Vikrant Bharat Bhandwalkar
Pune
Summary
Results-driven software engineer with over 4 years of experience in financial services, focusing on cloud-native data engineering and full-stack development. Skilled in creating scalable ETL pipelines utilizing AWS services such as Glue, Lambda, and S3, alongside developing user-centric applications with React. Achievements include enhancing data workflows for user transactions and implementing CI/CD pipelines that increased deployment efficiency. Proficient in Python, PySpark, SQL, and AWS CDK for infrastructure as code. Aside from my job, I like to travel, run, and swim on the weekends.
Overview
5
5
years of professional experience
Work History
Software Engineer
Principal Global Services
Pune
08.2022 - Current
- Led BAU operations for Malaysia domain, ensuring seamless business continuity.
- Created and deployed AWS Glue ETL pipelines to process daily financial transactions with robust error handling.
- Designed CI/CD pipelines using AWS CDK, reducing deployment time significantly.
- Developed over 10 REST APIs in TypeScript for fund management and transaction processing.
- Built a data ingestion hub for the Hong Kong region, utilizing AWS Step Functions, S3, Glue, and DynamoDB.
- Optimized SQL queries across PostgreSQL and MS SQL Server, achieving a 45% reduction in execution time.
- Implemented AWS Lambda functions with EventBridge Scheduler for automated NAV calculations and email notifications.
Trainee Engineer
Principal Global Services
Pune
07.2021 - 07.2022
- Developed a customer-facing web application using React.js, adhering to Facebook's best practices and modern UI/UX patterns.
- Enhanced frontend performance through code-splitting and lazy loading, achieving 40% faster page load times.
- Implemented over 10 production improvements based on user experience analytics, boosting user engagement by 25%.
- Collaborated with cross-functional teams to deliver features following Agile methodology during biweekly sprints.
Education
Bachelor of Technology - Mechanical Engineering
Vishwakarma Institute of Information Technology (VIIT)
Pune01.2021
Skills
- Python
- JavaScript and TypeScript
- SQL databases
- HTML and CSS
- Java
- Reactjs
- PySpark
- AWS CDK
- PostgreSQL
- MS SQL Server and MySQL
- Oracle SQL Developer
Accomplishments
• Optimized ETL job performance by 1000x through batch error collection instead of individual DataFrame operations
• Reduced deployment time by 87% through CI/CD pipeline automation
• Reduced deployment time by 87% through CI/CD pipeline automation
Projects
Tom TA - Transaction Order Management, Principal Global Services
Designed and deployed AWS Glue jobs for extracting data from master databases, transforming business logic, and loading it into interim/staging databases
Leveraged Step Function for execution of glue jobs and error-handling mechanism
AAV Data Ingestion Hub, Hong Kong Region
Architected an end-to-end data ingestion pipeline using AWS Step Functions, S3, Glue, and DynamoDB that served real-time users.
RSC Customer Portal, Customer Engagement Platform
Built customer-facing React.js application for fund investment and portfolio management serving 50K+ users and maintained RESTful services, ensuring data consistency across multiple database systems
PISYS5
Handled critical legacy application on Spring Boot Java having 20M user for Hong Kong region.
Hobbies and Interests
- Outdoor running
- Swimming
- Traveling
Strengths
- Problem-solving
- Analytical thinking
- Team collaboration
- Continuous learning
Timeline
Software Engineer
Principal Global Services
08.2022 - Current
Trainee Engineer
Principal Global Services
07.2021 - 07.2022
Bachelor of Technology - Mechanical Engineering
Vishwakarma Institute of Information Technology (VIIT)