dma2.gif (5195 bytes)Data Mining & Analysis, LLC

logo2.gif (5725 bytes)

Home Profile Services Staff Resources News Case Studies Feedback Contents Search

 

Information Architect

Overview

Seventeen years of experience in managing, designing, modeling, developing and implementing Data Warehouses, System Integration Planning and Coordination and Knowledge Based Decision Support applications. Delivered business solutions in Financial Services, General Ledger, Accounts Receivable, Oil and Gas, Retail and Healthcare industries. Expertise includes: Information Engineering Methodology (IEM), Business Process Engineering techniques, Client/Server architecture design, CASE tools (Power-Designor, ERwin, Key for Enterprise, IEF) and project management tools.

Ability to work as a project leader, client liaison, team member, and individual contributor. Technical expertise includes: Information Engineering Methodology (IEM), IDEF1, Business Process Engineering Techniques, Client/Server environment and architecture (UNIX, Sybase, Oracle), DB2 and COBOL IMS DB/DC programming and utilities, SQL, QMF, TSO/ISPF, Sterling Software's Key for Enterprise (ADW), IEF / Composer , Logic Works Erwin, and Sybase's Power-Designor C.A.S.E. Tools.

 

Technical Summary

Software

Databases -- Oracle, Informix, Sybase, DB2, IMS DB/DC, Microsoft Access

C.A.S.E. Tools -- Logic Works ERwin / BPwin, Sybase Power-Designor, Key for Enterprise (ADW) (Planning, Analysis and Design), Information Engineering Facility (IEF) / Composer (BAA through Implementation), High Productivity System (HPS)

Languages -- SQL, Visual Basic, COBOL II, QMF, SPUFI, SAS, FOCUS, EASYTRIEVE PLUS, Fortran, PL/I

Project Management -- MS Project for Windows, Project Workbench, ACT!, Defect Control System (DCS), SureTracker

Operating Systems -- UNIX, Sun Solaris SVR4, OS/MVS(ESA/XA)

Applications -- Microsoft Windows '95 (Word 7.0, PowerPoint 7.0, Excel 7.0, Access 7.0), Visio, Telnet, OS/2, TSO/ISPF, WordPerfect, SPF/PC, Lotus, Freelance, AmiPro

 

Professional Experience
GTE Communications Corporation 07/97 - present

Data Warehouse Consultant

  • Designed a logical and physical Oracle Data models to support Order Entry, Capacity Management and Customer centric subject areas.
  • Facilitated user sessions of business experts, developers, senior managers and telecommunications consultants to gather, group and define business, historical and trending requirements.
  • Participated in developing corporate methodology, modeling standards, and abbreviations for development environment.
Analysts International Corporation 07/96 - 08/97

Business Development Manager (consultant)

Responsible for identifying project related work in the Dallas / Fort Worth area for Analysts International Corporation (AiC). Created marketing plan, feasibility approach, proposal generation, executive management presentations, winning contracts, recruiting development staff and transitioning project to full-time project manager.

In six months won $2,873,000 in professional contracts in:

  • Object Oriented project to develop a real estate forecasting system ($520,000, 12 staff)
  • Outsourcing of Quality Assurance functions for a software vendor ($1,216,000/year, 14 staff)
  • Outsourcing software maintenance duties for a IT organization (357,000, 4 staff)
  • Client/Server Migration Project for an IMS and DB2 system to Oracle (635,000, 6 staff)
  • Data Warehouse/Data Mart for a credit retail company to analyze bad debt (145,000, 4 staff)
NationsBanc Information Services 08/96 - 11/96

Data Warehouse Manager (consultant)

  • Implemented a Data Warehouse environment in 75 business days that integrated an Asset Management systems environment. This allowed the end-user to view customer centric and bank-focused information for client assets, real estate, securities, bonds, trusts, 401k and IRA at the account level.
  • Facilitated user sessions to gather, group and define business, historical and trending requirements. Duties included: project management of a eight person team, logical and physical data modeling of 578 source data elements, data transformation and extraction rules, database design, implementation and designing user reports.
Associates Corporation of North America 02/96 - 08/96

Data Architect

  • Designed a logical and physical Oracle Data Warehouse structure to consolidate, integrate and centralize 95 existing legacy systems.
  • Facilitated user sessions to gather, group and define business, historical and trending requirements.
  • Assumed project manager responsibility to administer project plan regarding data sourcing, acquiring new hardware and software and decision support tasks.
  • Identified business and data requirements to consolidate and integrate legacy data into a centralized Data Warehouse which reduces the amount of redundant data corporate wide.
  • Defined separate requirements for building an Operational Data Store (ODS) and Data Warehouse to support the business' operational and historical information needs.
  • Identified phased implementation approach to deliver business value in 12-week increments to create client excitement and prove new technology and concepts to the business community.
Associates Corporation of North America 10/95 - 02/96

Information Architect / Migration Planner

  • Developed an enterprise wide migration plan for the Associates' Commercial line of business. This plan serves as the road map for all future systems development within this division.
  • Created a business model, current systems inventory and business precedence document for senior management to approve and authorize funding.
  • Developed a conceptual data and process model to be used to identify business requirements and identify existing "functional gaps" in legacy systems.
  • Created the migration plan and presentation for senior management to understand business, hardware, software and funding requirements.
  • Obtained approval to implement $1.35 million dollar Data Warehouse project.

 

Lewis Medical Informatics 1994 - 1996

Information Architect / Product Developer / Consultant

  • Designed and implemented a Clinical Data Warehouse to identify, capture and manage Patient demographic information for use by multi-hospital organizations. In order to support various customer-marketing strategies, this product was implemented in Oracle, Sybase and MS/Access environments.
  • Identified business requirements, data and functional definitions for identifying medical, financial and historical information about a patient that became a software product to market.
  • Designed the application to leverage existing credit information from TRW to support and target new market segments that hospitals are trying to penetrate.
  • Presented technical sales presentations and provided sales support for potential clients (CEO, CIO, Project Managers, DBA's and developers) resulting in additional sales worth $200,000.
Ameritech Health Connections 1993 - 1995

Data Architect / Product Analyst / Consultant

  • Worked with Product Management, R&D, Customers and Industry Consultants to develop a Clinical Data Warehouse using IEM/IEF and Sybase's S-Designor CASE tools. This was implemented in a UNIX, SYBASE environment.
  • Interviewed 11 different management and user groups to collect, evaluate and perform a feasibility study for the Client/Server Knowledge Keystone Product.
  • Using IEM Data Modeling and analysis techniques, developed a logical Clinical Data Warehouse consisting of 211 logical entity types. Designed and implemented a 107 table Data Warehouse in a UNIX SYBASE environment.
  • Developed a Hospital Clinical Communications Operational Data Store consisting of 207 logical entity types that interfaces with the existing Clinical Data Warehouse and OLTP.
Fidelity Investments Systems Company 1992 - 1993

Technical Analyst / Consultant

  • Developed and implemented a 56 table DB2 based Fixed Assets Application.
  • Used High Productivity Systems (HPS) CASE methodology to perform a feasibility analysis, and as the Facilitator of a JAD session developed a High Level Functional Decomposition and process modeling for the project.
  • Developed infrastructure for Systems Group to use in the tracking of Fixed Assets.· Created 65 programs and batch load schedule to extract inventory information from various computer platforms (Excel, VM, SAS, and TSO).
Mobil Oil Corporation 1988 - 1992

IEF BSD Technical Analyst 1991 - 1992

· Participated in the development of a General Ledger Business System Design through Construction using the IEF CASE Tool within the OS/2 environment.

· Developed four BSD Dialog Flows equating to 24 screens and programs from the Activity Hierarchy, including Screen Design, and writing Procedure Action Diagrams (RADs), code generation and unit testing.

· Uploaded, packaged, compiled and completed system and acceptance testing on the mainframe Central Encyclopedia, with client acceptance and sign-off.

IEF Model Administer 1990 -1992

· Responsible for the management and integrity of the General Ledger and Accounts Receivable Central Encyclopedia (CE) models.

· Scheduled, coordinated and executed eight separate model migrations between the PC platform and the CE thus monitoring the integrity of both data and activities.

· Provided CE Subsetting for 14 analysts across multiple projects.

IEF BAA Technical Analyst 1988 - 1990

· Participated in the development of a Controller's General Ledger and Account Receivable Business Area Analysis (BAA) through confirmation.

· Performed Data and Activity Analysis of a General Ledger Business Area to develop an Entity Relationship Diagram (ERD) with 92 entity types.

· Created and modified 180 Functions and Processes in the Model's Activity Hierarchy. Created 110 Process Action Diagrams (PADs) for the Accounts Receivable model in one month.

Project Leader 1988 - 1990

· Responsible for developing an IMS/DB2 based system that captures current systems information to be used during the Business Area Analysis confirmation phase.

· Constructed, tested, and implemented a 26 table system within eight weeks, on time and under budget.

· Identified general and detailed design specifications, project scheduling, and task assignments for 4 analysts, to meet aggressive delivery dates. Developed and conducted user training for 60 analysts.

Frito-Lay, Inc. 1984 - 1988

Project Analyst / Project

· Developed 25 interactive D2 processes for volume line items, expense costs, manufacturing requirements and marketing trade promotion calendars, thus able to forecast and track various scenarios under dynamic business conditions and client requirements.

· Developed MIS department standards for Data Modeling, analysis and design that are used by all project teams developing or enhancing applications.

· Responsible for a Cost Accounting Manufacturing system in which 67 short term enhancements were implemented using IMS DB/DC. Primary interface with 8 clients, on call for troubleshooting system abends and system recovery to ensure accurate and timely information.

Texas Instruments, Inc. 1980 - 1984

Project Leader / Software Analyst

· Responsible for the daily support efforts of a manufacturing application that described in detail the process of building various products for government contracts using IMS DB/DC skills. Involved in daily customer interface, multi-tasking of user problems and system troubleshooting. Identified corrective actions for system recovery and prioritized task for 4 analysts.

Education

B.S., Computer Information Sciences, Trinity University, San Antonio, Texas 1980

Secondary major in Business Finance