Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Accomplishments
Leadership Skills
Awards
Timeline
Generic

Madhusudan Bansal

Bangalore

Summary

Technologically proficient professional with strong customer service skills and effective time management. Demonstrated ability to multitask while addressing customer needs and resolving technical issues. Committed to delivering practical solutions that enhance user experience.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Project Support Lead

Majesco Software Solutions
Bengaluru
01.2024 - Current
  • Led support team to enhance customer service efficiency and satisfaction.
  • Trained staff on software tools and best practices for effective support.
  • Coordinated troubleshooting efforts for complex software issues with clients.
  • Oversaw workflow processes to streamline support ticket management systems.

Data Engineer / SQL Team Lead

PWC delivery center
Bengaluru
04.2023 - 08.2023
  • Developed Stored Procedures and T-SQL code to implement business logic for chatbot portal.
  • Applied Agile Model in SDLC process to enhance development efficiency.
  • Facilitated communication between financial users and chatbot by querying metrics and details.
  • Triggered responses through Stored Procedures to ensure accurate data delivery.

Lead DB Developer Role

Genpact Headstrong Pvt Ltd
06.2018 - 01.2023
  • Software : Toad for Oracle 12.8,Beyond Compare, Tortoise Git-Bucket, UC4,Informatica10.1, ETL, notepad++ etc
  • Skills : Oracle SQL, PL/SQL, Advanced PL/SQL, Performance Tuning
  • Team Lead - Managed Team of 10+ resources and monitored projects to ensure progress.
  • Lead Developer/ Team Lead Genpact Headstrong
  • Project Details
  • GRS - It is a trade repository where all the executed trades get stores in database and CME sent the custom reports to regulatory authority
  • SDLC process - Agile Model development strategy
  • To develop interfaces using oracle on top of Loan IQ
  • To create packages and procedure to implement the interface requirement
  • To perform Loan IQ batch job optimization using oracle tuning techniques to improve batch job runtime
  • To work on fixes as part of alacrity raised by users
  • To create new tables and modifying existing tables
  • To modify existing stored procedure to accommodate new business functionalities
  • To implement Loan IQ 7.4 upgrade functionalities through PL/SQL
  • To perform Root Cause Analysis (RCA)
  • To perform tech refresh for Loan IQ version upgrade
  • To improve upon existing processes and functions
  • To work in agile team situated around the globe
  • Assisting and training juniors in technical aspects

Senior Developer

JP MORGAN CHASE & CO
07.2016 - 06.2018
  • Company Overview: Loan IQ- Loan IQ product by MISYS. Domain- Commercial Banking. Desc- Loan IQ is flagship product developed by MISYS. JPM is using this product in commercial banking for lending loans to corporate.
  • Software : Toad for Oracle 12.8, Beyond Compare, Tortoise Git-Bucket, JIRA, notepad++ etc
  • Skills : Oracle SQL, PL/SQL, Advanced PL/SQL, Performance Tuning
  • This product is used to book loans and process loans till the end of the loan lifecycle for Bilateral lending, syndicated lending and secondary loan trading and for all commercial and lending purposes
  • SDLC process - Agile Model development strategy, Team Size(3 US + 3 INDIA)
  • Unix, Autosys, Informatica developer
  • Responsibilities
  • To resolve DB related issues and work for Jira items
  • To understand the business requirements and build the ETL process and PL/SQL code to implement the business logic
  • To work for optimization of Database and DB queries
  • Loan IQ- Loan IQ product by MISYS. Domain- Commercial Banking. Desc- Loan IQ is flagship product developed by MISYS. JPM is using this product in commercial banking for lending loans to corporate.

Senior Developer

Tata Consultancy Services Pvt. Limited
01.2016 - 07.2016
  • Company Overview: Big US MNC investment advisor firm. Domain- Investment Banking. Sub domain -Fixed Income.
  • Working for Fixed Income team which handles fixed income securities
  • Trading happens everyday for fixed income security bonds and Money Market instruments
  • Traders Used to trade the new or existing securities through trading applications and the trades goes through services and finally stores in Operational data warehouse and Trade DataMart
  • Different Downstream consumes the Trade data and Portfolio data required for analysis by PM's using end user tool
  • SDLC process - Agile Model development strategy, Team Size
  • Tools Used
  • Software: IRMA, ServiceNow, Quality Center 8.6, BMC Remedy, Beyond Compare, Tortoise SVN Oracle SQL, PL/SQL, ETL (Informatica Power Center-9.5), Ctrl-M, PL/SQL Developer, UNIX, Putty , Linux Box etc.
  • Big US MNC investment advisor firm. Domain- Investment Banking. Sub domain -Fixed Income.

SQL Developer, PL/SQL Developer, Senior Developer

Tata Consultancy Services Pvt. Limited
06.2014 - 12.2015
  • Company Overview: Top banking client. Domain- Banking. Sub-Domain- Wealth Management.
  • This Project aims at flow of data from one source system to another source system and finally into target system
  • T24>CSA>DSP>WM
  • Team Size(4+4)
  • To Work on the Portfolio Datamart that consists of all the funds and portfolio that Portfolio Managers need for their analysis
  • To work on Packages and procedures consisting of all the portfolio data loaders into Portfolio DataMart
  • To handle the Batch cycle and look after the performance of jobs
  • To create and enhanced the business logic residing under procedures using PL/SQL and ETL
  • To work on simplifying and streamline the PL/SQL objects and ETL mappings.
  • Top banking client. Domain- Banking. Sub-Domain- Wealth Management.

Developer Role

Accenture Services Pvt Limited
07.2010 - 05.2014
  • Skills : Oracle SQL, PL/SQL, Performance Tuning, Explain Plan, UNIX, TOAD for Oracle , SQL Plus, Putty etc.
  • To develop Oracle Views based on mapping specs provided by business engineering team
  • To create and develop XML code for Wealth Manager User interface
  • To develop and deploy Stored Procs and Functions for integration of applications
  • Involved in Unit Testing and Preparing Unit Testing Logs
  • To create and run the ctrl-M jobs
  • To develop ETL and run the workflows to load data from source database into target database
  • To raise and resolve Production issues
  • To coordinate and support testing team during PL/SQL code deployment in SIT and UAT development systems
  • To fix the PL/SQL code for any defects found in SIT and UAT
  • To make Release Deployment Plan for deployment of PL/SQL code into production.

Software Engineer

ACCENTURE SERVICES PVT LTD
07.2010 - 04.2014
  • Company Overview: US Multinational Telecom client.
  • Role PL/SQL Developer
  • Team Size - 5
  • Responsibilities
  • To create and run query on Client Database large volume database, using TOAD as the tool
  • It is a big Database formed on the principles of Data Warehousing
  • Using Toad to extract ad-hoc reports
  • Writing Cursors, Stored Procedures, case statement(s), object creation, Packages, Unix, Job -Monitoring
  • Also handled Manual sys
  • Involved in query tuning for large data by using hints
  • Performance tuning using Explain Plan
  • Requirement comes from end users pertaining Expense/Inventory of the Circuits/facilities
  • To understand the client/business requirements and face client interaction role to understand the business logic for the client requirements
  • To determine business, functional and technical requirements for Client application ADW
  • To review, analyze, and create detailed documentation of ADW
  • To provide technical assistance in understanding application requirements and developing solution designs to end customers/clients.
  • US Multinational Telecom client.

Education

XII -

CBSE BOARD
Delhi
01.2004

X -

CBSE BOARD
Delhi
01.2002

B. TECH - Electronics and Communication

Vellore Institute of Technology (VIT VELLORE)
Vellore

Skills

  • Oracle SQL and PL/SQL
  • Performance tuning
  • ETL and data warehousing
  • Data modeling
  • T-SQL and Unix
  • Shell scripting
  • Troubleshooting and analysis
  • Application development lifecycle
  • Design and coding
  • Testing methodologies
  • Cloud services: AWS and Azure
  • Data analytics: Synapse and Data Factory
  • EC2 and S3 management
  • Redshift database management
  • Communication and collaboration skills
  • Leadership and teamwork abilities
  • Time management strategies

Certification

Oracle Certified Associate

Personal Information

Date of Birth: 09/30/87

Accomplishments

Financial Domain, Retail, Telecom, Developed Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment., Built Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, sequences, and synonyms., Extensively used advanced PL/SQL features collections, records, bulk operations etc., Tuned SQL queries using Explain Plan, Hints for query optimization., 10+, 3+, 1+, 1

Leadership Skills

  • Communication
  • Leadership
  • Teamwork and collaboration
  • Time management

Awards

  • Spot Award, Accenture, 2012, Organizes quality work efforts
  • Spot Award, Accenture, 2011, Consistently delivering high quality deliverables
  • Appreciation Award, JP Morgan Chase, 2016, Received appreciation for performance
  • Excellent Performance Award, JP Morgan Chase, 2017, Received for outstanding performance
  • Cause for Applause, Genpact, 2021, Received for exceptional performance
  • Cheers Points, Genpact, 2022, Best performance on client project

Timeline

Senior Project Support Lead

Majesco Software Solutions
01.2024 - Current

Data Engineer / SQL Team Lead

PWC delivery center
04.2023 - 08.2023

Lead DB Developer Role

Genpact Headstrong Pvt Ltd
06.2018 - 01.2023

Senior Developer

JP MORGAN CHASE & CO
07.2016 - 06.2018

Senior Developer

Tata Consultancy Services Pvt. Limited
01.2016 - 07.2016

SQL Developer, PL/SQL Developer, Senior Developer

Tata Consultancy Services Pvt. Limited
06.2014 - 12.2015

Developer Role

Accenture Services Pvt Limited
07.2010 - 05.2014

Software Engineer

ACCENTURE SERVICES PVT LTD
07.2010 - 04.2014

XII -

CBSE BOARD

X -

CBSE BOARD

B. TECH - Electronics and Communication

Vellore Institute of Technology (VIT VELLORE)
Madhusudan Bansal