Technical Director Resume
Pensacola, FloridA
PROFESSIONAL EXPERIENCE
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 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 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 Confidential 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, 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.
- The 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.
- 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, Confidential Application Server, Confidential Forms (6i and 9i), PL/SQL, SQL, HTML, Sablime, Confidential Office, Telelogic DOORS, Vitech Core, Unix, data analysis
Technical DirectorConfidential, Pensacola, Florida
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 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 of West Florida for the Confidential (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 assisted with the development of a Software Engineering Environment (SEE) for the Confidential Activity (NSGA) Pensacola. This SEE provided the Confidential '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: 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
Database AdministratorConfidential, Hampton, Virginia
Responsibilities:
- 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 Confidential 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) Confidential 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 Confidential version 6 to Confidential 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 quickly.
Skills Used: Confidential Project, Confidential database, SCCS, UNIX, SQL*Forms, C programming, PL/SQL, SQL
Confidential, San Diego, California
Responsibilities:
- My primary job was to function as the detachment's Database Administrator.
- I designed the activity's Confidential Database composed of 40 tables and 10 views using the Confidential relational database management system.
- Additional duties included the drafting of reports using the Constructive Cost Model and data that had been entered into the Confidential 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 Confidential version 5 to Confidential version 6.
Skills Used: Confidential database, VAX VMS, SQL*Forms, Ada, Pascal, Fortran
TECHNICAL SKILLS
Programming languages used: Ada, Java, JavaScript, C++, C, Pascal, FORTRAN, COBOL, MIX (Knuth's assembly language), BASIC, LISP, APL, Z80 Assembler, PC Assembler, PL/SQL, SQL, Pro*C, Visual Basic, Transact SQL
Database management systems used: Confidential, dBase II, dBase III+, dBase IV, Sybase, Paradox, FoxPro, Confidential Access, Confidential SQL Server, MySQL
Development tools: Sablime, Telelogic DOORS, Vitech Core®, Confidential Application Server, Cadre Teamwork, Jasper iReports, Talend, Mercurial distributed source control management tool
Administrative tools: Confidential Office including Word, Excel, PowerPoint, and Outlook, Confidential Project, Confidential Visio, FrameMaker, Appraisal Wizard