EXPERIENCE SUMMARY

• 5+ Years of Experience with ETL, Experienced in various Data Methodologies and tools like BODS, Information Steward, HANA, MDG, SAP BOBJ BI Reporting, Data Modeling etc.
• Led Team in Implementing Projects, Implemented & Complete (BODS) Software Cycles.(Requirements - Design - Development - Go Live - Performance Tuning)
• Cross-functional Data knowledge of SAP components such as: Finance and Controlling (FI/CO), Sales and Distribution (SD), Materials Management (MM), Plant Maintenance(PM), Production Planning (PP), Supply Chain Management (SCM, including APO, SNC), Extended Warehouse Management (EWM) and Customer Relationship Management (CRM).
• Migrated Data to S/4 HANA using SAP BODS. Experience with Various Modules in S/4. RTR - GL Balances, Project systems, WBS Budget Balances, PTP - Materials, Bill of Materials, Purchase Orders, Contracts, Purchasing Info Records. Used BPDM jobs for few modules and customized BPDM to accommodate additional Segments on Idocs, EAM - Work centers, Task List.
• Understanding of Master Data Management (MDM) & Data Cleansing / Data Quality principles. Used Data Services for cleansing the data using Data Quality transforms like Match, Associate, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality. Familiar with Information Steward, profile and analyze data, define rules, Cleansing Package Builder and creating Cleansing Package.
• Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script-based methods, using SQL, SQL Script. Experience in HANA Security, Data provisioning viaSLT, DXC, BODS, SDA, Import, Export and Migration. Experience with SAP HANA Administration including managing schemas, data model objects, import/export content.
• Created and automated jobs, complete end to end process using SAP HANA Cloud Integration (HCI) with the ability to push the data to Sales & Operations (S&OP) and SmartOps.
• Loaded data into Various streams like Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO/RDS jobs.
• Experienced in loading Data from SAP/Non-SAP/Excel sources to ECC using either BODS (IDOCS/ BAPIs) or using prebuilt Programs/ LSMW. Experienced in Fetching Data from ECC Using ABAP Data Flows.
• Designed jobs to Extract data from SAP BW using Open Hub Destination, kicking off the process chains. Also Loaded data to the BW DSOs using the external source system configurations.
• Experienced in performing Audit and Error Management processes.
• Experienced in Performance Optimization & Tuning techniques, worked with data from source systems including JDEdwards, CobolCopyBooks, Peoplesoft, Flat Files, Excel Workbooks, Legacy systems, RDBMS, and SAP R/3
• Experienced with Relational & Dimensional Data Models, Worked on integration of Business Objects Data Services with Non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2005/2000, DB2
• Responsible for publishing the BODS batch jobs as web services job in order they can be called from the third-party scheduler applications.
• Worked with Delta records by using CDC (Change Data Capture) on both the source level and target for SCD (slowly changing dimension) of Type 1, Type 2 and Type 3.
• Level 3 Production Support Installed & configured Data Services 4.0 SP2 in Development & Production Server.

PROFESSIONAL EXPERIENCE

Confidential, Allegan, MI

SAP BODS/Master Data Consultant.

Responsibilities:

• Working on Ranir Data Migration Project involving Data Migration from SLQ server to SAP system.
• Working with a range of technologies, process and employees to design, build and manage appropriate development objects relating to ETL and Data Quality using Business Objects Data Services, Information Steward, SLT, SDI, and SAP MDG.
• Assisting in the development and maintenance of standards and procedures.
• Analyzing data requirements, mapping current systems and formats to logical and physical data models.
• Proposing harmonization opportunities, standard ways for this information to be communicated between systems and stored within corporate databases and performing architectural alignment.
• Working with nested schemas to troubleshoot and obtain master data extracts as XML files.
• Integrating various SAP instances with third party SFTP servers to achieve data loads.

Confidential, Rosemead, CA

SAP BODS Consultant.

Responsibilities:

• Serving as an SAP BODS consultant for development, testing of Projects and Enhancements.
• Working as Managed Services provider for IT for support activities related to Production systems.
• Extending support to resolving tickets and issues related to SAP BW, SAP BODS, SAP HANA and BOBJ reporting.
• Worked on non- SAP to cloud systems integration implementations to resolve critical data load issues.
• Worked on performance analysis of ticketing system by developing data extraction logic into HANA and further developing Power BI dashboards.
• Worked on implementation of Teradata and HANA functionality in Data Services.

Confidential, Plano, TX

Responsibilities:

• Working in Agile sprints to create a Global Template for Confidential to use on future deployments.
• Working on S/4 HANA 1709 platform and upgrade to S/4 HANA 1809.
• Manage the design of business processes, the construction of the Solution.
• Working on staging data to HANA studio in Staging, Alignment and Pre-load Schemas.
• Working on conversion objects related to RTR - GL Balances, Prior Year Management Reporting, Project Systems, WBS Budget Balances and EAM - Work Centers, Task List (Functional Location, General Maintenance and Equipment).
• Working on GDQ validations for various loads.
• Migration of GL Balances using IDOC (ACC DOCUMENT03) from BODS.
• Migration of Equipment using IDOC (EQUIPMENT CREATE02) from BODS.
• Used Data Migration Cockpit (DMC) to migrate data using t-code LTMC.
• Working on HANA on cloud implementation to create flowgraphs and move data from one schema to another.

Confidential, Irving, TX

SAP Techno-Functional Consultant

Responsibilities:

• Designed and developed a project for the Business to understand and monitor their Plant’s product sales, inventories and profits more efficiently.
• Used Open Hub Services to push data out of SAP BI (GL, COPC, COPA, SRC PLAN, INVENTORY, Cost Centre Accounting, CCA) using Data Services.
• Used all the Data integrator Transforms.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing
• Developed a functionality sourcing ECC tables that gave scope for users to correct the data in the form of Kick outs, took the corrected data to feed to the report and sent the bad data once again to ECC using Idocs.
• The basic data for a gross margin analysis is sales and cost of goods sold. Sales and Cost of Goods Sold data is captured at an invoiced or open line item level and passed over to Data Services so that business object reporting tools can be incorporated to present the data.
• Designed the Focus of Analysis document that captures the dimensions, facts and KPIs that are specific to Gross Margin reporting. Built the Process document definition for The Sales Analytics PDD .
• Developed these elements in data services that built the new Gross Margin reports using various data integrator transforms. The sources were ECC, BW, some custom tables built in ECC and Some flat files.

Confidential

SAP Consultant

Responsibilities:

• Workshops with Clients to gather their Business Requirements. Provided Mock-ups to finalize the requirements.
• Converted business requirements into Functional/Technical Requirement documents and from there into HANA Model design blueprints and Functional Mapping Specification documents to build SAP HANA models
• Data extraction from Forest SAP system to HANA using ABAP data flows and Worked closely with ABAP programmers for data extraction and function module debugging and custom Table/ Extractor creation.
• Developed and designed HANA Information Models: Attributes views, Analytic views and Calculation views, Extracting, Transforming and Loading the Data through Oracle and into HANA Data Base.
• Data extraction from GP SAP system to HANA and send them to CIS as Flat files with header / footer.