Open to opportunities

Shivam Gupta

@shivamgupta15

Message

Data Analyst and QA-focused analyst who builds Power BI insights and delivers reliable manual testing.

India

Message

What I'm looking for

I’m looking for a role where I can combine data analysis and reporting with hands-on QA—turning requirements into clean datasets, dashboards, and well-documented testing to improve product quality.

I turn messy datasets into decisions using MS Excel, SQL, Python, and Power BI, and I’ve built dashboards plus automated extraction workflows with Excel Macros. I also support rigorous research work, including literature reviews and structured data analysis.

From coordinating admission exam processes and maintaining accurate student data on an internal portal to executing manual testing across multiple mobile apps and web portals, I document 100+ bugs with clear evidence. I run regression testing, provide UI/UX feedback, and suggest enhancements to improve real product workflows.

Experience

Work history, roles, and key accomplishments

Research Analyst

Saanvi Innovative Soln.

Oct 2025 - Dec 2025 (2 months)

Completed research methodology work including literature reviews and data analysis using Mendeley, Turnitin, Excel, and SPSS. Delivered structured research chapters and analysis outputs for Oct–Dec 2025.

Research Methodology literature review Data Analysis Mendeley Turnitin SPSS Microsoft Excel

Data Analyst & Manual Tester

E-Biz Technocrats

Apr 2025 - Sep 2025 (5 months)

Managed admission exam data for 2,200+ students across 51 exams by cleaning Excel batches, removing duplicates, and validating records. Performed manual testing on a multi-category platform (3 mobile apps, 4 web portals) and reported 100+ bugs with documented regression, UI/UX feedback, and workflow inspections.

Data Analysis Microsoft Excel Data Validation Manual Testing Regression Testing Bug Reporting

Data Analyst Intern

ERP Boss

Jan 2025 - Mar 2025 (2 months)

Created monthly sales and inventory reports by cleaning and preprocessing Excel datasets. Built Power BI dashboards for trend and insight visualization and implemented data extraction automation using Excel macros.

Power BI Microsoft Excel Data Cleaning data preprocessing Dashboarding Excel Macros Reporting Data Extraction

Business Analyst / Accounts Manager

BLSD Lab

Dec 2023 - Mar 2024 (3 months)

Developed a sales operations system and documented business processes for Business Unit projects. Managed reporting and budgets while supporting operational planning from Dec 2023 to Mar 2024.

Business Analysis Sales Operations Process documentation Requirement gathering Reporting Budget Management

Education

Degrees, certifications, and relevant coursework

Harcourt Butler Technical University (HBTU)

Bachelor of Technology, Computer Science and Engineering

Grade: 73.96 %

Completed a B.Tech. in Computer Science and Engineering, learning programming and development technologies, and also studied an online complete web development bootcamp.