Senior Associate
mindtree
Total years of experience :12 years, 5 Months
Working as a SAP BW BI HANA consultant responsible for Data Modelling, Data Administration and Developing Reports and Dashboard.
Project 6: Adidas Wholesale BI KSR.
Client: Adidas
Project type: Migration and Support
Project start date: November 2013
Project end date: Till date
Description: We are involved into database migration of existing SAP BW MSS database to HANA database and providing support for the applications running on BW on HANA
Roles and Responsibilities: • I was part of HANA DB migration team.
• Played role of functional consultant during migration.
• Involved into the BW system data cleanup activity as a pre migration step.
• Transforming InfoCubes & DataStore Objects to HANA-optimized objects.
• Delta handling.
• Checked BW schema in HANA DB using HANA Studio.
• Analysis Authorization testing for BW on HANA.
• Perform end to end testing for existing data flow.
• Involved in creation of HANA artifacts like views, tables, attributed and measures.
• Process chains maintenance during migration.
• Was responsible for testing on the newly created SPO objects.
Project 5: Projected Revenue Dashboard.
Client: Mindtree Ltd
Project type: Implementation
Project start date: June 2013
Project end date: Oct 2013
Description: Projected Revenue Report is a report which helps in forecasting Enterprises Revenue for future months based on effort booking and resource staffing in the customer projects. This report contains multiple data points in source system like: 1. Staffing data,
2. Contractual data,
3. Project detail,
4. Timesheet data,
5. Leave data.
Roles and Responsibilities: • Requirement gathering through cross-functional coordination with various teams like Business Finance, Operations, Sales Support etc.
• Detailing of the requirement, identification of the data sources.
• Architecture conceptualization for data flow in BW system.
• Installation of Business Content for Cross-Application Time Sheet.
• Using standard datasource for time sheet data 0CA_TS_IS_1 and 0CA_TS_IS_2.
• Creating delta enabled Generic Datasource for customize application.
• Modeling of Dso, Cubes, Multiprovider with start routine and end routine in transformation.
• Created Bex reports development using customer exit variable, text variable, structure, selection.
• Integrated Bex reports into Bex WAD to build dashboard using charts, Analysis, table, container, text, dropdown box, button group and formatting table using CSS properties.
• Schedule broadcasting for the detail report.
• Process chain creation and define alert categories for monitoring it.
• Role creation for authorization of report and dashboard.
• Transportation of complete model from DevelopmentQualityProduction server.
• Successfully rolled out the dashboard with go live support.
Project 4: Talent Acquisition Reports and Dashboard.
Client: Mindtree Ltd
Project type: Implementation
Project start date: November 2012
Project end date: March 2013
Description: This report/dashboard displays various TA Metrics like select to offer ratio, offer to join ratio, NHR Vs offer, joined left report, ageing report, decline analysis. It also shows TA Pillar (Operational Excellence) KPIs like Median and Quartile report.
Roles and Responsibilities: • Direct interaction with TA functional owner to understand the requirement and accordingly design the dataflow in BW.
• Used DB connect to fetch data from MSS DB tables.
• Modeling of DSO, Cubes and Multiproviders with complex End routine in DSO Transformation.
• Wrote Infopackage routine to enable delta load.
• Merged TA data with Operations and HR data to generate many useful reports like Pillar, NHR and Joined/Left reports.
• Source data validation with BI report by using Excel capabilities.
• BEx Report development using RKF, CKF, static and dynamic filter.
• Designed BEx reports in accordance to Cognos System for further development of Dashboards.
• Transport of entire object from Development to Production server.
• UAT with the end-customer and presentations.
• Creation and monitoring of process chains.
• Prepare BI technical document.
Project 3: Plan Vs Actual Report.
Client: Mindtree Ltd
Project type: Implementation and support
Project start date: Aug 2012
Project end date: Oct 2013
Description: This report will display plan and actual values for verticals and corporate functions. Using this report vertical and functions head can understand and control the expenses of their respective departments. This report also contain detail report which helps in MIS preparation.
Roles and Responsibilities: • Implementing this report for every financial year according to changed organization structure and plan budget.
• Using the standard datasource 0FI_GL_14.
• Authorization management.
• Enhanced the standard datasource with field STBLG to identify the reverse posting.
• Bex report creation using variables (authorization, customer exit, manual input/output), exception and condition.
• Created RRI.
• Currency Translation.
• Resolve SID corruption issue and handling regular issues like process chain fail.
• Enable the process chain failure alert through email.
• Educating end users and answer their query.
Project 1: Adidas Wholesale BI KSR.
Client: Adidas
Project type: Support
Project start date: December 2011
Project end date: July 2012
Description: Adidas AG, is a global leader in the sporting goods industry and offers a broad portfolio of products. And we are providing support and maintain the existing Wholesale Business Intelligence (BI) landscape as part of the KSR (keep system running) sub-track. The key objective of this engagement was to provide operational support and incident management services for the existing Wholesale BI landscape. Wholesale BI is further subdivided in to three application area: 1. Sales
2. GOPS
3. Marketing
Roles and Responsibilities: • I was working into sales application area.
• Involved into monitoring, ticket resolving services and change implementation.
• Worked on different category of tickets like: incident management, Authorization management, Data accuracy & availability and performance issue.
• Worked on COPA Extraction to extract data from AFS Source System (R/3)
• Monitoring and maintenance the process chains on the basis of daily, weekly & monthly.
• Manual loading and rolling up the data into data targets if any adhoc load requested by business.
• Job and process monitoring.
• Maintaining Work History for tickets until it is closed down.
• Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after data loads.
• Transporting the requests from Development to Quality and then to Production
• Active co-ordination with Team Leads to follow up on Call Backs with pending resolutions.
• Background Job Maintenance (Monitoring logs, Scheduling, Cancelling long running jobs.
• Checking and deleting old lock entries
• Involved in maintaining documentation for all the Support Activities.
• Resolved issues related to IDOC Or tRFC Errors, dso activation fail, data load failure, lock issue, dump in info package due to huge volume of data.
• Creation of aggregates, perform rollup and compression on cubes.
• User and role creation.
• Perform analysis authorization.
• Perform repeat delta.
completed my engineering in IT
• B.E from RNS Institute of Technology, VTU in 2011 with First Class.