Sai Prathyusha
Alpharetta,GA
Summary
- 6 Years of experience in designing, developing, and deploying data integration solutions using Microsoft Technology stack, Azure Data Technologies, and SSIS.
- Adept in optimizing ETL processes for performance and efficiency.
- Strong expertise in SQL, T-SQL, and data modeling.
- Strong experience in Data Visualization like Power BI.
- Committed to delivering high-value solutions that drive business process improvements
Overview
7
7
years of professional experience
1
1
Certification
Work History
Azure Data Engineer
Tek Leaders Inc
Frisco, TX
05.2023 - Current
- Worked on the implementation of Azure Data Technologies, including Azure Data Factory, Azure SQL, and Azure Data Bricks for streamlined data processing
- Implemented Azure Data Factory for efficient data ingestion from various source systems, achieving a 25% reduction in ETL processing time
- Improved ETL performance by optimizing SQL queries and implementing best practices, resulting in a 30% reduction in query execution time
- Utilized SSIS to design complex data flows and executed stored procedures, reducing data latency by 20% and improving data freshness
- Developed complex pipelines using Azure Data Factory v2, leveraging various activities such as Copy, Transform, and Databricks to enhance data transformations
- Led the migration of on-premises data infrastructure to Azure, resulting in a 40% reduction in operational costs and improved scalability
- Executed stored procedures within SSIS and managed SQL Agent Jobs, ensuring efficient data extraction and transformation
- Performance tuning by optimizing queries, indexes, and partitioning strategies to ensure efficient data processing
- Created interactive Power BI dashboards to visualize key performance metrics, empowering stakeholders with timely insights
- Orchestrated CI/CD pipelines using Azure DevOps, enabling automated deployments, and reducing human errors.
Azure Data Engineer
Pelican IT Group LLC
Atlanta, GA
02.2023 - 04.2023
- Designed and implemented real-time and batch data processing solutions using Azure Data Factory, Azure Databricks, and Informatica Cloud
- Developed complex ETL pipelines using Informatica Intelligent Cloud Services (IICS), reduced data integration time by 40%, and ensuring consistent data quality across multiple sources
- Developed and deployed ETL procedures for Slowly Changing Dimensions (SCD), achieved 50% reduction in data processing time
- Leveraged strong T-SQL queries and stored procedures to create and optimize data queries, contributing to efficient data retrieval and analysis
- Developed and managed data pipelines for data transformation, enrichment, and loading into Azure Data Lake Storage and Azure SQL Data Warehouse.
SQL Developer
University of Central Missouri
Lee's Summit, MO
06.2022 - 12.2022
- Created and maintained complex SQL queries to retrieve and manipulate data from multiple tables, enabling efficient reporting and analysis
- Developed stored procedures and functions to automate repetitive tasks, reducing manual effort by 15 hours per week
- Involved in database designing, ensuring adherence to best practices for normalization, indexing, and data integrity
- Migrating legacy data to a new database system, successfully transferring 5TB of data without any critical data loss.
Senior Data Engineer
Accenture
Hyderabad, India
08.2019 - 08.2021
- Led end-to-end ETL strategies using SSIS packages, automating data movement from Source DB2 to Azure SQL Server
- Developed C# scripts for automatic SQL table creation, improving deployment efficiency by 30%
- Developed normalized database schema and ETL strategies using SSIS, enhancing data consistency and accuracy
- Created end-to-end SSIS packages, utilizing components like Derived Column, Data Conversion, and Look Up.
ETL Developer
Cognizant Technology Solutions
Chennai, India
03.2017 - 08.2019
- Developed and maintained ETL pipelines using Informatica Intelligent Cloud Services (IICS), including data integration, quality checks, and lineage tracking, ensuring consistent and high-quality data
- Implemented incremental data loading techniques for historical data, minimizing data load windows by 40%
- Worked on SQL Job Agent and Job-related activities such as managing history, scheduling, and Database SQL Operator.
Education
Master of Science - Computer Science
University of Central Missouri
Lee's Summit, MO12.2022
Bachelor of Science - Electronics And Computer Engineering
Koneru Lakshmaiah University
Vijayawada, India05.2016
Skills
- Azure Data Factory (ADF)
- Azure SQL Database,
- Azure Analysis Service
- Azure Databricks
- Azure Data Lake
- Power BI
- TSQL
- SQL Server Integration Services (SSIS)
- Informatica
- SQL Job Agent
- Azure DevOps
- GitHub
Certification
Microsoft Azure Fundamentals (AZ-900) - Feb 2020
Timeline
Azure Data Engineer
Tek Leaders Inc
05.2023 - Current
Azure Data Engineer
Pelican IT Group LLC
02.2023 - 04.2023
SQL Developer
University of Central Missouri
06.2022 - 12.2022
Senior Data Engineer
Accenture
08.2019 - 08.2021
ETL Developer
Cognizant Technology Solutions
03.2017 - 08.2019
Master of Science - Computer Science
University of Central Missouri
Bachelor of Science - Electronics And Computer Engineering
Koneru Lakshmaiah University