Principal Consultant Resume
SUMMARY:
- 26 years SAP experience as user and consultant
- 22 years as SAP Solution Architect in S/4 HANA, BPC, BI, Simple Finance and SAP Modules (FICO, SD, PS) with numerous life - cycles and multi country rollouts providing operational improvements and systems performance.
- Strong Online Analytical Processing and Decision Support Systems expertise (SAP-BI: Business Objects, Analysis, Design Studio ). WEB Application Design and BI Development
- Extensive cross-application integration expertise in multiple industries such as Manufacturing, Publishing, Entertainment, Pharmaceutical, Trading and Retail
- Over 4 years of diversified Public Accounting and Managerial consulting experience in vast range of businesses from mid size companies to multinational corporations working closely with and reporting to Chief Financial Officers, Controllers, Directors, Business & Systems Analysts, and Auditors.
- Proven decision-making, organizational, problem-solving, communication and presentation skills.
WORK EXPERIENCE:
Principal Consultant
Confidential
Responsibilities:
- Delivery of 23 custom reports in BPC on Hana to meet Macmillan’s requirements.
Principal Consultant
Confidential
Responsibilities:
- Implemented Embedded BPC with BW7.5 and Hana.
Solution Architect
Confidential
Responsibilities:
- Presentation to steering committee for project update, project issues and road map (including BI, HANA, BPC, Cloud ) .
- Designed, implemented and managed BI Solution. The project scope included Production plan variance, Inventory Revaluation, raw material usage, fix cost spending and consumption for actual and plan.
Principal Consultant
Confidential
Responsibilities:
- Led migration of 7 years of historical data from current oracle database to Hana.
- Design and implementation of S/4 Hana Design Studio in area of simple finance, sales and distribution, inventory, CRM and Hybris billing for integration of business from International Scholastic group.
- Developed reports using Analysis for office and Fiori.
Principal Consultant
Confidential
Responsibilities:
- Led Initiative to gather business requirements for planning and Budgeting. Designed system and procedures to meet multi countries planning and budget solution along with consolidation in BPC and BW on Hana.
- Implemented bottom up forecast, used actual data for forecast process. and comparison reporting. The activities include design and development of modules and dimensions, transformation and conversion files/process.
- HR Labor, labor rate calculations and Target Setting: Architect for flat file and BI integration as source of data, input forms for company, country and org level assumptions. Logic scripts, BPF and Security, EPM reports including validation macros. Design of BAdi to write back cost centers salary expenses to ECC.
- PL, Balance sheet, cash flow, functional overhead: Architect for source of data from BI, various Input forms include actual data and overwrite functionality, logic scripts, BPF, currency conversion, security and reports.
- GAP tracker: flat file load, distribution and collection of input forms, reports.
- Development in integration of SFDC data into S/4 Hana.
Solution Architect
Confidential
Responsibilities:
- Designed and implemented financial and management planning using BPC10 and BW.
- Created budget process in BPC10.1 for P&L at product and business area level including collection of actual data, historical data from different sources, modeling, rules, account translations and reports.
- Financial Consolidation of companies from 9 countries with different currencies.
Solution Architect
Confidential
Responsibilities:
- Gathered business requirements as part of blue print, designed and implemented BI solution for payroll, Human resources and statistical key figure solution for rapid growing service provider.
- Designed and delivered 20 custom reports.
Principal Consultant
Confidential
Responsibilities:
- Implemented BI solutions for multiple countries for complex trading systems (20M lines every day) with numerous inbound and outbound interfaces.
- Automated load procedure to give close to real time information as required by financial statements and management reports for trading activities in various commodities, risk layout, inbound and outbound interfaces to meet country specific, IFRS reports.
- Developed custom web reports for daily flash on website. Designed and implemented planning process for multiple countries.
Solution Architect
Confidential
Responsibilities:
- Designed and implemented BI-BPC solution for global trading system (GTS) along with finance, sales, inventory, overhead and purchase data.
- Fully integrated solution for planning in order to budget, forecast and currency translation at product level.
- Delivered custom reports to meet trading needs.
- Implemented authorization based on profit center and business area.
Solution Architect
Confidential
Responsibilities:
- Led design and implementation of BI solution for production, financials, sales, overhead and inventory systems including reports and security.
Solution Architect interactive reporting CRM
Confidential
Responsibilities:
- Designed and implemented BI Solution for interactive reporting in CRM. It includes custom extractors for CRM data and routine to currency conversion.
Solution Architect
Confidential
Responsibilities:
- Designed and proposed solution for issues related to high volume, Hyperion, Joint Venture and reconciliation to source. Provide solution to handle incremental digital music data and additional countries in current design.
Solution Architect
Confidential
Responsibilities:
- Provided redesign solution for Artist P&L and overall revamping of current BI system especially from royalty, copy right, reconciliation and performance in data load and report execution.
Lead Consultant/ Manager
Confidential
Responsibilities:
- Managed team of 7 onshore and 6 offshore resources.
- Lead architect for design of BI solution for FI, CO, SD, MM, legacy system and feed to various downstream systems. Design and creation of custom build generic extractors, info cubes, ODS and multi providers for FI, CO, Logistics cockpit for sales and distribution, material management etc.
- Load scheduling with process chains. Developed Security roles for end users.
- Created BEX as well as Web reports using web application server to meet business need and report broadcasting. Worked with Corporate finance and management finance teams to gather all reporting requirements.
- Data architecture for various Legacy Systems Data Migration with 10 to 14 years of history data. Developed complicated Open Hub destinations using BAdi and transformation to feed downstream systems and SAP R/3 for royalty, copyright and accrual posting.
- Designed an automatic process to validate and reconcile data from multiple sources with BW data to make sure that data in extractors is not lost while load process and created an email process to responsible persons in case the data is not matching in sources and BW.
- Prototype of product line PL in integration planning.
Lead Consultant
Confidential
Responsibilities:
- Solution architect to implement BW/SEM solution included BPS, BCS and CPM as part of SOX requirements.
- Created the Flexible upload functions and Methods for loading the Master data and loading the reported financial data along with currency translation function and Methods for each company code as per the requirement. Configured the Document Types for the Manual Posting, Reclassification functions, Balance Carry forward function
Lead Consultant
Confidential
Responsibilities:
- Led team of 7 onshore resources for requirement gathering, documentation, testing and .
- Delivered ECC - COPA and BW solution for profitability analysis and BW in GL, Service orders, AR, AP, COPA, PC, AA, CCA, PCA, Sales, Production planning, material ledger, Inventory and material ledger. The solution included highly customized data extractors, InfoObjects, communication and update rules include routines.
- Custom BEX queries and workbooks along with load procedures and load schedule for logistics cockpit (Inventory management, purchasing, sales and distribution, service module etc), profitability analysis, general ledger, accounts payable, asset accounting, product costing, overhead accounting and profit center accounting.
- Designed an automatic process to validate and reconcile data from multiple sources with BW data to make sure that data in extractors is not lost while load process and created an email process to responsible persons in case the data is not matching in sources and BW.
- Also, designed and implemented full cycle Cost based COPA integrated with SD, SM, PP, FI, CO, MM.
- Created and managed financial feed from BW to Hyperion for corporate reporting and processing.
Lead Consultant
Confidential
Responsibilities:
- Led team of 8 onshore FICO resources for requirement gathering, presentations,, Blue print, implementation, and change management.
- Responsible for design and implementation of COPA with integration to production planning, Asset settlement, CO allocation, Sales and GL.
- In BW 2.0, responsible for implementation of all financial data in ECC including project, royalty, publicity and catalog costs to deliver title P&L.
- Developed asset retractor from BW to ECC (COPA) for royalty, advertising, promotionpublicity, catalog costs of asset under construction at title level. This was the first retractor which is used by SAP to other clients.
- Delivered custom Bex, BO and ABAP reports to meet business need.
- Responsible for FICO data feed to Business Object universes for various internal and external reports.
Senior Consultant
Confidential
Responsibilities:
- Provided support for implementation and go-live activities for the large multinational trading company. Activities included participation in Integration testing, End-User testing, Dress rehearsal definition, knowledge transfer, as well as definition of post go-live support in FICO included COPA, CCA, PCA, G/L, AR, AP, and Fixed Assets
Senior Consultant
Confidential
Responsibilities:
- Designed and implemented custom functionality to support specific integration requirements (Sales BOM integration with Profitability analysis) between SD and FI/CO
Senior Consultant
Confidential
Responsibilities:
- Worked on an Upgrade proposal and scoping (from 3.1 H to 4.6 B). Scope of job including FI, CO, PP, MM and SD modules.
SAP Process Engineer
Confidential
Responsibilities:
- Team lead for 8 onshore FICO resources.
- Responsibility included support of CO module, including Profitability Analysis, Product Costing, Profit Center Accounting, Cost Center Accounting, Sales and Distribution Module, and the Service Module. This design provided for settlement of service orders, sales orders, and cost centers through COPA. Also performed configuration changes to support changes in cost allocation requirements.
Senior Consultant
Confidential
Responsibilities:
- Project responsibilities included full life cycle activities for definition configuration and support of complete COPA functionality. This included design and implementation of account-based and cost-based profitability analysis.
- Worked closely with project management, client steering committee members and other functional teams in an FICO leadership role to reconcile multiple SAP implementations into one company wide design. Involved in initial requirement gathering for BW 1.2B version.
SAP Consultant
Confidential
Responsibilities:
- Configuration and implementation of Funds Management with endowments and funds specific contributions.
- Integration of feed to Fund data from Sales, purchase and overhead costs.
SAP Consultant
Confidential
Responsibilities:
- Team member with responsibility for chart of account, number ranges for documents, document types and global GL configuration.
SAP Consultant
Confidential
Responsibilities:
- Worked on pricing procedures for sales and distribution.
SAP Analyst
Confidential
Responsibilities:
- Internal audit of general ledger and accounts receivables for preparation of SAP implementation.
Manager
Kingston
Responsibilities:
- Prepared year-end financial statements and corporate tax returns for different SAP
Senior Accountant
Confidential
Responsibilities:
- Performed cost accounting and Auditing for purchasing and manufacturing departments.