Data Engineer - ETL, BI, Cloud Analytics

ROHIT CHITYALA

703-***-**** ****************@*****.*** LinkedIn Github

SUMMARY

Data Engineer with 5 years of experience in Academic and Professional background, developing and automating end-to-end pipelines for business intelligence and analytics. Proficient in building interactive dashboards using Power BI and Tableau, enabling business stakeholders to monitor KPIs, identify patterns and make data-driven decisions in real time. Experienced in developing ETL workflows using tools such as Apache Airflow and AWS Glue, handling structured and unstructured datasets from multiple sources to ensure scalable data ingestion and transformation.

EDUCATION

George Mason University, VA Aug 2023 - May2025

Master of Science in Data Analytics Engineering.

Chaitanya Bharathi Institute of Technology, India Aug 2017 - June 2021 Bachelor of Technology in Chemical Engineering.

SKILLS

Programming Languages: Python, SQL(MySQL, PostgreSQL), NoSQL(MongoDB), R, MATLAB Business Intelligence Tools: Power BI, Tableau, Microsoft Office (MS Excel, MS Word, MS PowerPoint) Cloud Platforms: AWS(Athena, Glue,Lambda,S3,Redshift,EC2), RDBMS, DBMS Machine Learning: Supervised/Unsupervised Learning, Predictive Modeling, NLP, Feature Engineering ETL & Automation: Data Pipeline Development, ETL Processes, Automation(Python), SQL Optimization PROFESSIONAL EXPERIENCE

Senior Data Engineer ZS Associates, Chicago, IL Aug 2024 - Present

• Conducted detailed exploratory analysis of HCP engagement, promotional activity and prescribing behavior using SQL and Python, cleaned and validated data across time periods and therapeutic segments to ensure modeling readiness.

• Built segmentation models using K-Means and Hierarchical Clustering to classify HCPs based on response, frequency and prescription trends and helped marketing teams target under-engaged and high-potential segments more effectively.

• Developed multivariate regression models to quantify the impact of promotional tactics on prescription lift and isolated the effect of rep visits, digital campaigns and speaker events on behavior change.

• Collaborated with client stakeholders, brand consultants and engineering teams to align KPIs and validate model assumptions. Participated in interactive feedback sessions to tailor outputs to business needs.

• Wrote complex SQL queries to extract structured data from Snowflake and join multiple engagement sources. Ensured scalable query logic using CTEs and window functions for periodic analysis. Data Engineer Fractal Analytics, San Diego, CA Sep 2023 – July 2024

• Created automated ETL workflows using AWS Glue to extract billing and usage logs, transform cost data and prepare inputs for daily analysis and reduced ETL failure rate and ensured high-frequency pipeline reliability.

• Wrote and maintained complex Athena SQL queries to slice cloud spend by account, service type, environment and cost center and enabled cost drilldowns with hourly and daily granularity.

• Developed interactive Power BI dashboards with cost trends, forecasted spending, service optimization summaries, and anomaly alerts. Used historical averages and variance logic for visual detection.

• Built cost optimization models comparing reserved vs. on-demand instance usage. Provided actionable recommendations leading to 15-20% monthly savings

Data Engineer IBM, Hyderabad, India Dec 2021 - July 2023

• Designed end-to-end Power BI dashboards with slicers, filters and drill-down views to visualize compliance metrics across global units and enabled leadership to identify region-specific risks and SLA breaches in real time.

• Created a unified data model by integrating audit logs, compliance trackers, SLA tables and organizational metadata into a scalable structure and supported seamless refreshments and reporting for over 15 departments.

• Automated weekly and monthly reporting using Python (pandas) and SQL stored procedures and reduced manual Excel-based reporting effort and improved update frequency, reporting, dashboard logic and internal audits with efficient data access.

• Collaborated with global compliance and internal audit teams to gather reporting requirements, define KPIs and iterate on dashboards design and ensured that metrics audit policy expectations. Junior Data Engineer Tata Consultancy Services (TCS), Hyderabad, India Oct 2020 - Nov 2021

• Started as an Intern during the Final Semester and transitioned to a full-time analyst, gaining hands-on experience with enterprise analytics tools and reporting processes.

• Collaborated with cross-functional teams to gather data requirements, translate them into structured queries and support BI use cases for internal operations.

• Designed and optimized SQL queries to extract, clean and join large datasets from relational databases supporting dashboard development and custom reporting.

CERTIFICATIONS

• Advanced PGP in Data Science and Machine Learning (NIIT)

• AWS Machine Learning & Artificial Intelligence (AWS-44ZZPZR1E1B11HS3)

• Azure Data Engineering & AWS Solutions Architect (AWS-ASA-399983) ACADEMIC PROJECTS

Geographically Contextual Knowledge Worker Cost Feb 2025 - Apr 2025

• Developed a data-driven decision support tool that uses machine learning and linear programming to compare remote vs in- office workforce costs across U.S. cities enabling organizations to optimize hiring strategies based on remote work expenses. Indian Premier League: Team Performance Dataset (2008-2024) Sep 2024 – Nov 2024

• Conducted an in-depth data analysis of IPL matches using statistical modeling and data visualization to validate the hypothesis that toss decisions, significantly impact match outcomes revealing strategic patterns and evolving scoring trends. Movie Recommendation with NLP Feb 2024 – Apr 2024

• Developed a content-based movie recommendation chatbot using advanced NLP techniques to match user preferences with similar movies by analyzing metadata such as genre, actors, directors, plot and user-provided descriptions

Contact this candidate