SUMMARY:

• Databases systems using different programming Languages and Tools. Expertise in System Designing, planning, writing source code, Testing and Implementation of developing application. Energetic self - starter with excellent analytical and organizational skills. Excellent problem solving, organization and leadership skill.
• Developed Application programs under modular programming concept & client server base application using Oracle, PL/SQL, Web Logic, WebSphere MQ, VB, C.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 12c/11g/10g/9i Application Server, PRO*C, SQL*Loader, JAVA, C/C++, HTML, Visual Basic.
• Sound knowledge of Database design, Data Modeling. Data warehousing- ETL process. Knowledge of HTTP, TCP/IP functionality, web technology concepts.
• Very strong in PL/SQL, stored procedures/packages, constraints, cursors and views, triggers, Dynamic SQL, VPD client
• Writing test scripts. Creating SQL code for OLAP / OLTP application.
• Web, and client-server environments including Java Platform, Enterprise Edition (Java EE), Enterprise Java Bean (EJB), Java Server Pages (JSP) and Java database Connectivity (JDBC) technologies.

SKILLS:

Languages: SQL, PL/SQL, C/C++, Pro C, OLTP, Java, Java Script, JSP, Visual Basic; Shell Scripts - Unix & Linux;

RDBMS / Database: Oracle 12c/11g/10g/9i/8.x/7.x, SQL Server 7.x & 2000, MS-Access, DB2;

GUI Tools: Forms 4.5/6i, Reports 2.5/6i;

Tools: TOAD 12.7, SQL Navigator, Toad, SQL*Loader (Export/Import), Oracle, Informatica ETL, VB 6.0, .Net, Visual Studio.Net.

Reporting Tools: Crystal Report 8.0/8.5

Web/App Server: Confidential HTTP Server, Apache, Confidential web sphere 4.0/5.0,BEA / Oracle Web Logic.

Operating System: UNIX, Linux, Confidential Mainframe, WebSphere MQ, Confidential AIX 5.x, Windows 95/98/NT/XP/2000/Window 7 / Windows 8.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior Oracle Architect

Responsibilities:

• For new enhancement or modifying existing functionality: Designing, coding, Debugging, Testing for Oracle Pl/SQL Stored Procedures and Packages, Functions, VIEWs, . Triggers.
• Working for developer team during all phases of the SDLC- software development life cycle including functional, analysis & design, coding, testing & implementation.
• Creating Design for PL/SQL Packages, Function, Stored Procedure, Views, Triggers, Database Design. Prepare technical specification. Complete the design review.
• Application Performance & Tuning for SQL and PL/SQL code.
• Modify existing module Packages, Functions depend on Business Requirement.
• Working with database Partitioning, Materialize view.
• Running execution plan for analysis and improving performance using Hints.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts as per requirement. Schedule Cron tab as per requirement.
• Used SQL Loader utility conversion of flat file data into Oracle database.
• Experience on data extraction, Transportation and loading from various sources like Oracle SQL and flat files.
• Prepared Project Plan for developing global enterprise application. Create Test Plan and review with QA Team for the Product Test Environment.
• Debugging for Enterprise Application Oracle Web Logic with PL/SQL packages, functions.
• Worked for Statement Discloser Revamp Project for Client Reporting monthly Statement release. Planning and execution of product testing cycles, planning for project deployment.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, structure define, build, unit testing, systems integration and user acceptance testing.

Environment: Oracle 9i/10g/11g/12c, SQL*Plus, Oracle PL/SQL,SQL * Loader,, PRO * C, Linux, UNIX shell scripts,, CICS, XML, WebSphere MQ 8.0/ 7,5, Sybase, DB2, Team Track. Visual Basic 6.0, .Net, C/C++, SQL Navigator, HP-UX Windows XP Professional, Web logic, JAVA, J2EE, JSP, Team Track. SQL Developer. TOAD 12.7, WebSphere Application Server 8.0, Confidential WebSphere Message Broker, Autosys, Acqua Data Studio.

Confidential, New York / Charlotte, NC

Senior Oracle Architect/Developer

Responsibilities:

• Working for developer team during all phases of the SDLC- software development life cycle including functional, analysis & design, coding, testing & implementation.
• Creating Design for PL/SQL Packages, Function, Stored Procedure, Views, Triggers, Database Design. Prepare technical specification. Complete the design review.
• Application Performance & Tuning for SQL and PL/SQL code.
• Modify existing module Packages, Functions depend on Business Requirement.
• Working with database Partitioning, Materialize view.
• Running execution plan for analysis and improving performance using Hints.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts as per requirement. Schedule Cron tJob as per requirement.
• Used SQL Loader utility conversion of flat file data into Oracle database.
• Experience on data extraction, Transportation and loading from various sources like Oracle SQL and flat files.
• Prepared Project Plan for developing global enterprise application. Create Test Plan and review with QA Team for the Product Test Environment.
• Debugging for Enterprise Application Oracle Web Logic with PL/SQL packages, functions.
• Worked for Data Capture functionality for Enterprise release Settlement Extract for FTM application.
• Planning and execution of product testing cycles, planning for project deployment.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, structure define, build, unit testing, systems integration and user acceptance testing.

Environment: Oracle 9i/10g/11g/12c, SQL*Plus, Oracle PL/SQL,SQL * Loader,, PRO * C, Linux, UNIX shell scripts,, CICS, XML, WebSphere MQ 8.0/ 7,5, DB2, Team Track. Visual Basic 6.0, .Net, C/C++, SQL Navigator, HP-UX Windows XP Professional, Web logic, JAVA, J2EE, JSP, Team Track. SQL Developer. TOAD 12.7, WebSphere Application Server 8.0, Confidential WebSphere Message Broker.

Confidential, Parsippany, NJ

Senior Oracle Developer

Responsibilities:

• Working for WFN Application: For new enhancement or modifying existing functionality: Designing, coding, Debugging, Testing for Oracle Pl/SQL Stored Procedures and Packages, Functions, VIEWs,Triggers.
• Creating Design for Pl/sql Packages, Function, Stored Procedure, Views, Triggers, Database Design. Prepare technical specification. Complete the design review.
• Modify existing module Packages, Functions depend on Business Requirement.
• Creating new packages module for new pilot project migrating triggers code to new packages from current database.
• Working with database Partitioning, Materialize view.
• Application Performance & Tuning for Sql and PL/SQL code. AWR reports knowledge .
• Running execution plan for analysis and improving performance using Hints.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts as per requirement.
• Prepared Project Plan for developing global enterprise application. Create Test Plan and review with QA Team for the Product Test Environment.
• Working with Crystal Reports for WFN application. Research & investigation for the Report defects & fix defects.
• Planning and execution of product testing cycles, planning for project deployment.
• Experience on data extraction, Transportation and loading from various sources like Oracle SQL and flat files.

Environment: Oracle 9i/10g/11g/12c, SQL*Plus, Oracle PL/SQL,SQL * Loader,, PRO * C, Linux, UNIX shell scripts, Informatica, CICS, XML, Forms /Reports 6i, Visual Basic 6.0, .Net, C/C++, SQL Navigator 6.1, HP-UX Windows XP Professional, Web logic, JAVA, J2EE, JSP, Team Track. CVS version control. SQL Developer. TOAD 12.7, Apache Subversion (SVN), Rally |CA Agile Central tool .

Confidential, Parsippany, NJ

Senior Oracle Developer

Responsibilities:

• Designing /coding /Testing for Oracle Pl/SQL function, Stored Procedures and Packages for OLAP system.
• Creating Design for Pl/sql Packages, Function, Procedure and complete the design review.
• Modify existing module Packages, Functions depend on Business Requirement.
• Creating new packages module for new pilot project migrating triggers code to new packages from current database.
• Working with database Partitioning, Materialize view.
• Application Performance & Tuning for SQL and PL/SQL code.
• Running execution plan for analysis and improving performance using Hints.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts as per requirement.
• Prepared Project Plan for developing global enterprise application. Create Test Plan and review with QA Team for the Product Test Environment.
• Planning and execution of product testing cycles, planning for project deployment.
• Experience on data extraction,Transportation and loading from various sources like Oracle SQL and flat files.

Environment: Oracle 9i/10g/11g/12c, SQL*Plus, Oracle PL/SQL,SQL * Loader,, PRO * C, Linux, UNIX shell scripts, Informatica, CICS, XML, Forms /Reports 6i, Visual Basic 6.0, .Net, C/C++, SQL Navigator 6.1, HP-UX Windows XP Professional, BEA Web logic, Confidential Mainframe, J2EE, JSP, Team Track. CVS version control. SQL Developer

Confidential, Morristown, NJ / Wayne, NJ

Senior Oracle Developer

Responsibilities:

• Coordinated with users to define and design needs, developed technical solutions ensuring software integrity.
• Conduct System Analysis & Design sessions and created functional / technical design specification.
• Worked for developer team during all phases of the SDLC- software development life cycle including functional, analysis & design, coding, testing & implementation.
• Working for Marketing System Application - Incentive Administrative System ( IAS ). Based on new enhancement or modifying existing functionality: Designing /coding /Testing for Oracle Pl/SQL function, Stored Procedures and Packages.
• Creating Design for Pl/sql Packages, Function, Procedure and complete the design review.
• Create Test Plan and review with QA Team for the Product Test Environment.
• Execution String Test and product testing cycles for project deployment.
• Prepared Project Plan for developing global enterprise application.
• Planning and execution of product testing cycles, planning for project deployment
• Modify existing module Packages, Functions depend on Business Requirement for OLTP system.
• Design and developed primary database objects using referential integrity rules (tables, views, indexes).
• Application Performance & Tuning for Sql and PL/SQL code.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts and schedule Cron Job as per requirement.
• Used SQL Loader utility conversion of flat file data into Oracle database.
• Experience on data extraction, Transportation and loading from various sources like Oracle SQL and flat files.
• Debugging for Enterprise Application Oracle Web Logic with PL/SQL packages, functions.
• Worked for Data Capture functionality using web services.
• Designing for creating a Java Page flow controller for the Enterprise Application Tool Enhancement.
• Experience for creating scripts and maintaining Queue Managers, Queues, channels, processes, and other MQ Objects.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, structure define, build, unit testing, systems integration and user acceptance testing.
• Experience of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Working knowledge for XML schema & creating XML data using standard SQL function.
• Document all the scripts used in the project for easier maintenance.

Environment: Oracle 9i/10g/11g/12c, SQL*Plus, Oracle PL/SQL,SQL * Loader,, PRO * C, Linux, UNIX shell scripts, Informatica, CICS, XML, Forms /Reports 6i, Visual Basic 6.0, .Net, C/C++, SQL Navigator 6.1, HP-UX Windows XP Professional, Auto Sys, BEA Web logic, J2EE, JSP, Confidential Mainframe, WebSphere MQ 7,5, WebSphere MQ Workflow, DB2, Team Track.

Confidential, Atlanta, GA

Senior Oracle PL/SQL Developer

Responsibilities:

• Understanding the Customer requirements, analysis, design, development and implementation into the system.
• Designed and developed PL/SQL functions/ stored procedures/cursors/packages/triggers using PL/SQL.
• System analysis, Designing & Developing. Analyzing Data & Modifying Tables, enforcing constraint to table.
• Designed & Developed Manager’s Performance Activity Report for Individual/Team/Center level.
• Extensively used the advanced features of PL/SQL like collection types, varray & table functions, Bulk Collection, Dynamic SQL.
• Participated in performance fine-tuning of the queries using PL/SQL and SQL Plus
• Wrote Unix Shell Scripts to automate backend jobs, loading Non- Oracle data converting into the Oracle Database using SQL* loader utility.
• Application performance & Tuning using TKPROF generating report from Sql trace file. Table partitioning using range, hash partition.
• Also worked with production & maintenance support team.

Environment: Unix /Linux Os,PL/SQL, Oracle 10g (10.1.0.4), Oracle 10g/As RDBMS Oracle 9i, SQL * PLUS, Forms/Reports 9i, Toad 8.0, SQL * Loader, SQL Navigator, Confidential Aix 5.2, UNIX Shell Scripts, Sun Solaries 5.9, ETL tool Informica, Windows XP Professional, Visual Basic 6.0.

Confidential

Software Engineer - Oracle PL/SQL

Responsibilities:

• Researching and determining business and systems requirements to address a wide range of complex business issues.
• Designed Database using ORACLE 8i & system development under programming environment PL/SQL.
• Developed detail specification for the creation of new or modified programs, Form/ Report layouts and screen design & develop & execute unit Test Plan.
• System Analysis & designing, integration of different modules & finalized the project for real application.
• Created PL/SQL Database Triggers, Procedures, and Functions for Payroll Processing.
• Developed shell scripts to generate reports and transmission of files to global systems.
• Designed User Interface using Visual Basic’s controls - Text box, Label, List Box, Combo Box, Data Grid).
• Wrote PL/SQL Scripts, triggers, functions for Data Uploads.
• Wrote and validated functional specification, Prototypes, Design Documents
• Extensively involved in the process of trouble-shooting and application enhancements for performance.
• Advised on technical issues and developed technical and end-user operating instructions and procedures
• Developed reports using Crystal Reports.

Environment: UNIX Shell Scripts, Oracle 8i/9i, PL/SQL, SQL, Visual Basic 6.0, Crystal Reports 6/9, Windows 2000, UNIX. SQL Loader, SQL Navigator Ver 4.4, Confidential Mainframe, DB2, SCCS Version control.