SUMMARY;

• SAP HANA Developer. Classes HA100, HA150, HA300, HA400, H450
• SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12) (C HANAIMP 12)
• SAP CertifiedApplication Associate - SAP BPC (C EPMBPC 10) - Business Objects Planning and Consolidation 10.0
• SAP HANA Architect/Configuration - SUSE Linux Enterprise on VMWare hosts for HANADB, ECC, BODS and SAP S/4 HANA Finance, SAP S/4 HANA Optimized for SAP BPC, SAP BW on HANA
• S4/HANA Embedded Analytics using Core Data Services Views (CDS) on S4/HANA module operational databases, BW/EDW and HANA VDM - Virtua; Data Models.
• Building Fiori Apps on top or real time transactional data, Embedded BW data and VDM.
• HP ALM - Application Life Cycle Management for testing in QA/DEV/PROD systems
• SAP FI - Financial Accounting Business Processes Configuration Consultant
• SAP CO- Controlling Accounting Business Processes Configuration Consultant
• SAP AA - SAP Asset Management Configuration Consultant
• SAP AP, SAP AR Configuration Customer/Vendor Masters
• SAP Bank Accounting Configuration
• Expert developing SAP BO Business Intelligence Report systems, reports, forms and dashboards using SAP BO Analysis for Office 4.2 - SAP AO - Analysis for Office- both AO addin and EPM adin.
• Extensive experience with Lumira and SAP BO Design Studio
• SAP BPC 10.1 Business Objects Financial Consolidation implementations, Blueprints for full financial statements in compliance with accounting methods GAAP, IFRS, IAS and LOCAL.
• SAP BPC K2RUNLOGIC configuration for custom Data Manager Package execution.
• Implemented SAP BPC since version 1.0 when it was called Everest/Outlooksoft, SAP BPC 7.0 NW/MS, SAP BPC 7.5 NW/MS, SAP BPC 10.0 NW/MS and SAP BPC 10.1 NW/MS
• SAP BPC - Business Planning and Consolidation with SAP BPC (7.0, 7.5, 10.0,10.1) versions subject matter expert with over 15 years of consulting experience focused on Enterprise Performance Management (EPM) Reporting, and Business Planning and Consolidation (BPC). Focused and expert on both Consolidations, Planning and Reporting
• SAP BPC / EPM 10.0/10.1 Global Consolidation Reporting Developer for Manufacturing companies
• SAP BPC 10 NW Consolidation Model System Configuration Consultant / Analyst for the following projects, QSI-Quality Software System, California, Confidential Confidential, Texas, Precision Drilling, Calgary, Phoenix Technology Service, Calgary, Confidential, Louisiana.
• SAP BPC 10 NW Consolidation Model System Configuration Consultant expert in setting up all the Consolidation objects required for Full Global Consolidation Process included in the Prepare Master Data, Collect Transaction Data, Pre-Consolidation - Reconciliation and Matching, Consolidation and Full Financial Reporting processes.
• SAP BPC 10.1 NW Embedded version installation, configuration. Integrated Planning Modeler Models development. Planning enabled queries. Development of SAP BPC Embedded environments, models, Dimension and local providers. IP planning functions development using FOX code and SQL Script. Development in EPM add-in Planning and Reporting, Analysis for office, and Design Studio
• SAP BPC 10.1 Embedded NW HTML and Web Reporting development and tasks configuration.
• SAP BPC 10.1 Embedded Data Audit, BPF and work status configuration and development.
• SAP BPC 10.1 NW Embedded - WNAUNI SAP Workshop
• SAP BPC 10.1 NW Embedded - Replicated and Real-Time RTC (S/4HANA) Consolidation Models
• SAP IBP RSPLAN Objects configuration and implementation
• SAP Simple Finance IBP configuration, modelling, calculation, sequences, data loads, retraction of budget data from SAP BPC into SAP IBP on top of Simple Finance
• SAP HANA Full Standalone Enterprise Installation on SUSE Linux
• SAP HANA Studio design and development of Attribute, Analytical and Calculated Views, including restricted and calculated measures, filters, input parameters, etc.
• SAP HANA Data Provisioning using SLT for SAP Data Sources and BODS for non-SAP data sources.
• SAP HANA Security design and implementation.
• Expert in Planning, Budgeting, Forecasting, Consolidation of Actuals, Data Governance & Compliance, BI Reporting and Global Consolidations using Record to Report processes approach for faster, accurate and built-in compliance checkpoints.
• Expert Solution Architect of SAP BPC Global Consolidation Environments based on simplified, standardized and automated Group subs and Total Global Consolidated Group Financial month end close using high performance database algorithms.
• Has led BP teams to analyse, design and develop budgeting, forecasting, and financial consolidation and analysis systems at close to thirty clients.
• Participated in multiple SAP BPC projects working several Project Team Roles such as Solution Architect, Lead Consultant, Application Consultant, Technical Consultant, SAP BI/BW/BADI Consultant, SAP BO Consultant, Project Manager, and Trainer.
• Implemented and tested customer solution and Technical support for SAP BPC Customized Application Solution. Principal consultant in designing and implementing solutions for key, large customers in the Confidential . Field advisor and consultant on solutions to pre-sales and consultants to maximize customer success.
• Designed, implemented and tested SAP RDS (Rapid Development Solutions) for Sales and Operations Planning (SA SOP)
• Designed, implemented and tested/retrieved data into Business Objects Analysis for Office - Excel Add-In and developed reports using direct connections to SAP BW InfoCubes
• Participated in sizing of SAP BPC 10 NW (CPMBPC 800) on SAP HANAPBC 800 software component and SAP BW 730
• Developed proof of concept running SAP BPC 10.1 NW (CPMBPC) on SAP HANAPBC 810 software component and SAP BW 730 SP6. Developed SAP BPC 10.1 classic and Embedded (BW-IP-PAK) models. Compare and Contrast both models and implemented Business Objects Analysis for Office for reporting and input schedules from BW Embedded model.
• Designed, Implemented, managed and tested Excel and BPC server-side applications
• Developed PCRS (Portfolio Company Reporting System) for global company subsidiaries to streamline master and meta data preparation, transaction data collection, consolidation process and reporting
• Developed single Form to produce/calculate rolling forecasts for any number of month combination of Actual and Forecast and for either Calendar or Fiscal Year. This applies to any data category.
• Developed an SAP Planning, Forecasting & Budgeting WIZARD to streamline SAP Forms generation for a Global company in New York City. This Planning Wizard features SAP Form development of any number of months Rolling Forecast, Plan or Budget. It allows building SAP Forms either for calendar or fiscal year, and it is customizable as to select the nested dimensions combinations that contains data in large Master Data Sets.
• Developed Free Form for Bloomberg to allow CFO business units to load forecast data directly from their third party forecast model software (non-SAP forecasting models)
• Developed interface between SAP BPC SQL Server and data from Bloomberg’s Terminal Services Business Area and Bloomberg’s TOMS Business Area to develop Drill Through interfaces from Financial Accounting Data to Operational Data.
• Developed SAP BPC 10.1 Classic and Embedded (SAP BPC BW-IP) proof concept for client in New York City
• Customized training class for BPC450 - SAP BPC Embedded Model design for Planning and Consolidation processes

TECHNICAL SKILLS:

Application Development Tools: SAP BI/BW Workbench, SAP ECC, SAP BO, MS Office Suite - Word, Excel, PowerPoint, Business Intelligence Development Studio (BIDS), SQL Server (SS) Management Studio, Integration Services, Analysis Services, Reporting Services, Sharepoint Server, Oracle Database Development Studio, Hyperion Applications Development Tools, QlikView Desktop and QlikView Analytics Platform, Qlick Sense for Cloud.

Application Package: 7 years - Outlooksoft BPC, 9 years - SAP Business Planning and Consolidation (BPC), 6 years - SAP BPC Custom programming

Databases / DB Tools: SAP HANA DB, HANA STUDIO, HANA LIVE, FIORI, SAP BI/BW Workbench, SQL Server, MS Analysis Services, SSIS, SSRS, Oracle, TERADATA, SYBASE, ESSBASE, TM1

Operating Systems: Windows Server 2000-2012, Windows XP, Windows Vista, Windows 7,8, UNIX

Programming Languages: VB, VB.Net, C#, C++, ASP, ASP.Net, Excel add-in, BPC Script Logic, SQL, MDX, XML, SSIS custom script, ABAP/BADIS

PROFESSIONAL EXPERIENCE:

Confidential - Global Manufacturing - Sr. SAP HANA DEVELOPER-Solution Architect & SAP BPC NetWeaver 10 Solution Architect - CONSOLIDATIONS & PLANNING Solution Architect & Developer

Morristown, New Jersey - February 2017 - December 2017:: Global Consolidations /Merger & Acquisitions Design & Development/ Global Restructuring Design & Development/ Global Intercompany Eliminations / SAP BPC API Programming / VBA Programming / FICO-BW-BPC Data Flow Design and Development - HANA Applications developed in HANA Cloud Platfrom. Designed and developed Capsugel HANA Global Currency Conversion Consolidation Process to integrate Lonza - Confidential Acquisition on the HANA Cloud Platform (HCP) for new cloud applications, On Premise application and Cloud Extensions for clients in non-HANA Environments. Designed and developed HANA Global Intercompany Elimination Process to integrate Lonza - Confidential Acquisition Designed and developed Global Tax Entity Elimination Process to integrate Lonza - Confidential Acquisition Designed and developed Reclassification of flows for PPE and other assets rollforwards Designed and developed Data Load Automation Master and Transaction data to integrate the Acquisition of Lonza - Confidential Designed and developed complete set of Consolidated Financial Statements to include the Acquisition of Lonza - Confidential Designed and developed complete set of Consolidation business rules to include the Acquisition of Lonza - Confidential Designed and developed complete set of script logic to include the Acquisition of Lonza - Confidential Designed and developed complete set of BPC reports to include the Acquisition of Lonza - Confidential Designed and developed complete set of BPC Input Schedules to include the Acquisition of Lonza - Confidential Designed and developed Month End consolidation Checklist steps to include the Acquisition of Lonza - Confidential

Confidential - Global Manufacturing - Sr. SAP BPC MS10 - CONSOLIDATIONS Solution Architect & Developer

- Houston, Texas - August 2016 - February 2017:: Global Consolidations /Merger & Acquisitions Design & Development/ Global Restructuring Design & Development/ Global Intercompany Eliminations / SAP BPC API Programming / VBA Programming / FICO-BW-BPC Data Flow Design and Development

Designed and developed Global Consolidation Process to integrate Axiall Manufacturing Company Acquisition Designed and developed Global Intercompany Elimination Process to integrate Axiall Manufacturing Company Acquisition Designed and developed Global Tax Entity Elimination Process to integrate Axiall Manufacturing Company Acquisition Designed and developed Reclassification of flows for PPE and other assets rollforwards Designed and developed Data Load Automation Master and Transaction data to integrate the Acquisition of Axiall Manufacturing company Designed and developed complete set of Consolidated Financial Statements to include the Acquisition of Axiall Manufacturing company Designed and developed complete set of Consolidation business rules to include the Acquisition of Axiall Manufacturing company Designed and developed complete set of script logic to include the Acquisition of Axiall Manufacturing company Designed and developed complete set of BPC reports to include the Acquisition of Axiall Manufacturing company Designed and developed complete set of BPC Input Schedules to include the Acquisition of Axiall Manufacturing company Designed and developed Month End consolidation Checklist steps to include the Acquisition of Axiall Manufacturing company

Ball - Confidential - Sr. SAP BPC MS10.1 - Solution Architect & Developer - Chicago, Illinois

- June 2016 - August 2016:: Forecasting / Custom Forms Reporting Project / SAP EPM API Programming, VBA Programming

Designed and developed complex Custom Input Forms Forecasting models using SAP EPM Application Programming Interface (API) objects. Used and implemented SAP EPM API function class libraries from EPMOFFICEACTIVEX, Designed and developed complex Custom Input Forms Forecasting models using Microsoft Visual Basic for Application (VBA) objects. Designed and developed Forecasting models using SAP BPC 10.1 for the Microsoft Platform. Data sources for the SAP BPC Microsoft models stored in Microsoft Great Plains GP ERP modules: AP / AR / GL with AFA - Advanced Financial Analysis - SQL Server 2012. Designed and developed new Business Process Flows for Forecasting models. Designed and developed new Business Process Flows for Sales Planning Forecasting model

Designed and developed new Business Process Flows for Sales Detail Forecasting model

Design complex Hybrid Forecast Input Forms to allow SAP EPM 10.1 to execute EVDRE functions while also retrieving SAP EPM Functions Improve performance of complex Forecast Input Forms by reducing the time of retrieval from 20 minutes to 2 minutes, allowing forecasters to maintain momentum and engagement in the forecasting process. Streamlined forecasting process across Product Sales Planning Customer Regions and Product Variety Lines allowing

forecasts to be completed on time and on budget.

Confidential - Pharmaceuticals-Manufacturing - Sr. SAP BPC NetWeaver 10.1 - HANA Solution Architect & Developer - Jersey City, New Jersey

- November 2015 - Apr 2016:: Consolidation & Planning Project, SAP BPC 10.1 NW on BW 7.5, and ECC6 (MM, FI-CO, PS, HCM, COPA) .

Designed and developed Consolidation and planning models using SAP RDS for USGAAP Financial Close / Consolidation and Planning Developed Budgeting/Planning model for Operating Expenses, Revenue, Headcount & Salary and Capital expenditures along with all the model-specific related objects: Reports, Interfaces, Conversions, Enhancements and Forms (RICEF) Developed complete Data Provisioning Flow inbound/outbound from SAP ECC / MM / 0MATERIAL/MARA/MARC tables to SAP BW to SAP BPC, including SAP BPC Budget Data Retractions to SAP ECC. Developed over 20 complex reports to support the Sales and Marketing Organization reporting system to produce Gross Margin P&L by Product manufactured. Develop complex SAP EPM Add-in 10.1 NW forms to support the models using built in SAP EPM Application Programming Interfaces to manage and reuse native SAP EPM add-in code along with built in Excel objects Enhance Confidential Budgeting/planning user experience by automating all the data interfaces so it made it simple and fast to execute their planning and consolidation tasks. Developed real time infocubes, aggregation level for entity rollups, functions, planning-ready queries, BPC models Developed several Web and EPM Add-In input forms and reports. Developed Unified Business Process Flows for annual Budgeting, Monthly Rolling Forecast for 18 months recurring and long term plans.

Confidential - Confidential - Dallas, TX- Hyderabad-India - SAP HANA Installation, Configuration, Design and Development - SAP HANA V1 SP09- SAP BPC 10.1 NW on BW 7.4, SAP data source in ECC6 (FI-CO, PS, HCM, COPA), Non SAP data sources in text files. November 2015 - January 2016.

SAP HANA Full Standalone Enterprise Installation on SUSE Linux on Development Server Environment. SAP HANA Studio design and development of Attribute, Analytical and Calculated Views, including restricted and calculated measures, filters, input parameters, etc. SAP HANA Data Provisioning using SLT for SAP Data Sources and BODS for non-SAP data sources. SAP HANA Security design and implementation.

Confidential - Confidential & Confidential - Confidential - Sr. SAP BPC NW 10.1 - HANA Solution Architect & Developer - Solution developed in both SAP BPC NW 10.1 Classic and Embedded/Unified - HANA Applications developed on HCP - HANA Cloud Platform(HCP).

- Minneapolis, Minnesota - May 2015 - November 2015 - Consolidation & Planning Project, SAP BPC 10.1 NW on BW 7.4, and ECC6 (FI-CO, PS, HCM, COPA) using SAP RDS SAP USGAAP SP03 for Financial Consolidation and Planning, and SAP BW on HANA.

All the applications were Designed and developed using HANA Cloud Platform for new cloud applications, On premise extenssions Designed and developed Consolidation and Budgeting models using SAP RDS for USGAAP Financial Close / Consolidation and Planning Developed new consolidation business rules for subsidiaries participating in company’s reorganization. Developed Budgeting/Planning model for Operating Expenses, Revenue, Headcount & Salary and Capital expenditures along with all the model-specific related objects: Reports, Interfaces, Conversions, Enhancements and Forms (RICEF) Develop complex SAP EPM Add-in 10.1 NW forms to support the models using built in SAP EPM Application Programming Interfaces to manage and reuse native SAP EPM add-in code along with built in Excel objects Enhance Budgeting/planning user experience by automating all the data interfaces so it made it simple and fast to execute their planning and consolidation tasks. Developed Embedded models on real time infocubes using aggregation levels for entity rollups, functions, planning-ready queries, BPC models Developed SAP BPC Embedded models using SAP BW-IP Real Time Infocubes and local infoproviders for adhoc planning for users and planning enabled query on local Aggregation Level infoproviders for Planning SAP Sales&Distribution BW-IBP model to plan for Sales Volumes, Quantities, and Revenues per Distribution Channel, Segment and Business Areas. The SAP S&D IBP model was designed using current year and last year Aggregation slice by Account, Entity, Category, Product, Segment, Channel and Business Areas. Develop IBP Models based on Planning Areas for S&D, S&OP using Master Data Attributes, Master Data Types, Time Profiles specific for Forecast, Planning Levels (Base-Level), Key Figures and Operators Developed FOX formulas to calculate Plan Revenues based on Quantity and Price plan per segment, Channel and Products. Developed IBP Planning Functions for Copying/Calculate functions for the aggregation Level at Material Groups, also the repost and distribution IBP Functions. Develop templates for IBP Planning Areas using the IBP Addin for Excel. Developed Planning Functions, Sequences for step by step planning. Developed several reports and forms using the EPM Addin for SAP BPC Embedded models. Developed planning functions using AMDP (ABAP Managed Database Procedures) Developed Embedded Business Process Flows. Developed SAP BO Universes to source Reports for BW and BPC Developed SAP AO (SAP BO Analysis for Office) reports sourcing data from SAP BO, BW and BPC Developed several Web and EPM Add-In input forms and reports.

Confidential Confidential - Confidential - Sr. SAP BPC NW 10 - HANA Solution Architect & Developer

- Houston, Texas - January 2015-April 2015 Consolidation Project, SAP BPC 10 NW on BW 7.4 ehp1, and ECC6 (FI-CO, PS, HCM, COPA)

Reviewed and modified Consolidation model script logic for the Intercompany eliminations Developed new consolidation business rules for subsidiaries participating in company’s reorganization. Worked on the business transfers plan Developed business transfers plan template Requirement Gathering form Acquisitions and merger Statistical information that is in PeopleSoft GL brought into the Confidential Confidential Supplemental information for the Merger with USF and Confidential SAP BW databases migration to SAP HANA to gain SAP HANA DB efficiencies on speed, calculations, data provisioning and reporting performance The SAP HANA 1.0 installation option was SAP BW on HANA to leverage existing SAP BW standard infocubes and its data provisioning from SAP ERP via SLT and DXC All the major infocubes from SAP BW 7.4 were migrated including SAP BPC infocubes to support consolidation and planning and take advantage of SAP HANA built in features. SAP BPC EPM Addin tool were used to produce reporting for Actuals and Budget and Analysis for office as well. SAP HANA Data provisioning tools used were SLT AND DXC. The SAP BPC 10.1 - BW on HANA implementation were done in development environment as a side by side implementation with SAP BPC 10 NW.

SAP Confidential – OIL & GAS - Sr. SAP BPC Solution Architect & Developer

– Calgary, Canada –November 2013- December 2014 – Custom Sales Demo for MEG Oil Services - SAP BPC 10 NW .

Customized SAP Americas Sales Demo to integrate existing Master Data, Transactional Data, Business Processes, Logic Scripts, Business Rules, Forms, Reports, Security Data Manager Packages and business process flows from MEG Canada prospective client. All the RICEF objects were customized to implement the prospective client business processes and showed and effectively proved that SAP BPC 10 NW successfully satisfied all MEG Canada Functional and Technical deliverables. We implement all MEG Canada Business Processes using SAP BPC 10 NW Business Process Flows in the Web client. The demo touched ALL the SAP BPC 10 NW features to support both MEG Canada Planning and Consolidation recurrent processes The SAP HANA 1.0 installation option was SAP BW on HANA to leverage existing SAP BW standard infocubes and its data provisioning from SAP ERP via SLT and DXC All the major infocubes from SAP BW 7.4 were migrated including SAP BPC infocubes to support consolidation and planning and take advantage of SAP HANA built in features. SAP BPC EPM Addin tool were used to produce reporting for Actuals and Budget and Analysis for office as well.

Precision Drilling - Sr. SAP BPC Solution Architect & Developer

– Calgary, Canada –October 2013 - November 2014 Planning/Budgeting- Consolidation Project, SAP BPC 10 NW on BW 7.3 ehp1

Accomplished the following client deliverables:

Solution Architecture scoping the project from the functional and technical perspective Developed complex report to support multi model data in SAP EPM BPC 10 NW Consolidation, Planning, Budgeting and Forecasting and Reporting Environment with 4 models – Consolidation, Rate and Ownership and non-financial data Developed EPM 10 reports using SAP BPC 10 NW:: EPMOfficeActiveX, FPMXLClient and FPMXLClient OLAPUTILITIES VB/SAP BPC NW libraries. Developed custom reporting to show variances in Intra/Intercompany eliminations to help analysts in MonthEnd Close process. Consolidated financial statements reports using SAP EPM reporting framework – SAP EPM Addin. SAP EPM Data Manager Packages SAP EPM Consolidation script logic including eliminations, balance carry forward, equity pickup, currency conversion, reclassifications, journals, and allocations. Custom SAP EPM Data Manager Packages to support month end consolidations and KPI dashboards

Confidential - Sr. SAP BPC Solution Architect & Developer

– Calgary, Canada –October 2013- December 2013 Planning/Budgeting- Consolidation Project, SAP BPC 10 NW on BW 7.3 ehp1

Accomplished the following client deliverables:

Scoping the project from the functional and technical perspective Developed models for Annual Budgeting, Quaterly Rolling Forecast 18-14 Months, and long term capital plans for Oil & Gas Plants. SAP EPM Consolidation script logic including eliminations, balance carry forward, equity pickup, currency conversion, reclassifications, journals, and allocations. Installation of SAP BPC 10 NW on BW 7.31 Security set up SAP BW roles, profiles, authorizations set up SAP Business Rules set up for eliminations, CTA, Calculation Accounts and Currency Conversion SAP Script logic development for eliminations, CTA, Calculation Accounts and Currency Conversion Data Manager Packages development for eliminations, CTA, Calculation Accounts and Currency Conversion

Confidential - Sr. SAP BPC Solution Architect & Developer

– Calgary, Canada – April 2013- November 2013 Planning/Budgeting- Consolidation Project, SAP BPC 10 NW

Accomplished the following client deliverables:

SAP BPC 10 MS Installation/configuration support SAP EPM BPC 10 MS on SQL Server SSAS 2008 R2 Consolidation, Planning, Budgeting and Forecasting and Reporting Environment with 3 models – Consolidation, Rate and Ownership. Developed models for Annual Budgeting, Quaterly Rolling Forecast 18-14 Months, and long term capital plans. Consolidated financial statements reports using SAP EPM reporting framework – SAP EPM Addin. Custom reports using VB on SAP EPM Input and report templates SAP EPM Data Manager Packages SAP EPM Consolidation script logic including eliminations, balance carry forward, equity pickup, currency conversion, reclassifications, journals, and allocations. Custom SAP EPM Data Manager Packages

Confidential - Confidential - Sr. SAP BPC Solution Architect & Lead Developer

– Irvine, CA – January 2013 – May 2013- Consolidation and Planning Project, SAP BPC 10 NW on SAP BW 7.3

Accomplished the following client deliverables:

SAP EPM BPC 10 NW on SAP BW 7.3 Consolidation, Planning, Budgeting, Forecasting and Reporting Environment with 3 models – Consolidation, Rate and Ownership. Accomplished all Planning, Budgeting, Forecasting and Reporting in the Consolidation model to achieve less model maintenance time and costs. Implemented COGS rates as the planning driver. Consolidation legal application set up for 4 legal subsidiaries with 2 local currencies. Consolidations for intercompany eliminations were configured following Confidential Eliminations Business Rules and currency translations based on Actuals data loaded from SAP ECC into BPC SAP BPC Data Manager packages for Master Data, Texts, Attributes and Hierarchies SAP BPC Data Manager packages for transaction data from SAP BW 7.3 Infocubes - from 0FIGL, 0COPA, 0CCA Infoproviders. Develop SAP BPC Revenue Model, provisioning Actual data from SAP COPA for the Sales Organization. Data from COPA contained data for Products sold, Customers, Order Details. This SAP BPC Model was developed for the Sales Department to identify best Product/Segment distribution, Product Profitability, Contribution Margin per product and Sales Forecasts. SAP BADI, for retraction to ECC and data loads into BW Planning, Budgeting and Forecasting also were implemented within the Consolidation Application. One SAP BPC EPM model to service Consolidations, Planning, Budgeting, Forecasting and Reporting Implemented custom application to flag the last changed cells in SAP BPC EPM Input forms. Implemented Security in SAP BW 7.3 – created profiles, roles and authorizations and custom roles. Implemented Security Matrix in SAP EPM BPC web administration Environment with 3 models – Consolidation, Rate and Ownership. Consolidated financial statements reports using SAP EPM reporting framework – SAP EPM Addin. Custom reports using VB on SAP EPM Input and report templates SAP EPM Data Manager Packages SAP EPM Consolidation script logic including eliminations, balance carry forward, equity pickup, currency conversion, reclassifications, journals, and allocations. Custom SAP EPM Data Manager Packages Trend, %Revenue, Business Segment, Flash Month Prior Month, Quaterly, YTD, Variance reporting Actual Vs Budget

Confidential – Boston, MA – November 2012 – December 2012 - Sr. SAP BPC Solution Architect & Lead Developer

Accomplished the following client deliverables:

· Provided the required understanding on how the current BPC environment is set up so that to replicate the BPC 10 NW system set up in a SQL database via construction of stored procedures, common table expressions, SQL functions, and front end application to Microsoft Excel and SQL Reporting Services.

· Provided the know-how on BPC to create profitability reports on SAP BW 7.5 SP3.

· Identified all the tables in BPC which store the required data.

· Mapped the data elements in BPC to the required elements in BW 7.5 SP3

· Defined any conversions that must occur to translate values in BPC 10 NW to BW 7.5 SP3

· Defined how the BPC functions like EVGTS can be replicated in BW 7.5 SP3

· Defined the key members for each dimension in SAP BPC 10 NW that will drive the data extraction

· Designed and document methods that will allow ModusLink users to manage the ongoing mapping of data in SAP BPC 10 NW to BW 7.5 SP3

· Documented the formulas to create key statistical data such as REVENUE, VAR, Contribution Margin, %age of Revenue, Gross Margin, GM% and Operating Income

· Designed and document the technical elements that will need to be created to produce the data each month to be loaded to BW 7.5 SP3

· Provided technical design document to SAP BW 7.5 SP3 and SQL Server Team to replicate SAP BPC 10 NW functionality in SAP BW 7.5 SP3.

Confidential ( Confidential ) Arizona – January 2012 – October 2012- UTILITIES

Sr. SAP BPC Solution Architect & Lead Developer

Senior SAP EPM 10 – BPC 10 NW Project Solution Lead Architect/Developer. Assessment, scope, design, build of SAP BPC NW 10 Planning, Budgeting and Forecasting Environment, Models and accounting processes. The BPC system was built in SAP ECC 6 landscape with SAP BI 7.3 NW for a big-4 SAP Green Field Project

• Operating expense planning and budgeting for the annual budget and multi-year plan
• Capital planning and budgeting for the annual budget and multi-year plan
• Development of the key management multi-year reporting package including: Cost Statement, Balance Sheet and Cash Flows Statement (called Master Financial Plan) along with monthly Cash Forecasts
• Operating expense, capital, and financial forecasting for a 24-month horizon
• Business process changes; validation processes
• Installation and configuration of SAP BPC 10 NW on Development environment
• Designed/Develop SAP BPC Revenue Model, provisioning Actual data from SAP COPA for the Sales Organization. Data from COPA contained data for Products sold, Customers, Order Details. The COPA model was used to source the Monthly Sales Contribution Margin Dashboard, Sales Order Details Reports, provision data for the Budget, and the CFO Flash Dashboards.

Confidential – Dallas, Texas – March 2011 – October 2011 - Sr. SAP BPC LEAD

Blueprinting technical approach to Update SAP BPC-EPM Microsoft applications into SAP BPC-EPM NW 7.0 and SAP BPC-EPM NW 7.5. Develop BRD (Business Requirements document) and TRD (Technical requirements document). Scope project in phases, resources and timeline and post production tasks and maintenance document. Also, developed SAP BO FIM apps to integrate source applications such as SAP ECC and SAP EPM BO Suite of application (XI 3.1-3.2) such as SAP BO BPC (Business planning and consolidation), SAP BO PCM(Profitability and Cost Management), SAP BO Sales and operations planning, etc. We used SAP BO FIM which uses SAP BO DataServices as the ETL tool to move Source data to Target data using mapping tables. Also developing SAP BO FIM jobs that loaded data from SAP dataSources to Target. Developed Xcelsius dashboards using data from SAP BO EPM applications via the SAP BPC connector via Excel Add-in Extended Analytics Analyzer that allows connecting SAP BO EPM Applications and feed data into Xcelsius cockpits and dashboards.

–Bloomberg – New York City, New York. – April 2010 – February 2011 - Sr. SAP BPC Solution Architect & Lead Developer

• Managed and Developed SAP BPC-EPM 7.0 Microsoft built 7.0112 (ex Outlooksoft) in a dev server and then Developed/migrate in SAP BPC-EPM 7.0 NetWeaver built 7.5 (ex Outlooksoft) Budget Process, planning and reporting.

–JC Penney Company, Inc. – Plano- Texas – December 2007 – October 2009. - Sr. SAP BPC Solution Architect & Lead Developer – Budgeting & Forecasting & Consolidations & Reporting

SAP BPC-EPM Outlooksoft 5.1(BUILDS 486, 502) and SAP BPC-EPM 7.0 SP3 lead developer. Developing project tracking system for IT projects across JC Penney Company, Inc. IT departments and Finance department. The finance application set will be rolled out for budgeting and forecasting to over one thousand stores throughout the country. The IT application supports forecasts by project across different IT groups within JC Penney organization. Designed Microsoft SSIS packages to support the data load from FMS (system that holds data for software and capital expenses), Teradata, Oracle Project Accounting (system that holds data for software in an expense basis), and Microsoft Project Server which holds data for hours and rates for contractors, consultants and associates. Develop several journal entries templates, intercompany elimination schedules, and allocation logic to manage the consolidations across projects. The ERP data source for this application is JD Edwards/PeopleSoft, Khalix, Oracle Project Accounting and FMS. Developed JC Penney Directors project detail forecast, reports and MDX calculations as well as logic to load data via SQL server Integration Services Packages (SSIS). Develop SAP BW info packages to load transactional data, master data including SAP BPC-EPM characteristics, Attributes and text into SAP BW PSA and then develop the DTP (Data Transfer Processes) to load into SAP BPC-EPM NetWeaver InfoCubes. Develop the process chain to schedule the data loads into the BPC-EPM NetWeaver infocubes. Integrate Data Extraction using Teradata nodes to import Master data and data into SAP BPC for planning, consolidations and monthly forecast. All reporting designed and developed using Business Objects Enterprise XI, Webi, and Xcelsius. Business Objects Self-Service reporting implemented using customer specific Universes.

Migrate Cartesis set of financial consolidation reports into SAP BPC. The Cartesis migration consisted in all the Month End consolidation reporting, Management Reporting, Flash reporting, Blue book reporting for the CFO and the Board of directors.

Migrate all the set of Cartesis Business Rules to SAP BPC, Cartesis script logic and data load and Cartesis Journal entries tables and report sets.

– Confidential – Los Angeles- California – September 2008 – November 2008. - Sr. SAP BPC Lead Developer

Worked on a proof of concept to show SAP BPC-EPM features to Confidential senior management. In the proof of concept I developed a cube based on actual data provided by Confidential . The model was based on Confidential key performance indicators and its concept of Confidential media ultimates calculations and its corporate planning. The proof of concept model consisted of following dimensions (Accounts, Company, Contracts, Customers, Deal Type, Markets, Products, Currency, Territory, time and version. The proof of concept also required to develop the input templates, reports and calculations.

– Confidential, Inc. – San Jose- California – July 2008 – December 2008. - Sr. SAP BPC Solution Architect & Lead Developer – Budgeting & Forecasting

SAP BPC-EPM Outlooksoft 5.1 SP 03 (Build 5.502) technical-functional lead developer. Developing planning application for the financial planning department to manage Human Resources Expenditures, Operating Expenses, and Capital Expenditures by account, functional department, division and legal entities. The application supports monthly annual forecasts by functional departments. The application set was migrated from Hyperion Planning 9.1 database and converted into SAP BPC-EPM 5.1 application set. Currency translation was also implemented to support the foreign divisions. Develop the data architecture environment to extract data from SAP BI into SAP BPC-EPM fact tables. Project also required developing Bapi object to retract data into SAP BI from SAP BPC-EPM. Develop several SQL classes and visual basic routines to accomplish the drill-down logic for the input templates based on the location, legal entity and cost centers dimension intersections.

– Confidential – Houston- Texas – April 2007– October 2007 - Sr. Hyperion Solution Architect & Lead Developer – Budgeting & Forecasting

Designed and migrated Hyperion System 9 application Link processes into Data integration Management (DIM). Design Hyperion Server infrastructure for Hyperion planning, HFM. Built CAPEX planning cubes, design ETL routines from different data sources. Design, develop Workforce planning application for human resources planning and impact analysis on income statement applications. Technologies used Hyperion System 9.3.0.1 suite of products. Develop HAL process for project generation and GL account mapping. Design a Microsoft ASP page to allow users to enter projects description remotely. This ASP page will integrate with HAL executable in order to move project and GL numbers to Hyperion System 9 planning and Analytical Administration Services. Designed Hyperion System 9 planning web forms, business rules, and MAXL and ESSCMD scripts. Developed reports using Hyperion System Web Analysis, Financial Reporting and Interactive Reporting.

– Confidential – Baltimore- New York – November 2006– February 2007 - Sr. SAP BPC Solution Architect & Lead Developer - – Budgeting & Forecasting

Redesigned CNE (Constellation New Energy) Appset using Outlooksoft. User training development, test cases to validate all input and report templates, ETL procedures using Microsoft SQL Server 2000 DTS. Design a .NET visual basic application to automate the development of the CEO monthly financial report. Developed several MDX calculations to get the weighted averages for metrics such as Weighted Average Gross Margin, Weighted Average Term. Develop .NET application to execute Hyperion Essbase 7.0 API functions via WebServices.

– Confidential – New York City- New York – July 2005– October 2006 - Sr. SAP BPC Solution Architect & Lead Developer

Develop Portfolio Company Reporting System (PCRS) Outlooksoft CPM. The portfolio reporting system increased operational and strategic oversight of Private Equity’s Portfolio Companies (“PC”). This is accomplished by obtaining timely and appropriate financial and key operating information directly from each PC and Banker through the portfolio reporting system developed. This system produces presentation quality reports for monthly financial reporting packages, annual LP Advisory meetings, quarterly portfolio reviews, and other internal/external meetings. Technologies used in this project, Microsoft .net 2003 to write .NET WebServices calls to Outlooksoft CPM, transact SQL for data loads and Microsoft ASP .net. Develop data extraction procedures to move data from Hyperion Essbase into Microsoft Analysis Services. Develop .NET application project named “PCRS” which keeps track of approval status for Entity, Scenario (such as budget, actual, or forecast) and time period dimensions. It uses webservices functions to determine the status of the data intersection as follows: Submitted by Inputter, Submitted by Reviewer, Approved by Blackstone, Rejected by Reviewer and Rejected by Blackstone. Develop Portfolio Company Reporting System (PCRS) client using an Excel Add-in to allow Outlooksoft administrators to add and/or delete portfolio companies as they are bought or sold. Other technologies used for this project: Hyperion Essbase 7.0, Business Objects, JD Edwards. Developed .NET applications to automate remote client tasks using Hyperion and Microsoft Analysis services using WebServices.

– Confidential – Morgantown- West Virginia – March 2005– June 2005

Report and input schedule remap and development to support existing Outlooksoft-SAP BPC EAP applications. Develop complex reports using visual basic object to support Account Receivable credit analysis, estimated net sales reports, finance corporate analysis implementing dual drill down from entity dimension into account dimension. Develop monthly Accounting reporting package including dynamic line and pie chart graphs, net sales trial balances, statement of earnings, Other Assets and intangibles. Upgrade from EAP into Everest 4.2 is under development.

– Confidential – Harrisburg- Pennsylvania – Jan 2005 – March 2005.

Development Cognos DataWarehouse using Cognos Eapps for JD Edwards. Developed cubes for sales department for forecast, reporting and consolidations. Developed automated process to feed DataWarehouse from SQL Server JDE transactional databases using Cognos Decision Stream. OLAP cubes were designed using Cognos Transformer and Impromptu query definition files, data from JDE Edwards is loaded into Cognos datawarehouse via nightly SQL agent jobs, cubes are refreshed via Cognos scheduler. Cubes support forecasting, daily sales, retail analysis, Siebel deductions and customer profitability.

– Confidential – Atlanta- Georgia – October 2004 – January 2005.

Development/Maintenance/ DataWarehouse and OLAP database for budget/forecast, reporting and consolidations of Evian worldwide operations. Developed automated process to feed DataWarehouse from IBM DB2/ JDE transactional databases. OLAP cubes were designed using Hyperion Essbase 6.5; data from DataWarehouse is loaded into Hyperion Essbase via nightly batch processes to refresh cubes. Develop several .NET applications to execute Hyperion Essbase API functions via WebServices. Tasks such as running Essbase Calc Scripts from remote offices were possible using .Net WebServices.

Confidential - Atlanta, Georgia - September 2004 - December 2004

Senior technical TM1/Applix developer. Implemented Applix/TM1 cubes by extracting data from Oracle Financials. Developed input and report templates using TM1 Microsoft Excel add-in. The implementation also required to deploy the excel templates over the web, by using Applix web components. The project also required ETL automation to load TM1 Applix cubes via nightly process from Oracle Financials general ledger. Develop ETL routines using HAL (Hyperion application link) to load data into Confidential to CFO monthly reporting package.

– Confidential – New Orleans- Louisana – May 2004 – September 2004.

Develop OLAP management reporting system for reporting, budget/forecast, eliminations and allocations processes using Everest Outlooksoft-SAP BPC. Developed custom reports and input templates to automate the budget and forecast process. Design and implement load process and transaction drill through process for all field offices in the country. Developed portal with business performance management key performance indicators to support business decisions for headquarters and field offices. Develop several custom MDX calculated dimension members to support related calculations between balance sheet and income statement accounts. Developed ETL packages to export SRC data into Outlooksoft-SAP BPC.

– Confidential – Los Angeles - California January 2004 – April 2004

Convert existing mainframe reporting-budget/forecast information system into an OLAP based reporting – budget/reporting system based on Microsoft Analysis Services using Everest Outlooksoft-SAP BPC as a front end. Developed metadata and load process to support budget and forecast processes. Developed American Golf Web Portal to allow CEO, CFO and field managers to access actionable information. Developed daily data loads as well drill thru to transactional databases. Developed several custom MDX dimension members.

– Confidential – Houston Texas – June 2003- December 2003

Senior technical Outlooksoft-SAP BPC developer. Developed BP/Amoco business performance management portal. Budget and forecast input templates were developed to support business budget and rolling forecast procedures for headquarters and field offices. Developed custom reports and input templates to support business analysts. Developed BP/Amoco deep water business performance key performance indicators analysis tools to support business decisions making for budget and forecast and reporting for CFO. Developed load processes and data warehouse integration ETL procedures.

Confidential - Atlanta, Georgia - August 2001- May 2003

Senior technical Outlooksoft-SAP BPC developer. Developed Confidential budget, forecast and reporting OLAP cubes. Developed headquarters budget input template and field budget input templates as well as forecast input templates. Also, several drill-down reports were built to drill into detail accounts for expense and revenue accounts. Field budget input template deployed to over 100 field offices around the country, it will allow business analysts to submit and retrieve budget data from centralized data warehouse and several Essbase Cubes. Developed Confidential Managers Analytical Portal, for Finance department, using a combination of ASP pages and static HTML reports. Allocation templates were created to zero out expenses from corporate headquarters and debit them to the field based on statistical drivers. Developed a visual basic script using DSO objects to automate writing domain login ids into the databases roles. Project also required periodically data and metadata sync between Essbase cubes and Microsoft Analysis services cubes to that purpose I built an Essbase VBA API template to retrieve metadata changes from Essbase cubes to find changes in metadata and data. Managed more than one hundred budget analysts across the country to perform budgeting tasks using templates I designed.

Confidential - Dallas, Texas - May2001 - August 01, 2001

Senior technical Outlooksoft-SAP BPC developer. Developed over 100 budget input templates incorporating the first ever use of sum of conditional EvSnd' across multiple cost centers and multiple expense and revenue drivers. The project also required building several report templates in WebExcel. The implementation also required to deploy the excel templates over the web, by using Outlooksoft-SAP BPC web components. Another goal of this project was to deploy the budget process over the web so field managers can revise and enter budget data using My Outlook.

Confidential - Dallas, Texas - April 2001 - May 2001

Senior technical TM1/Applix-SQL Server 2000. Implemented Applix/TM1 cubes by extracting data via SQL stored procedures from MS SQL Server 2000 databases The project also required building several budget templates in Microsoft Excel and have those templates connected to Applix/TM1 cubes. The implementation also required to deploy the excel templates over the web, by using Applix web components.

Confidential - San Francisco, California - March 2001 - April 2001

Senior technical Outlooksoft-SAP BPC developer. Implemented Microsoft analysis services cubes by extracting data via DTS (data transformation services) from Oracle data marts (data marts were build using Informatica) into 2 cubes. Budgeting/Planning cube and currency exchange cube. The project also required building several budget templates in Everest WebExcel. The implementation also required to deploy the excel templates over the web, by using Outlooksoft-SAP BPC web components. The goal of this project was to deploy the budget process over the web so field managers can enter budget data from their laptop offices.

Confidential - Dallas, TX - March 2001-April 2001

Senior technical lead. Built a visual basic for application front-end for budget analysts. The program allows analysts to insert or update rows in the budget database tables (Sql server 2000) by entering data directly into a programmatically customized Excel spreadsheet. Data sources for this project included Essbase cubes data, SQL server transaction tables, and multiple text files and CSV files.

Confidential & Confidential, TX - April 2001-July 2001

Senior technical lead. Implemented Comshare DecisionWeb using Microsoft SQL server 2000 transactional tables and Microsoft analysis services cubes. Developed multiple views of operational data, accounting and key operating indicators.

Confidential - Dallas, TX - Jan 2001-March 2001

Senior technical essbase/api visual basic developer. Built a visual basic program that automates collection of data from hundreds of Microsoft Excel Spreadsheets sent to headquarters from field offices. The program read, transform and load the data into a summarized Essbase cube. In addition the program is to run scheduled weekly directly from the server located in headquarters.

Confidential - Houston, TX - June 2000- Dec 2000

Senior technical Hyperion Essbase lead for 4-man team. Implemented Hyperion 6.0 models for a national known plastics manufacturing company. Exported data out of SAP via Acta (ETL tools). Implemented numerous DataMarts from Financial to Sales for this corporation using Hyperion Integration server. The data was extracted from Oracle tables and loaded into Essbase via HIS. Designed a corporate-wide information system using Arcplan - Dynasight 3.0 (a GUI application that allows clients to interact via web and client server). The system allows all the departments in the corporation to access its own data via the corporate intranet. In addition, customer will be able to log in to this system via Intershop Enfinity e-commerce application that is linked to Arcplan via HTML and ASP pages. The project also required the development of several Essbase API applications to automate the generation of balance sheet, income statement and ad-hoc reports for the analysts in the corporation.

Confidential - Dallas, TX - August 2000- Dec 2000

Senior technical Hyperion Essbase developer for the developing of several Essbase 6.0 database emphasizing the using of attributes for the second largest hotel holdings co. in the United States. This project required collecting data from a variety of sources coming from different management companies. The majority of data resides in SQL server 7.0/2000 databases that were extracted via automated DTS packages and then loaded into Essbase. Developed an enterprise information system using Hyperion Analyzer 5.0. The system uses the corporate intranet for access and helped the asset management team and top officers to access key operating data from their laptops. Several Crystal reports were also designed and developed in this phase.

Confidential -Home - Houston, TX - August 2000- October 2000

Essbase API developer for Microsoft Excel front-end menu for the second largest homebuilder in the United SThe system allows analysts to produce balance sheets, income statement and ad-hoc reports without retrieval sheets. The front-end saved significant amount of time and helped analysts to concentrate in analysis rather than in extracting and manipulating corporate data designed and developed a visual basic program that automates the collection, calculation and loading of data into Essbase. The program read over 100 spreadsheets sent from the divisional offices, performed calculations and consolidations and then via a batch file loaded the data into Essbase.

Confidential - Houston, TX - January 2000- June 2000

Lead Developer for first documented Showcase implementation via Lawson Analytical Architect. Built DataMarts from financial through productivity models. Requirements included full lifecycle development from project plan, through database design and implementation and training. Automation via Visual Basic and other administration tools. Front-end delivery via Wired for OLAP – Hyperion Analyzer.

Confidential - Dallas, TX - December 1999- February 2000

Designed an enterprise-wide operational statistical and financial planning application that provides upscale travel services from love field to national locations. The solution was built in a UNIX environment using Hyperion Essbase OLAP Server as the foundation and included Hyperion Essbase Excel Spreadsheet Add-In and Wired For OLAP for the UI, Visual Basic for Applications for administrative tools.

Languages: English, Spanish, Italian