PUSHPAK KUMAR / WORK & PROJECTS
●  Pushpak Kumar — CA Finalist · Indirect Tax · BDO India

Finance and tax experience.
Applications I have built.

My work in GST compliance, banking research and financial applications. Each featured application includes my contribution, the technologies used and a note about its sample data.

CA Inter · 1st attempt Top RBI performer · 2024 CA Industrial Training from 22 December 2026
At a glance
10+ GST matters & hearings
₹900Cr+ Client business exposure
10+ Client engagements
7 Published GST tools
01

Featured project

Finance × Technology
PUSHPAK PRO · Supply Chain Finance

Supply Chain Finance Command Center — SCS

I built a demonstration dashboard for supply chain finance, connecting P&L, treasury, cash flow, working capital, inventory, logistics, procurement and risk into one decision-making view — analysing how inventory movement, fulfilment costs, logistics efficiency and working capital impact overall financial performance.

My contribution
I built the dashboard interface, financial KPI views, interactive charts and scenario controls.
Problem addressed
Reviewing cash flow, working capital, inventory and logistics costs in one place.
Technologies
HTML, CSS, JavaScript and Chart.js.

Demo data: Illustrative figures and simulated updates for portfolio demonstration.

Working Capital Cash Flow Supply Chain Risk Scenario Modelling AI Insights
View SCS Project
02

Featured project

Banking × Audit × Intelligence
RBI INTERNSHIP · Regional Banking Intelligence

Regional Banking Audit & Intelligence Dashboard — RBI

During my internship at the Reserve Bank of India, I worked with regional banking data, analysing branch-level accounts, advances, deposits and banking activity to identify trends, exceptions and process gaps across the regional banking ecosystem.

I developed a banking intelligence dashboard bringing together CBS surveillance, credit and loan analysis, NPA monitoring, KYC/AML checks, transaction analytics, GL-to-CBS reconciliation, suspense analysis, exception tracking and risk indicators into one structured regional banking view.

My contribution
I built the banking dashboard interface, risk visualisations, audit-domain views and simulated monitoring indicators.
Problem addressed
Reviewing credit, NPA, reconciliation and control exceptions together.
Technologies
HTML, CSS, JavaScript, SVG charts and CSS visualisations.

Demo data: Illustrative figures and simulated updates for portfolio demonstration.

Banking Audit CBS Analytics Credit Risk NPA Analysis KYC / AML GL Reconciliation Risk Analytics Macro Analysis
View Banking Dashboard
02

Tools I've Built

Loading…
Loading tools…
01

Selected work & experience

2024 — Present
Showing 7 / 7
RBI — Internship · Top performer JUN 2024 – NOV 2024 · 6 MO

Macroeconomic research & monetary policy analysis

Reserve Bank of India, Bengaluru Regional Office — evaluated credit facility usage across 50+ banking nodes for regional risk assessment.

  • Analysed sectoral credit across 50+ banking nodes, identifying a 12% variance in lending patterns that informed regional risk reports to senior economists
  • Analysed ₹2,000+ crore of advances across 10+ local/PSU banks, tracking sanctioned, disbursed and outstanding amounts and performing advance leakage checks across 1,000+ records
  • Reconciled 1,000+ advance records with bank reports and prior-period data, identifying mismatches, exceptions and material variances
  • Tracked CPI/WPI against repo-rate decisions across 6 consecutive MPC cycles; monitored Basel III CRAR, Tier 1 and PCR for scheduled commercial banks
  • Reviewed CBS and payment-system data and built Excel MIS, Pivot analyses, variance/exception reports and management presentations for senior review
Excel AdvancedRBI DBIEMOSPIFSR ReportsPythonBasel III
BDO — GST litigation · High-value matters DEC 2025 – PRESENT

Personal hearings & show cause notice response

Supporting tax litigation and defence for leading businesses across manufacturing, IT/SaaS, retail & FMCG, including large corporate groups with annual turnovers of approximately ₹500 crore to ₹10,000+ crore.

  • Assisted technical submissions for GST Personal Hearings (ADT-01) — drafting, document compilation and hearing support with the IDT team
  • Helped prepare SCN reply briefs on alleged ITC mismatches and short payment of tax — structuring legal-technical responses under supervision
  • Worked Place of Supply rules under the IGST Act and Section 16(4) ITC time limits through live client cases
  • Worked on complex Indirect Tax assignments for leading industry players across software/technology, SaaS, supply-chain & logistics, mobility/EV and FMCG, serving businesses with annual turnovers ranging from approximately ₹500 crore to ₹10,000+ crore.
  • Assessed inter-company and cross-border transactions, valuation, ITC, contractual arrangements and business restructuring, and prepared technical memoranda and issue-based tax analyses
  • Worked on SCNs, ADT-01, ASMT-01 and DRC-07 matters, contributing to assignments that helped reduce potential tax exposure by ₹10+ crore
  • Supported GST refunds, audits, due diligence and secondment assignments, including export/inverted-duty refunds and Customs SVB, provisional assessment and bond-related matters
GST PortalGSTN LitigationTally ERPInd AS 37Excel Advanced
BDO — Compliance · 10+ clients DEC 2025 – PRESENT

End-to-end GST compliance

Monthly compliance across manufacturing, IT and retail — GSTR-1, GSTR-3B and GSTR-6 (ISD) filings as part of the IDT team.

  • Managed GST compliance across 16 states, covering GSTR-1, GSTR-3B and GSTR-6 (ISD), with end-to-end automation using Python, VBA, Power Query and Advanced Excel
  • Assisted monthly GST compliance for 10+ clients; prepared REG-01 registration filings and tracked departmental deficiency queries
  • Hands-on GSTR-6 (ISD) exposure for multi-branch entities — ITC distribution across GSTINs
  • Built Excel compliance trackers using XLOOKUPs and conditional formatting that reduced recurring manual reconciliation work
Excel + Power QueryITC AuditGSTR-1/3BGSTR-6 ISD
BDO — ITC risk · Working papers DEC 2024 – PRESENT

GSTR-2A/2B reconciliation & ITC risk

Invoice-level matching across GSTIN, invoice numbers, dates and tax amounts for multi-crore purchase registers.

  • Automated reconciliations with Power Query and nested XLOOKUPs across multi-crore purchase registers
  • Designed a reusable reconciliation template adopted as the team-standard working paper — reconciliation time down 70%
  • Built GSTR-2B reconciliation, GSTR-1 vs GSTR-3B exception checks, Summary Maker and Credit/Debit Note Mapper tools adopted by multiple team members
  • Helped identify potential eligible ITC of ₹40–50 lakh through automated reconciliation and exception analysis
  • Generated vendor follow-up lists flagging ITC at risk of lapsing under Section 16(4)
Excel + XLOOKUPPower QueryGSTR-2BSec 16(4)
BDO — Annual return · Audit DEC 2024 – PRESENT

GSTR-9 annual return & 9C audited reconciliation

Twelve-month cross-verification of reported turnover against books of accounts, across multiple GSTINs.

  • Conducted month-by-month comparison of reported turnover vs books of accounts — reconciling differences arising from credit notes, debit notes and amendment entries
  • Supported GSTR-9C (Audited Reconciliation Statement) preparation by cross-checking audited financials against GSTR-3B figures under supervision
  • Prepared reconciliation workings and supporting schedules for annual return filing across multiple GSTINs
  • Gained understanding of the tax-financial statement interface — connecting GST adjustments with Ind AS disclosures and tax provisions in financial statements
TallyGSTR-9CInd AS 12Ind AS 37
Tools — Tax Engine v4.2 · NVIDIA × SAP ONGOING

GST automation & analytics engine

AI-augmented tax practice — a GPU-accelerated utility layer over SAP S/4HANA spanning reconciliation, litigation risk, predictive compliance and Ind AS impact.

  • GST Reconciliation Engine — real-time GSTR-2B vs books matching at 99.4% accuracy, <2ms query latency, ₹10Cr+ ITC analysed
  • Litigation Risk Scoring — ML-driven SCN probability, ITC exposure quantification and Section 16(4) deadline alerts
  • Developed an automated GST Litigation Reply Maker for recurring notices and supported Probable/Possible Risk (PPR) assessments for large corporates
  • Predictive Compliance + Ind AS Interface — GSTR-3B variance forecasts, anomalous HSN flags, auto-drafted ADT-01 briefs, live Ind AS 12 / 37 mapping
  • Developed an automated GST Litigation Reply Maker for recurring notices and conducted Probable/Possible Risk (PPR) assessments for large corporates
NVIDIA AISAP S/4HANALLMSAP HANA
Tools — Independent · Living to Zeil OCT 2024 – PRESENT

Finance tools & workflow automation

Built, deployed and used in practice — including a content and fintech tools platform selected for the Harvard HCAP programme.

  • GSTR-2B consolidation script — cleans messy GST portal exports into one workbook, packaged as a standalone .exe for non-technical users at BDO
  • Browser HRA calculator (Sec 10(13A), all three legal conditions) and a full-rate GST calculator with CGST/SGST/IGST splits
  • 4+ live finance tools plus Excel macro reconciliation templates adopted internally — infinitely reusable
  • Developed practical automation using Python, VBA, Power Query, Advanced Excel, SQL and Power BI to streamline data processing, reconciliation, validation and reporting
  • Founded Living to Zeil, combining finance writing, practical calculators and UI-driven tools for professionals; selected for the Harvard HCAP programme
  • Technical toolkit also includes SQL and Power BI, alongside Python, VBA, Power Query and Advanced Excel for finance and tax automation
  • Web Development Lead – ICSFA 2023: designed and developed the official website using PHP, HTML & CSS, with responsibility for performance, responsiveness, navigation and accessibility
Python · PyInstallerExcel / VBAJavaScriptHTML / CSSPower Query
04

What Professionals Say About My Work

Selected feedback
" CA EDUCATION · CHRIST UNIVERSITY

Pushpak is a talented and highly adaptive individual who picks up new concepts quickly and applies what he learns with clarity. His commitment to continuous improvement, curiosity, discipline and willingness to learn make him a valuable asset to any team or organisation. I recommend him without reservation.

CA Sunil Amlani Faculty for CA & Commerce Students · Christ University
" INDIRECT TAX · BDO INDIA

Pushpak brings a rare mix of strong tax knowledge and excellent technology skills. He grasps complex provisions quickly and uses technology to make work faster and more accurate. Curious, reliable and a quick learner, he would be an asset to any team. Highly recommended!

Karthik M Partner & Leader, Indirect Tax – South · BDO
" TAX TECHNOLOGY · AUTOMATION

Pushpak is a technology enthusiast who finds innovative ways to solve automation problems. He is hands-on with multiple technology tools and is a champion in Python. His tools are excellent, easy to use, and generate quality outputs in no time.

Ashish Nema Associate Director · Indirect Tax Specialist, BDO
" TECHNOLOGY × LAW · BDO INDIA

What truly sets Pushpak apart is his rare ability to merge technology, law and innovation. He connects the dots, simplifies complex tech-law intersections, and builds practical solutions that work for business. Always prepared, quick to learn and willing to go the extra mile, he takes complete ownership and genuinely makes a senior's job easier. Any team working at the intersection of technology and law would be lucky to have him.

Mugdha Narayan Associate Partner, Indirect Tax · BDO India
" RBI · BENGALURU

Pushpak demonstrated strong analytical ability during his work on macroeconomic research. His work was detailed, data-driven and presented with impressive clarity.

Senior Research Officer Reserve Bank of India
" FINTECH

He combines financial understanding with the ability to build practical tools. The dashboard work made complex analytics much easier to understand and use.

Ananya Gupta Founder · FinSync India
" TAX · CONSULTING

Pushpak has a rare ability to combine design with financial accuracy. His automation work helped reduce repetitive reporting and made the workflow significantly more efficient.

CA Rohan Mehta Partner · Mehta & Co.
" EDTECH

He brought a strong design-thinking approach to the platform. Complex finance concepts became much easier to understand through the interface he helped shape.

Shruti Nair Founder · LearnFi Platform
" ACCOUNTING TECH

Pushpak's understanding of both finance and technology stood out. His work on backend APIs showed that he can move comfortably between accounting requirements and technical implementation.

Rahul Sharma Co-Founder · Ledgerly Tech
" TAX · KOLKATA

He brought financial knowledge and attention to detail into both the website and client-data automation work, creating a much more precise and efficient experience.

Divya Agarwal Tax Consultant · Kolkata
05

Repository

Project files
File Type Size Updated Download
Pushpak_Kumar_Resume.pdf PDF—— Get
Monte Carlo Simulations.xlsx XLSX—— Get
Variance Analysis Dashboard.xlsx XLSX—— Get
06

Finance knowledge plus the ability to build tools. — Let's talk.