SUMMARY:

• Over 20 years of experience in design and technical support of information systems. Specialized experience in requirements analysis, data modeling, software integration, and managing system life cycles.

TECHNICAL SKILLS:

Tools: Oracle SQL Developer, Oracle Data Modeler, Toad for Oracle, IBM Rational Suite (RTC, RRC), Eclipse IDE (hyperModel plug - in), SOAP UI, Unix (HP-UX), Red Hat Enterprise Linux (RHEL), PL/SQL, Oracle, PostgreSQL, SQL Server, VP-UML

PROFESSIONAL EXPERIENCE:

Confidential, Charleston, SC

Senior Subject Matter Expert

Responsibilities:

• Developed a Conceptual Data Model (CDM) and a baseline Logical Data Model (LDM) for a Marine Forces Cyber Command (MARFORCYBER) Automated Individual Plan (AITP) to be deployed as an app in the MARFORCYBER Information and Knowledge Management (IKM) tool under development in Sharepoint 2013. Both the CDM and LDM were created using a common pattern for HR department applications. Converted the LDM into a Physical Data Model (PDM) for deployment in a database to be created in the SQL Server backend for the IKM Sharepoint instance.
• Participated in team planning sessions for the design of a Procurement System (TPS) app to be included in the Sharepoint 2013 IKM tool.

Confidential, Charleston, SC

Data Architect

Responsibilities:

• Developed a baseline LDM for the Veterans Administration (VA) Veterans Benefit Management System (VBMS) and converted the LDM into a PDM. Worked with Database Administrators (DBA) to convert the PDM into an Oracle 11g schema. The work was performed using Agile Development methodology for both modeling and documentation.
• As a member of the Data Guild embedded on multiple Scrum Teams, reviewed Liquibase changeSets submitted by developers to effect changes to the database and provided comments/guidance as necessary prior to delivery to the development stream.
• As a member of the Governance Working Group (GWG), authored data modeling rules and best practices for continued Agile development of multiple database schemas in VBMS. Created and maintained documentation for the Common Data Model XML schemas.
• Created documentation of multiple database schemas and updated same at the end of every two week development Sprint for submission as deliverables to the VA and for posting in the project's SharePoint wiki for access by developers.

Confidential, Charleston, SC

Software Developer, Principal

Responsibilities:

• Continued support of developing the DNDO JACCIS application Confidential initial operating capability (IOC) in an Agile Development environment.

Confidential, Charleston, SC

Systems Integration Analyst III

Responsibilities:

• Supported the SPAWAR aXiom/TC2 efforts in the areas of software integration and database technical support. Developed and implemented business process management and configuration control processes, managed system lifecycles, developed technical documentation and architecture diagrams, and executed high level system loads, integration, and security lockdowns. Executed assigned tasks with a high degree of independence and provided detailed documentation of all activities.
• Developed an LDM compliant with DoDAF artifacts, NIEM XML schemas and the N.25 RADNUC XML schema for the Department of Homeland Security (DHS) Domestic Nuclear Detection Office (DNDO) Joint Analysis Center Collaborative Information System (JACCIS). Converted the LDM into a PDM and created an Oracle 11g database for IOC installation at the DNDO data center.

Confidential, Charlotte, NC

Database Analyst

Responsibilities:

• Ninety day contract assignment to, Confidential, Inc. ( Confidential ) supporting SPAWAR's aXiom project. Transformed existing LDM for DNDO into an Oracle database, populated database with test data, and created complex stored procedures and views to enable demos of capability for DNDO.

Confidential, New Orleans, LA

Programmer Analyst

Responsibilities:

• Created complex stored procedures, views and reports for the Chem-LMS Laboratory Information Management System (LIMS) that provided for more efficient and reliable review of complex QC data associated with customers' environmental testing. Created complex ad-hoc queries. Tuned SQL and PL/SQL for performance.

Confidential, Norfolk, VA

Business Systems Analyst

Responsibilities:

• Principal: Created database objects, complex stored procedures, and reports for LIMS to provide managers with work performance metrics where none existed before. Created new management information reports to facilitate sample tracking and effect work flow improvements. Created ETL scripts for periodic data extracts from the database and data transformation for loading into the PDREP database maintained by NAVSEALOGCEN to facilitate data trending in paint testing.

Confidential, Goose Creek, SC

Programmer Analyst

Responsibilities:

• Developed, tested, installed, and maintained code modules and report files for LIMS database customization to support customer needs and to ensure both data integrity and compliance with external requirements such as ISO/IEC 17025, EPA methods, and NNPI security requirements. The database was in Oracle 9i on a Unix (HP-UX) server that was user accessed via Agilent QC Client software running on a Windows Terminal Server. The reporting package was Crystal Reports 8.5. Worked directly with customers for user requirements analysis to translate business processes into software requirements and to provide solutions with standardized test reports, management information reports, ad-hoc queries, etc. Solutions frequently required creation of complex stored procedures, triggers, tables, views, queries, indexes, and relationships, as well as importing and exporting data. Evaluated and tested software upgrades for compatibility with installed operating systems, Oracle, and QC Client versions. Created a lesson plan and conducted of site system administrators for ad-hoc query writing and reporting with SQL, Query Reporter, and Crystal Reports.

Confidential, Jacksonville, FL

Materials Engineer/Programmer Analyst

Responsibilities:

• Served as the system administrator for the Materials Engineering Laboratory during the design, development, test, integration, operation, and maintenance phases of the LIMS system life cycle. Applied best practices of data modeling and database design to accomplish or direct the requirements definition, installation, development, implementation, and customization of software systems elements.