Yash Gaikwad
Portfolio

Every business runs on data - but not every business knows how to connect it. At Capgemini, I was the glue between systems and insights. I created APIs that allowed data to move seamlessly, securely, and intelligently across platforms. Using MuleSoft and Oracle SQL, I designed backend systems that didn’t just function - they accelerated decision-making. From debugging integration failures at 2 AM to optimizing reporting pipelines under real-world pressure, I didn’t just write code - I made sure it delivered value where it counted: in production. At Capgemini, I was embedded within a leading banking client’s data analytics division, where I transformed data workflows and decision systems at scale. This role honed my ability to build scalable solutions in high-stakes, fast-paced environments, while ensuring data accuracy, performance, and business alignment.

My core contributions included:
- SQL Query Optimization: I restructured and fine-tuned SQL queries handling millions of transaction records—reducing execution time by 25% and vastly improving dashboard refresh rates.
- Power BI Dashboards: Built interactive, executive-level Power BI dashboards by integrating data from Oracle and API logs, leading to 20% faster strategic decisions and improved risk oversight.
- ETL & Data Transformation: Designed ETL pipelines to seamlessly convert raw financial data from MuleSoft APIs into reporting-ready datasets, reducing manual work by 30%.
- Data Validation Pipelines: Implemented SQL-based validation checks and anomaly detection logic, reducing errors in compliance reporting by 30%.
- Stakeholder Collaboration: Acted as the bridge between business stakeholders and engineering teams—gathering requirements, managing sprints via JIRA, and ensuring timely delivery of insights.
- API Integration: Collaborated with the API team to ensure real-time data flow into analytical systems, improving consistency and reducing mismatches across reports.