M Vimal Current Designation: SAP BI/BW Consultant
Preferred LOC: Bangalore, Chennai
Having 5 Year 2 months of experience in SAP BI and BW on HANA
Having experience in SAP Business Objects BI 7.4 suite of products,AFO, BW on HANA.
Involved in End to End Migration and Support projects
Has exposure on BI related ABAP
Data Warehouse: SAP BI 7.0, 7.3,7.4
ERP Packages: SAP ECC 6.0, SAP R/3, 7.4 with HANA DB SP 19
Operating Systems: Windows XP/2003, Windows 7,
Development Languages: ABAP,SQL query language.
Databases: HANA DB, Oracle 10G.
Reporting Tools: SAP BEx Query designer,
BEx Analyser, Analysis for office(AFO),BO.
Technical skills in SAP BI include, Modelling, Extraction, Reporting using BEx tool.
Worked on modelling concepts which includes Info provider, Info objects (Characteristics, Key figures), Data source, Data source objects, Info cubes, Multi providers, Info package, Transformation, Data transfer process, start routine, End routine, Field routine, worked on Query designer (Creation of structures, calculated key figure, restricted key figure, variables (formula variable, characteristic variable, Text variables), Conditions, Exceptions and Web Application designer
Technical skills in ABAP/4 include design, development and debugging of ABAP programs
Report programming - Both classical and interactive reporting
Self-motivated and ability to work both independently or as part of a team.
Assertive, Analytical, Decision-making and team building skills.
Efficient in understanding business requirement of clients and subsequent technical implementation of the requirement.
Data Extracting from the Source system using Generic Extractions for all the logistics data
Involved in Info Cube maintenance i.e., Compression, Roll-up for Aggregates
Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain
Had attended HANA training in Wipro and supporting the HANA system in the Project.
Over all Experience
Technology: SAP BI – BW
Software engineering: Requirement study, Analysis, Implementation, Unit
Testing, Non-regression tests, Product acceptance testing.
Project: Philips (Migration and Support)
Company: Wipro Technologies
Role: Module Lead
Environment: SAP 7.4 with SP19
Duration: May 2017 to till date
Philips is a big ecosystem and currently I am part of consumer lifestyle team.
I am Working as Module lead in the Philips project and handling all the critical activities, MEC, YEC BEX releated issue.
Completed SAP HANA training from Wipro and supporting BW on HANA developments (7.4) and also old flows are migrated to HANA with new business requirement.
We perform the activities like MEC and YEC which is too critical for FI and BCS closure.
New Demand and forecast flows has been migrated to HANA flow. Had taken part in the handshake mechanism between BW to HANA system(SDA Connection).
Supporting the future HANA projects and handling the support issues in HANA system.
Usage of analysis for office in the existed queries.
Roles and Responsibilities:
Incident Management,roster,DM board activity, kaizens,KPI,RCA.
Leading the 6-member team to work within the SLA.
Tracking the incidents to the Closure within the SLA time.
Close monitoring of MEC and YEC to be closed on time without deviations.
FI and general ledger data will have extracted from different source system and send to BCS system for validation part.
There are different FI reports which validated the data based on different ORU’s.
Motivating the team to work on odd hours to get the resolution of incidents and issue raised
No hesitation to support the team to catch up for the technical call during late night hours.
Taking the ownership of year end activities and month end activities for the system.
Project: Oki DATA (maintaince & support)
Client: OKI DATA LTD.
Duration: Feb 2016 to March 2017
Support is to be done for Job for 3 regions (Japan, Europe (UK), Americas). Issues faced by the client in these systems are addressed and solved through tickets.
Only High priority tickets will be raised in this project (P1 &P2), All the ticket raised in this projects needs to be resolved in 2 hours which is the SLA.
Implementation of major CRs as well as Bug Fix CRs. Solving High priority tickets. Process Chain monitoring.
Problem solving, improving an existing process and improvement in process chain was done.
Team Size: 3
Monitoring the data loads for US region and solving the tickets during the night shifts.
Resolving the incidents raised within the 2 hours SLA.
Attending the technical calls on the priority incidents raised.
Performance and optimization of data loads are carried out.
Optimization and improvements of critical flow has been carried out.
Had created SALES report On S605,S604(MCSI) table,FI General ledger reporting table.
We provide reports to financial managers of clients to plan their business based on the amount in bank and also annual financial report would be generated.
We provide reporting by forecasting and demand done for their business which helps them utilize the funds.
Involved in the migration of Euro currency projects where currency GBP is converted into Euros across the systems.
Project: BAT OPSIT BI (maintaince & Support)
Client: British American Tobacco
Role: Developer/ Support
Duration: Dec 2014 to JAN 2016.
Involved in data model designing. Creating and Enhancement of Info objects, Info cubes, Data Store Objects (DSO), Transformations, DTP and Info packages based on the requirement document.
Created Generic Data Source for the Actual data, which is based on the View and Table as per the requirement
Enhancement of Data source using CMOD.
Extensively worked on routines based on the requirement
Development of Technical specification documents for the developments assigned
Created utilization report and Travel Report.
Created Marketing Dashboards, and Quality Dashboards
Creation, Scheduling and monitoring of Process Chains.
Create reports on BEx query and use it as a source for webi reports.
Extensively used various techniques like Breaks, Sectioning, Ranking, Filtering, Conditional formatting, drilling to develop the WebI reports.
Involved in performance tuning by Data filtering and selected values
Year of Passing
M.Tech (Work integrated learning programme )
Vellore institute of technologies
Bhavan Vivekananda college
Maths, Physics, computers
Army school R.k Puram,Sec-bad
Date of Birth : 16th DEC 1989
Father’s Name : P Madhavan
Mother’s Name : K Vasantha
Languages Known : English, Hindi (R/W/S), French(R/W/S) learned, Tamil, Telegu (Speak)
Nationality : Indian.
Address : 4/255/5 Vasantha Illyam, Parvathi nagar,Uduppam road, Pudhanchandai, Namakkal, Tamil Nadu 637019
I hereby confirm that the information given above is true to the best of knowledge and believe that you make proper consideration of me.
Place: Coimbatore Date: M Vimal