SUMMARY

• Over 10 plus years of experience as a Senior Programmer with extensive experience in Analysis, Design, and Development of client - server applications using Oracle Relational Database Management System (RDBMS), SQL and PL/SQL.
• Proficient PL/SQL Developer - Strong exposure in writing simple and complex SQL queries and creating PL/SQL Functions, Stored Procedures and Packages
• Experienced in advanced PL/SQL concepts such as VArray, Cursors, Bulk Collect and Dynamic SQLs
• Proficient in creating Oracle objects - Tables (Partitioned & Non-Partitioned), Views, Materialized Views, Triggers, Synonyms, Nested tables and Collections
• Developed various tools for - DB standardization, DB hygiene and maintenance activities
• Worked on various Oracle utilities and Application developers such as TOAD, SQL Developer, SQL *PLUS, SQL *Loader
• Expertise in Performance Tuning and Query Optimization - Extensive experience in analyzing query performances using EXPLAIN PLAN
• Experienced in re-designing PL/SQL procedures and fine tune queries to improve performance
• Experienced Technical writer - Involved in discussions with Business Users along with Business Analysts and provided feasibility report of business requirement
• Highly experienced in system analysis and translating Software Requirement Specification (SRS) and Business Requirement Specification (BRS) into Technical Specifications and Design
• Working knowledge on UNIX and Data Warehousing/ETL concepts - CreatedShell Scriptsfor invoking SQL scripts.
• Experienced in Design and Development of Data warehousing solutions for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio
• Developed Ab Initio Generic Graphs using various Ab Initio Components such as Partitions (by Key, Round Robin), Reformat, Rollup, Join, Gather and Merge
• Sound knowledge on SDLC process - Involved in all phases of Software Development Life Cycle- analysis, design, development, testing, implementation and maintenance of applications
• Good experience in version control of documents and database objects using tools like VSS, SVN and CVS
• Experienced working in financial processes/areas such as loan system, customer and distributors management, securities and mutual funds.
• Self-motivated and proactive leader with technical and exemplary communication skills.

TECHNICAL SKILLS

Domain: Banking - Loans; Investment Banking Insurance - Life Insurance; Customers and distributions management

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),DB2/UDB

Programming Languages: SQL, PL/SQL, Unix shell scripts

Operating System: Unix (Linux, HP Unix), Windows XP

ETL: Ab Initio (GDE 3.0.1, Co>Op 3.0.1)

Tools: SQL*LoaderTortoise SVN, CVS, VSS

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Developer

Responsibilities:

• Involved in Design and Development of PL/SQL Packages and Stored Procedures for various business requirements involving data extract
• Analyzed application wide DB maintenance activities and prepared consolidated report on different approaches used by various applications
• Created framework to standardize DB maintenance process such as -
• Purging old data from partitioned and non-partitioned tables
• Gathering table stats
• Table driven method to log error or info messages - decommission pipe method (ongoing)
• SPM implementation for SQL Baselines (ongoing)
• DB hygiene check such as - PK definitions, unusable index, large non-partitioned tables, global index etc
• Created generic procedures using dynamic queries to reduce redundant process
• Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using Autosys
• Attended trainings on functional areas - Investment Banking, Collateral management, Clearing and settlement

Confidential, NY

Senior Developer

Responsibilities:

• Involved in Design and Development of PL/SQL Packages and Stored Procedures for various business requirements involving data loading and reporting
• Redesigned existing stored procedures using the Bulk Collect and FORALL (Bulk Bind) methodology to improve performance of business modules
• Created various generic procedures using DBMS STATS and Rebuild Index to generate the statistics of tables and study query performance
• Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TKProf
• Created many adhoc queries to monitor the data and create statistical reports
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using Crontab
• Supported Testing Team in providing data, loading data in test environment using SQL *Loader, provided SQLs for testing the Test cases
• Created various database objects such as tables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL DeveloperandSQL* plus
• Involved in unit and integration testing of the jobs and prepared documentation
• Responsible for writing high quality and well documented code according to standards and documentation of various processes
• Developed Ab Initio Generic Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, merge etc
• Developed UNIX Shell wrappers to initialize variables, run graphs and perform error handling
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning
• Developed tool using excel VBA to help monitor resource allocation to improvise planning and task allocations

Confidential, NY

Senior Developer

Responsibilities:

• Involved in PL/SQL development (packages, procedures, Scripts, functions and triggers).
• Translated business requirement to technical specification and functional design documents for software development.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Involved in gathering business requirements from business users, stakeholders, and Subject Matter Experts (SME’s)
• Utilized in-depth knowledge of functional and Technical experience in Oracle PL/SQL, Unix Shell Scripting, Oracle SQL Loader and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
• Established Quality Procedures and continuously monitor and audit to ensure the deliverable meets quality goals
• Created adhoc procedures to sync data with the latest business rules
• Organized technical and functional training based on project needs

Confidential, NY

Senior Developer

Responsibilities:

• Involved in all the stages of Software Development Lifecycle (SDLC) – design, development, analysis, testing and deployment of timesheet application.
• Designed Logical and Physical Models using Erwin, TOAD and ER diagrams.
• Created custom triggers to automatically populate different tables and to restrict the data.
• Design and developed the scripts to create table, views, index and sequence.
• Used AUTONOMOUS TRANSACTION PRAGMA in the procedures to control the transactions.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Created Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Created test scripts and complex queries to test business logic as part of unit and system testing.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.