SUMMARY:

• Over Nineteen (19) years of a broad background and experience with IT application development covering data analysis, requirements gathering, design, development, performance tuning, data modeling, testing, data masking and data conversion.
• Experience creating Stored Procedures, Functions, Packages, bulk collections, table and index partitioning, data modeling, create and manage database objects, data migration, use of Standard Packages and pre - defined Data types. Experience with SQL, SQL*PLUS, PL/SQL, Java, TOAD, Unix, Oracle SQL Developer, SVN, Oracle Enterprise Manager Grid control and Oracle Data Warehouse. Good knowledge with Oracle E-Business Suite (11i and R12), Oracle Developer Suite (Forms; Reports; Designer; Discoverer). Have experience in multitier architecture environment and documentation.
• Experience in business requirements gathering, data analysis, data mapping and dimensional data modeling.
• Hands-on Data Profiling, Data cleansing technologies, extract-transformation-loading (ETL) methods and testing strategies.
• Good knowledge and experience in using analytical functions and hierarchical queries.
• Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, Fact and Dimensional Tables.
• Expert knowledge in using data modelling tools like TOAD Modeler, SQL Developer Modeler and normalization techniques for database design.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Hands-on experience in creating database objects like tables, materialized views, Global Temporary tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Strong knowledge of Oracle 12c and 11g advance features for programming using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Expertise in SQL and PL/SQL tuning and query optimization using tools like EXPLAIN PLAN, SQL Trace, DBMS PROFILER, HPROF PROFILER, Hints, Table and Index partitioning .
• Strong knowledge in Oracle utilities like SQL*Loader and Oracle Data Pump utilities (EXPDP/IMPDP).
• Hand-on experience create database objects( tables, views, materialized views, views, sequences, synonyms, indexes, partitions and Global Temporary Tables) using client programs SQL*Plus, SQL Developer and Toad.
• Experience in retrieving data from external data Files and loaded into oracle tables using tools like SQL*Loader and External Tables.
• Strong knowledge in front-end development using Oracle Forms and Oracle Reports 11g, 10g, 9i, 6i, 4.5.
• Proficient in Microsoft Office and SVN tools.
• Ability to communicate effectively with both technical and management team members.

TECHNICAL SKILLS:

Software: Microsoft Office (Excel, Word, Power Point, and Access)

Operating Systems: UNIX, Windows 95/98/NT/2000/XP/7

Languages: Java, HTML, XML

Databases Environments: Oracle RDBMS 12c, 11g, 10g, 9i, 8i, 7)

Web Servers: Oracle Fusion Middleware 11g, Oracle Application Web Server (OAS), 9iAS, 10gAS

Tools: Oracle Forms (11g, 10g, 9i, 6i, 4.5), Oracle Reports (11g, 10g, 9i, 6i, 2.5), Oracle Financial (11i, R12), Oracle Data Warehouse Builder, SQL*Plus, PL/SQL, SQL, TOAD, Oracle Enterprise Manager Grid Control, PVCS, SVN, Oracle SQL Developer, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Senior Oracle PL/SQL Developer/DBA

Responsibilities:

• Design, develop and implement new and enhanced code for a custom PL/SQL application.
• Designed Physical and Logical Data model and Data flow diagrams using Oracle SQL Developer and Visio.
• Create installation scripts and migration scripts to move metadata along with data between schemas.
• Creating schema objects and implementing rules for data integrity
• Investigate data to isolate data values no longer used.
• Develop and execute SQL statements to validate data loaded.
• Create and tuning PL/SQL packages, stored procedures, functions, and triggers.
• Work with other technical staff and business analyst to discern business requirements and translate requirements into technical design documents.
• Perform Database remodeling and normalization.
• Communicate with DBA and other TECHNICAL members to resolve database issues.
• Support user acceptance testing

Environment: Oracle (12c, 11g), SQL, PL/SQL, SQLPLUS, TOAD, SVN, Oracle SQL Developer, Java, Eclipse, UNIX, Windows 7, Microsoft Office.

Confidential, Washington, DC

Senior Oracle PL/SQL Developer

Responsibilities:

• Create PL/SQL programming code using advanced concepts of Records, Collections, cursors and Dynamic SQL.
• Loading data from flat files into Oracle database and error capturing into log tables using PL/SQL and SQL*Loader. Transport data using tablespaces and Oracle Datapump expdp/impdp utilities.
• Developed stored procedures and packages to facilitate consistent data entry into the database using advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• 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.
• Collaborate with the project manager and technical team to ensure that designs are consistent with client expectations and overall project goals.
• Create tables, materialized views, views, partitions, indexes to improve performances.
• Involved in code review.
• Set up daily WEBEX SCRUM meeting in accordance with agile requirements.
• Create stored procedures to capture total counts at container, tray, bundle and piece levels.
• Create packages to pre-sort mails and track mails delivery.

Environment: Oracle (12c, 11g), SQL, PL/SQL, SQLPLUS, TOAD, Benthic, NotePad++, SVN, Oracle SQL Developer, TOAD, Bugzilla, UNIX, Windows 7, Microsoft Office, Visio.

Confidential, Reston, VA

Senior Oracle PL/SQL Developer

Responsibilities:

• Create PL/SQL stored procedures with bulk techniques and SQL scripts for data integration.
• Create installation scripts and migration scripts to move metadata along with data from the old schemas to the new schemas.
• Optimize various SQL and PL/SQL using Indexes, Hints, EXPLAIN PLAN and SQL Profiler.
• Work closely with client to identify and specify complex business requirements.
• Consult with business users in defining reporting requirements.
• Create package to process and validate RF Scan data.
• Work with System Architecture and other application developers to resolve issues.
• Test and validate developed procedures, functions and packages.
• Consult with business users in defining reporting requirements
• Assist in the preparation of all supporting documentations (Functional Specifications, System Documentation and User Documentation).
• 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 WEBEX SCRUM meeting in accordance with agile requirements.
• Support application and database development throughout the software lifecycle.

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

Confidential, Rosslyn, VA

Senior Oracle PL/SQL Developer

Responsibilities:

• Work closely with client and business users 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.
• Create packages, procedures, functions, and triggers as well as tables, dimensions, materialized views for data replication and indexes.
• Support application and database development throughout the software lifecycle.
• 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, TKPROF, 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, Oracle Warehouse Builder (10g, 11g), Windows (XP, 7), Microsoft Office.

Confidential, Gaithersburg, MD

Senior Oracle PL/SQL 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 new Oracle Forms and customize them
• Create Oracle Reports 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 Forms (10g, 6i), Oracle Reports (10g, 6i), Oracle SQL Developer, TOAD, Java, UNIX, SVN, Windows XP, Microsoft Office

Confidential, Herndon, VA

Senior Oracle PL/SQL 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 TKPROF, 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, Informatica, 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 in corporate 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 TKPROF 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 TKPROF 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, 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 DBMS OUTPUT, Forms Debugger, EXPLAIN PLAN and TKPROF.
• 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