Ayush Kapoor

• Optimized and Troubleshot SQL Code: Developed and optimized complex SQL queries and stored
  procedures in MS-SQL, streamlining workflows for administrative processes.
• Investigated Data Anomalies: Investigated and resolved data anomalies by conducting root cause analysis using Excel, Tableau, and Azure Data Factory, significantly improving data integrity.
• Constructed BI Data Models: Designed and implemented BI data models, integrating datasets across sources to create Tableau dashboards that enhanced decision-making.
• Implemented Data Transformation Best Practices: Applied data cleansing, normalization, and
  transformation techniques in ETL workflows using Azure Data Factory and Python, ensuring consistency
  and high-quality data solutions.
• Documented Functional and Technical Requirements: Collaborated with IT and data departments to elicit
  and document user requirements for enhancing data tools and workflows, ensuring comprehensive functional and technical documentation for non-technical stakeholders.
• Facilitated Technical Training and Workshops: Organized and conducted data workshops and departmental meetings, training staff on tools such as Tableau, Azure Synapse, and Excel, enhancing their data visualization and analysis skills.
• Streamlined Data Governance: Performed quality checks on student datasets and implemented data
  governance best practices, ensuring data dependability and compliance with university standards.

Business Analytics

• Process Optimization and Revenue Growth: Implemented hybrid software development procedures at Procter & Gamble, generating $3M in revenue.
• Project Management: Successfully completed BMS projects on schedule and within budget, contributing to the success of the Financial Platform Transformation Program (FPT).
• Leadership: Led a team of 20 to provide high-quality technical components on schedule and within budget.
• Client Engagement: Improved client adoption from 8.8/10 to 9.8/10 by creating interactive dashboards that demonstrated value to end users.
• Problem-Solving: Simplified project workflows using JIRA to structure requirements into epics and stories, resulting in 40% fewer application problems and the development of actionable BI tools.
• Data Visualization: Developed interactive dashboards in Tableau, enabling leadership to make real-time, data-driven decisions and improving visibility into sales and customer satisfaction.
• Global Collaboration: Partnered with global teams to address key business challenges, enhancing operational efficiency for top consumer products.

Data Engineering

• ETL Development and Data Integration: Designed and implemented complex ETL pipelines with Azure Data Factory and Databricks, ensuring high-quality data ingestion, transformation, and storage for scalable and efficient data solutions.
• Query Optimization/Performance Tuning: Optimized complex Transact-SQL and PL/SQL queries, resolving inefficiencies and significantly reducing query execution time across large datasets.
• Root Cause Analysis: Conducted root cause analysis to identify and resolve data anomalies in ETL workflows, utilizing tools like Tableau, Excel, and Databricks, ensuring data accuracy and integrity.
• Business Intelligence: Developed complex data models for BI solutions, integrating Delta Lake tables with Tableau to provide interactive dashboards and actionable insights.
• Quality Assurance: Applied data cleansing and normalization best practices, ensuring consistency across diverse datasets and improving data quality for real-time analytics.
• Modularization: Utilized PySpark to modularize transformations and simplify ETL workflows, enabling seamless scalability.
• Data Warehousing: Partnered with global teams to implement Azure Synapse Analytics for building robust data warehouses, achieving a significant improvement in query performance and operational efficiency.
• Process Automation: Automated data validation processes, reducing manual intervention substantially and improving the dependability of critical data pipelines.
• Training and Knowledge Sharing: Led workshops on advanced SQL techniques and ETL pipeline best practices, enhancing team capabilities in resolving data issues and ensuring project success.