We provide IT Staff Augmentation Services!

Bpc Senior Consultant Resume

Rockaway, NJ

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

BPC Senior Consultant

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

Hire Now