My Skill Set

I place a higher value on theoretical knowledge over the technology used to implement it. I have dedicated myself to gaining a deep understanding of the core principles of my profession. Here are a few key areas of my expertise:

1. Dashboard Design for Accounting Software

   • Objective: Create a data visualization dashboard as the home page for accounting software.
   • Tools Used: Angular + Highcharts.js (front-end), Spring Boot (back-end), and SQL (data analysis).
   • Outcome: Designed and implemented insightful dashboards that improved user experience and provided actionable insights

2. SQL Procedure for Financial Calculations

   • Task: Develop a stored procedure to calculate stock value for balance sheets, considering complex policies.
   • Tools: MySQL
   • Result: Optimized calculations and delivered accurate financial insights, earning recognition from management.

3. PDF Data Extraction and Consolidation

   • Client: Small software company.
   • Objective: Parse data from thousands of PDF files to generate a consolidated Excel report.
   • Technologies Used: Excel VBA for automation.
   • Result: Delivered a timely, consolidated report that was crucial for a marketing campaign.

4. Sales Reporting and Automation for SBI Card

   • Role: MIS Executive.
   • Achievements:
     • Created automated reports and interactive dashboards using Excel and VBA.
     • Migrated data to MS Access and developed a fully automated reporting system.
     • Designed a user-friendly data entry form to validate inputs, improving data accuracy and enforcing credit card eligibiliy rules.
   • Impact: Reduced manual work, improved data integrity, and facilitated informed decision-making for managers.

How I Can Help Your Business