SUMMARY

• 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.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C/C++, Pro C, OLTP, OLAP, 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, Sybase;

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

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

.Reporting Tools: Crystal Report 8.0/8.5

Web/App Server: IBM HTTP Server, Apache, IBM web Sphere 4.0/5.0,BEA / Oracle Web Logic.

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

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Working for UI ( Unemployment Insurance ) CLAIMS Project for new Enhancement for SSI & RCC CLAIMS Application using Oracle 12c, SQL PL/SQL, SQL Developer.
• Working for new enhancement or implementing existing functionality: Functional, Designing, coding, Debugging, Testing for Oracle Pl/SQL Stored Procedures and Packages, Functions, Views, Triggers.
• Working in Developer team during all phases of the SDLC- Software Development Life Cycle including functional, analysis & design, coding, testing & implementation.
• Creating Design & coding for PL/SQL Packages, Function, Stored Procedure, Views, Triggers, Database Design. Prepare technical specification. Complete the design review.
• Designing / Coding PL/SQL Packages, Stored Procedures module to submit IVR (Interactive Voice Response) Claims.
• Working for designing & coding new Stored procedure for creating Batch Data for MQ calls to Loop system.
• Application Performance & Tuning for SQL and PL/SQL code. Running execution plan for analysis and improving performance using Hints, Bulk collection, Table Partitioning.
• Modify / rewriting existing module Packages, Functions for improving performance depend on Business Requirement.
• Working with Database Design, table Partitioning, View. Writing complex SQL queries to run extract report as per Business requirement.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts as per requirement.
• Data migration from current RCC & SSI system to new CLAIMS application.
• Create Test Plan and review with QA Team for the Product Test Environment. Running execution plan & researching issue for fixing the opened JIRA tickets.
• Debugging for Enterprise Application Oracle with PL/SQL Procedures, Function, Packages, Scripting.
• Creating application interface Worktable to capture Claimant’s data for CLAIMS submitting using Web.
• Planning and execution of product testing cycles & project deployment per Manager guidelines
• Presenting & reviewing Design Document with Team & Project Manager.
• Creating new Lookup code framework to manage & implement lookup code for entire CLAIMS application which can improve system performance & CLAIMS application will be more user friendly.
• Build models for testing & helping QA & Business user group for Testing functionality.
• Writing codes for validation & error tracking & Testing for the Project.
• Providing application support during System & UAT testing, fixing any production issue as it is reported.
• Creating documents for Unit testing. Code reviewing for developed code and promoting all the changes in the test environment.

Environment: Oracle 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, Control M, Net, C/C++, SQL Navigator, HP-UX Windows XP Professional, Web logic, Microsoft Teams. SQL Developer. JIRA Tool, Microsoft Teams.

Confidential

Senior Oracle Developer

Responsibilities:

• Working for WM ( Wealth Management ) Project for Client Onboarding project team. This Projects is managed & operating for US Confidential Markets & Global International Client supporting.
• Working for new enhancement or implementing existing functionality: Functional, 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. Running execution plan for analysis and improving performance using Hints, Bulk collection.
• Modify existing module Packages, Functions depend on Business Requirement.
• Working with Database Design, table Partitioning, Materialize view.
• Recommended improvements to existing application for performance and scalability requirements.
• Write UNIX/ Linux shell scripts as per requirement. Schedule Cron tab as per requirement.
• 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 with PL/SQL Procedures, Function, Packages, Scripting.
• Working for Client OnBoarding Project -COB for Implementation for Multi Business Partner KYC profile.
• 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/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, Control M, Net, C/C++, SQL Navigator, HP-UX Windows XP Professional, Web logic, JAVA, J2EE, JSP, Team Track. SQL Developer. TOAD 12.7, WebSphere Message Broker, Autosys, Acqua Data Studio. TortoiseGit version control. JIRA Tool.

Confidential

Senior Oracle Developer

Responsibilities:

• Working for PWM - Application (Private Wealth Management) for Client Reporting Project. This Projects is for US & Confidential International Client supporting.
• 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 Design, table Partitioning, Materialise 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 Disclose 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, Control M,Professional, Web logic, JAVA, J2EE, JSP, Team Track. SQL Developer. TOAD 12.7, WebSphere Application Server 8.0, IBM WebSphere Message Broker, Autosys, Acqua Data Studio, CVS Version control ..