PROFESSIONAL SUMMARY:

• Having 11 years of Experience in SAP with ABAP, BI/BW, BODS
• Worked on Classical /Interactive and ALV Reports with ABAP.
• Worked on data transferring methods like BDC, BAPI, LSMW, IDOCs, and RFC’s with ABAP
• Worked on Module Pool Programming, Exits, BADI and Data dictionary with ABAP
• Worked on SAPScript, SMARTFORMS with ABAP
• Conceptual Knowledge in web dynpro.
• Good knowledge in various functional domains SD, MM/P2P, FI, CO, HCM, QM, PM, PP.
• Having around 5 years of experience in SAP BI/BW(ETL)
• Experience with BI/BW(ETL) components including Infocubes, DSO (ODS), Transformations,
• DTP’s, Info sources, BI content, and info objects among others.
• Experience in installing the Business Content Objects depends on requirements.
• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to Data targets.
• Expertise in Start Routines, Field Routines & End Routines in BI/BW(ETL)
• Analyzed the business requirements and translated into dimensional data models by using
• Extended star schema techniques in BI(ETL).
• Experience in extracting data from the Source system using LO Cockpit and Generic Extractions for all the logistics data in BI(ETL)
• Worked on data load management, CTS.
• Experience in working (design, code, test) with custom extractors (using function modules).
• Worked on Scheduling and Monitoring the Process chains, Data source Enhancement,
• OLTP extraction data, Loading (Full/Delta Up - Load), Monitoring, Remote Cubes, Multi Cubes,
• Data Mart and Open Hub Service in BI(ETL)
• Experience in performance tuning of Queries by maintaining Aggregates, Compression,
• Partition, Process chains, indexing of infocubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx Query.
• Worked on BEx query designer and analyzer in building Queries, Columns, Rows,
• Local structures restricted key figures, Variables, Exceptions, and conditions
• Interacted with users for their feedback for creating reports.
• Good knowledge on Snowflake schema
• Worked on ETL BODI/BODS (Business Object Data Services) in End to End
• Implementation, Data migration and Upgradation projects.
• Developed jobs in BODS(ETL) with Flat file Extraction, R/3 Extraction.
• Experienced in Various Transformations like Validation Transformation, Merge Transformation,
• Case Transformations, Table comparison, Map operation, History Preservation etc.
• Worked on jobs with SCD (Slowly Changing Dimensions) TYPE 1, TYPE2.
• Experience in creating system configuration for executing jobs with different system landscapes.
• Experience in using Transformations for Data Quality of data from source systems.
• Scheduled Jobs in Management Console for parallel run based on requirements.
• Worked on PI interfaces with RFC, IDOC, JDBC,SOAP,FILE adaptors.
• Good understanding of business environment and translate them into Technical solutions.

Areas of SAP R3 expertise in ABAP:

ABAP Data Dictionary: Domain, Data Elements, Structure, Views, Index, Search Help

Reporting: Classical/Interactive Reports, ALV Reports, Module Pool-Dialog Programming

Interfaces: BAPI, EDI, ALE/Idocs, RFC Function Modules

Conversions: BDC, LSMW

Enhancements: User-Exits, CMOD/SMOD Function-Exits, BADI, and Enhancement Framework

Forms: SAPScript, Smartforms

Functional areas: SD, MM/P2P, FI, CO, HCM, QM, PP, PM.

AREAS OF ETL EXPERTISE IN SAP-BI:

• Involved in creating and maintaining Info Areas, Info Objects, Data Store Objects, PSA, Multi Providers, Info Sources, Data Sources, Info Packages, Transfer structures, Standard and Custom Info cubes. worked on Flat file Extraction, R/3 Extraction.
• Extracted data from various sources by using Business content data sources (Enhancing Data sources) and
• Generic data sources (with views, infoset queries, and function modules) on the R/3 side.
• Data Extracting from the Source system using LO Cockpit for Sales, filled set up tables for Init loads and
• Generic Extractions for all the logistics data.
• Data loading was monitored and analyzed the failed data packets, manually edited in PSA and reloaded to
• Data targets when required.
• Checking and deleting old lock entries.
• Data loading, Monitoring and Scheduling using Process Chain.
• Created aggregates to improve the query performance.
• Design and Analysis of reports Using BEx Analyzer.
• Performance tuning and Testing - Used RSRT and RSRV Improved data load and query performance by
• Aggregates, compression of Requests, partitioning of infocubes, Line Item Dimensions.
• Involved in Report Generation and worked on BEx Analyzer in building Queries using Filters, Variables,
• Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created
• Aggregates for frequently used queries.
• Worked on Data Services(ETL) in End to End implementation, Data Migration and Upgradation projects.
• Created Data stores for different source systems for importing the required data.
• Experience in developing jobs with Conditions, Workflows, Data flows, Scripts based on the specifications
• Using various stages in BODI/BODS(ETL)
• Experience in configuring SAP ECC, SAP BI/BW(ETL) systems with Data Services system.
• Good Knowledge of Data Warehouse Concepts including Schemas, Dimensions and Facts.
• Experienced in Various Transformations like Validation Transformation, Merge Transformation, Case
• Transformations, Table comparison, Map operation, History Preservation etc. worked on jobs with SCD (Slowly Changing Dimensions) TYPE 1, TYPE2.
• Experience in creating system configuration for executing jobs with different system landscapes
• Experience in the preparation of test scripts, Unit testing, Source code reviews and performance tuning
• Of objects. During system and integration testing.
• Experience in using Transformations for Data Quality of data from source systems.
• Scheduled Jobs in Management Console for parallel run based on requirements.
• Experience in implementation of ETL methodology in Data Extraction, Transformation and Loading.

TECHNICAL SKILLS:

SAP R3: ECC 6.0, 4.7, 4.6C.

SAP BI/BW: BI 7.0, 7.1, 7.3 BW 3.5

SAP BODS: 4.0, 4.2

Front Ends: BEx Analyzer, Web Application Designer

Languages: C, ABAP/4, and SQL

Operating Systems: Windows

Tools: Remedy system, ACT system, HP-ALM, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Senior Consultant

Responsibilities:

• Working on RFC with ABAP to load Purchase orders
• Working on BODS to load AP & AR from ECC
• Developed BODS job for migrating Material Master.
• Developed RFC with ABAP for migrating Stock Transfer Order .

Environment: SAP ECC 6.0, Data Services(BODS)

Confidential, Hillsboro, OR

Technology Specialist

Responsibilities:

• Developed Job in Data services(ETL) for loading Diebank tables in MS SQL.
• Worked on Remote enabled Function module (RFC) to fetch data from ECC for Diebank
• Developed Job in BODS(ETL) to load Cibr Wip tables in MS SQL from ECC
• Developed RFC in ECC to get Cibr Wip data.
• Developed a Job in BODS(ETL) for loading tables in MS SQL for CibrLotIntransit.
• Developed RFC with ABAP to get data in ECC for CibrLotIntransit tables.
• Worked on Inter and Intra Company Stock Transport Order Migration
• Developed RFC with ABAP to load data interfaced from Tera database into a custom table in ECC.
• Worked on materials requirements planning (MRP)
• Developed RFC with ABAP for loading Lot Extracts in ECC custom tables
• Worked on Open PO migration into ECC
• Developed RFC in ECC to load Lot Changes in custom tables
• Implemented Enhancement ‘ATP00001’ (EXIT SAPLATPC 001) for STO (Stock Transfer Order)
• Worked on Line items splitting in sales order with ‘BAPI SALESORDER CHANGE’.

Environment: SAP ECC, Data Services(ETL)

Confidential

Senior Technical Analyst

Responsibilities:

• FS review and TS preparation
• Code review to maintain coding standards as per the quality process
• Preparing Unit test documents
• Developed RFC with ABAP to update GTS (J*) tables in ECC 6.0
• Developed BODS job for migrating GTS tables (Global trade services) from source system
• With above custom RFC to update in target system (ECC)
• Developed RFC with ABAP for creating warehouse task, picking confirmation, packing confirmation Goods issue for outbound deliveries in EWM.
• Worked on BODS job for migrating open outbound deliveries from source to target (ECC)
• Developed a job in BODS to migrate inbound deliveries in EWM from Source to target (ECC) based
• On plant and deliveries creation date
• Worked on BODS(ETL) for GL posting with idoc ‘ACC GL POSTING’
• Developed a job in BODS(ETL) for AP & AR posing using an IDOC.
• Developed RFC’s with ABAP to update the Missing components of a Process order Updating header batches, batch determination with consumed quantities.
• Developed BODS job for migrating the open process orders from source systems
• To target system (ECC 6.0).
• Jobs scheduling and monitoring with Autosys tool.
• Worked on BI(ETL) for total payment term analysis report and sales summary report for populating
• The missing data in the fields.
• Worked on BI(ETL) for Modifying the Purchasing MPV finance Analysis and MPV operational
• And purchasing MPV management reports by adding the variables, restricted key figures and
• Calculated key figures for the queries.
• Worked on BI(ETL) for creating infocubes for billing to generate reports.
• Designed process chains for scheduled loads and enabled batch processing for various
• Administration activities in BI(ETL).
• Activated business content in ECC for Master data and Transactional data
• Interacted with User and resolving the issues in BI(ETL) during UAT.

Environment: SAP ECC, SAP BI(ETL), HANA, Data Services(ETL), Autosys

Confidential

Lead Consultant

Responsibilities:

• Developed RFC to update process order (COR2) with batch and components interfaced
• From source (4.7) system.
• Worked on sales order to update characteristic values using idoc(ABAP)
• Extended idoc(MATMAS MASS BAPI) with ABAP to update material master with
• Z fields (product group & main groups).
• Created variants for various Bapi’s (ABAP) for Results recording, Digital signature etc for binding with UI5
• Worked on Digital signature, Results recording of inspection lot (QE51N, QA32) for binding with UI5
• Developed RFC’s with ABAP for creating info types ‘0002’,’0016’,’'0037’,’0182’’0666’,’1010’ etc in ECC from source system(4.7) in HCM
• Developed RFC for updating Equipment task list (IA02) with characteristics (Qualitative & Quantitative)
• Developed RFC with ABAP and prepared metadata for binding ‘Approval PDF document’ in UI5
• FS review and TS preparation
• Code review to maintain coding standards as per the quality process
• Preparing Unit test documents developed a job in BODS(ETL) for migrating Quality notifications to target system (ECC)
• Developed BODS job(ETL) for migrating CIN master data ( Tcode J1ID) from source system
• With custom RFC to update in target system (ECC).
• Autosys tool was used for Job scheduling and monitoring
• Prepared the Technical Specifications based on the requirements from user
• Worked on BI(ETL) for activating Business content for Master data (Customer)
• And transactional data in ECC.
• Designed and developed process chains for master data loads and transaction loads
• With the help of Info packages. And these process chains are scheduled for periodic loads.
• Worked on BI(ETL) for creating generic data sources from views, function modules on Custom tables
• And Data domains.
• Worked with BEx Report Designer to create formatted reports in BI(ETL)
• Extracted data from various Tables like VBAK, VBAP, LIKP, LIPS, VBRK, VBRP, BKPF, BSEG etc in ECC to BI(ETL)system
• Enhanced the Infocubes in BI(ETL) by adding custom Info Objects to reflect the Business Process
• In ECC system

Environment: SAP ECC, SAP BI(ETL), HANA, Data Services(ETL), Autosys

Confidential

Lead Consultant

Responsibilities:

• Requirement Analysis and estimating efforts
• FS review and TS preparation
• Code review to maintain coding standards as per the quality process
• Interacting with users to fix the issues at the earliest
• Preparing Unit test documents
• Involved in developing objects with ABAP like Leave deduction (EL, LOP), contract (Sales order) creation
• Using manual file upload etc.
• Worked on Infotype Creation, PA Letters, HR forms, Payroll schema Functions with ABAP
• Developed HR master and cluster Developments Interactive ALV Reports with ABAP
• Worked on payroll and time reports with ABAP
• Implemented BTE for FBL1N, FBL3N, FBL5N.
• Developed an object with ABAP to post the FI documents with BAPI from excel file.
• Developed Custom infoobjects, Infocubes, DSO, DTP,Transformation & Multi providers per requirement in BI(ETL).
• Worked on PSA for monitoring data transfer from source system into BI(ETL).
• Developed queries on Different Infocube Using Bex Analyzer in BI(ETL).
• Designed various BEx Reports using Formulas, Selections, Structures, Calculated Key Figure and Restricted Key Figure in BI(ETL)
• Created Info packages and scheduled to load Master data and Transactional data in BI(ETL) from SAP R/3 and flat file.
• Involved in Data source Enhancements in BI(ETL)
• BI(ETL) reports are generated and shared to users.

Environment: SAP ECC, SAP BW(ETL)

Confidential

Lead Consultant

Responsibilities:

• Requirement Analysis and providing Estimation
• Preparing High Level Design
• Coordination between Client and Offshore
• Reviewed Functional specification before assigning to technical resources.
• Involved code reviews and performance tuning
• Participated in boot camp as trainer to train the GET’s
• Analyzing & Implementing the OSS notes for the issues with standard programs.
• Enhanced exits for sales order with ABAP
• Developed an interface for electronic invoice with ABAP
• Worked on Idoc for Purchase Order with with P2P process.
• Enhance inbound idoc to populate custom message in status record with ABAP
• Involved in developing RFC with ABAP to interface data from PI system
• Developed Infoobjects, Infocubes, ODS, transfer rules, communication structureUpdate rules and Info packages in BW(ETL)
• Involved in performance tuning by maintaining aggregates, compression, partitioningIndexing of infocubes and use of statistics for the same.
• Worked on infocubes to analyze the accounts receivable transaction figures and line items for the customers in BW(ETL)
• Created Aggregates on infocubes to generate reports and improve query performance in BI(ETL)
• Involved in performance tuning by maintaining aggregates, compression, partitioningIndexing of infocubes in BW(ETL)
• Designed and developed several BW(ETL) queries using BEx (Business Explorer).

Environment: SAP ECC, SAP BW(ETL)

Confidential

Senior Consultant

Responsibilities:

• Analyzed the FS and reviewing TS
• Reviewed the code changes and updated the code review document
• Prepared the status reports
• Developed Smart form with ABAP to print the invoice details
• Developed module pool screens with ABAP to post the FI documents
• Updated the document types and payment terms in various programs with standard document types payment terms with ABAP
• Developed ALV report with ABAP to display region wise vendor and customer postings
• Developed custom Infoobjects, Infocubes, ODS, transfer rules based on requirements in BW(ETL)
• Designed and developed process chains (RSPC) for master & transactional data loads in BW(ETL) with the help of info packages in BW(ETL)
• Involved in Load Monitoring Using RSPC, RSMO, SM37 and SM50.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages in BW(ETL).

Environment: SAP ECC 6.0