SUMMARY:

• I possess over 20 years of in - depth experience in IT covering a wide range of functions from database administration through to financial and management reporting and visualization.
• This includes over 16 years in the SAP ECC, BW, BOBJ, and HANA environments with a current emphasis on BI and Planning.
• I have been in a lead or architect position on multiple SAP implementations, including BOBJ, BPC and BW projects at various phases, from project inception to post-implementation support, and have extensive hands-on management experience.
• My core skills include rapport with the business users at various levels, expedient and thorough analysis and understanding of business requirements, processes, applications, pain points, and transformation of these requirements into technical design specifications, architecture recommendations and ultimately solutions.

SKILL SUMMARY:

• R/3 Functional - Business Process Data Model and Structures
• MM 4 years
• SD 5 years
• FI/CO 7 years
• PS 2 year
• AFS 2 years
• Business Intelligence (up to and including 7.5 on HANA)
• Analysis and Design 16 years
• Backend Data Flow 16 years
• Front-end 14 years
• Custom and Business Content 12 years
• ABAP Coding 8 years

PROFESSIONAL AND BUSINESS EXPERIENCE:

Confidential, CA

BI HANA Lead/Architect

Responsibilities:

• Hands-on management of a team of onshore and offshore developers to design, develop and deliver HANA optimized LSA++ BI data flows for management reporting and dashboarding requirements.
• Project involved activation of HANA Optimized Standard BI content in the Logistics area as well as migration of several old content areas to HANA optimized data flows.
• Connectivity to Tableau for the dashboarding solution involved integration with HANA based calculation views and using native HANA modeling.
• BOBJ Analysis for Office was used for management reporting. Some reports incorporated advanced features of this tool, including conversion to formulas and OLAP.

Confidential, CA

BI HANA Architect

Responsibilities:

• Proposing and implementing a solution and architecture for migrating existing BW backend data flow to an optimized HANA based architecture based on SAP’s LSA++ model on a BW 7.5 system. The task involved a Proof of Concept pilot project to optimize parts of Newport’s Purchasing data flow to the new architecture utilizing Composite Providers and ADSOs. It also included migrating the ABAP transformation logic to a HANA SQL based AMDP logic. The goal was to automate the migration process to the most possible extent and minimize manual procedures.
• Developed a high level project plan and strategy for this migration including resource headcount and effort estimates.

Confidential, CA

BI Native HANA Consultant

Responsibilities:

• Responsible for architecture and development of a Native HANA data model for financial reporting using Tableau.
• The task involved creating HANA information views, HANA SQL Scripts using SAP HANA Studio, as well as extracting SAP BW and external data into HANA environment.

Confidential, CA

BI Architect/Senior Consultant

Responsibilities:

• Lead requirements analysis workshops with various divisions within TIC. Created rapport with executive management on those divisions. Conducted joint design sessions for BI dashboards and reports.
• Performed backend design and architecture for various BI data flows based on ECC and SQL based applications.
• Played the lead role in an upgrade project from BW 7.0 to 7.4. The effort comprised close cooperation with the Basis team in identifying and fixing the technical upgrade issues, coordination of UAT tasks for front end reporting as well as integration testing of data loads.
• Developed numerous BW data flows on BW 7.4 on HANA, including extensive ABAP and BADI coding
• Designed and developed front end reports and management dashboards using BOBJ Webi, Explorer Info spaces, and Tableau.
• Developed in-depth expertise in business data, processes and applications and architected information repositories accordingly.
• Was responsible for design and development of a BPC based planning application for the Office division for maintaining comparative lease data. This was an embedded design using BPC 10 and EPM tools.
• Designed and developed native HANA backend data flows using a mix of BW and SQL data using HANA Design Studio. The model comprised a combination of information views based on SAP BW objects using the push down approach as well as tables created using HANA SQL.

Confidential, CA

BI/BOBJ Senior Consultant - FICO

Responsibilities:

• Backend design and architecture for FICO data streams, including New GL, CCA, PS.
• Analysis of various FICO extractors and performing gap analysis for SBC extractors
• Enhancement of SBC extractors and development of generic extractors
• Development of BW objects such as DSOs, Cubes, Multi-providers, Transformation routines including ABAP coding
• Development of front end reports and management dashboards using BOBJ Webi and Xcelsius.

Confidential, CA

BI Architect/Team Lead

Responsibilities:

• Leading a team of onshore and offshore developers for development of a global BI solution. The system implemented based on BW 7.3 on Teradata with front end tools based on the Business Objects XI 4.0 Ramp-up.
• Coordination of functional analysis and specification and communication with the business. The SAP modules implemented were FI-New GL CO-COPA, CO-CCA and CO-PS.
• Design and architecture of backend solution in SAP BW.
• Design and development of certain complex front end report using Business Objects Web Intelligence and an executive dashboard using Xcelsius.
• Coordination and execution of QA, including SIT test plans and scripts.

Confidential, CA

Team Lead

Responsibilities:

• Leading a project for design and development of a BI Sales reporting solution. The task involved business analysis, data architecture design, and development of various objects such as the extractor, Info Cubes, DSOs and reports. Data was provisioned from SD and CRM Customer Service ECC modules.
• Interfacing with the business managers to capture financial reporting requirements
• Interfaced between technical and functional teams, and PMO.
• Managed and Coordinated Integration Testing, UAT, Training development and cutover planning
• Coordination of Issue Tracking and Resolution
• Managing timelines and reporting project status to PMO.

Confidential, CA

Senior BI Architect - FICO

Responsibilities:

• Design and development of a BI solution for the Generics group. The task involved business analysis, data architecture design, and development of various BI objects such as Info Cubes, DSOs, Transformations and routines (ABAP) plus Open Hubs to provision data to external systems.
• Development of front end report using Business Object Webi on OLAP Universes and Xcelsius.
• Involved in development of Integration Testing, UAT, Training development and cutover planning

Confidential, CA

BI Reporting and Planning Lead

Responsibilities:

• Hands-on team leadership to develop a budgeting / forecasting and reporting solution using SAP BI Integrated Planning.
• Responsible for design and development a Workforce Salary Planning solution using BI-IP. The task included development of complex tax calculation code using ABAP methods and Script Logic.
• Provided data architecture expertise and team leadership for all aspects of the BI project life cycle.
• Performed development tasks for back-end and front-end areas. This included BOBJ Webi reports and planning templates and publishing to SAP Portal.

Confidential, CA

Team Lead

Responsibilities:

• Hands-on leadership in a BI financial planning and forecasting project using the BW Integrated Planning (BI-IP) tool. Scope included Cost Center Expense and P&L forecasting.
• Managed all aspects of Business Blueprint, including end user workshops, business requirements gathering and analysis.
• Architected the back-end and front-end design, including strict security and authorization considerations.
• Developed numerous FOX formulas and ABAP based user exits.
• Developed a number of financial reports using Hyperion Essbase.

Confidential, CA

BI Reporting and Planning Lead

Responsibilities:

• Performed a role as SD reporting lead and overall technical architect.
• Performed a role as BW-BPS senior consultant to develop a Financial Forecasting tool
• The solution covered Income Statement and Balance Sheet forecasting for Profit Center and Cost Center Areas. The requirements were highly complex requiring heavy customization
• Developed BPS objects including complex user exit functions and VBA Macros for planning layouts.
• Developed an outbound interface from BPS to PeopleSoft comprising a number of ABAP programs.
• Participated in all aspects of Business Blueprint, including end user workshops, business requirements gathering and analysis.
• Designed data models in the sales area and developed a number of ODS objects, Info Cubes and Multi-providers, update rules and ABAP function modules.
• Designed and created a number of complex BEx queries and workbooks. Used extensive VB coding in some BEx workbooks.
• Coordinated Design reviews, QA testing and User Acceptance tests.

Confidential, CA

BW Senior Consultant/Architect

Responsibilities:

• Leading the project to upgrade the BW system to Netweaver BW version 3.5.
• Management of regression testing scope and timeline on various BW systems on the landscape.
• Tracking and resolution of Upgrade related issues.
• BEx Query and report development for Finance and Sales business units.
• Worked on integration of Business Objects queries and BW.
• Prototyping and demo of Information Broadcasting for Finance and Sales Business Units.
• Implementing a BW Web solution to restructure existing Income Statement reporting at Allergan.
• Developing a Cost Center Expense Forecasting solution using BW-BPS.
• Implementing a Sales Data Mart solution in BW for the European business units.

Confidential, San Francisco, CA

Hands-on technical team lead

Responsibilities:

• Reporting to Customer Contract Compliance and Vendor IMAs project managers.
• Lead a team of BW/SEM consultants to design a BI solution using BW and SEM-BPS.
• Designed SEM BPS Planning areas, layout, folders and functions for capturing contract commitments and sales forecast.
• Designed and developed complex BPS planning formulas and variable user exits for both solutions
• Assisted in Project planning and management activities per ASAP methodology.
• Participated in all aspects of business blueprinting, realization and go live activities for two back to back projects.
• Designed and developed a complex BW external hierarchy that was created and maintained outside BW and ported to BW automatically. This was made possible by creating a custom ABAP program.
• Designed and developed multiple BW backend objects including ODS objects, Info Cubes, Multi-providers, Update and Transfer Rules, and Process Chains.
• Designed and developed multiple queries, views, BEx workbooks, user exits in ABAP for variables and Web templates.
• Assisted in security design.
• Assisted in Training and change leader ship activities.

Confidential, Santa Clara, GA

Senior BW Consultant

Responsibilities:

• Focusing in the SD areas: Shipping, Backlog and Rebates, plus MM areas: Purchasing, and Inventory Mgmt, plus CO-PA.
• Providing technical review of existing BW design.
• Introduction and implementation of ASAP methodology including customizing ASAP templates.
• Proposing a new design strategy for common business measures in BW.
• Re-designing the existing Supply and Demand reporting area. This included several Info Providers.
• Developing and debugging custom and generic extractors, transfer and update rules, and variable user exits.
• Design and implementation of in-bound and outbound interfaces from/to the APO Demand Planning system.
• Providing Production Support in terms of load monitoring and resolving data and query issues.
• Participating in the upgrade of BW to version 3.0b. This included cleanup of the old system and use of new objects where required.
• Participating in the web enabling of the existing queries using Web Application Designer.

Confidential, San Jose, CA

Senior BW Consultant

Responsibilities:

• Activation of Business Content in the areas of PCA, CCA, CO-PA, FI GL, SD. This comprised loading of data into InfoCube.
• Requirements gathering and analysis in the areas of Product Profitability and Sales Reporting.
• Design and construction of custom InfoCubes in the FI-CO and SD areas.
• Development of a number of BW queries.
• Arranging a demo by SAP America for Business Unit managers
• Providing education and high level training on the application
• Activating BPS business content to provide a demo of SEM capabilities.
• Initiating and implementing a prototype for client’s Cost Center Planning requirements in BPS.