Summary
Overview
Work History
Education
Skills
Websites
Timeline
AdministrativeAssistant

ROSI REDDY

Irving,TX

Summary

Accomplished Sr. Data Engineer with a proven track record at Change Health, where I spearheaded the migration to a cloud-based EDW, enhancing query execution by 30%. Expert in Azure Data Factory, Power BI, and collaborative project management, I excel in transforming complex data into actionable insights. My leadership in optimizing data processes and mentoring teams underscores my commitment to excellence and innovation.

Overview

6
6
years of professional experience

Work History

Sr. Data Engineer

Change Health
Nashville, TN
03.2022 - Current
  • Migrate and build an EDW in a cloud environment.
  • Designed and maintained scalable ETL workflows using Azure Data Factory, SSIS, and Alteryx, ensuring data reliability for critical business operations.
  • Worked closely with business users to understand the requirements metrics business formulas and define the mapping document by identifying all the required data tables and fields with transformation specifications
  • Designed and developed the reusable ELT/ETL framework with the required configuration data model, pipeline frameworks, and SQL stored procedures.
  • Developed the performance-effective ETL (Extract, Transform, and Load) pipelines using Azure Data Factory (ADF), Azure Databricks, and Synapse.
  • Developed T-SQL scripts and stored procedures, achieving 30% improvement in query execution times.
  • Migrated legacy on-premise data warehouse to a cloud-based environment, leveraging Azure Synapse and optimizing costs by configuring efficient cluster sizes
  • Performance optimization of ADF pipelines
  • Help the team member in day-to-day development activities
  • Conduct code walkthroughs
  • Coordinate with Project Manager, Scrum masters & QA Managers to prioritize task and deliverables
  • Decommission SSIS in phased approach
  • Help production support team as and when needed

Data Engineer

John Deere
Moline, IL
02.2020 - 01.2022
  • Build account reconciliation reports for care first finance and accounting teams
  • Data preparation and transformation and done using ADF which is further used by accounts team for reconciliation and audit purpose
  • Built monitoring processes for data pipelines, utilizing Python and alerting stakeholders for data quality anomalies.
  • Developed high-performance ADF pipelines to process and transform financial data for reconciliation and audits.
  • Migrated SSIS packages to Azure cloud environment, reducing ETL processing times by 25%.
  • Created T-SQL queries for complex data transformations and performance tuning in SQL Server.
  • Migrated SSIS package to Cloud environment using ADF
  • Built ADF pipelines to pull data from various sources
  • Design and build high level and low level of design documents
  • Involved in designing architecture
  • Performance tuning and optimization
  • Provided end-to-end solution for accounts reconciliation
  • Gather requirements from business users
  • Built POC’s for cloud migration using ADF
  • Migration of SSIS packages to ADF
  • Conduct design/code reviews and mentor other engineers on best design, coding, quality, and development practices

BI Developer

Citi Group Marketing
India
12.2018 - 01.2020
  • Build reporting solution for overall infrastructure services
  • Create dashboards for all levels of management and provide end-to-end data warehouse reporting solution to all Infra related services using Power BI, SSIS and SSAS and DAX
  • Designed and implemented end-to-end data warehouse solutions, migrating legacy reports to Power BI and Tableau.
  • Built SSIS ETL packages to extract data from multiple sources, enhancing integration reliability by 40%.
  • Created tabular models in SSAS for multidimensional data analysis and performance optimization.
  • Migrate existing reports and applications under DW
  • Built dimensions and fact for Inventory data
  • Built SSIS ETL packages to pull data from various sources
  • Built SSAS Tabular model for analysis
  • Built Power BI dashboard
  • Design and build high level and low level of design documents
  • Migrated legacy reports to Power BI Platform
  • Involved in designing architecture
  • Performance tuning and optimization
  • Involved in testing
  • Provided end-to-end solution for BI
  • Upgraded and migrated users from legacy reporting to new reporting
  • Helped other projects/teams to build SSIS packages and power bi reports
  • Took an extra mile and worked with client /business users to provide effective dashboards
  • Add value by eliminating manual processes and replacing them with automated jobs.
  • Conduct design/code reviews and mentor other engineers on best design, coding, quality, and development practices
  • Coordinate with all business units to capture requirements and understand existing models and migrate them to Power BI

Education

MS - Computer Information Systems

Christian Brothers University
Memphis, Tennessee

Skills

  • Azure Data Factory (ADF)
  • Azure Synapse
  • Alteryx
  • Azure Data bricks
  • PySpark
  • Azure Data Lake
  • Delta Lake
  • Python
  • Power BI
  • Logic apps
  • SSIS
  • T-SQL
  • Snowflake
  • SQL server
  • Oracle
  • DB2
  • Teradata
  • MySQL
  • PostgreSQL
  • SSRS
  • SSAS
  • MS Excel
  • ERWIN
  • SharePoint
  • Jira
  • Service Now
  • TFS
  • GIT
  • SVN

Timeline

Sr. Data Engineer

Change Health
03.2022 - Current

Data Engineer

John Deere
02.2020 - 01.2022

BI Developer

Citi Group Marketing
12.2018 - 01.2020

MS - Computer Information Systems

Christian Brothers University

Similar Profiles

CREATE PROFILE
ROSI REDDY