SUMMARY:

• EPM Consultant with 8 years of diverse industry experience in Finance and banking Services.
• Aiming to use my professional consulting expertise in Business planning, Strategic management reporting and financial consolidation to endeavor the portfolio of Business Entities.
• Implementing Business Planning: Operational and Capital Expenditures planning, Sales planning, Head count planning, Investment planning, Integrated planning
• Budgeting, Forecast and Rolling Forecast
• Functional understanding and end to end implementations in Financial Consolidation
• Foreign Currency Translation, Inter - Company Eliminations
• Investments, Minority InterestsGoodwill and Reserves management
• SAP Business Objects Planning and Consolidation (Version 10 & 10.1 installed on HANA/ Net Viewer BW/ Microsoft Version database)
• Environment/Application set management, Model/Application management
• Dimensions, Journals, Controls & Business rules, Script logic - BADI, FOX scripting, stored procedure
• Reports/Schedules - Analysis for office, EPM 10 Add-in & Confidential, Tableau
• Data management - Transformations, Conversions and MD, Tx. Data loading
• Work flow - Business Process Flows, Security & Transports
• SAP Business Objects Analysis for Office, BEX Query Designer
• SAP Business Objects Financial Consolidation (Version 7.5 & 10 based on HANA)
• Dimension & Scope management
• Category management - Accounts, Flows, Business Controls/Validations and Formulae
• Business rules, Schedules & Journal templates
• FX rate tables, Conversion and Tax rate table management
• Security, Work status, Operational Cycle management (Period Closure)
• SAP Inter-Company Services, Financial Information Management
• SAP HANA - Modelling concepts, Data migration, System adaptability for BPC and BFCDownstream applications
• SAP BI/BW - Administration - Modeling & Transport management
• SAP FI CO - General ledgers, AP/AR, Cost center accounting, costing, profitability analysis
• ETL - SAP Data Services and Extended Analytics
• Vast experience in requirement gathering & customer Interactions
• Involved in four full life cycle implementation & Support project in SAP BPC/BFC and BO Web Intelligence and Dash boards

PROFESSIONAL EXPERIENCE:

Confidential, Rockaway, NJ

Responsibilities:

• Conducting brainstorming sessions to align Planning and consolidation implementation with future S4 strategy
• Preparation of Key design documents for Master, Tx data, Security, Work flow, Consolidation requirements, reporting
• Preparation of Functional specs for Cash flow, Eliminations & COI, Work status, Security & BPF
• Currency translations and Eliminations
• Controls, Journals, Work status and Business process flow design
• Process design and implementation for Supply Chain Users to capture the COGS at material, align freight standards and simulate variance in standards
• Design Sales and Operational planning model to facilitate simulation and analysis for Volumes and gross sales at SKU level by Business Unit, Brands, Sub Category and Category
• Financial planning model to collect, process planning and forecast for P&L accounts apart from SKU COGS, BU’s, Volume and Price mix
• Design input templates and reporting files, free forms to support data collection and reporting in these three planning models
• Leverage BPFs and security, based on User community by operational structure

Confidential, Los Angeles, CA

BPC Senior Consultant

Tools: SAP BPC 10.1 (NW), SAP HANA

Responsibilities:

• Involved in process and functional design activities
• Setting up Environment with Consolidation, Ownership and Rates model
• Dimensional Modeling and data structure modeling for Consolidation model
• Designing data collection though standard SAP extractors
• Data migration packages setup from legacy consolidation system ECCS
• Designing Input templates and Free forms for Non-SAP data collection
• Involved in designing Consolidation Reports BS, P and L, Product based Revenues, Cash Flow statements with drill down functionality
• Legal consolidation based on US GAAP & SIN GAAP
• Ownership Management & Consolidation life cycle management
• Business process templates for corporate data collections and validations
• Business rules to define Foreign currency translations, Intercompany matching, Intercompany eliminations, Investments & Cash flow statements
• Designed Script logics and Business rules & Interoperable differences and baseline calculations
• Security configurations for member access profile, task profile and teams to restrict users as per management and business requirement
• Designed and developed Templates as per business requirement
• Worked on creation of Journal template for Consolidation Model
• Configured the Consolidation Environment with the Consolidation Model, Rates & Ownership Model

Confidential, Chicago, IL

BPC Consultant

Tools: used: SAP BPC 10.1 (NW), SAP HANA

Responsibilities:

• Business requirement gathering to understand their core business model and build planning, budgeting solutions
• Configure system to compute asset planning based on the depreciation class and asset type in CAPEX planning
• Cost estimates and allocation logics for the Revenue planning based on LOBs
• OPEX planning based on plant and division
• Preparation of Consolidated Financial statements
• Technical design for data flow and business user data collection process via process flows (Input templates and data loads)
• Build Dimensions & Models and their master data maintenance
• Input schedules and complex EPM input sheets for data collection based on Brand, Segment, Product & their CCs
• Built Data Manager Packages for both Master data and Transaction data loading
• Logic Scripts for computation from Cross reference models
• Formulae for KPI calculation based on dimensional values
• Build business rules for
• Account transformations & Currency translation
• Elimination of intercompany transactions & Elimination of Internal Dividends
• Consolidation of Investments & Minority Interests
• Developed Business Process Flow (BPF) Templates for each business operation
• Security setup for Users and assigning them to the respective teams and access groups
• Audit Log and Work status configuration to adhere local governing Compliances
• User training on BPF, Free forms and data packages
• Change/Incident/Knowledge management

Confidential, Santa Clara, CA

BPC Consultant

Tools: used: SAP BPC 10 (NW)

Responsibilities:

• Involved in process and functional design activities
• Involved in developing the Sales Planning Model to report on their business targets
• CAPEX and OPEX models to deliver their Organizational financial operations
• Developed Head count planning model for Human resource management
• REAC Management model for strategic branding and efficiency reporting
• Designed and developed Reports & Input Schedules using EPM PANE and other EPM Functions like EPMsaveData, EPMRetrieveData, EPMComment, EPMdimensionOverride, EPMcomparison, EPMurl etc.,
• Involved in designing financial planning reports with standard planning functions Spread, trend, weight in Sales planning based on product by segment and region
• Designed input sheets for resource planning based on new & old contract, Full time resources and their cost by grades
• Designed input forms for Revenue planning based on the comparative data from actuals
• Involved in designing Consolidation Reports BS, P and L, Product based Revenues, Cash Flow statements with drill down functionality
• Legal consolidation based on US GAAP
• Ownership Management & Consolidation life cycle management
• Business process templates for corporate data collections and validations
• Business rules to define Foreign currency translations, Intercompany matching, Intercompany eliminations, Investments & Cash flow statements
• Designed Script logics, BADIs and Business rules
• Security configurations for member access profile, task profile and teams to restrict users as per management and business requirement.
• Designed and developed Templates as per business requirement.
• Involved in Data management and loading of data intoBPCusing the DMP, transformation, conversion logic files
• Worked on creation of Journal template for Consolidation Model
• Configured the Consolidation Environment with the Consolidation Model, Rates & Ownership Model
• Looping the currency translation logic in the reporting cycle by maintain rate templates

Confidential

BFC Consultant

Tools: used: SAP BO Financial Consolidation, FIM, EAD (Extended Analytics)

Responsibilities:

• Technical implementation of Insurance reporting & Solvency II reporting requirements
• Building new dimension walkcategory to stimulate the function of audit id dimension
• Data model design for COA, AC families and flow behavior of Insurance accounts
• Designed business rules to re-classify the objectives of Solvency ii
• Blocking formulae with pseudo calculations, complex data mappings
• Mapping IFRS consolidated data to Insurance Units along with balance carry over functionality
• Involved in building Technical category scenario version for the data management from the existing implementation
• Category Scenario: Account Management, account families, flow setup, formulae for intermediary calculations and controls for data validations
• Dimensional Analysis configuration to provide breakdown analysis bases on Partner, Share, Maturity and Geography
• Involved in building business rules for account transformation
• Data extraction from IFRS consolidation (Technical consolidation)
• Legal entity transfers
• Data transformation to Walk Category audit ids
• Foreign currency conversion into Group currency
• Provisional Eliminations, Intercompany Eliminations, Dividends
• Elimination of Investments, Handling investments in JV
• Goodwill and Minority interest reclassification
• Defining scope for the portfolio management and organizational structure
• Involved in creating input schedules and output reports linked to Enrichment schedules
• Created style books for cosmetic and standard reporting structure in schedules

Confidential

BPC/BO Consultant

Tools: used: SAP BPC 7.5 (NW), SAP Dashboards

Responsibilities:

• Maintaining dimension members, properties, developing input schedules & reports.
• Maintaining dimension hierarchies, dimension Member formulas, creating and using Scrip logic through default logic.
• Executing account transformation program to verify cash flow statement in LC
• Uploading ownership data of reporting period from flat file in ownership application
• Execute Ownership calculation program for required period and verify ownership data
• Upload exchange rates for the period from BI infoprovider and verify exchange rates
• Customizing and implementing reports based on Schedule 6 IAS structure
• Requirement gathering from Finance controllers and Corporate Leads
• Maintaining system security to users and user groups by application level security and dimension level security.
• Support on Input templates architecture and providing analysis using Quick-Adhoc reports
• Analysis interacting with the team and the users to get the desired inputs
• Work status settings and linking them to input templates
• Created Live office and access database connections
• Provided connectivity for dashboard to BW through Open Hub Services
• Maximize option for charts without panel set option
• Used components like selectors, cascading prompt, and drill down options
• Radio buttons, check Boxes, Image components, dynamic visibility
• Excel functions like DGET(), formulae
• Various charts, single valued displays, Alerters, containers
• Used play selector, Ticker, conditional hiding

Confidential

BFC Consultant

Tools: used: SAP BO FC, FIM, EAD (Extended Analytics)

Responsibilities:

• Building dimensions, characteristics and properties involved in reporting
• Master data management as per the business requirement User defined dimensions, characteristics and properties for granular level of data analysis based on the business requirements
• Designed new schedules based on User requirements and enhancements
• Change management related to
• Restatements & Currency translations
• Elimination of intercompany transactions & Consolidation of Investments
• Creating Dimensional Analysis providing breakdown analysis bases on product, Maturity, Geography and Loan Quality
• Creating new formulae if required with the new accounts or any changes in properties/characteristics related to the existing accounts
• Analyzing the organizational structure based on the investments and building the hierarchy with the Scope and setting up reporting units that participate in consolidation
• Analyze and configure the Incoming and outgoing Reporting units in the Scope
• Configuring the Business level authorization groups for Data Access
• Creating new DAG filters based on the access level required by the Users providing, read/write option to the system level objects like package and Consolidation
• Package Amount Trace maintenance for tracking the deltas
• Data Model updates, Incident management, Change management
• Transports to other environments
• Performance tuning
• Archiving the logs in regular periods to improve the database performance
• Deleting un-used version of consolidations &Task group archiving
• Operational cycle
• Setting up Reporting IDs, Reporting Units
• Package management - Publish and integrate
• Master data for RU’s in ICS for IC matching & reconciliation
• Scheduling the tasks & task groups to automate the consolidation process

Confidential

BPC Associate Consultant

Tools: used: SAP BPC 7.5 (NW), SAP BI7, Xcelsius

Responsibilities:

• Requirement gathering from client’s super user and financial controller
• Understand and Analyze Business Requirements for Financial Budgeting & Planning
• Developing the Application set, Applications, and Dimensions for the planning system
• Maintaining dimension members, properties and developing input schedules and Reports
• Maintaining Dimension hierarchies, Dimension Member formulas, creating and using Scrip logic through default logic
• In BPC- Excel, Create Budget Input templates for Policy Sales, Channel Expenses, Capital Expenses, Product Expenses, Headcount, Payroll and Project wise Income Analysis template using EVDRE Grids and EVDRE formulas
• Develop variance reports for Income, Expenses, Assets, P&L, and Balance sheet, KPI trending analysis report and “What if” analysis and Drill down, Drill through reports
• Developing and Configuring Business Process Flows and setting Approval processes
• Setting up system security to users and user groups by Application level security and Dimension level security, Work status settings and linking them to input templates
• Data manager functionality and loading data using data manager packages
• Maintaining the exchange rates in the rate application for currency translation
• Implementing currency translations to support for foreign division

Confidential

BW/BO Consultant

Tools: used: SAP BO 3.1 Web Intelligence, Xcelsius 2008, SAP BI7

Responsibilities:

• Develop offline charts with SWF features
• Connectivity with Access database via live office and ODBE connections
• Develop Charts, Tickers, Alerters and Scroll Bars for the graphical presentation of SM Dumps
• Project KPIs related to solution dumps in the Sales and Procurement cycle
• Automate the process of data extraction from Business Warehouse to Access database via open hub file services and connect it to Xcelsius
• Web Intelligence reports to distribute projections of both Sales and Procurement cycle
• Page formatting, Page breaks, print options, Variance calculations and in sheet formulae etc., to provide better visualization
• Developed reports with filters at both report and query level and facilitate Users & administrators to tighten data accessibility
• Maintain roles, User profiles and systems & their server partitions, job maintenance in Central Management Console