SUMMARY:

• Over fourteen years of professional experience in Analysis, Design, Development, Testing, Implementation and Maintenance, Production support of Software tools and Application packages As a Senior Oracle PLSQL Developer.
• Very strong skills & clear understanding of requisites and solutions to various issues in implementation throughout the Software Development Life Cycle (SDLC) which include
• Analysis, Design, Development and Testing.
• Proficient in writing Packages, Stored Procedures, Functions, Views, Database Triggers,
• Collections and Analytical functions using SQL & PL/SQL in Oracle.
• Excellent understanding of the Oracle Architecture.
• Extensive experience in Analysis & Design of Database schemas.
• Created ER Diagrams (Logical/Physical data models).
• Experience using Bulk processing, REF cursors and Oracle Supplied DBMS packages.
• Excellent knowledge on Data migration & Data conversion.
• Hands on experience with Data loading using SQL*Loader and External tables.
• Experience in utilizing Oracle tools and methods like the use of merge statement, Pipelined functions.
• Expert in Performance Tuning & Query Optimization of SQL statements using EXPLAIN PLAN, SQLTRACE, TKPROF, DBMS Profiler and HINTS.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Strong in using tools such as TOAD, SQL*Plus and SQL Developer.
• Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
• Experience with shell scripting for creating UNIX processes, running background processes.
• Expertise in debugging and analyzing production issues.
• Experience in communicating with end users when working on Production Support.
• Interfering and effective communicating during outages with all down and upstream teams and business users
• Very good experience in handling severity one and two incidents.
• Expertise in handling disaster recovery and FWP tests as per the DB policy.
• Handling all weekend activities required to maintain the system in production environment.
• Maintaining the file system space to avoid any major incidents in production.
• Maintaining the database by doing the regular archival to avoid major incidents in production.
• Excellent planning, analytical, written Communication and Interpersonal skills.
• Strong technical aptitude, ability to rapidly assimilate and design practical applications of new technology.
• Guided and lead team members in various stages of the project
• Good team player and ability to work independently.
• Excellent logical and analytical skills, enthusiastic, excellent interpersonal & communication skills.
• Commitment to excellence proven by an outstanding career track.

TECHNICAL SKILLS:

Operating Systems: HP - UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL, UNIX

Tools: TOAD,PL/SQL Developer, SQL Developer, Metasolv, CVS

Tuning Tools: EXPLAIN PLAN, SQL Optimizer

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

Lead PLSQL Developer

Responsibilities:

• Discuss with Business Users, BA’s and Architects to finalize requirements and scope of the project.
• Identifying and building the migration logic from source to landing using the in house designed data migration tool (Enterprise data migration solution tool).
• Creation of mapping documents required for data migration
• Worked on the SVN versioning Tool to deploy the code.
• Unit testing and Exception Handling
• Creation of database objects like tables, views, materialized views.
• Perform code review and make changes/improvements as required.
• Designed Database Triggers for audit and validation.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.,.
• Testing with system developers to ensure overall data quality, functionality and technical quality of deliverables.

Environment: Oracle 11g, SQL Developer, CVS, UNIX Shell Scripting

Confidential, Miami, FL

Lead PLSQL Developer

Responsibilities:

• Discuss with Business Users, BA’s and Architects to finalize requirements and scope of the project.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and DynamicSQL.
• Worked in the CVS versioning Tool to deploy the code.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error
• Creation of database objects like tables, views, materialized views, procedures and packages.
• Created PL/SQL stored procedures, functions and packages to meet the requirements.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Perform code review and make changes/improvements as required.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Designed Database Triggers for audit and validation.
• Worked extensively on Ref Cursor, External Tables and Plsql Collections.
• Built Reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.,.
• Developed back end interfaces using PL/SQL Packages, Stored procedures and Collections.
• Testing with system developers to ensure overall functionality and technical quality of deliverables.

Environment: Oracle 11g, SQL Developer, CVS, UNIX Shell Scripting

Confidential, Miami, FL

Senior PLSQL Developer

Responsibilities:

• Discuss with Business Users, BA’s and Architects to finalize requirements and scope of the project.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and DynamicSQL.
• Worked in the CVS versioning Tool to deploy the code.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error
• Creation of database objects like tables, views, materialized views, procedures and packages.
• Created PL/SQL stored procedures, functions and packages to meet the requirements.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Perform code review and make changes/improvements as required.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Designed Database Triggers for audit and validation.
• Worked extensively on Ref Cursor, External Tables and Plsql Collections.
• Built Reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.,.
• Developed back end interfaces using PL/SQL Packages, Stored procedures and Collections.
• Testing with system developers to ensure overall functionality and technical quality of deliverables.

Environment: Oracle 11g, SQL Developer, CVS, UNIX Shell Scripting

Confidential, New Jersey, NJ

Senior Tech Lead

Responsibilities:

• Database designing and managing data model.
• Preparing Pseudo code documents for complex business logic.
• Writing complex stored Procedures, functions and packages for entire business logic.
• Preparing deployment document for creating database objects.
• Maintaining high level of documentation by following proper naming standards to the entities and relationships.
• Worked as production support lead in maintaining Production databases and managing their growth, configuration and performance.
• Issue and error analysis using the log files.
• Maintain the production space to run all the jobs successfully.
• Working on analyzing Explain plans for various scripts and analyzing to improve the performance of the database applications and user reports.
• Generating on demand reports to the business users.
• Supporting four applications managing all the critical issues.
• Archival of historical date to maintain the database space.
• Involved in tuning and optimizing SQL queries
• Supporting to move the data from Production to lower environments for various testing cycles
• Worked on Access control by managing various database roles.
• Involved in designing the disaster recovery plans and successfully participated in the tests
• Communicating the business users with appropriate solutions in given SLA
• Suggesting the permanent fix to developer team by analyzing and fixing the issue in production environment.
• Good experience in handling all production support activities.
• Expertise in debugging and analyzing production issues.
• Interfering and effective communicating during outages with all down and upstream teams and business users
• Very good experience in handling severity one and two incidents.
• Expertise in handling disaster recovery and FWP tests as per the DB policy.
• Handling all weekend activities required to maintain the system in production environment.
• Maintaining the file system space to avoid any major incidents in production.
• Maintaining the database by doing the regular archival to avoid major incidents in production.
• Maintaining daily batch cycle and providing 24/7 support.
• Worked on 24/7 support carrying production mobile and supporting the business in off Hours during critical issues.

Environment: Oracle 11g/10g, Toad, Sun Solaris, IBM AIX, UNIX Shell Scripting

Confidential, Maine and New Hampshire

Oracle Consultant.

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Analyze data management to create the staging databases.
• Data validation after the loading the data to staging database
• Developed stored procedures to migrate the data from staging database to Metasolv.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries.
• Automated the user reports
• Developed and implemented complex data models and logical database designs.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Bug fixes after the production deployment
• Manual updates to avoid critical incidents
• Pushing the orders manually in production where the logic created was not in the discussion scope.
• Maintaining the production database and file system.
• Close monitoring of alert mechanism in production environment.
• Written the queries to generate the status reports for management activities.
• Preparing the build deployment document for bug fixes.

Environment: A 20-member team was involved in the development of the system on Windows using Informatica, Oracle 10G, Toad, Metasolv, ETL

Confidential

Responsibilities:

• Database designing and managing data model.
• Preparing Pseudo code documents for complex business logic.
• Writing complex stored Procedures, functions and packages for entire business logic.
• Preparing deployment document for creating database objects.
• Maintaining high level of documentation by following proper naming standards to the entities and relationships.
• Prepared KT documents, Run Books, updating Problem Logs for Autobahn Direct application.
• Approval, Implementation changes in accounts for Autobahn Web users.
• Checking for the successful completion of jobs mentioned in ABD Daily Status
• Report sent at a specified time.
• Monitoring EOD and ensuring that it runs smooth and finishes within the time frame on Production.
• Investigation and resolution of any batch issues.
• Resolving the various issues coming through a Problem Management Software called GIMS.
• Other application (Kondor, Money Markets) Monitoring & escalations.

A 20-member team was involved in the Maintenance of the system on UNIX using Toad.

Confidential

PLSQL Developer

Responsibilities:

• Database designing and managing data model.
• Preparing Pseudo code documents for complex business logic.
• Writing complex stored Procedures, functions and packages for entire business logic.
• Preparing deployment document for creating database objects.
• Maintaining high level of documentation by following proper naming standards to the entities and relationships.
• Creating Development and Test databases of Production database.
• A five-member team was involved in the development of the system on Windows using Java and Oracle.