PROFESSIONAL SUMMARY:

• Over 7 years of experience in developing and implementing database applications and solutions as ORACLE PL/SQL DEVELOPER on variety of UNIX (HP and AIX), Windows XP platforms with Oracle 10g/11g.
• Worked on Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and used TOAD in many development projects.
• Extensively involved in developing multiple applications with Pro*C and PL/SQL.
• Expertise in finding Memory leaks and handling pointers in C.
• Great Experience in Shell scripting and used CRONTAB for scheduling jobs regularly.
• Expertise in creating Oracle objects like Tables, Synonyms, Triggers, Indexes, Views, Functions and Stored Procedures.
• Proficient in advance features of Oracle for PL/SQL programming like using Cursor variables, Ref. cursors, VARRAYS, Nested tables and Dynamic SQL.
• Extreme experience in using SQL*Loader for loading data into single table and multiple tables.
• Experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
• Extreme Use of exception handling methods along with pragma exception init in order to associate our own created exception names.
• Experience in creating Global Temporary Tables.
• Advanced Knowledge of transferring data between different servers using Export/Import and Data Pump utilities like expdp/impdp.
• Extensive experience in developing application with ETL (Extraction, Transformation, Loading)
• Experience in adhering and implementing CMMi Standards and Methodologies.
• Documentation included the preparation of High Level Design Documents, Low Level Design Documents during the Requirement Analysis phase.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Agile transformation certified and extensive experience with working in Agile model.
• Self - motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines. Able to work independently and as team member.
• Well-rounded, team player, fast learner and open-minded individual whose philosophy to any work at hand is hard work, commitment, and excellence.
• Proactive and self started who can handle the project independently without much supervision. Have good experience on customer training and project documentation.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, Pro*C, C, C++ and VB.NET

Database Management Systems: Oracle, Microsoft SQL Server 2008

Operating Systems: UNIX (HP, IBM AIX 5.3/6.1), Windows OS (XP, 2008 R2)

Scripting: UNIX Korn Shell scripting

Version Control System: Tortoise SVN, VSS, Rational Team Concert (RTC)

Development Tools/ Environment: Oracle SQL Developer, PL/SQL Developer, SQL* Plus, Toad, Oracle Forms, Win SCP, Putty, Visual Studio 2008, Microsoft Office 2007/2010, VM Ware

Utilities: SQL*Loader, Export / Import, Expdp / Impdp, FTP, SFTP

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

Senior Developer

Responsibilities:

• Involved in understanding and developing new requirements from different state tax agencies and providing them a feasible solution.
• Wrote stored Procedures, Functions, Packages and Triggers.
• Used SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.
• Involved in the development of database objects.
• Created and dealing with Database links for communication between different databases.
• Wrote Complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Creating new interfaces in Oracle Forms as per client requirements as well as maintaining existing interfaces.
• Extensively working in Pro*C to develop new requirement from tax agencies and to maintain existing legacy code.
• Good exposure in creating and maintaining UNIX Shell scripts.
• Thoroughly involved code reviews, follow ups and daily stand-ups to closely monitor the development through Agile methodology.
• Creating and managing repositories in RTC.

Environment: PL/SQL, UNIX Shell Scripting, Pro*C, Oracle Forms, RTC.

Confidential, NYC, NY

Senior Developer

Responsibilities:

• Involved in Requirement gathering & Analysis of new enhancements with clients.
• Played major role in 32 bit (AIX 5.3) to 64 bit (AIX 6.1) OS Migration.
• Involved in Production Support during deployment.
• Involved in the development of database objects.
• Involved in Oracle User creation & assigning Roles & Privileges.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Used the pragma Exception Init to name the system exceptions that are raised by the program.
• Writing SQL queries for data retrieval involving complex join conditions.
• Wrote stored Procedures, Functions, Packages and Triggers.
• Involved in writing Cursors and REF Cursor.
• Used Impdp/Expdp (Data Pump) utilities of Oracle.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Extensively worked in Pro*C for developing business logic and creating daemons.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Involved in Creating and Maintaining of users in UNIX.
• Thoroughly involved in unit testing, creating unit test documents and involve in peer reviews, code reviews, follow ups and status updates to closely monitor the development throughout its life cycle.
• Managing source code, Front End as well as Back End.
• Creating and managing repositories in SVN.

Environment: PL/SQL, UNIX Shell Scripting, Pro*C.

Confidential

Senior Developer 

Environment: PL/SQL, UNIX Shell Scripting, Pro*C.

Responsibilities:

• Extensively worked with client for requirements gathering and designing right from the initial phase of the project.
• Utilized SQL developer tool in developing all back end database interfaces.
• Developed user documentation for all the application modules.
• Implemented core business logic in Pro*C.
• Developed complex Packages, Stored Procedures and Functions to implement business logic.
• Worked extensively on exception handling to trouble-shoot PL/SQL code.
• Created Indexes and Sequences for faster retrieval of the customer information and enhance the database performance.
• Data loading from flat files into to database tables using SQL* loader.
• Used CRONTAB to run PL/SQL Scripts and stored procedures at a particular date and time.
• Generated DDL statements for creation of new database objects like tables, views, indexes, triggers, stored procedures, roles and granting privileges.
• Involved in performance tuning with EXPLAIN PLAN and Indexes.
• Implemented Join conditions, group by functions, correlated sub queries.
• Created PL/SQL procedures and functions necessary for validation of transaction records into interface tables.
• Involved in technical documentation, and writing test plan.

Environment: PL/SQL, UNIX Shell Scripting, Pro*C.

Senior Developer

Confidential

Responsibilities:

• Involved in Creation of tables, Join conditions, nested queries, views, sequences, synonyms for the business application development.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Created dynamic SQL to support dynamic nature of front to end applications.
• Developed PL/SQL code (packages, stored procedures, functions and database triggers) for Extraction, Transformation and Loading (ETL) processes.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used the CRONTAB in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Developed multiple interfaces with the help of Pro*C.

Environment: PL/SQL, UNIX Shell Scripting, Pro*C, C, C++, Kettle.

Confidential

Developer

Responsibilities:

• Involved in the production support and solved critical issues.
• Extensively worked on cursors for manipulating row-by-row for oracle database.
• Used debugger to test the mapping and fixed the bugs.
• Developed shell scripts for batch processing
• Involved in Creation of tables, Join conditions, nested queries, views, sequences, synonyms for the business application development.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Wrote complex queries to generate reports as per client request as a part of production support.

Environment: PL/SQL, UNIX Shell Scripting, Pro*C, J2EE, Tomcat 5.9.9.

Developer

Confidential

Responsibilities:

• Extensively involved in writing SQL queries (Sub queries and Join conditions) and PL/SQL programming.
• Involved in creating and maintaining of existing database objects like Tables, Views, Functions and Stored Procedures.
• Worked on user-defined and also the system defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT.
• Used automation of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in various UNIX platforms.
• Used set operators in PL/SQL like unions, union all, intersect and minus.
• Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients
• Extensively worked in Pro*C used for developing business logic.
• Worked in different shift timings to support Production environment.

Environment: PL/SQL, UNIX Shell Scripting, Pro*C, Oracle Forms.

Developer

Confidential

Responsibilities:

• Involved in writing SQL queries to perform DML operations
• Worked in Pro*C to fix existing bugs and enhancing the application
• Involved in writing shell scripts for batch processing and database transactions
• Used CRONTAB to automate daily activities like performing SFTP, archiving daily logs etc
• Worked in Production environment in all possible shifts
• Involved in Integration testing, System testing and Implementation

Environment: PL/SQL, UNIX Shell Scripting, Pro*C, Oracle Forms.