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.