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

Contact this candidate