Shubham Jawalkar
About Me
I'm a Data Analyst & Automation Specialist with over 3 years of experience turning raw operational data into dashboards, automated reports, and decision-ready insights. Based in Pune, I specialize in building the tools — Excel/VBA automations, SQL-backed reports, and full-stack applications — that save teams hours of manual work every week.
Results-driven and detail-focused, I've managed end-to-end campaign reporting lifecycles and driven measurable process efficiency through automation. I translate complex, messy datasets into clear, actionable insights using Power BI, Python, and advanced VBA/Excel — and increasingly, into full working applications built with Flask and SQL.
Currently pursuing my MBA in Information Technology, I'm always exploring new technologies to bridge the gap between data and strategy.
Technical & Analytical Skills
Achievements & Certifications
Project Management Foundations
Wall of Fame Award
Quarterly RNR
Experience
Campaign Coordinator (Data & Automation)
Candorworks Pvt. Ltd | Apr 2024 – Present- Built KPI & SLA dashboards, improving reporting visibility for leadership across [X] campaigns/teams
- Automated MIS reports using VBA & SQL, cutting manual report-prep time by roughly [X%] / [X hours per week]
- Streamlined reporting workflows, reducing data errors and improving turnaround time by [X%]
MIS Executive
Candorworks Pvt. Ltd | May 2023 – Apr 2024- Prepared delivery reports and campaign performance trackers covering [X] campaigns/clients
- Maintained campaign lead trackers with advanced Excel tools, handling [X]+ records
- Supported data-driven decision-making with accurate, on-time reporting
Education
MBA – Information Technology
Sikkim Manipal University | 2026 – 2028BBA – Computer Applications
Savitribai Phule Pune University | 2022 – 2025HSC & SSC
Maharashtra State Board | 2017 – 2020Projects
Data Management Portal – Lead Management System
Developed a Flask + DuckDB web application for managing, importing, and analyzing lead data with role-based access control, multi-database support, audit logging, and interactive analytics dashboards.
Key Features
- Role-based access (Admin / Viewer) with password hashing and session hardening
- Lead management with CRUD, search, multi-country filter, and inline editing
- Bulk actions — select, delete, and restore soft-deleted leads from trash
- CSV and Excel import with auto column mapping and duplicate detection
- Filtered data export to Excel
- Multi-database support — create, switch, rename, and delete databases
- Analytics dashboards with Chart.js — country breakdown, job titles, trends, status distribution
- Audit log tracking all user actions across the system
- DuckDB embedded database with schema management
- Data extraction helper tool (VBS) for offline processing
Sales Performance Analytics Dashboard (FTD & MTD)
Designed an interactive Excel-based performance analytics dashboard to track First-To-Date (FTD) and Month-To-Date (MTD) sales metrics across multiple regions. The dashboard empowers leadership teams to quickly identify trends, spot underperforming areas, and take data-driven decisions without digging through raw spreadsheets.
Built entirely with advanced Excel formulas, pivot tables, and data visualization techniques, this solution converts raw sales data into a structured, real-time view of business performance. It reduced manual reporting effort significantly and improved visibility for stakeholders at every level.
Key Features
- Real-time regional sales performance breakdown with automated calculations
- Clear identification of top and bottom performers across teams
- Automated computation of averages, variance, and growth percentages
- Visual trend lines and charts for faster decision-making
- Structured MIS reporting format requiring minimal manual intervention
- FTD and MTD views for both short-term and monthly performance tracking
Microsoft Leads Packaging Automation
Nov 2024 – Dec 2024 | Savitribai Phule Pune UniversityDesigned a VBA-based automation solution to streamline packaging and delivery of Microsoft leads in client-specific template formats.
Process Flow
- Raw lead data pasted into structured input database sheet
- VBA scripts clean, validate, and organize data
- Automated transformation aligns data with client-approved templates
- Final output generated in client-required format
Key Benefits
- Reduced time spent on manual formatting
- Improved accuracy by eliminating human errors
- Consistent template-aligned lead delivery
- User-friendly workflow with minimal expertise required
HRMS Portal – Human Resource Management System
2025 | Personal Development ProjectBuilt a full-featured Flask-based HRMS for managing employees, leaves, payroll, recruitment, assets, tickets, goals, and onboarding from a single portal with role-based access.
Key Features
- Employee authentication with role-based access (Admin / Employee)
- Admin and employee dashboards with reporting views
- Leave requests, tracking, holidays, and regularization workflows
- Payroll and salary management modules
- Recruitment pipeline — jobs, candidates, interviews, offers
- Assets management, support ticketing, and onboarding/offboarding
- Analytics dashboards with data visualizations
- REST-style APIs documented with Swagger
- Docker support for containerized deployment
Recommendations
Vishakh Khandizod
"Shubham is a highly motivated, disciplined, and dedicated team player who consistently exceeds expectations. His commitment to continuous learning and exceptional collaboration makes him a valuable asset to any organization. I am confident that he will continue to excel in his future endeavors."
Shinde Mangesh
"I had the pleasure of working with Shubham Jawalkar for 2 years at Candorworks. He consistently demonstrated exceptional skills in MS Excel, VBA, Power BI, Automation, etc. and were instrumental in achieving the target within deadline. His ability to tackle problems by collaborating with all the other teams made a significant difference to our team. I highly recommend Shubham Jawalkar for any role that requires dedication, technical expertise, and a positive attitude."