We provide IT Staff Augmentation Services!

Sap Bpc Consultant Resume

SUMMARY

  • Excellent working experience in Financial Reporting for Internal and External reporting requirements using SAP BPC, SAP BI and SAP Integrated Planning.
  • Expertise in design and configuration of BPC consolidations and planning environments for operating expenses and revenue planning and head count planning.
  • Functional and Technical expertise in BPC Consolidations and Cash Flows, Business Rules, Journals, Controls, and Work Status.
  • SAP BPC Embedded experience in creating Filters, Planning Functions & Planning Sequences.
  • Worked on creating Reports and Forms using Analysis Office on Both Multi providers & Composite Providers.
  • Created the custom functions using Fox Formulas to reach the business needs.
  • Managing the BPC upgrade from 10.0 NW to10.1 HANA.
  • Extensive 3 years’ experience on SAP HANA 1.0 SP11 and SAP BIBO (4.2) and BW 7.5 and having experience on SAP BODS modules.
  • Involved in 2 HANA full life cycle implementations.
  • Excellent Techno - functional skills on SAP HANA 1.0 SP11.
  • Excellent experience with consulting, designing, implementing and leading SAP HANA - based solutions.
  • Involved in business development initiatives - provided demos and discussed advantages on Hana and projected the new projects in HANA 1.0.
  • Strong command over creating and maintaining the Data provisioning Techniques using SDA/SDI & SLT.
  • Full Life cycle implementation experience in SAP BW implementation - Modeling, Configuration, Extraction and reporting.
  • SAP Certified in Business Intelligence with SAP Net Weaver 7.0.
  • Experience in system upgrade from BW 7.1 to BI 7.3.
  • Experience in system upgrade from BW 7.3 to BI 7.5.
  • Extensively worked on BEX reports, Workbooks and Information Broad casting.
  • Working Knowledge on Business objects- Lumira, Web Intelligence and Design Studio.

PROFESSIONAL EXPERIENCE

Confidential

SAP BPC Consultant

Responsibilities:

  • Worked on BW to build BADI’s to retract Master data attributes and Hierarchies from BPC to BW.
  • Created Transformation Files and Conversion files to load Transactional data and master data texts and hierarchies.
  • Worked on Business Rules and Script logic for currency translation, allocation and copy data from one Model to another.
  • Worked on BPC Admin team to configure and testing BPC security.
  • Worked on BW Security team to configure security consistent with BPC Security, Users, Teams, Task Profiles and Member Access Profiles.
  • Worked on creating Data Manager Packages and Data Manager Package Links with Prompts.
  • Worked on configuring and testing Work Status and Controls.
  • Worked on creating Journal Templates by BPC model.
  • Worked with user in UAT, loading master and transactional data, creating and posting Journals, creating and posting journals, testing Controls and Work status and running consolidation tasks.
  • Supporting revenue planning and expenses planning applications and troubleshooting day to day BPC technical issues and BPC performance issues working with SAP basis and DB teams.
  • Managing the BPC upgrade from 10.0 NW to10.1 HANA.
  • Worked with business users in requirement gathering, and designed, proto-typed, developed, tested and deployed SAP BPC solutions for corporate planning and corporate reporting groups.
  • Responsible for supporting corporate reporting group with their month/quarter/annual financial close.
  • Support CFO and audit committee with ad hoc projects for their financial analysis and decision-making.

Confidential

SAP HANA/BI/BOBJ/BPC Consultant

Responsibilities:

  • Experience on SAP HANA 1.0 SP11 and SAP BIBO (4.2) and BW 7.5 and having knowledge on SAP BODS (4.2) modules.
  • Design, develop & optimize Attribute Views, Analytic Views and Calculation views.
  • To perform real-time data replication into SAP HANA and near time data loading into HANA using Data provisioning with remote sources (SDI/SDA/SLT/BODS) with HANA and Hadoop as source systems.
  • Experience in Creating and building SQL based Procedures / Table functions and Calculation Views with Graphical.
  • Experience in Replication Technologies like Trigger Based, Log Based and ETL Based Replications.
  • Modeling of cost and revenue allocation models based on fine granular data, e.g Station level data.
  • Knowledge of XS and OData Services.
  • Worked as BPC consultant responsible for implementation of SAP BPC 10.NW.
  • Responsible for implementation and sustainment of SAP BPC 10.0 NW legal consolidations models - USGAAP and regulatory reporting.
  • Supporting revenue planning and expenses planning applications and troubleshooting day to day BPC technical issues and BPC performance issues working with SAP basis and DB teams.
  • Managing the BPC upgrade from 10.0 NW to10.1 HANA.
  • Worked with business users in requirement gathering, and designed, proto-typed, developed, tested and deployed SAP BPC solutions for corporate planning and corporate reporting groups.
  • Responsible for supporting corporate reporting group with their month/quarter/annual financial close.
  • Support CFO and audit committee with ad hoc projects for their financial analysis and decision-making.
  • Extracted Maintenance and Service orders data (Plant Maintenance, Customer Service), Inventory Management Data, Purchasing Requisitions and Purchase Orders data (MM) using LO-Cockpit extraction.
  • Performed Data Tiering Optimization (DTO), Multi-Temperature Data Management. Hot, Warm & Cold data concept.
  • Involved in development of Advanced Data store Object (ADSO), Composite Provider and Open ODS View.
  • Developed ABAP routines at Info Package level for data manipulation and restriction.
  • Designed making extensive use of the DSO capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
  • Actualized various types of BEx query variables including User exit, Text and formula variables.
  • Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
  • Having experience on end to end implementation projects right from blue printing till post go live support.
  • Created WEBI reports, Lumira Reports & Design Studio reports and deployed them through Info View with Hana as Source.
  • Created reports using user-defined functions like variables, prompt and Aggregate in SQL enhancement.
  • Created Reports by using multiple data providers to combine 3 reports as a single Report in Webi.
  • Created Business Objects Reports using Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer's requests from Tables and Views.
  • Dashboard application development using Design Studio with BW & HANA as data sources.

Confidential

SAP BI/BOBJ/BPC Consultant

Responsibilities:

  • Worked with team creating Consolidation, Management, Ownership, IC Matching and Rate models.
  • Worked on BW flow for BPC staging Master data BW Objects) and BPC Staging BW Info Providers (Info Cubes /DSO)
  • Worked on BW to build BADI’s to retract Master data attributes and Hierarchies from BPC to BW.
  • Created Transformation Files and Conversion files to load Transactional data and master data texts and hierarchies.
  • Worked on Business Rules and Script logic for currency translation, allocation and copy data from one Model to another.
  • Worked on BPC Admin team to configure and testing BPC security.
  • Worked on BW Security team to configure security consistent with BPC Security, Users, Teams, Task Profiles and Member Access Profiles.
  • Worked on creating Data Manager Packages and Data Manager Package Links with Prompts.
  • Worked on configuring and testing Work Status and Controls.
  • Worked on creating Journal Templates by BPC model.
  • Worked with user in UAT, loading master and transactional data, creating and posting Journals, creating and posting journals, testing Controls and Work status and running consolidation tasks.
  • Worked on documentation and knowledge transfer to BPC Admin Team.
  • Extracted data from COPA for profitability analysis reporting in BW. Created custom Info Cube, ODS and reports.
  • Developed Info Objects, Info Sources, Info Cubes, Multi providers & ODS.
  • Analyzed Info Cubes created and maintained aggregates to improve the performance.
  • Defined Transfer rules and Update rules for data in SAP-BW.
  • Scheduling, Monitoring and transporting objects in Dev, QA, Prod Systems.
  • Experienced with design, development and deployment of various reports in BEx and Web Application Server.
  • Developed the integrated planning Environment using RSPLAN and performed Manual Planning and Automated Planning using Web Application Designer.
  • Used Elements of Planning environment like Info Provider, Aggregation Level, Filters, Planning function ns and Planning Sequence.
  • Experienced in development of Project Documentation, training materials and project management methodology.
  • Extraction of data from Flat files & R/3 using LO’s, and Generic data sources.
  • Designed universes against the different database, defining the necessary connections and exported them to specified universe domains.
  • Involved in performance tuning and Data Quality, Business Objects Full Client and WEBI.
  • Created complex reports stating revenue generation per year using cascading.
  • Used SAP Data services as ETL tool in developing Data flows.
  • Worked with data analysts to gather business requirements to be translated into design considerations.
  • Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
  • Created test cases to test complicated data flows.
  • Design the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
  • Managed onsite and offshore team during implementation and support phase.

Hire Now