About
Highly skilled Data Analyst with 3+ years of experience excelling in ETL pipeline development, data integration, and advanced analytics. Proven ability to design and optimize scalable data solutions, reducing processing times by up to 40% and improving data accuracy by 25%. Adept at leveraging SQL, Python, Power BI, and cloud platforms to deliver enterprise-grade reporting and drive data-driven decision-making.
Work
Bhopal, Madhya Pradesh, India
→
Summary
Spearheaded end-to-end ETL pipeline development and data analysis initiatives for the SiriusXM Enterprise project, enhancing data processing efficiency and reporting accuracy.
Highlights
Led the design and implementation of robust end-to-end ETL pipelines, optimizing workflows to reduce data processing time by 25% and cutting pipeline execution time by 40% through indexing, batch processing, and parallel loading.
Enhanced data accuracy by 25% and ensured data integrity for downstream teams by implementing Slowly Changing Dimensions (SCD) and resolving 95% of duplicates, null values, and datatype issues.
Designed and deployed automated error-catching routines and data validation flows, reducing pipeline failures by 90% and ensuring 99.9% accuracy of production data outputs.
Developed a tiered data archiving strategy that drove 30% storage cost savings and enabled 40% faster dashboard query performance by moving historical data into lower-cost storage.
Automated manual reporting workflows using SQL and Pentaho, decreasing monitoring effort by 30% and testing time by 60%, while creating 5+ interactive Power BI dashboards for KPI tracking and operational insights.
Partnered with 3+ cross-functional teams to gather requirements, define metrics, and deliver tailored analytics solutions, contributing to data-driven decision-making.
Performed root cause analysis (RCA) on 30+ complex data issues, collaborating with QA/Dev teams for User Acceptance Testing (UAT) to ensure high reliability of production data.
Bhopal, Madhya Pradesh, India
→
Summary
Supported ETL development and data validation efforts for enterprise projects, gaining foundational experience in data processing.
Highlights
Executed ETL processes using Pentaho PDI, contributing to data transformation and loading for enterprise projects.
Conducted data validation and testing for enterprise projects, ensuring data quality and reliability for downstream systems.
Awards
Team Award for Outstanding Performance
Awarded By
Netlink Software Group America Inc
Awarded as part of a team for exceptional collaboration and achievement on a key project.
Best Performer Award
Awarded By
Netlink Software Group America Inc
Recognized for outstanding individual performance and contributions to project success.
Languages
Hindi
Native
English
Fluent
Skills
ETL Tools
Pentaho PDI, Informatica.
Programming Languages
SQL (Advanced), Python (Basics).
Databases
PostgreSQL, SQL Server, MySQL, Vertica, Snowflake.
Cloud Platforms
AWS (S3, Redshift).
Data Concepts
ETL Development & Testing, SCD, Data Warehousing, OLTP/OLAP, Data Migration, Data Modeling, Metadata Validation.
Data Analysis
EDA, KPI Monitoring, Business Metrics, Requirement Gathering, RCA, UAT.
Reporting & Visualization
Power BI, Advanced Excel, Excel Dashboards.
Other Tools & Methodologies
Kubernetes, Agile, Stakeholder Communication.