SKILL SUMMRY

Over 18 years of Information Technology experience. Includes extensive experience with multiple technologies.Oracle Database and PL/SQL developing, Logical Data Modeling, Physical Data Modeling, CMMI, SDLC, Oracle11g, 10g, 9i/8i and other Oracle technologies on Unix/Linux 9 years .

• Erwin, SQL, requirements gathering
• Data Modeling, Oracle 9i - Oracle 11g for Solaris and Linux
• Used Oracle PL/SQL to developProgram units, Procedures, Functions, Packages and Triggers for more than 10 years.
• Designed and developed complex application projects using Oracle 11g PL/SQL , ASP.NET 3.5, C , Java, Java Script and HTML.
• SDLC, Three Phase Technical Analysis
• I am highly skilled in design, development, troubleshooting applications, documentation, coding, testing, and preparation of system test plans.
• Developed applications along the guidelines of Capability Maturity Model Integration Level II and III for Software and Quality Assurance and ISO 9001 for various government agencies.
• Performed job responsibilities in an outstanding manner during times of personnel shortages.
• Effective team-builder with strong leadership skills and proven track record at setting and achieving goals.

SKILLS:

Data modeling: Erwin, Toad, SQL developer

Databases: Oracle 11g, 10g, 9i/8i, SQL Server 2005, Oracle Designer/2000, Oracle Developer 2000 Oracle Forms 4.5-10g, Reports 2.5 -10g PL/SQL , Oracle Webserver, Advanced Revelation, Unidata

Software: ASP.NET 3.5, Visual InterDev, Java, Visual BASIC Script, Java Script, Active Server Pages ASP , Hypertex Markup Language HTML , VisualSourceSafe, Business Objects

Languages: Oracle PL/SQL, Java, C , RBASIC, C, PRO C

Operating Systems: UNIX, Linux, Windows NT, Windows XP

Hardware: IBM PC/XT/AT, Compatible

Networks: Novell

PROFESSIOANL EXPERIENCE:

Confidential

Position:Database/Record Manager

Confidential

• Manages data verification processes, coordinates data updates, and ensures data integrity. Maintain system configuration, including core tables, security and workflow. Provide overall expertise regardingdatabase use.
• Develop, test, modify, and documentdata entry processes. Recommend methods and procedures to improve efficiency and accuracy.
• Oracle Database and PL/SQL developer for Unit Oracle database of medical records of selected population. Coordinate maintenance and quality assurance of unit database s . Ensure data integrity of records in the database through regular audits.
• Develop, implement, and complete extensive audit processes for all systems. Coordinate data audits. Analyze audit results and recommend improvement to policy, practice, and/or procedure as a result of audit findings.
• Create and generate a variety of standard and customized queries and reports and database exports. Compile and summarize data as needed to support analytics. Coordinates the dissemination of this information, as appropriate.
• Handle staff inquires and assist them with data interpretation and understanding.
• Troubleshoot problems, develops solutions, and coordinates with appropriate internal staff or vendors to resolve issues.
• Provide ongoing support for systems medications and documentation as needed.
• Participate in team activities related to new database development and database enhancements.

Position: Senior System Analyst

Oracle Database Modeler, PL/SQL Developer,Database Administrator for creating and automating electronic forms for USDA - Forest service, Office of Regulatory and Management Services ORMS . ORMS is converting national forms from paper to electronic including some with updated business process that are automated using Oracle databases to store data collected on formsWork includes full life cycle software development, requirement preparation and Prepare DB logical and physical models based on requirements. Review and obtain approvals on designs through database design review boards. Develop unit test harness using PL/SQL and test programs. Obtain Q/A sign off on the code and promote to integration test environment. Work closely with QA testing resources to ensure the product met expectations

• I created Oracle Data Model for Telework Agreement Oracle database using Erwin, Design Oracle Relational Database using SQL Developer. Created archiving process and tuning.Extract Transform and Load from multiple databases to Telework AgreementOracle Relational Databases
• Using SQL Developer and Toad, I designed Telework Agreement Oracle database and schema.
• Using PL/SQL, I created Oracle procedures, functions, Triggers and packages.
• Oracle database administrative duties include creating database schema. I also participate in software Release and maintenance.
• Oracle database administrative duties include creating database schema. I also participate in Software Release, maintenance, users support and training.
• Using SQL Developer and Toad I designed Forms, Oracle databases and schemas, created Oracle procedures, functions, Triggers and packages, data import in Oracle database using Oracle Loader.
• Provide technical support to end users and other developers.
• Research and resolve production problems. Interact with end users to resolve issues. Act as a point-of-contact POC for customers and the Project Management Office PMO .
• Developed electronic forms for USDA Forest service, FS-6400 0033 - Space and Reconfiguration Form. I also reviewed and debugged Triggers for FS-1300 0024 - Request for Forms Action and Approval. Work includes Researches and analyzes problems, issues, program requirements. Conducted database management reviews, test eforms and workfellows.
• Oracle 10g, PL/SQL and Formatta software are used. Toad and SQL Developer are tools used in this project.

Position: IT Specialist

Duties and Accomplishments:

• Analysis, development, testing, implementation and maintenance of software applications used in the National Institutes of Health - Center for Scientific Review.
• Troubleshoot ARWS Web application a SQL Server 2005 Based database. Participated in updating channels of Intranet and Internet at CSR. Function as the assistance database administrator for CSR's SQL Server 2005-8 databases. Used Oracle SQL Loader to move data into Oracle database.

Position: Senior System Analyst

Duties and Accomplishments:

Senior system analyst/Developer for the design, development and maintenance of databases and WEB applications for the Bureau of Engraving and Printing BEP .

• Used Erwin data modeling tool for creating Federal Reserve Report System complex Oracle Database. Prepared applications for release to test, pre-production and production environments.
• UsedOracle10g Forms, Oracle10g PL/SQL and Oracle10gReports to developWEB based applications for BEP.
• Translated business requirements and software design specifications into Oracle Forms 10g applications. Conducted unit testing of applications prior to release for user acceptance testing. Supported members of the testing team through user acceptance testing and pre-production and load testing.
• Designed and developed the Federal Reserve Report System FRRS application using Oracle10g. Used Oracle SQL Loader to move data into Oracle database.
• Created front end to FRRS application using Oracle 10g Forms. Supported members of the testing team through user acceptance testing and pre-production and load testing. Applicationsweremanaged and designed using the guidelines of Capability Maturity Model Integration Level II.

Position: Senior System Analyst

Duties and Accomplishments:

• Confidential is a multi-module DBMS designed to utilize data that was collected under the auspices of the National Bridge Inspection Standards. NBI System created accurate reports for Congress and Federal Highway Administration FHWA on the numbers and state of the Nation's bridges. I performed the following tasks:
• Senior system analyst/Developer for FMIS and National Bridge Inventory Information System NBI project contract at the U.S. Department of Transportation - Confidential .
• Analyzed and developed requirements, document, prepared physical and logical database designs, Coded, tested and performed configuration management as well as quality assurance forNBI database management system.
• Used Erwin data modeling tool for creating complex NBI Oracle Database.
• Designed and developed NBI Oracle database tables using normalization process using Toad.
• Populated and validated database tables using SQL loader and SQL scripts.Created interface to NBI Oracle Web based application usingOracle 10gForms, Java,ASP and ASP.NET.
• Developed a financial module using Oracle 9i Forms to connect NBI to financial application FMIS to review contracts on each bridge financially
• Used Oracle PL/SQL to develop Program units, Procedures, Functions and Packages for NBI.