Open to opportunities

Yogita Singh

@yogitasingh1

Message

Analytical BSc graduate passionate about data-driven problem solving.

India

Message

What I'm looking for

I am looking for a role that offers opportunities for growth and collaboration in a dynamic team environment.

I am an analytical and detail-oriented BSc graduate with hands-on experience in SQL, Excel, and Power BI. My academic background in Chemistry and Zoology has equipped me with a strong foundation in analytical thinking and problem-solving. I have successfully completed various real-world projects and virtual internships that have honed my skills in data analysis and visualization.

Throughout my journey, I have developed a keen interest in turning raw data into actionable business insights. My projects include creating Power BI dashboards to track sales KPIs and developing Tableau dashboards to visualize business trends. I am eager to contribute to a forward-thinking organization where I can leverage my skills to drive data-driven decision-making.

Experience

Work history, roles, and key accomplishments

Data Analyst Project

Self Employed

Jul 2023 - Aug 2023 (1 month)

Created performance dashboards from raw operational data using SQL aggregations, joins, and CTEs to enhance operational insights.

SQL Performance Dashboards SQL Joins

Data Analyst Project

Self Employed

Jun 2023 - Jul 2023 (1 month)

Analyzed Instagram user behavior by extracting engagement metrics and follower trends using SQL, providing insights for social media strategies.

SQL User Behavior Analysis Follower Trends Social Media Strategy

Data Analyst Project

Self Employed

May 2023 - Jun 2023 (1 month)

Tracked hiring process metrics from applications to onboarding using Excel formulas and pivot dashboards to enhance recruitment efficiency.

Excel Data Tracking

Data Analyst Project

Self Employed

Apr 2023 - May 2023 (1 month)

Cleaned and structured raw datasets for IMDB movie analysis, visualizing revenue and rating trends using slicers and charts for enhanced interactivity.

Data Cleaning IMDB Analysis Data Visualization

Data Analyst Project

Self Employed

Mar 2023 - Apr 2023 (1 month)

Conducted exploratory data analysis on bank loans, identifying key risk factors and customer segments using pivot tables and charts.

Pivot Tables Data Visualization Risk Factors Customer Segmentation

Data Analyst Intern

Deloitte

Feb 2023 - Mar 2023 (1 month)

Created Tableau dashboards to visualize business trends, implementing filters, calculated fields, and data storytelling techniques to support consulting recommendations.

Tableau Data Visualization Filtering Data Storytelling

Data Analyst

TCS

Jan 2023 - Feb 2023 (1 month)

Developed a Power BI dashboard to track sales KPIs, customer segmentation, and regional performance, enhancing reporting efficiency through dynamic visuals and DAX measures.

Power BI DAX Sales KPIs Customer Segmentation

Education

Degrees, certifications, and relevant coursework

Chatrapati Shahuji Maharaj University

Bachelor of Science, Chemistry & Zoology

2018 - 2022

Grade: 64%

Bachelor of Science in Chemistry & Zoology with a focus on analytical skills and hands-on experience in data analysis tools. Developed a strong foundation in scientific principles and methodologies.