Rahul Sirivella

Detail-oriented Data Analyst with 3+ years of experience in data migration and development projects. Proficient in utilizing SQL Server Management Studio (SSMS) with TSQL and SQL Server Integration Services (SSIS) for data integration, including ETL and modeling. Experienced in leveraging Azure services for cloud-based data solutions and adept at utilizing Workday reporting tools for advanced analytics. Skilled in translating complex data into actionable insights to drive business decisions. Strong communicator and collaborative team player committed to delivering high-quality results in a dynamic environment.

Project #1: LATAM Migration to Azure Cloud

Client: LATAM (NSR, Columbia, South Cone & Brazil)

Roles and Responsibilities:

 Migrate all the on-premises data to the Azure cloud using Medallion architecture.

 Migrate all Application data and Linked servers’ data, which is

used for Reporting purpose.

 Centralization of data from all the LATAM regions into Cloud

platform.

 Map Source to Destination data to achieve accurate date

without missing anything.

 Improve performance of the existing process using advanced SQL

techniques.

 Build/modify complex Stored Procedures to perform ETL

operations.

 Build/modify complex SSIS Packages to Perform ETL operation

and as well as monitored.

 Performed JOB monitor activities.

 Lead TP Performance (Process) in implementation and

maintenance. As part of this process, build new KPIs and modify

KPIs client-wise based of TPBR (TP Performance Backend)

Requirement).

 Involved in AVAYA/GENESYS & BMS projects as a DA to

understand the requirement and guide the developers.

 Worked along with the data engineer in pipeline building for the

movement of exciting data to Cloud Platform.

 Involved in documenting the technical part, ask TDD and

Mapping document, which is useful while creating pipeline and

validating the destination data.

Project #2: RBC Lighthouse

Client: RBC (Royal Bank of Canada)

Roles and Responsibilities:

 Implemented SQL Server Integration Services (SSIS) for

seamless data extraction and loading.

 Developed complex ETL processes to support diverse business

requirements, improving data accuracy and timeliness.

 Enhanced reporting capabilities using SSRS, contributing to

strategic decision-making at RBC.

 Involved in both development and maintenance activities.