Data Analyst | Finance & Accounting Background

SALIL RAJ GUPTA

Ex-Chartered Accountancy student pivoting into the tech world. Bridging the gap between complex financial logic and data analytics to drive business intelligence.

IntermediateSQL & Python
AutomatedETL Workflows
SQL
Python
Power BI
Excel

The Pivot Story

After clearing CA Foundation on my first attempt and dedicating years to mastering Accounting Standards, Taxation, and Law, I realized my true passion lies in the technology that powers financial decisions.

I don't just see numbers on a spreadsheet; I see the underlying business narrative. My background allows me to understand Accountability while my technical skills allow me to deliver Scalability.

8.1
B.Com CGPA
1st Attempt
CA Foundation

Tech Tinkerer

"Beyond data analysis, I enjoy building systems that automate and simplify life."

  • Prompt Engineering, Ability to Use AI in CLI For Better Context.
  • Self-hosted Home Server, Storage Server, Basic Linux & WSL.
  • Knowledge of Network Port Forwarding & Mesh Networking.
  • Passionate about integrating modern tech into legacy finance workflows.

Technical Competencies

A blend of financial rigor and data-driven technological capabilities.

Visualization

  • Power BI (DAX & Data Modeling)
  • Intermediate MS Excel
  • Interactive Dashboards
  • Report Automation

Programming

  • Python (Pandas/Matplotlib/SQLAlchemy)
  • SQL (Joins, Views, Queries, CTE's)
  • API Data Extraction (Requests, BeautifulSoup)
  • Script Automation (.bat scripting, Task Scheduler)

Financial Core

  • Accounting Standards (AS)
  • Corporate Taxation (GST/IT)
  • Financial Statement Analysis
  • Strategic Management

Featured Analysis Projects

Translating complex data into actionable business intelligence using modern tools and techniques.

View All Projects
End-to-End Crypto Market Pipeline & Dashboard
Automated ETL Pipeline: Python → PostgreSQL → Power BI

End-to-End Crypto Market Pipeline & Dashboard

A self-sustaining data system that captures real-time crypto snapshots to analyze market cap distribution and supply-side inflation.

PythonPostgreSQLPower BISQLAlchemy
Integrated a custom logging system and automated hourly data 'pulses'.
Built a historical time-series from a live API snapshot.
Project Deep Dive
SpaceX Launch Trends & Operational Analysis
Python & API Data Scraping

SpaceX Launch Trends & Operational Analysis

Automated retrieval of mission data from the SpaceX REST API to analyze mission success rates and fairing recovery trends over time.

PythonRequestsMatplotlibPandas
JSON data cleaning and Pandas table merging.
Multi-variable trend visualization for recovery successes.
Project Deep Dive
End-to-End Retail Analytics Dashboard Simulation
Business Intelligence

End-to-End Retail Analytics Dashboard Simulation

Synthesized a Generated, multi-table relational database modeled on professional retail environments. This dashboard tracks Profit Margins, Order Volume, and Average Spending.

Power BISQL JoinsExcel
Star-schema optimization for fast querying.
Interactive Regional Slicers and Drill-down cards.
Project Deep Dive

Academics & Certifications

Certificate

Google Data Analytics Professional Certificate

Coursera | Oct 2025

Comprehensive training in the data analysis lifecycle (Ask, Prepare, Process, Analyze, Share, Act).

Verify Certificate
CA Foundation

Chartered Accountancy - Foundation

ICAI | Jan 2024 (First Attempt)

Built a strong foundation in accounts, corporate reporting and taxation logic.

B.Com

B.Com | University of Delhi (SOL)

2023 - 2026 (Ongoing) | 8.1 CGPA

Specializing in business, financial management and statistical analysis.

Get in Touch

I'm always open to discussing new projects, creative ideas, or opportunities to be part of your visions. Whether you have a question or just want to say hi, my inbox is always open.