SUMMARY:

• Having 11 years of Experience in SAP with ABAP, BI/BW, BODS
• Worked on Classical /Interactive and ALV Reports.
• Worked on data transferring methods like BDC, BAPI, LSMW, IDOCs, and RFC’s.
• Worked on Module Pool Programming, Exits, BAID, Enhancements and Data dictionary.
• Worked on SAP Scripts, SMARTFORMS.
• Conceptual Knowledge in Webdynpro.
• Good knowledge in functional domains like SD, MM, FI, CO, HCM, CRM, QM, PM, PP
• Having around 5 years of experience in SAP BI/BW
• Experience with BI/BW components including Info Cubes, DSO’s (ODS), Transformations,
• DTP’s, Info sources, BI content, 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.
• Analyzed the business requirements and translated into dimensional data models by using extended star schema techniques.
• Experience in Extracting data from the Source system using LO Cockpit and Generic Extractions for all the logistics data.
• 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.
• Experience in performance tuning of Queries by maintaining Aggregates, Compression, partition, Process chains, indexing of info cubes 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.
• Worked in BODI/BODS (Business Object Data Services) Projects like End to End implementation, Data migration and Upgradation.
• Developed jobs in BODS 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.
• Capable of understanding the business environment and translate business requirements into
• Technical solutions.

AREAS OF EXPERTISE IN SAP R/3:

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, Enhancement Framework

Forms: SAP Script, Smart forms

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

AREAS OF 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, info set 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 info cubes, 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.
• Involved in BODI/BODS (Business Object Data Services) Projects like End to End implementation, Data migration and Upgradation.
• 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.
• Experience in configuring SAP ECC, SAP BI/BW 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) TYPE1, 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, SQL

Operating Systems: Windows

Tools: Remedy system, ACT system, HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SAP BODS Consultant

Responsibilities:

• This project is an up gradation from 4.7 version to ECC with UI5 as front end for user interaction.
• FS review and TS preparation
• Code review to maintain coding standards as per the quality process
• Preparing Unit test documents
• Developed RFC 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 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 job for GL posting with Idoc ‘ACC GL POSTING’
• Developed a job in BODS for AP & AR posing using an IDOC.
• Developed RFC’s 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)
• Worked on BI for total payment term analysis report and sales summary report for populating the missing data in the fields.
• Worked on BI 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 for creating info cubes for billing to generate reports.
• Designed process chains for scheduled loads and enabled batch processing for various administration activities in BI.
• Activated business content in ECC for Master data and Transactional data
• Interacted with User and resolving the issues during UAT in BI.

Confidential, Chicago, IL

Technology Specialist

Responsibilities:

• This project is an up gradation from 4.7 version to ECC with UI5 as front end for user interaction.
• 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
• Extended idoc(MATMAS MASS BAPI) to update material master with Z fields (product group & main groups).
• Worked on enhancing components, working with event handlers, context nodes, attributes, plugs, views, windows.
• Created variants for various Bapi’s 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 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).
• Worked on Enhancements for dynamic value help, hiding of the fields in set types in the product screen at UI level.
• Developed RFC 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 for migrating Quality notifications to target system(ECC)
• Developed BODS job for migrating CIN master data (T.code J1ID) from source system with custom RFC to update in target system(ECC).
• Prepared the Technical Specifications based on the requirements from user
• Worked on BI 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 for creating generic data sources from views, function modules on Custom tables and Data domains.
• Worked with BEx Report Designer to create formatted reports
• Extracted data from various Tables like VBAK, VBAP, LIKP, LIPS, VBRK, VBRP, BKPF,BSEG etc in ECC to BI system
• Enhanced the Info Cubes by adding custom Info Objects to reflect the Business Process in ECC system

Confidential, New York City, NY

SAP Implementation

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 like Leave deduction (EL, LOP), contract (Sales order) creation
• Using manual file upload etc.
• Implemented BTE for FBL1N, FBL3N, FBL5N.
• Developed an object to post the FI documents with BAPI from excel file.
• Developed different types of objects like Info objects, Info cubes, DSOs, DTP, Transformation & Multi providers.
• Worked with PSA in monitoring the data transfer from source system into BI.
• Developed queries on Different Info Cube Using Bex Analyzer.
• Designed various BEx Reports using Formulas, Selections, Structures, Calculated Key Figure and Restricted Key Figure.
• Created Info packages and scheduled them in order to load Master data and Transactional data from SAP R/3 as well as flat file into BI.
• Involved in Data Source Enhancements.
• BI reports are generated and shared to users.

Confidential, San Diego, CA

Senior Consultant

Responsibilities:

• Requirement Analysis and providing Estimation
• Preparing High Level Design
• Co-ordination 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
• Developed an interface for electronic invoice
• Enhance inbound idoc to populate custom message in status record
• Involved in developing RFC to interface data from PI system
• Developed Info objects, Info cubes, ODS, transfer rules, communication structure, update rules and Info packages.
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes and use of statistics for the same.
• Worked on info cubes to analyze the accounts receivable transaction figures and line items for the customers.
• Created Aggregates on info cubes in order to generate reports and improve query performance.
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes
• Designed and developed several BW queries using BEx (Business Explorer).

Confidential, San Diego, CA

Senior Specialist

Responsibilities:

• Analyzed the FS and reviewing TS
• Reviewed the code changes and updated the code review document
• Prepared the status report
• Developed Smart form to print the invoice details
• Developed module pool screens to post the FI documents
• Updated the document types and payment terms in various programs
• With standard document types payment terms
• Developed ALV report to display region wise vendor and customer postings
• Developed Info objects, Info cubes, ODS, transfer rules based on requirements
• Designed and developed process chains (RSPC) for master data and transactional data loads with the help of info packages.
• Involved in Load Monitoring Using RSPC, RSMO, SM37 and SM50.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Created Aggregates and used line item dimensions to increase the performance of the query.

Confidential

Responsibilities:

• Reviewed Functional specification before assigning to technical resources.
• Reviewed program changes (New/delta code) and involved in review audit
• Arranged the TR’s for transportation from development environment
• PIC for Global coding standards for project
• Involved in Zero defect initiative with proposals to reduce defects.
• Reviewed KPI reports and also prepared KPI reports
• Attended in weekly & monthly review meetings with client
• Analyzed and converted user requirements into technical specifications for easy development.
• Reviewed Technical specifications, also prepared TS when required
• Developed new objects (inbound/outbound interfaces, Smart forms, ALV reports)
• Enhanced programs with additional requirement as per the SCR’s
• Worked on module pool for developing custom screens to post the FI documents for non-trade business
• Developed BDC programs, Custom tables
• BW reports are generated and modified them when required by comparing with data in R3 system.

Confidential

Senior Engineer

Responsibilities:

• Analysis of functional specification and developed the Technical Specification
• Developed ALV, Interactive reports in SD, MM modules
• Developed interfaces with BDC, Idoc’s
• Debugging standard transactions for analysis
• Performance tuning with SCI & SLIN
• Performing Unit Test and preparing test documents.
• Interacting with the on-site coordinators

Confidential

Software Engineer

Responsibilities:

• Developed Reports, BDC programs, LSMW
• Worked on Scripts
• Worked on IDoc’s
• Scheduling the background jobs and monitoring
• Prepared Technical specification from FS
• Developed objects as per the standards with minimal TR’s.
• Worked on Idocs, BAPI, BDC,
• Developed Smart forms to print the invoice details
• Performing Unit Test and preparing test documents.
• Interacting with the on-site resources when required