We provide IT Staff Augmentation Services!

Sap Bpc Consultant Resume

SUMMARY:

  • Result oriented SAP BPC/BO with Eight Years, BI professional with Twelve years & HANA with Three years of progressive experience working in various Domains - Petroleum, Manufacturing, Transportation and Telecommunications.
  • 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.

WORK EXPERIENCE:

Confidential

SAP BPC Consultant

Environment: SAP HANA1.0 SP11, BPC 10.1 NW, SAP ECC 6.0, SAP BI 7.5, BEx query Designer, BEx Analyzer, BOBJ 4.2.

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

Environment: SAP HANA1.0 SP11, BPC 10.1 NW, SAP ECC 6.0, SAP BI 7.5, BEx query Designer, BEx Analyzer, BOBJ 4.2.

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

Environment: SAP BPC 10.0 NW, SAP ECC 6.0, SAP BI 7.3, BEx query Designer, BEx Analyzer, BOBJ.

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, 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.

Confidential

SAP BI Consultant

Environment: SAP ECC 6.0, SAP BI 7.1, BEx query Designer, BEx Analyzer

Responsibilities:

  • Involved in complete life cycle implementation of SAP BW.
  • Preparation of Technical and functional Specs according to Client requirements.
  • Translated functional Spec into Technical Specification.
  • Installed Business content like CUBE, DSO etc.
  • Developed custom Info Sources, DSO, Info Providers, Virtual Providers, and Multi providers.
  • Defined Transformations, DTPs and Info Packages.
  • Customization of data source and ABAP code for User Exits.
  • Unit Testing of data loads (full & delta) and defect fixing.
  • Distributed data using Open Hub Destination customer master data with daily.
  • Responsible for defining all reports BEx Query Designer, Analyzer.
  • Analyzed Info Cubes created and maintained aggregates to improve the performance.
  • Developed load strategy and created process chains to automate the process according to different load schedules.
  • Automated the Data loads with recursive info packages.
  • Post production support, monitoring daily loads and defect fixing, Process Chains maintenance for master data and transaction data.
  • Scheduling of Weekly maintenance chains which are PSA Deletions, Compression and Drop empty F partitions with various retention periods.
  • Creating Customer message to SAP on critical issues.
  • Creating and maintaining secondary indices on the ODS and Master data tables.
  • Creation and maintenance of BIA index for high priority cubes and monitoring the functions.
  • I have been involved in Application critical activities like Inventory Management reloads, Cycle Zero Activities during the Drop Go Live, Delta queue maintenance activities, Involved in Historic data loading projects and also repair load activities during weekends.
  • Implemented OSS notes while solving tickets.
  • For all the repetitive problems during process chain monitoring, Creating RCA (Root cause analysis) and providing solutions to monitoring team.

Confidential

SAP BI Consultant

Environment: SAP ECC 6.0, SAP BI 7.0, ABAP/4, FI/CO, SD, CRM BEx query Designer, BEx Analyzer

Responsibilities:

  • Installed Business Content for Financial and Profit Center Accounting Info Cubes and customized the FI-GL, FI-AR and FI-AP business content cubes for meeting the business requirements
  • Handled accounts payable cubes, accounts receivable cubes as a part of SAP BW implementation
  • Involved in Star-Schema design, data loading, Query creation, for CRM
  • Enhancing the business content GL Cubes as per the enhanced GL Extractor 0FI GL 4 to include new fields like username, tax code and tax base amount
  • Delta with extractions involving standard COPA data sources, FI-GL.
  • Expertise in troubleshooting the load failures and extensively used Error-DTP for correcting the loads
  • Compressed the Info Cube data for better performance.
  • Worked on Design & Development on BW / CRM and FI related BI objects & queries.
  • Development of Custom Objects and Queries for Trade and Non-Trade Chargeback / Disputes.
  • Developed BW reports using BEx analyzer, created queries with variables, restricted key figures, calculated key figures, conditions, exceptions etc
  • Designed global structures to in corporate query requirements.
  • Created reports using Business Explorer (BEx), Calculated/Restricted Key Figures, Structures, Hierarchies, User Exits, Characteristic/ Formula/Hierarchy/Hierarchy-Node/Text Variables, Conditions, Exceptions & Currency Translation and Web templates.
  • Worked on the WAD (Web Application Designer) to create specific templates based on the business requirements of the user.
  • Monitor the data loads from various source systems like R/3, CRM, SEM and APO by means of process chains.
  • Mange the data targets by having the correct and up to the date data.
  • Reconstruct the data requests from PSA in case of data load failure.
  • Importing transports from the development systems to the production system.
  • Perform pre-manual and post manual actions while importing the transports.

Confidential

SAP BI Consultant

Environment: SAP ECC 6.0, SAP-APO, SAP-BW 3.5, SAP BI 7.0, BEx query Designer, BEx Analyzer

Responsibilities:

  • Worked with Business Content as well as creating Info sources, Info Objects, Info cubes, ODS Objects, Transfer/Update Rules.
  • Extensively involved in setting up of procedures for extracting data from SAP R3 by using Logical Information structures (LIS), Extracted Logistic Data like Customer, Sales Order, Delivery and Billing from SAP R/3.
  • Setup Flat File extractions for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structures, and Metadata maintenance for the Info Source and Source System. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the Source System.
  • Uploaded master and Transaction data from Files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1). Customized Info Objects, Info Sources and Info Cubes.
  • Created Info Packages and Info Package Groups and scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems in BW.
  • Involved in Creating and Maintaining Info Cubes, Operational Data Store, Data Sources, Transfer Structures, Communication Structures, Transfer Rules and Update Rules, Info Packages, Info Packages groups for Data Targets.

Hire Now