Sairohith Chityala Email & Phone Number

Lexington, Ky, Us

Nashville, Tennessee, United States

Cincinnati, Ohio, United States

• Managed and optimized large datasets in Starrez software for resident check-ins, check-outs, and mail tracking, ensuring data accuracy and efficiency. I streamlined workflows for package deliveries, enhanced database management skills, and collaborated on process improvements, emphasizing data integrity and precision

Hyderabad, Telangana, India

• Designed Synapse Analytics workflows to extract and transform complex insurance reports, optimizing transformations with Python to improve reporting accuracy by 18%.• Built scalable ETL pipelines with Azure Data Factory, ingesting multi-source data into ADLS in Parquet format, reducing data latency by 22% with High Watermark techniques.• Implemented Spark transformations (time-based windows, micro-batching) and RDDs, enhancing large-scale data processing performance by 16%.• Architected a Delta Lake data warehouse using Medallion Architecture with dimensional modeling and star schema, reducing processing times by 13% while maintaining ACID properties for transactional integrity.• Developed Power BI dashboards with advanced DAX expressions, delivering insights into claims and customer segmentation, improving retention strategies by 17%.

Hyderabad, Telangana, India

• Engineered ETL pipelines to process high-volume IoT data from AWS S3 to on-prem SQL DB using Azure Data Factory, reducing data ingestion latency by 26% with optimized Spark clusters and data flow techniques.• Developed Spark-optimized data transformations in Databricks with Python, RDDs, and DataFrames, improving query performance by 22% and delivering structured datasets for advanced analytics and dimensional modeling.• Built predictive Tableau dashboards using advanced calculated fields and LOD expressions to track bot performance, development phases, and budget requirements, enhancing decision-making efficiency by 30%.• Automated JSON data validation with Azure Functions and Python scripts, eliminating 95% of upstream errors and reducing downstream SQL processing times by 21%.• Deployed and monitored CI/CD pipelines with Azure DevOps and GitHub, achieving a 35% increase in deployment speed and ensuring reliable workflows through real-time troubleshooting.

Hyderabad, Telangana, India

• Built ETL pipelines with AWS Glue to extract and validate data from on-prem SQL databases, automating checks with PowerShell and reducing data errors by 33% while ensuring IAM-based access control.• Architected a Snowflake data warehouse integrated with AWS S3 and Fivetran for automated replication, implementing AWS KMS, encryption, and Time Travel to enable secure, real-time analytics.• Transformed data in Snowpark using Python, SQL, and stored procedures for feature engineering and cleansing, improving processing speeds by 40% with automated workflows and compliance measures.• Designed Tableau dashboards linked to Snowflake for monitoring production yield and defect rates, leveraging Live and Extract connections to optimize inventory and increase yield by 16%.• Integrated Python-based predictive modeling into Tableau dashboards for inventory and customer analysis, enhancing forecasting accuracy by 11% and reducing overstock inventory by 19%.