Skills
Project history
COMPANY(CLIENT) : NGA HR
PROJECT : Migration of BEX to BOBJ reports/Enhancements/Support
DURATION : Dec 2017 – Till Date
ENVIRONMENT : SAP BW/4 Hana 2.0,SAP BW 7.3,SAP BOBJ 4.2 SP3,Analysis for Office and SAP Lumira
LOCATION : Hyderabad, INDIA
DESCRIPTION : Northgate Information Solutions Limited (Northgate) is the holding company of NGA Human Resources, a provider of specialist software and outsourcing services for human resources (HR) and payroll, based in the United Kingdom.
Responsibilities:
- BW/4 Hana Implementation and Migration of NAG HR system and designed Lumira Dashboards for Higher Management
- 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
- 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.
COMPANY(CLIENT) : INFOSYS(Burlington Northern Santa Fe Railway(BNSF))
PROJECT : Enterprise Asset Management(EAM) Enhancements
DURATION : Jan 2017 – Nov 2017
ENVIRONMENT : SAP HANA 2.0 SP10, ABAP, SAP BW 7.4
LOCATION : Hyderabad, INDIA
DESCRIPTION : BNSF Railway Company is the largest freight railroad network in North America.
Responsibilities:
- 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).
COMPANY(CLIENT) : INFOSYS(Fossil)
PROJECT : Fossil Support and Enhancements
DURATION : OCT 2015 – DEC 2016
ENVIRONMENT : SAP ECC 6.0, SAP IS-RETAIL, ABAP, SAP BW 7.3, BW-IP, BO 4.0
LOCATION : Richardson, Texas, USA.
DESCRIPTION : Fossil Group, Inc. is an American fashion designer and manufacturer company. Their brands include Fossil, Relic, Michele Watch, Skagen Denmark, Misfit, WSI, and Zodiac Watches. Fossil also makes licensed accessories for brands such as Skechers, Emporio Armani, Karl Lagerfeld, Michael Kors, Marc Jacobs, formerly Marc by Marc Jacobs, DKNY, Diesel, Kate Spade New York, Tory Burch, Chaps, Burberry and Armani Exchange.
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.
- Worked closely with users during User acceptance testing(UAT) for SER’s,
- 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.
COMPANY(CLIENT) : INFOSYS(KRAFT FOODS)
PROJECT : Symphony Project End to End implementation
DURATION : DEC 2014 – SEP 2015
ENVIRONMENT : SAP ECC 6.0,SAP BW 7.4.
LOCATION : Chicago, Illinois, USA.
DESCRIPTION :Kraft Foods Group, Inc. is an American grocery manufacturing and processing conglomerate headquartered in Chicago, Illinois, part of the Kraft Heinz Company.
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.
COMPANY(CLIENT) : INFOSYS(Adidas Group)
PROJECT : POS Retail Hana
DURATION : JUNE 2014 – NOV 2014
ENVIRONMENT : SAP BW 7.3, SAP Hana 1.0
LOCATION : India
DESCRIPTION : Adidas AG is a multinational corporation, founded and headquartered in Herzogenaurach, Germany, that designs and manufactures shoes, clothing and accessories. It is the largest sportswear manufacturer in Europe, and the second largest in the world, after Nike
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.
COMPANY(CLIENT) : INFOSYS(Adidas Group)
PROJECT : POS Retail Support
DURATION : APR 2012 – MAY 2014
ENVIRONMENT : SAP BW 7.3
LOCATION : India And Germany
DESCRIPTION : Adidas AG is a multinational corporation, founded and headquartered in Herzogenaurach, Germany, that designs and manufactures shoes, clothing and accessories. It is the largest sportswear manufacturer in Europe, and the second largest in the world, after Nike
Responsibilities:
- 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.
COMPANY(CLIENT) : INFOSYS(Adidas Group)
PROJECT : POS Retail RFC’s,GRS 2.0
DURATION : FEB 2011 – MAR 2012
ENVIRONMENT : SAP BW 7.0
LOCATION : India
DESCRIPTION : Adidas AG is a multinational corporation, founded and headquartered in Herzogenaurach, Germany, that designs and manufactures shoes, clothing and accessories. It is the largest sportswear manufacturer in Europe, and the second largest in the world, after Nike
Responsibilities:
- Interacting with client to gather the business requirements for the change requests.
- Understanding the Functional specifications of the change requests and converting them into Technical specifications.
- Involved RFC’s for GROW Tool, CIS Local Tool – Data Provisioning, Size Viability Time Period , Implement Gift Card Reconciliation process to generate file in SVS format for NAM Retail, NAM-ADD KEY CHARACTERISTICS TO REPORTS ORR-23 & 25, MAP 3rd Party RFC
- Implemented the Data Life cycle Management (DLM) concept for the performance improvement in the system.
- Worked with the Batch man tool for the data loads using the process chains.
- Handled complete clearing of error stack across all transaction data flows as a post-production support.
- Involved in developing Queries in BEx query Designer
- Used Standard BEx Reports for User requirements using Filters, free Characteristics, Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables.
- Worked closely with users during User acceptance testing(UAT) of all the reports deployed in the project
Handled post production support and imparted training to reports.