SUMMARY

• Over 10+ years of Computer Programming experience mainly as Database Applications Programmer, which includes Software Development and Implementation in Oracle 11g/9i/8i/7.x/COBOL and as Forms Developer (Forms 6i/9i/10g/11g).
• Experienced in development of Database server side programming using Oracle PL/SQL viz. Stored Procedures, Database Triggers, Packages, Development of materialized views, clustered tables, indexes and table creations.
• Experienced in Development and Implementation phases of complete Software Development Life Cycle.
• Experienced in providing production support to the financial companies using Oracle 11g.
• Translating business requirements into creation of database objects: Tables, Indexes, Constraints, Triggers, Stored Procedures and Materialized Views
• Expertise in development of application in relational databases, client server environment, and web - enabled environment using Oracle 8i/9i/11g. and Oracle APEX (Oracle HTML DB)
• Proficient in Logical and Physical Design of Databases using Toad Data Modeler.
• Experienced in UNIX Shell Scripting
• Knowledge of Cost Based and Rule based query optimization techniques.

TECHNICAL SKILLS

Languages: PL/SQL, JAVA, SQL, C, C++, HTML, XML, Perl, .NET, C#, COBOL

Databases: Oracle /11g/10g/9i/ 8i/ 8/ 7.3, MS Access, FoxPro

Development Tools: SQL Developer, Discoverer, Project Builder, SQL Navigator, SQL Loader, Toad Data Modeler, Crystal Reports, Clipper

Front-end Tools: Forms Builder & Reports Builder (6i/9i)

Applications: Oracle APEX (Oracle HTML DB), FTP, MS Office, Outlook Express

Environment: Windows 2000/XP/Vista, MS-DOS, Windows 2003 Server, UNIXOracle Application Server (OAS), Forms & Reports Server

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Oracle PL/SQL Developer

RESPONSIBILITIES:

• Develop the PL/SQL procedures, packages, triggers etc
• Modify the Oracle module functionality fix the bugs with Oracle 10g
• Development of third party liabilities using Oracle 11g
• Work with Business Analyst/Functional leads in Analysis and Designing Applications for any defect fixes or change orders
• Provide support to test team in ITF/UAT test cycles
• Attend standup meetings to provide status
• Responsible for writing PLSQL program units per defined coding standards
• Responsible for checking the performance of Queries/PLSQL batch jobs and make corrective actions.
• Participate in code peer reviews and ensure the code written complies with the company standards and policies
• Work with the GUI team for writing queries and integrating PLSQL program units
• Tuned the SQL queries to improve performance using ETL Tools develop for large databases
• Wrote Oracle SQL complex queries as per requirement of the users
• Provide technical support to fix bugs in the programs using SQL Developer
• Development of complex functionality for the Medicaid Project of DMHM
• Generate PL/SQL code for Auto Respond letters for the MERP Projects
• Strong Analysis skills and experience working with users to gather requirement and suggest solutions
• Experience with import/export of big data from files

ENVIRONMENT: PL/SQL, Oracle 11g, SQL*Plus, SQL Loader, Toad, PL SQL DeveloperSQL Developer

Confidential, Irvine, CA

Sr Oracle PL/SQL Developer/Production Support

RESPONSIBILITIES:

• Modify the PL/SQL procedures, packages, triggers etc
• To load data using SQL Loader facility
• Identify solutions to open issues/problems
• Creating PL/SQL scripts/tools (complex stored procedures, triggers, and functions) to resolve system issues, fall outs.
• Modify the Oracle module functionality fix the bugs with Oracle 10g
• Modify the Oracle Forms and Reports using Forms 9g
• Tuned the SQL queries to improve performance using ETL Tools
• Wrote Oracle SQL complex queries as per requirement of the users
• Provide technical support to fix bugs in the programs using SQL Developer
• Wrote UNIX scripting programs required for the technical requirements

ENVIRONMENT: Windows XP Pro., UNIX, PL/SQL, Oracle 9g/10g, SQL*Plus, Forms/Reports 6i, SQL Loader, Shell Scripting, Toad, PL SQL Developer, PVCS, SQL Developer

Confidential

Sr Oracle PL/SQL Developer/Production Support

RESPONSIBILITIES:

• Creating PL/SQL scripts/tools (complex stored procedures, triggers, and functions) to resolve system issues, fall outs.
• Hands on design and development experience in complex PL/SQL packages, functions, stored procedures, triggers.
• Identify solutions to open issues/problems.
• Knowledge in developing database solutions using Optimized SQL and tuning existing SQLs
• Retrieve data from various sources and prepares data for analysis and Verify accuracy of data
• Compiles and prepares reports and occasionally graphs and charts of data developed by analyzing situations and/or data from which answers can be obtained
• To load data using SQL Loader facility
• Modify the Oracle module functionality fix the bugs
• Write queries and stored procedures in SQL, export data into excel or csv files, review for quality and data integrity, and send them to internal clients or external agencies.
• Modify the Oracle Forms and Reports using Form 10g/11g in Oracle 10g
• Tuned the SQL queries to improve performance
• Wrote Oracle SQL complex queries as per requirement of the users using Toad
• Provide technical support to fix bugs in the programs
• Wrote UNIX scripting programs required for the technical requirements
• Experience with data modeling in Erwin
• Extensive use of the SQL Developer tools to operate in Oracle 10g/11g

ENVIRONMENT: Windows XP Pro., UNIX, PL/SQL, Oracle 10g/11g, SQL*Plus, Forms/Reports 10g/11g, SQL Loader, Shell Scripting, Toad, SQL Developer, Toad

Confidential

Intermediate Developer

RESPONSIBILITIES:

• Develop PL/SQL procedures, packages, Triggers and views
• To load the data using SQL Loader facility.
• Wrote and modified the complex C programs using the Oracle database and module functionalities using Oracle 10g/11g.
• Wrote complex stored procedures, functions, types, packages and triggers to facilitate the functionality for various modules.
• Wrote database triggers for automatic updating the tables and views.
• Tuned SQL queries to improve performance
• Provide technical support to fix the bugs in the program
• Testing, Integration System Tests, documenting for the project.
• Worked with reports using APEX 4.1 and SQL Developer

ENVIRONMENT: Windows XP Pro., Solaris, UNIX, Window Server 2003, PL/SQL, Oracle 10g/11g, SQL*Plus, PL SQL Developer, Project Builder, SQL Loader, C, Shell Scripting, Pro*C, APEX 4.1, SQL Developer

Confidential

Accounts and Audits

RESPONSIBILITIES:

• Process, analyses, transferring funds from client accounts.
• Process mortgage advances, payments, worked with debits and credits, balancing entries etc
• Experience in Oracle 9i/10g

ENVIRONMENT: Oracle 9i/10g, Windows XP/NT