B4Hana Greenfield Implementaion

•  SAP BW4HANA Implementation and Migration of NAG HR system.
• Designed SAP Lumira and power BI Dashboards  for Higher Management.
• Created stories and Dashboard on SAP Analytics Cloud using HANA views.
• My Primary focus is to design, develop and test the SAP Business Object components required to support the Project analytic reporting requirements.
• Migrated 30 Bex/WAD reports to Webi and Analysis for office reports.
• Standard BOBJ Audit reports were implemented to see the BW/BOBJ report Usage/statistics and Performance of the reports.
• Worked on IDT for creating universes and has knowledge on BOBJ administration in CMC tool.
• As part of Change requests extensively involved in Requirement Gathering, Solution designing and End to End development is done.
• Worked extensively with BW STMS Transports and BOBJ Promotion management.
• Parallelly handled Support Incidents and data load monitoring is done.

SAP Native hana Implementations

• As an offshore consultant: discussion with Onsite manager and customer regarding development/delivery, offshore co-ordination and status updates to customer regarding delivery and Estimation related to change requests and service requests.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption 
• Performance of the sql scripted views are improved via materializing the views by creating a back-end table and populating the table via AMDP code which pushes the calculation logic from application layer to Database layer.
• Conversion of BW views to HANA live views.
• Conversion of scripted vies to Graphical views.
• Automated Alert programs are created to trigger email alerts to team based upon the exceptions (SQL query output conditions, If zero records inserted to a table or Less than 5000 records insert happens).

Fossil Support and Enhancements

Responsibilities:

• Spoc for Transition of Support activities to Infosys Limited.
• Creating Application Information documents of all the data flows and reports during Transition Phase.
• Single point of contact from onsite and responsible for critical weekly reporting service management with Client.
• Optimization of NA flash reports is done, Automated alert system was created for Business which in turn helped offshore team to proactively follow up with source teams and fix the issues before Business was online.
• Worked on POSDM reconciliation issue between source and BW,Traffic counter,Payroll data issues, NA flash report issues.
• Worked on the fixes for the frequently occurring issues and took initiative to avoid them using automations and made my offshore team to contribute the same and brought value add to client.
• Single point of contact from onsite for Priority 1 and priority 2 tickets came across different applications like NA flash reports, Open to Buy(OTB),BODS job failure,VISTEX issues. Handled tickets with different priority, Service requests and Service Enhancement requests.
• Migration of finance data from BW to Hyperion with the help of BODS data flows.
• Developing Workflows, Data flows based on the specifications using various stages in BODI/BODS.
• Providing support for UAT, moving the transports through CHARM to the production environment, giving Post implementation support as well as resolution of issues that occur in these phases.

Symphony Project End to End implementation

Responsibilities:

• Interacting with client to gather the business requirements.
• Understanding the Functional specifications of the change requests and converting them into Technical specifications.
• Involved in the full life cycle implementation.
• Involved in development of Data flows in SAP BW for Master Schedule – SNP and Long Term Schedule – SNP data sourced from APO(Advanced Planner and Optimizer) for future projections.
• Involved in development of Data flows in SAP BW for history data extractions from ECC for PSI reports
• Created generic extractors, enhanced of Data Sources, Involved in end to end Implementation for SD, and MM modules
• Involved in creation of BEx queries for PSI development like structures,CKF’s,RKF’s,Cell restrictions, Formula Variables and queries were sourced to Webi for reporting.
• Involved in FUT of individual data flows and system integration testing of the complete data flows.
• Worked closely with users during User acceptance testing(UAT) of all the reports deployed in the project
• Providing support for UAT, moving the transports through Rev Trac to the production environment, giving Post implementation support as well as resolution of issues that occur in these phases.

POS Retail Hana

Responsibilities:

• Worked closely with business users in understanding the Business requirement and developing the Technical Spec.
• As part of POS Retail Hana project Inventory, Sales, Traffic count Flows in SAP BW were analyzed  and involved in documentation of business flows in SAP HANA
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BI reports on HANA data.
• Developed Attribute views based on the master data tables
• Worked on POSDM Data Source 0RT_PA_TRAN_CONTROL to extract Sales data from PIPE.
• Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to the HANA studio tool.
• Created Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool.
• HANA studio Functions like Conversion, Mathematical, String, Misc. and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views
• Created Attribute Views and calculation Views and involved in Transport Cutover actives.
• Involved in UAT Phase, Scheduling and monitoring of Process chains for data loads.
• Reconciled Reports data with source system data.
• Had taken the lead responsibility for the support project with the team size 10.
• As a part of production support involved in monitoring load failures, Delta loads, Incident management, change requests/Problem management and monitoring the performance of the system.
• Managed and worked on Production incidents based on priority.
• Worked almost on every kind of problem being faced during extraction and data loading and succeeded in providing the resolution for all the problems encountered
• Interacting with client to gather the business requirements for change requests and converting them into Technical specifications.
• Supported the system with the concepts like weekly, monthly and daily, E2EInventory, Sales and the master data.
• Worked with the 3rd party scheduling like Batch man tool for the data loads
• Involved in query optimization and performance tuning of data on BW.