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
Delhi01.2004
X -
CBSE BOARD
Delhi01.2002
B. TECH - Electronics and Communication
Vellore Institute of Technology (VIT VELLORE)
VelloreSkills
- 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)
Similar Profiles
Hrishikesh Sudhir MithbavkarHrishikesh Sudhir Mithbavkar
Senior Lead/Project Leader at Majesco Software Solutions Pvt. Ltd.Senior Lead/Project Leader at Majesco Software Solutions Pvt. Ltd.
Murtaza PiyersoapMurtaza Piyersoap
Principal Engineer – Agile Coaching & Program Management at Majesco Software Solutions Pvt. Ltd.Principal Engineer – Agile Coaching & Program Management at Majesco Software Solutions Pvt. Ltd.
Arjun NagarajanArjun Nagarajan
Lead Engineer - Testing at Majesco Software & Solutions India Pvt LtdLead Engineer - Testing at Majesco Software & Solutions India Pvt Ltd
Simran SSimran S
Travel Consultant at BCD TravelTravel Consultant at BCD Travel
Kannan LKannan L
Service Owner - Identity Global Products at AXA Global Business ServicesService Owner - Identity Global Products at AXA Global Business Services