Nitin Kavalgi

Senior Business Analyst | ETL Developer

Project: Resource Planning & Financial Intelligence Modernization

• Designed and deployed a Weekly Financial Performance Report covering 110+ global projects/shows, tracking 5 critical KPIs—Gross Margin , Revenue, India VFX Contribution, Days Change, and Gross Margin Change—enabling leadership to monitor financial health in near real-time.
• Acted as a liaison between finance and data teams to translate business requirements into precise data definitions, reducing manual effort by 60% and significantly improving reporting accuracy and turnaround time.
• Defined, documented, and automated 70+ key financial metrics—including All KPIs—by implementing logic directly in the ETL transformation layer and ready to consume by Power BI. enabling early risk detection and corrective action.
• Reduced ADF pipeline runtime by 66% (3 hrs to less than 1 hr) through stored procedure optimization, enabling the pipeline to run three times daily across global time zones, ensuring fresher, zone-specific data visibility for stakeholders.
• Cut daily ADF pipeline costs by 90% (INR 10,000 to INR 1,000/day) by optimizing trigger logic, reducing unnecessary parallel runs, and enhancing data load efficiency, leading to significant cloud spend savings.
• Eliminated dependency on legacy Project Online system by engineering new ADF pipelines and stored procedures that directly extract project and crew data from SharePoint lists, modernizing the backend of a global Resource Planning Tool used by 8,000+ artists and DPMs for crew allocation and tracking.

• Modernization Project as a Data Engineer and Business Analyst.
• Lead a backend Data team to successfully migrate Chevron's key application from Oracle (Oracle Data Integrator and Oracle Database) to Azure (Azure Synapse Analytics and Azure SQL DB).
• Collaborated with stakeholders to analyze business needs, define functional requirements, and document data mapping rules for seamless transition to Azure platform. Crafted a detailed roadmap encompassing analysis of existing application structure and deployment milestones, all while navigating challenges posed by lack of documentation.
• Drove a 50% increase in team productivity by analyzing the existing oracle application, business data, and dataflow. Working closely with other team members to identity the solutions and Developed and implemented solutions utilizing Azure Synapse Analytics pipelines as well as Azure SQL database stored procedures despite joining the project one quarter late.
• Trained junior team members of quality standards and testing procedures.

• Data Source Migration and integration using Azure Data Factory
• Transitioned data source connection in a critical application from on-premises Oracle(WellView) to Azure DataLake Gen2(WellView Allez) through a successful data migration project.
• Utilized data analysis and strong SQL skills to convert more than 50 PL/SQL scripts into T-SQL scripts. Integrated these efficient solutions within two applications using Data Factory, completing all tasks within the designated timeframe.
• Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.