Forty seven YEARS OF information systems architecture, design requirements, documentation and DEVELOPMENT EXPERIENCE on Microsoft and IBM software platforms.

• Criminal Justice Information Systems Domestic Violence, NIBRS Reporting, Law Enforcement RMS, Jail Management, Court, Prosecution, Probation and Parole
• Government Welfare Systems WIC, Food Stamps, Child Welfare, Child Care, TANF, AFDC, Welfare to Work, Workforce Education
• Data Warehouse Dimensional Modeling, Star Schema, ODS, and Cube
• Property Casualty Insurance Systems

HRMS

• Healthcare Information Systems HIPAA, Outcomes, Charges, Claims, Patient Accounting
• CASE - Data and Process Modeling Tools
• OO Systems Design Rational Enterprise Suite, Paradigm Plus
• JAD Facilitation
• Client Server Design Implementation Microsoft DNA
• Relational Database Modeling and Design
• Business Process Re-engineering and Modeling BPR, BAA BSD
• Object - Relational Data Mapping
• Zachman Framework

Client Server and Web Environment:

• SQL/SERVER 4.3, 6.0, 6.5, 7.0, 2000 - 2012
• Oracle 8i
• Windows NT, 2000, 98
• Microsoft Office 95- 2000 Word, Excel, PowerPoint
• MS Project
• MS Visio
• DB2/2, DB2 UDB NT Platform
• Visual Studio 6.0, Visual Basic 5 6
• Visual InterDev 6, ADO, ASP, COM
• VBScript, JavaScript
• HTML, DHTML, XML
• Internet Information Server IIS 4.0, 5.0
• Microsoft BackOffice
• ERwin Data Modeling
• BPWin Business Process Modeling
• Paradigm Plus OO Modeling
• Rational Rose OO Modeling
• RUP Rational Unified Process
• Rational Enterprise Suite
• Visual Modeler
• Visio Professional 5.0, Visio 2000 2013 Enterprise
• JAD Facilitation
• ColdFusion 4.5.1
• Platinum Repository / MVS Metadata
• Microsoft Repository Metadata
• JAD Facilitation
• Data Dictionary, Meta Data
• Data Flow Diagrams
• Mainframe Environment
• CICS/MVS
• DB2 MVS
• MVS/ESA
• IMS/DB
• COBOL II COBOL/370
• Bachman DBA for DB2
• Bachman Analyst
• IEF/IEW/LBMS Case Tools
• MVS / TSO / ISPF/PDF
• JCL MVS VSE
• CSP Mainframe PC
• QMF
• SMS Shared Medical Systems

Confidential

• Managed a staff of 10 developers that under my leadership we did the following:
• Designed and managed development of a universal shelfStrips engine that was successfully implemented by a number of Vestcom shelfStrips customers
• Did the initial design work on the new Universal Composition Engine UE2
• Provided a ground work of back office products for shipping, pick pack and billing
• Designed and developmental the developer's time keeping subsystem based on Microsoft Project Server. The system reports on billable customer projects, SOP98 eligible Projects, Non billable customer projects.
• Designed and managed the development of a ISMAds campaign management system
• Designed and managed the development of a combobulator that enabled a potential customer to process data in a service bureau mode that emulated their processing in a local store mode. It should be noted this was developed using a User Manual was the only documentation the customer provided.

Confidential

Managed a staff consisting of 11 IT professionals: DBAs, DB Developers and Business Intelligence developers.

Some Accomplishments:

• Cleaned up a neglected SQL Server environment that had been neglected for over 18 months. This resulted in increased performance and throughput of the SQL Servers.
• Developed a database engine environment for several key company customers to process large volumes of data and convert it into company products. The processing volumes are in the millions of records per process and within tight SLA timeframes.
• Formed a company Business Intelligence department within the department to utilize and extract key operational information that had been disregarded prior to the implementation of a series of Data Warehouses and Data Marts. The BI department captured and analyzed over 200 million transactions per day, combined that data with operational data extracted form printer log s and presented a picture of Waste, Unbilled products and missed SLAs to the head of operations.
• Because of my duration with the company, I was generally regarded by several of the IT developers and managers as the answer man when a problem arose. I spend a lot of my days answering question how a particular process works or its purpose.

Confidential

Key Accomplishments include:

• Database re-engineering and modeling using ERwin
• Data modeling for web-enabled systems using ERwin
• Data warehouse dimensional modeling using ERwin
• Architecting 'n' tier client server systems for Windows DNA Platform
• Business Process Re-Engineering using BPWin
• OO Modeling and Design using Rational Enterprise Suite.
• Client server system development using Windows DNA Platform
• State Government Systems Welfare, Domestic Violence, Victims of Crime, Workforce Education, WIC
• Custom application development

Partial Client List:

Confidential

Senior Analyst and Project manager designing and managing the development of shelfStrips products for a number of retail clients. My position expanded to the analysis and design of Print Management System and second generation product composition system, including all of the back office components necessary to support the business. January 2, 2004 I became a full-time employee with this same company.

Confidential

• Senior P/A and Project Manager Developed an Information Management and Data Warehouse System for a Therapy Center
• Environment: WINDOWS 2000, Microsoft Office, ERwin, JAD, BPWin, Rational Enterprise Suite, Visio 5.0 Enterprise Visual Studio .NET, SQL Server 2000, Exchange Server 2000, Access 2000, VBA, Microsoft Project, Medical Manager
• Duties Include: Extensive data modeling, JAD Facilitation, data analysis business process modeling. Features: Medicaid and private carrier insurance billing and authorization, EFT, eForms, extensive tracking system conferences, goals, progress reporting , web enabled access via internet or Intranet .

Confidential

• Senior P/A and Project Manager -- Contracted by Palavar to serve as project lead on a conversion from Access to VB 6.0 and SQL Server for a major producer of bar code labels in the Little Rock Area. Duties included developing data models, data and business process models, designing and implementing the system which produces bar code labels printed on strips of paper that fit in shelf edge channels.
• Environment: WINDOWS NT, 2000, Microsoft Office, ERwin, JAD, BPWin, Rational Enterprise Suite, Visio 5.0 Enterprise Visual Studio 6.0, SQL Server 7.0 and 2000, Access 2000, VBA, Microsoft Project.
• Duties Include: Data modeling, JAD Facilitation, data analysis and data modeling, Business Process Modeling, relational database physical design, Access to SQL Server 2000 conversion, VBA to VB 6.0 conversion, design of new barcode labels system and integration of this system into existing barcode print system.
• E-commerce Developer -- Contracted by Palavar to develop e-commerce system for a client Site operational 12/31/2002 customer continually changes mind .
• Environment: WINDOWS 2000, ERwin, Rational Enterprise Suite, Visio 5.0 Enterprise , Visual Studio 6.0, Visual InterDev 6.0, IIS 5.0, SQL Server 2000, Microsoft Project, Adobe Photoshop, HTML, DHTML, XML, VeriSign, Visual Basic 6.0, VB Script 5.0, Java Script.
• Duties Include: Designed, developed and managed the development of a Wine Exchange Web and e-commerce Site.
• E-commerce Developer -- Contracted by Palavar to develop e-commerce system for a BCBS of Arkansas intranet site Site operational 2/1/2003
• Environment: WINDOWS 2000, ERwin, Visio 5.0 Enterprise Visual Studio 6.0, Visual InterDev 6.0, IIS 5.0, SQL Server 2000, Microsoft Project, Adobe Photoshop, HTML, DHTML, XML, Visual Basic 6.0, VB Script 5.0, Java Script, Homesite, Clarus ePro.
• Duties Include: Designed, developed and managed the development of a Computer Hardware and Software e-commerce front end for ePro.
• Database Re-Engineering -- Contracted by Palavar to develop re-engineer several Access Databases into an MYSQL Database
• Environment: WINDOWS 2000, ERwin, Visio 5.0 Enterprise Visual Studio 6.0, Access 97, 2000, MYSQL, Crystal Enterprise 9.0, Microsoft Project, Visual Basic 6.0
• Duties Include: Designed the SQL Server database, DTS plans and turned project over application developer to complete.

Confidential

• Data Administration Consultant -- Contracted by BCBSFL to develop data models, data and business process models, data warehouse models dimensional modeling for various BCBSFL systems and business partner systems. JAD Facilitation is also one of my duties. So far, I have developed the HIPAA Claims and Codes repository models. Selected to serve on the DA / DBA standards committee, metadata standards committee
• Environment: WINDOWS NT, Microsoft Office, ERwin, JAD, BPWin, ModelMart, Visio 5.0 Enterprise DB2, DB2 Universal Database Server, SQL Server 7.0, Oracle 8i, CA Platinum MVS Repository.
• Duties Include: Data Warehouse design dimensional modeling , extensive data modeling, JAD Facilitation, IDEF1X, data analysis and data modeling, Business Process Modeling, relational database physical design.

Confidential

• Application Developer Sub Contractor Contracted to create a HLLAPI interface between a GUI based Operating Room System and a homegrown mainframe Patient Account System. Character based to GUI Based interface
• Environment: Rational Rose, NT Server 4.0, NT Workstation 4.0, and Visual Basic 6.0.
• Duties Include: Used Rational Rose to model the application, developed application in VB 6.0.

A Confidential

• System Developer Sub Contractor Contracted to convert Electric Harness System from FOCUS to Microsoft Access 2000. We had 45 days to complete the project.
• Environment: Rose, NT Server 4.0, NT Workstation 4.0, Visual Basic 6.0, MS Access 2000 VISIO Professional, Office Development and Integration.
• Duties Include: Re-Engineered the application within 30 days, primarily due to the use of Rose to produce Class and Use Case Diagrams, developed the application with the assistance of five sub-contract developers.

Confidential

• System Developer Contracted to assist with the creation of an applications development consulting practice and to complete / implement several internal software projects.
• Environment: ERwin, JAD, NT Server 4.0, NT Workstation 4.0, Visual Basic 6.0, Visual InterDev 6.0 SQL Server 7.0, VISIO Professional, FrontPage 2000, ASP 3.0, IIS 4.0 5.0, Site Server 3.0 Commerce Edition, Outlook 2000 Customization, Office Development and Integration, ColdFusion, AcuCOBOL.
• Duties Include: Website software engineering, database design and implementation, project manager. HTML and ASP Website Development using Visual InterDev. e-commerce Site Development using Cold Fusion, MS Office Automation Project.

Confidential

• Project Prime Contractor My Company was contracted by City of Denver, District Attorney's Office to develop the VS2000 Victim Services 2000 System. Designed system, database and managed software development through a sub-contractor.
• Environment: JAD, ERwin, BPWin, Rational Rose, NT Server 4.0, Windows 2000, NT Workstation 4.0, Visual Basic 6.0, Visual InterDev 6.0 SQL Server 7.0, VISIO Professional, FrontPage 2000, ASP 3.0, IIS 5.0, OLAP, CUBE, DTS, SQL Server 7 Metadata and Microsoft Repository.
• Duties Include: Website and data warehouse software engineering project, database and data warehouse design and implementation. Application development using ASP website techniques, including the following development products JAD, ERwin, BPWin, Rational Rose, NT Server 4.0, Windows 2000, NT Workstation 4.0, Visual Basic 6.0, Visual InterDev 6.0 SQL Server 7.0, VISIO Professional, FrontPage 2000, ASP 3.0, IIS 5.0, OLAP, CUBE, DTS, SQL Server 7 Metadata and Microsoft Repository.

Confidential

• Project Prime Contractor -- My Company was contracted by Washington State Violence Against Women Network to develop the Violence Against Women Website. Designed system, database and managed software and website development through a sub-contractor.
• Environment: JAD, ERwin, Rational Rose, NT Server 4.0, Windows 2000, NT Workstation 4.0, Visual Basic 6.0, Visual InterDev 6.0 SQL Server 7.0, BPWin, VISIO Professional, FrontPage 2000, ASP 3.0, IIS 5.0, OLAP, CUBE, DTS, SQL Server 7 Metadata and Repository.
• Duties Include: Website and data warehouse software engineering project, database and data warehouse design and implementation. Application development using ASP website techniques, including the following development products JAD, ERwin, BPWin, Rational Rose, NT Server 4.0, Windows 2000, NT Workstation 4.0, Visual Basic 6.0, Visual InterDev 6.0 SQL Server 7.0, VISIO Professional, FrontPage 2000, ASP 3.0, IIS 5.0, OLAP, CUBE, DTS, SQL Server 7 Metadata and Microsoft Repository. This Projects was a transfer and modification of the Denver VS2000 Project

Confidential

• Prime Contractor -- My Company was contracted by Nevada Network Against Domestic Violence to modify and transfer the Texas ITS Integrated Tracking System to Nevada. Gathered requirements, identified changes and wrote conversion document, and managed software development through a sub-contractor.
• Environment: ERwin, NT Server 4.0, Windows 2000, NT Workstation 4.0, VBA, Access 97
• Duties Include: Software design and requirements, database design, project manager, application development using three contract developers.

Confidential

• Data Administration Consultant -- Contracted by the State of Arkansas to develop the Statewide Enterprise Data Model. Also created various data and business process models, Data Warehouse data models dimensional modeling Data Warehouse Operational Data Stores, Physical Data Base design object relational mapping and other tasks as necessary.
• Environment: WINDOWS NT, Microsoft Office 2000, ERwin extensive data modeling , JAD, BPWin, Paradigm Plus, Visio 5.0 Enterprise DB2 Universal Database Server, SQL Server 7.0.
• Duties Include: Data Warehouse design dimensional modeling , extensive data modeling, JAD Facilitation, IDEF1X, data analysis and data modeling, BPR, use case, sequence diagrams, OO Modeling, object relational mapping.

Confidential

• Senior DBA --. Contracted by SkyMall to re-engineer the Skyops database for core production system and ecommerce use. Documented current database schema, stored procedures over 2000 , triggers, rules, etc. Modeled processes VB, ASP and Powerbuilder applications to use case diagrams using Rational Rose. Developed data models for each of the business subject areas, which enabled SkyMall to segment the production database environment into multiple RDBMS. Also created use case diagrams translated two tier business rules to n tier business rules for all applicable stored procedures and triggers. Developed data warehouse models for accounting, operations and marketing.
• Environment: ERwin extensive data modeling , Rational Rose, DB Artisan NT Server 4.0, NT Workstation 4.0, Visual Basic 6.0, Visual FoxPro, Visual InterDev 6.0 SQL Server 6.5 and 7.0, Brio, DBArtisian, BPWin, VISIO Professional, Team Manager, Oracle 8, OLAP, CUBE, DTS, SQL Server 7 Metadata and Microsoft Repository.
• Duties Include: Relational database and Data Warehouse design dimensional modeling , RDBMS re-engineering methodologies, JAD facilitation, IDEF1X, data analysis and data modeling, SQL Server 6.5 to 7.0 conversion. Use case and class diagram development.

Confidential

• Converted 22 Cobol IMS/DC applications to CICS, DB2
• Worked on several FoxPro and Visual FoxPro applications.

Confidential

Recovered 10 VB 3.0 engineering applications company lost source code , rewrote applications in VB 5.0

Confidential

• Director of Software Development -- Project architect focused on developing and installing Law Enforcement and Domestic Violence Tracking Systems. I am the author and creator of H.E.L.P. Helping Enforce Legal Protection Domestic Violence incident and tracking system. Software included both transactional processing and data warehousing components. Components included RMS, NIBRS reporting, Criminal and Civil Court modules, Jail Management, Intelligence, Incident Reporting, Property and Evidence Inventory, etc.
• Participated in evaluation of E.T. Software and CrisNet RMS packages for 16th Judicial District, State of Tennessee.
• Environment: INTEL and DEC Alpha Based Servers and PC's, WINDOWS 95, Microsoft Office 97, ERwin extensive data modeling DB2 Universal Database Server, Visual Modeler Rose subset , BackOffice 4.0, NT Server 4.0, NT Workstation 4.0, Visual Basic 5.0, 6.0, Visual FoxPro, Visual InterDev 1.0 6.0 SQL Server 6.5, 7.0, TCP/IP, Ethernet, OLAP, CUBE, DTS, SQL Server 7 Metadata and Microsoft Repository.
• Duties Include: Web architect, Relational database design, Data Warehouse design, web enabled client server systems design methodologies, JAD, IDEF1X, data analysis and data modeling.

Confidential

• Data Analyst Contracted by the State of Arkansas to establish data modeling policies and procedures using ERwin, BPWin, ModelMart and Platinum MVS Repository. Accomplishments included:
• Developed the written justification for the purchase of the necessary software and hardware to establish a data-modeling environment at DIS.
• Conducted vendor negotiations for hardware and software.
• Wrote the IFB Invitation of Bid documents to procure the hardware and software.
• Installed the ERwin tools set and taught the other members of the Data Administration Department how to use the tools.
• Developed the Arkansas Crime Information Center ACIC data model. This model was used to convert the present VSAM data set structure to DB2 and to implement an ACIC data warehouse. Used for State NIBRS reporting to FBI
• Reviewed the AFGM data warehouse model. Worked with State Metadata and Platinum Repository / MVS.
• Advise the data warehouse team on data model, database, tools and three tier implementation techniques.

Environment: IBM MAINFRAME, IBM PC, WINDOWS 95, Microsoft Office 97, ERwin extensive data modeling , Rational Rose, ISPF, Platinum Repository / MVS, State Metadata, DB2 4.0, TSO, DB2 Universal Database Server.

Duties Include: Data Warehouse design, three tier applications design methodologies, JAD, IDEF1X, data analysis and data modeling.

Confidential

• Duties include overseeing the various applications development and consulting projects, acquiring and managing contract personnel, maintaining equipment and computer software, creation of corporate business plans, proposal writing, three tier client server systems design, project management and implementation of various client projects and performing various consulting assignments for clients.
• IBM Professional Services Client List

Confidential

• System and Data Architect Worked with IBM Professional Services in the re-engineering of the Florida WIC Women, Infants and Children Information System for the State of California. Project stopped because IBM ran out of money on the project and the Bachman tool set would not generate IBM CSP Code as advertised.
• Environment: Zachman Framework, MVS/XA, DB2 2.0 and 2.1, CICS/MVS, CSP 3.1, COBOL II, ISPF/PDF, DB2 PERFORMANCE MONITOR, VTAM, OS/2, BACHMAN Toolset, ADW Toolset, JAD.

Confidential

• DB2 Database Administrator, DB2 Systems Programmer, Project Manager and CSP Administrator Worked with IBM Professional Services in the development of the Florida WIC Women, Infants and Children Information System, AFDC and AFDC Jobs Systems at HRS. Worked closely with the IBM Systems Programming Staff tuning and installing MVS, DB2, CICS/MVS, CSP TSO. Trained the State DBA staff in the areas of database design, tuning of the DB2 sub-systems, tuning of the QMF and CICS/MVS interfaces to DB2, implementing DB2 PM statistical gathering procedures. Assisted the programming staff both State and contract by teaching them how to write correct SQL, thereby minimizing the effects of their queries on system performance. I was largely responsible for reducing the average response time of the WIC applications from over one minute to less than three seconds.
• Worked on the AFDC, AFDC Jobs, Florida Project design and DB2 consultant for IMS/DB DBA Medicaid/Medicare, Food Stamps, etc. , Client Common Registration project data design , Child Care project data design .
• Developed initial design for Leon County Sheriff's Department RMS, Court, NIBRS Reporting, Jail Management and other Law Enforcement / Civil and Criminal Justice Systems.
• Environment: Zachman Framework, MVS/XA, DB2 2.0 and 2.1, CICS/MVS, CSP 3.1, COBOL II, ISPF/PDF, DB2 PERFORMANCE MONITOR, VTAM, OS/2, BACHMAN DBA for DB2, RACF, JAD.

Confidential

• DB2 and managed the conversion of various nuclear material management spare parts, pipes, pumps, welds, and structures systems from a System/38 to an IBM 3090 for a nuclear power facility South Texas Project . Designed the new DB2 relational tables and supervised the conversion staff of eight.
• Environment: MVS/XA, DB2, CICS/MVS, COBOL II, DB2 PERFORMANCE MONITOR, ADW, SCLM, OMEGAMON, ISPF/PDF, ACF II

Confidential

• DB2 Data Base Administrator. Installed and implemented a DB2 development for the conversion of an Oil Well Production System from ADABAS to DB2. Worked with the CICS, MVS, TSO, and ACF II systems programmers in interfacing to DB2 and tuning the MVS system accordingly. Assisted the applications programmers and taught several training sessions on DB2 applications programming.
• Environment: MVS/XA, COBOL II, DB2, ISPF/PDF, ADABASE, OMEGAMON, DB2 PERFORMANCE MONITOR, CICS/MVS

Confidential

• DB2 and CSP Consultant. Mentored development staff during the during the installation of a DB2 / CSP based HRMS Integral Systems . The system was the first Integral CSP / DB2 version to go into production. Assisted the DB2 and CICS systems people in installing and tuning DB2, CSP, and CICS.
• Environnent: MVS/XA, DB2, CSP, ISPF/PDF. CICS/MVS, OMEGAMON
• v the consulting services during the installation of a CSP based mortgage loan warehousing and re-marketing system. Was heavily involved in the CICS, CSP, and DB2 systems areas, assisting the systems programmers in tuning and installing the systems. Developed CSP MSL and ALF VSAM KSDS data sets definition parameters later adopted by IBM. Wrote a major module in the system GL interface using IMS/DB/DC and TELON -- ten MPP application programs and two BMP programs.

Environnent: MVS/XA, DB2, CSP, ISPF/PDF. CICS/MVS, OMEGAMON, JAD,

Confidential

• Provided systems programming support during the development of an extensive property / casualty insurance system I also acted as the IMS/DB DBA.
• Environment: MVS, IMS/DC, ISPF/PDF. CLIST, Assembly Language, CICS/MVS, OMEGAMON, DYL-280, COBOL

Confidential

• Because of resume size, client, contract and employment history prior to June 1984 is available upon request only. Industry areas are outlined below:
• Newspaper Publishing Business office and typesetting .
• Distribution retail / wholesale
• Healthcare Insurance, Hospital, HMO
• Criminal Justice Law Enforcement RMS
• Trucking and Heavy Haul Freight Dispatch
• Direct Mail Applications
• Advertising
• Property Casualty Insurance Vehicle, Homeowners, Business, Premium Finance
• Manufacturing Shop Floor Control, BOM
• Barge Line Operations
• Installment Loan non Banking application
• Mail Order
• Weapon Systems Laser guided and radar seeking analog computers