Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Core Technical Skills
Accomplishments
Work Availability
Affiliations
Timeline
background-images
Spandana Manda

Spandana Manda

Alpharetta,GA

Summary

Data Analyst with 10+ years of experience in data engineering, analytics, BI reporting, and geospatial analysis. Expert in SQL, Python, Tableau, Power BI, and cloud platforms (AWS, GCP, Azure). Proven ability to develop scalable ETL pipelines, automate workflows, and deliver actionable dashboards. Strong background in data governance, compliance (HIPAA, GDPR, FERPA), and metadata management. Known for improving reporting efficiency, optimizing data pipelines, and driving data-driven decision-making across government, education, healthcare, and enterprise environments.

Results-driven data professional with keen eye for detail and passion for uncovering actionable insights from data. Proven track record of utilizing data analysis and visualization tools to drive business decisions and optimize processes. Team-oriented with strong focus on collaboration and adaptability, consistently delivering reliable results in dynamic environments.

Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.

Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Data Analyst

Illinois Department of Natural Resources
07.2023 - Current
  • Analyzed large environmental and geospatial datasets using SQL, Python, ArcGIS, and QGIS to support resource management and environmental planning.
  • Built Tableau and Power BI dashboards delivering real-time KPIs and operational insights.
  • Developed multi-cloud data integrations (AWS, GCP, Azure) enabling scalable and accessible data pipelines.
  • Performed predictive analytics using Python (Pandas, NumPy) to forecast resource utilization and staffing needs.
  • Implemented data governance frameworks (HIPAA, FERPA, GDPR) improving metadata quality and audit readiness.
  • Automated reporting processes and optimized data models, reducing manual reporting effort by 40%.
  • Collaborated with IT and data engineering teams on data integrity, ETL validation, and disaster recovery processes.
  • Modernized geospatial data infrastructure, improving data reliability and decision-making capabilities.
  • Conducted data analysis to support conservation initiatives and resource management strategies.
  • Developed interactive dashboards using GIS tools to visualize environmental data trends.

Senior Data Analyst

Varsity Education Management VT Ltd
04.2021 - 11.2022
  • Designed and executed data analysis on student lifecycle and academic performance using SQL, Python, and cloud ETL pipelines.
  • Developed Power BI and Tableau dashboards improving visibility into enrollment, student outcomes, and retention.
  • Built predictive models using Python to forecast student success and recommend personalized learning strategies.
  • Streamlined ETL workflows on AWS and GCP, reducing processing time by 30%.
  • Optimized MySQL and MongoDB databases to improve query performance and reporting speed.
  • Ensured data compliance and quality checks to protect sensitive academic and operational data.
  • Consolidated fragmented datasets into a unified analytics platform used across academic departments.

Data Analyst

Wipro Ltd
03.2019 - 04.2021
  • Translated healthcare reporting requirements into SQL queries, KPIs, and dashboards for patient and operational insights.
  • Automated reporting pipelines using SQL and Python, reducing manual work by 30%.
  • Built Tableau and Power BI dashboards analyzing patient flow, treatment patterns, and outcome metrics.
  • Conducted impact analysis on workflow changes affecting patient care and compliance metrics.
  • Developed Azure-based pipelines using Data Factory and Synapse for scalable clinical reporting.
  • Implemented HIPAA/GDPR-compliant data protection practices and documentation.
  • Supported predictive analytics initiatives such as readmission risk and operational performance improvement.
  • (Healthcare Client)

Data Analyst

SITEL
12.2014 - 09.2017
  • Analyzed geospatial datasets using ArcGIS, QGIS, SQL, and Python for urban planning and logistics initiatives.
  • Built GIS dashboards and interactive maps supporting infrastructure and environmental projects.
  • Created metadata standards, validation rules, and QA processes improving geospatial data reliability.
  • Automated ETL processes using Python/SQL, reducing turnaround time by 35%.
  • Migrated spatial datasets to AWS S3 and GCP Cloud Storage to enhance accessibility and scalability.
  • Delivered geospatial insights through reports and stakeholder workshops.

Education

Master of Science - Management Information Systems

University of Illinois Springfield
Springfield, IL
10.2024

MBA - HR & Finance

Chaitanya Bharathi Institute of Technology
India
06.2013

Bachelor of Technology - Computer Science Engineering

JNTU Hyderabad
India
05.2011

Skills

  • SQL
  • Data cleaning
  • SQL databases
  • Analytical problem solving
  • Statistical analysis
  • Tableau
  • Attention to detail
  • Data validation
  • Database management
  • Database programming and SQL
  • ETL processes
  • Project management
  • Database maintenance
  • Data mining

Certification

  • ESRI Data Management
  • Power BI (Udemy)
  • AWS (Udemy)
  • ArcGIS (ESRI)

Personal Information

Title: Data Analyst | Data Engineer | BI Analyst

Spandana Manda
Data Analyst & Data Engineer

  • Based in Springfield, Illinois
  • 10+ years of experience in analytics, cloud data engineering, and BI
  • Skilled in SQL, Python, Tableau, Power BI, AWS, GCP, and ArcGIS
    📧 spandanam2909@gmail.com | 📞 +1 (864) 201-0810
    🔗 www.linkedin.com/in/spandana-manda-sm

Core Technical Skills

SQL, Python, MySQL, MongoDB, PostgreSQL, Oracle, Pandas, NumPy, Scikit-learn, Hadoop, Apache Spark, Tableau, Power BI, QuickSight, Google Data Studio, Talend, Informatica, Azure Data Factory, Apache Airflow, AWS (S3, Redshift, EC2), GCP (BigQuery, Cloud Storage), Azure Synapse, Collibra, Apache Atlas, metadata standards, ArcGIS, QGIS, Excel (Advanced), VBA, HIPAA, GDPR, FERPA

Accomplishments

  • Made recommendations on business intelligence tools (Tableau and Power BI) that cut processing time by 45%, reducing report generation from hours to minutes through automation and optimized data models.
  • Developed methods to integrate ETL workflows and BI reporting across Apache Airflow and Tableau, significantly improving workflow efficiency and ensuring real-time data availability for decision-makers.
  • Improved relationship with internal resource management teams by developing a custom Power BI dashboard that consolidated environmental, financial, and operational data, meeting complex analytical requirements and increasing user adoption by 60%.
  • Modified and optimized existing SQL databases to reduce processing time by 35% and improve data accuracy by 25%, enabling faster query execution and more reliable analytics for statewide reporting.
  • Used Microsoft Excel (Pivot Tables, Power Query, VBA automation) to develop inventory tracking and resource utilization spreadsheets, improving tracking accuracy and reporting efficiency by 30%.
  • Supervised a cross-functional team of 5 analysts and data engineers, mentoring staff on BI tools, SQL query optimization, and dashboard development best practices, improving project turnaround time by 20%.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Affiliations

  • Member, Data Management Association International (DAMA International) Professional body focused on data governance, data quality, and metadata management.
  • Member, International Institute of Business Analysis (IIBA) Recognized association for business analysts and data professionals applying analytics to business decision-making.
  • Member, Association for Computing Machinery (ACM) Global organization for computer science, analytics, and information systems professionals.

Timeline

Data Analyst

Illinois Department of Natural Resources
07.2023 - Current

Senior Data Analyst

Varsity Education Management VT Ltd
04.2021 - 11.2022

Data Analyst

Wipro Ltd
03.2019 - 04.2021

Data Analyst

SITEL
12.2014 - 09.2017

Master of Science - Management Information Systems

University of Illinois Springfield

MBA - HR & Finance

Chaitanya Bharathi Institute of Technology

Bachelor of Technology - Computer Science Engineering

JNTU Hyderabad