SUMMARY:

• Confidential is an experienced & certified SAP Consultant with leadership and technical skills in SAP BI (Business Intelligence) & application development (ABAP). He has over 25 years of SAP experience, of which over 12 years has been in BW/BI. He has knowledge in FI/CO/SD/MM/PP modules and is a recognized expert in all aspects of ABAP/4 programming. His experience in SAP - BI includes design and development of IMS data upload in the pharmaceutical industry, CO-PA, SD and S&OP Infocubes, ODS
• InfoObjects and Infospoke/Infohub, as well as development of BW queries and workbooks. He is proficient in ABAP/4-query, Report Writer, interface, batch and online-programming, User exits, Field-Exits and SapScript. The BI knowledge has been extended to Excelsius, WEBI, Design Studio and HANA as a developer, as well the creation of a single webservice using SOAMANAGER.

TECHNICAL SKILLS:

Most Recent Activities: BW Abap, Webreporting, BW Objects Development (DSO, Cubes (Standard, Real-Time, Remote), Multiprovider), ECC Data Extraction and DB-Connect to external Oracle DBs, Openhubs, file uploads, BW 7.3 upgrade, HANA Enterprise, Automated Report Bursting of BEX Queries and Workbooks using the Netweaver Broadcaster BWA. (Also see last page for s For Excellence). HANA view development for the past 4 and half year. Tableau app development for .

BO Specific Activities: BOXI4.0. Created an OLAP connection to cube/query and created WEBI reports. Dashboard creation based on a Query (basic implementation experience). BO SAP Analysis for Excel and OLAP with Aggregate Level defined in IP (RSPLAN). Infospace Development for BOEXPLORER. BODS data extraction from ECC and Modeln. Dashboard development with Design Studio. HANA modelling and development.

PROFESSIONAL EXPERIENCE:

HANA Consultant

Confidential

Responsibilities:

• The RAI is a HANA developed application which reads data from the Bell external system into HANA then harmonizes the data for the SAP-RAR application (Revenue Accounting Recognition).
• The data is passed from RAI to RAR using SAP BO Dataservice
• Create functional and solution design based on gathered Business requirements.
• Develop ECC extractors, BW Datasources, W-DSO, DSO, Cubes, Multiproviders and Queries for Billing and Vistex.

BW/Hana Sr. Modeler/Developer BI

Confidential

Responsibilities:

• Developed HANA views for the Office Construction Project on Project System and Purchasing modules via SLT. A separate team used this HANA view as the datasource for Tableau. This project reports real estate properties under construction, which shows budgeted, allocated and actual costs. This has drilldown capabilities by Market, Region, Project, Sales and Construction Managers. It also shows the number of projects completed, in progress and the duration of completion.
• Developed HANA views for the Resort Properties Project on New GL FAGLFLEXA and FAGLFLEXT as source tables via SLT. The company has many Resort Properties that generate income, and this HANA view will report daily and monthly budget, forecast and actual amount by property with comparison of current YTD, MTD, Previous YTD and MTD. It also allows drilldown and filtering by GL Account, Cost Center, Profit Centers, as well as Cost Center and GL account groupings. Web-Intelligence reporting is used as the reporting tool with the creation of a universe on top of the HANA views.

BW/Hana Sr. Modeler/Developer BI

Confidential

Responsibilities:

• Developed HANA views to consolidate data to be provided for the Allergan to TEVA migration.
• Supported the user community with reporting requirements during the transition period.
• ModelN data integration into HANA using BODS.
• HANA application user support .
• Data load from BW into HANA using BODS.
• Created reports in BO Advanced Analysis for office and OLAP.
• Created WEBI reports, scheduling and distribution.
• Created Dashboards with Design Studio.
• Legacy Actavis historical data migration into BW and HANA.
• Created Analytic and Calculation Views in HANA enterprise for several projects.
• Created Analytical privileges in HANA.
• Created delivery units and transport of HANA objects, as well as developer mode.
• Created SAP Analysis report on the HANA views.
• Extraction of ModelN data into HANA using BO Data service.
• Replication of SAP data into HANA using SLT.
• Analysis of AS-IS Quarter End Sales Cut-OFF reporting .

BW Sr. Developer Business Intelligence

Confidential, Denver, CO

Responsibilities:

• Cube Partitioning by Year design and development.
• Migration of 3.x datasources into 7.x.
• Problem ticket resolution and development of new BW reporting requirements in Finance, SD and Production Planning with APO plan data vs Actual from the Inventory movement cube.
• Developed the ECC BOM custom extractor into BW DSO.
• Process Chain support and overall BW development team member to support the business users with their Queries and Workbooks.

BW Architect/Sr. Lead Developer Business Intelligence

Confidential, Irvine, CA

Responsibilities:

• Developed a Global Financial BexWeb-reporting for Allergan’s Accounting Finance Team, Executive Committee and the office of CFO, which include Actuals, Budget and Forecast versions. The requirement gathering was in collaboration with the Sr. Director of Finance, V.P. of Finance and CFO.
• Developed HR Headcount and Workforce Planning Webreporting with Trend analysis.
• BW Application Team member of 7.3 upgrade .
• Created Webservice for BW Queries.
• In the planning stage for a POC for HANA (BW vs Enterprise).
• BO SAP Analysis for Excel Planning and Reporting with IP configuration (RSPLAN).
• Infocubes and Infospaces development for BOexplorer in areas: Logistics, Finance and Human resources.
• Development, Scheduling and support of process chains.
• Queries, Workbook and Webtemplate development in 3.x and 7.0 in Finance with currency translations, Logistics and Human resources.
• Custom development of ECC extractors Generic, Function module, Userexit and structure enhancements (EXIT SAPLRSAP 001 & EXIT SAPLRSAP 002) in areas Logistics, Finance and Human Resources transactional and master data. Extensive use of SBIW including Logistic Cockpit LBWE.
• Overall Business Intelligence Support for Analysis, design and development with working knowledge of Universe development and WEBI reporting.
• Team member of the Global Application Development and Support.
• System Info: SAP EHP 1 for SAP NetWeaver 7.0

BW Sr Developer

Confidential, Irvine, CA

Responsibilities:

• Member of the BW and R3 development team.
• BW-HR: Extracted 0EMPLOYEE and 0ORGUNIT master data with enhancements. Created an ABAP program to trigger an event that will trigger the process chain HR: Load Headcount and Personnel Actions Prior Period, and made the program flexible enough to allow for triggering of other HR process chains as well. Created a transfer routine to populate the long text for 0ORGUNIT with the orgunit medium text, concatenated with the manager name.
• Developed several Openhubs to generate CSV-files.
• Activated and installed GRC, 0PP *, 0AA *, 0FI GL 4, 0FI AR 4, 2LIS 11*, 2LIS 12*, and inventory movement 2LIS 03 BF business content with delta loads.
• Developed an extractor from an Oracle database using Ascential, which contains historical financial transaction data. The data are then stored in a customed Datastore (ODS) and summarized in a customed Infocube. Developed several queries for the financial group.
• Developed a BPS solution for the Italian Sales Commission calculation and adjustment.

BW Sr Developer

Confidential, Corona, CA

Responsibilities:

• BW-HR: Created a new infoobject based on 0EMPLOYEE to eliminate several sensitive attributes.
• SAP/BW support to troubleshoot encountered production issues.
• Loaded historical transactional billing data, as well as chargeback data from a non SAP system (CARS) for years 2002, 2003, 2004 into the ODS, Infocubes, including activating and refilling of the aggregates.
• Unit/String testing of new development of update rules, transfer rule, ODS, Infocube and Infoobjects.
• Remote support of the BW team.
• Analysis, design and development of Personnel/Sales Rep Marketing database to replace the lotus notes version.
• Analysis, design and development of new cubes and queries for the finance group for detail analysis of: indirect chargeback postings from the external application CARS quarter to date accruals and NASP (Net Average Selling Price) material costs and gross profit margin

Sr. ABAP Analyst / Programmer

Confidential, Foothill Ranch, CA

Responsibilities:

• Overall support of the business operations team in developing ABAP programs in FICO, MM, WM, SD and CRM.
• Technical BW support in modelling and development of BW objects (Cubes, ODS, Infoobjects, Update & Transfer rules, R/3 extractors, process chains, transports, queries)
• Developed complex ALV reports, custom online screens and transactions and custom Z-tables.
• Recoded ABAP programs for upgrade into ECC from 4.5.
• Developed RFC function modules for the CRM.
• Developed print programs for the barcode label printing.

BW Sr Developer

Confidential, Corona, CA

Responsibilities:

• Development of custom ODS, Infocubes and Infoobjects, as well as the utilization of the Transport Collector to collect the objects into a transport.
• Creation of process chains for the daily and weekly loads. Building and maintenance of aggregates.
• Initialized the setup tables and fill the setup tables, as well as the deletion of the deltas and scheduling of the delta update (Job Control) for R/3 extractors.
• Technical support of the BW environment, which includes troubleshooting of data loads into ODS and Infocubes and roll-up, as well as debugging the transfer and update rules.
• Developed complex BW BEX and Web-based queries for the Finance, Sales & Marketing executives.
• Modelled, designed and developed custom ODS, Cubes, Queries and workbooks for the Line- and Volume-Fillrate reporting.
• Analyzed, designed and developed the data upload of IMS data into BW, which includes custom ODS, Infocubes, Multi-provider and Infoobjects, as well as custom ABAP programs for the Decile and Calls & Frequency calculations
• Analyzed, designed and developed a bolt-on online application to SAP (Marketing Request System), which includes over 30 online transactions, over 20 dynamic screens, over 15 statistics reporting, real time interface to an external Chargeback and Rebates application (CARS) using db-link, and one file-interface for the pricing updates. This application includes also a custom built-in non-SAP workflow.
• Catalogued and mapped legacy data to SAP for data conversions of Customer, Material master, open sales orders and financial open items.