Summary
Overview
Work History
Education
Skills
Accomplishments
Key Domain And Technical Knowledge
Academic Qualification
Certifications And Professional Awards
Foreign Languages Known
Total Work Experience
Current Occupation
Highest Degree
Personal Information
Certification
Additional Information
Timeline
Generic

JAIMIN MEHTA

Fort Worth,USA

Summary

Having around 12 years of experience in SAP mainly focused on design, development and implementation of SAP Native HANA, SAP Data Services (4.1,4.2), SAP BI (7.4, 7.0), SAP Business Objects (4.1,4.0) including 2 years of client location exposure and experience at Kuala Lumpur for whole Pharma ASPA client support. Extensively worked for different Pharma clients with strong hold on Pharma change and quality processes. Worked on SAP Native HANA Data provisioning, Data modeling, Security and administration for Finance module reporting on BO and Tableau. Worked on Schemas, table definitions, Attributes, Measures & Hierarchies in HANA for Sales Module. Have done 1 end to end implementation on Data Services 4.2 with using ABAP dataflow. Support and Development based on Data Service jobs, rapidmarts and also migration from DS 4.1 to 4.2. Extensively worked on webi report and Universes. Also worked on development of BO Mobile webi based reports. Development and support of FRS reporting, COPA & LO data source enhancement and support for SAP BI 7.4. Expertise in production support issues which involved debugging ABAP Routines, Data source Enhancement, MultiCubes and fixing errors.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Onsite Lead Consultant US - SAP HANA & BI/BO Consultant

Infosys Technologies Ltd
04.2022 - Current
  • 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.

Offshore Team Lead - SAP HANA & BI/BO Consultant

Infosys Technologies Ltd
02.2021 - 04.2022
  • 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

10.2019 - 02.2021
  • Understand Data flow and business logic maintained in different warehouse server for Sales and Demand allocation for reverse engineering
  • Understand entity relationship for 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.

Offshore Team Lead - SAP HANA & BI/BO Consultant

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

Onshore Team Lead - SAP BO/BI Consultant and FRS Consultant

02.2014 - 01.2016
  • 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.

SAP BI/DS Consultant

08.2011 - 01.2014
  • 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.

Aeronautical Design Engineer

03.2009 - 03.2012
  • 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.

Education

Bachelor of Technology - Mechanical Engineering

Pune University
Pune, Maharastra
05.2008

Skills

  • Customer Relationship Management
  • S/4 HANA
  • BW/ BW on HANA
  • Technology Solution Design
  • BODS

Accomplishments

  • Supervised team of [Number] staff members.
  • Documented and resolved [Issue] which led to [Results].
  • Achieved [Result] through effectively helping with [Task].

Key Domain And Technical Knowledge

SAP BI/BW 7.X, SAP BI/BW 7.4 , BODS 4.1/4.2, SAP HANA1.0/2.0, SAP RapidMart, Oracle 10g, SAP Net Weaver BI 7.0 /BW 3.0 , BI Accelerator, BEX Analyzer , BEX Query Designer, HANA 1.0/2.0, HANA DESIGN STUDIO, Xcelsius 2008, Dashboard Manager, Crystal Reports XIR2, BOXI R3.1, Business Objects Enterprise 4.0/4.2, Web Intelligence 4.0/4.2, 360 CAST, SAP R/3 (ECC 6.0), PL/SQL, BODS Scripting Language, Native Hana DB

Academic Qualification

Bachelor of Engineering in Mechanical in 05/2008 from Pune University, Maharashtra, India.

Certifications And Professional Awards

  • HANA Associate Certification in 2016
  • Design Thinking
  • Professional Scrum Master – I in 2021

Foreign Languages Known

English (Reading, Writing and Speaking)

Total Work Experience

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.

Current Occupation

Lead Consultant US

Highest Degree

Bachelors in Engineering (Mechanical) - 2008

Personal Information

  • Gender: Male
  • Visa Status: H1B (In cap)
  • Passport Number: N6332352
  • Passport Expiry Date: 07/02/26
  • Marital Status: Married
  • Nationality: Indian

Certification

  • [Area of certification], [Company Name] - [Timeframe]

Additional Information

I am H1B authorize employee and my H1B is valid till June 2025.


Timeline

Onsite Lead Consultant US - SAP HANA & BI/BO Consultant

Infosys Technologies Ltd
04.2022 - Current

Offshore Team Lead - SAP HANA & BI/BO Consultant

Infosys Technologies Ltd
02.2021 - 04.2022

SAP HANA Data Modeler

10.2019 - 02.2021

Offshore Team Lead - SAP HANA & BI/BO Consultant

02.2016

Onshore Team Lead - SAP BO/BI Consultant and FRS Consultant

02.2014 - 01.2016

SAP BI/DS Consultant

08.2011 - 01.2014

Aeronautical Design Engineer

03.2009 - 03.2012

Bachelor of Technology - Mechanical Engineering

Pune University
  • [Area of certification], [Company Name] - [Timeframe]
JAIMIN MEHTA