Data Sap

Krishna Abhishek Mekala Mobile: +91-974*******

SAP BW/BODS / HANA Consultant Email: ******.********@*****.***

Career Objective:

Having 6 +Years of experience in Information technology as SAP BW/ BODS & HANA consultant with good functional knowledge and effective in executing multiple tasks and assignments ahead of schedule, highly motivated, and eager to develop rapidly and take on greater responsibility. I am involved in Both Implementation and Support.

EXPERIENCE SUMMARY

Worked in implementations projects, support projects, maintenance projects, migrations and upgrade projects and upgrade projects

Focused on data extractions, modeling and reporting.

Worked on inventory management data sources and FI data sources.

Worked on BI in Data Modeling and Extraction.

Worked on BI 7.0 Query Designer

Worked on Performance tuning to improve data loading and query performance by using Compression, Aggregates, Rollup, Indexes, and Query Properties etc.

Capable of handling errors while extracting from SAP R/3 and loading the data into its respective Info Providers.

Extraction of the data from different sources (Oracle, SQL server, Flat files) and loaded into SQL Server database.

Developed complex mappings in SAP BODS to load the data from various sources into the Target systems using Data Integrator and Platform.

Adept in creating repositories both local and central and scheduling sequential or conditional job with Data Services management console.

Worked extensively on integration of Business Objects Data Services with SAP BW, SAP ECC and Non-SAP Data Sources like Oracle, MS SQL Server & Flat Files.

Monitoring of BODS Jobs and fixing the issues.

Creating Jobs, Work Flows, Data Flows and executing jobs using Designer.

Loading data into Target using Flat files and from database used as Source.

Working on SAP HANA

Technical skills:

ERP Packages : SAP R/3 ECC 6.0

Data warehousing: SAP BI 7.0.

Reporting Tools : SAP Business Explorer, Bex Analyzer, Business Objects.

Employment History:

Worked as a SAP BI Consultant in SEAL INFOTECH Pvt. Ltd, Hyderabad from February 2013 to September 2016.

Working as SAP BW/BODS & HANA Consultant in MERCK GROUP, Bangalore from September 2016 to till date.

Project: #6

Client : M-Cloud for Finance

Environment : SAP ECC 6.0, SAP BI 7.3, SAP BODS, SAP HANA, SAP BO: 4.1

Project : Implementation

Duration : December 2017 to till date

Client Information:

Merck Group (known as EMD Millipore in the United States and Canada) is the life sciences subsidiary of Merck. It was formed when Merck acquired the Millipore Corporation in 2010.

Merck is active in Europe, Asia, the Americas and Africa. Divided into three business units – Bioscience, Lab Solutions, and Process Solutions – Merck Millipore is a supplier to the life science industry.

The Millipore Corporation was founded in 1954, and listed among the S&P 500 since the early 1990s, was an international biosciences company, known widely for its micrometer pore-size filters and tests.

In 2015 Merck finalized its acquisition of Sigma-Aldrich, and merged Sigma-Aldrich with Merck Millipore. The combined business of Merck Millipore and Sigma-Aldrich will be known as "Merck KGaA, Darmstadt Germany".

Responsibilities:

Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.

Created advanced DSO’s based on the M-Cloud Finance models.

Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.

Uploaded Master Data and Transaction Data from R/3 from all available source systems using ODP Data sources.

Designed and created Process Chains for master and transaction data loading from other source systems.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Project: #5

Client : SAPNEXT/SAPNOW

Environment : SAP ECC 6.0, SAP BI 7.3, SAP BODS, SAP HANA, SAP BO: 4.1

Project : Implementation & Support

Duration : September 2016 to till date

Client Information:

Merck Group (known as EMD Millipore in the United States and Canada) is the life sciences subsidiary of Merck. It was formed when Merck acquired the Millipore Corporation in 2010.

Merck is active in Europe, Asia, the Americas and Africa. Divided into three business units – Bioscience, Lab Solutions, and Process Solutions – Merck Millipore is a supplier to the life science industry.

The Millipore Corporation was founded in 1954, and listed among the S&P 500 since the early 1990s, was an international biosciences company, known widely for its micrometer pore-size filters and tests.

In 2015 Merck finalized its acquisition of Sigma-Aldrich, and merged Sigma-Aldrich with Merck Millipore. The combined business of Merck Millipore and Sigma-Aldrich will be known as "Merck KGaA, Darmstadt Germany".

Responsibilities:

Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.

Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.

Uploaded Master Data and Transaction Data from R/3 from all available source systems.

Designed and created Process Chains for master and transaction data loading from other source systems.

Fixing the Process chain errors at Production server to provide up-to-date data for End User.

Worked extensively on integration of Business Objects Data Services with SAP BW, SAP ECC and SAP HANA.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Imported data through flat files into SAP HANA and created schema and required tables.

Created complex reports and user objects like measure objects by using aggregate aware function to create the summarized reports.

Created Report Level Variables, Objects and Formula to create new columns based on the result set.

Experience in designing, developing and scheduling BODS ETL jobs sourcing from both SAP and Non SAP source systems.

Created Adhoc BODS jobs based on the User Request.

Educate Users to understand the system to get more requirements.

BW Objects creation using BW Modelling Tools at S4 HANA Level.

Project: # 4

Client : Luxottica Retail

Environment : SAP ECC 6.0, SAP BI 7.3, SAP BODS, SAP BO: 4.1

Project : Support

Duration : April 2014 to Sept 2016

Client Information:

Luxottica is the world's largest eyewear company, controlling over 80% of the world's major eyewear brands. Its best known brands are Ray-Ban, Persol and Oakley. It also makes sunglasses and prescription frames for a multitude of designer brands such as Chanel and Prada, whose designs and trademarks are used under license. Luxottica also makes sunglasses branded Giorgio Armani, Burberry, Stella McCartney, Versace, Vogue, Miu Miu, Tory Burch, and Donna Karan.

Responsibilities:

Designed Developed and Modified Info Objects, DSO’s, Info Cubes, Transformations and loaded.

Created Jobs, Work flows, Data Flows and Scripts using various transforms to successfully load data from multiple sources into desired target.

Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.

Responsible for data accuracy, by cross checking with source system. (SQL queries).

Experience in designing, developing and scheduling BODS ETL jobs sourcing from both SAP and Non SAP source systems.

Created and modified Reports based on Users request.

Adhoc extraction of the data from different sources (Oracle, SQL server, Flat files) and loaded into SQL Server database.

Developed complex mappings in SAP BODS to load the data from various sources into the Target systems using Data Integrator and Platform.

Adept in creating repositories both local and central and scheduling sequential or conditional job with Data Services management console.

Worked extensively on integration of Business Objects Data Services with SAP BW, SAP ECC and Non-SAP Data Sources like Oracle, MS SQL Server & Flat Files.

Monitored scheduled Jobs in Data Services Management Console.

Managed and monitored several data loadings, captured the errors and corrected the bugs.

Worked on transporting the objects among landscape systems.

Analysed the error log for trouble shooting batch jobs.

Good knowledge in Load Testing (uploading volumes of data in test environment)

Ensured proper Dependencies and proper running of loads (Incremental and Complete loads).

Monitored scheduled Jobs in Data Services Management Console.

Interacted with Clients to get the inputs from the user resolve and close the tickets.

Project: # 3

Client : Vasanth & Co

Environment : SAP ECC 6.0, SAP BI 7

Project : Implementation

Duration : Oct 2013 to Feb2014

Client Information:

Vasanth & Co is a premium chain dealer of consumer electronics, home appliances and mobile phones having base in Chennai, India. Vasanth & Co was started in 1978 and currently has 56 + showrooms in almost every town in Tamil Nadu. The company’s turnover is reported to be over 500 corers Indian Rupee (INR) or 100 Million USD in 2007.

Responsibilities:

Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.

Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.

Uploaded Master Data and Transaction Data from R/3.

Designed and created Process Chains for master and transaction data loading from flat files.

Worked extensively on LO Cockpit. Loaded the data from R/3 to BW and used Initialization with Delta Update and Full Update methods.

Involved in creation of info set and Multiproviders.

Created Process chains for different data flows. Manage data targets by having the correct data analyzed the errors in the data loads while monitoring.

Designed Info cubes and set up extraction from both R/3 modules and from flat files.

Identifying Data sources, Installation of Data sources and editing as per requirement.

Maintain list of all the activities for all the tickets until it is closed down.

Worked on activating the Standard Business Content object like Info Cubes, ODS Objects, Info Objects etc.

Process chains Testing.

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

Designing and mapping source and target structures to load transactional data and master data, setting up delta load.

Extracting Master & Transaction Data using Generic Data Sources from OLTP.

Data Extracting from the Source system using LO Cockpit and Generic Extractions for all the logistics data.

Monitoring of Background Jobs

Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.

Prepared Test Cases for UAT and attended client meetings

Project: #2

Client : Manipal University

Environment : SAP BI 7.3 SAP BO

Project : Support

Duration : July 2013 to Nov 2013

Client Information: The Manipal Group, a pioneer in higher education services with a 60-year-old legacy of excellence, also owns and operates campuses in Sikkim and Jaipur in India, and in Nepal, Malaysia, and Antigua, in the Caribbean.

Responsibilities:

Monitoring of Daily, Weekly & Monthly Loads using Process Chains.

Analyzing Frequent Load Failures.

Involved in Handling Tickets.

Maintain Work History for all the tickets and Involved in maintain documents for Support Activities

Project: #1

Client : Butterfly Appliances Ltd

Environment : SAP ECC 6.0, SAP BI 7.3 SAP BO

Project : Implementation & Support

Duration : March 2013 to August 2013

Client Information: The Butterfly Group, Pioneers in Stainless Steel Appliances started operations four decades ago. The company was the first in India, to introduce Stainless Steel Pressure Cookers and Vacuum Flasks and in the LPG and Mixie divisions. Products are also exported to the United Kingdom, Canada, Australia, Japan, Middle East and the East Asian Countries, among others.

Responsibilities:

Responsible for development/implementation and support of BI.

Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.

Monitored the data loadings and consolidated data with R/3 side.

Scheduling and monitoring of Daily, Weekly and Monthly data loading using process chains.

Fixing the Process chain errors at Development server to provide up-to-date data for Development.

Conducted knowledge sessions in client location on SD, MM, PP, HR, and FI.

Created and modified Reports based on Users request like Gross Profit Analysis Report, sales achievement Analysis, Top ten customers etc.

Involved in Unit Testing of the Data targets comparing the results with the SAP ECC data

Worked on 2LIS_02_S001 Customer Data source setup table filling.

Designed Developed and Modified Info Objects, DSO’S, Info Cubes, Transformations and loaded these objects with Master data and Transactional data from SAP R/3 Modified all the reports based on client requirements moved the request to Quality.

Worked on reports using Selections, Conditions, Exceptions, Filters, Free Characteristics, Restricted Key Figures, Calculated Key Figures, and Variables.

Created and Scheduled Process Chains based on client requirement.

Created Info packages with Full Loads, Delta loads, Initialization without/with data transfer.

Education qualifications:

Masters in Information Technology from Swinburne Institute of Technology Australia, 2010.

Contact this candidate