Summary Over 14 years of Oracle database and application design, development and support experience on various U.S. Government projects, with extensive hands-on and in-depth DBA and Oracle development exposure. Proficient in varieties of technologies, including Oracle 9i/10g/11g, DB2, Access, Sybase, MS SQL Server, JDBC, Apache Web Server, Java, JavaScript, VB.NET, C , HTML, XML, Oracle Apex 3.1 , Oracle Portal 10.1.3 , Oracle Financial 11.0.3 , Oracle SOA Suite 11g .

Work Experience

Confidential

Senior Oracle Developer

• Designed, developed and deployed new phase IV for a DOJ Application on Oracle Application Express Apex . Completed all testing in test environment and maintained a list of changes to be deployed into production.
• Held meetings with client to discuss ongoing business requirements and provide feasible technical solutions.
• Upgraded Oracle from 10g to 11g and Worked with Database team to run all DDL scripts and troubleshoot errors during upgrade. In the process of testing current DOJ application on upgraded database server
• Prepare to develop the next release for system, i.e. Phase IV-a release. Business requirements have been collected and development work will start soon.
• Serve as production support specialist and address issues from phones and ticket.Traveled 4 days to client academy base for DOJ application all User training. Addressed questions during the training and fixed issues found during these sessions.

Confidential

Senior Oracle Database Administrator

• Provide ongoing production support to CDH databases and related applications including troubleshooting complex problems and setting up automation tasks.
• Perform various CDH database administration tasks like tuning, optimization, TP and DW database export / import, data backup and data purge per client requirements.
• Develop and maintain disaster recovery and backup plans for CDH databases.
• Develop and maintain various Oracle Apex reports for ESRS users including, but not limited to CDH Monthly Report, DRSN Total Count Report, Busy Hour Summary Report, Duration Summary Report and Call number Summary Report.
• Apply industry advanced replication techniques and perform appropriate analysis to assure replication job work as expected and address issues if any.
• Led migration efforts for CDH DW database to new service location. Exported data from old database server and imported them into new server. Created database link in the new environment to assure all replication jobs to work as expected for each TP. Conducted regression tests on all CDH reports, ESRS reports on the new server location.
• Monitor CDH DW data flow on daily basis to assure data accuracy and timely refresh.

Information Design Leader

Confidential

• Designed, developed and deployed new C3M Construction Contract Change Management System Application on Oracle Application Express Apex with Single Sign On SSO for Navy PEO. Led discussions about system requirement. Created high level system design, functional design, workflow and page layouts for overall application.
• Designed, developed and deployed AITS Action Item Tracking System . Participated in requirement analysis, design, development and final production launch. Promptly addressed outstanding issues during UAT User Accept Testing . Introduced new updates to system based on customer's new requirements.
• Designed, developed and deployed EVM Review and Analysis System EVM-RAS Application on Oracle Application Express Apex for Navy PEO. Participated requirement collection and validation efforts. Designed workflow and page layout. Developed pages, reports and processes. Created PL/SQL packages, functions and views. Built email notification for each milestone within the workflow.
• Designed and developed CVN21 Contract Data Deliverables Database CDRL Phase 2, Solicited feedbacks on phase 1 application and proposed phase 2 changes. Led requirement meetings to finalize phase 2 requirements. Designed new reports and new features for the application. Conducted frequent demos for clients, Trained end users on system usages during UAT. Provided ongoing production support.

Confidential

Senior Software Engineer III

• Designed and developed Getronics Security Solution GSS Application on Oracle Application Express Apex . Created pages, regions, PL/SQL packages, functions and views. Created tabs, buttons, items,
• processes and computations. Wrote PL/SQL scripts for branches. Utilized functions and views to create a four level dynamic tree presentation of underlying database data. Upgraded Oracle HTML DB 2.0 to Oracle Apex 3.0.1. Designed and developed GSS prototype on Oracle Portal. Worked as backup DBA.

Confidential

Senior Systems Analyst

• Federal Transit Administration National Transit Database NTD
• Designed and developed over 250 SQL procedures and functions within short period of time for NTD rule engines to validate reporters' data inputs for annual mass transportation reports. Developed batch files to deploy these SQL procedures and Oracle databases. Worked closely with DBA team to review table design and provide performance improvement. Created Crystal Reports for NTD annual reports.
• FHWA Information Technology Support Services FITSS
• Worked with FHWA/FITSS program project account team and developed Oracle Reports and Forms for DIMS Delphi Interface maintenance system and RASPS Rapid Approval and State Payment System projects. Section 508 compliance development. Wrote design specifications and testing plans for new Report and Form development.
• FHWA Environmental Document Tracking System EDTS
• Participated in requirements collection of the EDTS project conversion from an ASP application to .NET application. Designed and implemented various functions and grid display for Environmental Impact Statements EIS , Environmental Assessments EA and Cooperating Agency CA using .NET forms.

Confidential

Oracle Developer

• Standard Base Supply System SBSS conversion project for Air Force
• Converted project from UCS COBOL accessing a DMS 2200 database to Micro Focus COBOL accessing an Oracle 9i database. The conversion is done by applying Database Input/Output DBIO modules on Sun Solaris 5.8. Created 120 DBIO conversion modules, which fetch, insert, update and delete records in Oracle database.
• USDA Phytosanitary Certificate Issuance and Tracking project
• Responsible for developing Forms and Reports using the Oracle Developer 6i product against an Oracle 9i database on Sun Solaris 5.8.

Confidential

Oracle Developer

• Performed setup of Oracle Financial 11.0.3 three modules: General Ledger, Account Payables and Account Receivables in enterprise level. Developed new reports using tables, packages, triggers procedures on central database using Oracle Developer 2000 to meet internal customer needs. Performed
• customization in Oracle Financial Forms, Reports and database packages. Use Oracle Report flexibility for AP Check print and AR Invoice print in exactly the format end user needs. Maintained current running Oracle Financials and Oracle Distribution applications on Sun Solaris 2.6.