Lakshmipathi Reddy Thotli

• Project: Hyperion, a multinational insurance company based in U.K
• Technologies: Server (T-SQL), SSIS, Azure (Data Factory, Blob Storage, Databricks), JSON, YAML
• Description:
• Hyperion is an international insurance intermediary group with insurance broking and underwriting companies under its umbrella.
• Our mission is to provide robust and complete solution to store, process, modelling the data to cater the needs of providing insights and also building the excellent visual reports (Power BI, Angular reports)
• Hybrid data model is used in this project to provide live analytics
• Key Accomplishments:
• CRUD operations using T-SQL as per project requirements
• Developed Pipelines in Azure Data Factory
• Created SSIS packages to import data from source to MS SQL server
• Implementation of Lift and Shift technique to migrate SSIS packages to ADF
• Created complex queries to provide the data model for reports.

Project: AARP, a non-profit social interest organization in USA

Technologies : Shell scripting, AWS

Description:

This system handles File Transfer operations from vendors to business partners. Files are processed at AWS servers to provide the files to business clients in required format (zipping, unzipping, renaming, encryption, decryption etc.).

Key Accomplishments:

• Developed shell scripts to perform all the operations.

• Automated the process to send email notifications about file transfer.

• Worked on processing and transforming files to suit business requirements.

• Created a flow to run the jobs without human intervention based on time and day of the month using Cron utility.

Project : GFOB, escorted tour company based in Australia.

Technologies : T-SQL, MS SQL server, SSIS,Azure Data Factory, Azure Databricks, SSRS, Power BI.

Description:

GFOB is a group of companies providing escorted tour, river cruise and independent travel package services across multiple countries. Our mission is to bring the data from oracle server to MS SQL Server.

Migrate existing citrus reports to SSRS reports with logic and UI enhancements. Create Power BI reports on top of data model according to the business requirements to find Key Performance Indicators.

Key Accomplishments:

• Developed ETL workflow in SSIS.

• Created SSIS packages to import data from Oracle server to MS SQL server.

• Created job schedules using SQL server Agent service.

Created stored procedures, views to get datasets for SSRS and Power BI reports.

• Upgraded the same functionality to cloud using Azure services (ADLS,Data Factory, Databricks)