SUMMARY

• Senior SAP Professional with 17 plus years SAP experience. Ten years of BW/BI experience. Involved in more than 20 full life cycle SAP implementations.
• BI 7.0, 7.3 Upgrade Experience. SAP BW on HANA. Big data experience SAP HANA and Apache Hadoop software.
• SAP BI Performance tuning and Architecture Reengineering expertise. QlikView, Tableau, SAP Lumira and SAP Business Objects Data Services Knowledge.
• Agile Project Experience and knowledge of Urban Turtle.
• Experience working with the business gathering and understanding of the reporting business requirements.
• Experience building reporting prototypes for the business users, creating test scripts, functional specifications.
• BI Extraction of FICO, Plan Maintenance - PM, HR - Payroll, SD data Order to Cash, Pricing, Deliveries and Shipments. Extraction of Logistics Purchasing data.
• Implementation of a BW SAP NetWeaver 2004S BI 7.0, 7.3, ECC 6.0. Upgrade experience R/3 and BW, SAP R/3 SD (Billing, FICO, Pricing) Supply Chain Management (SCM), SM since 1993 and four BW (2.0, 3.0, 3.1, 3.5)-CRM 4.0 Analytics (extraction of CRM Activities and CRM Opportunities). Reporting with Visual Composer.

PROFESSIONAL EXPERIENCE

Confidential - Detroit

SAP HANA Modeler and Architect

Responsibilities:

• SAP CR&B Utilities implementation SAP Suite on HANA.
• Contract Accounts Receivable and Payable (FI-CA) Reporting including Business Partner Items, Creditworthiness, Dunning, General Ledger, Installment Plan, Low Income, Payments and Returns, Security Deposits, Tax Exemption and Unbilled Revenue.
• Design and development of virtual data models HANA Live eliminating the need to replicate data of ECC and analytical, attribute, calculation views on SAP HANA.
• Designed, documented, developed and test HANA data models.
• Experience working with CE Functions.
• Creation of Lumira, Tableau and WEBI reports.
• Design and development of virtual data models in SAP HANA and analytical, attribute, calculation views on SAP HANA.

Confidential - New Jersey

SAP BW CRM Architect Consultant

Responsibilities:

• Marketing Attributes - Extraction of the SAP CRM Marketing Attributes. CRM 7.0.
• Agile Implementation.
• Evaluation of the implementation of SAP HANA at Confidential .
• Extraction and reporting of SD Pricing data.
• CRM Testing using LoadRunner and U/I Performance Testing.
• Creation of Test Scrips.
• Flatten the Service Type, Profit Center and Business Partner Hierarchies using Master Data objects and SAP Business Objects Data Services - Hierarchy Flattening - Flattens a hierarchy into relational tables. Reverse Pivot - rotates row values to columns.
• Experience working with the business gathering, understanding of the reporting business requirements, development, testing and documentation. Deliverable of complete end to end cycle.
• Migration from SQL Server project.
• Loading Salesforce.com data.
• Experience building reporting prototypes for the business users, creating test scripts, functional specifications.
• SAP BI CRM Production Support.
• Review and redesign of the SAP BI CRM Architecture.
• Setup the security for the Opportunity Report using an F4 Restrict BADI and ABAP code, restrict the display of employees by company.
• Experience with Open Data Protocol (OData) and creation of data services.

Confidential

SAP HANA Modeler

Responsibilities:

• Development of Semantically Partitioned GL, AP, Asset Accounting SPOs On SAP NetWeaver 7.4 SP 5.
• Reporting out of the BOBJ 4.0 BusinessObjects Enterprise Auditor using a Universe.
• Determined development best practices ABAP, SQL Script.
• Experience working with the business gathering and understanding of the reporting business requirements.
• Experience building reporting prototypes for the business users, creating test scripts, functional specifications.
• Design and development of virtual data models HANA Live eliminating the need to replicate data of ECC and analytical, attribute, calculation views on SAP HANA.
• Designed, documented, developed and test HANA data models.
• Experience working with CE Functions.
• Creation of Lumira reports.
• Creation of custom reuse views of Z tables.
• Development using the HANA Extended Application Services XS using SqlScript, and Calculation Engine (CE) functions for data-intensive operations. The application processing was performed in the database, close to the data to improve performance.
• Design and development of virtual data models in SAP HANA and analytical, attribute, calculation views on SAP HANA.
• HANA modeling Eclipse platform HANA Dev Studio.
• Experience working with CE Functions.
• Creation of Workday DSOs and Cubes.
• BPC design and development of predictive analytics capabilities on SAP HANA.
• Development of a BPC Audit Tables BW Dataflow - DSOs, Cubes and Multi-Providers in SAP HANA.
• Used SAP Landscape Transformation (SLT) for real-time data replication from SAP ERP or non-SAP systems.
• Financial Reporting and extraction of FICO data.
• Designed, documented, developed and test HANA data models.
• Development of BPC BADIs - Write-Back ABAP Code in SAP HANA.
• Development of Accounts Payable reports.
• Setup security of Navigational Attributes of AP report.
• Housekeeping of existing code.
• Perform ABAP Code Analysis.

Confidential

SAP BI 7.3 Backend Developer Agile Implementation

Responsibilities:

• Development of Expert Routines using ABAP Classes and Methods.
• Determined development best practices ABAP, SQL Script.
• Configuration/implementation of BW integrated planning. Experience implementing BW-IP Planning Functions. Knowledge of FOX code.
• Data loads of flat files non SAP data. Trading Systems data loads - Univeris, NBCN, Winfund and SAS.
• Development of WEBI Reports and Universe reading an ECC Infoset.
• Development of BPC Reconciliation Reports.
• Configuration of the CFM (Corporate Finance Management) ECC Treasury and Risk Management extractors.
• Financial Reporting and extraction of FICO data.
• Development using APDs and Direct Update DSOs.

Confidential

SAP HANA Modeler, SAP BI 7.3 HR Talent Dashboard Developer and Architect

Responsibilities:

• Implemented HR Talent Development SABA and ABAP Routine enhancements. Backend enhancements to Payroll extractors.
• Development done with SAP BI 7.3 using remodeling.
• Experience working with the business gathering and understanding of the reporting business requirements.
• Experience building reporting prototypes for the business users, creating test scripts, functional specifications.
• SAP HR ABAP experience.
• Participated in a HANA SABA proof of concept.
• Used SAP Landscape Transformation (SLT) for real-time data replication from SAP ERP or non-SAP systems.
• Design and development of virtual data models HANA Live eliminating the need to replicate data of ECC and analytical, attribute, calculation views on SAP HANA.
• Designed, documented, developed and test HANA data models.
• Experience working with CE Functions.
• Creation of Lumira reports.
• Creation of custom reuse views of Z tables.
• Designed, documented, developed and test HANA data models.
• Created the Agile project plan using Urban Turtle.

Confidential

BW Upgrade Technical Lead and Architect

Responsibilities:

• Technical Upgrade BW from 3.0b to 7.3. Technical upgrade from 3.0B to 7.01 then technical upgrade from 7.01 to 7.3. SAP BI.
• SAP BI Performance tuning and Architecture Reengineering.
• Development using the SAP HANA Studio. Tasks included importing tables, creating Attribute Views, Analytic Views, Calculated Views, Language Dependent Text Views and used the SQL Editor to create SQLScript stored procedures.
• Used SAP Landscape Transformation (SLT) for real-time data replication from SAP ERP or non-SAP systems.
• Designed, documented, developed and test HANA data models.
• QlikView reporting.
• Extraction of Sabrix Tax Data - Value Added tax.
• Development using Infospokes, APD with ABAP Routines and Aggregation.
• Created Data Virtualization Business views with the Composite Software.
• Convert ABAP routines to OO framework.
• Migration of Bex Reports to WEBI Business Objects Reports.
• Fix the Data Model for the high cardinality Infocubes.
• Global calculated key figures, restricted key figures, and structures were not being utilized which complicated developing testing strategies and the migration to BusinessObject reporting tools.
• The reasons for the technical upgrade were SAP BW3.0 does not integrate with Business Objects to provide stable and easy reporting and SAP BW 3.0 is also in extended support with SAP and will eventually no longer be supported, which is putting business operations at risk.
• Plant Maintenance extraction and queries to determine Damage Analysis - Notifications, Maintenance Operations - overview of the planned and actual labor for maintenance orders at individual work centers, Budget Comparisons - Actual vs. Planned.

Confidential

BW/BI Technical Lead and Architect

Responsibilities:

• BI Upgrade and BOBJ Migration. Migration of the Supply Chain Management object - FICO, SD, APO, MM, and Spend Analysis Project. SAP BI Performance tuning and Architecture Reengineering.
• BI Upgrade from 3.5 to 7.0.
• QlikView reporting.
• Management of Consulting Resources in the US and India.
• Migration of BEx queries and Workbooks to BOBJ WEBI reports.

Confidential

BI Development and Support Manager

Responsibilities:

• Turnaround department. Restructure development and support group.
• SAP BI Performance tuning and Architecture Reengineering.
• Experience working with the business gathering and understanding of the reporting business requirements.
• Hire and restructure staffing levels.
• Mentor of staff and support Global staff located in the USA, China, Mexico and Europe.
• Change Management.
• Evaluation of BO Xcelsius for a Vendor Performance reporting requirement.
• Implementation of a BI Optimization/Performance Tuning program that included deletion of redundant data, improvement of aggregates, remodelling that included using line item dimensions and archiving using “Near Line Storage”.
• Migration of BEx queries and Workbooks to BOBJ.
• Plant Maintenance extraction and queries to determine Damage Analysis - Notifications, Maintenance Operations - overview of the planned and actual labor for maintenance orders at individual work centers, Budget Comparisons - Actual vs. Planned.

Confidential

Senior SAP BW 7.0 Developer

Responsibilities:

• Implementation of a BW SAP NetWeaver BI 7.0 IS Retail and SAP CRM 5.0 environment. Implementation of BW CRM Trade Promotion Management - Planning layouts, Supply Chain Management SCM Forecasting and Replenishment (APO for Retail), Procurement to Pay, Supply Chain Execution, Purchasing. Implementation of CRM Complaints with CRM2005 and utilizing the BI Component of SAP Netweaver2004s. Familiarity with the reporting tool Visual Composer.
• Development of a four layer BI Architecture to provide flexibility and eliminate future maintenance costs. The component layers were the Data Warehouse, Transformation, Application Integration and Reporting layers.
• Retail Forecasting and Replenishment and EDI 852 Vendor Product Activity Data.

Confidential

Senior SAP BW Developer

Responsibilities:

• Functional Development of a Strategic Mission Critical CRM Pricing Management, Supply Chain Management (SCM) and Control Analysis System using SAP BW. Pricing, Volumes and Margin Analytics generated Competitive Advantage for the Client. Development of an R/3 Pricing Master Data Generic Extractor.
• Loading JDE data.
• CRM 4.0 Analytics (extraction of CRM Activities and CRM Opportunities).
• The objectives of the CRM BW Pricing project are to generate reports showing prices increases, and the effects of Volumes (Sales), Margins and to generate accurate, current price lists for the Sales Force.
• The CRM BW Pricing project greatest savings will be through the increased speed that the client will be able to implement a price increase and realize the increased top line revenue. Furthermore, providing visibility of where the client is not receiving the price increases so that the client can insure that they get the additional revenue wherever possible. The deliverable will also eliminate the labor required by the CRM customer service department entering approved prices into SAP and generating the Price lists for the Sales Force.
• Eliminate the manual entry of approved prices.
• Increase speed to implement price increase.
• Reduce sales rep's and administration personnel's time required to administer price increase (projects 32410 and 32411for above 3 goals).
• Provide comprehensive analysis tool to manage prices and insure increases (BW CRM project 32040).
• Pricing Management and Control Analytics System improved SOX Governance.
• Ensure project focus is aligned with business and technology strategy. Build and manage a project plan.

Confidential

BW/BPS Developer

Responsibilities:

• Managed a SEM BPS and BW environment for Confidential . Provided production support.
• BW extraction of Confirmed Shipment Items. Information at the document item level about scheduled, loaded and delivered quantities
• SEM BPS Support and development of Planning Areas (Basic and Multi), Levels, Packages, Variables, Planning Functions, Layouts, Planning Folders and BW reporting.
• Ensure project focus is aligned with business and technology strategy. Build and manage a project plan.
• Support BW reporting. Supported existing and developed new reports.
• Enhanced existing cubes and monitored jobs using the BW Administrator’s Workbench.
• Member of the Sarbanes-Oxley Act Compliance Team.
• Execution periodical extractors in SAP-BW to report in real-time for enterprise planning (SEM-BPS) as planning scenario with consideration of actual data.
• Execution periodical extractors in SAP-BW to report in real-time for enterprise planning (SEM-BPS) as planning scenario with consideration of actual data.

Confidential

BW-SEM Back-End Development Consultant

Responsibilities:

• Production Support Shared Services, Supply Chain Management (SCM).
• Member of the Sarbanes-Oxley Act Compliance Team.
• BW Training, Development of Training Deliverables and Documentation.
• BW 3.0B Upgrade. BW Conversion to 3.0B. Converted over 100 Transfer Rules and InfoObjects from 2.0B to meet new Alpha conversion restrictions in 3.0B. Converted Web Reporting from ITS to new Web Application Server. Debugged 3.0B ABAP conversion programs for Roles, URLs and MIME repository.
• Top-down & Bottom up with Business Planning and Simulation (SEM-BPS 3.2) to control Budget (Budget Monitoring) for order on stock and resource planning.
• Transfer of profit center data (extraction) of different locations and elimination of corporate group clearings as preparation for the financial consolidation in BW.
• Execution periodical extractors in SAP-BW to report in real-time for enterprise planning (SEM-BPS) as planning scenario with consideration of actual data
• Analysis of the characteristic number activity (KPIs) and the employees and business partners to increase the efficient control of the communication processes with value activity tree and key figure tree (Return on Capital Employed) as actual-target comparison.
• Creation of external Data Source to facilitate flat file update for Activity Based Costing data.
• Operation, development, support, and maintenance of a large SAP BW, SEM system. Translating functional specifications into BW and SEM technical solutions, cube development tuning maintenance; extract design-implementation, system configuration and tuning, performance optimization, OSS research, support packs and upgrades, BW front-end support, and coordination of all landscape activities with BASIS.
• Attended the FDA required cGMP training.
• Web Reporting using the Web Application Designer.
• Generation of Crystal Reports.
• BW HR Design for 3.0B. Designed Master Data Targets using 3.0B Master Data Queries and InfoSet Temporal Joins for Personnel Administration. Implemented Data Targets for HR Monitor Dates BW Generic Delta in 3.0B. Designed Generic Delta Data Sources for HR Master Data.
• BW Purchasing Extractors in 3.0B. Implemented changes to SAP delta extractors using CMOD User Exits.
• Implemented Process Chains.
• Installation of standard business content for GL and associated info objects for BW.
• Design of BW data targets based on data sources with ODS and Info cubes from the PSA.
• Experience with BW standard business content, info cubes, ODS, PSA, extractors, plugins, extending extractors.
• Data exports from SAP.
• Experience in ABAP for user-exits.
• Design and creation BW security.
• Tuning of BW with aggregates and indexes for Oracle on AIX/Unix.

Confidential

BW-SEM Project Manager

Responsibilities:

• Coordinate the activities of team members from cross-functional departments, as well as third-party systems integrators and developers.
• Work with the business to establish an agreed-to scope, budget, and schedule and manage the team to deliver within the established parameters.
• Ensure project focus is aligned with business and technology strategy. Build and manage a project plan.
• Management of a Project Team of 15 professionals located in Sao Paulo and Madrid.
• Execution periodical extractors in SAP-BW to report in real-time for enterprise planning (SEM-BPS) as planning scenario with consideration of actual data.
• BW Training, Development of Training Deliverables and Documentation.
• Creation of Reporting Authorization Objects using the Profile Generator (PFCG).
• SAP BW upgrade from 2.1C to 3.0A.
• Development of BW extraction programs for Performance Management KPIs. Successfully developed and implemented InfoCubes and ODS Objects using SAP’s Business Warehouse (BW), version 2.1C, 3.0A.
• Development of a KPI BEx Reports such as HR, Standard Cement Operations Report, Financial Report, Marketing and Sales Report, Ready/Aggregates Report, Alternate Fuels Report and Corporate Management Report.
• Implementation and execution of transports of objects from a Global Development Center in Spain to a Pilot Center in Sao Paulo Brazil.
• Configuration/Activating of SAP BW2.1C, 3.0A Standard and Non-Standard InfoObject, InfoSource, update rules, transfer rules, communication structure and transfer structure.