Nawaz Ahmed
Chennai
Summary
With over 15 years of experience in the IT industry, honed skills in Business Analysis and Data Analysis for more than a decade. Expertise lies in conducting thorough data analysis and creating interactive dashboards using Tableau, SQL, and R programming. Proven track record of leading cross-functional teams to develop and implement scalable BI strategies that enhance decision-making processes and improve operational efficiency.
Overview
17
17
years of professional experience
Work History
Business and Data Analyst
Cholamandalam MS General Insurance Company
02.2015 - Current
- Automated Report Generation: Collaborated with cross functional teams to create automated reports:
- Requirement gathering from Claims teams to define dashboard specifications and ensure alignment with business needs.
- Created data models in R that accommodates multiple scenarios and conditions for Operations, Underwriting and Health Claims data, ensuring real-time insights with daily updates.
- Developed Operational Reports to Support Business Decision-Making:
- Replaced traditional manual Excel reports with a dynamic R-programmed approach. Developed a data model that eliminated manual data extraction from shared folders and Oracle databases. Consolidated multiple data sources into comprehensive final reports, providing product-wise and channel-wise policy numbers for daily, monthly, and yearly analysis.
- Revamped Ticketing Analysis:
- Developed a comprehensive reporting system for a ticketing tool that logs issues from various branches. The report categorized issues by severity levels (Severity 1, 2, and 3), providing resolution timelines and analysis. Ensured timely resolution by tracking how many Severity 1 issues were solved on the same day and how many took longer. Similar analysis was done for Severity 2 (within 8 hours) and Severity 3 (within 3 days) issues. Facilitated informed decision-making through weekly and monthly consolidated reports, driving improvements in service efficiency.
- Streamlined Application Support Process:
- Conducted comprehensive surveys across all company branches to gather feedback on application support performance, enabling the identification of key improvement areas. This initiative drove enhancements in productivity and working methods, further supported by introducing tailored response templates and a feedback system for continuous improvement.
- Elevating Audit Integrity: Data Model Enhances Process Accuracy and Efficiency:
- Facilitated the Audit team in quarterly data extraction, structuring unstructured datasets into an audit-friendly format. Developed reusable data models, ensuring efficient analysis of refreshed data each quarter, enhancing audit processes. Through the implementation of the data model, identified numerous discrepancies, leading to significant process improvements and enhanced compliance rigor.
- Reverse Engineering Analysis for Database Optimization:
- Streamlining Data Management for Innovative Product Development. Identified and documented the purpose and limitations of each column in a complex insurance database through close collaboration with development teams and underwriters. This reverse engineering effort enabled clearer understanding, easier maintenance, and efficient use of the table for future product development and project enhancements.
- Data Architect Synergy :
- Collaborated closely with data architects to design a robust data model and enhanced a comprehensive data dictionary. This streamlined the process by providing clear definitions, relationships, and constraints for data elements, ensuring consistency and facilitating efficient data management.
- Strategic Collaboration with External Stakeholders :
- Liaised between IIB professionals and internal underwriters to transition from manual data uploads to real-time API submissions. Conducted a comprehensive analysis of format changes, including the percentage of existing and new columns, to ensure smooth integration and data collection strategies.
- Developed and implemented interactive Tableau dashboards to support sales strategy decisions, tracking state-wise and region-wise sales performance and decision-making
- RPA Solutions: Transforming Legacy Process into Smart Workflows.
- Developed RPA solutions using UiPath to automate business processes. I worked closely with the core application team and RPA team to automate core application processes through UiPath. Collaborated with stakeholders to gather requirements and ensure that RPA solutions meet business needs and compliance standards.
Support Analyst
Iopex Technologies Pvt Ltd
12.2011 - 03.2013
- Company Overview: Project Details – Video Monetization with Ooyala, a US-based company that focused on video monetization and workflow management, serving clients such as ESPN and Bloomberg
- Oversee the identification of issues related to Java APIs and ensure thorough analysis to understand root causes
- Collaborate with team members to gather data and insights on recurring problems
- Work closely with Java developers to troubleshoot and resolve API-related issues, ensuring that solutions are implemented effectively
- Facilitate communication between technical teams and stakeholders to clarify requirements and expectations
- Regularly update stakeholders on the status of troubleshooting efforts, including any significant findings or delays
- Present findings and recommendations to management for strategic decision making
- Project Details – Video Monetization with Ooyala, a US-based company that focused on video monetization and workflow management, serving clients such as ESPN and Bloomberg
Business Analyst
M2i Software Solutions
01.2008 - 12.2011
- Company Overview: Project Details – Serve Smart 2.0
- As a Business Analyst, I coordinated client requirements and ensured alignment with business objectives for a restaurant billing software serving clients across India, Malaysia and Singapore
- Observe and analyze the process for any application issues
- Analyze changes recommended by the client side and communicate between department to implement the required changes
- Coordinate with development and testing team for bug fixing and UAT process
- Coordinate with development for fixing production issues
- Internal IT related analysis and reporting to senior management
- Project Details – Serve Smart 2.0
- As a Business Analyst, I coordinated client requirements and ensured alignment with business objectives for a restaurant billing software serving clients across India, Malaysia and Singapore
Education
B.E - Computer Science
Ghousia College of Engineering
Bangalore, KarnatakaPost Graduate Program - Business Analytics and Business Intelligence
Great Lakes Institute of Management
Skills
- Business Process Analysis
- Statistical Analysis
- Business Analytics
- Robotic Process Automation Integration
- Requirements Analysis
- Team Leadership
- Activity diagrams
- Trend analysis
- Data mapping
- Business management
- Data visualization and presentations
- Data quality
Tools And Platforms
R Studio (focused on data cleaning, mining, and data modelling), Toad for SQL, SQL Workbench, Redshift Query Editor, Oracle Database, Tableau Prep, Tableau Desktop, Draw.io (Free web-based diagramming tool for UML diagrams and flowcharts)
Timeline
Business and Data Analyst
Cholamandalam MS General Insurance Company
02.2015 - Current
Support Analyst
Iopex Technologies Pvt Ltd
12.2011 - 03.2013
Business Analyst
M2i Software Solutions
01.2008 - 12.2011
B.E - Computer Science
Ghousia College of Engineering
Post Graduate Program - Business Analytics and Business Intelligence
Great Lakes Institute of Management
Similar Profiles
Abiksha AshokAbiksha Ashok
Senior Executive at Cholamandalam MS General insurance CompanySenior Executive at Cholamandalam MS General insurance Company
Aas MohmadAas Mohmad
Area Sales Manager Retail Broking at Cholamandalam MS General Insurance CompanyArea Sales Manager Retail Broking at Cholamandalam MS General Insurance Company
SIVASUBRAMANIAN VSIVASUBRAMANIAN V
Chief Manager - Operations at M/s Cholamandalam MS General Insurance Company LtdChief Manager - Operations at M/s Cholamandalam MS General Insurance Company Ltd