Dinesh Punvasi Gupta
Analytically minded engineer with 2.5+ years building data pipelines and BI dashboards for a capital markets firm, tracking client KPI's, deal P&L, and portfolio performance for 40K+ clients. Strong SQL, Power BI, and Pythonjava background, with hands-on exposure to financial data at scale.
Experience
Software Engineer (Internship)
T.D. Williamson
Singapore
Java Spring Boot, MySQL, MSSQL, Redis, REST API
- Architected a robust RESTful API using Java Spring Boot to manage safety-critical "measuring card" data for global pipeline field operations.
- Planned and implemented a structured SQL database schema using Entity Framework/JPA principles to store complex operational parameters across six distinct tap locations (equalization, isolation, and bypass).
- Developed complex server-side validation logic and automated calculation engines for pipeline travel distances, reducing the risk of manual entry errors in high-pressure environments.
- Planned token-based authorization using JWT scopes and roles, allowing for granular access control across different user types (Technicians, Engineers, and Admins) within a Spring Boot microservices environment.
Software Engineer
Mirae Asset Capital Markets
Mumbai, India
Java Spring Boot, MySQL, MSSQL, Redis, REST API, Next.js
- Planned and optimized SQL queries and stored procedures to retrieve and analyse client data, improving data retrieval efficiency by 40% through Redis caching.
- Planned and owned 6 Power BI dashboards tracking client KPIs, deal P&L, and portfolio performance for 40K+ clients including data model design, DAX measures, row-level security, and training 15 internal users.
- Collaborated with stakeholders on the UI Global project, analysing user engagement data through Strapi CMS to improve content delivery efficiency by 20%.
Education
National University of Singapore
MTech
Mastered the systematic design of modern, scalable software architectures.
Applied digital product strategy, service design, and platform-as-a-business frameworks to manage and deliver robust software products.
GPA: 4.18/5
Skills
PROJECTS
TraceLogic — Knowledge Infrastructure Platform (DMPP, NUS)
User Research, Figma, Miro, Affinity Mapping, Market Sizing
- Conducted primary research with 6+ stakeholders across pharma and semiconductor sectors, synthesising findings into 3 structured insight frameworks via affinity clustering and thematic coding
- Quantified a $4B TAM knowledge management gap, mapping $260K/hr downtime costs to a structural training bottleneck across 65 high-downtime facilities in Singapore
- Applied Impact-Effort analysis and competitive benchmarking across 4 incumbent solution categories (LMS, VR, AR, document platforms) to identify product whitespace and prioritise roadmap
- Defined phased GTM strategy (SAM $40M to SOM $15M) targeting pharma/semiconductor clusters, projecting a 3× reduction in engineer onboarding time from 18 months to 6 months
TraceData AI — Fleet Telemetry Analytics Platform
Python, PostgreSQL, Redis, Celery, Docker, TypeScript, REST API
- Built real-time data pipeline processing fleet telemetry using Python, PostgreSQL, and Redis, handling 50+ events/batch with automated AI-driven scoring and sentiment analysis.
- Designed event-driven architecture with Celery workers for distributed analytics tasks (Safety, Scoring, Support, Sentiment), executed intelligent routing based on trip context.
- Enhanced microservices-based system with 10+ Docker containers, REST API backend, and TypeScript frontend for fleet performance visualization.
- Engineered data buffering and queue management using Redis sorted sets, ensuring data integrity while enabling sub-second query performance for analytics dashboards.
Customer Excellence — Data Analytics & Proactive Notification System(Mirae Asset Capital Markets)
Python, SQL, Redis, APIs, CSV pipelines
- Designed systematized data extraction pipelines from multiple sources (APIs, CSV, databases) processing 100K+ records daily.
- Reduced manual reporting time by 30% through systematized SQL pipelines processing 100K+ daily records
- Enforced Redis caching strategy reducing database query load by 40% and enabling real-time analytics.
- Created tracking database for notification metrics enabling data-driven insights and client reporting dashboards.
VIRTUAL COURSEWORK
Databricks, Singapore: AI Agent Fundamentals
Real-world agents use cases and introduction to agentic workflows and multi-agent systems.
Agent Bricks simplifies the development of enterprise-ready agents across various applications, with demos on Databricks.
CBRE, Mumbai: Project Management Simulation
Completed a job simulation focused on project management at CBRE.
Enhanced a Gantt chart to track project progress, risks, and dependencies.
CERTIFICATIONS & ACHIEVEMENTS
Certification in Managing Digital Products – Professional (Singapore Computer Society)
McKinsey Forward Program
Developed core competencies in structured problem-solving, influential communication, and digital toolkit applications.
Data Analytics Essentials — Digital Badge (Cisco Networking Academy)
Databricks Knowledge Badge - Building Retrieval Agents
Databricks Knowledge Badge - Building Single-Agent Applications
Hacker Rank Advanced SQL Certification
Demonstrated SQL queries, joins, indexing, and optimization.
LeetCode Problem Solving
Solved 300+ algorithm and data structure problems, strengthening coding efficiency.