SUMMARY

• Highly motivated and enthusiastic SQL and PL/SQL Professional with 10 years of experience in financial domain/Investment banking (Fixed income securities).
• Experience in the complete software development life cycle of the project and extensive involvement in analysis, design, development, testing, deployment, production - maintenance, operation-support, version control, bug tracking and bug fixing.
• Proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
• Have worked in development, maintenance and enhancement projects and was instrumental in proposing process improvements to enhance the quality of the project.
• Excellent PL/SQL programming skills using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data.
• Experience in Advanced PL/SQL Concepts such REF cursors, Collections. Extensively used PL/SQL tables and Oracle Bulk Collect to improve the performance.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Experience in writing shell scripts.
• Experience in Data Migration, data loading from flat files to database tables using SQL*Loader.
• Knowledge on Performance Tuning.
• Worked extensively using TOAD, SQL*Plus, PL/SQL Developer and UNIX utilities.
• Experience in data conversion activities like Extraction, Transform Loading of Data from Legacy systems to Target production systems.
• Experience working in UNIX and Windows 95/98/NT/XP/2000 environments.
• Extensively worked on developing PL/SQL code for data conversions.
• Knowledge on AS400 in ILE-RPG, CL/400 and DB2/400.
• Experience in database programming using Oracle 8i/9i/10g databases.
• Knowledgeable in Performance Tuning of Queries.
• Have got the experience in Post Production support, bug fixing and enhancement.
• Ability to learn new skills and take on greater responsibilities.
• Leading a team, monitoring and guiding the team members.
• Excellent communication skills, adapt in client interaction and understanding business applications.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment.
• Good Knowledge of Fixed Income Securities and their back-end processing which include regulator reporting, (Comparison & Matching), (Clearance & Settlement) and Re-conciliation processing.

TECHNICAL SKILLS

Languages and Development tools.: SQL, PL/SQL, Shell Scripting, SQL*Loader, SQL*Plus, Putty, WINSCP, TOAD, SQL Developer, SQL Navigator, Java, HTML, XML, UNIX shell scripts, CL/400, RPG/400, SQLRPGLE.

Database: Oracle RDBMS (11g,10g, 9i, 8i)

Operating Systems: Windows NT/2000/XP/7, UNIX

Knowledge Base tools: Oracle Metalink and Oracle Forums

Documentation: AIM Documentation (MD50, MD70, MD120, CV60, CV40)

Others: MS Office, MS Access, MS Excel & Visio

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

• Involved in Requirement, Analysis, database design and development and also analysis of the existing databases.
• Developed Technical Design Documents.
• Created DDL scripts for tables, views, constraints and indexes.
• Developed PL/SQL Procedures, functions, packages and triggers.
• Used PL/SQL features like PL/SQL tables, Pragmas for error handling, implicit, explicit and Ref cursors for data processing.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Optimized query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.
• Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the Staging tables.
• Executing the scripts and inserting data into the tables.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Developing SHELL SCRIPTS to automate the processes.
• Worked on the production issues and database maintenance.
• Writing Mappings for Transformation logic.
• Ensure all Technical Designs and build components are delivered with good quality by meeting object deadlines.
• Worked with project team and Offshore to resolve defects identified during testing.
• Adding constraints, tables according to the changes in the design documents.
• Documentation of Tables and Views.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Have done performance tuning for the complex queries in TOAD.
• Delivered the objects and respective documents by following Oracle’s AIM methodologies.

Environment: Oracle 10g, SQL, PL/SQL, SQL*LOADER, SQL*PLUS, UNIX

Confidential

Member Technical

Responsibilities:

• Worked closely with the Business Analysts and Business users to understand the business requirements.
• Involved in preparation of MD70s (Technical design documents).
• Client conversions - Handling client conversion process for new clients like CITI Bank, Confidential, BMO-Nesbit Merge, JP Bear Merge on to IMPACT system by studying technical and functional gaps
• Analyzing the Business Requirements, Preparing Technical Level Design.
• Taking up the enhancement and analyzing the requirement specification, preparing the High level and Low level design, time estimates and work allocation. Getting approval of the same in the review meetings.
• Handling Client special projects and upgrades.
• New functionalities - Providing needed information to existing clients when client wants to amend a new functionality of impact and also to ensure that client goes live with the new functionality.
• Client interaction on a daily basis and user interaction on need basis.
• Data Conversions - Data mapping between files sent by client on to impact equivalent files.
• Client static setup - Handling tasks like setting up static data for a client which includes NODS setup (NDM on demand), Bloomberg connectivity.
• As a product lead, I have to review the analysis and setup’s done for all the clients in both test and production regions
• Coordinating with Client Representatives in getting their requests completed by End of Day and working with them closely in resolving the issues and preparing tasks involved in a major client mocks and conversions.
• Providing batch support and ensuring successful nightly batch completion by resolving any batch issues.
• Designed and developed tables, views, SQL queries, stored procedures and functions to implement complex business logic and optimize system performance.
• Developed a PL/SQL code to convert the data from legacy systems to Oracle databases.
• Involved in the PL/SQL code review and modification for the development of new requirements.
• Developed custom stored procedures and packages to support new enhancement needs.
• Used PL/SQL features like PL/SQL tables, Pragmas for error handling, implicit, explicit cursors for data processing.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Optimized query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.
• Executing the scripts and inserting data into the tables.
• Wrote shell scripts that assisted in the migration of data and creation of custom views which served as primary tools for analysis.
• Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the Staging tables.
• Adding constraints, tables according to the changes in the design documents.
• Documentation of Tables and Views.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Have done performance tuning for the complex queries in TOAD.
• Worked with project team & Offshore to resolve defects identified during testing.
• Involved in preparation of MD70s, Test Cases and Migration Documents.
• Delivered the objects and respective documents by following Oracle’s AIM methodologies.
• Carried out unit testing successfully.

Environment: Oracle database 10g, Toad, SQL and PL/SQL, Shell Scripting, Winscp and Putty

Confidential

Software Engineer

Responsibilities:

• Designing Tables, Views, Cursors, Triggers according the requirements given in the design document.
• Writing code for stored procedures, functions according to the requirements.
• Used PL/SQL features like PL/SQL tables, Pragmas for error handling, implicit, explicit and Ref cursors for data processing.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Optimized query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.
• Executing the scripts and inserting data into the tables.
• Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the Staging tables.
• Adding constraints, tables according to the changes in the design documents.
• Documentation of Tables and Views.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Have done performance tuning for the complex queries in TOAD.

Environment: Oracle database 9i, Toad and PL/SQL.