Highly skilled and solutions-oriented Senior Software Developer and Technical Project Manager with 11+ years of experience in PLSQL, Java, Spring, Oracle, RDBMS, AWS, Code Design, Reviews, Project Management and People Management.
Overview
14
14
years of professional experience
Work History
Senior Database Developer
Bank Of America
Dublin
06.2023 - 10.2023
In Risk and Finance Team
Collaborated with cross-functional teams to understand requirements and deliver solutions
Facilitated discussions and provided technical guidance to ensure alignment with project objectives
Wrote PL/SQL procedures, functions, and packages to meet business requirements and deliver CR's
Worked on GIT, Bitbucket, Jenkins to automate build, test, and deployment processes.
Project Lead
Servosys Solutions
Mumbai
01.2021 - 08.2022
Led successful delivery of Loan Origination- Business Loan product for Axis Bank as Project Manager
Managed project plans, design, effort estimations, user stories creation, and product backlogs
Implemented PL/SQL modules to ensure daily refreshing of master data, facilitating seamless updates in application
Enhanced application performance by tuning SQL queries, implementing indexing strategies, and refactoring code
Developed and deployed APIs in Java Spring framework to detect fraudulent activities during Pre-Screening phase
Created JIRA dashboards to monitor management of production releases patches and manage the change request delivery process.
Collaborated with system design team to architect scalable and efficient server infrastructure integrating load balancers, and optimising database design for improved performance
Provided mentorship to team members, ensuring adherence to coding standards.
Lead Software Engineer
Accelya Solutions
Mumbai
12.2009 - 12.2019
Developed end to end implementation of IATA PASS module in PLSQL to standardize the invoicing process for over 10+ airlines, reducing invoice processing time by more than 70% time
Carried out Automated data verification, creation, and dispatch of standardized invoices, with supporting shipment data
Designed and implemented Audit Trail module, utilizing PL/SQL packages, triggers, and collections in Oracle, to ensure accurate and efficient tracking of data changes.
Optimized database design by analysing and creating indexes and normalizing database tables.
Created Dashboards for Product to display daily revenue, sales, and invoicing data.
SME for Airmail and Cargo modules, scheduler module for revenue accounting product, and migration of modules from CoolGen to Oracle Packages
Developed Rest APIs using Spring framework to interface accounting data to SAP framework
Created comprehensive High-Level and Low-
Level Design documents, along with detailed effort estimation sheets
Provided functional and technical guidance to team members and assisted them in their professional development
Collaborated on development of modules responsible for generating accounting entries for Revenue and Forex modules, as well as for creating invoices for GPOs, utilizing stack consisting of Core Java, J2EE, and Hibernate technologies.
Education
Bachelor of Engineering - Information Technology
University of Mumbai
2009
Skills
Programming Languages - SQL, PLSQL, Java, Spring
Databases -Oracle, RDS, DynamoDB
Data Management - Data Modeling, Normalization, Indexing, Query Optimization