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
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
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
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
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
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
Similar Profiles
Srikanth VuppalaSrikanth Vuppala
Head of Talent Acquisition - India & US at Tek Leaders IncHead of Talent Acquisition - India & US at Tek Leaders Inc
Rashmi BadakalaRashmi Badakala
Trainee Recruiter at Tek leadersTrainee Recruiter at Tek leaders
Sandeep KolichalamSandeep Kolichalam
Team Lead-Sales at Tek LeadersTeam Lead-Sales at Tek Leaders