Executive Summary
Finance and Indirect Tax professional combining GST expertise with technology and data analytics, with experience at
BDO India and the Reserve Bank of India. Hands-on experience across multi-state GST compliance, tax audits,
litigation support, transaction assessments and banking analytics. Develops practical automation solutions using
Python, VBA, Power Query and Advanced Excel to streamline complex workflows, strengthen controls and deliver
data-driven insights.
Educational Qualification
Professional Experience
| GST Compliance & Automation |
- 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 for data processing, reconciliation, validation and return preparation.
- Developed and streamlined GSTR-2B reconciliation, GSTR-1 vs GSTR-3B exception checks, Summary Maker, GSTR-2B Consolidator and Credit/Debit Note Mapper tools adopted by multiple team members, helping identify potential eligible ITC of ₹40–50 lakh.
- Handled and coordinated GST refunds, audits and secondment assignments, including export and inverted duty structure refunds, with focus on reconciliations, documentation and completion status.
|
| GST Litigation & Risk |
- Handled and reviewed SCNs, ADT-01, ASMT-01 and DRC-07 matters involving factual analysis, reconciliations and legal research.
- Conducted and analyzed Probable/Possible Risk (PPR) assessments for large corporates, including PepsiCo, evaluating GST positions and potential tax exposures.
- Developed and executed an automated GST Litigation Reply Maker to streamline first-draft preparation for recurring notices and support structured responses.
|
| Indirect Tax Advisory |
- Advised leading industry players across technology, SaaS, supply-chain & logistics, mobility/EV and FMCG, with businesses having annual turnovers of approximately ₹1,000 – ₹10,000+ crore, on complex GST matters including inter-company and cross-border transactions, place of supply, valuation, ITC, contractual arrangements and capital restructuring.
- Prepared and drafted technical memoranda and issue-based tax analyses, supporting client finance/tax teams on complex transactions and business decisions, including assistance in Customs SVB, provisional assessment and bond-related matters.
|
| Banking & Financial Data Analysis |
- 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.
- Analysed credit growth, deposit mobilisation, CD ratio, NPAs and sectoral credit patterns, identifying significant period-on-period movements.
- Reviewed CBS and payment-system data, analysing transaction volumes, settlement flows and banking operations to assess bank performance.
- Built Excel-based MIS, Pivot analyses, variance/exception reports and management presentations for senior review.
|
Projects
GST Extension
- Extension that allows to download all the compliance copies from the Portal, available in the resource section of the website.
|
Flipkart Supply Chain Analysis - Dashboard
- Built an interactive dashboard analysing Flipkart's supply chain operations, covering inventory flow, delivery performance and logistics bottlenecks to surface actionable improvement areas.
|
Regional Banking Audit & Intelligence - Dashboard
- Built a regional banking intelligence dashboard analysing branch-level advances, deposits, CBS data, credit risk, NPAs, KYC/AML controls, transaction patterns and GL-to-CBS reconciliations to identify exceptions, process gaps and banking risk indicators.
|
Impact of Geopolitical Events on Investor Decisions
- Analysed stock market volatility driven by geopolitical events (Israel-Palestine, Indo-China), applying data visualisation techniques to interpret trading patterns.
|
Organisational Study - Bain & Company
- Explored Bain & Company's structure, operations and strategies as part of an organisational study at Christ University, Bangalore.
|
Tool Repository - GST & Payroll Utilities
- Built and published a personal repository of browser-based tools, calculators and automations, available at pushpakkumar.com, including a GST Extension for downloading compliance copies from the portal, an HRA Calculator, a Credit Note Mapping Tool, GSTR-1 and GSTR-3B Summary Makers, and a GSTR-2B Combiner.
🔗 View Projects ↗
|
Position Of Leadership
| Position of Responsibility |
- Web Development Lead - ICSFA 2023: Designed and developed the official website using PHP, HTML & CSS, managing performance, responsiveness, navigation and accessibility.
- Event Coordinator - Cognito 2024: Led planning, logistics, promotion and execution, coordinating team members to drive student outreach and participation.
- EDEC Business Society: Coordinated student initiatives focused on financial literacy, strategic thinking and entrepreneurship.
- Student Editor - Magnate: Contributed to editorial planning, content development and publication activities.
|
| Technical Skills |
- Programming & Automation: Python | Microsoft VBA | SQL | Power Query
- Data & BI: Advanced Excel | Power BI
- Finance & Accounting: Tally Prime | FMVA (Basic)
|
| Significant Awards & Certifications |
- CFA Level I - Cleared | NISM Investor Certification
- PwC Switzerland - Audit Job Simulation | White & Case - Private Equity Job Simulation
- Top Performer - RBI Research Internship | Best Co-Editor - Magnate
- Outstanding Achievement - ICSFA | Excellence in Social Service Award
|
| Extra-Curricular |
- Finalist - Eye Delineation, Quantum Competition | HCAP
- Interests: Technology & Automation | Business Strategy | Research | Photography
|