SUMMARY

• I have over ten years of Computer Programming experience mainly in Database Applications Development and Implementation using Oracle 10g/11g/12c Java.
• Experienced in Database server side programming using Oracle PL/SQL viz. Stored Procedures, Database Triggers, Packages, Development of materialized views, clustered tables, indexes and table creations. Also experienced in Oracle Forms Development (Forms 6/6i/10g/11g).
• Experienced in Development and Implementation phases of complete Software Development Life Cycle (Oracle 11g)
• Translating business requirements into creation of database objects: Tables, Indexes, Constraints, Triggers, Stored Procedures and Materialized Views
• Have experience in development of applications in relational databases, client server environment, and web - enabled environment using Oracle 8i/9i/11g/12c. and Oracle APEX
• 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,Pro C, HTML, XML

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

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/7/8, MS-DOS, Windows 2008/2012 Server, UNIXOracle Application Server (OAS), Forms & Reports Server

PROFESSIONAL EXPERIENCE

Confidential, Gaithersburg, MD

Sr. Oracle Developer

RESPONSIBILITIES:

• Develop the PL/SQL procedures, packages, triggers etc
• Modify the Oracle module’s functionality by fixing the bugs using Oracle 11g
• Work with Business Analysts/Functional Leads in Analysis of Applications for any defect fixes or change orders
• Responsible for writing PL/SQL 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
• To Write Oracle SQL complex queries as per requirement of the users
• Provide technical support to fix bugs in the programs using SQL Developer
• Dealing with import/export of big data from files
• Worked in Oracle 11g/12 and XMLon reports.

ENVIRONMENT: PL/SQL, Oracle 11g/12, SQL*Plus, Toad, PL SQL Developer, XML

Confidential, Denver CO

Sr. Software Engineer

RESPONSIBILITIES:

• Develop the PL/SQL procedures, packages, triggers etc
• Modify the Oracle module’s functionality by fixing the bugs using Oracle 10g
• Development of third party liabilities using Oracle 11g
• Work with Business Analysts/Functional Leads in Analysis of Applications for any defect fixes or change orders
• Attend standup meetings to provide status
• Responsible for writing PL/SQL 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
• To Write Oracle SQL complex queries as per requirement of the users
• Provide technical support to fix bugs in the programs using SQL Developer
• Strong Analysis skills and experience working with users to gather requirement and suggest solutions
• Dealing with import/export of big data from files

ENVIRONMENT: PL/SQL, Oracle 11g, SQL*Plus, Java, Pro C, SQL Loader, Toad, PL SQL Developer.

Confidential, Baltimore, MD

Mid Level Oracle

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
• Developed Servlets and back-end java classes using WebSphere Application server.
• 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
• Created complex SQL and used JDBC connectivity to access the database.
• Responsible for writing PL/SQL 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 developed for large databases 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
• Development of complex functionality for the Medicaid Project of DMHM
• Generate PL/SQL code for Auto Respond letters for the MERP Projects
• Developed strong analytical skills by working with users to gather requirement and suggesting solutions
• Experience with import/export of big data from files

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

Confidential, Irvine, CA

Sr. Oracle PL/SQL Developer

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

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/11gSQL*Plus, PL SQL Developer, Project Builder, SQL Loader, C, Shell Scripting, Pro*CAPEX 4.1, SQL Developer

Confidential

Oracle Programmer/Analyst

RESPONSIBILITIES:

• Analysis of Customer specifications and custom design of applications
• Successfully implementing designs in new/existing applications using Oracle PL/SQL.
• Data migration from MS Access to Oracle 8i. Loaded data into multiple tables using Oracle 8i/9i
• Wrote PL/SQL codes for maintaining the invoices of truckloads application.
• Maintain the driver’s records in tables using Oracle 8i.
• Involved in writing SQL queries (sub queries & Join conditions).
• Used different joins, sub-query, and nested query in SQL query for reports.
• Involved in coding and designing of the Report Module using APEX
• Extensive use of SQL Developer

ENVIRONMENT: Oracle 8/9i, MS Access, PL/SQL, Report 6i, Form 6i, HTML, Windows 2000, APEX, SQL Developer