EXECUTIVE SUMMARY:

• Over 13 years of professional experience in Project Management and Consulting leading Full Life Cycle Financial Planning and Consolidation Implementations in SAP HANA/BPC / BW.
• In - depth knowledge of Financial Planning and Consolidation processes.
• Extensive experience in programs and projects management and thorough understanding of the quality assurance, configuration management, and change control processes in accordance with SAP ASAP methodology
• Experience in SAP HANA data modeling (Attribute View, Analytic view and Calculationview), Data Provisioning using SLT and BODS replication.
• Worked on SAP HANA Security including User mangement, Roles and Privileges
• Worked extensively on Migration Projects from SAP BPC 5.xM/ OLS4.2/Hyperion/ESSBASE to BPC HANA/SAP BPC 7.5 NetWeaver/ BPC 10 MS.
• Worked on Installation of SAP BPC 7.0,10 NM/M versions on a multiple application server environment intended for wide delivery to a number of different clients, worked through bugs and limitations inherent in the software.
• Extensively worked in SAP Reports, BDC, LSMW, Smart-forms, Interfaces, SAP Script, Conversions, Menu Painter, BADIs, User Exits, Dialog programming, Data Dictionary and ABAP query.
• Expertise in creating DTS/SSIS Packages for Data Migration from several sources like SQL Server 2000/2005, UDB DB2 and Flat file

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SAP HANA Architect

Environment: Data Services (BODS) 4, SQL Server 2008, SAP ECC /BPC 10.1 NW/ HANA 1.0 SP7

Responsibilities:

• Architecting a HANA solution for the OLAP analysis through leveraging data from source systems.
• Completed the Sizing process to identify the HANA software hardware configuration with respect to the present BPC environment.
• Working with the business stakeholders to understand enterprise reporting requirements.
• Configured SLT/BODS data replication for getting Operational data to HANA DB from SAP ECC Applications.
• Created SAP HANA Information Models for Finance and COPA Scenario.
• Developed SAP HANA Analytic Views for components of Consolidation and assisted in the analysis of reporting requirements, conduct fit/gap and post-implementation support.
• Worked with the BASIS Team on DXC Configuration so that the BW Standard Extractors can be used.
• Configured BPC Master Data Update process that could be run through Package Link in BPC to update Dimensions Account, Cost Center, Cost center and Profit Center.
• Worked on fixing and creating many EPM reports that were needed by the business.
• Demonstrated BPC NW on HANA by migration their consolidation cubes into the HANA Landscape.

Confidential

SAP BPC/HANA Architect

Environment: SAP BPC 10 NW, SAP BI 7.3/7.4, SAP HANA 1.0 SP7

Responsibilities:

• Technically worked on Architecture of Applications of BPC on HANA and reports on EPM 10.
• Worked on getting data into the HANA using SLT, SAP BO Data Services and DXC replication techniques.
• Completed the parallel Consolidation process and compared number to the BPC 10 NW version to that of BPC on HANA for the month of Jan 2014 to April 2014.
• Implemented the Consolidation application that could generate the group Financial Statements as per the IFRS.
• Worked on getting GL Balances into BW Cube BOFC01 using standard Data Source FI GL 10.
• Used the BPC Packages that could do the automated Master Data/Hierarchy load and Transactional load from BW system.
• Worked on getting Balances into ECC using BAPI for the Entity that were not in the ECC System so that when a single package is run the entire data for all the entities flow instead of a manual process that was done by business users before.
• Configured the BPC Objects on the Currency Conversion, IC Eliminations, Business Process Flow, EMP Reports and other BPC Object
• Manually reconciled loaded balances to that of ECC and worked on getting the consolidation process run for the months of DEC.2012 to APR.2013

Confidential, Universal City, CA

SAP BPC Solution Architect

Environment: SAP BPC 7.5 SP09

Responsibilities:

• Lead the Installation of SAP BPC 7.5 SP09 Upgrade.
• Lead team on and off shore in Migration SAP BPC 7.5 SP06 system to SAP BPC 7.5 09
• Worked on the 3 issues in Production
• Dimension updates and Report execution was causing an error on a Node of QA. Email Task on back end package was fixed with dynamic parameters.
• The OLS Admin Task on the Packages that was causing error on the tbllogs tables was fixed.

Confidential, Nashua, NH

SAP Functional BPC Architect

Environment: SAP BPC 7.0 MS, SAP BPC 10 MS

Responsibilities:

• Worked on the complete Installation of SAP BPC 10 SP4 Version on the Production Box.
• Worked with the Windows Team in getting the Windows Server 2008 R2 Server 64-bit OS installed.
• Captured the Installation Step by Step procedure on an Excel document which included the hardware requirement, Pre Installation Prerequisites and Post-Installation steps.
• Completed the parallel testing with the Dev. Box for a month end close for all the SAP BPC objects.
• Created LegalApp for the consolidated purpose to work the Financial Reports such as Balance Sheet and Income Statement in three months’ time.
• Developed Customer Currency Translation Stored Procedure on backend SQL Server for the Currency Translation from local currency CNY, TWD to reporting currency USD so that it could include all the business requirements.
• Developed IC Elimination Stored Procedure that would eliminate based on the Inter Company Accounts that resided in ELIM data source and was run on SQL Server, it included all the additional plugs that were required to show the right values on the Balance Sheet and Income statements.
• Created a Plug that would do the calculation on the fly to Balance the Asset/liabilities on the Balance Sheet.
• Completed the entire task of consolidation reporting alone which involved Requirement gathering, Development and Testing Parallel.

Confidential, Rutland, VT

SAP BPC/IP Architect

Environment: SAP BPC 7.5 NW, SAP BI/IP 7.0

Responsibilities:

• Created a Project Plan to Migrate all the IP/BEx to BPC application.
• Converted all the IP calculations that were in Planning function type FOX and Exit were converted to dimension formula and Script Logic, Dimension Logics and Excel report fomulas.
• All the tool functionalities setting on IP/BEx Query such as Analysis functions, Calculated key figures, Aggregation, drilldown and flexible query views were accomodated in BPC.
• Carrying out Budget Formulation and Layout: multiple layouts (excel-based & web-based) for Personnel budget, capital budget, and other budget, support top-down and bottom-up planning
• Carrying out Version Management: track budget versions (current, submitted, approved, and final), manage workflow process.
• Carrying out Summary: alternative hierarchies for budget summary
• Carrying out Reporting and Auditing
• Trained Business users on BPC Administration Overview, Business Process Flows, Business Rules, Security and BPC Reporting Framework

Confidential, Providence, RI

SAP BPC Functional Architect

Environment: SAP BPC 7.5 NW, SAP BI 7.0, SEM BPS

Responsibilities:

• Gathered the business requirements for the suitability of implementation SAP BPC 7.5NW solution for a unified CFO performance measurement solution.
• Participated in architecting new consolidation solution with new group currency and changed business processes, worked on the proof of concepts for identifying the pain points that would be encountered during the SEM BPS to SAP BPC 7.5 NW Migration.
• There were some existing fixes that the business requested to maintained, supported, and enhanced SEM Cost Center Planning such as developing new layouts, additional formula extension FOX and planning sequences.
• Migrated all the FOX formula to Script logics and dimension logics in BPC some of them were to calculate Bonus, Overtime, Employee Benefits in Personal Expenses Senario.
• Set up of two tier organizational hierarchy, consolidation of business rule, validation, inter-company elimination, and currency translation
• Created a Compressive financial Planning for the entire organization which included Annual Operating Planning and Forecasting using SAP BPC.
• Lead the team of SAP professionals in the areas of Consolidation Process SAP BPC and SAP BI
• Architected the SAP BPC Cube as per the requirement so that it could include all the features.
• Automated Master Data and Transactional Load in BPC using Data Architect, which could get data from Info Cube and Info Objects of SAP BI Cube.
• Mapped key figures of SAP BW Cubes Sales/Finance based on the Account ranges to SAP BPC 7.0 NW so that it could get all the key figure values in Finance/Sales BPC Cube.

Confidential, Mason, OH

SAP BPC Consultant

Environment: SAP BPC 7.5 M SP3

Responsibilities:

• Worked for the Itelligence Implementation team for a 4 weeks assignment to finish up the new requirement that came in weeks before the Go-Live date.
• Interacted with the Business user in getting the requirement narrowed down and wrote the Functional Specification for Lee Kantor (Itelligence Team)
• Document the Present GSC Logic; highlight the sections in the Logic that needs to be updated in the GSC Logics as per the Elimination Excel Sheet.
• Wrote the Test Scenario to check the updates in the Logic
• Updated the Logic and documented it.

Confidential, Princeton, NJ

SAP BPC Lead

Environment: OutlookSoft 4.2, SAP BPC 7.0 SP3

Responsibilities:

• Helped the client in Avoiding Hyperion Licensing and support costs by architecting the Retail Cube so that it could include all the functionalities that were possible in ESSBASE Hyperion Cubes
• Worked over a lot of pain point of reporting with Hyperion such as inconsistent currency rates used in Hyperion and no Master Data trace features available, data can be changed in Hyperion with no audit trail, this not only affects data integrity but is a compliance risk as well.
• Developed the Accounts, Entity dimension and Logics in SAP BPC with all the functionalities in ESSBASE/Hyperion such as Outline (Aggregation Type(+,-,~)/Line Types(Two pass/Dynamic Calc/TB Average)
• Installed SAP BPC 7.0 SP6 in a multi-application server environment.
• Worked on over 150 different Two pass formulas that were present in Hyperion/ESSBASE converted them in dimension logic, advance Logic and Stored procedures, these account formulas were of type Impact business formulas.
• Worked on stored procedures to run various allocation logic and calculations that were not possible using Advanced Logic
• Upgrade Project OutLookSoft 4.2 to SAP BPC 7.0 SP3

Confidential, St Louis, MO

SAP BPC Lead

Environment: SAP BPC 5.x M /SAP BPC 7.0 Net Weaver, SAP BI

Responsibilities:

• Lead the team in conducting the very first Installation of SAP BPC 7.0NW version on a multiple application server environment intended for wide delivery to a number of different clients, worked through bugs and limitations inherent in the software.
• Migrated all BPC 7.0M objects to BPC Netweaver version such as AppSets,Applications,Dimensions,Security,Web Admin parameters,Audit,Comments,Reports and Input Schedules (some manual work done)
• Created Dimensions for Finance/HCM Cubes
• Created Applications Finance/HCM Cubes with similar functionalities to that of SAP 7.0 M Cube
• Migrated HCM Logic/Finance Calculations from SAP BPC to BPC NetWeaver
• Created all Data Architect packages in BPC Netweaver for HCM/Finance Cubes
• Load and Validate Data into Finance/HCM Cube
• Set up Security on Finance/HCM Cube
• Develop Business Process Flows for Finance Cube
• Enable BPC Audit
• Worked on Architecting and Configuring effect multi-site, multi-period, multi-currency load for budgets that could not be done with the existing SAP/Peoplesoft system.
• Set up of two tier organizational hierarchy, consolidation of business rule, validation, inter-company elimination, and currency translation.
• Created Balance sheet, Cash flow Shedules and Reports for planning and forcasting
• Worked on Cash Flow Logic and Balance Sheet Logic using Advanced logic and executed them using data Architect Custom Packages.
• Normal Movement add Cashflow Caluclation Using Advanced LOGIC Reverse Movement add Cashflow Caluclation Using Advanced LOGIC Calculate the Retained Earnings Roll Forward Amount updated MDX dimension Logic

Confidential, Charlotte, NC

SAP BPC Lead

Environment: SAP BPC 5.1M, SSIS, SSAS, SSRS, TFS, BO XIr2/ SAP BPC 5.1M

Responsibilities:

• Architected several subsystems of SAP BPC (OutlookSoft) 5, including data and activity auditing, member and task security, authentication mechanism, enhanced database commentary, and reporting.
• Universe development of various application schemas derived from user requirement analysis.
• Performance and Dashboard Architect metric and aggregate implementation.
• Developed Universe used them as source for both SSRS and BO reporting tools
• Designed, developed and maintained a data mart using Business Objects for reporting purposes.
• Automated various SSIS packages so that we can run the SSIS packages from data Architect and as well as stored procedure.
• Created Clustered Indexes, Non-Clustered Indexes and partitioned the tables to increase the performance of database.
• Provide recommendations and guidance to companies requiring business intelligence and data warehouse solutions.
• Developed Complex Input Schdules and Reports which had VB scripting.

Confidential, San Rafael, CA

SAP BPC Lead

Environment: SAP BPC 5.0M, ECC 5.0, Pillar, Hyperion, VFS, SSIS, SSRS, BO XI r2/6.5, SAP Net weaver BI 7.0

Responsibilities:

• Was responsible for analysis, requirement gathering, Conceptual design and prototyping BPC Outlook Soft 5.1 solution in the following areas- Business Planning, Consolidations, Data Architect and Reporting.
• Created a Compressive financial Planning for the entire organization which included Annual Operating Planning and Forecasting using SAP BPC.
• Provided a variety of custom solutions to various client.
• Universe development of various application schemas derived from user requirement analysis that could not be brought into SAP BPC Cube.
• Develop Webi reports and migrated reports from Business Objects 6.5.1 to Business Objects XI R2.
• Responsible for educating and training end-users in the use of Business Objects XI R2. Training was conducted in classroom settings and telecommunication presentations.
• Created a SQL Server-based transactional system to capture accounts receivable information for License and project revenues based on renewal rates and termination statistics.
• On a monthly basis, new policies and commissions were transformed and loaded from many disparate sources, the model was calculated using SQL and VB, and Excel reports were generated to allow the client company to complete its financial A/R and revenue reporting.

Confidential, Deerfield, IL

OutlookSoft Consultant

Environment: SAP BPC (OutlookSoft) 5.0, BI 7.0, Hyperion Enterprise

Responsibilities:

• Worked on the complete Compressive financial planning of the entire organization that included Personal Expenses, Revenue, Operational Expenses, Capital Spending and Statistics.
• Eliminated manual reconciliation between Architectial Business Objects and Legal Hyperion with OutlookSoft.
• Eliminated Extensive data transformation for Architectial reporting results in reconciliation issues between Business Objects and Hyperion Legal Reporting during period end with the help of OutlookSoft.
• Worked Eliminations in OutlookSoft that was not possible using logic in Hyperion does not cover all eliminations. Must manually adjust for some eliminations (ex: IC Sales\COGS)
• Involved in the Optimization and Processing of Dimensions, creation of Hierarchies, Modification of Applications,Maintenance of Dimension Members.
• Trained End users on the use of BPC custom-built planning applications Provide custom solutions to integrate SAP BPC with data warehouses.
• Set up of two tier organizational hierarchy, consolidation of business rule, validation, inter-company elimination, and currency translation