Shreya Raghuvanshi

Data Analyst

Mumbai, India 3+ yrs exp 86 · Excellent

About

Data Analyst with 3+ years of experience in SQL development, data analysis, ETL pipelines, business intelligence reporting, finance, insurance and regulatory compliance domain. Proven expertise in SQL, Python, Power BI, and data pipeline optimization across PostgreSQL, MySQL, and SQL Server environments. Experienced in data modelling, query optimization, data quality validation, and building scalable reporting solutions to support business and regulatory reporting. Strong background in data engineering practices, cloud infrastructure (AWS and Azure), and Agile delivery environments.

Skills & Expertise (47)

SQL Advanced

8.4/10

Years Exp

Python Advanced

8.1/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Pandas Advanced

7.8/10

Years Exp

ETL Advanced

7.6/10

Years Exp

Data Transformation Advanced

7.5/10

Years Exp

NumPy Advanced

7.5/10

Years Exp

Data Warehousing Advanced

7.4/10

Years Exp

AWS Advanced

7.2/10

Years Exp

Data Quality Management Advanced

7.0/10

Years Exp

Data Governance Advanced

6.8/10

Years Exp

Kubernetes Intermediate

6.5/10

Years Exp

Docker Intermediate

6.5/10

Years Exp

Azure LINUX Git Jenkins Stored Procedures Agile Lambda DevOps S3 EC2 Jira Confluence Microsoft Fabric Indexing Normalization Databricks Microsoft SQL Server Oracle Postgresql Tableau SSRS Advanced Excel Pivot Tables VLOOKUP Macros Performance Tuning DAX SSIS Data Pipelines Data Modelling Schema Design Data Validation Query Optimization MySql

Work Experience

IT Consultant

The Brow Bar

Mar 2026 - Sep 2026

Supported day-to-day IT operations, data reporting and digital systems, ensuring accurate and reliable information for business and operational activities. Analysed sales, customer and operational data using Excel and SQL-based reporting techniques to identify trends, monitor KPIs and support business decisions. Created and maintained Excel reports and dashboards, using Power BI, Pivot Tables, VLOOKUP and data validation to track revenue, appointments, customer activity and operational performance. Performed data cleaning, validation and reconciliation across business records, identifying inconsistencies and improving data accuracy. Assisted with cloud and DevOps-related activities, including basic AWS/Azure administration, Git-based version control, deployment support and monitoring of applications/services. Supported CI/CD workflows and system monitoring, helping identify deployment issues, review logs and maintain reliable application environments.

Data Integration and Operations Analyst

AQMetrics Ltd. Ireland

Sep 2025 - Mar 2026

Managed and maintained SQL-based data pipelines and ETL workflows supporting regulatory and operational reporting within a SaaS financial compliance platform, improving data processing reliability. Designed and optimized complex SQL queries (CTEs, joins, window functions) across PostgreSQL and MySQL, reducing report execution time by 25–35%. Developed data ingestion and transformation processes for structured and semi-structured datasets, improving data integration efficiency by 30%. Implemented data validation and reconciliation checks across multiple data sources, reducing reporting errors and data inconsistencies. Investigated and resolved data pipeline failures, data discrepancies, and production data issues, improving reporting reliability and reducing incidents by 25%. Contributed to database schema design, indexing, and query optimization, improving database performance and reporting efficiency by 20%. Automated data extraction and reporting workflows, reducing manual data processing and operational workload by 20%.

Consultant

MindCraft Software Pvt. Ltd. (Client: Aditya Birla Insurance Brokers)

Aug 2021 - Sep 2023

Utilized Business Intelligence tools such as SSIS, SSRS, MSSQL, Excel and PowerBI resulting in a 25% increase in overall project efficiency. Generated over 50 Power BI and SSRS reports for clients, enabling them to derive meaningful and actionable insights, leading to a 20% improvement in client decision-making efficiency. Designed and developed ETL (Extract, Transform, Load) packages to import, transform, and load data from diverse sources into MSSQL Server, resulting in a 30% reduction in data processing time. Employed Python (pandas, NumPy, matplotlib) to clean and analyze large datasets, reducing manual work by 40% and uncovering trends in inventory, production, and resource utilization. Optimized complex stored procedures and queries, reducing runtime by 40% and improving overall database performance. Analyzed and resolved over 50 report errors through thorough report validation, improving report accuracy by 35%. Developed and managed SQL-based reports for data analysis and decision support, improving report accuracy by 15% and reducing generation time by 25%. Managed cloud infrastructure on AWS, including EC2 instances and S3 buckets, reducing cloud operational costs by 15% and improving CI/CD pipeline efficiency by 20%. Led data analysis projects focused on ERP reporting, improving operational efficiency by 22% and reducing reporting errors by 25%.