SUMMARY

• Around 7 years of experience in IT industry emphasizing in ETL and various Data Methodologies and tools like BODS, Information Steward, HANA, MDG, SAP BOBJ BI Reporting and Data Modeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Led Team in Implementing Projects, Implemented & Complete (BODS and HANA) Software Cycles.
• Cross - functional Data noledge 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).
• Experience in handling large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards
• Migrated Data to S/4 HANA using SAP BODS. Experience wif 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.
• Possess exceptional ability in problem solving, data analysis, complex reports generation wif macro utility to improve efficiency
• 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 wif 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 wif graphical and script-based methods, using SQL, SDI, SQL Script. Experience in HANA Security, Data provisioning viaSLT, DXC, BODS, SDA, Import, Export and Migration. Experience wif 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) wif 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 Performance Optimization & Tuning techniques, worked wif data from source systems including JDEdwards, Cobol Copybooks, Peoplesoft, Flat Files, Excel Workbooks, Legacy systems, RDBMS, and SAP R/3
• Responsible for publishing the BODS batch jobs as web services job in order they can be called from the third-party scheduler applications.
• Worked wif 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.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SAP BODS/HANA Consultant

Responsibilities:

• Analyze material failure data to determine the causes and develop appropriate solutions.
• Study the impact of materials on various streams such as procurement, production, finance, and Research & Development.
• Perform Data Modeling using Enterprise resource planning software such as SAP Data Services and SAP HANA to evaluate batch and material performance.
• Ensure smooth migration of objects and tools across various environments for deployment.
• Interpret the business requirements to develop work models using SAP BODS and SAP HANA.
• Design and optimize batch processes to ensure the proper flow of material data from source to target.
• Evaluate plans and specifications using software applications to determine technological and financial implications.
• Process material and other related data by compiling and coding wif the help of stored procedures using SQL.
• Advice changes in technical design and production process to enhance batch performance and quality.

Confidential, Allegan, MI

SAP BODS/Master Data Consultant

Responsibilities:

• Worked on Ranir Data Migration Project involving Data Migration from SLQ server to SAP system.
• Worked wif 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.
• Assisted in the development and maintenance of standards and procedures.
• Analyzed data requirements, mapping current systems and formats to logical and physical data models.
• Worked on proposing harmonization opportunities, standard ways for dis information to be communicated between systems and stored wifin corporate databases and performing architectural alignment.
• Worked wif complex nested schemas to troubleshoot and obtain master data extracts as XML files.
• Integrated various SAP instances wif 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 Hadoop, Teradata, and HANA functionality in Data Services.

Confidential, Plano, TX

SAP BODS Developer

Responsibilities:

• Worked in Agile sprints to create a Global Template for Confidential to use on future deployments.
• Worked on S/4 HANA 1709 platform and upgrade to S/4 HANA 1809.
• Managed the design of business processes, the construction of the Solution.
• Worked on staging data to HANA studio in Staging, Alignment and Pre-load Schemas.
• Worked 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).
• Worked on GDQ validations for various loads.
• Migrated GL Balances using IDOC (ACC DOCUMENT03) from BODS.
• Migrated of Equipment, Functional Locations, using IDOC (EQUIPMENT CREATE02) from BODS.
• Used Data Migration Cockpit (DMC) to migrate data using t-code LTMC.
• Worked 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 elements in data services that built the new Gross Margin reports using various data integrator transforms. The sources were ECC, BW, a few custom tables built in ECC and flat files.

Confidential

SAP Consultant

Responsibilities:

• Knowledge in extracting SAP application Data in data services such as info cube using SAP Open Hub Destination and execute a batch job that calls a BW Info Package.
• Assess master data requirements for Material Master, Vendor Master and assess the requirements for SAP Master Data.
• Developed reports and Dashboards using Business Objects Web Intelligence View, Bex’s Query.
• Connect various source systems such as SAP BW, MS SQL Server, to extract data and tan apply business rules and load into SAP ECC 6.0.
• 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.