SUMMARY:

A responsible and challenging database administration position that utilizes database design and development skills.

EXPERIENCE::

Confidential, Augusta, ME

Responsibilities:

• My task was to test the functionality of the birth portion of a new release of the application.
• Additionally, I was tasked to develop interactive training for users of the DAVETM using Adobe Captivate.
• I also help by creating Excel spreadsheets that allowed the users to copy the contents of a text file into a worksheet, and display the data in a more usable form on a different worksheet in the same workbook.

Skills Used: SQL Server, SQL, Microsoft Excel, Adobe Captivate, DAVETM

Confidential, Portland, ME

Responsibilities:

• I was a contractor that provided extract, transform and load (ETL) support to the company.
• As the ETL Report Writer, I used Jasper iReports and Talend to generate reports that provided information to management and to clients.
• The data was maintained using a MySQL database that was located in two separate data centers.

Skills Used: MySQL, UNIX, SQL, Jasper iReports, Talend, Mercurial, MAC OS X

Confidential, Pensacola, FL

Project Leader

Responsibilities:

• As the Project Leader I was responsible for overseeing the administration of each of the four databases.
• I trained and managed the team to ensure that they had the necessary database knowledge and skills.
• I also showed them how to used Access as a front end for the SQL Data to allow the users to retrieve data without having to learn all of the details required by the SQL Server tools.
• I developed plans and process manuals for SSC C Level 3 Confidential efforts.
• I also worked on a short term project to help a client convert an Oracle 10g database to SQL Server 2008 database.
• I helped the client install a version of Oracle so that they could load the database from a company that they had acquired so that they could still meet corporate obligations.
• Then, I had to analyze the existing database environment in order to map the tables, views, and procedures from Oracle to corresponding objects that would have the same functionality in SQL Server. Once the conversion was complete, the client was able to switch seamlessly from using the Oracle database to the SQL Server database.

Skills Used: Microsoft Project, Microsoft Office, Microsoft Visio, SQL Server 2008, SharePoint, Visual SourceSafe, Appraisal Wizard, Transact SQL, SQL, Microsoft Access, Oracle 10g

Confidential, Fort Meade, Maryland

Database Administrator

Responsibilities:

• Because the web pages were created using stored procedures that used the Oracle web packages, I was able to embed JavaScript in the generated HTML. While the analysis is still on going, the initial prototype was built in three months. When I left, data had been collected on over one thousand systems almost half of the total inventory.
• As a result of this effort, the agency has established a foundation upon which decisions can be made to eliminate or keep the systems.
• I generated several ad hoc reports in response to requests from Congress.
• After building the database, I was assigned three contractors from other companies to build additional reports and data entry forms.
• I was responsible for assigning tasks and overseeing the quality of the product and data, as well as tuning the performance of the database.
• The Jackpot effort had over 1000 objects, including tables, views, and P/L SQL packages. During this time, I was responsible for upgrading the database from Oracle version 8i to Oracle version 9i, and for introducing the Oracle Application Server.
• I also upgraded the forms capability from Oracle Forms 6i to Oracle Forms 9i.
• All of these upgrades were performed as part of semi - annual releases.
• I also created an automated process for generating a spreadsheet compatible output on a daily basis so that it could be used by some of the analysts that were uncomfortable with accessing data directly in a database. My team was also responsible for creating roles and views to ensure that only authorized users had access to some of the sensitive data.
• I also put in place procedures for backing up the database on a weekly basis in addition to the backups performed by the network support group.
• I was tasked to generate a quick reaction capability to meet critical mission needs.
• The current developer was not able to provide the necessary functionality so the customer asked the Software Engineering Center if we could deliver the desired capability.
• In three weeks, I led the effort to design, implement, test and deploy a web-based capability that would allow users to enter either requirement information or personnel information to allow the customer to track this information, and make appropriate assignment decisions.
• The customer was very pleased with our responsiveness and quality of work.
• I added additional tables to the Jackpot Database to capture information about an effort to move UNIX applications to an NT environment.
• I also designed and helped implement a set of data entry forms to capture information about legacy databases.
• This information was provided to other contractors to help them migrate the data from the old databases to a new, more up-to-date database.
• Once again we were only given two months to deliver an initial capability. Our initial prototype was quite successful.
• Because the customer was not ready to collect data when the initial prototype was delivered, he asked for additional modifications that we added without any problems.

Skills Used: Microsoft Project, Microsoft Visio, FrameMaker, Oracle database 9i, Oracle Application Server, Oracle Forms (6i and 9i), PL/SQL, SQL, HTML, JavaScript, Sablime, Microsoft Office, Telelogic DOORS, Vitech Core, Unix, data analysis

Confidential, Pensacola, Florida

Technical Director

Responsibilities:

• I was responsible for managing the technical aspects of all development and maintenance efforts.
• I developed the company's design and coding standards.
• I was responsible for developing and implementing the company's configuration management procedures.
• I was responsible for performing Independent Verification and Validation (IV&V) on the development of the Confidential II system.
• Documents that I reviewed included: Software Development Plan, System Specification, System/Segment Design Document, Software Requirements Specification, Software Test Plan, Software Design Document, and Software Test Description.
• The Confidential II system was developed using the Shlaer-Mellor object-oriented analysis and design methodology.
• Upon successful completion of the course, the students were awarded 3 semester credit hours.
• I developed all the database lab sessions for the above database course. These labs covered skills ranging from accessing the database to actually designing and building simple databases.
• I designed and implemented a database to support the Air Force's Housing Information Management System. This effort involved converting an un - normalized Microsoft Access database into a normalized ORACLE database.
• These database modifications resulted in queries taking only minutes instead of hours.
• I designed and developed the database for NSG's System Security Plan software. This effort involved converting an un-normalized dBase III application to work in a FoxPro environment.
• Additionally, I designed and developed data entry screens using FoxPro's tools.
• I provided guidance and assistance with the analysis of data collected by NSGA Pensacola. This analysis has resulted in several reports on the metrics effort at Confidential and how to improve it.

Skills Used: Microsoft Project, Oracle database, SourceSafe, Microsoft Office, Telelogic DOORS, dBase, FoxPro, Microsoft Access database, Sybase database, Unix, VMS, Cadre Teamwork, Ada programming, IV&V testing