PROFESSIONAL SUMMARY:

• 11 years of experience in Information Technology with Extensive knowledge and work Experience in design, development, testing and Implementation of Database applications in Client/Server environment using Oracle Database and PL/SQL Programming.
• Expertise in Implementation of Business Applications using Oracle technologies in Financial, Insurance and Distribution domains.
• Over 11+ years of work experience in SQL, PL/SQL Programming, Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, Oracle Discoverer Reports 9i/6i, Crystal Reports 2008/XI and Business View Manager.
• Strong working experience in Oracle 9i/10g/11g database programming using PL/SQL (Stored Procedures, Functions, Packages, and Triggers) and standard built - in Oracle packages in UNIX and Windows environment.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle(SDLC).
• Expert in Application Debugging, Troubleshooting and programming using database tools like TOAD 9.6, PLSQL Developer, SQL Developer and Edit plus.
• Experienced in developing Data Conversions/Data Migration from Legacy System of various sources (flat files, xml, excel, Oracle, Non Oracle) to Oracle system Using SQL*Loader, UTL FILE, XML Parsing.
• Proficient in SQL, PL/SQL, Query Optimization using optimizer hints, Explain plan, SQL trace, Auto trace, TKPROF.
• Worked with Very Large Databases, multi-Terabyte databases. Worked with Dynamic SQL, Global Temporary Tables- Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect as performance improvement process.
• Good exposure toDBAroutine tasks; can be self-servingDBA, managing users, roles, privileges, schema and objects, developingPL/SQL triggersfor user access audit. Experience in data loading, export/import, backup/restore, session monitoring, providing technical support to Oracle users, Oracle Client installation, and network environment setup.
• Experience in editing and scheduling shell scripts (ksh,bash) and batch scripts.
• Experienced in designing the logical and physical Data Modeling/ER-Modeling using SQL Developer Datamodeler in both OLAP and OLTP applications.
• Experience in writing Program Specification documents (PS), Test Plans and defining Test Cases based on Business requirements.
• Actively involved in Performance Tuning, Error handling, Product Development & Support on various Platforms.
• Involved in 24/7 Production Database Support, and also involved in Database Performance Monitoring
• Worked with version control tools like VSS, CVS, ClearCase.
• Experience in waterfall, Agile / SCRUM development methodologies.
• Knowledge in SOA, SOAP based web services using JAX-WS, JAX-RPC, and Spring framework.

TECHNICAL SKILLS:

Oracle Tools: Oracle Reports 10g/9i/6i/3.0, Forms 9i/6i/5.0 & Oracle Discoverer Reports 9i/6i, SQL Developer Data modeler, Oracle JDeveloper 11g/10g, TOAD, PL/SQL Developer, SQL Navigator, SQL*Plus, SQL*Loader, UTL FILE, SQL Developer, EXPLAIN PLAN, OEM

Development: Oracle Database 11g/10g/9i/8i, PL/SQL, SQL Query Tuning

Programming languages: SQL, PL/SQL,HTML, XML, JAVA, Shellscripts(ksh,bash)

Tools: /Utilities/IDE:: EditPlus, Notepad++, Crystal Reports 2008/XI, Case Complete2012, JIRA, Business View Manager

J2EE Technologies: JDBC, Servlet, JSP, JavaScript

Operating systems: UNIX (HP-UX,Sun Solaris and Linux),DOS, Windows NT/2000/XP/Vista/7

Databases: Oracle 8i, 9i, 10g,11g

Bugtrackers: JIRA, Elix, Bugtrk

Version control systems: Microsoft Visual Source Safe (VSS), CVS, IBM ClearCase

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle 11g RAC, SQL, PL/SQL, Java, J2EE, JBoss, Web Services, JSP, CSS, JavaScript, IBM ClearCase, Doc1 Reports, Shell Script, Toad 10.6, JIRA.

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed scripts to load data from legacy files (text, ebcdic, xml, excel...etc) to staging tables using SQL*Loader, XML Parsing.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in the continuous enhancements and fixing of production problems.
• Preparing and maintaing release scripts and release notes for client deliverables.
• Deploying the db objects into db server as per release notes.
• Deploying the reports into the server by executing shell scripts.
• Exporting and import schemas from servers (dev/test).
• Tablespace management.
• Created/Managed of Users, Roles & Privileges.

Confidential, Washington, DC

Oracle Developer

Environment: Oracle 11g RAC, Oracle Forms and Reports 11g/10g, PL/SQL, SQL*Plus, Shell Script, Toad 10.6, HP-UX 11.0, CVS, JIRA, Case Complete 2012

Responsibilities:

• Worked with business analysts to develop business, technical and functional requirements.
• Developing and Customizing Oracle Forms as per the client requirement
• Developed and Customizing New Reports (Simple reports, letter reports, complex reports like finance reports and matrix reports etc..)
• Created database objects such as Stored Procedures, Functions, Packages, Collections, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links and user-defined data types in Oracle according to the business requirement.
• Involved in writing complex SQL Queries to implement the business requirements and extracting data for monthly, quarterly and yearly reports.
• Involved in the development, testing, UAT Sessions, Production Support phases of the project.
• Developed Test Plans and test cases for Oracle Forms, Reports and database scripts.
• Requirement gathering from the client and preparing FSD and TSD for reports.
• Report Design analysis and functional testing the output of the report.
• Upgraded Oracle Forms and Reports from 10g to 11g.
• Tracking the issues in the CC2012 and specifying the solution.
• Release Notes preparation for Reports, Forms and db scripts deployment.
• Planning and tracking project deliverables to the Project Manager & participate in project governance meeting / steering committees when necessary.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system.
• Develop batch processes for financial reporting applications and modules using Korn shell scripts on Oracle database.

Confidential, NY

Oracle Developer

Environment: Oracle 10g RAC, Oracle Forms 10g,Oracle Reports 10g, XML/BI Publisher, SQL, PL/SQL, TOAD and SQL* Loader, VSS.

Responsibilities:

• Developing and Customizing Oracle Reports and Oracle Forms as per the client requirement
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Designed/Coded/implemented automatic error handling and recovery processes for table data loads.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Fine tuned PLSQL programs and SQL Queries for the maximum efficiency in various schemas across databases using oracle Hints, Explain Plans, Tkprof method and Trace sessions for Cost Based Optimization (CBO).
• Created PL/SQL programs to dump the data from staging tables into Base Table.
• Implemented SQL * Loader Control files to load the data files into the Staging tables.
• Created validation programs to verify data in the staging tables.
• Developed and Modified Existing Packages, Stored Procedures, Stored Functions and Cursors.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Optimized, tuned and monitored the procedures using Explain Plan, Indexing and Hints based on the throughput of the results.
• TKPROF to accurately assess the efficiency of the SQL statements and application runs.
• Designed technical user documents for the future enhancement of the product.
• Installed and configured Oracle development and testing server.
• Monthly refresh of the development and test environment using the Import/Export.
• Created/Managed of Users, Roles & Privileges.
• Created inbound and outbound shell scripts and updated the scripts as per the requirement

Confidential

Oracle Developer

Environment: Oracle 10g/9i, Oracle Reports 9i/6i, Oracle Forms 9i/6i, PL/SQL Developer, SQL PLUS, Edit Plus, Windows 2000/NT.

Responsibilities:

• Participated in the project to upgrade the Oracle Forms and Reports from 6i to 9i and Customized oracle forms and reports according to the client design specifications and change requests.
• Created database objects such as Stored Procedures, Functions, Packages, Collections, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links and user-defined data types in Oracle according to the business requirement.
• Created records, tables, collections(nested tables and varrays) for improving query performance by reducing context switching
• Involved in writing complex SQL Queries to implement the business requirements and extracting data for monthly, quarterly and yearly reports.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
• Worked with built-in PL/SQL packages like DBMS OUTPUT, DBMS UTILITY, and DBMS JOB.
• Involved in handling Exceptions through PL/SQL Blocks.
• Tuned batch jobs and other daily/monthly reports/downloads.
• Used PL/SQL Developer tool for creating, modifying and debugging Oracle objects (procedures, functions and packages).
• Writing the Program Specification documents (PS), Unit Test Document (UT) and Integration Testing Document (IT).
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Developed and modified several UNIX shell scripts, and managed important CRONTAB jobs.

Confidential

Software Engineer

Environment: Oracle 9i/8i, Shell scripting, Oracle Forms 6i and Reports 6i, TOAD, SQL PLUS, Sun Solaris, Edit Plus, CVS

Responsibilities:

• Assigned as Oracle Developer and involved in Philplans life insurance project development using PREMIA insurance product.
• Customized various Forms, Reports and Oracle objects (Procedures, functions and packages) based on the client requirements.
• Design & Development of PL/SQL code with quality (i.e. readable, performable and supportable) on Oracle 9i database, delivering the functionality detailed in the technical specifications.
• Developing and Customizing Oracle Reports and Oracle Forms as per the client requirement.
• Wrote Complex PL/SQL coding using Collections, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links.
• Created materialized views, Inline views and normal views where business requirements needed and helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Developed control files for SQL*Loader and written PL/SQL programs for loading and validating the data into the tables from the Legacy system as part of ETL process.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Designed and Developed physical and logical database schemas using SQL Developer Datamodeler.
• Used TOAD tool for creating, modifying and debugging Oracle objects (procedures, functions and packages).
• Requirement gathering from the client and preparing FSD and TSD for reports.
• Perform root cause analysis and prepare incident reports
• Track and verify all escalated issues till closure.
• Involving in the deployment of Oracle DB scripts in to server.
• Writing the Test Analyze and Fix (TAF) documents.