SAI YARRAM
Naperville,IL
Summary
Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.
Overview
3
3
years of professional experience
Work History
Data Engineer
Systech Solutions
07.2020 - 08.2022
- Managed the migration of projects to the Azure cloud platform, designing and setting up automated data pipelines using Azure Data Factory, Azure Data Lake, and SSIS, which increased data processing efficiency by 30%
- Automated ETL processes, improving data accuracy from 78% to 98% and reducing the need for manual data corrections
- Created and refined Power BI dashboards and DAX formulas, enhancing data analysis, reporting accuracy, and user engagement
- Collaborated in Agile teams, managing sprints and delivering data engineering tasks on time, which improved overall project efficiency
- Used Python to clean and prepare both structured and unstructured data, ensuring smooth integration across various data sources
- Built and deployed Azure Data Factory (ADF) pipelines with CI/CD integration through Azure DevOps, ensuring consistent data flow in production with minimal downtime
- Reduced daily processing time by 30% by optimizing data models, workflows, and pipeline processes
- Enhanced reporting efficiency by 20% through the development of operational data marts and streamlining ETL processes for Sales and Service Analytics
- Developed and managed complex SSIS packages to automate data extraction, transformation, and loading from SQL Server to various external data sources, boosting operational efficiency and reporting
- Worked closely with clients to understand their business needs, delivering customized solutions that improved decision-making through tailored dashboards and reports
- Conducted training sessions for users on report functionalities, helping them make better use of data insights
Associate Data Engineer
NxtWave
05.2019 - 06.2020
- Experienced in creating complex SSIS packages using proper control and data flow elements
- Created and scheduled SSIS packages to pull data from SQL Server and export to various data sources like Excel spreadsheets, flat files, etc., and vice versa
- Enhanced operational data mart and streamlined reporting processes for Sales and Service Analytics, resulting in a 20% increase in reporting efficiency
- Developed DML scripts to insert, update, and delete data in MSSQL database tables using SQL Server Management Studio
- Implemented data extraction and loading from OLTP onto staging with SSIS packages
- Implemented transactions in SSIS packages using sequence containers and executed SQL tasks
- Hands-on experience with Oracle, including performance tuning and efficient querying in Oracle environments
- Designed charts with lines, bar graphs, and columns to generate reports with cumulative totals
- Delivered numerous ETL performance enhancements to reduce the ETL run time
- Involved in the design, development, and testing of ETL processes using Informatica
- Conducted user sessions to educate users on the reports and functionality
- Designed mappings and workflows and wrote complex SQL and PL/SQL queries based on business requirements
Education
Master of Science - Data Science
Lewis University
Romeoville, IL05.2024
Bachelor of Technology - Computer Engineering
RVR & JC College Of Engineering
Guntur, India05.2020
Skills
Azure Data Factory
- Data Lake Storage
- Synapse Analytics
- Snowflake
- SSIS
- Informatica
- SQL
- PL/SQL
- DML Scripts
- Dimensional modeling
- Star Schema
- Snowflake Schema
- ER modeling
- Python
- SQL Server Management Studio
- Stored Procedures
- Views
- Power BI
- DAX
- Report creation
- Dashboard modifications
- Git
- Azure DevOps
- Unix/Linux
- ETL development
- Data warehousing
- Data modeling
- Data pipeline design
Timeline
Data Engineer
Systech Solutions
07.2020 - 08.2022
Associate Data Engineer
NxtWave
05.2019 - 06.2020
Master of Science - Data Science
Lewis University
Bachelor of Technology - Computer Engineering
RVR & JC College Of Engineering
Similar Profiles
Vasanth Kanna AnandanVasanth Kanna Anandan
Data Engineering Lead at Systech SolutionsData Engineering Lead at Systech Solutions
SHIVANI JADHAVSHIVANI JADHAV
BMS Engineer at Systech SolutionsBMS Engineer at Systech Solutions
Ajith Kumar MAjith Kumar M
Data Engineer at Systech Solutions Private LimitedData Engineer at Systech Solutions Private Limited