Data Analyst - IT Operations & BI Specialist

Spandana Chittaluri

405-***-**** ***********@*****.***

LinkedIn: https://www.linkedin.com/in/spandana-chittaluri/ Professional Summary

Dynamic Data Analyst with expertise in IT data management, system performance monitoring, and business intelligence reporting. Skilled in SQL, Python, Power BI, Snowflake, SSIS, and Teradata, with extensive experience in automating IT reporting and data visualization. Designed and implemented ETL pipelines, reducing data processing times by 30% and improving system uptime to 99.9%. Strong understanding of Agile methodologies, collaborating with IT and engineering teams to optimize data solutions.

Technical Skills

Data Warehousing and ETL Tools: Teradata, Snowflake, SQL Server (2016/2017), SSIS (SQL Server Integration Services), ETL (Extract, Transform, Load), Change Data Capture (CDC), Slowly Changing Dimensions (SCD)

Data Analysis and Visualization: Excel (2016/Google Sheets), Python (Pandas, NumPy), Exploratory Data Analysis (EDA), Power BI, SQL Server Reporting Services (SSRS)

Programming and Scripting: Python 3.6, UNIX Shell Scripting

Database Management: SQL Server Management Studio (SSMS), Mainframe Systems, Oracle

Reporting and Modeling: SSAS (SQL Server Analysis Services), Multidimensional and Tabular Models

Agile and Collaboration Tools: Jira, Agile Methodology

Production Support and Validation: L1 and L2 Production Support, Data Validation and Quality Checks Work Experience

Data Analyst

Ascendion Oklahoma July 2023 – till date

Project summary:

Led the development of a scalable data warehouse for IT operations, integrating structured and unstructured data sources using Snowflake and SSIS. Designed ETL pipelines to automate data ingestion from various applications, reducing manual processing efforts by 40%. Created Power BI dashboards for IT system performance monitoring and anomaly detection.

Roles and Responsibilities:

Conducted in-depth healthcare data analysis using SQL, Python, and Excel/Google Sheets, identifying patterns and anomalies that improved decision-making and operational efficiency by 20%.

Developed and optimized ETL (Extract, Transform, Load) workflows using SSIS to integrate data from diverse sources such as Mainframe, Teradata, SQL Server, and Snowflake, reducing data processing times by 30%.

Created multidimensional and tabular models with SSAS, improving data analysis and reporting accuracy for healthcare KPIs by 25%.

Designed and deployed interactive PowerBI dashboards, providing stakeholders with actionable insights to monitor trends, increasing user engagement by 15%.

Automated reporting using SSRS, streamlining the generation of detailed reports and improving efficiency by 40%.

Collaborated with healthcare professionals and data engineers to gather requirements, define KPIs, and deliver tailored data solutions, achieving a 95% satisfaction rate.

Provided L1 and L2 production support for critical batch processes using UNIX shell scripting and Jira, ensuring 99.9% system uptime and SLA adherence.

Conducted data validation and quality checks during ETL processes, ensuring a 98% accuracy rate in data delivery for healthcare systems.

Wrote and optimized complex SQL queries in SQL Server Management Studio, Snowflake, and Teradata, reducing query execution times by 35%.

Documented and standardized over 50 ETL workflows, data mappings, and reporting processes, enhancing scalability and team collaboration.

Data Analyst

Atos Pune, Maharashtra Feb 2019 – Nov 2021

Project Summary:

Designed and implemented a robust data warehousing solution for the Hospital Corporation of America (HCA) to streamline patient data management. Developed ETL pipelines using SSIS and SQL Server to automate data ingestion from various sources, improving data accessibility by 30%. Integrated Change Data Capture (CDC) and Slowly Changing Dimensions (SCD) methodologies to track patient history and insurance claims effectively. Created Power BI reports for patient admission trends, reducing decision-making time for hospital administrators by 25%. Roles and Responsibilities:

Designed and implemented data warehousing solutions for the Hospital Corporation of America (HCA) using Teradata, SQL Server, Snowflake, and ETL processes, improving data accessibility by 30%.

Developed and tested 100+ ETL jobs leveraging SSIS to extract, transform, and load data from heterogeneous sources, including flat files, SQL Server, Oracle, and Mainframe systems, reducing processing time by 25%.

Automated ETL mappings, including Change Data Capture (CDC) and Slowly Changing Dimensions (SCD) type 2, enhancing data accuracy and timeliness in HCA’s reporting systems by 40%.

Analyzed healthcare data using Excel, Google Sheets, SSRS, and Python to create reports and dashboards, increasing operational efficiency by 15%.

Collaborated with HCA stakeholders to gather requirements and conduct impact analysis, achieving 95% satisfaction in delivering tailored data solutions.

Provided L1 and L2 production support, ensuring 99.9% system uptime and timely data delivery within SLAs.

Developed hospital dashboards (ERWT) and COVID-related batch jobs, delivering projects 10% ahead of schedule.

Streamlined batch processes using UNIX shell scripting, reducing manual intervention by 35%.

Documented 50+ ETL workflows and processes for scalability and team collaboration.

Used Jira to track tasks, ensuring timely delivery in an Agile environment. Junior Data Analyst

IQVIA Gurgaon, India April 2018 – Jan 2019

Project Summary:

Managed a large-scale cloud data migration project, transitioning data from on-premise SQL Server to Snowflake for improved scalability. Developed ETL workflows to clean and validate data during migration. Designed cloud-based Power BI reports for IT teams to analyze system performance and data security metrics. Optimized cloud data storage, reducing infrastructure costs by 25%.

Roles and Responsibilities:

Extracted and collected healthcare data from relational databases using SQL Server 2016/2017 and SSIS, ensuring accurate data acquisition and integration.

Cleaned and transformed raw data using Python 3.6 and SQL, leveraging libraries like Pandas and NumPy to ensure data consistency and readiness for analysis.

Built and maintained ETL pipelines using SSIS, automating data extraction, transformation, and loading into the data warehouse.

Designed and generated detailed reports using SSRS 2016/2017 and Excel 2016, presenting KPIs and trends to stakeholders for decision-making.

Conducted exploratory data analysis (EDA) using Python 3.6 and Excel 2016, identifying trends and anomalies in healthcare data.

Collaborated with cross-functional teams using JIRA to track tasks, manage issues, and ensure timely project delivery.

Education

Masters in Computer Science

Oklahoma City University — Jan 2022 – May 2023

Bachelors in Computer Science

Bharat Institute of Engineering and Technology — 2014 – 2018 Certifications

Teradata Certified Professional

Python for Data Science and Machine Learning

SQL Server Reporting Services (SSRS) Certification

Contact this candidate