Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Avantika Singh

Summary

Data professional skilled in transforming complex datasets into impactful insights through advanced analytics, machine learning, and data visualization. Proficient in Python, SQL, and Tableau, with a strong track record in automating workflows, building predictive models, and designing dashboards to support data-driven decision-making. Recognized for a collaborative approach and a strategic mindset, with a focus on optimizing processes and enhancing business outcomes.

Overview

6
6
years of professional experience

Work History

Graduate Assistant

California State University (Part-Time)
Long Beach, CA
04.2024 - Current
  • Spearheaded the launch of interactive Tableau dashboards to monitor real-time student performance trends and faculty workload distribution, enhancing decision-making efficiency by 20% through immediate access to critical metrics.
  • Conducted an in-depth analysis of departmental resource utilization using SQL and Excel, uncovering key optimization opportunities that improved resource allocation by 15%.

Senior Data Analyst

Infosys Pvt. Ltd
Bengaluru, IN
02.2022 - 07.2023
  • Conducted exploratory data analysis and cleansing on large SSHE datasets , identifying critical inconsistencies that improved data quality by 30%, leading to more accurate reporting and informed decision-making.
  • Engineered predictive models using Python and machine learning algorithms to forecast equipment failures in SSHE systems, enabling proactive maintenance scheduling that reduced unplanned downtime by 25% and extended asset life cycles.
  • Identified high-failure machinery through regression and time-series analysis on downtime data, supporting a shift to predictive maintenance scheduling that reduced equipment failures by 20% and improved operational efficiency by 15%.
  • Automated ETL processes for SSHE data integration with Python and SQL, reducing manual processing time by 40% and enhancing data accuracy through validation protocols, resulting in faster, reliable access to critical operational data.
  • Consolidated safety and performance data into interactive Tableau dashboards, delivering real-time insights that enabled a 10% improvement in resource allocation, and enhanced executives' responsiveness to operational risks.

Data Analyst

Accenture Solutions Pvt.Ltd
Pune, IN
12.2018 - 02.2022
  • Implemented automated alerting mechanisms using Python and SQL, integrating them into the monitoring dashboard to reduce response times by 25% and minimized system downtime through faster issue detection and resolution.
  • Crafted client-specific, real-time Tableau reports to monitor key performance indicators, proactively reducing client incidents by 10% and enhancing operational stability and satisfaction.
  • Built and implemented a custom SAP monitoring dashboard in Tableau to provide real-time system performance insights, boosting operational efficiency by 25% and enabling data-driven optimizations that increased productivity.
  • Collaborated with cross-functional teams to translate business needs into technical requirements for data visualizations and dashboards, ensuring alignment with client objectives and delivering insights that supported stakeholder decision-making.
  • Led client engagements and corporate social responsibility initiatives, earning recognition for communication, teamwork, and positive impact, which fostered strong client relationships and contributed to team cohesion.

Education

Bachelor of Engineering - Computer Science & Engineering

Reva Institute of Technology And Management
Bengaluru, IN
06-2018

Master of Science - Computer Science

California State University
Long Beach

Skills

  • Skills: Microsoft Excel, GitHub, Statistical Analysis, SAP, ServiceNow, Machine Learning, Artificial Intelligence, Deep Learning, Statistics, Data Structure, Data Cleaning, Data Pipelines, EDA, ETL, Hypothesis Testing, A/B Testing, NLP, Data Mining, Data Visualization, AWS Cloud Services, Tableau, SAP Business Intelligence
  • Scripting: Python, R, SQL
  • Libraries: NumPy, Pandas, Scikit-learn, Matplotlib, Plotly, TensorFlow, PyTorch, Keras, Seaborn
  • Databases: MySQL, Oracle, SAP HANA, DB2, SQL Server

Projects

Healthcare Analytics – Hospital Readmission Rates | Python, SQL, Tableau

  • Created a comprehensive Tableau dashboard that analyzed hospital readmission rates, and identified trends, leading to targeted interventions that improved patient outcomes and reduced readmissions by 15% over six months.

Facial Expression Recognition | TensorFlow, Keras, ImageDataGenerator, Matplotlib, Seaborn, Scikit-learn

  • Developed a convolutional neural network (CNN) model using TensorFlow/Keras to classify facial expressions into seven categories, enhancing image data with preprocessing and augmentation techniques.

Timeline

Graduate Assistant

California State University (Part-Time)
04.2024 - Current

Senior Data Analyst

Infosys Pvt. Ltd
02.2022 - 07.2023

Data Analyst

Accenture Solutions Pvt.Ltd
12.2018 - 02.2022

Bachelor of Engineering - Computer Science & Engineering

Reva Institute of Technology And Management

Master of Science - Computer Science

California State University
Avantika Singh