We provide IT Staff Augmentation Services!

Data Architect Resume Profile

5.00/5 (Submit Your Rating)

Experience Summary

  • All of my architectures for the last 17 years have been object oriented OO , before it was a Buzz word. The same can be said of my architectures over the last 9 years in terms of service oriented architecture SOA . In architecting a system, several architectures need to be developed and integrated. In all subsequent project descriptions, architecting the systems includes the development of the following architectures and most importantly, their integration: Functional business , Data information , Organization, Software application , Hardware technology , Procedural business rules and Security. I have architected some of the largest data stores in the country, including the hundreds of terabyte databases at the Defense Logistics Services Center DLSC in Battle Creek, MI which only handles the entire inventory supporting the US Department of Defense DoD . I have an unblemished track record of success as a project manager and developed a multi-dimensional software development management model SDMM based upon 5 different levels of project complexity for the USAF Project Management Institute for the Denver Research Institute. Spent over 2 years researching various project management methodologies under a 2 year contract with The Denver Research Institute DRI under a USAF contract. The end result was a multidimensional software development management model SDMM . Based upon 5 levels of increasing complexity, the SDMM provides me a roadmap for developing any project plan in an amazingly short amount of time. I have an unblemished track record of success as a PM. The use of the SDMM allows me to move quickly from the project planning and actually start work on the enterprise and data architectures. Working with teams of architects I have architected some of the largest, most complex IT systems for Nationwide Insurance, the FBI, several for the USAF, Chase Home Finance, JP Morgan Chase, National City, Defense Finance and Accounting Service DFAS and Defense Logistics Agency DLA .
  • I performed as a project manager, business analyst, data architect logical and physical data modeling and Master Data Management MDM , BI/DW Expert, enterprise architect, technologist and project manager for over 20 years. I pride myself in staying hands-on in all technologies so I can hit the ground running. I provided presentations to the US Senate and officials in the DOD and FBI and NSA. I wrote contracts with large corporations, Siebel, SAIC, Northrop Grumman, EDS and federal and state agencies.

Technical skills:

Project Manager/Business Analyst/ Architecture/ BI/ Data Warehousing/Operational Data Stores ODS - Leadership and team-building skills Excellent motivation and mentoring skills Excellent project methodology and process background Business Analysis Rational Tools Rational Unified Process, JAD Sessions, Master Data Management, Applied the DoD SDLC to projects in commercial as well as government, Agile, eXtreme programming, SOA. Database and related: Oracle, DB2, SQLServer, Informix, UDB, IMS, PLSQL, Teradata, Logical and Physical Data Modeling, Master Data Management. Operating Environments: IBM Mainframe 3000, OS390, COBOL, IMS, DB2, VSAM, Assembler, CICS , UNIX Solaris, AIX , CITRIX, Windows. Development platforms: J2EE, Mainframe COBOL, Assembler, VSAM , SAP, BizTalk, Siebel, SAS Product Suite Enterprise, etc. , PeopleSoft, Oracle Financials. J2EE, OBIEE, Essbase, Hyperion Planning and Web Technologies. I used Java, Enterprise JavaBeans, XML, WebSphere, Weblogic, JSP, Servlets, HTML, ActiveX, SGML, UML, BEA, .Net, Visual Basic. Tools/Middleware/Packages/Standards: ExtremeX, Erwin, Rational Rose, BizTalk, Enterworks Virtual DB, Information Builders Enterprise Data Architecture, Informatica, Informatica CDE, Cognos, Brio, SCOR, Crystal Reports, Business Objects, MicroStrategies, Autonomy, Enterprizer, Erwin, Designer 2000, Oracle ES, MQ Series, CORBA, DCOM, COM, W3C. Test Planning/Execution- Have written User Acceptance Test Plans and Test scripts and test procedures. Have lead teams in developing system and integration testing. I have designed Usability Test Labs for OCLC products.

EXPERIENCE

Confidential

Project Manager/Sr. Business Analyst /Lead Technical Architect

Developed the project plan and schedule for this KMCI project. Developed the Semantic SOA and the Federated EDW a distributed data architecture managing hundreds of terabytes of data distributed global across the USAF Enterprise in support of the USAF Global Combat Support System for the KMCI 8a Minority Owned Set aside contract. Led the writing team and was principle author for two entire proposals for the NETCENTS 2 USAF Contract Vehicle Project and the USAF Global Combat Support System GCSS Project. Developed the Master Data Management Plan in support of the GCSS proposal effort. Developed the procurement strategy and Procurement Plan for the project. I developed the project plan and schedule for deliverable development. Performed as the lead Business Analyst and Lead Technical Architect Lead Technical Architect includes performing as both the Enterprise Architect and the Lead Data Architect to define the requirements and develop the Semantic SOA utilizing OBIEE concepts for the USAF Enterprise SOA and Federated Enterprise Data Warehouse including an Operational Data Store ODS . I utilized Cloud Computing concepts such as Software as a Service SaaS and Platform as a Service PaaS in the development of the Semantic SOA. Functioning as the Lead Data Architect I developed a USAF Enterprise Logical Data Model for inclusion in the GCSS Requirements Specification and then developed the Physical Data Model and Federated EDW architecture. Developed a similar proposal for the FBI Sentinel Project and used a COTS Integration Architecture as the solution. In my Business Analyst capacity I modeled the as is system and then defined the requirements for the to be system for both GCSS and Sentinel..

Confidential

As Sr. Business Analyst / Lead Data Architect

I utilized ERWIN to develop the logical and physical data models for the USAF Shared Data Warehouse SDW . I stay very hands-on in my role. Developed the Project Management Plan PMP for the USAF NETCENTS 2 Project including sections covering all project aspects, a complete SDLC including the project management approach, the organizational structure I created a concept I named SWAT Teams, small, elite groups of experts assigned definitive tasks that they could accomplish successfully very quickly and provide the contractor and USAF a great deal of flexibility and success. , systems engineering approach, governance approach, test approach, QA and CM approaches, tools approach and recommendations such as Sharepoint for use implementing the governance requirements and required support activities. Developed the Project Procurement Plan utilizing Peoplesoft. I developed a draft SOA and methodology to construct it. Developed a draft Master Data Management Plan and implemented the Master Data Management approach.

Confidential

As Project Manager/Sr. Business Analyst

I was hired to develop and lead the technical and management sections of two USAF Proposals, Enterprise Information Management System EIMS and the Global Force Management System GFMS . I was named the Project Manager for the proposal effort and developed the proposal plan, schedule and defined the resource allocations. I developed the engineering and IV V methodologies for both proposals. I defined the requirements, developed Logical and Physical Data Models for data stores consisting of hundreds of terabytes od data, and developed SOAs utilizing Cloud Computing and OBIEE Concepts and the architecture for an Enterprise Data Warehouse EDW and Operational Data Store ODS . I developed the System Engineering Management approach with outlines for the SEMP and the IV V Plan. All work was done on a UNIX platform. Ensured all approaches and methodologies were in compliance with IEEE standards and CMM requirements. Ensured the SOAs would integrate seamlessly into the USAF Enterprise SOA that I had previously developed under a different contract potentially saving the USAF millions of dollars in development costs

Confidential

I worked as a business analysis defining requirements for a Business Development Plan and a Procurement Plan utilizing Peoplesoft. I executed the plans, meeting executives, describing KMCI capabilities, writing technology white papers on Cloud Computing and OBIEE concepts and supporting proposal efforts. Secured contracts for KMCI with SAIC and Lockheed Martin.

Confidential

Paros Partners/State of Ohio Treasurer Project Manager/Business Analyst

  • With a new Treasurer and staff in place, the State Auditor noted security discrepancies from the previous administration that needed to be addressed by the end of the current fiscal year, June 30, 2008. I was brought in develop and execute the project plan to assess the security architect on their mainframes, AS400s and servers, Sun Solaris and network access and database access and application access. The department satisfied all Auditor requirements for the new fiscal year. Develop the Business Intelligence BI Roadmap utilizing Cognos/Cognos Enterprise Planning and Business Objects. Working directly with CFO
  • Developed an SOA data architecture for the Global Combat Support System GCSS including an enterprise data warehouse EDW and Operational Data Store ODS .
  • Developed new Procurement Plans and Procedures.

PM, Architect, Data Architect, BI Expert, Technologist, Developer or Business Analyst

Confidential

  • Developed a white paper documenting a data architecture that integrates a Teradata EDW into a federated EDW consisting of hundreds of terabytes of data.
  • Developed a presentation with a plan to justify and perform an assessment of the GCSS EDW.
  • As project manager developed a project plan, resource allocations and schedule to perform the assessment.
  • Developed a procurement/acquisition plan and procedures
  • Reviewed the USAF SOA Requirements Spec, the Metadata Catalog MDE requirements and preliminary design.
  • Developed a Master Data Management Plan for theTeradata EDW platform.

Confidential

  • Was responsible for the data architecture for an integrated enterprise warehouse and supporting datamarts for a major US Air Force project involving hundreds of terabytes of data
  • Developed a project plan including schedule, tasking, deliverables and resource allocations
  • Managed the team of data modelers
  • Develop the Business Intelligence Tool Roadmap for the future
  • Developed database design specs
  • Developed architecture presentations for senior management and USAF staff
  • Developed a draft Master Data Management Plan that I later used as the foundation for my Teradata efforts

Confidential

  • Developed project plan to develop an international broadcasting network via satellite
  • Developed a procurement plan for acquisition of satellite capabilities
  • Developed the requirements specification for satellite technology platforms, programming/production platforms, server platforms for editing and commercial development, operations center requirements
  • Developed test plan and test procedures
  • Developed data model and data architecture for programming management
  • Work was done on a UNIX platform

Confidential

  • Managed a wide area of technology projects
  • Developed tasking, deliverables, schedules and resource allocations
  • Developed a capacity management department including process, procedures, metrics and staff
  • Was the project manager for a major storage replacement/upgrade for the Nationwide subsidiary Allied's data center in Des Moines
  • Was the project manager for a Novell IDM2 upgrade to the entire password/ID directory system using Identity Vault
  • Was project manager for the Peoplesoft ERP upgrade to Version 8.9
  • As Project Manager, I developed all project plans, determined schedule and deliverables and performed resource allocations
  • Evaluated Teradata data warehouse design, developed data model and distributed data architecture for Oracle 7i/8i/9i datamarts involving hundreds of terabytes of data, developed ETL requirements using Informatica, developed Business Intelligence BI requirements for Microstrategies and Business Objects
  • Developed and implemented the MasterData Management Plan

Confidential

  • As the Project Manager I developed all project plans, defined deliverables, determined schedule and resource allocations
  • Developed Use Cases for a bio-terrorism alert system under a Homeland Security Grant
  • Developed the data model and data architecture for the alert system
  • Developed the Functional Specification for the alert system
  • Evaluated vendors of alert system technology
  • Developed a Procurement/Acquisition Plan for acquiring vendors
  • Developed the Business Intelligence interface for the alert system utilizing Autonomy and Microstrategies
  • Mentored ODH staff in technology and methodology
  • Work was done on a UNIX platform

Confidential

  • As Project Manager, I developed project plans, defined deliverables, determine schedule and resource allocations.
  • Developed the business plan for a joint venture with Pittsburgh International Telecommunications PIT for ethnic broadcasting, wireless telephone and VOIP with PIT satellites
  • Developed marketing and sales plan for joint venture
  • Developed financial plan and CRM strategy for Alpha TV
  • Developed Procurement/Acquisition Plan for satellite capabilities
  • Performed CRM for 16 different international companies, including broadcasting TV and Radio , VoIP, wireless phone and wireless Internet
  • Wrote 16 international contracts

Confidential

  • Developed a RUP based project plan for a conversion effort from CICS/COBOL/VSAM to a COTS Solution running on Oracle 9i
  • Defined schedule, deliverables and resource allocations
  • Built the data modeling team and built the to be data model and data architecture
  • Developed the Requirements Specification
  • Provided Informatica 7.1 training
  • Developed/architect/designed new claims management system for Anthem Life Insurance products.

Confidential

  • As project manager, developed project plan, determined deliverables, determined schedule and resource allocations
  • Led the architecture team that architected/design/developed of a data access layer utilizing a SOA approach
  • Developed application and data architecture for a data warehouse Defined requirements for ETL, Informatica 7.1, developed Informatica replacement design for over 180 stored procedures to populate the Operational Data Store ODS and Retail Data Warehouse RDW and developed Informatica training program Developed project plan based on RUP
  • Led the team of analysts in developing use cases, activity and communications diagrams
  • Developed logical data model using ErWin
  • Developed SQL Server physical database
  • Evaluated Stored Procedures and replace them with Informatica
  • Wrote SQL queries to determine data quality
  • Developed BI interface using Microstrategies
  • Developed Draft Master Data Management Plan which was later was implemented under a different project

Confidential

  • Developed the enterprise and data architecture for the US Dept of Treasury for a data warehouse system integrating 12 legacy IRS data bases containing hundreds of terabytes of data
  • Developed a RUP based project plan in Hyperion Planning
  • Defined deliverables, schedule and resource allocations
  • Led the team of analysts in developing use cases, activity and communications diagrams
  • Developed requirements for the Financial Criminal Enforcement Network Fin CEN
  • Developed a J2EE OO Architecture to integrate 12 legacy IRS systems
  • Developed presentations for US Treasury executives
  • Developed BI interface for IRS legacy applications.
  • Developed Procurement Plan for new applications linked to Requirements Specification

Confidential

  • Developed RUP based project plans and developed the architecture/design and requirements specs for 5 projects in the Speed to Market Initiative
  • Determined schedules, deliverables and resource allocations
  • Developed Nationwide Finance Agent Gateway architecture and Agent Gateway CRM interface.
  • Led the team of analysts in developing use cases, activity and communications diagrams
  • Led a team of data analysts to develop a Master Data Management Plan
  • Developed queries to extract Teradata property information into the Short Term Property Data Base STPDB , in Oracle 9i.
  • Optimized MicroStrategy queries.
  • Mentored senior staff in use case development and process engineering
  • Mentored senior technical leads in J2EE OO methodologies
  • Provided Informatica architecture to move data from the Teradata warehouse to Oracle 7i and 8i datamarts per business unit, auto, P C, and life and annuities

We'd love your feedback!