Infosys Technologies Ltd, 12/2008 to 04/2023 (14.4 Years), SAP Analytics Operations Support, One of the leading US pharmaceutical client, 04/2022 – Present, Onsite Lead Consultant US - SAP HANA & BI/BO Consultant, Managing SAP Analytics Operations team for day to day support activity which includes month end reporting closure, helping client with different SAP umbrella tools for warehousing and reporting lifecycle management, Data availability and Enhancements as per business requirements. Collaboration with Projects team and coordinating with business for roll out of sites and new applications., SAP Analytics Consulting and L3 support, Performance Tuning and optimization of SAP BW, BPC, BODS and BOE system, data flow and reporting., Respond to the analytical and reporting issues assigned and conduct analysis of the issues., Understanding Business reporting requirement and translate them to technical system change in SAP application., Business Impact analysis, Managing and Coordinating the Business requirements/ issue's work with Offshore team., Identifying problem areas and proposing and implementation of new solutions to the customer., SAP Analytics Operations Support, One of the leading US pharmaceutical client, 02/2021 – 04/2022, Offshore Team Lead - SAP HANA & BI/BO Consultant, Managing SAP Analytics Operations team for day to day support activity which includes month end reporting closure, helping client with different SAP umbrella tools for warehousing and reporting lifecycle. Daily scrum activity and offshore maintenance activity planning and execution., SAP HANA Data Modeler and Scrum Master, One of the leading US Retail client, 10/2019 – 02/2021, SAP HANA Data Modeler, Understand Data flow and business logic maintained in different warehouse server for Sales and Demand allocation for reverse engineering. Understand entity relationship for the data flow. Work with Architect and Intel business rule to model Data flow for HANA and get it approved for development. Work in multiple scrum team and manage business transformation program on implementation on HANA system. Creating Data Quality check views to compare data between new HANA flow and old flow and support business for UAT. Go-live of reports on HANA and hyper care support., SAP Analytics Production Enhancement/ Support, One of the leading US pharmaceutical client, 02/2016 - Present, Offshore Team Lead - SAP HANA & BI/BO Consultant, Support and enhancement for different SCM and Finance DS jobs, Universe and webi reports based on Business requirement. Migration of Management Sales reporting from traditional DS-WH-BO landscape to HANA-BO landscape. Development of Management Sales related views on HANA DB after data provisioning of SAP tables through SLT and then building of reports based on HANA Direct connection., Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements., Building HANA Attribute, Analytic and Calculation view., Implemented SLT transformations using SAP ABAP to Load real time data to SAP BW., Created webi reports on SAP HANA models using IDT universe, Created HANA views directly on DSO., In native HANA environment, worked on implementing solution right from extraction using SLT to modeling in SAP HANA and reporting in SAP BO 4.1/4.2, Integrated BOBJ 4.1 with SAP HANA1.0., Worked on DS migration from 4.1 to 4.2 and enhancement of DS jobs based on rapidmart., Implementation of Outbound Delivery Pricing Condition data from ECC to BO through Data Services., SAP BO/BI Support at client location for ASPA region, One of the leading European pharmaceutical client, 02/2014 to 01/2016, Onshore Team Lead - SAP BO/BI Consultant and FRS Consultant, Support and enhancement for FRS monthly reporting for ASPA region. Migration of BO reports from 4.1 to 4.2 and SAP BW system upgrade to 7.4. Helping BPA managers with their regional monthly FRS reporting closure and reconciliation of data on BW reports., Deputed at ASPA Malaysia office for requirement gathering for Upgrade of SAP BW System to SAP BI 7.4 and BO server to BO 4.2., Modification in current flow/objects for upgrade. Planning the test cases and executing test. Fixing the issues came during the testing., Client interfacing and handling for the issues encounter during upgrade phase., Supporting Animal Health Sales reporting using Webi reports in IPAD to Sales team., Migration and testing of platform applications from BI 7.4 to BI7.4 on HANA., FRS extraction and monthly report generation to check accuracy of BW data. Help ASPA business to close their monthly FRS numbers in BW system and guide them with improvement in their monthly financial postings., Development of Regional BPA sales reports on BI 4.2 webi with IPad support., SAP BI/DS Production Enhancement/Support, One of the leading European pharmaceutical client and its subsidiary, 08/2011 to 01/2014, SAP BI/DS Consultant, Support and enhancement for BW reporting and Maintenance of Pharma BW data. Development and support of Sales webi reports schedules on 360 cast server. Incident management support and Daily load monitoring activity for DS jobs and BW system., Creation of Sales and Marketing Webi reports using WEBI rich client 4.1., Performance tuning for extracting Sales data from SQL server. Optimizing Target tables for extraction using BODS Jobs., Creation of BODS jobs and flow to load data to SAP BW system from SQL server., Creating scheduled task and bursting webi reports on 360 Cast to deliver webi report output to Sales team on the IPAD., Most Valuable Player Award in 2013 for delivering and Go-live of 360 Cast project., Working on Work Orders for enhancements as asked by the Business, FRS extraction and monthly report generation to check accuracy of BW data., Creation of Reports, Chains, Ad-hoc data loads, Interface, query distribution via email., Transporting new developments and Enhancements into quality system for user testing and then to Production system., Replicating Cubes, MPROs, chains and queries from Regional system(BW3.5x) to IBI system(BI 7.0x), L3 level support for fixing the process chains. Solving issues like restart a chain when repeat option is not applicable, Chains failed in DSO activation step, Chains failed at roll up step due to BWA issues., Process chain creation., DESIGN ASSESSMENT OF CONCESSIONS (SINGLE AISLE AND LONG RANGE AIRCRAFTS), UK based Aeronautical service based industry, 03/2009 to 03/2012, Aeronautical Design Engineer, Design solution for live wing panel manufacturing and assembly non-conformances for Single Aisle and Long Range commercial airliner. Analysis of Manufacturing or Assembly defects based on Design and Stress domain aeronautical and mechanical empirical formula and knowledge and then providing solution based on EN9100 Airline quality standards., To analyze non-conformances encountered during production operations at Europe based Aero plane manufacturer from a design and stress perspective and to provide solutions accordingly while keeping in mind Assembly constraints, Manufacturability and Reparability., Ensure compliance with applicable technical publications through the use of maintenance instructions manuals for the appropriate series aircrafts., Train and mentor junior engineer members., Flexibility and ability to prioritize workload., Reduced significant error rate by utilizing methodical approach to training., Configuring and Maintaining database as per EN9100 (Airliner quality standard)., Configuration management plan, Version control, Access rights, installation and deployment of client provided tools on server and individual systems., Sap End user for data transfer and Sap configurator at our platform.