Parth Kalbag
Mumbai
Summary
I am an experienced data solutions professional with a strong background in turning business requirements into practical, high-impact data products. I've worked closely with business and technical teams to design database structures, automate data flows, and ensure data accuracy across multiple dashboards. My expertise includes integrating REST APIs with tools like Informatica Cloud Application Integration (CAI) and Immuta (access management) to streamline data management, enforce security, and keep data catalogs up to date. I have built insightful Power BI dashboards that help organizations monitor key metrics, improve data quality, and support compliance needs. I'm also passionate about process improvement—having automated and standardized testing for complex data systems, which reduced QA efforts and improved validation consistency. My approach combines technical know-how with a focus on collaboration and delivering solutions that align with business goals.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Analyst
Deloitte Consulting India Private Limited
01.2023 - Current
- Requirements Analysis: Collaborated with cross-functional business teams to elicit and analyze requirements for multiple KPIs, translating business needs into actionable data solutions. Designed and structured database tables for dashboards and implemented REST API-driven automation to populate and maintain these tables across multiple dashboards, ensuring data accuracy and alignment with business objectives.
- REST API Integration and Catalog Management: Implemented REST API-based automation using Informatica Cloud Application Integration (CAI) to streamline the approval and rejection of orders placed within the Data Marketplace. Developed and refined processes to monitor and track changes within the database, including the addition of new tables, new columns within existing tables, and updating the catalog accordingly. Implemented row and column-level data restrictions using Immuta to ensure seamless compliance. Developed REST API-based automation to seamlessly register datasets from the Informatica marketplace into Immuta.
- Dashboard development: Developed dashboard in Power BI to track different metrics for multiple objects including data quality scores, total rows processed for the object and displaying the failed records in a table view. Also developed quality & compliance metrics dashboard to support regulatory and business needs and developed dashboard to identify data mismatches, missing records, duplicate records, records with mapping errors between complex systems, enhancing data integrity and reconciliation processes. Developed and enhanced Power BI dashboards to monitor KPIs related to End User Utilizations for different datasets within Informatica Marketplace, Data Usage for the datasets with POV on data collections/datasets and the User Coverage Maps with POV on individual users.
- Testing & Automation: Executed over 400+ SIT test cases in qTest for over 20+ database tables and 4+ dashboards. Developed an automated system to replicate source data, streamline test case execution, and generate validation evidence for approximately 50% of cases. This initiative standardized validation and reduced QA efforts by ~20%.
Education
B.E - Information Technology
University of Mumbai
07-2022
Skills
- Languages: Python, SQL
- ETL Tool: Informatica IDMC, Informatica CDGC, Informatica CAI, Informatica CDMP
- Visualization Tool: Power BI
- Databases: Redshift, SQL Server
References
- Sidhya, Ghatak, Associate Director, sighatak@deloitte.com, Deloitte India
- Nutan, Naik, Senior Consultant, nchandrashekharna@deloitte.com, Deloitte USI
Certification
Informatica Cloud Application Integration R42, Professional Certification
Languages
English, Hindi, Marathi, Konkani
Timeline
Analyst
Deloitte Consulting India Private Limited
01.2023 - Current
B.E - Information Technology
University of Mumbai
Similar Profiles
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)
Gowtham BGowtham B
BA & QA Test Analyst at Deloitte Consulting India Private Limited | Bengaluru, IndiaBA & QA Test Analyst at Deloitte Consulting India Private Limited | Bengaluru, India
Jayita BhattacharyaJayita Bhattacharya
Consultant at Deloitte Consulting India Private LimitedConsultant at Deloitte Consulting India Private Limited
Mansi BajajMansi Bajaj
Senior Associate - Market and Consumer Insights at Orion InnovationSenior Associate - Market and Consumer Insights at Orion Innovation
Prachi PathratkarPrachi Pathratkar
Accounts Intern at Rahul URS & COAccounts Intern at Rahul URS & CO