SUMMARY:

• SAP - Certified BODS associate with over a decade of professional experience in analysis, design, development, implementation of business applications and extensive experience in DATA migration, DATA Ware housing by using SAP tools (SAP BODS, HANA, ABAP, BW/BI) and worked as Techno Functional lead architect.
• Accomplished 9 complete life cycles implementations 4 of SAP BW/BI & Webi, 4 of SAP BODS, 1 of HANA SP9
• Over a decade of experience in Analytics/Data warehouse using SAP BW/BODS/DI, integration of BODS with SAP and Non-SAP data sources and hands on knowledge of Information steward.
• Designed the ETL processes using BODS data stores to connect variety data sources like SAP HANA, Oracle DB, MS SQL Server, TERADATA, PROGRESS DATABASE, ARIBA, NAVISION, XML, Flat Files, SFDC, SAP ECC, SAP BW, e-commerce application to staging database from staging to the target Data Warehouse
• A decade of experience and commandable knowledge in extracting data from SD, MM, FI, CRM and ISU Database and their tables relationship
• A decade of experience involving more than 10 projects for improving performance activity of data extractors, inbound & outbound IDocs’ processing, and development of Data Dictionary Objects, RICEFW objects (reports, interfaces, conversions, enhancement, forms, workflow, webdynpro), BDC, LSMW, Function Modules, RFC, BAPIs
• Delivering client specific coding standards for BODS, HANA, BW/BI, Lumira and ABAP technologies
• Providing SAP BEST Practices and performance improvement for defects and issues in existing deliverables
• Peer review of coding standards, designing solutions, project templates as per the client specific needs, managing approved project documents in secured shared path and data secuirty
• Managing issues and risks (Delivery tracker sheets) across project, Managing delivery packages and SAP transports, Coordinat and collaborate all team members and their deliveries, ensure code movement to production in time (project time line).
• Conducting workshops and meetings with project team for providing business and technical knowledge and set up proper goals to achieve the project timelines
• Designing and development of automation custom tools for avoiding dependency on manual process for easy reference

PROFESSIONAL EXPERIENCE:

Confidential

SAP BODS/BW Lead

Environment: SAP Business Objects Data Services 4.1, SAP BW 7.3

Responsibilities:

• Worked for BW-ABAP concepts like routines (start routine, end routines, lookups, dynamic selection at info package level, reading data from multiproviders and BEx variable custom exits (BADI))
• Developed OPEN HUB tables (SAP BW) to extract the data through BODS with process chain methodology.
• Developing custom and standard enhanced extractors from SAP CRM & ISU into BW through BADIs and called same extractors in BODS

Confidential, Houston, TX

SAP BODS/ HANA/ BW Architect

Environment: SAP Business Objects Data Services 4.1, SAP BW 7.3 & SAP HANA SP9

Responsibilities:

• Analyzing and designing the solution for business requirement and preparing standard templates (HLD, DLD and Test case docs) for project development
• Taking care of Business approvals, development standards and development in time
• Preparing common functions for the ETL design and audit tables creation for the project specific
• Creating batch jobs by extracting and validating data with respect to BW, and performing Extraction through ABAP DF, Pre-Load Validation, Transformation, and Post Load Validation
• Developing custom (splitting/partitioning data) program in SAP BW for loading huge volume (around 200 million records) of data into target DSOs within an hour SLA
• Sharing final data to ACRON system (SAP FI) by IDOCs’ from SAP ISU through BODS, and sharing the same data to Hadoop through BODS from BW SPO DSOs, and then business team queries that information for their reporting through SAS
• Executing Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
• Migrating MS SQL Database into SAP HANA and data read from SAP BW Open Hub through BODS
• Creating WEBI report and virtual info provider based on HANA models
• Extracting data from SAP BW by using Source Open Hub &Target Extractors and involving in text data processing
• Designing and developing new code for BANNER summarized data through PL/SQL code for KAC and Non-KAC contracts, products and appliances count
• Authorizing objects for the BODS user, table partitioning, and index creation to improve the security and performance (in association with Oracle DB team)
• Loading data into Hana Data base using SAP BODS from SAP ECC and conversion of Info cubes, Standard DSOs to HANA Optimization in BW on HANA
• Working on Match Transforms, Address Cleanse and Data Cleanse Transforms for Confidential
• Cleansing in Data Quality and Data profiling experience from source systems including SAP application/ SAP BW, Flat Files, Open Hub and Legacy systems using SAP Data Services (BODI/BODS)
• Implementing SCD - Type I & II using normal transformations (Other than Table comparison and History Preserving) in Data Integrator to increase performance. As a part of optimization used MAP operations to route update and insert records in the DW by creating the necessary indexes and Implemented incremental load process
• Loading IDOCs’ into ECC through BODS for basic, sales, company code and purchase organization data using flat file inputs
• Integrating Confidential 4.1 and BODS 4.1 with SAP HANA1.0. and loading data into Hana Data base using SAP BODS from SAP ECC
• Designing and implementing SAP HANA info models using Attribute Views, Analytic Views, Calculation Views Restricted and Calculated Measures, Input Parameters, Variables, Stored
• Procedures, CE Functions and SQL script and Data Provisioning (HANA) involving the areas SLT, BODS
• Sharing data of Banner (WMIS), SAP CRM, SAP ISU systems summarized data into SAP BW through BODS
• Creating new & enhancing existing DSOs, Multi providers, BEx queries, start, end, and field routines (reading data for lookup and dynamic selection for selective full loads of info packages)
• Extracting and loading data from ORACLE tables to Files and then Files will keep into CRM FTP location
• Loading data from Files to TERADATA layers by using Process chain methodology
• Working on the IDOC'S and Batch jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects

Confidential

Lead SAP BODS/BW/ABAP Consultant

Environment: SAP Business Objects Data Services, SAP BW

Responsibilities:

• Collecting FSDs, Reviewing, Preparing HLD document, Reviewing, Code development, DD document, testing documents and Reviewing
• Creating Release Documents for SIT, FUT and UAT
• Preparing custom functions, common job template for all the interfaces, naming standards, quality check list preparation, reviewing code and documents in Q-Gate
• Extracting data and generating file from Open Hub Tables and from ABAP data flows through BODS into SFTP location of Confidential system
• Extracting data from SAP-MM & EWM tables and generating XML files to load into Navision and MGX system
• Transferring data from legacy systems to SAP R/3 system using BODS IDOC for purchase order.
• Involving BODS ETL Jobs deployment from DEV to TEST and TEST to PROD
• Loading DATA TRANSPORT Files (ABAP DF Method) from SAP ECC to TERADATA using BODS
• Picking Routes information based on Batch id from Oracle and loading to SAP TM through the IDoc message
• Developing interfaces with Progress Database, Outer join with SAP PI system tables for the lookup and finally loading to ECC through BODS
• Creating and loading data into staging, dimension and fact tables from .csv files
• Using custom and standard IDOC's for extracting SAP data, transforming and loading it to SQL Server Table
• Developing interfaces between different types of files, Oracle Tables and loading Nielsen data files to MRS schema tables through BODS
• Installation, Configuration and Administration of Business Objects Data Integrator 12.2.0
• Implementing Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.

Confidential, Reston, VA

Lead SAP BW/ABAP Consultant

Environment: SAP BW & SAP ECC

Responsibilities:

• Developing data modeling techniques, and designing Info Cubes and ODS objects, as well as different aspects of time-dependent and non-time-dependent master data attributes
• Working on designing BEx Queries as data sources for Confidential reports.
• Developing a generic data source to pull master & transaction data with delta capability from MS SQL to BW
• Moving data from SAP to FTP servers. Reading data from FTP into SAP and creating and changing directories in FTP thru ABAP code
• Analyzing dump analysis and bug fixes to avoid the ABAP run time dumps in production
• Scheduling, and monitoring both master & transactional data flows through Process Chains on a daily/weekly/monthly basis
• Designing, creating, and maintaining custom Info Objects, Info Cubes, DSO, Data sources, Transformations, DTPs, Multi Providers, remote cubes, applying filtering conditions, aggregates, Info Set queries, initial, delta, full uploading methods, Info Package groups, and process chains
• Creating ETL mappings using Data Services to move Data from multiple sources like Flat files, Excel files, XML Files, Oracle, and Microsoft SQL Server into a common target area
• Creating RFC connection between SAP ECC to SAP BW, initiate communications to execute the Data conversions schedule and extracting data from SAP ECC systems using ABAP data flows transformed Data and stage them into SAP BW
• Deploying code into different environments i.e. DEV, TEST, and PROD
• Scheduling and Monitoring data loads in SAP BW, automating error handling, error escalation, and email notification procedures
• Handling Inbound/outbound interfaces using existing/customized IDOCS, EDI and ALE interfaces data
• Developing DTPs and Info packages and creating various routines with ABAP for the selections

Confidential

Lead SAP BW/ABAP Consultant

Environment: SAP BW & SAP ECC

Responsibilities:

• Gathering requirements, designing Functional/Technical specifications, Data Migration to SAP BW
• Extracting the data from legacy systems and SAP ECC to SAP BW through BAPI and ABAP functions
• Staging source data into Data Services Engine from SQL server, flat files, Excel and transforming to target SAP BW
• Designing and Modeling SD, MM, FI, OM and HR SAP Modules to fit the legacy system to SAP System
• Writing complex queries/formulas and creating Calculated, Restricted Key figures in BW Query Designer to generate required Plan/ Actual Data Reports
• Developing BW reports using BEx Analyzer, BEx Query, Web Application Designer and implementing Calculated & Restricted Key figures, variables, workbooks and using SAP BW Business Rules to improve report performance and functionality
• Modifying and recreating some of the ODS, Info cubes, Multi provider reports, web templates, start and field routines as per the client requirement
• Rectifying Load Failure errors in Master/Transaction Data Loads, and assisting fellow team members in solving their report issues
• Handling the tickets of priority P1, P2 and P3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement
• Continuous monitoring of weekly status of deliverables/incidents and updating the client accordingly
• Module development: AMS (Agro procurement Management System), as part of procurement from farmers, we need to collect lot of information from farmers, SAP MM module doesn’t support fully for this. So that, we have developed CMS (Cane Management System) as a initial version. Later, we enhanced and released as AMS.
• Note: We have done so many objects as part of this module development.
• Simplified PO creation (ME21N) with GUIXT and changed descriptions according to user friendly requirement.
• Enhancement of existing reports by copying and creating custom reports with BADI and user exit enhancements
• ZMMR029 - enhancement MM material report for warehouse management and ZMMR026 - enhancement MM critical toxic material report for material dept.
• ZEHSR002 (MM - Report) - Enhancement to add instructions on selection screen and movement types logics for report results.
• ZMMR16 (MM - Report) - Enhance to add additional selection fields, output fields and logics.
• Created approval WORKFLOW for Purchase Orders belonging to a particular purchasing group team or Business team.