SUMMARY:

• Over 17 years of IT experience in analysis, database design, development and testing of Oracle applications on Oracle Databases with strong knowledge in conceptual, logical and physical data;
• Proficient in the database design of tables, global temporary tables, external tables, constraints, indexes, procedures, functions, packages views, triggers, synonyms, sequences using SQL and PLSQL for Oracle database applications and have experience in working with high volume of data.
• Worked extensively on RDBMS: Oracle 11g/10g/9i/8i/8.0/7.x, SQL, PLSQL and Shell scripting
• Expertise in Performance Tuning of SQL, PLSQL using Oracle features like Global Temporary Tables, External Tables, Partitioning, Bulk fetch, Bulk bind, collections, Nested cursors, AUTONOMOUS TRANSACTION, Analytical Functions, Regular Expressions, WITH clause, LISTAGG, PIVOT functions, Ref Cursor, DML error logging, Oracle Hints.
• Strong experience in using oracle packages like UTL FILE, DBMS UTILITY, DBMS SMTP, DBMS OUTPUT, DBMS LOB, DBMS SQL, DMBS JOB to create various processes and utilities.
• Worked extensively on Oracle tools including Oracle Forms, Oracle Reports, SQL*Plus and SQL*Loader, import, export, Data Pump
• Developed many scalable, customizable database applications to transfer data electronically between multiple systems with ETL and auto - email capabilities.
• Working knowledge with Oracle Application Express (APEX) 4.2, 5.0
• Familiarity with T-SQL and Cassandra
• Developed utility to log the debug message based on the severity level and tracking the data changes using configuration.
• Strong experience in identifying and resolving the issues quickly and efficiently for production issues.
• Excellent self starter and team player with good communication, analytical, verbal and writing skills and strong commitment and dedication towards project goals and deliverables; willing to work in challenging environments in terms of learning new tools and applications or complex business requirement.
• Worked through the entire life cycle of the project under various responsibilities including collecting business requirements, defining functional specification, designing and developing, testing and supporting applications.

TECHNICAL SKILLS:

Back End: Oracle 11g/10g/9i/8i/7.x Database, Exposure to SQL Server.

Programming: ORACLE PLSQL, UNIX Shell Scripting, AWK, SED, HTML, Java, Python

Front End: Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i/ Oracle APEX 4.2,5.0

Middleware: Oracle 10g/9i Application Server, Tomcat 6.0 server.

Version Control: PVCS, Accurev

Job scheduling tool: Tivoli (IBM), Control-M

DW/BI Tool: Oracle Discoverer 10g/9i, Business Objects 5.0

ETL Tool:: Informatica Power Center 8.6

Third Party Tools: TOAD 8.6/7.5/7.0, PLSQL Developer 7.0, WRQ Reflection, SecureCRT, Citrix

Operating System: Windows Vista/XP/2003/2000/NT, HP UNIX 11.0 Server, AIX 5.1, Solaris 8.0/10

PROFESSIONAL EXPERIENCE:

Confidential,Monmouth Junction,NJ

Senior Oracle Developer

• Analyze business requirements and translate into efficient system design and implementation.
• Implement software applications using relational database, data modeling and financial business knowledge.
• Write modular packages, stored procedures and functions.
• Provide ongoing development and enhancements for all components of the Database
• Performance tuning of database application. Lead and participate in design reviews and SQL tuning.
• Develop robust solution for all aspects of application data within the database, including but not limited to data load, data management, data audit, recovery.
• Review current database design and provide expert recommendations on design.
• Ensure that solution developed is scalable, and does not compromise infrastructure security nor complicate current process.
• Follow Best Practice for Database Development by developing Confidential schema that is extensible and one that meets design for enterprise requirements of scalability, performance, resiliency, security, and manageability.

Environment: Oracle 11g/10g database, Oracle Forms 10g, Oracle Reports 10g, Unix K-Shell Scripting, TOAD 9.0, Solaris, Reflection, Win 7 Professional.

Confidential,Montvale,NJ

Senior Oracle Developer

• Analyze business requirements and translate into efficient system design and implementation.
• Create database objects including tables, views, constraints, indexes, triggers, procedures, functions and packages.
• Performance tuning of database application in various levels. Lead and participate in design reviews and SQL tuning.
• Develop robust solution for all aspects of application data within the database, including but not limited to data load, data management, data audit.
• Followed best practices in the application development to meet design for enterprise requirements of scalability, performance, resiliency, security, and manageability.

Environment: Oracle 11g/10g database, Oracle Forms 6i/10g, Oracle Reports 6i/10g, PLSQL Developer 8.0, Unix K-Shell Scripting, RETEK 10, SecureCRT, WRQ Reflection, PVCS, TOAD 9.6, AIX, Win XP Professional.

Confidential, Marlborough, MA

Senior Oracle & ETL Developer

• Developed Oracle Forms applications (Oracle Forms6i) for AIM propagation to propagate the Geneva account related data (party, reference, accounting parameters and portfolio).
• Created several Oracle reports 6i for AIM to generate the account setup discrepancy report between IDR and Geneva tables, list of active account and sub accounts, account propagation reject report
• Used PLSQL to propagating the account, security (investment), withholding tax related information from various sources into Geneva in real time using Oracle triggers, Oracle AQ and Oracle PLSQL Packages.
• Enhanced the performance of the SQL queries in many applications SQL using TKPROF, EXPLAIN PLAN, AUTOTRACE, hints like INDEX, FULL, ORDERED, DRIVING SITE, PARELLEL, etc
• Optimized PLSQL Code with Collections, Bulk processing, using Oracle Hints, REF Cursor, NOCOPY compiler directive, Nested Cursors, Associative Arrays, Indexed Tables, Sub-query factoring, Pinning the frequently used stored programs, MERGE and Oracle DBMS packages
• Wrote Perl scripts to extract the data from Oracle database in pipe-delimited format and load into Geneva.
• Used third party tools Accurev for version control, Humming Bird for UNIX access, Oracle Forms and Oracle Report compilations, IBM Tivoli for job control, TOAD for database activities.
• Created documents in each phase of the design, development, implementation and support such as Functional and Technical document, Test Cases, User Manual and Support documents.

Environment: Oracle 10g database, Oracle Forms 6i, Oracle Reports 6i, PLSQL Developer, Unix K-Shell Scripting, Perl, TOAD 9.0, Solaris, Win XP Professional.

Confidential,Fountain Valley, CA

Senior Oracle Database Developer

Responsibilities:

• Analyze business requirements and translate into efficient system design and implementation.
• Write modular packages, stored procedures and functions.
• Performance tuning of database application. Lead and participate in design reviews and SQL tuning.
• Develop robust solution for all aspects of application data within the database, including but not limited to data load, data management, data audit, recovery.
• Ensure that solution developed is scalable, and does not compromise infrastructure security nor complicate current process.

Environment: Oracle9i Database, DB Artisan, Win 2000, Microsoft Visio.

Confidential

Oracle Developer

• Worked on Oracle Forms and Reports conversion projects from UNIX environment to Windows environment for Argonaut Insurance Company (USA), Nu Skin (USA), Cardiac Care Network (Canada).
• Used Kumaran’s own Forms conversion tool called Forms Converter which converts Oracle Forms 3.0 in UNIX environment to Oracle Forms 4.0 in Windows environment and modified the converted Oracle Forms to accommodate the functionality and business logic of the legacy applications by changing the properties of the Forms, Blocks, Fields and other objects of the Forms and by writing additional PLSQL code and database triggers
• Used Kumaran’s own tool called Report Converter which converts Oracle Reports 1.0 in UNIX environment to Oracle Reports 3.0 in Windows environment and modified the converted Oracle Reports to match the result set with the legacy reports by changing the properties in frames, repeating frames, field properties, adding additional temporary queries, report triggers.
• Developed new screens using Oracle Forms 4.0 and reports using reports 3.0 for new modules.
• Used advanced SQL and PLSQL features to improve the performance of the queries and PLSQL procedures using indexes, collections, views, REF CURSOR.
• Used SQLCODE, SQLERRM functions in Error Handling to get the error messages accurately and MESSAGE function in Oracle Forms and SRW package in Oracle Reports for debugging.

Environment: Oracle 8i Database Enterprise Edition, Oracle Developer 2000, AIX 5.1 (UNIX), Win 2000.