Data Sap

Subramanyam B Contact No: +91-915*******

SAP BW Consultant E-mail:***************@*****.***

Professional Summary

SAP BW/BI Consultant with 4.2 years of Professional experience, Involved in documentation, development, implementation, testing and support phases of SDLC.

Have good knowledge in Data Modeling, Extraction and Reporting.

Experience in Data Extraction, Data Loading, Installing business content and customizing the object as per requirement.

Shown good demonstrations to Identifying and flagging potential issues impacting the execution of Projects and Excellent ability to quickly grasp business requirements and data models .

Experience in Scheduling, Monitoring, Creating Data Source, Transformation and Data Transfer Process, Info-Cubes, DSO Objects, Multi-Providers, Info Set, Open Hub Service.

Expertise in Performance Issues using Dimension Design, Aggregates, Indexes, Compression, and partitioning.

Proficient in uploading master data and transactional data both from flat files and SAP ECC Systems and various other sources.

Experience in setting the procedure for LO Extraction and generic data sources using views, tables and maintained Delta from SAP source systems.

Experience in creating process chains for loading data into data targets and monitoring daily, weekly and monthly schedule data loads.

Good experience in maintaining loading performance and Query performance.

Worked extensively with BEx Query Designer, BEx Analyzer and Web Application Designer for creating custom and enhanced reports.

Experienced in Transport the requests from Dev system to Quality,Production Environments.

Experience in BI-IP (Integrated Planning) tool development of Real time Info cubes, Characteristic Restrictions, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.

Having good knowledge of SAP HANA Modelling like Creating Attribute, Analytical and Calculation views.

Able to learn new technologies, concepts and Business processes quickly, evaluate their applications, and apply them to business need when appropriate.

Versatile team player as well as independent contributor with good problem solving and interpersonal skills.

Ability to deliver with in timelines, Evaluation/Prototypes to address the client requirements.

Technical Skills

ERP : SAP BI 7.0, IP&7.3, SAP BW 3.5, SAP HANA, SAP R/3 &

SAP ECC 6.0

SAP Modules : FI, CO, COPA, SD, MM, PP, APO

Reporting Tools : BEx Analyzer, BEx Query Designer,

Web application Designer, SAP Business Objects 4 .0

Operating Systems : Windows 98/NT/7/Vista and XP

Databases : MS SQL Database, Oracle 9i

Programming Languages : C, HTML, XML

Educational Qualification

B.pharmacy from Jawaharlal Nehru Technological University in 2009.

Experience Summary

Worked as a SAP BW/BI Consultant for Sunpro Cyber Systems Pvt. Ltd., from Apr 2012 to till date.

Project Details

Project 3:

Client : Tata Power

Project Type : Implementation & Reporting

Role : SAP BI Consultant

Duration : Sep 2015 to till date

Environment : SAP BW 7.3, SAP ECC 6.0

Client Description:

Tata Power is an Indian electric utility company based in Mumbai, Maharashtra, India and is part of the Tata Group The core business of the company is to generate, transmit and distribute electricity. With an installed electricity generation capacity of about 8560 MW. it is India's second largest private power producer. At the end of August 2013, its market capitalization was $2.74 billion (INR 182 billion).

Responsibilities:

Design and modeling of InfoCubes and DSO’s to combine and stage data from different areas of SD, MM and FI,BPC.

Created the DSO Objects and cubes, mapped the Transformations and created the DTP to load the data into Target.

Extracting data using LO Cockpit and handling Inventory Management.

Maintaining reconciliations to verify the data in SAP ECC and SAP BW are same or not after the data loads.

Modified the existing reports with new fields and transported to production system.

Developed the customized reports from respective modules based on client requirement.

Formatted the reports as per the client’s needs with inclusion of new columns.

Creating Queries using BEX using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.

Experience in using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.

Project 2:

Client : VSP

Project Type : Implementation & Reporting

Role : SAP BI Consultant

Duration : Apr 2013 to Aug 2015

Environment : SAP BI 7.0, SAP ECC 6.0

Client Description:

Visakhapatnam Steel Plant, popularly known as Vizag Steel, is the most advanced steel producer in India with the help of German and soviet technology. Its products have been rated the best in the world market. Almost 80% of its income comes from the exports of steel products to Japan, Germany, United States, Singapore, Dubai, Australia, South American countries and many more. The company has grown from a loss making industry to 3 billion dollar turnover Company registering a growth of 203.6% in just 4 years.

Responsibilities:

As one of the Technical consultants in implementation team, involved in gathering user requirements, analyzing the internal business units and data modelling.

Involved all kinds of development activities like Objects and Info Providers Creation, Reports Creation, data loading, object transports and data loading issues fixing.

Experience in BI-IP (Integrated Planning) tool development of Real time Info cubes, Characteristic Restrictions, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.

Design and modeling of InfoCubes and DSO’s to combine and stage data from different areas of SD, MM and FI.

Created the DSO Objects and cubes, mapped the Transformations and created the DTP to load the data into Target.

Extracting data using LO Cockpit and handling Inventory Management.

Maintaining reconciliations to verify the data in SAP ECC and SAP BI are same or not after the data loads.

Involved in managing of Info cube, which involves Info cube content, performance issues like Indices, Statistics, compression of Info cube and rolling up the data to the aggregates.

Creating Queries using BEX using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.

Scheduling daily, weekly, and monthly data loads.

Project 1:

Client : Balasore Alloys Limited

Project Type : Production Support

Role : SAP BI Consultant

Duration : Apr 2012 – Mar 2013

Environment : SAP BI 7.3, SAP ECC 6.0

Client Description:

Balasore Alloys Ltd, formerly known as Ispat Alloys (IAL), a part of Ispat Group was incorporated on 31 May '84 as a public limited company and engaged in the business of manufacturing silicon and Ferro alloys. In Dec.'87, it came out with a public issue of FCDs, aggregating Rs 99.99cr to finance its expansion and to strengthen long-term resources. It has set up a Rs 132-cr chrome ore pellet plant at Orissa, a Rs 100-cr project in Tripura and a Rs 624-cr gas-based sponge iron project in Maharashtra.

Responsibilities:

Involved in Ticket handling, resolving tickets with in SLAs.

Monitored and checked the daily scheduled runs using process chains.

Maintaining Reconciliation's to verify the data in SAP ECC and BI after the data loads.

Involved in escalating tickets regarding extractions, Performance Issues and also system.

Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.

Involved in resolving issues related to process chain errors and corrective action.

Maintaining the queue for the system generated tickets and customer generated tickets.

Daily monitoring of Info-cubes and DSO object requests.

Involved in Load monitoring using RSPC, RSMO, SM37, and SM50.

Increased the query performance with the help of RSRT.

Improved performance by implementing indexes, aggregates and repartitioning of Cubes.

Involved in the activities like root cause analysis for aborted process chains.

Personal Details

Name : B. Subramanyam

Father’s Name : B. Subbarao

Gender : Male

Date of Birth : 18th May, 1986

Marital status : Single

Passport Number : J5478667

Nationality : Indian

Permanent Address : Door no: 9/288-3, Nandyal Road,Mydukur

Mydukur (MD), Kadapa (DIST), AP-516172.

Contact this candidate