Summary

Over thirty years of experience in a broad range of applications and environments. Experience in application network interfacing, connectivity and information engineering is evident. Such diversity of experience is demonstrative of the versatility of this individual.

Knowledge and Experience

Applications

Project Experience

Confidential

• Acted as the data architect for the data conversion team on the Health Exchange project for the State of Arkansas. Defined the approach that the team was to use for integration of the state's systems with the Curam Social Program Management Program Curam .
• The source systems resided on IMS and VSAM platforms. Each source system and Curam were documented with a source system description for the state systems or a data dictionary for Curam . This documentation was then used to develop physical data models for each data interface. These physical data models were then used to develop a corresponding logical data model. An evergreen Common Integration Model CIM to support the re-use of the various data interfaces was started. The CIM is used to develop a Canonical Model for use by the integration implementation teams.
• Developed source system descriptions, physical data models, logical data models for data sources that were to be integrated with. Began development of the CIM.
• System Environment: Windows 7, Rational Software Architect, VB.net, MS Office

Confidential

• As a subject matter expert, participated in a research project in semi-automated taxonomy generation. The objective of the project was to see if a tool could take Entity, Attribute and Relationship definitions, analyze them, generate a taxonomy and then create Entity Relationship Diagrams reflecting the generated taxonomies.
• As a developer, designed and implemented a tool in VB .net that used ERwin API to take the generated taxonomies and automatically create Entity Relationship Diagrams.
• As a participant reviewed the interim results with the Enterprise Data Architecture unit of the sponsoring organization.
• System Environment: Windows Vista, Excel, Word. VB .Net, Powerpoint, Erwin, StarUML, FreeMind, Protege

Confidential

As an enterprise data architect, established a strategic approach that resulted authoring of an enterprise data framework, integration of the framework with specific implementation models ensuring the development of the necessary generic structures required to support flexible, scalable, reusable systems. Also developed the strategy and approach for the implementation of enterprise meta-data management. System Environment: Windows XP, Word, Excel, MS Access, VB .Net, Erwin, Rational System Architect, Provision, Eclipse EPF, IBM Business Glossary.

Confidential

• As a senior business data information architect, authored methodologies and processes for: business process modeling, object modeling, model management and entity relational modeling. Developed documentation and training materials for use by business analysts, object modelers and data modelers. Advised the director on strategic objectives and challenges. Conducted tool evaluations and mentored other architects and modelers.
• System Environment: LAN, PC workstation, Unix servers, , Windows XP, Word, Excel, Erwin, EPF Composer, XMLSpy, Webshpere Business Modeler, Rational Software Architect, Power Designer, CVS and Eclipse.

Confidential

Acted as a senior consultant in the Strategic Data Consulting group within ExxonMobil. Defined strategies and approaches for XML / EBXML based Enterprise Application Integration. Assisted application development groups in the adoption and use of XML based canonical structures for the transmission of information between diverse applications around the enterprise. Built tools to extract information from XSD files and build documentation spreadsheets. System Environment: LAN, PC workstation, Unix servers, DB/2, MS Access, Oracle, Windows XP, Word, Excel, Erwin, EPF Composer, SharePoint, XMLSpy, BizTalk, SAP/XI.

Confidential

• Participated in the Merchandising System Transformation project as the lead data architect for the Store clustering, Item planning and Assortment team. Assisted the SIA team in developing structures and determining sources for the Operational Data Store. Developed enterprise data standards and integration strategy. Models were developed using the Erwin tool. Wrote API utilities utilizing the Erwin SCAPI interface.
• System Environment: LAN, PC workstation, DB/2, MS Access, Oracle, MySQL, Windows XP, Word, Excel, Erwin.

Confidential

Worked with the VP of product development to develop enterprise business models. Assisted the Systems Development department in utilizing the business models to develop non-redundant physical implementations. Utilized the ER-Studio api to develop specialized reporting tools. Hibernate was utilized to map Java classes to tables. EPF Composer was utilized for the Data Architecture processes. System Environment: LAN, PC workstation, Unix servers, DB/2, MS Access, Oracle, MySQL, Hibernate, Windows XP, Eclipse, Word, Excel, ER-Studio, EPF Composer.

Confidential

• Participated in the planning and development of an integrated data strategy to support the Common Application Integration initiative. Two companies had merged to form the Yellow Roadway Corporation. The strategy had to address issues of data integration in a diverse and geographically dispersed environment.
• Also worked with the development teams to develop application level models. Participated in a project to migrate models from one ModelMart server to another. Developed various Erwin API tools. Developed the an EDI based interface with the U.S. Customs' Automated Manifest System.
• System Environment: LAN, PC workstation, IBM mainframe, Unix servers, DB/2, MS Access, Oracle, MS SQL Server, Visual Basic, Windows 2000, Word, Excel, Erwin, ModelMart

Confidential

Filled the role of lead data architect on an Enterprise Application Integration EAI project. The EAI middleware utilized on the project was SeeBeyond Logical structures were developed utilizing Rational Rose. These structures were exported from Rose in XML format and imported into SeeBeyond as Entity Type Data ETD structures. Also advised the Data Systems Reporting group on the development of their data warehouse. Logical models and Star Schema's were developed utilizing Erwin. Implemented a model management infrastructure based on ModelMart. System Environment: LAN, PC workstation, IBM mainframe, DB/2, MS Access, Teradata, MS SQL Server, Visual Basic, Windows 2000, Word, Excel, Rational Rose, Erwin, ModelMart

Confidential

• Functioned as the lead data architect on a large 150 people project to develop and implement a Clinical Information System CIS . As lead architect, developed and implemented data modeling methodology utilizing Rational Rose. Built tools in Visual Basic utilizing the Rational Rose Extensibility Interface to carry out gap analysis between the different models for various releases. Was responsible for mapping the logical model to the different implementations.
• System Environment: LAN, PC workstation, IBM mainframe, DB/2, MS Access, Visual Basic 6.0, AIX, Windows 2000, Word, Excel and Rational Rose

Confidential

• Assisted the process modeling team in gathering and organizing information requirements. Developed a tool to organize and track information on the process scenarios, objects and data sources. Provided recommendations with regard to data and process modeling approaches.
• System Environment: LAN, PC workstation, IBM mainframe, Oracle, DB/2, MS Access, Unix, Windows 95, Word, Excel and Silverrun

Confidential

• Acted as a methodologist in a data mapping effort. Designed and implemented procedures for mapping interface data between legacy systems and a new AllTel implementation. Developed procedures to identify and define target and source data, map logical attributes to the target data, map migration paths between target and source data and document the transition logic between the source and the target.
• System Environment: LAN, PC workstation, A/S 400, IBM mainframe, Oracle, MS Access, Unix, Windows 95, Word, Excel and Select SE

Confidential

• As a certified product specialist and instructor for ERwin, BPwin and ModelMart, developed strategies for implementation of the tools and methodologies. Developed customized curriculums for specific client needs. Taught both customized and standard classes. Developed specialized applications utilizing the ERwin API.
• System Environment: LAN, PC workstation, A/S 400, HP, IBM mainframe, DB/2-400, Oracle, SQL Server, MS Access, OS/MVS, OS/400, Unix, Windows 3.1, Windows 95, Windows NT, TSO, ISPF, Word, Excel, ERwin, BPwin and ModelMart.

Confidential

• Developed an activity centered data architecture and a process architecture for automated data extraction. Authored a recommendation regarding the participation of the data management organization in the technology review process. Participated in a modeling effort for the development of an enterprise wide shared reference table. Drafted processes for the participation of the data management organization in the MIS solution delivery process. These processes complied with the Software Engineering Institute's Capability Maturity Model.
• System Environment: LAN, PC workstation, A/S 400, HP, IBM mainframe, DB/2-400, Oracle, SQL Server, MS Access, OS/MVS, OS/400, Unix, Windows 3.1, Windows 95, Windows NT, TSO, ISPF, Word, Excel and ERWin.