Senior Consultant In Sap Analytics (papm/bi/bo/hana) Resume
2.00/5 (Submit Your Rating)
SUMMARY:
Currently working as a senior SAP PaPM, HANA/BI/BO consultant at Deloitte. Total 10+ years of experience in SAP. Worked with some of the world’s largest consulting firms like Confidential and Deloitte, for fortune 500 clients.
SKILL:
SAP Profitability and Performance Management (Advanced)
SAP HANA - Modelling and Analytics (Advanced)
SAP-BI frontend and backend design (3.5/7.0/7.3/7.5 ) (Advanced)
SAP Business Explorer: Design and Reporting
SAP-BI ABAP
SAP-BO WEBi
SAP BW on HANA
SAP Lumira
SAP Analysis for Office
PROFESSIONAL EXPERIENCE:
Confidential
Senior Consultant in SAP Analytics (PaPM/BI/BO/HANA)
Responsibilities:
- Worked onsite for Confidential as a client, in a role of senior techno-functional consultant for PaPM finance scenarios like transfer pricing and intercompany cost-plus implementation.
- Developed end to end PaPM models for fetching data from different SAP and non-SAP datasources (e.g. BW, Big Query, Manual input, HANA, Oracle, flat files), massaging the data for cost plus and revenue scenarios (functions like joins, calculations, derivations, allocation for calculations like markup, tax, cost exclusion, revenue and cost segmentation, etc.) and deriving the final result set (calculations like policy, PnL, etc.)
- Modelled complex PaPM allocation scenarios (e.g. Post and Pre 998 allocation, multiple driver combinations)
- Performance optimization measures including parametrization, table/database partitioning, allocations with offset, etc.
- SAP HANA Object modelling; calculations view (graphical and script based), procedure, table functions, analytical view, flowgraphs, etc.
- HANA data replication, SLT/SDI. Custom SLT replication using includes.
- S4 HANA CDS views modelling with annotations.
- Designing end to end HANA data flows with foundations, attribute, analytical and calc views.
- Report development using Lumira, SAP BO WEBi tools on top of HANA views.
- Performance optimization of HANA views for better report runtime.
- Lead a team of 10 resources both technically and functionally for handling enterprise HANA reporting requirement design, delivery and hypercare.
- Major areas handled for HANA reporting are procure to pay, supply chain management and warehouse management.
- Developed reporting models within HANA and BW for complex scenarios including hierarchies and FI-CO.
Confidential
Senior ConsultantResponsibilities:
- Worked on End to End Implementation for SD, FI, CO, MM, PM, FM, HR, QM, PP and TR modules in BI.
- Functional requirement gathering with the end client and map them to technical dimensions to create a technical document.
- Planning and executing new and customized data flows in SAP BI 7.4 for the technical specs approved by the client.
- Activating BC application component hierarchy in dev and successfully migrating it to quality and production environments.
- Business content datasource activations; both master and transaction data.
- Activating extract structures for LO datasources.
- Creation of new datasources; view and FM based. FM coding for the same.
- Enhancement of existing data sources and writing user exits.
- Transportation of objects from Development to Quality and Production.
- Modelling end to end dataflows in BW 7.4 for client’s reporting requirements.
- Performance tuning of Queries by maintaining Aggregates, Compression, Partition of Info cubes and Line item dimensions.
- Query development and designed queries using BEx analyzer for data presentation. Used Variables, calculated and restricted key figures, conditions, filters and exceptions for BEx queries.
- Designing WEBi reports on top of the BEx reports developed.
- Extensively used BEx Analyzer & Browser to build queries to access data from BW data targets like Info Cubes, DSO etc.
- Maintaining the reconciliation between R/3 and SAP BW.
- Developed Multiproviders and Info sets based on reporting requirements.
- Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and FI extractions, and GENERIC extractions.
- Start, End, fields and expert routine coding in BW from the point of view of customization.
- Managing a team of 4 resources.
- Managing target plans for the BI deliverables with the project management.
- Day to day micromanagement in the team for the targets set.