CAREER OBJECTIVE
Over ** years of progressive experience in corporate reporting and more than 8 years of experience with EPM/consolidation systems my goal is to obtain a position as a Solution Architect or Senor Developer, enabling me to utilize and expand my knowledge while providing an opportunity for advancement. I am able to provide an experienced individual with well-developed interpersonal and communication skills, having dealt with a diversity of clients, staff members, a self-motivated individual who is able to set effective priorities and implement decisions to meet operational deadlines. Adapt easily to new concepts and responsibilities.
CORE STRENGHTS
Creation and Management of SAP BPC and Hyperion Application
SAP BPC and Hyperion Financial Reporting/Analysis
Consolidations in Hyperion as well as BCS
Budgeting & Cash Flow statements
Excel Retrieve of Hyperion Data
Training end users in SAP BPC and Hyperion
Implementation of SAP BPC 7.5 and SAP BPC 10.0 NW
SUMMARY:
5 End to End Implementation Of planning Application for SAP BPC in NW 7.0, NW 7.5 and NW 10.0
Creation and Management of SAP BPC and Hyperion Application/Models
SAP BPC and Hyperion Financial Reporting/Analysis
Consolidations in Hyperion as well as BCS
Budgeting & Cash Flow statements, Excel Retrieve of Hyperion Data
Training end users in SAP BPC and Hyperion
Provide an experienced individual with well-developed interpersonal and communication skills, having dealt with a diversity of clients, staff members, a self-motivated individual who is able to set effective priorities and implement decisions to meet operational deadlines
SKILLS:
TOOLS: SAP BPC 10.0 NW, SAP BPC 7.5 NW, BPC 5.0 MS,Hyperion Enterprise, Hyperion Enterprise report writer, Infinium, Report writer in Infinium, Accpac, ADP Payroll, ADP Report writer, Microsoft Excel, PowerPoint, Word, AS400, Lotus Notes, Microsoft Outlook
EXPERIENCE:
IPG July 2015 – Present
Senior BPC Developer
Support the current BPC 10.0 NW model
Enhancement to the current system ( Reports, Input templates, Distribution of reports)
Build EPM Reports as per user requirements (building complex reports with Macros to perform EPM functions and Override the Page Axis with macros )
Working with the BADI developers to improve the performance of the current BADI’s
Resolution of current issues with better solutions
Coordination with the Offshore team for resolution of data loads issue
Improving the overall performance of the system implemented
UAT for various enhancements
Distribution of offline BPC reports
Building simple queries in BW
IBM June 2014 – July 2015 (two projects)
Honda (Columbus, OH):- Package Consultant (SAP BPC 10.0 NW)
Development of complex EPM reports in BPC 10.0 NW (using EPM Local members to calculate data, various EPM Axis and dimension Override formulas)
Requirement gathering for Gross Profit Calculations from the users
Working with the BADI developers to build the calculations
Testing the complete process for Gross Profit calculations
Working with the users for UAT
Coordination with the Offshore team for resolution of the remedy tickets
Bank of Montreal (Milwaukee, IL) :- Package Consultant ( SAP BPC 10.0 NW )
Development of complex EPM Input Schedules and EPM Reports in BPC 10.0 NW( using EPM functions and EPM properties)
Validation of complex Banking calaculations used for various Planning scenarios
Logic Scripts for Allocation of Payroll expenses
Reports for validation of data
Administration of dimension and properties for the Planning Model
Custom Measures set up for the Balance Sheet balances
Setup of Security and team folders for the users
Fujitsu America June 2013 – May 2014
Contour Global (New York, NY) :- Lead Solution Consultant ( SAP BPC 10.0 NW )
Development of the IFRS model for Planning and consolidation
Development of the Periodic Entry model so data can be pulled from YTD Planning model .
Loading Data from BW to BPC
Scripts to transfer data from periodic data entry to YTD
EPM Reports/Inputs for planning and validation of data
Fujitsu Consulting India
Various Projects
June 2009 – 2013 June
Lead Competency Manager: - Being the Competency Manager had the following responsibilities
Manage the Hyperion and BPC teams for Fujitsu
SAP BPC and Hyperion proposals in response to RFP’s
Imparted training for SAP BPC 7.5 NW for report writing and administration
SAP BPC sales and presales activities (conducting demos, presentations)
Conducted Audit for Hyperion from the competency perspective
Certification for sales and presales for SAP BPC, HANA, and BO 4.0
Implementation of BPC for the following clients
ORYX GTL (Doha, Qatar) :- Offshore Solution Architect ( SAP BPC 10.0 NW )
Development of the Expenses Planning Model
Development of hierarchy matching to SAP BPC
Automation of Master data hierarchy from the BW system to BPC
EPM Reports/Inputs and validation of data
Matheson Trigas :- Solution Architect Offshore ( SAP BPC 10.0 NW )
Requirement gathering for the planning Application at Matheson
Implementation of the Planning Models
Allocation and script logics for Planning and Currency Conversions
EPM Reports/Iinputs and validation of data
Americold :- Technical lead Offshore ( SAP BPC 7.5 NW )
Implementation of the Planning Application
Allocation and script logics for Planning
Scorecard reporting
Customer Profitability
EVDRE Reports and Input Schedules
Hearthside Foods: - Technical lead Offshore ( SAP BPC 7.0 NW )
Implementation of the Planning Application
Allocation and script logics for Planning
Imparted training to end users
Reports and Input Schedules
Support Projects
Armour Eckrich
Consulting and financial experience in the following industries food, Infrastructure, Paint, Medical
Experienced in SAP BPC 5.0 SAP BPC 7.0 and SAP BPC NW
Supported the Armour Eckrich(US Company) SAP BPC 7.0 and SAP BPC 5.systems
Built various reports and solved system issues.
Trained SAP BPC users at Fujitsu India
Working with HearthsideFoods (US Company) In implementing the SAP BPC net waver version
Abhijeet Group
Worked as a Consultant
Experience in BCS consolidation systems
Helped in gathering requirements for Consolidation in BCS for Abhijeet group
Assisted in implementation of Legal Consolidation at Abhijeet
Training Demo attended for Consolidations in BPC at SAP
Armour-Eckrich Meats LLC
Systems Manager
Jan 2008 - June2009
Worked as a Systems Manager
Armour-Eckrich is a meat processing and distributing company. Major responsibilities were BPC system administration, user support, creation of new reports, data management and reconciliation of the financial data from SAP to BPC. Assisted with monthly closing and financial reporting .
Implemented SAP BPC MS version 7 sp 3
Assumed primary responsibility for solving users’ issues by providing specific functional and solution
Knowledge transfer, instruction and assistance.
Consult with users/functional teams to gather and interpret their documented reporting requirements for various projects.
Responsible for security and preparation of SOX documents for the BPC system
Rust-Oleum Corporation, Vernon Hills, IL
Hyperion Administrator/Financial Analyst
June 2005- Dec 2007
Worked as a Hyperion Administrator/Financial Analyst
Rust-Oleum is a paint manufacturing company .Major responsibilities were Hyperion system administration, acquisitions and consolidations,financial analysis and reconciliation, foreign currency translations, uploading data from various system to Hyperion, planning and budgeting, month end reconciliation
Consolidation of Foreign entities in Hyperion
Providing Month-end Hyperion Financial reports and support to Parent and subsidiaries
Retrieving financial information using Hyperion excel retrieve to assist in planning for the future
Provide support for financial planning and budgeting for subsidiary companies.
Analyze the Cash Flow statement and Working Capital for the Plan
William Zinsser & Co, Somerset, NJ
Systems Accountant
August 2001- May 2005
Worked as a Sr. Accountant/Systems Accountant
William Zinsser is a paint manufacturing company. Major responsibilities included month end financial reporting, consolidations, variance analysis,costing,analysis of inventory reports, journal entries
Implemented automation of receipts to the Infinium System
Prepared month end financial statements for Foreign and Domestic companies
Prepared schedules for Balance sheet items.
Reconcile inter company accounts.
Analyzed Inventory reports and compare the cost to the previous month
Responsible for CTA and exchange rate variation for Foreign subsidiaries.
Reconciled Hyperion balance sheet and income statement reports with Infinium system reports
Developed ad-hoc reports using Report writer in Infinium
Magna Health System, Chicago, IL
January 1998 - April 1999
Worked Sr. Accountant
Magna Health is a management company .Major responsibilities were preparation of financial statements and month end reporting
Prepared financial statements on a monthly and yearly basis for the three Subsidiary companies
Reconciliation of Accounts Receivable system to the accounting system
Prepared Bank Reconciliation and solving discrepancies
Managed Payroll for 150 employees and produced monthly and bi-weekly reports
Eastern Art Arcade, Downers Grove IL
Staff Accountant
September 1996 - December 1997
Worked as a Staff Accountant
Eastern Art Arcade is a wholesale company buying gift articles from Africa and selling it to major departmental stores .Major responsibilities included accounts payable, financial reporting and accounts receivable, budgeting
Managed Accounts receivables, which resulted in reducing the line of credit for the company.
Managed the Accounts Payable
Analyzed balance sheet and the income statement with the budget on a monthly basis
Assisted in implementation of automated billing system by using EDI (Electronic Data Interchange) which lead to faster payment collection
EDUCATION:
Equivalent to CMA (USA), Chartered Institute of Management Accountants (CIMA) London, May 1996
Course work included Management Accounting, Cost Accounting, Financial Accounting, Strategic Planning & Marketing, Linear Programming and Network Planning
Association of Business Executives (A.B.E) London, May 1993
Equivalent to BS in Accounting (USA)
Certified Management Accountant (CMA) USA, (Completed Stages I & II))
Course work includes Cost Accounting, Management Accounting, and Financial Accounting