Hema Gupta

Background

About Hema Gupta

Built dynamic Power BI dashboards for Equipment KPIs, increasing data processing efficiency by 50% using DAX, Power Query, Dataflows, and Incremental Refresh. Created platform-wise KPIs and visualizations to monitor sales trends, product performance, and customer behavior. Designed and automated ETL/ELT pipelines using Matillion, DBT, and Python to move data from AWS S3 to Snowflake, ensuring data quality and performance. Implemented Dynamic Data Masking (DDM) in Snowflake for PII protection and role-based access control. Conducted data profiling, schema validation, and duplicate checks using SQL and Hive to maintain data accuracy. Built File Iterator pipelines and reusable workflows, improving ingestion flexibility and reducing maintenance effort. Collaborated with stakeholders to gather requirements and align analytics with business goals. Documented technical specifications and translated complex business needs into actionable data strategies. Certifications and Achievements: • Agile Fundamentals – Scrum & Kanban (Udemy) • Summer Training on Python – NIELIT Chandigarh • Xcelerate Warrior Certificate – TCS • Service & Commitment Award – TCS • Workshops on Android, Ethical Hacking, and Personality Development Key Skills: Power BI | Snowflake | SQL | Python | Alteryx | Matillion | AWS S3 | Agile | Git | Jira | Pyspark | Confluence | Communication | Data Modeling | Problem Solving | Collaboration With a passion for turning raw data into business value, I aim to keep learning and solving real-world problems through analytics. Let’s connect!