Business Analyst · Delhi, India

Jatin
Sharma

Business Analyst skilled in SQL, Power BI, Tableau, and Excel — combining analytics with 6+ years of hands-on business operations experience.

✦ Open to Work Business Analyst Power BI SQL
8
Analytics Projects
7
Certifications
6+
Years of Ops Exp.

I don't just analyse data — I've lived in the operations these numbers describe.

SQLPower BI TableauExcel Data ModelingBusiness Strategy Digital MarketingSEO / WordPress

Currently based in Delhi · Open to BA roles in Delhi/NCR · GUVI × HCL Certified

Background

Business-first analyst with
operational leadership experience.

Hi, I'm Jatin — an aspiring Business Analyst who brings something most freshers don't: real operational context. I co-founded an Indo-Chinese café at age 14, managed a PVC wire manufacturing unit, and ran a real-estate sales operation. I've lived the problems that data solves.

After completing a Business & Marketing Analytics certification from GUVI (in collaboration with HCL), I now combine this operational background with technical fluency in SQL, Power BI, Tableau, and Excel.

I analyse problems by focusing on business impact first — identifying root causes, then supporting my findings with data. I'm now seeking an entry-level BA role where I can deliver meaningful outcomes.

Co-Founder & Ops Head — Indo-Chinese Café
Kanpur · 2018 – 2022
Started at age 14. Managed inventory, vendors, staff & customer ops. Ran for 3.5 years before COVID-19 impact.
🏗️
Sales Operations Executive
Kanpur · 2022 – 2023
Managed land property sales and soil supply business. Lead generation to deal closure.
🏭
Operations & Business Analyst Associate — Ajanara Gold
Bawana, Delhi · Nov 2023 – Present
PVC Copper Wire Manufacturing. Shifted factory to demand-driven model, reduced waste, improved logistics.
📊
Independent Business Operations Consultant
Delhi · Aug 2025 – Present
Guiding early-stage entrepreneurs on market entry, financial planning, and operations setup.
Work

Analytics Projects

8 real-world projects completed during the GUVI × HCL Business & Marketing Analytics program.

Hospital Dashboard
Project 01 — Final Project
Hospital Performance & Readmission Analytics System
Built a 4-page Power BI dashboard tracking 20+ KPIs across hospital operations and patient readmission analysis. Cleaned 10,000+ records in Excel, wrote 15 SQL queries — uncovering ₹741M revenue leakage and 69.2% avg bed occupancy across 6 departments.
SQLPower BIExcelHealthcare AnalyticsKPI Analysis
Healthcare · Hospital OperationsView ↗
Zomato Dashboard
Project 02
Zomato Order & Restaurant Analysis — Power BI
Imported Zomato data to MySQL, transformed with SQL, and built a 3-page interactive Power BI dashboard with KPI cards, heatmaps, scatter plots, and tree maps — analysing ₹15.57M revenue across 500+ restaurants in 5 cities with delivery efficiency vs. customer rating analysis.
Power BISQLDAXData Cleaning
Food & Beverage · Business AnalyticsView ↗
Amazon Fresh ER Diagram
Project 03
Amazon Fresh — SQL Database Analytics
Designed a fully normalised (3NF) relational database for Amazon Fresh with 6 tables — built ER diagrams, wrote advanced SQL queries (joins, subqueries, window functions) and ACID transactions to surface customer purchase insights, supplier performance, and revenue trends.
SQLER DiagramsData ModelingACID Transactions
E-Commerce · Retail AnalyticsView ↗
Sugar Cosmetics Tableau
Project 04
Instagram Performance Analytics — Sugar Cosmetics (Tableau)
Built a 10-sheet Tableau dashboard analysing Sugar Cosmetics' Instagram KPIs — tracking 1.27B impressions and 987M reach, engagement funnels by post type (Reels, Stories, Videos), hashtag performance, and day-of-week posting trend recommendations.
TableauSocial Media AnalyticsKPI Design
Digital Marketing · BIView ↗
Digital Marketing Dashboard
Project 05
Data-Driven Insights for Digital Marketing Campaigns
Simulated a Google DM Account Manager role — analysed campaigns across 57K users, identified 684% ROI and $7.84 ROAS, and built a 3-page Power BI dashboard covering channel performance, conversion rates by group, and strategic budget optimisation recommendations.
Power BIMarketing AnalyticsExcelROAS
Marketing & AdvertisingView ↗
Regional Sales Dashboard
Project 06
Analyzing and Visualizing Regional Sales Performance
Cleaned and analysed regional sales data in Excel across 5 product categories and 5 regions — built an interactive dashboard with pivot tables and dynamic slicers tracking ₹10M+ total sales, identifying top-performing zones and the impact of discounts on profit margins.
ExcelData CleaningSales AnalysisPivot Tables
Retail · Business IntelligenceView ↗
Kespa Wires Website
Project 07
Comprehensive Audit for Effective Digital Presence (Infosys)
Conducted a full website and SEO audit for Kespa Wires, analysed traditional vs digital marketing strategy, and designed a conversion-optimised landing page using WordPress — validated with page speed and SEO tools, featuring product showcases, CTAs, and a lead capture form.
SEOWordPressDigital MarketingLanding Page
IT Products & ServicesView ↗
Nykaa Brand Analysis
Project 08
Nykaa Brand Perception & Market Analysis
Analysed customer reviews and social media data to assess brand perception, identify market trends, and benchmark Nykaa against competitors like Amazon Fashion and AJIO — delivering strategic recommendations across pricing, product mix, and customer experience improvement.
Social Media AnalyticsReview AnalysisStrategic Recommendations
E-Commerce · FashionView ↗
Toolkit

Skills & Tools

Technical proficiency built through real projects and certification.

Data & SQL
MySQL / SQL Server
DDL, DML, TCL
Joins & Subqueries
ACID Transactions
Data Modeling / ER
Visualisation
Microsoft Power BI
Tableau Public
DAX Functions
Dashboard Design
KPI Storytelling
Analytics & Excel
MS Excel (Advanced)
Pivot Tables
Data Cleaning & EDA
Marketing Analytics
Campaign Analysis
Business & Digital
SEO Auditing
WordPress / CMS
Digital Marketing
Business Strategy
B2B Operations
Credentials

Certifications

📊
Business & Marketing Analytics with AI Tools — GUVI × HCL
📗
MS Excel Certification
📈
Microsoft Power BI Certification
🔍
SQL Server Certification
📉
Tableau Certification
💰
Finance Certificate
🗄️
AI – Database Administrator
📁  View All Certificates ↗

Let's work
together.

Open to Business Analyst roles in Delhi / NCR.