SUMMARY

• Over 9 years of experience in Business Objects Data Services, SAP - ABAP, Master Data Implementation, Data Migration, Data Extraction, Configuration, Customization, Data Stage, Oracle, SQL, Hard dollar, Rapid Marts.
• Good understanding in SAP HANA Modelling.
• Involved in the configuration of SAP HANA SLT from SAP R3 to HANA.
• Involved in the configuration of Data Services (BODS) and replicated the data from source system to SAP HANA system
• Four years of Experience with SAP Business Objects Data Services.
• Create Custom Attribute views, Analytical Views & Calculation Views in SAP HANA.
• Strong experience in Data Migration, Data Profiling, Data Integration, ETL Processes and Webreporting features for data warehouses and also responsible for ETL design and implementation involving Extraction, Transformation and Loading of data from various legacy systems into data warehouse.
• Good understanding on Data Services 4.0/3.2/BODI 3.1 concepts which involves creating of complex Jobs, Work Flows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target.
• Installed and configured the Business Objects Data Services v4.0, Data Services XI 3.2 with SAP BI, ECC and CRM.
• Worked with ABAP Data-flows, BW extractors, IDOCs, AIO (All-In-One) Templates and RFC (as a remote function) to read and write data from SAP sources.
• Provided Data Architecturefor data models and data maps (Extract, Transform and Load analysis) of the data marts and feeder systems in the aggregation effort.
• Worked with SAP ABAP Dictionary, Data Transfer using Batch Data Communication techniques like BDC Sessions and Call Transaction methods, Smart Forms, SAPScripts, Screen Painter, Dialog Programs, Area Menu, User Exits, RFC’s, ALV, BAPI, BADI, ABAP Objects and Cross Applications like LSMW, ALE, EDI and IDOC.
• Implemented ASAP Methodology and Involved in Six Full Life Cycles of the Project.
• Experienced with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary, information Stewardship, Data Profiling, Data Quality, and Data Model Standards
• Has experience in Migration, Integration, Development and Implementation of Master Data using strong project management methodologies by combining technical and leadership skills effectively with focus on process efficiency and productivity.
• Good understanding of relational database management systems like Oracle, DB2, and SQL Server and extensively worked on Data Integration for the Extraction transformation and loading of data from various database source systems.
• Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Join Schema/Snowflake modeling, Fact & Dimensions tables, Physical & Logical Data Modeling.
• Work closely with various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track ETL projects throughout SDLC.
• SAP Techno-Functional Consultant with extensive experience on SAP-ABAP.
• Loaded several Master Data and Transaction data from Legacy Systems (Mainframes, Oracle, UNIX, MS Excel) into SAP R/3, APO, GTS, and BI Tables.
• Worked on Information Steward in Data Insight tab on Profiling data, creating rules.
• Very good understanding on moving Hadoop files into Hana using BODS.

TECHNICAL SKILLS

Data Warehousing: Business Objects Data Services XI 3.2 (12.2.0, BOXIR3.1), 4.0.

SAP: ABAP, ECC / R/3 (FI/CO, SRM, SD, and MM), IDOCs, BAPI, LSMW, BDC, WEB-DYNPRO, BI/BW, HANA-SLT, HANA Studio.

Data Modeling: Attribute views, Analytical Views, Calculation Views, Star Schema, Snow-Flake Modeling, Fact and Dimensions tables.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008.

Related Skills: Java, HTML, XML, JSP, IIS.

Operating Systems: Windows XP/2008/2003/NT/98, UNIX.

Languages: C/C++, PL/SQL, T-SQL.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

SAP BODS/HANA Developer

Responsibilities:

• Implementation project as per ASAP methodology - Project preparation, Business Blue Print, Realization, Go-live.
• Conducted workshops with users to gather requirements and to understand the workflow of the as-is system, analyzed workflow to design To-be solutions, documented the findings, assessed scope of studies.
• Created Project Plan for scheduling based on Business requirement.
• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Understand and document the requirements based on the source and target systems and also created data mapping documents and Developed Specifications data mapping and Unit Test Plans for each of the Conversion Processes.
• Creation of Attribute views, Analytic views and Calculation Views based on replication data using HANA modeler.
• Worked on Restricted, Calculated Measures, Variables and Input Parameters in Analytic views.
• Creation of Analytic privilege to apply restrictions on the Information views.
• Restricted access to data by assigning relevant roles to users based on user profile.
• Created Information spaces in explorer based on HANA Information views.
• Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables.
• Worked on Hana studio to load, replicate, stop replication suspend and resume tables in Server based table data provisioning screen.
• Creating different types of jobs in SAP SLT like Real time job, schedule by interval, schedule by time. Managing the Replication Process Using the SAP HANA Studio.
• Worked on SAP SLT complex table structure changes (change data type or length, add or delete key fields) the trigger and logging table have to be dropped and recreated. Also on HANA side dropped and recreated to ensure data consistency.
• Developed Data Services job to pull data from SQL and Oracle into HANA database.
• Developed MM, SD, FI and HCM modules related objects to support go-live activities
• Developed jobs to extract the data from different sources and load it into staging then transform it per business requirements.
• Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.
• Involved in data profiling and used validation and address cleansing transformations while updating data into SAP.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Developed processes to meet the goal of 100% clean data in an environment of zero tolerance for duplicate records.
• Used SAP BODS to pull data from SQL into SAP HANA.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Involved in implementing SAP SD standard Rapid Marts to view some standard report on SQL Server.
• Developed Data Services job to pull data from Flat & Excel files into HANA database.
• Integration between BODS & BW.
• Developed complex mappings as per the requirement between SQL and BW using BODS.
• Used the ABAP data flows to read data from SAP to SQL Server for reporting purpose.
• Developed complex mappings as per the requirement using almost all transformations and effectively used Debugger for identifying errors and resolving them.
• Replicate operational tables into staging tables, Transform and load data into enterprise data warehouse tables using Informatics from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Created validation rules and rule bindings for data profiling according to business requirements.
• Used query, match, validate transforms and look up function for data integration purposes.
• Worked with Address cleanse (USA Regulatory certified address cleanse), Data cleanse, Match transforms (Firm address match batch) for cleansing the legacy records in customer master, material master etc.
• Worked on profiling of data (column relationship, de-duplication, redundancy and uniqueness) using Data-insight in Information Steward.
• Preparation and review of test cases.

Environment: SAP ECC 6.0, SAP HANA, SLT, BI/BW, BODS 4.0, CRM, PI, LSMW, Solution Manager, MICROSOFT SQL SERVER 2008, HP Quality Center, SAP Crystal Reporting.

Confidential

SAP ABAP/BODS Developer

Responsibilities:

• Implementation project as per ASAP methodology - Project preparation, Business Blue Print, Realization, Go-live.
• Conducted meetings with users to gather requirements and to understand the workflow of the as-is system, analyzed workflow to design To-be solutions, documented the findings, assessed scope of studies.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Developed processes to meet the goal of 100% clean data in an environment of zero tolerance for duplicate records.
• Developed methodologies using IDOCS and AIO.
• Developed job to update SAP Material master data from MDM using Data Services.
• Developed job to update MDM with new material created in SAP.
• Developed MM, SD and FI modules related objects to support go-live activities.
• Developed jobs to extract the data from different sources and load it into staging then transform it per business requirements.
• Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.
• Developing custom Report, BDC conversion programs, Dialog programs, SAP Smart forms.
• Developing Barcode Interface program from scanner to SAP.
• Reviewing Coding Standards compliance.
• Preparation and review of test cases.

Environment: SAP ECC 6.0, Data Services, Access Database, MDM, MICROSOFT SQL SERVER 2008

Confidential

SAP ABAP Developer

Responsibilities:

• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Developed MM & SD modules related objects.
• Developing custom Report, BDC conversion programs, Dialog programs, SAP Smart forms.
• Reviewing Coding Standards compliance.
• Preparation and review of test cases.
• Distributing Project work to team members.
• Work hour’s estimation of tasks.

Environment: SAP ECC 6.0

Confidential, Cleveland-OH

SAP ABAP Developer

Responsibilities:

• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Developed SD modules related objects.
• Assigning the task to the team members & monitoring the task.
• Delivery of objects on time & on schedule to the Project Manager.
• Developing Custom Report, BDC conversion programs, LSMW, Creating outbound IDOC setting and programs.
• Reviewing Coding Standards compliance.
• Preparation and review of test cases.
• Finding bugs in program for team member program.

Environment: SAP ECC 6.0

Confidential

SAP ABAP Developer

Responsibilities:

• Implementation project as per ASAP methodology - Project preparation, Business Blue Print, Realization, Go-live.
• Conducted meetings with users to gather requirements and to understand the workflow of the as-is system, analyzed workflow to design To-be solutions, documented the findings, assessed scope of studies.
• Involved in Development and High Level Technical design.
• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Developed processes to meet the goal of 100% clean data in an environment of zero tolerance for duplicate records.
• Developed MM, SD, PP, PM & FI modules related objects.
• Worked on Empties Management (the process of checking credit limit of empty bottles and managing empty bottles deposits.)
• Developing custom Report, BDC conversion programs, Dialog programs, SAP Smart forms.
• Reviewing Coding Standards compliance.
• Preparation and review of test cases.
• Distributing Project work to team members.
• Work hour’s estimation of tasks.

Environment: SAP ECC 6.0

Confidential

SAP ABAP Developer

Responsibilities:

• Developing and testing reports and enhancements to existing reports (Classical and Interactive), BDC conversion programs, Dialog programs & Used BAPIs.
• Reviewing Coding Standards compliance.
• Preparation and review of test cases.
• Finding bugs in program.
• Distributing Project work to team members.
• Worked in Enhancements of existing Reports, Interfaces, Workflow and Conversion objects using SAP ABAP.
• Providing RICE Support for the Modules SD, MM, PP, FI/CO.
• Solved IDOC related problems in the Project.
• Involved in extensive debugging of programs.
• Involved in Development and High Level Technical design of new Requirements.
• Involve in Trouble shooting of existing objects and come up with new changes in the System.

Environment: SAP 4.7