— HELLO, I'M

SURAJ GUPTA

MCA Student & Aspiring Data Analyst

I enjoy working with data, turning complex datasets into clear, evidence-based insights, and building practical reporting solutions that help teams make better decisions. Grounded by an MCA foundation, I also bring practical knowledge in UI/UX Design and Salesforce Administration to build cohesive, end-to-end data workflows.

View Projects → Download Resume

Connect:

DATA ANALYTICS SQL • Python • Power BI

TECHNICAL BREADTH Salesforce Admin • UI/UX

SCROLL TO EXPLORE ↓

01 / ABOUT

About Me

Bridging analytical logic, structured database modeling, and user-centered design.

I am an MCA (Master of Computer Applications) student currently building my professional career around Data Analytics. I have always been drawn to the clarity that data brings to complex problems—whether that involves cleaning raw transactional records, writing optimized SQL queries, or creating intuitive dashboards that turn numbers into actionable decisions.

My analytical foundation focuses heavily on exploratory data analysis (EDA), database normalization, and interactive business intelligence tools such as Power BI and Tableau. I place high value on data integrity, analytical rigor, and clean visualization.

In addition to core data analytics, I hold practical capabilities in Salesforce Administration and UI/UX Web Development. This broader context allows me to understand where business data originates, how enterprise CRM workflows function, and how non-technical stakeholders actually consume reports.

CAREER OBJECTIVE

To secure a role as a Data Analyst / Associate Data Analyst where I can apply my skills in SQL, Python, Excel, Power BI, and quantitative problem-solving to analyze business performance, optimize operational metrics, and support data-driven strategy.

Professional Overview

Status MCA Student & Aspiring Data Analyst
Core Stack SQL, Python, Power BI, Excel, Tableau
Supporting UI/UX, Salesforce Admin, Web Basics
Location PUNE
Availability Open for Full-time & Internships

Analytical Thinking

Breaking down ambiguous business questions into measurable analytical objectives.

Data Integrity

Rigorous data cleaning, schema validation, normalization, and outlier treatment.

III

Clear Visual Storytelling

Designing executive dashboards with visual hierarchy, avoiding chart clutter.

Continuous Learning

Actively refining statistical methods, modern database querying, and BI workflows.

02 / SKILLS

Skills & Capabilities

Data analytics represents my primary technical focus, supported by structured capabilities in Salesforce administration and modern web interface design.

PRIMARY FOCUS

Data Analytics & Business Intelligence

End-to-end capabilities from relational querying to executive visual presentation.

Excel Advanced Formulas, Pivot Tables, VLOOKUP/XLOOKUP

SQL Complex Joins, Aggregations, Subqueries, Window Functions

Python Pandas, NumPy, Matplotlib, Seaborn

Power BI DAX, Relational Modeling, Interactive Dashboards

Tableau Visual Dashboards, Story Points, KPI Cards

Statistics Descriptive & Inferential, Hypothesis Testing

Data Cleaning Handling Missing Values, Deduplication, Transformation

Data Visualization Visual Hierarchy, KPI Selection, Business Storytelling

SUPPORTING STRENGTH

Salesforce Administration

SUPPORTING STRENGTH

UI/UX & Web Development

TOOLS & ENVIRONMENT

Database & Development Tools

03 / PROJECTS

Selected Projects

Demonstrations of practical data analysis, SQL modeling, automated data pipelines, and business workflows.

Data Analytics

01 Retail & Revenue Analytics

Retail Sales Performance & Revenue Dashboard

An end-to-end sales analytics dashboard examining transaction logs across product categories, fiscal periods, and customer demographic segments to optimize store performance.

Excel SQL Power BI Data Modeling

PURPOSE & FOCUS:

Automated multi-store sales aggregation and structured DAX measures for YoY and MoM variance analysis.

GitHub Code → Live Demo →

Data Analytics

02 Quality Control & Statistical Modeling

Semiconductor Manufacturing & Quality Analysis

Exploratory data analysis and statistical feature selection on high-dimensional sensor data captured during semiconductor wafer fabrication to isolate failure patterns.

Python Pandas Data Analysis Seaborn

PURPOSE & FOCUS:

Identified leading chamber pressure and temperature variances correlated with wafer defect formation.

GitHub Code → Notebook →

Analytics & Web

03 Automated ETL & Market Analytics

Data Extraction & Market Intelligence Pipeline

An automated Python pipeline that captures structured product and pricing datasets from web endpoints, stages and transforms data in SQL, and serves dynamic Power BI reports.

Python Web Extraction SQL Power BI

PURPOSE & FOCUS:

Automated recurring data ingestion and schema validation to track price movements with zero manual data entry.

GitHub Code → Overview →

Salesforce

04 CRM Operations & Governance

Salesforce CRM Architecture & Workflow Automation

Configuration of custom objects, relationships, validation rules, record-triggered flows, and role-based security access matrices for client account management.

Salesforce Admin Flow Builder Reports & Dashboards Security (OWD)

PURPOSE & FOCUS:

Automated opportunity stage tracking and built executive matrix reporting with strict profile permissions.

Documentation → Overview →

05 / EDUCATION

Education

Formal technical education providing core foundations in computer applications, databases, and software engineering.

Current Degree 2025 – 2027 (Pursuing)

Master of Computer Applications (MCA)

DR. DY PATIL VIDYAPEETH

PUNE, MAHARASHTRA

CGPA: 9.18

Graduated 2022 – 2025

Bachelor of Computer Applications (BCA)

INTEGRAL UNIVERSITY

LUCKNOW, UTTAR PRADESH

CGPA: 9.7

Higher Secondary School 2019 – 2021

Higher Secondary School

JAY BAJRANG INTER COLLEGE

UTTAR PRADESH

Score: 75.2%

Secondary School 2017 – 2019

Secondary School

UNIVERSAL PUBLIC SCHOOL

UTTAR PRADESH

Score: 79.4%

06 / RESUME

A clearer view of my background, skills & journey.

My academic foundation, technical capabilities, and analytical practice converge into a strong profile for Data Analyst and BI-focused roles. I combine structured learning in MCA with hands-on exposure to SQL, Python, Power BI, Excel, Salesforce, and user-centered design thinking.

RESUME / 01 Open to Work

SURAJ GUPTA

DATA ANALYST

Fresher Profile

Education

MCA (Pursuing)

Dr. D. Y. Patil Vidyapeeth, Pune

BCA · Integral University

Technical Skills

SQL, Python, Power BI, Excel

Data Cleaning, Analysis, Reporting

Projects

Sales Analytics, KPI Dashboards

Data Visualization & Storytelling

Additional

Salesforce Administration

UI/UX & Workflow Design

Download Resume

07 / CONTACT

Let's Connect

I am currently open to Data Analyst job opportunities, graduate internships, and project inquiries.

Direct Channels

Feel free to reach out directly through any of the channels below or send a message using the form.

EMAIL sg022529@gmail.com LINKEDIN linkedin.com/in/suraj6386 GITHUB github.com/suraj-6386

LOCATION PUNE, MAHARASTRA

Send a Message

Messages are securely transmitted to my inbox.

Name *

Email *

Subject *

Message *