PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior Oracle Developer

Responsibilities:

• Develop and maintain complex PL/SQL stored procedures and functions this include collections and cursors.
• Loading data from flat files into Oracle database and error capturing into log tables using PL/SQL and SQL*Loader.
• Tuning SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time
• Involved in drawing process flow diagrams and data flow diagrams to help the system users in the future.
• Develop and revise program code based on clearly defined requirements.
• Prepares documentation of program development, modify updating invoice summary error counts process and mail presort process.
• Test all functionality of applications based on test plan (unit Test).
• Collaborate with the project manager and technical team to ensure that designs are consistent with client expectations and overall project goals.
• Create tables with partitions, indexes to improve performances details include partition key, partition name and partition status.
• Set up daily Confidential SCRUM meeting in accordance with Agile requirements.
• Create stored procedures to capture total counts at container, tray, bundle and piece levels.

Environment: Oracle 11G, SQL, PL/SQL, SQLPLUS, TOAD, Benthic, NotePad++, SVN, Oracle SQL Developer, TOAD, Bugzilla, UNIX, Windows 7, Microsoft Office.

Confidential, Reston, VA

Senior Oracle Developer

Responsibilities:

• Install and configure Oracle Weblogic Service including forms and reports.
• Convert Oracle Forms 6i and Reports 6i to Oracle Forms 11g and Oracle Reports 11g. Install Java and SVN.
• Set up daily Confidential SCRUM meeting in accordance with Agile requirements.
• Work closely with client to identify and specify complex business requirements.
• Create packages, procedures, functions, and triggers as well as tables, materialized views and indexes.
• Support application and database development throughout the software lifecycle.
• Consult with business users in defining reporting requirements
• Prepare and assist in the preparation of all supporting documentations (Functional Specifications, System Documentation and User Documentation).
• Test and validate developed procedures.
• Work with System Architecturer and other application developers to resolve issues.
• Create PL/SQL stored procedures with bulk techniques and SQL scripts for data integration.
• Optimize various SQL and PL/SQL using Indexes, Hints, EXPLAIN PLAN and SQL Profiler

Environment: Oracle 11G, Oracle Enterprise Manager Grid Control, Oracle Forms (11g, 6i), Oracle Reports (11g, 6i), JDeveloper, SQL, PL/SQL, SQLPLUS, SQL Developer, TOAD, Java, SVN, Oracle SQL Developer, TOAD, UNIX, Windows 7, Microsoft Office.

Confidential, Rosslyn, VA

Senior Oracle Developer

Responsibilities:

• Work closely with client and business users to identify and specify complex business requirements.
• Create integration interfaces.
• Provide technical expertise to junior team members and consult with senior application developers to resolve performance issues and test new and existing code.
• Create packages, procedures, functions, and triggers as well as tables, dimensions, materialized views and indexes.
• Support application and database development throughout the software lifecycle.
• Consult with business users in defining reporting requirements
• Map the source data to target data model and formulate associated business logic.
• Collaborate with the project manager to ensure that designs are consistent with client expectations and overall project goals.
• Take data from an operational system and move it into data warehouse for analysis.
• Test and validate the developed procedures.
• Work with database administrator and application developers to resolve issues.
• Develop SQL queries to review data and provide complex reports to business users.
• Optimize various SQL and PL/SQL using Indexes, Hints, EXPLAIN PLAN, AWR, Confidential, SQL Profiler and SQL Trace.

Environment: Oracle (10G, 11G), Oracle Enterprise Manager Grid Control, SQL, PL/SQL, SQLPLUS, Oracle SQL Developer, TOAD, Java, SVN, Oracle SQL Developer, TOAD, UNIX, Data Warehouse Builder (10g, 11g), Windows (XP, 7), Microsoft Office.

Confidential, Gaithersburg, MD

Senior Oracle Developer

Responsibilities:

• Understanding the functional requirements of the client, Analysis and resolve the issues through functional walkthroughs.
• Working with packages.
• Provide technical expertise to junior team members and consult with senior application developers to resolve performance issues and test new and existing code.
• Create packages, procedures, functions, and triggers as well as tables, dimensions, materialized views and indexes.
• Support application and database development throughout the software lifecycle.
• Map the source data to target data model and formulate associated business logic.
• Developing custom interfaces between various Applications for integration.
• Prepare user guides and procedure documentation
• Create Oracle Discoverer reports to retrieve data based on business requirements.
• Used SQL*Loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Collecting Business requirement and Leveraging with Oracle Applications
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Supported all go - live activities and post-production troubleshooting.

Environment: Oracle E-Business Suite (11i, R12), Oracle (10G, 11G), SQL, PL/SQL, SQLPLUS, Oracle Discoverer (10g, 11g), Oracle SQL Developer, TOAD, Java, UNIX, Data Warehouse, SVN, Windows XP, Microsoft Office

Confidential, Herndon, VA

Senior Oracle Developer

Responsibilities:

• Work closely with client to identify and specify complex business requirements.
• Provide technical expertise to junior team members and consult with senior application developers to resolve performance issues and test new and existing code.
• Write cube queries, and analytical functions.
• Create packages, procedures, functions, and triggers as well as tables, materialized views with constraints and indexes.
• Support application and database development throughout the software lifecycle.
• Define integrity constraints to enforce business rules associated with the database to prevent entry of invalid information into tables.
• Consult with business users in defining reporting requirements
• Map the source data to target data model and formulate associated business logic.
• Collaborate with the project manager to ensure that designs are consistent with client expectations and overall project goals.
• Take data from an operational system and move it into data warehouse for analysis.
• Loading data using SQL*Loader and Stored procedures.
• Test and validate the developed procedures.
• Create PL/SQL stored procedures with bulk techniques and SQL scripts for data integration (SQL*Loader and External Tables).
• Develop SQL queries to review data and provide complex reports to business users.
• Involved in the LOGICAL & PHYSICAL MODELING of the schema.
• Optimize various SQL and PL/SQL using Indexes, Hints, EXPLAIN PLAN Confidential, SQL Profiler and SQL Trace.
• Identify and capture data that has been added, updated or removed and make change data available to applications and individuals.

Environment: Oracle 10g, Oracle Reports 10g, Oracle Designer 10g, SQL, PL/SQL. SQLPLUS, Java, Unix, Data Warehouse, TOAD, HTML, Oracle SQL Developer, PVCS, Windows XP, Microsoft Office

Confidential, DC

Senior Oracle Developer

Responsibilities:

• Work closely with users and managers to understand the requirements.
• Perform database tables partitioning using range partition to improve performance.
• Create procedures to update the internal structures to reflect the newly loaded Data and create materialized views.
• Communicate technical issues and progress to the project manager.
• Develop Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules.
• Work with Dynamic SQL , Global Temporary Tables, collections and bulk binding techniques to improve performance.
• Work with DBA to resolve database issues.
• Rewrite SQL statements to avoid problems such as unnecessary full-table scans by adding query hints and make sure tables have appropriate indexes.
• Analyze the execution plans and performance of the SQL statements, using EXPLAIN PLAN, SQL Trace facility with Confidential and Oracle Trace.
• Load data using SQL*Loader (both conventional and direct path loading) and Stored procedures.
• Identify performance bottlenecks in PL/SQL subprograms using a profiler API.
• Create database triggers, procedures, Functions, Packages to provide backend security and data consistency.
• Define, develops, document and maintains PL/SQL objects (procedures, packages, triggers)
• Design and implement batch processes using PL/SQL.
• Create complex SQL queries with joins, subqueries and correlated subqueries.
• Import data from flat files from legacy system into database table using SQL * Loader.
• Perform unit testing to ensure that user requirements are met.
• Analyze, design and develop various Oracle Forms and Oracle Discoverer reports.
• Created database triggers to implement and enforce data integrity and security.

Environment: Oracle 10g, Oracle Designer 10g, Oracle Forms 10g, Oracle Discoverer 10g, Oracle Reports 10g, SQL, PL/SQL, Java, TOAD, HTML, Windows XP, UNIX, Microsoft Office.

Confidential, DC

Senior Oracle Technical-Functional Consultant

Responsibilities:

• Work hand in hand with Oracle functional team, supervisors, managers and operational personnel in defining business systems requirements.
• Loaded Legacy Journals data into GL interface table using SQL*Loader and run Journal Import Program.
• Identified, isolated and resolved malfunctions related to software.
• Customize Oracle Applications with the CUSTOM Library and Forms Personalization.
• Created and updated system documentation and design specifications.
• Customized the Sales Tax Listing Report and created AR Invoice Report in Receivables and them as a Concurrent Program for front-end users in Oracle Applications.
• Develop PL/SQL packages, procedures, functions in order to implement client specific business logic.
• Use SQL*Loader Import Utility to populate Oracle Projects interface table then run Transaction Import to move data into Oracle Projects tables.
• Developed a program to import invoices into Oracle Payables from three different sources and registered as a single concurrent program.
• Assisted in testing prior to release into production, validated data to comply with defined requirements and follow up with issues resolutions.
• Developed and executed plans for deploying the applications into production.
• Analyze the execution plans and performance of the SQL statements, using EXPLAIN PLAN, SQL Trace facility with Confidential and Oracle Trace.
• Created PL/SQL Package/Procedures to validate the data and entered into the Interface Tables and finally imported the data into the Base tables using Auto Invoice Import program.
• Developed a control file using SQL*Loader to import the data from flat files into Staging tables
• Import Standard Invoices for Oracle Receivables from the Legacy System into the Oracle Applications.

Environment: Oracle 9i, Oracle Financial 11i (GL; AR; AP; PO; FA; PA), Oracle Designer 6i, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer 4i, SQL, PL/SQL, SQL Navigator, HTML, PVCS, Java, TOAD, Windows XP, UNIX, Microsoft Office.

Confidential, DC

Senior Oracle Developer

Responsibilities:

• Worked directly with users to understand how the current system is used and identify the enhancements that will provide the greatest benefit to the department.
• Worked hand in hand with the DBA to create and design database based upon business and user requirements.
• Developed standards documentation for the new system based on user inputs and observations.
• Developed user interfaces using Oracle Forms to support the mortgage types exist within Confidential .
• Created reports using Oracle Reports to display mortgage details based on mortgage type and location.
• Created PL/SQL packages to process, validate and approve each mortgage category.
• Troubleshoot and resolve technical problems (Oracle Forms, Reports and PL/SQL codes).
• Developed forms and reports to allow management to produce month end reports in different layouts.
• Develop technical and user documentations.
• Optimized SQL queries, PL/SQL code and tuning for better performance.
• Performed testing to ensure system operates according to defined business rules.
• Created reference tables using Oracle Designer.
• Deployed forms, reports packages, stored procedures and functions in production.
• Linked Oracle products and non Oracle products.

Environment: Oracle 8i, Oracle Forms, Oracle Reports, Oracle Designer, SQL, PL/SQL. Unix, TOAD, Oracle SQL Developer, Windows 98, Microsoft Office

Confidential, Washington, DC

Senior Oracle Developer

Responsibilities:

• Meet with military personnel, carriers and end user, collecting change requirements and converting into technical specifications.
• Design, create and maintain Oracle Forms & Reports for unit, non unit and carriers schedule reporting.
• Troubleshoot performance issues and bugs within packages, forms, and reports using Confidential, Forms Debugger, EXPLAIN PLAN and Confidential .
• Generate SQL and PL/SQL scripts to install, create and drop Booking process connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Create documentation for all aspects of the project including training the end users.
• Create Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links and roles.
• Write the functional design requirements and performed custom development for the scheduling and non unit distribution modules.
• Write PL/SQL packages to calculate Low Cost and High Cost Carriers information and determining the compliance with the Department of Defense rules.
• Create SQL*Loader script file for reading data from text file and loading into oracle table.
• Work hand in hand with the Help Desk technicians to resolve network problems and hardware when needed.
• Troubleshoot and resolve applications functional and technical issues.
• Work hand in hand with the DBA to resolve database issues and make change on the database objects based on user needs.
• Use revision control system to keep track of the changes.

Environment: Oracle 7.x, Oracle Forms 4.5, Oracle Reports 2.5, Oracle Designer 2000, HTML, PL/SQL, PVCS, Oracle PL/SQL Developer, SQL, Unix, Windows NT