Summary
Overview
Work History
Education
Skills
Timeline
Generic

Manchali Patil

Bangalore

Summary

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
  • Methodologies - Agile, Waterfall, Scrum
  • Cloud Services - AWS EC2, RDS, S3, IAM, API Gateway, Lambda, EBS, Cloud Watch
  • Build/DevOps Tools - Maven, ANT, Eclipse, Jenkins
  • Bug Tracking Tools - JIRA, Service
  • Web/Application Servers - Apache, JBOSS
  • SCM/Version Control Tools - Git, Subversion (SVN), Bitbucket
  • Monitoring Tools - Sonarqube, AppDynamics

Timeline

Senior Database Developer

Bank Of America
06.2023 - 10.2023

Project Lead

Servosys Solutions
01.2021 - 08.2022

Lead Software Engineer

Accelya Solutions
12.2009 - 12.2019

Bachelor of Engineering - Information Technology

University of Mumbai
Manchali Patil