SUMMARY:

• Oracle PL/SQL Developer with Over 12 years of experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Support using Oracle SQL, PL/SQL on UNIX and Windows environment.
• Hands on experience working on Oracle 8i/9i/10g/11g databases on various platforms like SUN SOLARIS, UNIX, Red Hat Linux and Windows (98/XP/2000).
• Hands on experience in UNIX shell Scripts, Perl Scripts, Connect Direct NDM, MQ Series, and CDftp.
• Extensive experience in developing Database Objects, Triggers, stored procedures, Functions, Packages. Materialized views.
• Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning.
• Extensively worked on Collections, Bulk Binds, Bulk Collects and Table Partitioning.
• Excellent in writing Shell Scripts using (Sh, Ksh, Bsh) for database transactions and batch processing.
• Experience in performance tuning of using EXPLAIN PLAN, TKPROF, SQL Trace, and Oracle Hints to improve the performance.
• Proficient in using Oracle tools such TOAD, SQL Developer, SQL*PLUS and SQL Navigator.
• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import/Export, Data pump.
• Strong interpersonal, analytical and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation.
• Experienced in providing quality operational Support for Production Environments.
• Good knowledge of domestic/international equities trading, options and Fixed Income Trading.
• Good knowledge of Oracle Financials General Ledger module.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, MS SQL Server, MS Access

Operating Systems: Windows 95/98/XP/2000/NT 4.0, UNIX, Linux and Sun Solaris

Tools: PL/SQL Developer, SQL*Plus, SQL Loader, Toad 8.6.1, SQL Developer, IBM MQSeries - 5.1/5.3, Connect Direct NDM 3.3/3.6, Autosys

Reporting Tools: Oracle Report 6i

Tuning Tools: STATSPACK, TKPROF, EXPLAIN PLAN

Internet Technologies: ASP 2.0, JavaScript, HTML, XML, Coldfusion

Languages: C, C++, Java, SQL, PL\SQL, VB

Version Control: CVS, Clear Case, TFS

IT Concepts: Relational Database Management System, OOAD, Data Warehousing

PROFESSIONAL EXPERIENCE:

Confidential, Pennington NJ

Senior Oracle Developer

Responsibilities:

• Production Support and Develop automated job generates report of terminated FDW users
• Involved in interaction with the client to identify the functional requirements.
• Involved in the Analysis, Design, Coding, Testing, Implementation and Support of the applications.
• Involved in the development of packages, materialized views, procedures, functions which were used by the front end/back end system
• Tuned the queries using the oracle hints and creating the necessary indexes using EXPLAIN PLAN utility.
• Supported the front end system developed by ColdFusion, Java
• Wrote shell Script KSH, Perform job schedule on CRONTAB on Solaris 8/9 and generate reports
• Did various up gradations to the present application as per the customer request
• Wrote Complex Queries, Store Procedures/Functions, Views, Triggers and Synonyms to maintain the Business Rules.
• Extensively used SQL*LOADER to load data from flat files received from various facilities on daily basis into the database tables
• Worked with Offshore Team and fix the troubleshooting in DBMS and Applications to support the customers remotely
• Involved in migration of entire database from Oracle 9i to Oracle 11g.
• Involved in migration of AIX to Unix upgrade & Autosys upgrade from 8 to 11.0.

Environment: NET Framework v4.5, Oracle 11g, Sun Solaris, Shell Scripting (KSH), Perl Scripting, TOAD 12, TFS, Autosys

Confidential, NJ

Senior Oracle Developer

Responsibilities:

• Involved in interaction with the client to identify the functional requirements.
• Involved in the Analysis, Design, Coding, Testing, Implementation and Support of the applications.
• Involved in the development of packages, materialized views, procedures, functions which were used by the front end/back end system
• Tuned the queries using the oracle hints and creating the necessary indexes using EXPLAIN PLAN utility.
• Supported the front end system developed by ColdFusion, Java
• Wrote shell Script KSH, Perform job schedule on CRONTAB on Solaris 8/9 and generate reports
• Did various up gradations to the present application as per the customer request
• Wrote Complex Queries, Store Procedures/Functions, Views, Triggers and Synonyms to maintain the Business Rules.
• Extensively used SQL*LOADER to load data from flat files received from various facilities on daily basis into the database tables
• Worked with Offshore Team and fix the troubleshooting in DBMS and Applications to support the customers remotely
• Involved in migration of entire database from Oracle 9i to Oracle 10g.

Environment: Sun Solaris, Oracle10g, Shell Scripting (KSH), Perl Scripting, VSS, MQ Series, ConnectDirect FTP, ColdFusion, Java, Reports 6i, TOAD 8.6, PL/SQL Developer7.0 etc.

Confidential

Oracle Developer

Responsibilities:

• Analysed the business requirements of the project by studying the Business Requirement Specification document
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Worked on Perl scripts to transfer files using FTP to all the servers at one time.
• Maintained documentation of functional/technical designs and test cases to support development life cycle.
• Assisted QA team User Acceptance Testing performed against the modified applications.

Environment: Windows, Oracle 9i, Java, Perl Script, Visual Source Safe (VSS), SQL*Plus, PL/SQL Developer, Eclipse, SQL * Loader, TKProf.

Confidential

Oracle Developer

Responsibities:

• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Involved in creating stored procedures, functions, database triggers and packages using Dynamic SQL.
• Involved in design, implementation, testing and deployment of Forms using HTML, JavaScript, and ASP.
• Involved in generating new reports using Reports 6i and Report Templates.
• Enhanced the existing UNIX scripts to run batch processes, oracle background processes using JOBS & achieve better performance and throughput.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL *Loader.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Windows, Oracle 8i, HTML, CSS, JAVASCRIPT, XML, RATIONAL CLEARCASE etc.

Confidential

Base COM - Database Commercials

Responsibilities:

• Designed and developed database tables and procedures and triggers.
• Developed common library of functions used in retrieving user id, passwords and to execute sql scripts from UNIX shell scripts.
• Modified some UNIX shell scripts to use the common library of functions written to retrieve the user id, password and to execute sql scripts.
• Modified and tested the web forms in Interactive Keynote application based on the design documents.
• Performed User Acceptance testing for the Keynote and Interactive Keynote applications with modified modules in place.

Environment: Windows, Java, J2EE, ORACLE 8i.

Confidential

BSNL Telephone Billing Information System

Responsibilities:

• Had responsibilities in applying a multi-level security for application front end (online billing statements).
• Developed and source control of table creation scripts, database functions and triggers.
• Development of Web based programs using HTML, Java Script, and ASP
• Implementation, System testing and Acceptance testing.
• Development of reports and report generation scripts.

Environment: Windows, Java, J2EE, ORACLE 8i, HTML, JavaScript, ASP.

Confidential

Inventory Control

Responsibilities:

• Development and source control of table creation scripts, database functions and triggers.
• Development of Web based programs using HTML, Java Script, ASP
• Implementation, System testing and Acceptance testing.
• Development of reports and report generation scripts.

Environment: HTML, CSS, JAVASCRIPT, ASP, ORACLE 8i, Reports 6i