Professional Highlights

• Over 5 years supporting United States Army Materiel Command USAMC Logistics Support Activity LOGSA database design as a Enterprise Group Team Leader/Data Architect utilizing Sparx Enterprise Architecture 10.0, SAP PowerDesigner 16.1, ErWin 7.3 following DoD Architecture Framework DoDAF 2.02.
• Extensive experience as an Information Technology IT Professional supporting Logistics, Aerospace, Automotive, Transportation, Healthcare, Power Generation and Food industries.
• Over 15 years Automotive industry experience working in various Data Architect, Database Administration DBA and Team Management capacities supporting Military, Engineering, Finance and Marketing/Sales application development.
• Over 17 years of experience database design as a Data Architect/Data Modeler utilizing Sparx Enterprise Architecture 10.0, SAP PowerDesigner 16.1, ErWin 7.3, Oracle Designer 10g, 9i, 6i, 2000, CASE 5.1, SQL, and SQL PLUS.
• Over 15 years Military/Commercial Aerospace industry experience working in Software Engineering and Hardware Task Manager capacities, adhering to various Military Standards Mil-Stds .
• Extensive experience following IT standards, Software Development Life Cycle SDLC methodologies and Change Control Management in compliance with all applicable regulations including Sarbanes-Oxley SOX .
• Extensive experience as Business Analyst gathering and documenting customer requirements, Facilitating JAD Sessions, and implementing best practices ensuring compliance to corporate strategic direction, policies and standards following guidance provided DoD Architecture Framework DoDAF 2.02 and Agile software development process.
• Proven leadership skills as a Team Leader and Project Manager, utilizing MS Project.
• Proven ability to successfully execute multiple projects concurrently.
• Excellent written and verbal communication skills have proven to be highly effective in interfacing with various levels of business and technology. Able to work well within a team environment and with all levels of management and business areas.

Employer History:

Confidential

Senior Data Architect

Enterprise Architecture Data Architecture Team Lead of the Logistics Integration Warehouse LIW Data Warehouse. Supervised multidisciplinary team of 10 Architects and modelers in the design and development of the United States Army Materiel Command USAMC Logistics Support Activity LOGSA Logisitics Integrated Warehouse LIW Redstone Arsenal. The team was engaged in the development, support of Data Vault models a specific data modeling technique for designing highly flexible, scalable, and adaptable data structures for enterprise data warehouse repositories in UML2, Developed standards and methodologies following guidance provided DoD Architecture Framework DoDAF 2.02 and the IBM Enhanced Agile Software development process. Developed LIW-I Business Requirements, within the LOGSA Software Engineering Process SEP Lifecycle framework. Provided Data Modeling estimates to the LIW-I MS project plan Work breakdown Structure WBS . Utilized Atlassian JIRA for bug tracking and work flow management, Atlassian Confluence for project documentation, Jama Contour to communicate and manage project requirements, and Apache Subversion for version control. Utilized SYBASE PowerDesigner to capture the design of the database architecture for the LIW project, including the use of dimensional database design methodologies and overall DW best practices. Developed Logical and Physical data modeling standards for use by the US Army in support of LIW. Facilitated design of ETL metadata layer. Developed prototypes for OS shell scripts and PL/SQL modules. Assisted team in reviewing long-term LIW architecture plans including the use of ETL tools, the future of the BI interface, and the interaction with planned LOGSA Service Oriented Architecture efforts. Coordinated the development of DoDAF Version 2.02 artifacts in support of the LIW Database design and development effort. Assisted in the design of the SAP Business Objects Universe for the US Army Supply Class VII Assets dashboard project for the USAMC LOGSA. Environment: Oracle 11g, Sparx Enterprise Architect, DODAF 2.02, UML2, SYBASE PowerDesigner 15.3-16.1, Erwin 7.3, SQL, PL/SQL, TOAD 9.1, SAP Business Objects Universe Designer 12.3, Jama Contour, Atlassian Jira, Atlassian Confluence, Apache Subversion, MS Office 2000, and Windows XP.

Confidential

Senior Data Architect

Contracted to Ford Motor Company, Data Architecture Services Department. Performed analysis, design and development of the Conceptual, Logical and Physical Data Models to satisfy customer requirements and to support the Enterprise Information Architecture strategy.Developed data architecture for applications supported by multiple patterns. Patterns included: Online Transaction Processing OLTP , Operational Data Stores ODS databases within Oracle 10g, DB2 and MS SQL Server environments, and Online Analytical Processing OLAP databases within the Teradata environment. Facilitated design sessions with business customers to derive database design requirements to support the business processes. Fully Documented Technical and Business Process Requirements in Logical and Physical Data Models. Generated Data definition Language ddl utilizing Oracle Designer 10g/9i ensuring compliance with IT standards, Software Development Methodology SDM . Changed Control Management and Sarbanes-Oxley SOX .Reviewed/Reconciled Data Model designs for adherence to data strategic direction, integration and integrity compliance, and data administration standards, ultimately preparing them for compliance and tollgate reviews. Worked with a team and with all levels of management and business areas.Lead Data Architect for the F ST Vehicle Accounting and Material Cost Management Forecasting system, providing oversight and direction to 3 Data Architects. Provided Data Architecture solutions to Engineering Product Development PD and Information Technology IT business areas. Provided production support/enhancements to multiple projects concurrently. Reverse engineering of existing database systems to physical data models and/or retro-fit Physical data models into logical data models. Developed and maintained data dictionaries, quality reporting, and naming standards.Received recognition awards for displaying exemplary teamwork in supporting PD IT applications. Environment: Oracle 10g, 9i, Oracle Designer 10g, 9i, 6i, MS SQL Server, IBM DB2, Teradata, TOAD, MS Office 2000, and Windows XP.

Confidential

Project Team Lead/Systems Analyst

Contracted to Gordon Food Service, Inc.: Completed successful expansion and deployment of 18 specific data fields in the UNIX Open systems and Mainframe environments and their related Oracle databases. Facilitated multiple large JAD Sessions 75 Users with representatives of all business areas to Identify, quantify and document end-to-end business processes. Establish internal and external applications, programs, databases, data integration processes and reporting between departments. Documented departmental business processes and corporate wide business process/rules utilizing VISIO. Worked with Oracle DBA s to create Automated Conversion Scripts to facilitate data comparison/conversion and coordinate end-to-end testing utilizing TOAD. Environment: Windows 2000, UNIX, Mainframe, TOAD, VISIO, Oracle 8i and MS Project.

Confidential

Business Analyst/Systems Analyst

Completed successful analysis, design, development, test, implementation and training of HIPAA compliant web enabled mobile software solutions for community healthcare providers, in support of state and federally regulated medical and social programs. Facilitated multiple JAD Sessions with user community to develop the mobile Maternal and Infant Support Services Tool MISST , a PC-Tablet based VB.net/ MS SQL Server Database software solution. Developed the Logical database design, utilized VISIO for deployment to customer host server or Data Center server. Developed interface and communication requirements with legacy Electronic Medical Records EMR and billing systems. Collaborated with Data Center to define a secure Virtual Protocol Network VPN to meet customer data communication Requirements. Environment: VISIO, MS SQL Server, MS Office 2000 and Windows XP.

Confidential

Architect/Project Manager

Database Architect/Project Manager 07/02 to 10/02 : Accomplished successful product analysis. Completed design and development of a generic web application, which globally standardized the method of defining and storing communication protocol diagnostic test specifications. Created Logical and Physical Data models, generated ddl using Oracle Designer 6i, SQL and SQL PLUS tools. Environment: MS SQL Server, Oracle 8i, Oracle 9i, Oracle Designer 6i, Developer 2000, MS Access, MS Project, VISIO, and Windows 2000. Contracted to Ford Motor Company Electrical and Electronic Systems Engineering EESE Dept. 07/00 to 07/02 : Planned, analyzed, designed and developed an Oracle 8i database to support a web based application that globally standardized the method of defining and storing vehicle Electronic Control Unit ECU diagnostic test specifications and the assignment of the ECUs to specific vehicle configurations for Ford Motor Company. Created Logical and Physical Data models. Generated ddl using Oracle Designer 6i, SQL and SQL PLUS tools based on customer requirements gathering in Facilitated JAD Sessions. Environment: MS Server, Oracle 8i, Oracle 9i, Oracle Designer 6i, Developer 2000, MS Access, MS Project, Visio, and Windows 2000. Contracted to Daimler Chrysler Dealer Technical Operations as a Systems Analyst/Site Manager 01/00 to 07/00 : Designed and developed a MS Access based OBD II vehicle calibration data transaction extraction/translation utility, which compared and created a Sybase superset of vehicle OBD II/DRB III test plan calibration data which significantly reduced duplication of data and maintenance costs within the HP/UNIX environment. Also served as Site Manager for the supervision of 4 on-site contractors. Environment: HP/UNIX, Sybase 11.03, MS Access, MS Project and Windows 2000.

Confidential

Application Support Manager

Facilitated HP/Unix system administration, Informix DBA and application support for 75 Users. Increased performance, productivity and profitability of the transportation department through automation, system migration, application upgrades and training. Trained other in an HP/UNIX, Informix based transportation system which included: truck loads planning, dispatch, vehicle maintenance and inventory control, billing and accounts receivable, general accounting, driver settlements, safety, fuel optimization, Satellite transmissions, Electronic Data Interchange EDI . Environment: HP 9000/D370, HP/Unix 10.2, McLeod Loadmaster, PC-Miler, Qualcomm, VSIfAX, EDI, Platinum Accounting, Windows 97, MS Tools and TCP/IP.

Confidential

Sybase DBA/Computer Operations Manager Oracle Reports Specialist

Contracted to Ford Motor Company/Process Leadership Dept. - Oracle Reports Specialist 07/98 to 11/98 :Creation/enhancement of TESTnet reports utilizing Oracle Reports 2.5 in a HP/UNIX environment. The TESTnet application provided a common process for initiating, reviewing, analyzing, tracking and managing vehicle component part testing at Ford Motor Company Worldwide. Environment: HP 9000/T50/K500, HP 9000/T50/K200, Unix v10.0, Oracle Developer 2000.Chrysler Corporation/Computer and Instrumentation Services Dept. - Sybase DBA/Computer Operations Manager 05/97 to 07/98 : Performed Digital UNIX/IBM AIX Systems Administration and Sybase DBA. Monitoring performance, upgrades, backup/recovery utilizing Dbartisan, Platinum and ERWIN toolsets. Sybase Data Replication design/administration. Environment: IBM RISC 6000/Aix 4.21, Digital Alpha/Unix 4.0d, Sybase 11.03, Sybase 11.5, Sybase Replication 11.0.2, DBARTISAN 4.02 DB Management tool, Platinum DB Monitoring tool, ERWIN, VISIO, Lotus Notes, Windows, MS Office.

Confidential

Application Systems Manager

Contracted to Ford Motor Company/Process Leadership Dept.: Global Systems Manager 11/96 to 05/97 : Performed TESTnet application Management, HP UNIX Systems Administration and Oracle DBA.Successful launch at 5 test facilities, and trained 200 users. Environment: HP 9000/T50/K500, HP 9000/T50/K200, Unix V10.0, Oracle 7 and MS Office. Contracted to Ford Motor Company/Automotive Safety Center: Database Analyst 10/94 to 11/96 : Completed Successful analysis, design and development of the Oracle 6 Logical, Physical, Function and Process Models to support crash testing within a HP UNIX environment. Environment: HP 9000/T50/K200, Unix, Windows, MS Office, MS Access 2.0, LABVIEW, Oracle 7, Database View, Oracle Designer/Developer 2000 And TCP/IP. Contracted to Detroit Edison Fermi II Nuclear Power Plant: Database/Systems Analyst 03/94 to 09/94 : DOE Security Clearance issued Project Leader responsible for planning, analysis, design and development of an Oracle cable routing management system. Utilized Information Engineering IE Business Process Modeling Methodology to capture customer Requirements. Used Oracle Case 5.0 tools to capture and store the Logical, Physical, Function and Process models. Environment: Oracle Case 5.0, IBM OS/2, Windows, MS Project, MS Office and IE-EXPERT.

Confidential

Project Leader/Hardware Task Manager

Planned, designed, and developed hardware, Graphical User Interfaces GUI , Data Communications Interfaces and Video Interfaces for 3 types of Special Operation Forces Aircraft Training Simulators SOFATS in accordance with Military Standards Mil-Std in a SUN, UNIX environment. Managed 8 engineers using MS Project for project planning. Environment: SUN, Unix, C, ADA, AUTOCAD v10, MS Office, Kermit, Ethernet, TCP/IP and FTP Utilities.

Confidential

Software Engineer

Designed, developed, integrated, tested in accordance with Mil-Stds and following SDLC methodologies the following: real-time embedded software for C-141, C-5, C-17 military/ Boeing 737-300 commercial aircraft Flight Management Computer Systems and P3-C, P3-P anti-submarine warfare systems Software primarily developed in VAX mainframe environment using FORTRAN, ADA, and Assembly Languages. Environment: VAX/VMS, IBM 370, Assembly, ADA, JOVIAL, FORTRAN, C, Pascal, Configuration Management System CMS , Structured Analysis, Structured Design, CADRE Teamwork Case Tools.

Hardware/Software Experience:

• Database related Oracle 11g, 10g 9i, 8i, 7, 6 Oracle Designer 10g, 9i, 6i, 2000 Oracle Developer 10g, 9i, 6i, 2000 Oracle Case Tools 5.1 Oracle Forms 4/Reports 2.5 Sybase Replication 11.0.2 Sybase 11.5, 11 Dbartisan DB Administration tool Platinum DB Monitoring tools MS SQL Server IBM DB2 Teradata SQL PL/SQL SQL Plus TOAD 9.1
• Development Tools Sparx Enterprise Architect v10, SAP Powerdesigner 16.1, ERWIN 7.3 SAP Business Objects Universe Designer 12.3 MS Office Visio PVCS Informix 5.08 ODBC FTP Assembler Ada Jovial C Labview Cobol Basic DCL McLeod Loadmaster AutoCAD 10.0 EDI Qualcomm TCP/IP
• Hardware Platforms IBM AIX v4, OS/2, Risc 6000 Sun Openlook, Sunview, Sparc, IPC VAX/VMS, VME, 11/750, 8600 HP/Unix v10, 9, 4 Concurrent 7550 Honeywell CP-6 MS Windows Macintosh
• Methodologies/Management Unified Modeling Language UML 2.02, Defense Architecture Framework DoDAF 2.0, Software Development Methodology SDM Zachman Framework Information Engineering IE methodology MS Project