SUMMARY:

• 15 plus years’ experience in IT, SAP Data Services Data Migration and 12 Plus yrs. of EIM and HANA/BODS 4.1/4.2, HANA SQL,SAP ECC,CRM,SCM,BW,ABAP,MDM,Tableau Reports, LSMW, JDE,Oracle,ABAP, XML Data, EWM,APO - SNC, BAPI’s, BADI’s,HCI, Web Dynpro, SAP Best Practices for Data Services, AIO Package, SAP Logistics and Business Objects.
• Implemented 4 complete Lifecycle Data Services projects including requirement gathering, data modelling, EIM, extractions, Server Installation, SQL, PL/SQL, Custom ABAP Code, Information Steward, SAP ABAP Dataflow, IDOC Data validation, SQL Server, XML Data validation, TOAD, Configuration, Upgrade, data staging, Master data management, Web Services, Data Quality, Unit Testing (UAT), data cleansing, Python Code, Address Verification, data quality and transformations and reporting.
• Created various information models like Attribute views, API Development, HANA, BODS upgrade, SQL Scripts, Side car scenario, SAP Basis Administration, HANA Security, Analytical views and Calculation views. Good Experience in MDM extended star schema including Info Cube design, ABAP,DSO design, Info Objects, Info Sources, LSMW, MDM, Transformations, DTP’s.
• Worked with following MDM core functionalities like Identity resolution, Data Services, Data Governance Utilities, Data integration, Data profiling.
• Experience in creating views, Perform column profiling, Source System Configuration, address profiling, dependency profiling, redundancy profiling, uniqueness profiling, creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0.
• Good professional development experience in Oracle 11.2, SQL Server 2005, 2008 or 2012.
• Experience in defining and supporting Business KPIs as per the business process.
• Designed the jobs using the mapping rules in Legacy Mapping Templates and SAP Mapping Templates and loading of the data from Source database to Stage Database in SQL Server 2008.
• Responsible for creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0.
• Created views, Performed different kind of profiling like column profiling, address profiling, dependency profiling, redundancy profiling, uniqueness profiling on IS 4.0.
• Loaded source data for different countries one by one using Conditional Flows, Scripts and Global Variables.
• Performed Mapping, Validations (Lookup, Mandatory, Format), Enrichments in AIO Jobs for Customer Master, Vendor Master, Material Master, PIR.
• Developed HANA Information composer and trained non-technical user to access data easily for reporting.
• Transformations have been applied in SLT to convert data and to fill additional columns of table.
• Migrating HANA content from development, Single Sign On, testing environment to Production environment using delivery units.
• Good understanding of various components of SAP HANA.
• Overview working Knowledge of Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services

PROFESSIONAL EXPERIENCE:

Confidential, San Jose CA

SAP BODS Senior Consultant

Responsibilities:

• Involved in Implementation of SAP BODS/HANA, SAP FI, SAP ECC, HANA SQL, CRM,MDM,EWM, BW,SCM, FI-AR, FI-AP, ECC Logistics, Tableau reports, Pre-Load Validation, ABAP, Web dynpro, BAPI’s, BADI’s, HCI, SAP Best Practices for Data Services Migration, SAP SLT, SAP SDI/SDQ, AIO Package, LSMW, JDE, Oracle, SQL, XML Data validation, Unit Testing (UAT, Data Loading, Legacy systems, ECC systems. Involved in BOBJ Queries from ECC, BOBJ 4.2, Native HANA, MDM, Web Intelligence Reports, Custom ABAP Code, HR, LSMW and ABAP.
• Worked on Cost Center data validation with business rules, Web Services, Data Reconciliation. Worked on validating the Material Master Data derivation rules.
• Implemented SAP Data Services with SAP ECC Logistics data, SAP ABAP Dataflow, IDOC Data validation, SQL Server, Source Systems configuration, Pre-Load Validation, SQL data validation, Unit Testing (UAT), PL/SQL, data loading, EIM, Involved in legacy systems and ECC systems data validation, Native HANA, Data validation, Web Intelligence (WEBI) reports, LSMW and ABAP.
• Worked on cost center data validation with business rules, web services and data reconciliation.
• Worked on validating the material master data derivation rules.
• Experience in BODS ETL mapping design, data load strategy and defining the technical architecture.
• Designed ETL frameworks and best practices. Worked on data integration projects with SAP and knowledge of database tables and relationships in SAP.
• Worked on SAP Tables and relationships, SAP functional knowledge, debugging, understand ABAP code. Integration experience with source code repositories, Job Server and access server configuration. Working knowledge and understanding relational data models
• Experience in data quality module of data services. Used Match-Merge transform to perform customer address cleansing against USPS address directories.
• Sound knowledge of various transforms of data services like query, validate, case, match, base data cleanse, table comparison and key generation transforms.
• Loaded data into SAP using all methods of LSMW as Standard Batch/Direct input method.
• Implemented data mapping strategy for loading data to different Data Marts and Data Warehouses. Analyzed the BW Data model and Business Objects Queries.
• Executed data validation, migration rules and supporting to the business users.

Environment: SAP BO 4.2, SAP Data Services 4.2, EIM, BEx, ECC 6.0

Confidential

SAP BODS/HANA Senior Consultant

Responsibilities:

• Implemented and constructed reusable templates to speed ETL development in BODS and provide auditing functionality. Involved SAP Best Practices for Data Services, HANA SQL,XML Data validation, Tableau reports, HCI, CRM, LSMW, JDE, Oracle, ABAP,MDM,SAP SLT, SAP SDI/SDQ, EWM, APO-SNC, AIO Package with Data owner Legacy data files(flat and Excel) and map the fields with SAP ECC Master Data, Worked with SQL Server database tables and validated with master, Custom ABAP Code, BAPI’s, BADI’s,Web dynpro, transaction historical data, Created ETL Scripts( Decode functions) to replace the field values, Involved in Logistics data and integration with other modules, Involved in sessions with master data management, server installation, RFC connection and Source systems checks, Involved in security and master data governance, Unit Testing (UAT), IDOCs.
• Led training BODS sessions explaining usage of templates and gathering ideas for improvement.
• Implemented data migration from legacy systems to ECC HANA ECC and worked on existing Business Objects Queries 4.2, Worked on Native SAP HANA, CDS views and SAP HANA Live, Virtual Data Model (VDM), HANA XS. Worked on Change Data Capture on both source and target level for Slowly Changing Dimension (SCD) Type 1, Type 2 and Type 3.
• Created Batch jobs and ran ETL jobs to load SAP material master and vendor master data loads.
• Worked on configuration of multiple data stores and servers (Job server and Access server).
• Involved in Source files with LSMW data mapping, Data Quality transformations match, associate with data and multiple country address cleansing. Developed, published, and scheduled batch and real-time jobs.
• Involved in identifying the duplicate records and modify the Query transformation in the ETL job, Worked on local and Global variables in ETL Jobs for Date variables and parameters.
• Worked on Architecture contributions to dashboard reporting and ETL architecture and design, including best practices.
• Acted as go-to for the team for technical issues and replicating the jobs for new Application development.
• Loaded data into SAP and data validation with final mapping rules as per the business rules.

Environment: Data Services (BODS) 4.2, HANA, Business Objects (WebI, UDT, IDT).

Confidential, NY

SAP BODS/BW/BO Senior Consultant

Responsibilities:

• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Gathered requirements from business users to support the Solution Architecture ETL for EDW.
• Created Local and Central repositories, LSMW, JDE, Oracle, SAP ABAP and assigned the security in the multi-team environment.
• Worked on the Business Objects Data Services 4.2 with SQL Server, Tableau reports, SAP SLT, SAP SDI/SDQ, XML Data validation, SAP HANA, SAP ECC, Involved in Master Data Governance, SAP ECC IDOC Data validation, Custom ABAP Code, SAP ABAP Dataflow, HANA SQL, IDOC Data validation, Server Installation, SQL, Source systems data validation, LSMW, MDM, Tableau, Flat file, Database Configuration, Data Quality Transforms, MDM, EDI/BAPI, Environment, ETL Developer entire project implementation was on 4.0.
• Worked on the IDOC’S, Batch/ real time jobs to extract the data from the SAP/ECC system,ETL Scripts Lookup ext, Decode functions, Data Quality Transformations, Ifthenelse scripts to load into the staging data-base for the multiple projects.
• Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, Web Services, Oracle, XML, SQL Server, and .txt and .CSV files. Worked on the DI scripting and prepared a standard Incremental load template which enables the job failure/success notifications. Worked on the BW open Hub tables to extract the data from the BW.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put and get the files on the data-exchange servers.
• Worked on the standards and guidelines Best practices Documentation, and also the functional and Technical design specification documentation.
• Supported the Solution Architect for BODS Technical features to integrate with SAP systems and provide solution to establish the ETL Framework around SAP BODS.
• Defined Data Stores to allow BO Data Services to connect to the source or target database.
• Developed ETL jobs to move data from multiple sources to Enterprise Data Warehouse
• Implemented use of SAP ABAP data flows to extract data from SAP Applications ECC, BW etc.
• Developed integration between different systems (SAP BW, SAP ECC, SQL Server).
• Implemented Delta recovery solution for failed objects like auto-recovery.
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flow’s and target tables using bulk loads.
• Configured and implemented Enterprise structures, Organizational Management, Personnel Administration, and Payroll. It's a full cycle SAP implementation as a Techno functional team member. Designed and implemented numerous accounting systems including applications such as FI-G/L, FI-A/P, FI-A/R, F/A, and financial reporting.

Environment: SAP BO Data Services 4.2, EIM, BW 7.0/7.3,SRM,BI 4.0, BEx, ECC 6.0

Confidential, Ohio, Columbus

SAP BODS-HANA/BO Senior Consultant

Responsibilities:

• Worked on SAP BODS Jobs, Performance Issues, Involved in ETL scripts data validation, HANA SQL, Microsoft SQL Server, LSMW, JDE, Oracle, Source Systems Configuration, Involved in XML Data validation, Tableau reports, Master data validation, Custom ABAP Code, Server Installation, Worked on Tableau reports, Analyzed Hadoop data, Master data load using LSMW, Supported SAP PLM Implementation and Custom Function modules for the Specification and Recipe management data.
• Worked on Hierarchy master data, Match Transformation, Source and Target Data store Configurations, SAP Function module Extract structures, SAP HANA Attribute views, Calculation Views, XML Data, Involved in Business Data owners Data cleansing, SAP BODS trouble shooting jobs, Address verification, maintaining data sources.
• Variables, TWS, IDOC, BAPI Data validation, Attribute values, Authorizations, default values.
• Worked with Functional area of EHS and QM modules.
• Involved with Specification types, Specification categories, SAP HANA Database sizing, Classes and Property tree data validation with NWBC transaction.
• Worked on BODS Source Database and Target Database validations, checking the Central repository and Local repository Data store connections and transformations, sending the Files to respective destinations.

Environment: SAP BO Data Services 4.0, BW 7.0/7.3,SRM,BI 4.0, EIM, BEx, ECC 6.0

Confidential, Michigan

SAP BODS-BO Senior Consultant

Responsibilities:

• Extensively worked Implementation, Server Installation, Configuration, Information Steward, SAP BODS Designer Components- Projects, Jobs, Information Steward, HANA SQL, XML Data validation, SQL, PL/SQL, Performance Testing, Workflows, Data Flows, Data Store and Formats.
• Worked on Information Steward, LSMW, JDE, Oracle, ABAP BAPI and IDOC Data validation, Custom ABAP Code, XML, Version upgrade, Master Data Data manipulation ETL Scripts, Data Profiling and Data Quality tools,
• Good Knowledge in Data Warehouse Table analysis and Implementation.
• Validated the BODS data with new versions of data changes from Development to Production.
• Involved in initial & incremental Extraction and Loading of data into Data Warehouse using SAP BODI.
• Created mappings using Merge Query, Master Data Governance, Case, Date Generation, Xml pipeline, Table comparison and Lookup.
• Good knowledge on DBMS concepts like conceptual, Relational schema, Normalization, Demoralizations, Indexing methodology etc.
• Developed highly complex WEBI reports using various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking, Controlling lov’s incorporating sound business logic.
• Good knowledge in deployment, Tomcat, Web services, Java, Web sphere, unit testing and user acceptance testing thereby ensuring quality assurance
• Having excellent communication skills and good team player with the ability to work in association with team members for successful implementation of projects.

Environment: SAP BO, SAP Data Services 3.x

Confidential, ATLANTA, GA

SAP BW-BODS/BO Senior Consultant

Responsibilities:

• Worked as BODS Developer, Business Objects 4.0, SQL Scripts, LSMW, JDE, Oracle, ABAP, Data Services, HANA SQL, Data Integrator Functions, Technical and Functional Specifications, Performance Testing, Finance data validation, Sales territories, BEx Query Designer, BEx Analyser, Custom ABAP Code, Conditions, Exceptions, Modelling, MDM, Web API Development, Web Application Designer, Global Structures and Formulas.
• Extensively worked on SAP BODS Designer Components- Projects, Jobs, Performance Testing, Workflows, Data Flows, Information Steward, XML,LSMW, Data Profiling, Address verification, Web services, Java, Data Quality, Data Stores.
• Good Knowledge in Data Warehouse Implementation.
• Involved in initial & incremental Extraction and Loading of data into Data Warehouse using SAP BODI.
• Created complex mappings using Merge, Query, Case, Date Generation, Xml pipeline, Table comparison and Lookup..
• Good knowledge on DBMS concepts like conceptual, Relational schema, Normalization, Demoralizations, Indexing methodology etc.
• Good in writing complex SQL query on various RDBMS system.
• Worked on Data Migration from SAP and non SAP Data to Target databases.
• Custom development and adding the Navigational attributes to the Info Cubes and Multi provider.
• Involved in adding the New Master data Info Objects to the existing Aggregate Cubes and activated the aggregate Info Cubes.
• Involved In Restricted Key Figures, Calculated Key Figures and Filters and Bex Variables and Imposing the Processing Options.
• Worked on SCM, ABAP Custom development, Informatica, SQL Scripts, APO Demand Planning, Function modules, BADI, Vistex Bill backs, Agreements, Global Claim Requests Master data and Transaction data loads using Process Chains.
• Designed & developed Sales Commission Reporting using the Vistex sales incentive module (/IRM/
• LIS RM IPSIHDR,/IRM/LIS RM IPSIITM,/IRM/LIS RM IPSIKON)that is integrated with SD module.
• Involved in SAP Development area and Front end reports Bex Reports, HANA, Building the BICS Connection ( Business Intelligence Consumer Services ) to queries, Business Objects Explorer 4.0, IDT 4.0, Universe Designer Tool, Business Objects Analysis 4.0, Crystal Reports 4.0, Business Objects Dash board 4.0,Business Objects Mobile User 4.0 with respect to the business requirements.

Environment: ECC, COPA, SD, SCM, Vistex, Business Objects 4.0, ABAP.

Confidential, St. Louis, Mo

SAP BW/BODS-CRM Lead Consultant

Responsibilities:

• Understanding the requirements and feasibility.
• Extracted data from SAP BODS SYSTEM and loaded into target SAP BW system.
• Design, develop, Test and implement Extraction Teradata, LSMW, JDE, Oracle, ABAP, FI-CO Transformation and Loading
• Worked on Multi provider to generate Bex report with CO-PA,BPC 10.0, HANA SQL, ABAP Routines, HR Budget Management, BW Extractors, ABAP Custom Function modules, BO Security, Validating the HR Info types, BWA, Open Hub Service, Performance Tuning, Custom ABAP Code, QM, PP,FI modules, Process Chains Creation, ABAP, ECC modules.
• Involved in BW Development area and Front end reports with respect to the business requirements.
• Involved in Business Objects, Web Intelligence Reports 4.0. Analysis Process Designer (APD) Crystal Reports, XCelsius development
• Involved in Master data Hierarchy Data Sources, Mobility Implementation, Logistics Cockpit-(LO Cockpit), which includes the functionality of the extract structures, Maintaining data sources, Upgrade, Activating updates.
• Built Info Cubes, DSO, Info Sets and Core Reporting Queries. OBIEE, BOBJ SDK, XCelsius Dashboard Reports, Business Objects 4.0 developments, Operational and Reporting Scenarios.

Environment: SAP BO 4.2, SAP Data Services 4.2, EIM, SAP BW, SAP BPC BEx, ECC 6.0

Confidential

SAP ABAP Programmer Analyst

Responsibilities:

• Involved in active interaction with the functional consultants, tailoring and developing the applications as required by the end users.
• Interacted with team members of Data Warehousing team to understand their data requirements as per End-user Query needs from Inventory perspective.
• Developed different business solutions for problems arising from unique client requirements
• Involved in the development and modification of specific reports as required in the areas of FI/CO, MM And SD modules.
• Involved in the development and modification of SAP programs using ABAP/4.
• Worked with LSMW considerably to handle the interfaces Development of Layouts with sap scripts and Smart forms like MM: changes made to sap standard PO layout to customize as per clients requirements.
• Using Runtime Analysis, debugging and dump analysis, analyzed the performance of Programs Created in ABAP/4 Workbench.

Environment: SAP R/3, SAP ABAP