Data Analyst

SWETHA BARLA

Dallas, TX 682-***-**** *************@*****.*** Medium LinkedIn

Data Analyst with expertise in data analysis, data models, and developing BI solutions. Skilled in SQL, Python scripting, and advanced analytics to improve customer relations, optimize processes, and drive data-driven decision-making through predictive modeling and interactive dashboards.

EDUCATION

Master’s Degree in Business Analytics

University of North Texas Denton, TX January 2022 – May 2023

Post Graduate Diploma in Data Science

IIIT Bangalore Bangalore, India August 2020 – September 2021

Bachelor’s Degree in Electronics and Communications Engineering

Anil Neerukonda Institute of Technology and Sciences Visakhapatnam, India July 2012 – May 2016

EXPERIENCE

Data Science Analyst

Lennox Dallas, TX January 2023 – Present

•Developed business intelligence reports and dashboards on PowerBI to monitor HVAC system performance, identify anomalies in sensor data, and provide actionable insights to stakeholders, minimizing system downtime and reducing maintenance costs.

•Performed data modeling by designing and structuring data within the Databricks Lakehouse platform for efficient data storage and retrieval and conducted exploratory data analysis using Python libraries to profile data distributions, detect outliers, and assess correlations.

•Conducted feature engineering and statistical analysis on IoT sensor and weather datasets for HVAC systems, and implemented time series forecasting using ARIMA, SARIMA, and Prophet models, achieving 97% accuracy in energy consumption predictions.

•Conducted cost-benefit analysis on energy consumption trends, driving a 5% cost reduction and operational improvements.

•Designed and managed data pipelines using Apache Kafka, Apache Spark, Azure Data Lake Storage, Databricks and Azure IoT Hub for real-time data ingestion, processing, and anomaly detection.

Data Quality Analyst

Amazon.com, Inc Hyderabad, India July 2019 – December 2021

•Analyzed and improved last-mile delivery data by auditing route deviations, incorrect drop locations, and address mismatches, increasing delivery accuracy by 35% and enhancing business performance.

•Conducted spatial data analysis using QGIS and OpenStreetMap, enhancing last-mile address accuracy and optimizing routing efficiency, leading to reduction in delivery times.

•Developed SQL queries in Auditbook – an internal tool built on top of Amazon RDS, to extract and analyze flagged cases, perform aggregations and trend analysis, reducing incorrect drop locations.

•Worked closely with operations teams to refine SOPs based on insights derived using Auditbook data, leading to improved efficiency.

• Built interactive QuickSight dashboards to monitor route deviations, case resolution trends and provide real-time insights to leadership.

•Automated data ingestion and reporting using Python scripts, reducing manual effort monthly by 20% and increasing overall productivity.

Data Analyst

IntouchCX (formerly Knoah Solutions, Inc) Hyderabad, India August 2016 – June 2019

•Conducted business impact analysis on customer service data to identify trends affecting agent performance and customer satisfaction, leading to data-driven training enhancements that increased customer satisfaction scores by 45%.

•Conducted A/B testing on training programs to assess effectiveness, driving a 15% annual improvement in efficiency and performance.

•Developed SQL queries to support workforce analytics and data integrity checks using Kronos data housed in SQL Server.

•Collaborated with HR and management to analyze workforce trends and performance metrics, presenting data-driven insights to executive teams to guide strategic planning and decision-making.

•Created data visualization dashboards in HubSpot to track KPIs, including Average Handle Time (AHT), First Call Resolution (FCR), and Customer Satisfaction Score (CSAT) to track employee engagement and performance for informed management decisions.

•Recognized as “Best Employee of the Month” five times and awarded the Bravo Award for outstanding performance.

CERTIFICATIONS

Databricks Certified Machine Learning Associate, Microsoft Certified DP-203: Azure Data Engineer Associate

SKILLS

SQL, Python, R, Power BI, Tableau, QuickSight, Microsoft Excel, A/B Testing, Hypothesis Testing, Trend Analysis, Pandas, NumPy, Scikit-learn, TensorFlow, NLP, Predictive Analytics, Regression Models, Microsoft Azure, AWS, Docker, Kubernetes, Terraform, CloudFormation, Apache Spark, PySpark, Kafka, AWS Glue, Apache Airflow, Azure Data Factory, Informatica, Databricks, SSIS, Git, Azure DevOps, CI/CD Pipelines, Jenkins, Problem-Solving, Team Collaboration, Stakeholder Communication, Agile and Scrum

Contact this candidate