SAI KIRAN GOUNI
Chicago,USA
Summary
Certified Data Engineer with 7+ years of experience designing and implementing scalable data pipelines, ETL frameworks, and analytics platforms across cloud ecosystems (AWS, Azure, GCP). Proven expertise in building end-to-end data solutions using Python, SQL, and big data technologies. Adept at transforming business requirements into actionable insights and production-grade systems.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst
State Farm
Chicago, IL
10.2022 - 02.2025
- Designed and deployed Power BI dashboards using Python for real-time business monitoring.
- Built ETL pipelines using SSIS and Python to integrate data from Oracle, Teradata, and flat files.
- Improved query performance by 40% through optimization and indexing on SQL Server 2022.
- Developed machine learning models (e.g., logistic regression, ARIMA) to support business forecasting.
- Automated reporting processes, reducing manual efforts by 50%.
- Engineered GCP-based data pipelines using Big Query, Pub/Sub, and Dataflow.
Data Engineer
Mphasis
Bangalore, India
01.2020 - 08.2022
- Built scalable ETL pipelines using SSIS and integrated reporting with SSRS and Power BI.
- Migrated SQL Server data workflows to Azure Data Lake and Azure SQL Warehouse.
- Created and maintained data models and schema designs using ER Studio and Visio.
- Developed end-to-end solutions for Hadoop-based processing using Spark, HBase, and Hive.
- Implemented data governance and lineage tracking using Apache Atlas.
- Led IVR-based Voice Bot development for internal tools using NLP techniques in Python.
ETL Developer
Dr. Reddy’s Laboratories
Hyderabad, India
05.2018 - 06.2020
- Developed SSIS packages to transform data from flat files, Oracle, and Excel into SQL Server ODS.
- Built time-series forecasting models using Prophet and ARIMA to optimize pharmaceutical inventory.
- Created Tableau dashboards to visualize sales trends, improving decision-making.
- Automated data quality validation using Informatica and Python-based scripts.
- Deployed SSAS tabular models and reports integrated with SharePoint Server.
Education
Master’s - data Analytics
University of Illinois at Springfield
01.2023
Skills
- GCP
- BigQuery
- Dataflow
- Dataproc
- AWS
- Redshift
- EC2
- IAM
- Azure
- Data Lake
- Data Factory
- SQL
- ETL
- SSIS
- Informatica
- Data Warehousing
- Snowflake
- SQL Server
- Data Modeling
- Star/Snowflake
- Python 312
- Java
- T-SQL
- PL/SQL
- R
- Hadoop
- HDFS
- MapReduce
- Spark
- Kafka
- Hive
- Power BI
- Tableau
- SSRS
- SSAS
- Scikit-learn
- TensorFlow
- NLTK
- ARIMA
- Prophet
- Git
- Jira
- Airflow
- Erwin
- Visio
- SAS
Certification
- AWS Certified Data Analytics – Specialty, 01/01/23
- Databricks Certified Data Engineer Associate, 01/01/23
- Google Cloud Certified, 01/01/22
- IBM Data Science Professional Certificate, 01/01/21
- AWS Certified Data Analytics – Specialty
- Databricks Certified Data Engineer Associate
- Google Cloud Certified
- IBM Data Science
Selected Projects
- Regulatory Compliance & Data Governance – State Farm, Developed automated data lineage and audit tracking system using Apache Atlas and Azure Monitor. Ensured GDPR and NAIC compliance.
- Real-time Supply Chain Analytics – Memphis Project, Built IoT-driven data platform with Kafka, Databricks, Azure Event Hubs, and Power BI. Achieved 30% reduction in delivery delays.
- Pharma Sales Forecasting – Dr. Reddy’s, Built predictive models using ARIMA and Prophet to forecast demand, reducing stockouts by 25%.
Timeline
Data Analyst
State Farm
10.2022 - 02.2025
Data Engineer
Mphasis
01.2020 - 08.2022
ETL Developer
Dr. Reddy’s Laboratories
05.2018 - 06.2020
Master’s - data Analytics
University of Illinois at Springfield