SUMMARY

• Experience with various stages of SAP implementation cycles including design configuration, development, testing, maintenance and production support.
• Understand and gather requirements by interacting with end users, business analysts, Department heads, directors and Project Managers.
• Extensive knowledge of SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update rules, routines, Transfer rules, Process Chains and Event management for Automation process and Transformations.
• Extraction: Experience in extracting data from SAP R/3 using LO Cockpit, FI - SL, CO-PA and generic extractors. Also from new dimensional products SAP PP,QM, SAP APO. OLTP Extraction (Transaction Data, Master Data Attributes, Text, Hierarchies).
• Data Modelling: Proficient in BW/BI data modelling, Info Cube design & administration, DSO object design & administration, Multi provider design, info source design, and info object design and administration
• Reporting: Expertise in reporting using BEx Query Designer, Analyzer, Web Application Designer (WAD).
• SAP BI ABAP - Created Update rules, Transfer rules, Transformations, Start Routine, End Routine, user exit and function module code for generic data source.
• Business Content: Exposure to the Business Content and implementation of the same in the appropriatefunctional area and to activate business content.
• SAP R3 Source Configuration systems: Extracted Data from Flat File (CSV & Notepad), ECC / R3, SAP BW (Data marts), SAP APO Advance Planning Optimizer, SAP MDM Master Data Management system.
• Transformation: Expert in building custom Update rules, Transfer rules, Transformations, Start Routine, End Routine and Expert Routine.
• Data Staging & Loading: Experience with proper data architecture, PSA maintenance, Info Packages, Data Transfer Process (DTP), Delta functionality, Flexible Master data staging, and debugging loads using the Data load Monitor.
• Information Broadcasting: Used this tool to send Reports to Group E-mail as well as Portal Publishing in different formats like HTML, MHTML, and PDF.
• Performance tuning by maintaining Aggregates, Compression, Partition, indexing of info cubes and use of statistics for the same.
• Data Migration: Experience in data migration from BW 3.5 to BI 7.0.
• Testing: Experience in Unit test, Integration testing, User acceptance tests (UAT).
• Extensively involved in preparing test cased, User Manuals and End-User training.
• BO Reporting: Creation of Universe, OLAP Universe, XCelsius reports, Desktop Intelligence, Webi reports and Dashboards.
• Good working knowledge of SAP BPC & BW integration.
• Customizing the SAP BPC reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC.
• Experience in working with OOPS ABAP.
• Expertise in developing interfaces using ALE/EDI/IDOCS/RFC.
• Expertise in MM, SD, FI-CO, LE, WM, PP, FI-CO and APO modules.
• Good at tuning the performance of the Programs, SQL trace, code optimization and Debugging.
• Extensively worked on workflow monitoring and trouble shooting.
• Expertise in SAP Archiving and imaging using IXOS Live Link.
• Good skills in testing, troubleshooting, debugging and code review to check for program optimization, correctness & performance.

TECHNICAL SKILLS

ERP: SAP R/3 4.0, 4.6C, ECC 6.0, SAP BI 7, 7.3

Reporting Tools: BEx, SAP BO 3.x, 4 .0, WEBI

Languages: ABAP/4, C/ C++

Interfaces: ALE, EDI, BDCs, LSMW, IDoc’sTesting / Worklog Tools HP Quality Centre 9/10, BMC Remedy 7.0 / 7.5

Document & Change Mgmt: SAP Solution Manager 7.0 / Rev-Trac

Job Automation: UC4 Automation

Databases: Oracle 8i/8.0, SQL 2000/7.0.

PROFESSIONAL EXPERIENCE

Confidential, Plano, Tx

SAP BI/BO Analyst

Responsibilities:

• Working on SAP Business Intelligence enhancements by implementing backend and frontend changes.
• Involved in CMMI phases of Business Requirement Gathering, Functional and Technical Specification, Test Scripts, Traceability Matrix preparation and User Acceptance Testing for timely delivery of Work-Orders (Enhancements).
• Working with the business users for defining the reporting needs and help design/develop flexible queries using features like variables, exception, conditions, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis
• Working on Service Restoration Incidents and User Service Request type of tickets and solving them efficiently on time.
• Worked on the report performance tuning techniques like compression of the requests, logical partitioning of the info cubes, Building of the aggregates, using the OLAP cache, Marking the dimensions to High cardinality, running the DB statistics for all info cubes after each data load and creating additional indexes on the master data tables that are being used in the navigational attributes.
• Involved in creating the BIA indexes for the cube with performance issues and initial fill/rolling up of the indexes.
• Daily Job Monitoring to ensure that data is available for reporting before the US business starts.

Environment: Tools and Technology used: SAP-BI 7.3, ECC 6.0 EHP5, ABAP/4, SQL, SAP Business Explorer (BEx) Analyzer, BEx Designer, BOBJ 4.0

Confidential, Richmond, VA

SAP ABAP/BI Analyst

Responsibilities:

• Worked in technical support team as ABAP/BI Analyst to handle problem records, change requests and service calls
• This involved RCA of issue, restoring failed delta loads, handling change requests for any modification in existing functionality, handling service calls for issues encountered in production system for reports, loads.
• Resolved issue related to error in BEX, Workbook, WAD and authorizations.
• Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow.
• Creation and maintenance of BI objects (InfoCubes, DSO objects, Infoset, Multi Providers).
• Resolved issues related to process chains, data loads, Admin workbench, number range problems, info-provider related problems etc.
• Involved in creating new reports, interfaces and data upload programs.
• Involved in performance tuning long running custom programs.
• As per P&G quality standards Documentation is done e.g. creation of functional specifications, Technical Specifications etc.
• Followed PFG Change Management Process for moving any production change.

Environment: Tools and Technology used: SAP-BI 7.0, ECC 6.0, ABAP/4, SQL, SAP Business Explorer (BEx) Analyzer, BEx Browser.

Confidential

SAP BW/BO Analyst

Responsibilities:

• Created Process chains for Master data and Transaction data loads to automate the data loading in the organization and these process chains were scheduled for periodic loads.
• Scheduling and periodic monitoring of extractions through Info Packages and Process Chains
• Created an Open Hub Destination to automate the process of creating and downloading the .csv file for full hierarchy data upload
• Involved in documentation for the mapping, technical specifications, data validations and Test cases
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Involved in requirements study, design reviews and analysis of input/output flow.

Environment: Tools and Technology used: SAP-BI 7.0, 3.5, ECC 6.0, ABAP/4, SQL, SAP Business Explorer (BEx) Analyzer, BEx Browser.

Confidential

ABAP track lead and onsite-coordinator

Responsibilities:

• Handling any urgent break-fix or incidents that need to be resolved ASAP.
• Meeting functional leads to understand the requirements and suggest process solutions for new requirements/projects.
• Reviewing functional specifications and preparing technical specifications.
• Development coordination with offshore team, preparing unit test cases, conducting process and code reviews.
• Understanding the business process and gathering requirements for any new enhancements/projects.
• Proactive production support in resolving technical issues.
• Resource planning.
• Developed a report to find the EDI output status against invoice and an email would be sent to the users with an excel attachment.
• Developed a tool to automate the process of SAP user ids locking and deletion automatic in various SAP systems
• Developed an inbound interface to post the invoices in SAP based on the flat file (with invoice details) and with the images (PDF files) of the corresponding invoices, images would be archived using IXOS Livelink. In case if invoice posting fails then invoice would be parked and workflow triggers.
• Developed Apacheta route audit report, this report gives a comparison of Apacheta (route manager) sales order and invoice data to SAP sales order through invoice data. Its intended use is for the Route Audit group to ensure all Apacheta sales have flowed correctly to SAP.
• Developed ALV Reports for calculating variance between SAP and TPM/MF data and Automated Invoices
• Developed Open Puchase Order report to enable the procurement department to extract the list of all purchase orders and their associated status,i.e., GR or IR against the PO.

Environment: SAP ECC6.0, 4.6C, ABAP/4, SD, FI/CO, PP, WM, MM, LE