AAYUSH MANI TRIPATHI 🇮🇳

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.

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 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.

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.

Designation:- Intern Department:- Business Development Unit:- Sales Role:- Generating revenue for the team through educational consulting and by closing sales deals either over the phone or face to face.

College:- United College of Engineering and Research Allahabad

School: 1. Air Force School, Gorakhpur (Class I to V) 2. Air Force School Bamrauli, Allahabad (Class VI to XII)