We provide IT Staff Augmentation Services!

Sap Bpc Embedded Consultant Resume

New, YorK

SUMMARY:

  • Highly proficient SAP BPC/HANA/BI Expert with 8 years of experience in SAP Implementation & production support projects. Commands an excellent understanding of SAP S4HANA, Functional modules (FI, CO, SD, MM, PS, and PM), HANA, BPC, Analysis office & BW/BW - IP to work independently & provide end to end SAP reporting/planning/Consolidation solution.
  • Experience in Interacting with CFO/CIO/Assistant Controller/Finance Analyst/ VP FP&A/purchasing director/Sales Director to understand the requirements & deliver reporting solution.
  • Exposed to all phases of SAP project from Requirements gathering, Blueprinting, Configuration, Integration Testing, Training to Go Live, documentation, Post-Go live support and end-user training .
  • Excellent Team Player and Excellent written & Customer interaction Skills.
  • High level of energy, self-starter, highly motivated & entrepreneurial type of person with excellent Analytical skills.

PROFESSIONAL EXPERIENCE:

Confidential, New York

SAP BPC Embedded Consultant

Responsibilities:
  • As a part FP&A team support SAP BPC Embedded Consolidation process on S4HANA/ECC(legacy system).
  • Setup new master data (Accounts, Company codes etc) and modify business rules, logic and reports accordingly.
  • Make sure all 3 systems (SAP FI, BPC and oracle PBCS) transaction data matches during month.
  • Develop complex Analysis reports using query designer/analysis office 2.5/Macro.
  • Monitor BW process chain and fix any issue while loading data into BPC from Legacy system (ECC).

Confidential

SAP BPC Consultant

Responsibilities:
  • Delivered new Implementation solution in BPC - Consolidation as per IFRS standards.
  • Requirement gathering from business users, developed Blueprint & getting signoff, configuration in BPC 10.1 etc.
  • Developed Z Flow in BW(setup DSO, InfoCube, infopackage) & setup full Integration from SAP -> BW -> BPC for Consolidation.
  • Achieved various task - Loading data from SAP & non-SAP entities, Setup Chart of Accounts as per IFRS, Making Trial balance=0, currency translation, InterCompany Elimination, Consolidation of Investment, calculation of currency translation difference, calculation of Minority Interest, calculation of Share of Investment of Associate in consolidation, consolidation reports as per IFRS requirement etc.
  • Worked mostly from offshore - Mumbai(India) & went client side last 3 weeks for Go-Live.

Confidential, San Antonio, TX

SAP BPC Standard/Embedded Consultant

Responsibilities:
  • Migrated BPC 7.5 to BPC 10.1 standard & support post migration process/issues.
  • Part of team to implement fresh BPC 10.1 Embedded version.
  • Delivered planning solutions (Opex & HeadCount) via developing Aggregation level, Bex query, Fox Formula, customer exit & Analysis workbook on top of multiprovider.

Confidential, San Antonio, TX

SAP BPC / BI / HANA Reporting Specialist

Responsibilities:
  • Designed and customized BPC for multiple financial planning scenarios by working with key stakeholders to define technical requirements, managing development and testing of project, and ensuring alignment with project specifications.
  • Delivered different planning solution - cost center opex planning, profit center revenue planning, and capex planning by implementing SAP BW IP/BPC Embedded Model on S4HANA.
  • Led design and customization of aggregation level, filters, planning functions, FOX & characteristic relationship, using RSPLAN.
  • Achieved detail level planning by adding custom member line item and implementing comments to track explanations.
  • Designed, developed, and rolled out complex BPC Input template and reports using analysis for office and validating Data flow from S4HANA HANA View Embedded BW-PAK Bex Analysis office.
  • Developed more than 40 reports using Analysis office / Tableau for different department, including finance, sales, purchasing, asset, tax, budget / forecast, AR / AP, projects, inventory, and plant maintenance by developing information models (calculation views) using HANA Studio or HANA live content (virtual data model - private view, reuse view, value help view).
  • Achieved complex reporting requirement by creating complex calculation views using calculated / restricted columns (example: YTD, QTD, AR Aging, YTD - 1), general ledger hierarchy and cost center hierarchy.
  • Developed budget and forecast reports on HANA views, pulling plan data from BPC by activating HANA external views setting.
  • Resolved many production issues in BPC role, including failure of package, Input template fixes, actuals not matching with SAP, security, master data, hierarchy and creating new BPC reports/input template as per requirement.
  • Troubleshot and resolved production issues in BW role, including process chain failure and reports number not matching with SAP and develop new Z data flow (Z Source, DSO, Cube, DTP, transformation, Bex) as per requirement.
  • In BOBJ role, implemented 20 reports in BOBJ by moving reports from Bex and BPC using Analysis office and Webi.
  • Coordinated with Offshore team in resolving SAP production support (FI, CO, PS, PM, SD, MM module) tickets by performing daily offshore calls and collaborating with key business stakeholders.
  • Solid understanding of SAP FICO process & resolved many FICO related issue independently or with the help of offshore team.
  • Led master data project, pulling master data from Legacy system in excel using SQVI to migrate into S4HANA system.
  • Solid understanding of Master data table & Transaction data tables of each module.

Confidential, New York, NY

SAP BPC/EPM Consultant

Responsibilities:
  • Client wants to do reporting on additional dimension - Business Area in SAP BPC and to achieve this requirement performed analysis and modified BPC models, transformation files, conversion files, security, and script logic.
  • Trained and mentored power users for best practice of BPC / EPM reporting and worked collaboratively in evaluating and resolving complex reporting performance and script logic issues - EBITA calculation and other.

Confidential, Woburn, MA

SAP BPC/EPM Consultant

Responsibilities:
  • Provided consultative support on brand new SAP Implementation project through oversight and collaboration with 100 reports, contributing to development of scope, defining technical requirements, managing change and ensuring budget, milestones, and deadlines were met for seamless implementation.
  • Analyzed and reviewed blueprints and designs and implemented BPC solution for consolidation, meeting strict quality and industry standards using USGAAP RDS.
  • Evaluated & customized USGAAP RDS as per client requirement by modifying dimensions, script Logic, business rules - Currency Conversion, IC Matching, IC elimination and Cash flow.
  • Implemented full end to end Integration from ECC BW BPC (Master data & Transaction data), minimizing downtime during transition and allowing automation for improved operational efficiency.
  • Developed & delivered complex EPM / BPC reports and input templates as per client requirement. Designed and customized standard BPF, Controls, web reports, and Web Input templates. Developed Z data flow to load exchange rates from ECC table - TCURR into rate model.

Confidential, Albuquerque, NM

SAP BPC/EPM Consultant

Responsibilities:
  • Evaluated and automated the data loading process from ECC BW BPC (Master data & Transaction data).
  • Delivered complex Input templates & reports using EPM & also used VBA macros.
  • Trained End users how to load data from ECC to BPC on-demand basis.
  • Created & maintained BPC launch page so that end user can access all reports using one excel.
  • Fixed issue related to data discrepancies in BPC, BW & ECC.

Confidential, San Antonio, TX

SAP BPC 7.5 Consultant

Responsibilities:
  • Analyzed & fixed performance related issues of most important EVDRE Input template of Opex application.
  • Using UJSTAT, audit logs and other performance tool like fiddler to get the details logs of Application OPEX in BPC to understand the root cause of the performance issue.
  • Corrected Transformation and Conversion files for loading HR planning data from Flat file coming from ADP.
  • Developed and maintained Member access profile & task profile for new user.
  • Developed BPC Menu page (using EVMNU function) so that users can access all templates & reports using one template.
  • Analyzed & debug Routine for issue related to exchange rate calculation before loading in HR model & debug Custom BADI.

Hire Now