Skills Summary
Ten years of Oracle DBA/Developer experience with a proven record of delivering
products ahead of schedule. A consistent high performer with an ability to work
independently or a in team environment. Proficient with developing and creating
oracle database. Maintain Web based and Client/Server government operation
systems. Knowledge of financial management systems, army readiness systems,
inventory and retail systems using full life cycle development. Technical
experiences including: PL/SQL, Oracle 10g/9i/6i, Toad, Oracle Forms and Reports,
Ewrin, WinSCP, Putty, Unix, Java, HTML, JavaScript, SQL Loader. Effective and
efficient analytical and Accounting skills. Consistently perform backup and
recovery, SQL tunning, and documentation.
Certification Oracle Certified Professional (OCP)
Certified Public Accountant (CPA)
Technical Skills
Database: Oracle 10g/9i/8i/6i, ERD, Data Modeling, Normalization, RAC, Data
Guard
Oracle Utilities: SQL*Plus,SQL Loader, Oracle Form 10g/9i/6i/5/4.5,Oracle Report
10g/9i 6i/3/2.5
Programming: SQL, PL/SQL, Java/J2EE, Unix Shell Script, HTML, JavaScript, XML
Applications: ETL, DW, Discoverer 10g, PVCS, ClearCase, MS Office Word, Excel,
Power Point. SSO/OID,
Oracle ERP (EBS), SOA/BPel, Business Activity Management (BAM), Oracle Web
Service
Management (OWSM)
Developmental Experience
New Vision Engineering Group, Fall Church, VA
DBA/Developer/Sr. Software Engineer 11/07 – Present
• work on site at Department of Defense at Alexandria, VA
• Perform database backup and recovery using Toad, Oracle Enterprise Manager,
and data pump.
• Monitor database by using Toad, Oracle Enterprise Manager in RAC and Data
Guard environment.
• Handle database performance tuning by using Toad, Oracle Enterprise
Manager.
• Develop database and application with system development life cycle, data
modeling, Normalization,
scripting, testing, procedure/package, and documentation.
• Write PL/SQL package to implement business logic and processing needs for
forty applications
• Create views, tables, index, sequence, procedure, function of new schema for
new applications
• Write, modify, and run baseline scripts and data migrations scripts for
applications, including grant privileges
• Tune SQL for performance requirement by working with front end developers,
business analyst, project
Managers, and team members
• Access, retrieve and manipulate data from RAC oracle and data warehouse
• Use Toad, VSS, Erwin Designer to develop database and packages and version
control
• Provide production support by trouble shooting reported errors with report
team members
Global Computer Enterprises, Inc./ US Secret Service (Reston, VA)
Sr. Oracle Developer/DBA 5/07 – 9/07
• Applied patches to oracle application server (AS), operating systems,
database
• Upgraded applications, server, and databases to maintain operation functions
and integraty
• Installed and configured applications and databases to set up servers and
databases
• Provided production support for Oracle Purchase Order and Requisition
processing by modifying Oracle
Forms, updating PL/SQL packages, SQL tunning from client service requests in
Oracle10g
• Wrote installation documents for Database Software, Application Server
upgrade, Prism (Purchase Order
Module) upgrade, and Discoverer upgrade.
• Documented technical resolutions documentation for service packs, production
support
• Created Service Request/TAR with Oracle Corp thru metalink and monitor
status
• Used Unix, Linux shell commands to compile Forms and perform tasks
• Performed multitasking, including tracking, monitoring, and reporting
efficiently for meeting deadline
• Assisted other team members on various issues on SQL coding, PL/SQL coding,
Accounting concepts and
principal in Financial operations
Accenture Technology Solutions (Reston, VA)/Department of Commerce
(Gaithersburg, MD)
Sr. Oracle Developer/DBA 7/06-5/07
• Attended user meeting meeting to gather user requirements for system
configuration,
Application, and database
• Performed Oracle web migration from 6i client/server to 10g for Federal
Financial Management System for Commerce Business System (CBS)
• Used UCM ClearCase to check in/out modules during development process to
management soft repository
• Utilized PL/SQL, Oracle Form 6i, 10g, Oracle Report 6i,10g,Toad, SQL Plus,
Unix during conversion
• Made functional, GUI, code updates in PL/SQL, Forms, Report
• Performed unit testing and peer review for quality control to meet specific
requirements
• Wrote Unxi Shell Script to automate tasks during data migration
• Used tools of Oracle Toad, ClearCase, UltraEdit-32 for daily database
monitor and development work
• Completed ahead of schedule for project phases and obtained high qualities
Incisive Technology (Alexandria, VA)/Army Readiness Systems (Alexandria, VA)
PL/SQL Developer 2/06 – 7/06
• Wrote PL/SQL package, function, procedure by using SQL Developer,
Jdeveloper, SQL+ in Oracle 9i
• Used ref cursor, collection, bulking,index, partition, dynamic sql to
resolve business logic in package to provide front end queries for Oracle 9i army
readiness database deployment of readiness systems
• Tested and debugged package integrated with front end queries screens
• Tuned SQL and PL/SQL for satisfactory response time to meet the business
requirement of users.
• Installed Oracle 9i database on window and created database using Oracle
Enterprise Manager console to manage database
Savantage, Inc. (Rockville, MD)/Department of Homeland Security
Oracle Developer 7/05 – 2/06
Upgraded Oracle Forms 6i Client/Server environment to Forms 9i web server
technology for
Federal Financial Management Systems (FFMS) of Department of Homeland Security,
by utilizing Forms 6i
and Form 9i, SQL, and PL/SQL.
● Used ClearCase to check in/out modules for work
Updated program unit, triggers, property palette in Forms 6i to run in Forms
9i
Updated and maintained Federal Financial Management Systems/Altimate oracle
Reports
and Forms.
Understood federal financial operations and system processing and make
changes to oracle
package in Order to fulfill SF133 change requirements for fiscal year 2006 by
using knowledge
of Oracle, Oracle Forms, Oracle Reports, package, SQL, PL/SQL.
Rockwell University (Vienna, VA) 6/04 – 7/05
Graduate student
Certification: Oracle Developer, Java, Project Management
Developed Oracle 9i retail sales application using predefined user requirements,
SQL, SQL*Plus, PL/SQL, Oracle Forms and Reports. Development activities
included:
Verifying user requirements, developing a normalized model and designing
database.
Creating database with required views and loading initial application data
using SQL scripts.
Creating PL/SQL procedures, functions and triggers to enable global
functionality.
Developing user interface for application administration, user
inventory/order input, processing,
and reporting.
Developing required reports using Reports 6i to implement project report
requirement.
Testing database, objects, Forms and Reports created to insure data integrity
and application function.
Developing Java/J2EE program
Developing web page using HTML, JavaScript, XML
● Installed Weblogic, Tomcat, J2EE to server
VNU/Claritas Inc., Rosslyn, VA
Oracle Developer 5/00 – 6/04
• Used Oracle tools, PL/SQL, developer and SQL *Plus in Oracle 9i to create &
update tables and processed data in data warehouse.
• Used SQL Loader to load data into Oracle tables and performed quality
control on data loaded by SQL script file.
• Used MS Access, Excel and TextPad to import, export and process data to
create Compass database.
• Worked with Project Manager to craft the specifications and requirements for
the production of Compass (Precision Marketing Software) database.
• Documented the DB creation process of Compass database with Word.
• Performed quality control on database created to ensure efficient data
loading.
• Worked with team members to accomplish major projects and attending business
requirement meeting.
• Consistent track record of meeting delivery deadlines for software
products.
• Worked with the team and proposed the restructured workflows to meet
aggressive delivery deadlines, which resulted in early product deliveries.
• Ensured accurate production leading to satisfied clients and meeting
deadline.
SAIC Inc./Information Technology Advanced Training, Vienna, VA
Oracle Developer 9/98 – 4/00
• Developed inventory systems with a team of three members with full software
development life cycle project responsibilities like designing, development,
implementation and maintenance.
• Used data modeling and normalization techniques to design database base on
business requirements.
• Coordinated team members and allocated responsibilities to accomplish
project deadlines.
• Used Oracle SQL, PL/SQL, script files, Oracle Forms and Oracle Report for
omplenenting project.
• Obtained one year training from ITAT Inc. in Oracle Developer track, DBA
training
CPA/Accountant 1/89 – 8/98
Education
Master of Science (MS) - E-Commerce, Rockwell University, McLean, VA
Masters of Science (MS) - Accounting, University of North Texas (UNT), Denton,
TX
Bachelor of Business Administration (BBA) - Business Computer Information
Systems,
UNT, Denton, TX
|