Life Cycle 4 Hana

Professional Profile

SAP BI and BI related ABAP consultant with 13 yrs. of professional experience which includes in BI 7.0, 7.3, 7.4, 7.5 on HANA & BW 3.5, BW/4HANA and Procedural ABAP. Involved in life cycle implementations that includes Data modeling, Data extraction and reporting along with Production Support for BI and involved in analysis, design, coding and testing phases of different projects for BI related ABAP (Like developing custom Extractors, Start Routines, End Routines, Customer Exits, Expert Routines and Field Level Routines etc.) Have good functional knowledge of SAP R/3 application areas like SD, MM, and FI. And enhanced my skill to SNP Outboard Data tiering SDA+ to offload data from BW systems to AWS S3 Bucket for BW on Hana and BW/4 HANA and having SAC 2 years of experience.

Recent Accomplishments with Cognizant :

Project Name : EDW Data life cycle Management

Duration : June 5 2023 to till date

Client Name : Novartis

Team size : 05

Environment : ECC 6.0, S/4 HANA, BW 7.5 on HANA, BW/4HANA, SNP OTB Data Tiering

SDA+

Role : Technology Architect

Summary:

Novartis AG is a Swiss multinational pharmaceutical corporation based in Basel, Switzerland. Consistently ranked in the global top five, Novartis is one of the largest pharmaceutical companies in the world and was the fourth largest by revenue in 2022.

Cognizant is currently supporting for the client Novartis. IT Development of both SAP and Non-SAP systems. I am currently engaged with EDW archiving Team of this client. Following below are my daily routine and responsibilities.

Responsibilities:

Analyzing the technical feasibilities for offloading data from BW to AWS through SNP OTB SDA+.

Involved in development of objects from Scratch.

Suggesting the Functional in configuration scenarios if they miss any configuration.

Involved in the OFFSHORE Development team and involved in Communication with ONSITE functional for requirement analysis.

Involved in Functional testing as well as integration testing phases.

Involved in initial offloading and regular offloading phases.

Involved in offloading analysis for objects identification for offloading.

Reloading data from offloaded area to original Info provider

Accomplishments with TCS.

Project Name : Thomson Reuters

Duration : Oct 2019 to Till Date

Client Name : Thomson Reuters

Team size : 07

Environment : ECC 6.0, S/4 HANA, BI 7.4,7.5, BW/4HANA

Role : ABAP and BI Consultant

Summary:

Thomson Reuters Corporation is a Canadian multinational media conglomerate. The company was founded in Toronto, Ontario, Canada, where it is headquartered at the Bay Adelaide Centre.

Thomson Reuters was created by the Thomson Corporation's purchase of the British company Reuters Group in April 2008 and is majority owned by The Woodbridge Company, a holding company for the Thomson family.

TCS is currently supporting for the client Thomson Reuters IT Development of both SAP and Non-SAP systems. I am currently engaged with Enhancement Team of this client and projects of ER SAP BW Development Team. Following below are my daily routine and responsibilities. This Project is currently Operated from TCS-Hyderabad Location.

Responsibilities:

Coding the requirements for Extractors based on Function Module, Routines: Start, End, Field Level, Expert Routines .

Analyzing the technical feasibilities for all the requirements.

Reviewed and correct the Code of other developers at the time of data load performance issues.

Involved in development of objects from Scratch.

Developed the Custom Extractors, Data flows and Bex Reports for T.code : ME2N and Pulses bulk Stock by understanding the business with the help of excel sample data which was provided by end users .

Suggesting the Functional in configuration scenarios if they miss any configuration.

Involved in the OFFSHORE Development team, and also involved in Communication with ONSITE functional for requirement analysis.

Involved in Functional testing as well as integration testing phases.

Project Name : Alighntech

Duration : Mar 2019 to Sep 2019

Client Name : Alighntech

Team size : 12

Environment : ECC 6.0, BI 7.4

Role : ABAP and BI Consultant

Summary:

Align Technology is a manufacturer of 3D digital scanners and clear aligners used in orthodontics. It is headquartered in San Jose, California; it manufactures the aligners in Juarez, Mexico and its scanners in Israel. Aligntech is one of the world’s largest suppliers of digital scanners and Clear aligners. etc.

TCS is currently supporting the Aligntech IT Development of both SAP and Non-SAP systems. I am currently engaged with Enhancement Team of Aligntech Project of ER Development Team. Following below are my daily routine and responsibilities. This Project is currently Operated from TCS-Hyderabad Location.

Responsibilities:

Coding the requirements for Extractors based on Function Module, Routines: Start, End, Field Level, Expert Routines.

Analyzing the technical feasibilities for all the requirements.

Review Code of other developers.

Involved in development of objects from Scratch.

Performing Design and Code reviews for team members.

Suggesting the Functional in configuration scenarios if they miss any configuration.

Involved in the OFFSHORE Development team, and also involved in Communication with ONSITE functional for requirement analysis.

Involved in Functional testing as well as integration testing phases.

Involved guiding new team members.

Accomplishments with IBM India Pvt. Ltd.

Project Name : OLAM

Duration : May 2018 to March’2019

Client Name : OLAM International Limited

Team size : 35

Environment : ECC 6.0, BI 7.5 on HANA

Role : BI and ABAP Package Analyst

Summary:

Olam International is a leading agri-business company in the world, operating from seed to shelf in 70 countries, supplying food and industrial raw materials to over 23,000 customers worldwide.[1] Olam is one of the world’s largest suppliers of cocoa beans and products, coffee, cotton and rice etc.

This Project is going on multiple locations in IBM - like Kolkata, Bangalore and Hyderabad etc.

OLAM is also having Sub Projects in each location like OLAM Wave1, OLAM Wave2 etc. The Each Sub Project has divided into teams like Development, Production Support, Performance tuning etc. I belong to Hyderabad OLAM Wave1 Development team. This team consists of 35 members.

Responsibilities:

Coding the requirements for Extractors based on Function Module, Routines: Start, End, Field Level, Expert Routines.

Analyzing the technical feasibilities for all the requirements.

Review Code of other developers.

Involved in development of objects from Scratch.

Has been worked as single point of contact for many objects in the project.

Performing Design and Code reviews for team members.

Suggesting the Functional in configuration scenarios if they miss any configuration.

Involved in the OFFSHORE Development team, and also involved in Communication with ONSITE functional for requirement analysis.

Involved in Functional testing as well as integration testing phases.

Involved guiding new team members.

Project Name : Ernst & Young

Duration : Jan 2018 to May 2018

Client Name : Ernst & Young

Team size : 5

Environment : ECC 6.0, BW 3.5, BI 7.3

Role : Performance Analyst/Tuner

Summary:

EY (formerly Ernst & Young) is a multinational professional services firm headquartered in London, England. EY is one of the largest professional services firms in the world and is one of the “Big Four” accounting firms.

EY operates as a network of member firms which are separate legal entities in individual countries. In India, EY is among the leading providers of advisory, tax, transactions and assurance services. The organization is also the number one professional services brand* in India, which is a testimony to our relentless commitment to deliver exceptional client service. EY has 16 offices spread across 10 cities in India. *as per Global Brand Survey, conducted by an independent research agency commissioned by EY.

This Project is going on multiple locations in IBM - like Kolkata, Bangalore and Hyderabad etc.

Ernst & Young is also having Sub Projects in each location like E&Y Mercury Wave1, E&Y Mercury Wave2 etc. The Each Sub Project has divided into teams like Development, Production Support, Performance tuning etc. I belong to Hyderabad E&Y Mercury Wave1 performance tuning team. This team consists of 5 members.

Responsibilities:

Coding the requirements.

Analyzing the technical feasibilities for all the requirements.

Review Code of other developers & tuning of performance.

Monitoring the jobs.

Worked on tickets for performance tuning of Jobs.

Worked on tickets related to EWA alerts related to performance tune of routines.

Project Name : Abbott

Duration : June 2015 to Jan 2018

Client Name : Saphega and Mylan

Team size : 23

Environment : SAP ECC 6.0, BW 3.5, BI 7.3

Role : SAP BI/BW Consultant

Summary:

Abbott Laboratories is a global health care company. It operates in more than 150 countries. The company headquarters are in Abbott Park, Illinois. Abbott Labs main activities are broad range of branded generic pharmaceuticals, medical devices, diagnostics, nutrition products, including Ensure, a line of meal replacement shakes. The company's in-vitro diagnostics business performs immunoassays and blood screening. Its medical tests and diagnostic instrument systems are used for customers worldwide by hospitals, laboratories, blood banks, and physician offices to diagnose and monitor diseases such as HIV, hepatitis, cancer, heart failure and metabolic disorders, as well as assess other indicators of health.

This Project is going on multiple locations in IBM - like Kolkata, Bangalore and Hyderabad etc.

Abbott Labs is also having Sub Projects in each location like SAPHEGA, Mylan, Symphony etc. The Each Sub Project has divided into teams like Development, Production Support etc. I belong to Hyderabad ABBOTT LABS SAPHEGA & MYLAN BW Production Support Team.

The Hyderabad Sub Project SAPHEGA & MYLAN BW Production Support team consists of 23 members.

Responsibilities:

Maintenance & Support of the existing SAP BI implementation.

Monitoring the Process chain and Daily, weekly, and Monthly Data Loads using RSPC, RSPCM and RSMO.

Actively Involved in Rectification of Load Failure errors in Master Data and Transaction data loads.

Created Process Chains and Scheduled as per the requirements.

Involved in creation of Generic Data Sources for Extracting data from SAP R/3 source system

as per the Business requirements using Views/tables, Function module and Info set query.

Creation of Info packages for schedule the data load process with Full and Delta update mode.

Evaluated Project wise aggregates for every 3 months and deactivated unnecessary aggregates and created new ones

Involved in editing the error records in the ERROR stack and uploaded these records by using error DTP.

Created Analysis Process Designer (APD) and loaded data to Direct Update DSO for further analysis

Rectification of Job failures because of Source system errors, Short Dumps, Duplicate records, Attribute change run failure, ODS activation problem, Rollup Step Failures, Invalid character and Lock Issues.

Fixing different kinds of load failures independently and prepared root cause analysis

to submit to client.

Creation of reports based on flat file loading with BEX Query Designer by using Free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, conditions and Exceptions.

Actively involved in sending reports to users by using bex broadcasting.

According to business requirement worked on Start Routine, End Routine and Field level routines, customer exits.

Creating generic Data sources and enhancing standard extractors (RSO2) to meet financial requirements. Worked on DB connect and Open Hub Destinations.

As part of Quality management standards to deliver the objects in quality performed unit testing and recorded the test results in unit test case documents.

Project Name : BP ADAM

Duration : March’14 to June 2015

Client Name : BP WR5

Team size : 19

Environment : SAP ECC 6.0, BW 3.5, BI 7.3

Role : SAP BI Consultant

Summary:

BP is one of the world’s largest energy companies providing its customers with Fuel for Transportation, energy for heat and light, retail services and Petrochemical products. BP’s main activities are the exploration and production of crude oil, natural gas, refining, marketing, supply and transportation and the manufacture and marketing of petrochemicals.

This Project is going on multiple locations in IBM - like Kolkata, Bangalore and Hyderabad etc.

BP is also having Sub Projects in each location like ADAM, Whiting Wave, Nike, WRM, WRC and WR5 etc. The Each Sub Project has divided into teams like Development, Production Support etc. I belong to Hyderabad BW WR5 Production Support Team. The Hyderabad Sub Project BW WR5 Production Support team consists of 19 members.

Responsibilities:

Involved in M&S and Enhancement work requests for Extracting data from SAP R/3 source system.

Handled the work request to fix all the known issues in NGL process chains to reduce the manual effort and created process chains to automate the work in North Star weekend master data loads.

Provided the NGL loads check list document to team which will be mainly useful for the new team members and maintained the tracker for all the data load errors for future reference.

Involved in Regression testing for North Star, NGL and Angola servers and coordination with basis team for transport relevant issues during package release.

Involved in Month close and Q close Interface activities like PSW, PC Recon, Netting DB and ECC etc. along with Month close schedule preparation activities during close times and handled Touch point calls with users during Month close & Q close.

Handled desktop testing when ever patches applied to WR5 system.

Given Knowledge Transfer Sessions to all the new Team members for North Star, NGL and Angola loads and helped to team members while they are monitoring the production system.

Provided the technical guidance/support to all the consultants in the team including weekends

Checking the daily time schedule for the run & ensuring that the jobs are finished within the specified time frame and informing Clients about the Success/Failure of the loads as soon as the activity is finished.

Creation of Tickets at the time of load failures & assigning it to the concerned user group. Also sorting out the problem if the problem is related to BW

Involved in performance tuning of queries by maintaining Aggregates, Compression and partition.

Worked on tickets related to EWA alerts related to performance tune of cubes and routines.

Worked on tickets for performance tuning of loads.

Project Name : BP ADAM WRM

Duration : July’ 2012 to Mar 2014

Client Name : BP WRM

Team size : 5

Environment : SAP ECC 6.0, BI 7.0

Role : SAP BI Consultant

Summary:

BP is one of the world’s largest energy companies providing its customers with Fuel for Transportation, energy for heat and light, retail services and Petrochemical products. BP’s main activities are the exploration and production of crude oil, natural gas, refining, marketing, supply and transportation and the manufacture and marketing of petrochemicals.

This Project is going on multiple locations in IBM - like Kolkata, Bangalore and Hyderabad etc.

BP is also having Sub Projects in each location like ADAM, Whiting Wave, and BW WRM Enhancements etc. The Each Sub Project has divided into teams like Development, Production Support etc. I belong to Hyderabad BW WRM Enhancements Team. The Hyderabad Sub Project BW WRM Enhancements team consists of 5 members.

Responsibilities:

Developing/enhancing the structure from time to time as per the client’s requirement & creating the transports for the same.

Implemented Upgrade Project from BW 3.5 to BI 7.0

Developed BEX Reports and having knowledge in WEB Reports in BI7.0

Created Customized Info Objects, Info Sources and Info Cubes.

Handling the tickets of priority according Service Level Agreement.

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

Used ODS to stage the data before transferring the extracted data to the Info Cube using standard data sources and custom data sources.

Improved query performance and load performance using Aggregates, Indices, packet size, Data Selection and Data Compression.

According to business requirement worked on Start Routine, End Routine and Field level routines, customer exits.

Creating generic Data sources and enhancing standard extractors (RSO2) to meet financial requirements. Worked on DB connect and Open Hub Destinations.

Created Drill through Queries (RRI) from summarized Info cubes to detail ODS Objects.

Involved in ABAP routines (Start Routine, End Routine, Field level Routine) related to BI and expertise in and data source enhancements related to BI data sources and in BI reporting.

Weekly Communicating with clients about the ticketing issues status updating and to gathering the requirements and analyzing business-reporting requirements that could be satisfied by the users.

Conducting review meetings with Business Users and Stack Holders. Gathering user requirements to present the solutions to the user groups and training the users.

Written custom report for comparing BW Hierarchies.

Project Name : Kraft Foods

Duration : March’12 to July 2012

Client Name : Kraft Foods

Team size : 40

Environment : ECC 6.0

Role : Developer

Summary:

"Kraft Foods Inc. is North America's largest food and beverage company. It is the second largest in the world. Kraft Foods' core businesses are in beverage, cheese and dairy, snack foods and confectionery, convenience foods and cereals.

Catalyst is the name of Kraft’s multi-year program to streamline and standardize - to integrate - how it works throughout the company and do business with customers, suppliers and other external partners

Catalyst helps Kraft business to simplify and harmonize their processes with integrated way of working. It provides better information within Kraft, with Customers and with Suppliers. It provides the capabilities to grow the business, strengthen sales execution, reduce cost and eliminate redundant work. It replaces 50+ major systems with one integrated platform.

The Development work in this Project consists rollouts, Extending business for other products like Snacks etc.

Responsibilities:

Coding the requirements.

Analyzing the technical feasibilities for all the requirements.

Review Code of other developers & tuning of performance

Provide support for Production related problems

Project Name : GMOV (General Motors Harmonization Project)

Duration : May ’11 to Mar ’12

Client Name : GM (General Motors)

Team size : 18

Environment : ECC 6.0

Role : Developer

Summary:

General Motors Company, one of the world’s largest automakers, traces its roots back to 1908. With its global headquarters in Detroit, GM employs 209,000 people in every major region of the world and does business in more than 120 countries. GM and its strategic partners produce cars and trucks in 31 countries and sell and service these vehicles through the following brands: Buick, Cadillac, Chevrolet, GMC, Daewoo, Holden, Isuzu, Jiefang, Opel, Vauxhall and Wuling. GM’s largest national market is China, followed by the United States, Brazil, the United Kingdom, Germany, Canada and Russia. GM’s on Star subsidiary is the industry leader in vehicle safety, security and information services.

The Development work in this Project consists the following scenarios: Migration, Roll Outs and

Support. The Project involves migrating the existing SAP systems to new version of SAP ECC 6.0, simultaneously bringing the different functionality (like Project Systems, Controlling, and Sales) into SAP.

Technical architecture involves developing new Transactions, developing interfaces to upload the data from legacy systems into SAP, developing new reports.

Responsibilities:

This Project was going on Multiple Locations in IBM – Like Pune, Hyderabad, and Bangalore.

I Belong to Hyderabad Development Team. The Hyderabad Team consists of 18 members.

Involved in development of objects from Scratch.

Has been developed New Interfaces to replace the legacy systems functionality.

Has been worked as single point of contact for many objects in the project.

Performing Design and Code reviews for team members.

Suggesting the Functional in configuration scenarios if they miss any configuration.

Involved in the OFFSHORE Development team, and also involved in Communication with ONSITE functional for requirement analysis.

Involved in Functional testing as well as integration testing phases.

Involved guiding new team members.

Achievements:

Has been awarded “TAC ABAP Best Developer” for the quarter and “Deep Skill” for two quarters respectively.

Token of appreciation from the management for completion of complex objects in the time span.

Educational Background

Bharathi is bachelor’s in computer science (BSc Computer Science) from Andhra University.

MCA from Sikkim Manipal University.

Technical Skills

Sap Skills…

Programming languages : BI Related ABAP (Extractors, Routines etc. )

Datawarehouse/ETL Skills : SAP BW 3.5, BI 7.0, 7.4, 7.5 on HANA, BW/4HANA .

SAP HANA STUDIO, SNP Outboard Datatiering SDA+

Data warehouse Reporting tool : SAP Bex and having knowledge in WAD, SAP BO WEBI

and SAC

Methodology : Waterfall, Agile.

Non-Sap Skills…

Operating Systems : Windows (95, NT, and 2000, XP, Vista, 7).

Databases : ORACLE 8.0, 11g

Contact this candidate