AAYUSH MANI TRIPATHI profile photo 1 on Tal

AAYUSH MANI TRIPATHI

Assistant Manager- Data & ML Engineering | Fabric | Power BI | Tableau | SQL | Alteryx | Python | JIRA | Azure | GCP | AWS | SAP | Databricks | Qlik | PSM I | 7x MS Cert. | CFPM | 👇Book a 1:1 (Views are Personal)

Greater Bengaluru Area

8+ years of work experience

Unilever
May 20266 mosPresent

Bengaluru, Karnataka, India

KPMG India
Apr 20242 yrs 2 mosMay 2026

Gurugram, Haryana, India

Key Responsibilities: Project 1: Data Migration & Analytics • Led data migration and analytics across multiple systems, enhancing reporting accuracy and efficiency. • Designed source-to-target mapping sheets, transformation rules, and data lineage. • Collaborated with cross-functional teams in Agile to gather requirements, define KPIs, and deliver technical solutions. • Created BRD/FRD documents, process maps, and data flow diagrams for stakeholder alignment. • Supported sprint planning, backlog refinement, and UAT for accurate analytics delivery. • Built and optimized SQL scripts for ETL, validation, and reconciliation of large datasets. • Developed 50+ Power BI dashboards with advanced DAX, dynamic KPIs, and interactive visuals. • Automated 90% of manual reporting, improving accuracy by 95% and reducing delivery time. • Managed ETL pipelines with Alteryx, Fabric Dataflow Gen2, and Pipelines, cutting refresh time by 80%. • Used Python for complex transformations, validation, and performance tuning. • Integrated Power BI with Fabric Dataflows for real-time analytics. • Automated workflows via Power Automate, saving 40+ hours/month, and built Power Apps forms, improving efficiency by 75%. Project 2: Azure Data Lakehouse & Analytics (SAP S/4HANA Integration) • Led development of Databricks notebooks for transformations, performance tuning, and Delta Lake optimization. • Managed Azure Data Factory pipelines, reducing failures by 50%. • Designed fact–dimension models in Azure Synapse for finance, procurement, and supply chain analytics. • Integrated SAP S/4HANA tables into Azure for ETL and BI, improving data availability. • Implemented CI/CD in Azure DevOps, cutting deployment time to under 20 minutes. • Coordinated batch and near real-time ingestion from APIs, SAP, SQL, and flat files, handling 1TB+ daily data.
KPMG India
May 20221 yr 11 mosMar 2024

Gurugram, Haryana, India

Key Responsibilities: • Played a pivotal role as a Business Analyst and Power BI Developer in a report automation project leveraging Azure services. • Conducted comprehensive requirements gathering sessions to understand stakeholders' needs and translated them into technical requirements. • Collaborated closely with IT teams to design and implement data automation strategies, ensuring compatibility with Azure services. • Utilized Power BI to analyze existing data structures and identify opportunities for optimization and enhancement. • Developed data mapping documents to facilitate the automation from legacy systems to Azure-based solutions. • Implemented Azure Data Factory pipelines to automate the extraction, transformation, and loading (ETL) processes. • Created and executed test plans to validate data accuracy and integrity post-migration. • Worked closely with stakeholders to address any data quality issues and ensure smooth migration outcomes. • Provided training and support to end-users on accessing and utilizing data in the Azure environment. • Generated reports and dashboards using Power BI to visualize the data insights. • Collaborated with Azure architects and engineers to troubleshoot and resolve any technical issues encountered during the migration process. • Successfully completed the report rationalization of sales business by identifying the unique and key KPIs standardizing the reporting format and deploying the reports to Power BI from various data sources. After this, sales data reports and dashboard count are reduced by 77.3%. • Created data visualizations using Power BI to provide insights and recommendations to stakeholders. • Post Report Rationalization and Deployment achieved the KPI Automation of 69.4 %. • Documented migration processes, best practices, and lessons learned for future reference and continuous improvement.
Allianz Technology
Sep 20201 yr 9 mosMay 2022

Pune City, Maharashtra, India

Allianz is one of the biggest multinational financial services company. Allianz Technology is a Group Company of Allianz for delivering IT solutions. Key Responsibilities: • Worked on the implementation of a Policy Administration System (Allianz Business System) for the ABS Sahara Project (Allianz Africa). ABS is an Insurance product used by Allianz Major European countries. The scope of the project is to customize the ABS for Africa's OEs. • Involved in the deployment of ABS core application to Africa OE'S with the needed customization. • Closely worked in the development of a Customer portal using core functionalities & legal customization based on the requirement for creating policy in real-time. •Handled, Designed solutions, and Delivered complex requirements related to different scenarios for the ABS Sahara Project. • Created Data Mapping Sheets for various Insurance Output Documents like Policy Documents, Debit Notes, and Insurance Certificates. • Played a key role in the successful implementation of Core Upgrade 20.5 in the ABS Sahara Project. • Collaborated with stakeholders for business and functional requirements elicitation and validation. • Documented and analyzed the requirements. • Acted as a liaison among stakeholders for clarifications and updates. • Created and reviewed the Test Scenarios, Test Cases, and Test Reports. Performed UAT and Ad-Hoc testing to ensure the system’s behavior was as per the client’s need. Provided demo to the stakeholder teams on the product releases. • Independently handled client calls for requirement gathering, understanding business problems, and then translating the same to business solutions • Coordinated with the client throughout the project life cycle over calls/emails for intermediate reviews, scope changes, and gathering feedback. • Translation of stakeholder requirements into user stories and visualize the data to create impactful dashboards.
YES IT Labs LLC (Top Guru Assistants)
Jul 20191 yr 3 mosSep 2020

Noida, Uttar Pradesh, India

Role : • Gathering functional requirements from users & preparing Business Proposals and Business Requirement Documents (BRD). • Identifying & mitigating project risks by identifying solutions & deploying resolutions. • Facilitating design sessions with the implementation team to define the solution and using Balsamiq 2.0 for creating Wireframes. • Formulating project stakeholder reports and project financials in terms of progress, cost, payments & variance. • Conducting UAT for better implementation and sign-off from stakeholders. • Reviewing, approving & managing change requests. • Facilitating functional support to users.
Career Break
Apr 20181 yr 3 mosJun 2019

New Delhi, Delhi, India

Prepared for GATE Examination.

AAYUSH’s AI Stack

Guardrails AI
Guardrails AI
Mistral Vibe
Mistral Vibe
Napkin AI
Napkin AI

Education

Dr. A.P.J. Abdul Kalam Technical University

Bachelor of Technology, Electronics and Instrumentation Engineering

Dr. A.P.J. Abdul Kalam Technical University

20144 yrs2018
Central Board of Secondary Education

Central Board of Secondary Education

200112 yrs2013

Join AAYUSH and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

AAYUSH MANI TRIPATHI on Tal

Headline

Assistant Manager- Data & ML Engineering | Fabric | Power BI | Tableau | SQL | Alteryx | Python | JIRA | Azure | GCP | AWS | SAP | Databricks | Qlik | PSM I | 7x MS Cert. | CFPM | 👇Book a 1:1 (Views are Personal)

About

Data & Analytics professional with 7+ years of experience across Business Analysis, Data Analytics, Consulting, and Data Engineering. My career journey spans from gathering business requirements and managing Agile delivery at YES IT Labs, to driving data migration and analytics initiatives at Allianz, architecting enterprise-scale data platforms at KPMG, and currently leading SAP-to-cloud data transformation programs at Unilever. I specialize in Microsoft Fabric, Azure Databricks, PySpark, Power BI, Tableau, Qlik, SQL, Python, Alteryx, SAP ECC/BW/S4HANA, and Azure Data Factory. I have delivered large-scale SAP modernization, lakehouse implementations, enterprise reporting solutions, data governance frameworks, and self-service analytics platforms across Finance, Supply Chain, and Master Data domains. Passionate about bridging the gap between business and technology, I enjoy transforming complex data challenges into scalable solutions that drive measurable business outcomes. Microsoft Certified (DP800, DP 700, DP-203, DP-600, PL-300,DP-900, AZ-900) | PSM I | Certified Financial Project Manager

Location

Greater Bengaluru Area

AI stack

Guardrails AI

Mistral Vibe

Napkin AI

Work experience

Senior Data and ML Engineer at Unilever, May 2026 - Present · 6 mos, Bengaluru, Karnataka, India

Consultant at KPMG India, Apr 2024 - May 2026 · 2 yrs 2 mos, Gurugram, Haryana, India, Key Responsibilities: Project 1: Data Migration & Analytics • Led data migration and analytics across multiple systems, enhancing reporting accuracy and efficiency. • Designed source-to-target mapping sheets, transformation rules, and data lineage. • Collaborated with cross-functional teams in Agile to gather requirements, define KPIs, and deliver technical solutions. • Created BRD/FRD documents, process maps, and data flow diagrams for stakeholder alignment. • Supported sprint planning, backlog refinement, and UAT for accurate analytics delivery. • Built and optimized SQL scripts for ETL, validation, and reconciliation of large datasets. • Developed 50+ Power BI dashboards with advanced DAX, dynamic KPIs, and interactive visuals. • Automated 90% of manual reporting, improving accuracy by 95% and reducing delivery time. • Managed ETL pipelines with Alteryx, Fabric Dataflow Gen2, and Pipelines, cutting refresh time by 80%. • Used Python for complex transformations, validation, and performance tuning. • Integrated Power BI with Fabric Dataflows for real-time analytics. • Automated workflows via Power Automate, saving 40+ hours/month, and built Power Apps forms, improving efficiency by 75%. Project 2: Azure Data Lakehouse & Analytics (SAP S/4HANA Integration) • Led development of Databricks notebooks for transformations, performance tuning, and Delta Lake optimization. • Managed Azure Data Factory pipelines, reducing failures by 50%. • Designed fact–dimension models in Azure Synapse for finance, procurement, and supply chain analytics. • Integrated SAP S/4HANA tables into Azure for ETL and BI, improving data availability. • Implemented CI/CD in Azure DevOps, cutting deployment time to under 20 minutes. • Coordinated batch and near real-time ingestion from APIs, SAP, SQL, and flat files, handling 1TB+ daily data.

Associate Consultant at KPMG India, May 2022 - Mar 2024 · 1 yr 11 mos, Gurugram, Haryana, India, Key Responsibilities: • Played a pivotal role as a Business Analyst and Power BI Developer in a report automation project leveraging Azure services. • Conducted comprehensive requirements gathering sessions to understand stakeholders' needs and translated them into technical requirements. • Collaborated closely with IT teams to design and implement data automation strategies, ensuring compatibility with Azure services. • Utilized Power BI to analyze existing data structures and identify opportunities for optimization and enhancement. • Developed data mapping documents to facilitate the automation from legacy systems to Azure-based solutions. • Implemented Azure Data Factory pipelines to automate the extraction, transformation, and loading (ETL) processes. • Created and executed test plans to validate data accuracy and integrity post-migration. • Worked closely with stakeholders to address any data quality issues and ensure smooth migration outcomes. • Provided training and support to end-users on accessing and utilizing data in the Azure environment. • Generated reports and dashboards using Power BI to visualize the data insights. • Collaborated with Azure architects and engineers to troubleshoot and resolve any technical issues encountered during the migration process. • Successfully completed the report rationalization of sales business by identifying the unique and key KPIs standardizing the reporting format and deploying the reports to Power BI from various data sources. After this, sales data reports and dashboard count are reduced by 77.3%. • Created data visualizations using Power BI to provide insights and recommendations to stakeholders. • Post Report Rationalization and Deployment achieved the KPI Automation of 69.4 %. • Documented migration processes, best practices, and lessons learned for future reference and continuous improvement.

Business Analyst at Allianz Technology, Sep 2020 - May 2022 · 1 yr 9 mos, Pune City, Maharashtra, India, Allianz is one of the biggest multinational financial services company. Allianz Technology is a Group Company of Allianz for delivering IT solutions. Key Responsibilities: • Worked on the implementation of a Policy Administration System (Allianz Business System) for the ABS Sahara Project (Allianz Africa). ABS is an Insurance product used by Allianz Major European countries. The scope of the project is to customize the ABS for Africa's OEs. • Involved in the deployment of ABS core application to Africa OE'S with the needed customization. • Closely worked in the development of a Customer portal using core functionalities & legal customization based on the requirement for creating policy in real-time. •Handled, Designed solutions, and Delivered complex requirements related to different scenarios for the ABS Sahara Project. • Created Data Mapping Sheets for various Insurance Output Documents like Policy Documents, Debit Notes, and Insurance Certificates. • Played a key role in the successful implementation of Core Upgrade 20.5 in the ABS Sahara Project. • Collaborated with stakeholders for business and functional requirements elicitation and validation. • Documented and analyzed the requirements. • Acted as a liaison among stakeholders for clarifications and updates. • Created and reviewed the Test Scenarios, Test Cases, and Test Reports. Performed UAT and Ad-Hoc testing to ensure the system’s behavior was as per the client’s need. Provided demo to the stakeholder teams on the product releases. • Independently handled client calls for requirement gathering, understanding business problems, and then translating the same to business solutions • Coordinated with the client throughout the project life cycle over calls/emails for intermediate reviews, scope changes, and gathering feedback. • Translation of stakeholder requirements into user stories and visualize the data to create impactful dashboards.

Business Analyst at YES IT Labs LLC (Top Guru Assistants), Jul 2019 - Sep 2020 · 1 yr 3 mos, Noida, Uttar Pradesh, India, Role : • Gathering functional requirements from users & preparing Business Proposals and Business Requirement Documents (BRD). • Identifying & mitigating project risks by identifying solutions & deploying resolutions. • Facilitating design sessions with the implementation team to define the solution and using Balsamiq 2.0 for creating Wireframes. • Formulating project stakeholder reports and project financials in terms of progress, cost, payments & variance. • Conducting UAT for better implementation and sign-off from stakeholders. • Reviewing, approving & managing change requests. • Facilitating functional support to users.

Personal goal pursuit at Career Break, Apr 2018 - Jun 2019 · 1 yr 3 mos, New Delhi, Delhi, India, Prepared for GATE Examination.

Education

Bachelor of Technology, Electronics and Instrumentation Engineering, Dr. A.P.J. Abdul Kalam Technical University

Central Board of Secondary Education