MADHAN B
Contact No: +91 9514144501
Email: madhanme12@gmail.com
PROFESSIONAL SUMMARY
• Having around 2+ Years of experience as a PLSQL developer and involved in Production
Support.
• Experienced in the agile methodologies in Software Development Lifecycle.
• Have involved in Data Modelling in the Project Development using Modelling tools.
• Had worked in the Oracle Objects like Table, View, Sequence, Synonym, Index and
Materialized View.
• Having very good understanding of Data Dictionary Tables, Constraints in Oracle.
• Having good knowledge about DDL, DML, DCL and TCL languages in Oracle.
• Have ability to write Complex Queries using Group by, Having, Nested Functions, Joins
and Methods of Sub query to implement business logic.
• Familiar with Pseudo column, Analytical Functions, and Materialized Views.
• Had experience in external data loading into database using SQLLDR.
• Have good knowledge about Hierarchical Query, Multi-table Insert (INSERT ALL), CTE
(WITH Clause) and Regular Expression.
• Well Informed about Table Partitions and Index organized Tables.
• Having good knowledge in Global Temporary Table and Private Temporary Table.
• Have well experienced with Cursor and Exception Handling in PLSQL.
• Possess a strong understanding of Stored Procedures, Stored Functions, Packages and
Triggers in PL/SQL.
• Have worked with UTL FILE package for required report generation.
• Expertise and implemented Dynamic SQL to enhance database performance and
optimize query execution.
• Expertise in Performance Tuning to resolve Performance degradation by using Execution
Plan, Query Optimization, HINTS and Index.
EMPLOYMENT HISTORY
✓ Working as a Software Engineer with red cloud Soft Solutions Chennai from
October 2022 to Till Date.
✓ Worked as a Software Engineer with Capgemini Information Technology Pvt Ltd
Chennai from June 2022 to September 2022.
TOOLS USED
Environment Oracle 10g/11g, Unix
Oracle Developer SQL PLUS, PLSQL, SQL Developer, PuTTY
Ticketing Tool JIRA
Version Control Tool Tortoise SVN
Job Scheduling Autosys
PROJECT SUMMARY
First Premier Bank - Banking Application Nov 2022 to till date
______________________________________________________________________
Description:
First Premier Bank is the 13th largest ACH Originating Bank in the USA and the
9th largest issuer of MasterCard credit cards in the country. We are also honoured to
have served as the bank for the State of South Dakota for over 25 years, as well as the
bank for the City of Sioux Falls for nearly 20 years. The scope of the project that worked
on was to facilitate in the maintenance and development of the application which
supported personal banking on credit management, commercial loans management,
credit cards and consumer complaints dealing with different types of accounts and
services.
Roles and Responsibilities:
➢ Analysed the business requirements of the project by studying the Business
Requirement Specification Document.
➢ Created database objects like Packages, Procedures, and Functions, Triggers
according to the client requirement.
➢ Created Indexes on the tables for faster retrieval of the data to enhance database
performance.
➢ Used Pragma Autonomous Transaction to commit the child transactions without
affecting the parent transaction commit status.
➢ Created PL/SQL scripts to extract the data from the operational database into
simple flat text files using UTL_FILE package.
➢ Used Raise Application Error to handle exceptions and handled few users defined
errors.
➢ Used Bulk Collection for better Performance and easy retrieval of data, by
reducing context switching between SQL and PL/SQL engines.
➢ Identified several SQL and PL/SQL bottle necks using PL/SQL Profiler
(DBMS_PROFILER), Explain Plan, and Auto Trace.
Thrivent Financial - Trading Application July 2022 to Sep 2022
______________________________________________________________________
Description:
Thrivent Financial is a Fortune 500 not-for-profit financial services
organization headquartered in Minneapolis, Minnesota, and Appleton, Wisconsin, and
founded by Lutherans. Operating through its local chapters nationwide, Thrivent and its
subsidiaries offer financial products and services including life insurance, annuities,
mutual funds, disability income insurance, credit union products, money management,
brokerage services, retirement planning and more.
Roles and Responsibilities:
➢ Analysed and overviewed about the business requirement of the project and
worked according to the WR/CR which is raised from the end user.
➢ Convert the functional requirements into technical document as per the
business standards.
➢ Modifying various existing Packages, Procedures, and Functions according to
the new business needs and carrying out the impact analysis too.
➢ Involved in creation of sequences for automatic generation of Product ID.
➢ Created PL/SQL scripts to extract the buying/selling reports from the
operational database into simple flat files by using UTL_file package.
➢ Tuning the SQL queries, this takes long time to process the request using
Explain Plan, Hints to reduce the response time.
➢ Involved in code review and unit testing of code functionality using testing
environment to ensure the code that its bug free.
➢ Involved in the File monitoring Using UNIX commands for monitoring on daily basis.
CADEMIC PROFILE
BE (ECE) Tamil Nadu College of Engineering Coimbatore Affiliated to Anna University
Chennai.
PERSONAL INFORMATION
Father Name : Balasubramanian M
Date of Birth : 31 JULY 1984
Marital Status : Married
Nationality : Indian
Passport No : T4586628
Place of Issue : Coimbatore
Passport Expiry : 16 JUNE 2029
Present Location : Chennai
Languages Known : English, Tamil.
