EXPERIENCE SUMMARY:

• A SAP Certified (S 0005026456 ) BI Senior Consultant with Expertise & Experience of 11.5 Years in Handling Confidential, Media & Entertainment & Confidential Domain Projects.
• Worked on BW Technical and Functional migration from 3.x to 7.4 and 7.4 to 7.5 for the BI data model (in different application areas e.g. Sales, Inventory, Procurement, FI, CRM, SRM etc.).
• Hands - on experience in 7 live implementations in SAP Business Intelligence 7.0.
• Excellent command over SAP BI Modelling, Reporting and Extraction.
• Having exposure in BI security.
• Having Exposure towards integrated planning and Enterprise portal.
• Extensive experience in Customization skills - Data source enhancements, Generic extractors, User Exits configuration and customization, transformations including start, end, expert and individual routines and DTPs, Update/Transfer rules modifications, Info Providers.
• Experience working on Upgrade/Migration of SAP BW to BW on HANA DB
• Extensive experience in preparing baseline testing approaches for data extraction and reporting during DB2 to HDB migration.
• Worked on BW LSA/LSA++ data modelling.
• Specialized in Analytics and reporting along with extensive work on the areas of Sales and Distribution (SD), SRM, CRM, Materials Management (MM), Inventory Management (IM) and M&E, having in-depth business process knowledge.
• Rich experience in BW ON HANA migration, information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
• Strong knowledge of BEx Query Designer, Calculated & Restricted Key Figures, RRI (Jump Target), Conditions, Exceptions, Infoset Queries, Queries on Multi Providers, Web Application Designer, JavaScript, BEx query performance issue.
• Well versed with the Performance optimization through data modeling changes. Full working knowledge of the administrative process in BW including compression, PSA maintenance, aggregate maintenance, creation of indexes and statistics.

PROFESSIONAL EXPERIENCE:

Confidential

BW Senior Consultant

• Hands on experience & strong exposure with latest HANA Modelling objects is required (Creation of Composite Providers, Advanced DSO's, Open ODS Views etc.).
• HANA Architecture experience and Native HANA Modelling Experience.
• Optimization of the BW on HANA data flows, experience in working with large datasets & developing complex BEx queries.
• Working extensively on BI related ABAP work e.g. Routines and enhancing the extractor to achieve the business logic.
• Involved in BW on HANA sizing preparation.
• Extensively worked with BASIS & DBA team to identify the risks while start & stop services on HANA DB.
• Participated in migration of DB2 to HANA 2.0
• Extensively involved during Sap BI 7.4 to 7.5 upgrade .
• Involved in Baseline testing for SAP BW/BI Flows on DB2 & HANA DB.
• Involved in stress testing during BW on HANA migration.
• Handled various testing business patterns by executing identified noise test cases on HANA DB.
• Involved in production support for critical business flow in Warner’s business.
• Involved in the Quality audit process on behalf of BW team
• Involved in enhancements with respect to the user requirement.
• Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW
• Participate in peer development reviews to ensure proper documentation on features and interoperability within the entire system.
• Participate in developing test plans, including regression tests for newly developed features.
• Worked with SNOW ticketing system to create tickets for issues encountered day to day and prioritizing the issues and solving them efficiently.
• Interaction with TV business owners and Functional teams for requirement gathering.
• Creation of detail level technical Documents.
• Created Attribute Views, Analytical View and Calculation Views based on best practices in HANA Studio.
• Worked on SAP HANA Sizing using quick seizer and Optimization of HANA system.
• Enhanced Standard Data Sources for CRM and FI Modules.
• Worked on creation and processing of data through APD and Open hub.

Confidential

Developer

• Involved in creation of Universes.
• Involved in creating the connection between BEx query and Universes.
• Created the Web Intelligence Document in BO XI R/3 environment.
• Worked on Dashboard report format.
• Involved in creation of mock-ups.
• Coined rules for survivorship of attribute groups between source systems feeding the customer data to the master data hub.
• Data mapping and attribute mapping for incoming and outgoing customer master data from the customer hub.
• Presented profiling reports to determine the match and merge criteria for the POC.
• Test planning and strategizing to optimize testing related tasks.
• Definition of business scenarios to be used for integration testing across the ecosystem.
• Preparation of extensive list of test cases to be used in end to end integration testing.

Confidential

Consultant

• Involved in generating the data sources in R\3.
• Developed the flow from R/3 to SAP BI system for MM module which involves in creating Data sources, DTP’s, DSO’s, info cubes & Multi provider.
• Involved in enhancing the reports as per user requirement.
• Involved in daily/weekly monitoring.
• Develop cutover activities which should perform during the support pack up-gradation.
• Involved in designing the technical specifications.
• Involved in designing web templates.
• Involved in designing Aggregation levels, filters, Planning functions and planning sequences.
• Involved in designing of Info Cubes, DSO’s and MultiProvider.
• Developed transformations and DTP’s in data flow.
• Designed the virtual info provider based on generic extraction.
• Implemented RRI Concept into the model.
• Worked on creation of users and granting authorization values to them.
• Extensively involved in transporting the object across the systems (DEV QA, QA PROD)
• Extensively used restricted key figures, calculated key figures and formulas in developing the queries.
• Developed the reconciliation flow into the data model.

Confidential

Consultant

• Involved in developing the Info objects, Info cubes, Datastore objects and transformations
• Involved in creating DTP (Data Transfer process) to update the data from PSA to Data targets.
• Extensively involved in Master Data and transactional Loading to the Data Target.
• Extensively worked on Web application designer to execute the reports in the browser
• Involved in defining the cell definitions.
• Extensively worked on transactional and cell based queries.
• Extensively used Restricted key figures, calculated key figures and formulas in developing the queries
• Extensively worked on Structures, Free characteristics, Filters, Variables with variable processing types in designing the reports.