RAVINDRA CHAPPA

In my role as a Senior Developer overseeing the migration from SAP BW Data Warehouse to Snowflake Data Lake, I proficiently utilized a suite of cutting-edge tools to ensure a seamless transition and optimize data operations:

• Data Warehouse: Leveraging the power and flexibility of Snowflake, I orchestrated the migration process to establish a robust and scalable data foundation in the cloud.
• ELT (Extract, Load, Transform): I employed Azure Data Factory (ADF) to execute efficient ELT processes, facilitating the seamless extraction, loading, and transformation of data between disparate systems with agility and precision.
• DevOps: Utilizing Git as the cornerstone of our DevOps practices, I implemented version control and collaboration strategies to streamline development workflows, enhance code quality, and promote seamless integration across teams.
• Data Transformation: I harnessed the capabilities of dbt (Data Build Tool) to streamline and automate data transformation pipelines, enabling rapid iteration and ensuring data integrity and consistency throughout the migration process.

By harnessing the capabilities of these tools, I played a pivotal role in driving the successful migration initiative, delivering enhanced data agility, scalability, and performance within the organization.

• Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
• Skilled at working independently and collaboratively in a team environment.
• Self-motivated, with a strong sense of personal responsibility.
• Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
• Demonstrated leadership skills in managing projects from concept to completion.

Client Description:

Hewlett Packard Enterprise Company (commonly referred to as Hewlett Packard Enterprise or HPE) is an American multinational enterprise information technology company based in Palo Alto, California, founded on 1 November 2015 as part of splitting of the Hewlett-Packard Company. HPE is a business-focused organization with four divisions: Enterprise Group, which works in servers, storage, networking, consulting, and support; Services; Software; and Financial Services.

DXC Technology was founded on April 3, 2017, when the Hewlett Packard Enterprise Company (HPE) spun off its Enterprise Services business and merged it with Computer Sciences Corporation (CSC). At the time of its creation, DXC Technology had revenues of $25 billion, employed 170,000 people and operated in 70 countries.

Roles & Responsibilities:

Requirement Gathering: Understand and gathering requirements by interacting with business analysts, Department heads and Project Managers.
Extraction: Experience in extracting data from SAP R/3 using LO Cockpit and generic extractors. Also, OLTP Extraction (Transaction Data, Master Data Attributes, Text, Hierarchies).
Data Modeling: Has knowledge in Advanced DSO(ADSO), Composite Providers and LSA++.Has knowledge in the Migration of SAP BW 7.3 to SAP BW4HANA via Remote Conversion based on the requirement for the initial setup of the BW systems for parallel execution of data.
Proficient in BW/BI data modeling,Data Store Object design & Administration, Multi provider design, Info source design, and Info object design.
Reporting: Expertise in reporting using BEx Query Designer.
SAP BI ABAP: Created Start Routine, End Routine, Field Routine, Expert Routine, User Exit and Function Module code for generic data source.
Business Content: Exposure to the Business Content and Implementation of the same in the appropriate Functional area and to activate business content.
SAP R3 Source Configuration systems: Extracted Data from Flat File (CSV & Notepad), ECC / R3, SAP BW (Data marts), SAP MDM Master Data Management system, SAP CRM, Oracle Data Base.
Transformation: Expert in building custom Update rules, Transfer rules, Transformations, Start Routine and End Routine.
Data Staging & Loading: Experience with proper data architecture, PSA maintenance, Info Packages, Data Transfer Process (DTP), Delta functionality, Flexible Master data staging, and debugging loads using the Data load Monitor.
Information Broadcasting: Used this tool to send Reports to Group E-mail as well as Portal Publishing in different formats like HTML, MHTML, and PDF.
Performance Tuning: By maintaining Aggregates, Compression, Partition, indexing of info cubes and use of statistics for the same.
Production Support: Experience with Process Chains to schedule batch jobs. Configured security roles and authorizations for both BW objects and reports.
Data Migration: Experience in data migration from BW 3.5 to BI 7.0.
Testing: Experience in Unit test, Integration testing, User acceptance tests (UAT).

Client Description:

Hewlett Packard Enterprise Company (commonly referred to as Hewlett Packard Enterprise or HPE) is an American multinational enterprise information technology company based in Palo Alto, California, founded on 1 November 2015 as part of splitting of the Hewlett-Packard Company. HPE is a business-focused organization with four divisions: Enterprise Group, which works in servers, storage, networking, consulting, and support; Services; Software; and Financial Services.

DXC Technology was founded on April 3, 2017, when the Hewlett Packard Enterprise Company (HPE) spun off its Enterprise Services business and merged it with Computer Sciences Corporation (CSC). At the time of its creation, DXC Technology had revenues of $25 billion, employed 170,000 people and operated in 70 countries.

Client Description:

Hewlett Packard Enterprise Company (commonly referred to as Hewlett Packard Enterprise or HPE) is an American multinational enterprise information technology company based in Palo Alto, California, founded on 1 November 2015 as part of splitting of the Hewlett-Packard Company. HPE is a business-focused organization with four divisions: Enterprise Group, which works in servers, storage, networking, consulting, and support; Services; Software; and Financial Services.

DXC Technology was founded on April 3, 2017, when the Hewlett Packard Enterprise Company (HPE) spun off its Enterprise Services business and merged it with Computer Sciences Corporation (CSC). At the time of its creation, DXC Technology had revenues of $25 billion, employed 170,000 people and operated in 70 countries.

Client Description :

The Arabian Geophysical & Surveying Company (ARGAS) was established in January 13th, 1966 as a Limited Liability partnership between industrialization and Energy Services Company (TAQA) which owns 51% of the shares and CompagineGenerale de Geophysique (now CGG) which owns the remaining 49%.

Roles & Responsibilities:
I had worked on SIRs (System Investigation requests). These SIRs are Break fixers or Enhancements requests.
Involved in SAP BW Unit Testing, Integration Testing.
Designed process chains and involved in process chains monitoring.
Checking Short dump errors in BW production system and reloading the data.
Monitoring Month end and mid-month loads.
Being knowledge of ABAP was also involved in writing Transformation routines also.