Abhinav Sarma
Bengaluru
Summary
Analytical and detail-oriented Data Analyst with expertise in predictive modeling, statistical analysis, business analysis and ETL processes. Proven ability to collaborate with cross-functional teams to deliver actionable insights that drive strategic decision-making.
Overview
3
3
years of professional experience
Work History
Data Analyst
Deloitte USI
Bengaluru
09.2022 - Current
- Developed interactive Power BI dashboards by integrating data from multiple sources, enabling clear visualization and analysis of complex data sets.
- Managed and resolved production issues during the Hypercare period for data quality monitoring dashboards, ensuring seamless operation and reliable source data insights.
- Migrated over 100 Tableau reports from Oracle to PostgreSQL, performing technical and functional validation by analyzing stored procedures to ensure consistent and accurate report metrics.
- Performed data extraction, transformation, and loading processes using SQL.
- Conducted a comprehensive analysis to identify columns suitable for mastering data in MDM, leveraging data profiling techniques, and collaborating with business stakeholders to ensure optimal field selection.
- Performed ETL testing across raw, staging, and Master Data Management (MDM) layers, conducting comprehensive count and data validation checks to ensure data integrity and accuracy.
- Created training datasets to optimize generative AI models using prompt engineering, improving model output accuracy, and aligning solutions to specific client requirements.
- Collaborated with cross-functional teams to define project requirements and deliverables.
Education
Bachelor of Technology - Mechanical Engineering
National Institute of Technology (NIT) Silchar
Silchar05-2022
Skills
- Technical skills: predictive modeling, statistical analysis, data visualization, ETL testing, and prompt engineering
- Languages: SQL, C, Python (NumPy, Pandas, matplotlib, sklearn, etc) for ML
- IDEs: Jupyter Notebook, VS Code, Code::Blocks
- Data warehousing and database systems: Databricks, SQL Server Management Studio (SSMS), Oracle, PostgreSQL
- Data visualization: Power BI, Excel
- Other skills: PPT, Word, Jira, GIT
Projects:
Customer churn prediction using classification
Developed a customer churn prediction model for an online retail store using classification algorithms enhanced with a bagging ensemble technique, the model achieved an accuracy of 80%, with a precision of 0.78, and a recall of 0.82, indicating strong performance in correctly identifying customers likely to churn while maintaining a low rate of false positives
Timeline
Data Analyst
Deloitte USI
09.2022 - Current
Bachelor of Technology - Mechanical Engineering
National Institute of Technology (NIT) Silchar
Similar Profiles
GURUPRASATH KRGURUPRASATH KR
Senior Consultant at Deloitte USI Consulting - Deloitte DigitalSenior Consultant at Deloitte USI Consulting - Deloitte Digital
Akhtar KhanAkhtar Khan
DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)
SHRESTH ISHSHRESTH ISH
Advisory Intern at Deloitte USIAdvisory Intern at Deloitte USI
Rolwin D'CunhaRolwin D'Cunha
Senior Auditor at Deloitte USISenior Auditor at Deloitte USI
Ritu A. MullurRitu A. Mullur
Project Coordinator (PMO) at Persistent SystemsProject Coordinator (PMO) at Persistent Systems