Spandana Manda
Alpharetta,GA
Summary
Dynamic Data Analyst with a proven track record at the Illinois Department of Natural Resources, leveraging SQL and Python to drive impactful insights. Expert in crafting engaging dashboards with Tableau and Power BI, enhancing decision-making efficiency. Passionate about data integrity and compliance, delivering innovative solutions that streamline processes and elevate analytics capabilities.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Analyst
Illinois Department of Natural Resources
Springfield, United States
08.2023 - Current
- Analyzed geospatial and environmental datasets using SQL, Python, and ArcGIS to inform resource management decisions.
- Built and maintained BI dashboards in Tableau and Power BI, delivering real-time KPIs and actionable visualizations.
- Collaborated with IT and data engineering teams to ensure data integrity and disaster recovery for large-scale datasets.
- Conducted predictive analytics with Python (Pandas, NumPy) to forecast resource needs and support strategic planning.
- Designed multi-cloud integrations across AWS, GCP, and Azure for scalable data pipelines.
- Implemented data governance frameworks (FERPA, HIPAA, GDPR), standardizing metadata for improved audit readiness.
- Delivered process improvements that reduced manual reporting effort by 40% and enhanced decision-making efficiency.
- Led initiatives to modernize data infrastructure at Illinois Department of Natural Resources, enhancing analytics capabilities.
- Collaborated with team members on data collection and analysis projects.
- Developed dashboards for monitoring key performance indicators in programs.
- Presented analytical results in meetings to inform strategic decision-making.
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
Senior Data Analyst
Varsity Education Management PVT Limited
India, India
05.2021 - 12.2022
- Led analysis of student lifecycle data, utilizing ETL pipelines and BI reporting for informed decision-making.
- Designed and delivered Power BI/Tableau dashboards to enhance visibility into student outcomes and faculty performance.
- Applied predictive models in Python to forecast student success rates and propose personalized learning pathways.
- Streamlined ETL workflows on AWS and GCP, reducing processing time by 30% and enhancing reporting accuracy.
- Collaborated with DBAs to optimize MySQL and MongoDB performance, improving reporting speed.
- Enforced data compliance and quality checks to protect sensitive student and faculty information.
- Spearheaded initiative to transform fragmented student lifecycle data into actionable insights using cloud-based analytics solutions.
- Utilized advanced tools including Python, SQL, Power BI, Tableau, AWS, and GCP for data management.
- Developed predictive models to enhance student performance and retention strategies.
- Analyzed educational data trends to support strategic decision-making processes.
Data Analyst
Wipro LTD(Healthcare Client)
India, India
04.2019 - 05.2021
- Translated healthcare reporting requirements into SQL queries, KPIs, and dashboards for patient outcome monitoring.
- Automated reporting pipelines using SQL and Python, reducing manual report generation time by 30%.
- Created interactive dashboards in Tableau and Power BI to analyze patient flow and treatment effectiveness.
- Conducted impact analyses to evaluate workflow changes on patient care and compliance metrics.
- Developed cloud-based reporting pipelines with Azure Data Factory and Synapse for scalable analytics.
- Ensured HIPAA/GDPR compliance through implementation of data protection protocols and documentation standards.
- Supported predictive analytics projects for identifying trends in readmissions and operational performance.
- Led design and implementation of comprehensive data solutions for enhanced patient outcome tracking.
Data Analyst
SITEL
India, India
01.2015 - 10.2017
- Analyzed and visualized large-scale geospatial datasets using ArcGIS, QGIS, SQL, and Python.
- Built GIS dashboards and interactive maps to enhance urban planning and logistics projects.
- Designed metadata standards and validation protocols to ensure data reliability.
- Automated ETL processes with Python/SQL, reducing turnaround time by 35%.
- Migrated spatial datasets to AWS S3 and GCP Cloud Storage for improved accessibility.
- Conducted workshops and delivered reports translating geospatial insights into actionable business strategies.
- Modernized spatial data management processes to support environmental monitoring and optimization efforts.
Education
Graduate Certified in Business Process Management -
University of Illinois At Springfield
Springfield, Illinois, IL10-2024
Graduate Certified in Business Analytics -
University of Illinois At Springfield
Springfield, Illinois, IL10-2024
Graduate Certified in IT Project Management -
University of Illinois At Springfield
Springfield, Illinois, IL10-2024
Master of Science - Management Information Systems
University of Illinois
Springfield10-2024
MBA - HR & Finance
Chaitanya Bharathi Institute of Technology
Hyderabad, IN06-2013
Bachelor of Science - Computer Science Engineering
JNTU
hyderabad, IN05-2011
Skills
- SQL and Python
- Data analysis with Pandas and NumPy
- Data visualization with Tableau and Power BI
- Advanced Excel techniques including pivot tables
- VBA programming
- Cloud computing with AWS and GCP
- Data integration with Talend and Informatica
- Big data processing with Hadoop and Apache Spark
- Workflow orchestration with Airflow
- Business intelligence with QuickSight and Google Data Studio
- KPI dashboards and data storytelling
- Metadata management with Collibra and Apache Atlas
- Compliance knowledge: HIPAA, GDPR, FERPA
Certification
- Certified Business Process Management
- Business Analytics
- IT Project Management
Timeline
Data Analyst
Illinois Department of Natural Resources
08.2023 - Current
Senior Data Analyst
Varsity Education Management PVT Limited
05.2021 - 12.2022
Data Analyst
Wipro LTD(Healthcare Client)
04.2019 - 05.2021
Data Analyst
SITEL
01.2015 - 10.2017
Graduate Certified in Business Process Management -
University of Illinois At Springfield
Graduate Certified in Business Analytics -
University of Illinois At Springfield
Graduate Certified in IT Project Management -
University of Illinois At Springfield
Master of Science - Management Information Systems
University of Illinois
MBA - HR & Finance
Chaitanya Bharathi Institute of Technology
Bachelor of Science - Computer Science Engineering
JNTU