PROFESSIONAL SUMMARY:

• 13+ years of IT experience in Oracle Database Technology in analysis, design, development, implementation, support and Application Maintenance of Business Applications.
• 11+ years of experience in development using PL/SQL language.
• 9+ years’ experience in Oracle Forms 6i and Oracle Reports 6i.
• 6+ years’ experience in Oracle Forms 10g and Oracle Reports 10g.
• 2+ years’ experience in Oracle Forms 11g and Oracle Reports 11g.
• 3+ years of experience with Agile/Scrum development methodology
• 6+ years of experience in developing Crystal Reports 8/11.
• 5+ years’ experience using Oracle Designer6i/2000.
• 4+ years of experience with Business Objects R2.
• 2+ years of experience with SAP Business Objects R3
• Expertise in Shell Scripting, Perl Scripting, Batch Processing,SQL Tuning.
• Extensively used Oracle Designer 6i, Erwin for data modeling.
• 6+ years of experience in Healthcare and property casualty subrogation applications.
• 4+ years of experience in developing financial applications.
• 4 Years of Experience in Project and process management applications.
• Expertise in data loading using Oracle SQL* Loader, UTL Files, SSIS
• Expertise in developing reports using Oracle Reports 6i/10g and Crystal Reports 8/11
• Expertise in handling various Administrative roles such as Managing and configuring servers using Central Management Console (CMC), Central Configuration Manager (CCM) and Infoview.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.
• In depth knowledge of Client - Server architecture for Oracle RDBMS.
• Expert in business requirements analysis for analyzing the user requirements.
• Result oriented team player with ability to learn, implement latest technologies and has strong inter-personnel skills.
• Have excellent communications skills with good analytical, logical and problem solving ability.

TECHNICAL SKILLS:

Business Intelligence: Business Objects R2/R3

Databases / RDBMS: Oracle 11g/10g/9i/8i., MS SQL Server 7.0/6.5, 2000, 2005, 2008

System Programming Languages: PL/SQL, VB 6.0, C, C++, C#, Java,Unix Shell Scripting, Perl Scripting.

Web Technologies & Scripting: XML, Korn Shell, ASP, JSP, VB Scripting.

Business Reporting Technologies: Oracle Reports 10g/9i/6i, Oracle Discoverer, Crystal reports 8/11

Data Modeling / Database Design: Oracle Designer 10g/6i, Microsoft - Visio, UML

UI Development: Oracle Forms 11g/10g/9i/6i,Developer 2000, Oracle Designer 6i, VisualStudio 6/2005/2008/2010

Web Servers: Oracle 11g/10g / 9i AS, Microsoft IIS

Operating Systems: Windows 2003/2008 Servers, Unix Server, Windows 95/98/2000 Professional/XP.

Version Control: PVCS,VSS,Version Manager

Office Suites: Microsoft Office 2007/2003/2000.

Technology Tools: Citrix 9.2, Winscp- FTP,Leach - FTP, PL/SQL Developer, Toad, SQL Loader. SQL Navigator, ERWIN

SDLC / Software Quality Assurance: Business Requirement Design (BRD), Unit Test Case Flow (UTC), System Test Case Flow (STC), System Integration Design (SID), Functional Design Model(FD), Technical Design Flow(TD), SEI-CMM Data Audits, ISO

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. Programmer Anlyst

Responsibilities:

• Developed and maintain screens using Oracle Forms 11g/Reports 11g.
• Developed pl/sql procedure to run as Batch process for generating weekly reports.
• Created some Batch files which would run daily basis in order to expunge records.
• Design and development of PL/SQL objects such as Packages, functions, procedures, triggers etc to process complex business requirements.
• Used tools like leech for FTP of files.
• Developed reusable PLL Libraries used by Oracle Forms bringing code efficiency leading to Better performance, standardization and code optimization.
• Participated in the weekly meetings to understand functional requirements.
• Provide production support to the application.
• Planned and implemented data access control and application security at screen level.
• Developed stored procedure using MS SQL Server 2005.
• Developed html reports and oracle Reports using reports 10g
• Migrated reports from Crystal reports 8 to Crystal reports XI.
• Developed reports for various clients using Crystal Report XI and configured with Bussiness Objects R2.
• Extensive analysis to design the Universes and assign them to respective domains.
• Webi Reports were created and deployed through Info View.
• Installed and Fixed maintenance issues for .Net application Self Service Investigation
• Created batch files, Perl Scripts and Shell Scripts for processing end of month schedules.
• Involved in Performance Tuning for Business critical processes by re-coding functions, procedures and packages and creating/adding indexes.
• Client User Interactions for escalations regarding production issues, data corrections, performance improvements and enhancements.
• Developed PL/SQL Procedure to provide standardized XML output data file for external applications across organization.
• Configured APOS definitions and burst PDF report to Business Objects using APOS tool.

Environment: Unix, Oracle 11g/10g, Forms 11g/10g, Reports 11g/10g, .NET, ASP, SQL Server 6.5/7. 2000/2005/2008, Crystal reports 8/11, Business Objects R2, SAP Business Objects 3.1, APOS bursting manager, Microsoft Visual studio 2005/2008.

Confidential, Rockville, MD

Sr. Programmer Analyst

Responsibilities:

• Developed and maintain screens using Oracle Forms 10g.
• Provide production support to the entire application.
• Developed reports using Reports 10g.
• Responsible for ensuring proper data analysis requirements are captured and documented to achieve the business objectives of the project.
• Developing and maintaining necessary database objects using PL/SQL which includes creating tables, functions, procedures, packages, table indexes and performance improvement methods.
• Developing and Deploying Form Interfaces and Reports required by the system using Forms 10g,Reports 10g and Application Server 10g using all important form triggers built in packages MDI application with multiple window and canvas interfaces, Dynamic LOV, Programmatically Record Group handling.
• Developing Necessary forms Libraries like PLL’s, OLB’s and Form Templates.
• Worked with DBA in implementation of physical data model and monitoring Table spaces for their growth and liaising with DBA for more storage allocation.
• Created partitioned tables for manageability and scalability of the application.
• Performance Tuning, Business critical processes by re-coding and creating/adding indexes. Used Oracle hints for performance optimization.
• Involved in Production Support and data quality investigations.
• Creating views for checking the integrity of Data. Also creating materialized views for data on remote tables.
• Monitoring DBMS Jobs for their success and failures and taking necessary action.
• Testing and taking measures for maximum performance.

Environment: Windows, Oracle 10g, Forms 10g, Reports 10g, Oracle webutil, MS SQL Server

Confidential, KY

Sr. Programmer Anlyst

Responsibilities:

• Developed and maintain screens using Oracle Forms 11g/Reports 11g.
• Design and development of PL/SQL objects such as Packages, functions, procedures, triggers etc to process complex business requirements.
• Used tools like leech for FTP of files.
• Developed reusable PLL Libraries used by Oracle Forms bringing code efficiency leading to Better performance, standardization and code optimization.
• Developing Necessary forms Libraries like PLL’s, OLB’s and Form Templates.
• Participated in the weekly meetings to understand functional requirements.
• Provide production support to the application.
• Planned and implemented data access control and application security at screen level.
• Developed stored procedure using MS SQL Server 2005.
• Developed html reports and oracle Reports using reports 10g
• Installed and Fixed maintenance issues for .Net application Self Service Investigation
• Created batch files, Perl Scripts for processing end of month schedules.
• Involved in Performance Tuning for Business critical processes by re-coding functions, procedures and packages and creating/adding indexes.
• Client User Interactions for escalations regarding production issues, data corrections, performance improvements and enhancements.
• Created Shell script for wrapping Oracle Procedural calls. Also created shell scripts for data validation, data transfer.

Environment: Unix, Oracle 11g/10g, Forms 11g/10g, Reports 11g/10g, .NET, ASP, SQL Server 6.5/7. 2000/2005/2008, Crystal reports 8/11, Business Objects R2, SAP Business Objects 3.1, APOS bursting manager, Microsoft Visual studio 2005/2008.

Confidential, Louisville, KY

Sr. Programmer Analyst

Responsibilities:

• Developed and maintain screens using Oracle Forms 10g.
• Developed reports using Reports 10g.
• Responsible for ensuring proper data analysis requirements are captured and documented to achieve the business objectives of the project.
• Developing and maintaining necessary database objects using PL/SQL which includes creating tables, functions, procedures, packages, table indexes and performance improvement methods.
• Developing Necessary forms Libraries like PLL’s, OLB’s and Form Templates.
• Created some Batch files which would run daily basis in order to expunge records.
• Involved in developing an application for enhancing the security for accessing the forms in the application.
• Used UNIX to make compile and implement the procedures, packages, forms that have been modified and developed into different databases.
• Created partitioned tables for manageability and scalability of the application.
• Performance Tuning, Business critical processes by re-coding and creating/adding indexes. Used Oracle hints for performance optimization.
• Involved in Production Support and data quality investigations.
• Monitoring DBMS Jobs for their success and failures and taking necessary action.
• Created Shell script for wrapping Oracle Procedural calls. Also created shell scripts for data validation, data transfer.
• Testing and taking measures for maximum performance.

Environment: Windows, Oracle 10g, Forms 10g, Reports 10g, Oracle webutil, Unix, MS SQL Server

Confidential

Sr. Software Developer

Responsibilities:

• Development and maintenance of PL/SQL Stored Program units - Packages, triggers.
• Conversion of existing screens from Forms 6i to Forms 10g.
• Developed and maintain screens using Oracle Forms 10g.
• Provide production support to the entire application.
• Planned and implemented data access control and application security at screen level.
• Developed reports using Reports 10g.
• Responsible for ensuring proper data analysis requirements are captured and documented to achieve the business objectives of the project.
• Developing and maintaining necessary database objects using PL/SQL which includes creating tables, functions, procedures, packages, table indexes and performance improvement methods.
• Developing and Deploying Form Interfaces and Reports required by the system using Forms 6i/10g,Reports 6i/10g and Application Server 10g using all important form triggers built in packages MDI application with multiple window and canvas interfaces, Dynamic LOV, Programmatically Record Group handling.
• Developing Necessary forms Libraries like PLL’s, OLB’s and Form Templates.
• Created partitioned tables for manageability and scalability of the application.
• Testing and taking measures for maximum performance.

Environment: Windows, Oracle 10g, Forms 10g, Reports 10g, Oracle webutil, Crystal reports XI, Unix, MS SQL Server

Confidential

Team Lead/ Sr. Developer

Responsibilities:

• User requirements analysis and design of screens.
• Developed the database design using Designer 6i and integrated to the other modules.
• Developed and modified Oracle packages, procedures, functions and triggers.
• Calling the sql and report files from shell scripts.
• Maintenance and debugging of existing financial modules.
• Involved in integration of finance application with other modules Human resources and Payroll.
• Developed pl/sql procedure to run as Batch process for generating weekly reports.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures using Pl/Sql Developer.
• Extensively involved in coding of the procedures, triggers, and making use of built in packages and libraries while developing Forms.
• Modified existing stored procedures, functions and triggers using PL/Sql Developer.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Performance tuning of the queries using optimizer hints and creating new Indexes.
• Used tools like leech for FTP of files.
• Developed reusable PLL Libraries used by Oracle Forms bringing code efficiency leading to better performance, standardization and code optimization

Environment: Unix, Oracle 9i, Oracle Forms 6i, Reports 6i

Confidential

Sr. Software Developer

Responsibilities:

• Design and Developed Application screens.
• Developed database Design using Oracle Designer 6i.
• Responsible for the Integration of the entire Modules.
• Developed many packages, procedures, functions and triggers
• Developed Deviation Scripts between testing and Development databases using TOAD.
• Used Shell scripts to automate Oracle script execution.
• Involved in successfully upgrade of database from Oracle 8i to 9i.
• Optimizing, and fine-tuning the Oracle Reports for efficiency.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
• Tuned SQL by using Explain Plan, Indexing and Hints.

Environment: Oracle 9i, SQL*Loader, Oracle 9i Application Server, Forms 6i /Reports 6i, PL/SQL, Oracle Designer 6i, Unix

Confidential

Software Developer Engineer

Responsibilities:

• Designed & Developed using Forms 6i, Reports 6i
• Used Oracle Designer for data modeling
• Developed many database triggers and instead of triggers
• Involved in Client meetings to gather requirements.
• Extraction of data from different flat files into Oracle Database using SQL* Loader.
• Gather Business rules from the end users that are to be incorporated into the system.
• Developed PL/SQL Procedures, Functions and Triggers for insert, update, and delete transactions.
• Changed existing logic within the packages for optimum Performance.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Used Shell scripts to automate Oracle script execution.
• Involved in successfully upgrade of database from Oracle 8i to 9i.
• Optimizing, and fine-tuning the Oracle Reports for efficiency.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
• Tuned SQL by using Explain Plan, Indexing and Hints.

Environment: Win2000, Oracle forms 6i, Reports 6i, Oracle 8i/9i, Oracle Designer 6i,SQL*Loader, Unix, Crystal Reports

Confidential

Software Developer Engineer

Responsibilities:

• Developed PL/SQL Stored Program units - Functional, Exception Handling Packages, Triggers.
• Developed Screens and reports using Oracle Forms 6i and Oracle Reports 6i
• Wrote SQL scripts for batch processing of data
• Loading data into tables from legacy system using control files and staging tables.
• Scheduling the jobs using process Scheduler
• Involved in back end development and maintaining of oracle database.
• Created tables, indexes, views and other objects using SQL.
• Developed and implemented Stored Procedures, Packages, Functions, and Database Triggers.
• Created indexes to improved database performance.
• Involved in tuning and applying the SQL statements and PL/SQL processes.
• 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: Oracle 9i, SQL*Loader, Oracle 9i Application Server, Forms 6i /Reports 6i, PL/SQL, TOAD

Confidential

Software Developer Engineer

Responsibilities:

• Developed Screens and reports using Oracle Forms 6i and Oracle Reports 6i
• Written extensive PL/SQL Programs as per the functional flow and business requirement of the application.
• Loaded data into Oracle instance by maintaining the data integrity and consistency using control files, SQL* Loader.
• Created tables, indexes, views and other objects using SQL.
• Developed and implemented Stored Procedures, Packages, Functions, and Database Triggers.
• Created indexes to improved database performance.
• Involved in tuning and applying the SQL statements and PL/SQL processes.

Environment: Oracle 8i, Designer 2000, Forms 6i, Reports 6i, SQL* Loader, TOAD, Windows 95 and Unix