S

Sonali Gupta

Associate Consultant

Noida, Uttar Pradesh, India6 yrs 10 mos experience

Key Highlights

  • Expert in data visualization and reporting.
  • Proficient in Power BI and advanced Excel techniques.
  • Strong analytical skills driving business insights.
Stackforce AI infers this person is a Data Analyst with expertise in HR Analytics and Business Intelligence.

Contact

Skills

Core Skills

Data AnalysisData Visualization

Other Skills

Looker StudioGoogle SheetsExcelSQLPower BIMicrosoft ExcelHR AnalyticsMicrosoft Power BIKPI DashboardsTransact-SQL (T-SQL)Microsoft SQL ServerBusiness Intelligence (BI)Extract, Transform, Load (ETL)DAXMySQL

About

Hi, I'm Sonali Gupta, a data professional with hands-on experience in Power BI, SQL, Advanced Excel, ETL processes, and data visualization. I specialize in transforming raw data into meaningful insights through interactive dashboards, streamlined reporting, and actionable analytics. I'm passionate about leveraging data to drive smart decisions and business growth. I'm currently open to collaboration opportunities. Feel free to reach out at sonaligupta1315@gmail.com. Let’s connect and explore how we can drive success through data!

Experience

6 yrs 10 mos
Total Experience
2 yrs 9 mos
Average Tenure
1 yr 1 mo
Current Experience

Vensysco technologies limited

Reporting Analyst

Apr 2025Present · 1 yr 1 mo · Noida, Uttar Pradesh, India · On-site

Looker StudioGoogle SheetsData AnalysisData Visualization

Self-employed

Sonali Gupta (YouTube Channel)

Jan 2025Present · 1 yr 4 mos

  • Creating content based on personal experiences and challenges.
  • Sharing real-world data insights, tools, and techniques.
  • Simplifying Excel, SQL, and Power BI for practical learning.
  • Delivering hands-on tutorials and real-world case studies.
ExcelSQLPower BIData AnalysisData Visualization

Career break

Professional development

Nov 2024Dec 2024 · 1 mo

  • Actively engaged in hands-on projects to enhance both technical and non-technical skills, fostering a well-rounded professional profile.
  • Committed to continuous learning and upskilling, acquiring knowledge and expertise that contribute significant value to any organization.

Manjushree technopack limited (mtl)

Officer HR Analyst

Sep 2023Oct 2024 · 1 yr 1 mo · Bengaluru, Karnataka, India

  • 📌Data Analysis and Reporting:
  • Collected, processed, and analyzed large datasets of 10,000+ employees to uncover trends.
  • Consolidated data from 25 plants into a unified dataset, enabling more accurate analysis.
  • Generated HR reports using advanced MS Excel tools like Pivot Tables, VLOOKUP, SUMIF, etc.
  • Performed data cleaning, validation, and transformation in Excel using tools like Conditional Formatting, Data Validation, and Advanced Filters.
  • 📌Data Accuracy and Maintenance:
  • Ensured 100% accuracy, relevancy, completeness, and consistency of employee data across 25 plants.
  • Maintained precise and up-to-date employee records, ensuring accuracy in product-related updates.
  • 📌 Dashboard Design and Visualization:
  • Designed an employee dashboard using Microsoft Power BI for delivering actionable insights and enhancing data-driven decision-making.
  • 📌HR Technology and Training:
  • Proficiently managed HRMS tools like Darwinbox and Bluetree, overseeing 10,000+ employee records.
  • Executed and managed monthly payroll activities, ensuring seamless and accurate processing.
  • Handled attendance, leave, and employee-related queries for blue-collar and white-collar employees across India, ensuring timely resolutions.
  • Provided training on Darwinbox to the HR team across all India locations, improving HRMS adoption and operational efficiency.
Data VisualizationMicrosoft ExcelHR AnalyticsMicrosoft Power BIData Analysis

Kpmg

Data Analytics Consulting Virtual Internship

Jan 2023Jan 2023 · 0 mo

  • During this internship performed three main tasks-
  • → Data Quality Assessment: Evaluated the data accuracy, consistency, completeness, relevancy and provide the clean and transformed data to the business.
  • → Data Insights: Generated the important insights that helps the business.
  • → Data Insights and Presentation: Present the data in the form of visuals.
Data Analysis

Pwc

Power BI Virtual Case Experience

Dec 2022Dec 2022 · 0 mo

  • During this internship I have completed the three tasks and perform the following things-
  • Import data
  • Transform and clean data using power query
  • Calculated some measures using DAX
  • Developing interactive dashboard
  • Provide meaningful insights
Data VisualizationKPI DashboardsMicrosoft Power BIData Analysis

Career break

Personal goal pursuit

Jun 2018Nov 2022 · 4 yrs 5 mos · Gwalior, Madhya Pradesh, India

  • I was preparing for Civil Services Examination ( UPSC, MPPSC) but due to Covid-19 and some other reasons the exam is getting delayed continuously and unfortunately I couldn't clear the exam and decided to resume back in private industries.

Education

ITM Gwalior

Bachelor of Engineering - BE — Information Technology

Jan 2014Jan 2018

A.M.I. Shishu Mandir

PCM

Stackforce found 100+ more professionals with Data Analysis & Data Visualization

Explore similar profiles based on matching skills and experience

Sonali Gupta - Associate Consultant | Stackforce