Shaik Mohammed
Data Analyst
Bengaluru
Summary
Having over 5+ years of Experience in Data Analytic at Go Digit General Insurance Ltd, specializing in Advance excel and Power BI. Proven track record in automating reports and enhancing data visualization, fostering cross-functional collaboration, and delivering actionable insights. Strong analytical thinking and leadership skills drive continuous improvement in data management and reporting processes.
Overview
6
6
years of professional experience
Work History
Data Analyst
Go Digit General Insurance Ltd
03.2023 - Current
- Having 5+ years of experience in Advance Excel and Power BI for developing and maintained database systems for efficient data management and reporting.
- Prepared dataset on Power query editor & excel using some advance functions such as pivot table, Vlookup, Xlookup, Logical function, aggregate function, slicer, Sum if etc.
- Automated reports in Cognos and circulated them on a daily, weekly, and monthly basis.
- Delivered accurate reports on time to assist management in making informed decisions based on data analysis.
- Handled end-to-end projects like Convex, Digit Disk developments, Digit Meet, and MIS automation in collaboration with IT & Development teams.
- Conducted training sessions on Advance excel, Power BI, MIS tools, Qlik, and data analysis techniques, empowering staff to leverage data effectively.
- Defined and monitored KPIs for departments; provided performance feedback to zonal heads and assignees, driving continuous improvement.
- Fostered cross-functional collaboration by sharing insights and dashboards, enabling teams to tackle complex challenges collectively.
- Involved in meetings understanding the requirement, streamlining processes and developing dynamic dashboards.
- Exposure to gathering requirements and performing adhoc analysis by writing sql queries using SQL joins, Views, Analytical functions, Aggregate functions, Subqueries to perform analysis on large dataset.
- Collaborated with the AI team to construct agents to reduce workload performance for the operation of claims and understanding the claims.
- Leveraged SQL to query and analyze extensive non-motor performance reports on a daily basis, tracking claim settlements, outstanding claims, and pending cases with TAT’s, Amt banding wise, LOB, Zone etc.
Data Analyst
Genpact India Private Limited
06.2020 - 03.2023
- Having good Experience in Created and maintained reports and dashboards using Microsoft Excel and Power BI.
- Attended buisness requirement meetings with Buisness analyst to understand the process flow and requirement behind BRD's.
- Developed various dashboards for different banking products such as Credit card, loan, Income Statement, Balance sheet in power BI.
- Expertise in creating dashboards, with some advance visualization like waterfall chart, Gantts, Scatter Plots, Histograms etc. with using parameters, drill-down, drill up, custom tooltips & bookmark in report.
- Created and optimized Dashboard and Dax queries to generate calculated columns and measures by using some advance DAX functions & applied various calculations including Custom Aggregations, Custom Calculated Fields, and conditional calculations etc in query editor.
- Experienced on publishing Power BI reports in service and scheduling the dataset to refresh for upcoming data in power BI server.
- Experienced in doing RCA, requirement analysis and writing design document.
- Experienced in written queries to fetch data from SQL.
Education
Bachelor of Science - Mechanical Engineering
Jawaharlal Nehru Technological University, Anantapur (SVTM).
Madanapalle, India 04.2001 -
Skills
Technical:
Power BI, Power BI Service, Advanced Excel, DAX, Pivot Table, Vlookup, Pivot tables, Textjoin, Power Query Editor, ETL, PostgreSQL Server, SharePoint, Google Sheets, PowerPoint
Data Expertise:
Data Analysis, Data Modeling, Data Visualization, Data Validation & Profiling, Data Warehousing, Exploratory & Prescriptive Analysis, Preparing BRD & CR etc
Soft Skills:
leadership, Analytical thinking, strategic problem-solving, debugging, troubleshooting, communication, interpersonal skills
Additional Information
Achievements
· Received Wall of Awesomeness and Best Performer awards for outstanding efforts in 2023and 2025.
Timeline
Data Analyst
Go Digit General Insurance Ltd
03.2023 - Current
Data Analyst
Genpact India Private Limited
06.2020 - 03.2023
Bachelor of Science - Mechanical Engineering
Jawaharlal Nehru Technological University, Anantapur (SVTM).
04.2001 -