SUMMARY:

• EPM Consultant with 9 years of diverse industry experience in Finance, retail, healthcare and banking Services.
• Expertise in Financial planning and analysis.
• Design technological solutions for OPEX/ Confidential, Revenue, Head count, & Investments planning. Integrated planning - Cost Center planning/Balance sheet & PL Planning
• Budgeting, Forecast and Rolling Forecast
• Functional understanding and end to end implementations in Financial Consolidation
• Knowledge in COREP and FINREP - (EBA reporting), Solvency ii and IFRS 2 reporting frameworks
• Consolidation concepts: Foreign Currency Translation, Inter-Company Eliminations
• Consolidation of Investments - Investments, Minority InterestsGoodwill and Reserves management

TECHNICAL SKILLS:

• SAP Business Objects Planning and Consolidation (10.1/10.0 Embedded & Classic/Optimized for S4 HANA)
• Design Environment, Models, Dimensionality, data model
• Journals, Controls & Business rules, Ownership & Rates Management
• Design Script logics & enhancements through Business Add-ins (BADI)
• Design Planning Functions/Sequence - FOX scripting
• Design HANA views, ADSOs, Composite providers, Aggregation levels & filters
• Reporting - Analysis for office 2.5, EPM 10 Add-in & Web Reporting, Tableau
• Data - Transformations, Conversions for Master & Transaction records
• Design integration of Calculation views/Info providers/queries in HANA to Confidential
• Design real time consolidation/business planning views in S4 & integration to Confidential
• Work flow - Business Process Flows, Security/Analysis authorizations & 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, Extended Analytics
• SAP HANA - Modelling concepts, Data migration, System adaptability for Confidential and BFC
• Vast experience in requirement gathering & customer Interactions
• Involved in four full life cycle implementation & Support project in SAP Confidential /BFC and BO Web Intelligence and Dash boards

DOWNSTREAM 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

PROJECT DETAILS

Confidential, San Diego, CA

Responsibilities:

• structured the reporting menu roles by the planning process flow diagnosed the root cause for duplicate transactions/URLs that shows up on saving the analysis for Office work books and provided the global settings, to avoid duplication
• Fixed the Overhead allocations process to trigger appropriate adjustments by troubleshooting FOX (formula Extensions)
• Prepared the road map for IT financial planning model in BW-IP to SAP Confidential and migration plan to Confidential 11 Embedded on BW4HANA
• Cosmetic changes to AO reports
• Designed Native HANA views for Real Estate Management Cash Flows on real estate leasing by Contract numbers, contract types and Validation rules on Ad-Hoc reporting
• Designed views for process flow information for real estate leasing and provide documents by contracts and expose these views by composite providers allowing Bex based Analysis for Office reporting
• Tuning up Analysis authorizations to provide the right level of authorization to Users

Confidential, Redmond, WA

Responsibilities:

• Built Reconciliation reports to recon source system (MS plan, RPT) plan information in data warehouse to the target models in Confidential
• Reduced the run time/refresh time for reports by 30 percentiles of existing SLA
• Troubleshoot, diagnose and report the root cause for design bugs
• Reduced the runtime and parallelized the data loads for Budget, Expenses, Margin models
• Support data loads, troubleshooting process chains and data manager packages linked to pc
• Support and maintain Users, work status, process flows and reporting issues
• Create User stories, bugs and relate the ongoing development process, enhancements meet and the requirements with minimum structural & customization for existing design

Confidential, Piscataway, NJ

Responsibilities:

• Designed data flow architecture from source systems Confidential /EDW/Work day
• Structural mapping and conversions of master to Confidential
• Designed scripts to handle Currency conversion without business rules
• Achieved elaborated reporting capabilities on total number of product units sold based by different packet size through conversion of Product units to Single units
• Designed script logic - Copy tax account data from No channel to Distributor Entities
• Automate adjustments for OCNIS (Other Costs not in standard) to the departmental expenses on Quality Assurance/Check
• Provided EPM Add-in Input schedules/Forms for data collection related to Adjustments/Tax/Depreciations
• Enhanced User experience on EPM reports for P&L, BS and standard comparative reports through VBA based APIs
• Supported Financial closure cycles. Maintained integration points. Scheduling planning areas to automate closure activities

Confidential, Rockaway, NJ

Responsibilities:

• Conducted brainstorming sessions to align Planning and consolidation implementation with future S4 Finance system
• Designed HANA views of Confidential & Confidential structures and integrate data layer from ECC
• Built real time info providers and aggregation levels for Exchange rates, Ownership rates and Consolidation data
• Built Composite providers to consume Historic & Confidential data for consolidation
• Constructed multiple composite providers to ease business user reporting requirements
• Built reconciliation reports for Currency rates & Master data maintained in ECC tables through virtual providers
• Prepared Functional and technical specification documents for BCF, Currency translations, IC Eliminations & Consolidation of Investments, Work status, Security & BPF
• Built business rules and task sequences for Carry forward, Currency translations, Eliminations
• Achieved retained earnings calculation through account transformation rules
• Designed logics for computing P&L to RE via Journal Entries by planning functions - FOX scripts
• 30%-time reduction in closure cycle through simpler, faster, automated controls and validations to check and enforce data consistency at entity level
• Designed Journal templates, allowing Group Accountants and Controllers to enter adjustments at entity/group level through journals at site
• Delivered seamless integration of business teams and processes through Business process flows and work status, providing data locks after each financial process
• Designed input queries in BEX and skull templates for reporting financial statements - Balance sheet, Income statements, Statement of Equity, Cash flows with drill down at PC
• Built calculated key figures for management reporting
• Captured consolidation team structure and implemented analysis authorization to restrict users based on their role in reporting system
• Designed data access profiles and teams to provide User community with right data set and execution authorization level
• Conducted workshops to demonstrate the reporting features and flexibility for Excel based add-in Analysis for Office
• Consumed functions, calculations, cell-based formatting, variable passing, filters, conditional formatting to enhance User experience with AO reports and input forms
• Support work status and reporting issues

Confidential, Los Angeles, CA

Responsibilities:

• Involved in process and functional design activities
• Built Environment with Consolidation, Ownership and Rates model
• Modeled data structures and dimensions for Consolidation model
• Implemented standard SAP extractors for data collection from ECC
• Created Data migration packages to import data from legacy consolidation system ECCS
• Achieved Non-SAP systems data collection through Input templates and Free forms
• Design data transformation and conversion from ECC to BW on Hana and then to Confidential
• Involved in designing Consolidation Reports BS, P and L, Product based Revenues, Cash Flow statements with drill down functionality
• Implemented Legal consolidation based on Confidential & SIN GAAP
• Ownership Management & Consolidation life cycle management
• Designed Business process templates for corporate data collections and validations
• Built Business rules for Foreign currency translations, Intercompany matching, Intercompany eliminations, Investments & Cash flow statements
• Designed Script logics and Business rules for baseline calculations and derivations
• Designed free forms for collection of Travel expenses based on Profit centers, class, period, Employee designation, trip, cost of air fares, meals, conveyance & lodging including adjustments with the vendor funding
• Built input template to collect the POS mark ups, discounts, client services, merchandise, marketing and other allocations in the budgeting
• Built template to collect Confidential projects based on asset class, useful life, depreciation start date and end date not available from the source system
• Designed occupancy cost planning based on concession fee, Ground and facilities rent expenses and distribute (allocation) to the shops
• Designed scripts and calculations to generate reports on operation expenditure by consumer marketing, FPA and business administration including baseline adjustments/calculations and payroll costs
• Designed sales planning based on retail sales by metrics - nationality by channel and retail sales by Shop, allow adjustments and review allocations by product category as a break down. Achieved data integration through flat file data source for Sales info
• Configured application level security through member access profile, task profile and teams to restrict users as per management and business team structure created Journal template for Consolidation Model, allowing adjustments through JEs
• Maintained and tuned parameters for smooth application performance
• Supported Consolidation closure cycles by maintaining process flows, setting up ownership, rates for the period and work status updates
• Scheduled daily lite optimization to improve the reporting performance of the application

Confidential, Chicago, IL

Responsibilities:

• Gathered Business requirement to understand their core business operation model and built planning, budgeting solutions
• Configured system to compute asset planning based on the depreciation class and asset type in Confidential planning
• Designed Cost estimates and allocation logics for the Revenue planning based on LOBs
• Built OPEX planning model with break down reporting based on plant and division
• Designed technical data flow and business user data collection process via process flows (Input templates and data loads)
• Built Dimensions & Models and their master data maintenance
• Built 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
• Designed Logic Scripts for computation from Cross reference models
• Designed Formulae for KPI calculation based on dimensional values
• Built 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
• Conducted User training on BPF, Free forms and data packages
• Support Change/Incident/Knowledge management

Confidential, Santa Clara, CA

Responsibilities:

• Involved in process and functional design activities
• Involved in developing the Sales Planning Model to report on their business targets
• Confidential and OPEX models to deliver their Organizational financial operations
• Developed Head count planning model for Human resource management
• 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
• Business process templates for corporate data collections and validations
• 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 into Confidential using the DMP, transformation, conversion logic files