Database Developer Resume

Title
Database Developer

Primary Skills
Oracle Developer, PL/SQL ASP.net

Location
US-DC-Washington (will consider relocating)

Posted
Jun-07-09


SUMMARY
Over twenty years of experience in all phases of development life cycle including analysis, design, project management, development, installation and support of computer and database business solutions. Designed, developed and maintained databases in Oracle and SQL Server. Developed standalone, multi-user and multi-tier model web based and client/server computer systems in VB.NET, ASP.NET, Visual Basic, ASP, Java Script, Access, FoxPro, dBase, Paradox, SAS and COBOL.

Clearance Obtained
Secret
(Current)

Knowledge of:
- Oracle Database 10g
- Oracle PL/SQL
- Transact SQL
- SQL/Loader
- SQL Developer
- TOAD
- MS/SQL Server 2005
- ASP.NET
- VB.NET
- C#
- ADO.NET
- MS/Access
- Crystal Reports (Business Objects)
- ASP
- HTML
- VB Script
- Java Script
- Java
- XML
- Visual Source Safe
- Microsoft Project
- Excel



EDUCATION/TRAINING
• State University College at Geneseo, Geneseo, NY May 1982
Bachelors of Science in Business Administration, Minor in Management Science

• Microsoft Certified Professional for Visual Basic
EXPERIENCE
Technical Advisor/Contractor -- August 2008 to Present -- Contracting for Civilian Police International working for the United States Department of State, Baghdad, Iraq
Provide technical assistant to officials from Iraqi government and implemented Oracle 10g databases for their judicial system.
• Created Oracle databases using Database Configuration Assistant. Designed, developed Oracle tables using normalization techniques. Implemented constraints, indexes and sequences.
• Designed and implemented security by setting up users, profiles and roles and assigning system and object privileges.
• Created triggers, packages, stored procedure, views and functions using PL/SQL. Knowledge and experience in implementing cursors and exception handling.
• Develop advanced queries to retrieve, analyze and update data and evaluated SQL statements for performance tuning.
• Extensive knowledge and use of the Oracle data dictionary in resolving database issues.
• Used SQL/Loader and ODBC to import data into Oracle from Access, Excel and flat files. Developed packages and stored procedures to validate information according to established business rules. Populated Oracle tables with imported data

Technical Adviser/Contractor -- October 2006 to August 2008 - Contracting for BearingPoint working for the United States Department of State, Baghdad, Iraq
Provided technical support for an existing Web application to be used by the Iraqi Government Ministries
• Created databases and implemented triggers, stored procedures and functions using SQL/Server 2005.
• Assisted in developing a web based application in ASP.NET with C# using Oracle Database and nHybernate, a .NET based object persistent library for relational databases.
• Debugged existing C# code and develop Oracle stored procedures and functions, designed tables using Oracle DDL and sequences and triggers in PL/SQL.
• Designed and developed accounting/project tracking system used by the different proveniences in Iraq.
• Developed training manual and instructed training seminars with Local Nationals on a change control/project tracking application t hat I developed.
• Used data pump to import and export Oracle database object and data. Implemented a simple database backup and recovery process.
• Develop project plans for current IT projects using MS Project.


Contractor / Programmer -- October 2005 to October 2006 - EDS, Herndon, Virginia
Develop data import solution for Oracle and provided support for an existing Web Application,
• Designed, developed and implemented a data import utility with Oracle SQL/Loader to load data from flat files to data tables. This solution included SQL*Loader control files to described the data to be loaded, stored procedures and triggers for data validation and to populate Oracle tables.
• Developed utilities and modified web applications in ASP.NET using VB.NET and Visual Studio 2003.
• Supported an existing web based application by working on bug fixes. Identified existing problems and develop the solutions t to resolve them.

Internet Developer/Contractor -- June 2003 to October 2005 -- Xerox Corporation, Rochester, New York
Design, develop and implement ASP.NET Web Applications and provided system administration for several Microsoft Windows 2003 servers.
• Developed numerous Web based applications under IIS and the Microsoft.NET framework using Visual Basic.NET programming language with ASP.NET connecting to an Oracle database. Utilized ADO.NET against a Microsoft SQL/Server database.
• Designed and consumed Web Services using an n-tier architecture containing a data tier, business logic tier and a presentation tier. ADO.NET disconnected data sets were used to transfer data between the different layers.
• Maintained and supported Xerox's Financial Services Intranet web site, which consisted over 400 web pages.
• Designed detail specifications outlining application requirements and procedures for computer applications.
• Utilized Crystal Reports to develop reports accessing Oracle data through stored procedures and data views.
• Developed test scripts to assist in the testing and debugging of computer application.


Between 1985 and 2003, I worked as a private contractor/consultant/employee for the following companies.
EDS, Herndon, Virginia
Xerox Corporation, Rochester, New York
EDS, Rochester, New York
Strong Memorial Hospital, Rochester, New York
Bausch and Lomb, Rochester, New York
Eastman Kodak, Rochester, New York
LTV Aerospace and Defense, Dallas, Texas * Top Secret Clearance

While employed, I was responsible for the following:
• Provided database administrative functions for Microsoft SQL/Server such as designing and creating database and tables, implementing database backups and restores, importing and exporting of database files, developed stored procedures and views.
• Analyzed, designed, developed and tested client/server applications using Visual Basic and Crystal Reports against an Oracle database.
• Worked on a development team to design, create and deploy a mini-data warehouse used for data analysis and to post information to General Ledger. This was developed against several Oracle databases and PL/SQL.
• Destined, maintained and supported an Oracle Manufacturing and Finance (OMAF) decision support system. Application comprised of Oracle Manufacturing, Inventory, Purchasing, Financing and Planning data extracted from OMAF using Access SQL to display data using forms and reports.
• Used Crystal Reports (Business Objects) to develop reports accessing Oracle data using stored procedures and views.
• Designed and developed Data Transformation Services (DTS) packages in MS/SQL Server used for importing, formatting and validating financial data into SQL/Server tables.
• Provided support for the implementation of a new Financial Investment Management Software Application by developing Storage Procedures, Views and Scripts using Microsoft SQL Server.
• Developed Web based applications using VB.NET with ASP.NET against an Oracle and SQL/Server database.
• Provided support for the implementation of a new Financial Investment Management software application by developing stored procedures, views, triggers and scripts using Microsoft SQL Server.
• Designed and developed a generic/database driven reporting tool using Access 2000 Visual Basic for Application, Access SQL and Access Reports. Data was being captured from a Web Based Customer Relations Management application stored in Microsoft SQL/Server.

Certifications
VB certification from Microsoft


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Washington, DC | Resumes in District of Columbia

View other Database Developer resumes, Programmer / Developer resumes