Delhi, India
Data Analyst/Engineer with a consulting background and experience delivering cloud-based data solutions for healthcare and analytics use cases. Skilled in designing scalable ETL pipelines, data modeling, data quality frameworks, and modern data platforms using SQL, Python/Pyspark, Tableau and Snowflake. I enjoy partnering with business and technical stakeholders to transform complex data into actionable insights, improve operational efficiency, and enable data-driven decision-making. My experience includes building automated monitoring solutions, reusable ETL frameworks, and scalable data pipelines that enhance data reliability and accelerate data onboarding. Core Skills: • Azure Databricks • SQL • Tableau/PBI • Python/PySpark • Snowflake • ETL/ELT Development • Data Quality • Healthcare Analytics
Designed and deployed a python-based monitoring and alerting framework for ADLS-to-Snowflake pipelines (~25 daily feeds), proactively detecting 3-5 missing inputs per run via Slack/email alerts, and implemented feed-level tracking (last received / never received) to enhance data visibility and accelerate issue resolutions.
Automated tableau PIPO (Port IN/OUT) email report to be sent automatically every 15 minutes from tableau server during business hours to track customer churn, helped control churn by 5-7%.
Led a 3–5 member tableau Visualization CoE team, created various complex interactive dashboard for multiple B2B clients.
- Part of Tableau CoE team, created various complex interactive dashboard for multiple B2B clients. Visualized data using Tableau & python libraries like Bar , Line & Scatter plot. - Lead team of Intern, junior and senior analyst to ramp up them in McKinsey solutions and tools. - Created multiple Excel VBA utilities, which helped client and team-mates to do recurring work in short time and without any error. - Deployed multiple Deal Advisor and Price Advisor solution on/off-premises to help client improve their pricing module. - Created multiple data pipelines using Python to receive data from SAP through SFTP and upload price conditions in SAP through SAP.
- Part of a automation team, specialized in optimization and automation the business process with the help of VBA(Visual Basic for application). - Handling team of 300 people for automation of manual process of financial processes. - Created daily utilities that helped client & team saved 10000 hours in an year, which helped the team to get more work and generate the revenue. - Web Crawling using IE application/xmlHttp. - Automating allocation of daily work using Outlook VBA. - Provide training to new joiners and ramp up them to the project and tools