EXPERIENCE:

Confidential

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

• 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 wrote the Segment Specification for the Software Engineering Center at Fort Meade, MD.
• I am a Software Engineering Institute SEI certified instructor and lead appraiser, and have taught the Introduction to the Capability Maturity Model Integration CMMI more than ten times.
• I participated in three Standard CMMI Appraisal Method for Process Improvement SCAMPI assessments for projects at SSC-C.
• I was the lead appraiser assessments for seven organizational units, both commercial and government.
• I developed and taught Requirements Management and Measurement and Analysis Workshops for SSC-C.
• I taught the Configuration Management and Process and Product Quality Assurance Workshops developed by TECHSOFT.
• I worked as the Measurement Analyst, Configuration Manager and Requirements Manager for the CICS project and wrote the CICS System Specification and the SecureD Subsystem Specification. Later, I assumed responsibilities as project Systems Engineer.
• 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, SharePoint, Visual SourceSafe, Appraisal Wizard, Transact SQL, SQL, Microsoft Access, Oracle 10g

Confidential

• 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. The database used Oracle 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 Oracle database. This effort involved designing a web-based questionnaire, collecting the data and analyzing the results. 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, Oracle Application Server, Oracle Forms 6i and 9i , PL/SQL, SQL, HTML, Sablime, Microsoft Office, Telelogic DOORS, Vitech Core, Unix, data analysis

Confidential

• As Technical Director, 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 University of West Florida 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 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 assisted with the development of a Software Engineering Environment SEE for the Naval Security Group Activity NSGA Pensacola. This SEE provided the Naval Security Group's Software Support Activity with a state-of-the-art programming environment for maintaining complex computer systems which range from simple personal computers to large networks of UNIX and VMS operating systems.
• 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.
• I developed the TECHSOFT's process manuals to support the Software Capability Maturity Model.

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

Confidential

• As the Database Administrator, I lead a team of software engineers responsible for developing the Joint Forces Air Component Commander's JFACC Decision Support System JDSS . This effort required the development of requirements, specifications and an implementation plan. The first prototype was developed in less than nine months with a minimum staff and very few resources at the beginning. I analyzed the existing ORACLE databases and developed a method of accessing the data elements to make them available to the JFACC staff using a Motif-based interface and the Common Mapping Program.
• I was the lead software engineer responsible for the performance tuning of the Contingency Theater Air Control System TACS Automated Planning System CTAPS ORACLE database. I was responsible for analyzing the database design, SQL Forms and query structure and recommending, implementing and testing improvements. During this project, I was responsible for upgrading from Oracle version 6 to Oracle version 7. I introduced the use of PL/SQL to the other database staff. Because it is based on Ada, a language that I had been using, I was able to accomplish the training quickly.

Skills Used: Microsoft Project, Oracle database, SCCS, UNIX, SQL Forms, C programming, PL/SQL, SQL

Confidential

• I supervised the personnel who were providing software support to the Naval Security Group Detachment, Pensacola, FL.
• My primary job was to function as the detachment's Database Administrator. I designed the activity's Corporate Database composed of 40 tables and 10 views using the Oracle relational database management system. Additional duties included the drafting of reports using the Constructive Cost Model and data that had been entered into the Corporate Database. I provided guidance on the management of several programs that were supported by the detachment. These programs included the Data Handling System, the Operational Intelligence OPINTEL Broadcast, Centerboard/Flaghoist and CLASSIC AERIE. During this time, I was responsible for upgrading from Oracle version 5 to Oracle version 6.

Skills Used: Oracle database, VAX VMS, SQL Forms, Ada, Pascal, Fortran