SUMMARY

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

PROFESSIONAL EXPERIENCE

Confidential, Augusta, ME

Responsibilities:

• I was a contractor that provided testing support for the DAVETM system used by the State of Maine.
• 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 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, Confidential 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

Responsibilities:

• I was the Project Leader for the Tools Development Project which was responsible for developing the four web - based applications, using a SQL Server database as a repository for the Space and Naval Warfare Systems Center Atlantic (SSC Atlantic).
• 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 CMMI efforts.
• I helped write the six management plans for the Space and Naval Warfare Systems Support Center, Charleston, SC (SSC C).
• I also worked on a short term project to help a client convert an Confidential 10g database to SQL Server 2008 database.
• I helped the client install a version of Confidential 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 Confidential 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 Confidential database to the SQL Server database.

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

Confidential, Fort Meade, Maryland

Responsibilities:

• As the Database Administrator for the Software Engineering Center, I designed and implemented the Jackpot Database by working with others to establish the requirements for the database.
• The database was designed primarily to support the collection and analysis of software measurement data. database used Confidential products, including a Web Server, Developer/2000, and Net8.
• My initial work accomplished in 12 months what the previous contractor could not do in two years.
• The Jackpot Database provided a solid foundation for establishing process improvement procedures throughout the agency.
• I expanded the Jackpot Database to provide the tools to support the collection and analysis of data about the agency's diverse software systems using web pages maintained in the Confidential database.
• This effort involved designing a web-based questionnaire, collecting the data and analyzing the results.
• Because the web pages were created using stored procedures that used the Confidential 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 Confidential version 8i to Confidential version 9i, and for introducing the Confidential Application Server.
• I also upgraded the forms capability from Confidential Forms 6i to Confidential 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: Confidential Project, Confidential Visio, FrameMaker, Confidential database 9i, Confidential Application Server, Confidential Forms (6i and 9i), PL/SQL, SQL, HTML, JavaScript, Sablime, Confidential 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.
• As a Senior Software Engineer, I was responsible for performing Independent Verification and Validation (IV&V) on the development of the TACINTEL 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 TACINTEL II system was developed using the Shlaer-Mellor object-oriented analysis and design methodology.
• I developed the Database Administrator (DBA) portion of the database course that was taught by the Confidential for the Naval Security Group (NSG).
• These lessons taught the student a variety of DBA skills, including: how to install a SYBASE Relational Database Management System (RDBMS), allocate resources, manage user accounts and perform backups and recovery. Upon successful completion of the course, the students were ed 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 Confidential Access database into a normalized Confidential 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 NSGA Pensacola and how to improve it.

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