SUMMARY:
SAP BW/ABAP Consultant with 8 years in BW Cube/ODS design/creation/maintenance, BEX query development, WAD development, Portal deployment, BW production support, data modeling and ETL, and Master Data development. 11 years in ABAP Design, ABAP Programming, Performance Tuning, BAPI, ALV, BDC, Dialog/Dynpro, Outbound Interfaces, Reporting, Workbench Debugger, Database table creation, Runtime Analysis, and Development Project full life cycle.

EXPERIENCE

Confidential,New York, New York, SAP BI Architect, March 2012 – June 2012, BW Version: BW 7.0
Project Objective:
To design the implementation of the International Commerce project from an SAP BI standpoint. Responsibilities included analysis of existing SAP BI data models for the remediation of hardcoded currency and installation of organizational characteristics. Also, modification of Bex queries for selection and navigation of organizational characteristics as well as the remediation of hardcoded restricted key-figures. The analysis resulted in the decision to isolate all non-U.S. data in new data structures and all new reports for non-U.S. data.

• Performed extensive analysis of existing BW utilization.
• Analyzed Bex queries for current usage and viability to the business.
• Developed the techniques used to isolate Non-U.S. data. This was done to insure that non-U.S. activity would not impact current U.S. reporting.
• Worked with the business analysts in understanding the requirements and developing the reporting needs of the end user community.
• Worked extensively within the Administrator Workbench to analyze required transformations, DTPs, info packages, data sources and structures.
• Worked with developers to determine impact to BOBJ and Crystal reports
• Created in-depth documentation of the current “problem” areas and the “to be” changes.

Confidential,New York, New York, SAP BI Lead, September 2011 – March 2012, BW Version: BW 7.0
Project Objective:
To lead and support the implementation of J. Crew’s BW Security Concept. Responsibilities included: creation of the project charter, design new Security Roles, socialization of the new roles to the existing BW User Community, Testing/Documentation of these new roles and cleanup unused queries.

• Implemented the creation of new Roles.
• Conducted User Training
• Worked closely with Basis to gain acceptance of the new Roles
• Setup a Production implementation schedule

Confidential,New York, New York, SAP BI Lead, December 2010 – August 2011, BW Version: BW 7.0
Project Objective:
To co-lead and support the implementation of the International Commerce project from an SAP BI standpoint. Responsibilities included analysis of SAP BI data models for the remediation of hardcoded currency and installation of organizational characteristics. Also, modification of Bex queries for selection and navigation of these characteristics.

• Managed a team of 4 consultants for the overall delivery including design reviews and solution design.
• Conducted team-level workshops to obtain design consensus for currency conversion techniques.
• Worked with the business analysts in understanding the requirements and developing the reporting needs of the end user community.
• Worked extensively within the Administrator Workbench to analyze required transfer rules, update rules, DTPs, info packages, data sources and structures. Enhanced sales, purchasing and production planning extractors based on business reporting specifications and requirements.
• Worked closely with the in house BW team to create test scripts and test scenarios for testing in both unit and QA testing.
• Developed and executed report testing and verification of BEX, Crystal and BOBJ reports
• Created in-depth documentation of the current “problem” areas and the “to be” changes with detailed screen shots. Involved the core team and conducted multiple design and status meetings.

Feb ‘05 – Dec’10 Confidential,Business Intelligence - Retail

SAP (4.7 / 6.20 Enterprise) - BW :
Sr. BW Developer 3.5 & 7.0 environments

• Designed Info Cubes, Info Objects and Queries, loaded data from SAP R/3.
• Executed performance tuning and query optimization.
• Created Info Cube Aggregates to improve the performance.
• Extracted Master and Transactional data from both flat files and data extractors.
• Analyzed data. BW OLAP extraction.
• Modified Info Sources for master and transactional data.
• Designed & developed numerous Business Explorer Analyzer Queries (Bex).
• Configured BW Business Information Warehouse v 3.5 & 7.0.
• Developed an R/3 ABAP/reporting interface which reads BW Multi-providers
• Setup schedules for daily/weekly processing including DTP’s &Process Chains
• Implemented the POSDM interface to existing BW Sales ODS/DSO
• Developed WAD reports and deployed to Portal
• Installed and configured Standard Extractors using Business Content for SCM/MM using LO Cockpit (Purchasing, Movements and Inventory)

ODS/DSO’s Designed and developed:
Inventory, Receipts, Sales, Open Order, Planning and Layout Module.

Cubes/Multi-providers Designed and developed:
Daily Sales, Planning, Inventory, Receipts, Weekly Sales, Open Order,
Layout Module, Special Order Sales and Coupon Analysis.

BEX Queries designed and developed:
WFM Statistics via WAD/Portal
Daily Sales Analysis (multiple queries)
Special Order Sales Analysis
Sales Standard Analysis
Article/Site Standard Analysis (multiple queries)
Single Ticket Sales Analysis
Sales Tax Summary
On-Hand Standard Analysis
On-Order Standard Analysis
Merchant Dashboard via WAS/Portal

BW environment size 8 Terabytes.

May ‘04 – Jan ‘05 Confidential,SAP Warehouse Support

SAP (4.7 / 6.20 Enterprise) - ABAP/4 :
Design Analyst / Programmer 4.7 / 6.20 environment
Supported SD/MM outbound and in bound interfaces to EXE (Warehouse Management System).
Designed and developed Customs Compliance System.
Part of a team that installed a new Distribution Center.

May ‘03 – ’04 Confidential,SAP Retail Upgrade project

SAP (4.7 / 6.20 Enterprise) - ABAP/4 Consultant:
Design Analyst / Programmer
Designed and developed custom ABAP programs in a 4.7 / 6.20 environment.
Modified existing 4.5a ABAP programs, to enable them to run in a 4.7 environment.
Performed upgrade testing (unit, string, and integration) on modified 4.5a and on newly created 4.7 programs.

Feb ‘99 – May ’03 Confidential,SAP Retail project SAP (4.5a) - ABAP/4 Consultant: Design Analyst / Programmer

* Successfully Implemented SAP Retail – Live in Production on March 20, 2000.
* Wrote data migration programs (legacy to SAP during implementation)
* Developed Info-Structure key figure balancing programs
* Coded the Offer Entry dialog of the in-house developed Promotion Evaluation System
* Created BW load verification programs
* Coded and Tested Outbound Interfaces to BW and other Data Warehouse systems
* Participated in System Test execution and resolution of issues
* Utilized SAP Performance monitoring and trace tools to improve run times on custom ABAP programs
* Total of 80 plus programs created and installed covering MM, SD and BW

1997 – 1999 Confidential,

Senior Software Developer / Consultant

* Created Y2K conversion utilities and methodology

1995 – 1997 Confidential,

Senior Software Developer / Consultant

* Developed CICS/DB2 based Order Entry System

1993 – 1995 Confidential,

Senior Software Developer / Consultant

* Converted IDMS database to DB2

1992 – 1993 Confidential,

Senior Software Developer

* Wrote CICS/VSAM based Teller Variation system

1990 – 1992 Confidential,

Senior Software Developer

* Created CICS/DB2 based Claims Retrieval system

1983 – 1990 Confidential,

Senior Software Developer

* Converted DOS VSE to MVS

EDUCATION/TRAINING:

* SAP Certification and Training
* SAP 4.7 ABAP Delta Training
* SAP IDOC Interface Training
* SAP BW Data Modeling
* BEX Reporting
* IBI WebFocus Reporting
* BW Extractors