Data Sap

Professional Summary

• *+ years of IT experience, with 6 years of effective SAP BI/BW experience focusing on successful Enterprise implementations at a global level.

• Multiple full- life cycle projects (ASAP methodology) implementations in BW and experience with proven results in meeting reporting requirements, analysis, as well as design, construction and delivery of end user reports.

• Hands-on SAP BW technical expertise in developing and enhancing DSOs, Info cubes, Multi Providers, Extractors, Data source and complex transformations.

• Experienced in FIGL, Accounting, Accounts Receivables and Accounts Payables, Cost Center Accounting, Internal Orders, Profitability Analysis.

• Excellent experience in Extraction Lo-Cockpit - Inventory Management, SD, MM, Etc

• Experience with Systems Analysis and Design methodologies

• Extensively worked in the designing of performance optimization strategy for BW Data ware houses.

• Solid knowledge in System Administration, Table storage maintenance, Security, Data Extraction, Data Loading (Full /Delta Up-Load), ETL, Scheduling, Monitoring and Data Modeling.

• Maintenance, Installation and Enhancement of Business Content objects.

• Experience in Process chains and Info packages to lay connectivity into various Data Targets

• Strong analytical, conceptual and problem solving skills to evaluate complex BW technical and functional problems and apply knowledge to identify appropriate solutions.

• Good communication skills and ability to manage both team and multiple assignments simultaneously.

ENVIRONMENT:

• SAP BW 3.5, SAP BI 7.0, R/3, 4.6c, 4.7 ECC 5.0, 6.0, Netweaver 2004, BEx Analyzer, Web Application Designer, FI, CO, MM and SD modules etc.

Professional Experience

Client: Electronic Systems Inc, Virginia

Capacity: SAP BW Developer (March 2011- Feb 2012)

Scope: Implementation and Support

• Created Process Chains to schedule the data loads into data targets, info cubes and Rollups.

• Performed and setup multiple extractors in LO cockpit.

• Executed load balancing and data packet sizing for Performance Enhancements

• Generated OLAP Universes based on BW queries.

• Analyzed business requirements, performed GAP analysis with respect to the data models needs and available business content.

• Developed queries, variables, structures, restricted key figures, calculated key figures, conditions and exceptions.

• Also used RRI to jump target for more granular reporting. Created and configured Info Object, Data store Objects, Info Cubes, Multi providers and Info Sets based on Client Business requirements.

• Worked on performance tuning to improve data loading and query performances

ENVIRONMENT:

• SAP BW 3.5, SAP BI 7.0, R/3, 4.6c, 4.7 ECC 5.0, 6.0, Netweaver 2004, BEx Analyzer, Web Application Designer, FI, CO, MM and SD modules etc.

Client: Maccrae Industry, Claremore, OK

Capacity: SAP BW Developer (June, 2010 – February, 2011)

Scope: Implementation and Support

• Provided recommendations for overall system design and involved in dialog with Project team regarding new requirements and related issues.

• Activated info cubes and other data targets for these data sources in FIGL Accounting, Accounts Receivables and Accounts Payables, Cost Center Accounting, Internal Orders, Profitability Analysis

• Interfaced with Business Community to obtain reporting requirements that were converted to functional and technical specifications.

• Enhanced the extract structures by adding new fields and populating them with the user/function exits in CMOD.

• Involved in the Modeling, building and customizing Info Object, DSO, Info Cubes, Info Sets and Multi providers as per the functional specifications.

• Created Process Chains to schedule the data loads into data targets, infocubes and Rollups.

• Performed and setup multiple extractors in LO cockpit.

• Extracted data from Material master data material like MARA, MARC and MARD.

ENVIRONMENT:

• SAP BW 3.5, SAP BI 7.0, R/3, 4.6c, 4.7 ECC 5.0, 6.0, Netweaver 2004, BEx Analyzer, Web Application Designer, FI, CO, MM and SD modules etc.

Client: Koch Inc, Reno, Nevada

Capacity: SAP BW Developer (November 2009 – June 2010)

Scope: Implementation and Support

• Created info cubes, DSO’s, multi providers, Data sources and Extractors and complex transformations.

• Extensively worked in the designing of performance optimization strategy for BW data warehouses

• Created Process chains and Info packages to lay connectivity into various Data Targets

• Used Extraction Lo-Cockpit for Inventory Management, SD, MM, Etc

• Maintained Info Cube operability by employing various techniques such as Optimizing dimension size, compression, aggregates, logical partitioning and line item dimensions

ENVIRONMENT:

• SAP BW 3.5, SAP BI 7.0, R/3, 4.6c, 4.7 ECC 5.0, 6.0, Netweaver 2004, BEx Analyzer, Web Application Designer, FI, CO, MM and SD modules etc.

Client: Exacom, Concord, New Hampshire

Capacity: SAP BW Developer (July 2008 – September 2009)

Scope: Fresh Implementation

• Involved in a fresh BW implementation using the ASAP Methodology

• Activated info cubes and other data targets for logistic in SD, MM and some data sources in FI.

• Developed generic transactional and master data sources to fill gaps.

• Created process chain to schedule the data loads into info cubes and aggregates

• Enhanced the extract structures by adding new fields and populating them with the user/function exits in CMOD.

• Performed and setup multiple extractors in LO cockpit Extensive knowledge of BEx Analyzer, and BEX Query Designer for developing reports, analysis and Web reporting using BEX Web Publisher and BEX Web Application designer

• Maintenance, Installation and Enhancement of Business Content objects.

• Use SAP BW Data modeling of DSOs, Info Cubes, Multi Providers and Info set

ENVIRONMENT:

• SAP BW 3.5, SAP BI 7.0, R/3, 4.6c, 4.7 ECC 5.0, 6.0, Netweaver 2004, BEx Analyzer, Web Application Designer, FI, CO, MM and SD modules etc.

Client: Unilever Ghana Ltd

Capacity: SAP BW Developer (January 2006 – February 2008)

Scope: Implementation and Support

• Involved in complete life cycle implementation of SAP BW using ASAP methodology as a team member, converting Functional Specifications into Technical Specifications and then to realization.

• Analyzed the requirements and identified the suitable business content for SD, FI/CO and had the standard info cubes, ODS’s, Multi cubes and various other relevant objects installed and activated.

• Developed BW Queries, Testing and transporting through landscape.

• Involved in testing extractors, data loads and reports before transporting into production.

• Enhanced extract structures by adding new fields and populating them with the user/function exits in CMOD.

• Created the process chains to automate the data loads for transaction, master, text, hierarchies, currency exchange rate tables.

• Performed standard, application specific and generic extractions such as LO Cockpit, LIS, CO-PA, and FI/GL extractions.

• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.

• Extensive work on Design & Development of Custom Cubes, DSO/ODS Objects, Multi providers and Info sets; Enhancements on Accounts Receivables (AR) cube 0FIAR_CO2.

• Delta Management.

• Modeled Data targets according to the reporting requirements.

• Performance Optimization by Tailoring Transfer Structures, Communication Structures, and Update Rules using routines and Start Routines.

• Developed various FI/CO and SD reports such as DSO Analysis Current Period, Days overdue Analysis, Customer Sales Trend, Actual Contribution margin in Sales, Incoming Orders Analysis and Product Profitability Analysis in SD.

• Provided complete end user training and knowledge transfer to permanent staff.

ENVIRONMENT:

• SAP BW 3.5, R/3, BEx Analyzer, Query Designer etc.

Client: Ghana Cocoa Board

Capacity: Junior BW Developer (September 2005– December 2006)

Scope: Fresh Implementation

• Involved in a fresh BW implementation

• Activated all data sources in RSA5 and checked extractors in RSA6 and then RSA3

• Documented short dumps and faulty extractors

• Created many custom Info Objects documented to satisfy requirements for connectivity with Legacy systems

• Activated Master Data objects

• Performed and documented unit testing for all objects in Sandbox and development system

• Created Info packages in Development system and tested new Info Objects data loads

• Checked PSA for errors involving invalid characters

• Enhanced the different Transactional Data Sources with new fields and added functionality to populate them.

• Modeling, building and customizing Info Cubes, DSO/ODS, Info Objects, Info sets and Multi Providers as per the functional specifications.

• Involved in Installing Business Content for Standard Info Objects, Info Sources, Info Cubes related to Sales & Distribution, Material Management and Finance.

• Used the Business Content Sales Overview Info Cube 0SD_CO3, for overall Sales Analysis.

• Monitored data extraction and created queries based on client’s requirement.

• Performance Tuning of queries and data uploads: OLAP Caching, Aggregation and Compression

• Implemented BW statistics to monitor BW system performance.

• Liaised with SAP Basis Team regarding BW Transport requests.

ENVIRONMENT:

• SAP BW 3.5, R/3, BEx Analyzer, Query Designer etc.

Contact this candidate