Summary
Overview
Work History
Education
Skills
Personality Traits
Timeline
Generic
PRAJWAL H M

PRAJWAL H M

Bangalore

Summary

Results-driven Technical Analyst with strong experience in financial data reconciliation, GST analytics, and data visualization. Proficient in SQL, Excel (including VBA and Power Query), Power BI, and Tableau. Demonstrated ability to extract insights from large datasets, support tax compliance, and deliver automated reports for the Commercial Tax Department. Seeking roles in Finance or Data Analytics domains to contribute analytical and automation expertise.

Overview

6
6
years of professional experience
6
6
years of post-secondary education

Work History

Technical Analyst

RMS Technologies Pvt Ltd
Bangalore
12.2023 - Current
  • Company Overview: Commercial Tax Department
  • Reported to the Deputy Commissioner of Commercial Taxes and contributed to strategic decisions via comprehensive monthly MIS reports covering tax revenue, arrears, and compliance.
  • Developed and maintained MIS dashboards for real-time tracking of GST collections, return filing statuses, and VAT arrears recovery progress.
  • Analyzed GST data (GSTR-1, GSTR-2A, e-way bills) and reconciled high-volume taxpayer records across multiple industries.
  • Automated reporting and reconciliation processes using Excel VBA, macros, and Power Query, reducing manual effort by over 40%.
  • Built dynamic Power BI and Tableau dashboards to visualize filing patterns, tax shortfalls, and collection targets versus actuals.
  • Conducted end-to-end reconciliation of returns with books of accounts and detected mismatches to flag potential tax evasions.
  • Conducted follow-ups with field officers and taxpayers for recovery of pending dues, including VAT arrears and old demands under pre-GST laws.
  • Supported audit teams by validating financial statements such as balance sheets and P&L accounts against return data.
  • Performed variance analysis and trend reporting to identify non-filers, short filers, and repeat defaulters.
  • Generated daily and monthly performance reports on tax collection efficiency, enforcement actions, and arrear settlements.
  • Collaborated with audit, enforcement, and legal cells to prepare data-driven case files under GST Sections 65, 67, 73, and 74.
  • Assisted in creating standardized templates and tools for district-wide tax monitoring and reporting practices.
  • Played a key role in systematizing taxpayer profiling for better arrear tracking and compliance behavior forecasting.
  • Commercial Tax Department

Associate Software Engineer Trainee

Torry Harris Integration Solutions
Bangalore
11.2022 - 03.2023
  • Worked on backend technologies including Java, Unix, SQL, and PL/SQL, supporting enterprise-level integration and service logic.
  • Applied Object-Oriented Programming (OOPs) concepts in Java to build modular and maintainable code structures.
  • Wrote and optimized SQL queries using JOINS (INNER, LEFT, RIGHT, FULL) to extract, filter, and join data from multiple relational tables.
  • Debugged Java applications and shell scripts in Unix environments to identify root causes of functional and performance issues.
  • Collaborated with senior developers in developing, testing, and deploying service logic as part of agile sprint cycles.
  • Assisted in unit testing and bug fixing, ensuring smooth performance and alignment with business rules.
  • Participated in code reviews, documentation, and troubleshooting in both development and staging environments.
  • Gained exposure to SOAP/REST API concepts and integrated them into service workflows using backend logic.

RPA Intern

Valenta.ai
02.2022 - 04.2022
  • Gained hands-on experience in the full RPA development lifecycle using UI Path, including planning, design, development, testing, and deployment of bots.
  • Developed automation workflows to reduce repetitive manual tasks such as data entry, validation, report generation, and file management.
  • Designed process flowcharts and logic using UI Path's drag-and-drop interface and implemented exception handling for robust automation.

In-plant training

Manyatha Solutions
01.2019 - 03.2019
  • Completed a hands-on training program focused on full-stack web development and scripting fundamentals.
  • Gained real-world exposure to dynamic website creation using PHP and MySQL for backend and WordPress for content management.
  • Learned responsive UI design techniques using Bootstrap, and automation basics with Python scripting.

Education

B.Tech - Computer Science

Reva University
Bangalore
06.2019 - 07.2022

Diploma - Computer Science

SDM Polytechnic
Ujire, Mangalore
06.2016 - 05.2019

Skills

Excel (VLOOKUP, Pivot Tables, VBA, Power Query)

SQL

Visual Studio

Python

PL/SQL

Power Bi

Technical analysis

Data analysis

undefined

Personality Traits

Being a judge of myself as a hardworking, ambitious and a capable team player, I can contribute substantially to any venture or organization, I join.

Timeline

Technical Analyst

RMS Technologies Pvt Ltd
12.2023 - Current

Associate Software Engineer Trainee

Torry Harris Integration Solutions
11.2022 - 03.2023

RPA Intern

Valenta.ai
02.2022 - 04.2022

B.Tech - Computer Science

Reva University
06.2019 - 07.2022

In-plant training

Manyatha Solutions
01.2019 - 03.2019

Diploma - Computer Science

SDM Polytechnic
06.2016 - 05.2019

Similar Profiles

CREATE PROFILE
PRAJWAL H M