Timothy Talbert

**** ******** ***.

Chatham, IL *2629

H: 217-***-**** C: 217-***-****

Skills Summary: Experience in administration, systems analysis, programming, DBA, project management, and data warehousing. Worked for both government and private business. Strong background in user training and support documentation.

Education: Coursework towards B.S., Accounting

Illinois State University, Normal, Illinois

A.G.E., Data Processing

Lincoln Land Community College, Springfield, Illinois

Dimensional Modeling in Depth, Microsoft Data Warehouse in Depth

Kimball University

Certifications: IBM Certified Solutions Expert – Business Intelligence

IBM Certified Specialist – DB2 UDB V6/V7 User

Cognos DecisionStream Series 7 Product Professional

Work History Summary

Experience: Administration, System Analysis, Structured Design and Development, Database Design, Database Administration, Dimensional Modeling, Business Intelligence, COBOL, Application Maintenance, Implementation, Batch Development, On-line Development, Computer Operations, Project Management, Conversion, Software Evaluation, System Testing, Dataflow Diagramming, Documentation

Applications: Accounting, Data Warehousing, Corrections, Sales Tax, Income Tax, Collections, Tax Records, Data Control, Test Data Generation, Tax, State Warrant Processing, Property Insurance, Wholesale Distribution, Retail Leasing, Long Range Planning, Retirement Systems, Small Equipment Manufacturing

Software: Microsoft SQL Server, COBOL, SQLWays, Cognos DecisionStream, Oracle, ISPF, VSAM, IMS/DB, BTS, IMS/DC, CICS, DB2 for z/OS, Omegamon PE for DB2, Optim Performance Manager, MVS, CICS EXCI, DB2 for VSE, EDF, SQL, QMF, dBase IV, DOS, COBTEST, INTERTEST, Windows, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Word Perfect, ER/Studio, Microsoft Visio

Work History Detail

11/11 – 6/15 Illinois Department of Central Management Services

Public Service Administrator

DB2 z/OS and LUW support. ETL for Department of Corrections database conversion / consolidation. Transition database responsibility to SQL Server group. Installation and maintenance of mainframe Omegamon PE DB2 monitor. Installation and configuration of Optim Performance Manager. Maintenance of Tivoli Decision Support 390 on mainframe.

8/06 – 10/11 Illinois Department of Corrections

Public Service Administrator

Supervised staff of Database administrators. Planned and executing a database conversion from Sybase ASA 7 to SQL Server 2005 64 bit. Designed hardware and software infrastructure and conversion methodology. Upgraded from SQL Server 2005 to SQL Server 2008. Began first phase of data warehouse. Performed data conversion

12/96 – 8/06 Levi, Ray & Shoup, Inc. - Springfield, IL

Senior Consultant

Performs a variety of application development activities as an information technology consultant for various company clients.

DEMDACO – Stilwell, KS

Designed and implemented an Operational Data Store and Data Mart for improving reporting capabilities. Tools included Cognos Data Manager (formerly DecisionStream), Oracle, and SQL Server 2000.

ServiceMaster – Downers Grove, IL

Provided an unbiased review of the data warehousing system put in place by ServiceMaster for one of their subsidiaries. Facets included hardware, software, and ETL processing.

DEMDACO – Stilwell, KS

Created a data discovery document to allow the client to start creating a data warehouse. Source systems use Oracle and SQL Server on the Windows platform.

Wellpoint, Inc. – St. Louis, MO

Performed a post implementation review on a data warehouse. The data warehouse resides in an Oracle database on the UNIX platform.

Los Angeles County Department of Children and Family Services – Norwalk, CA

Created a road map document to allow the client to start creating a data warehouse. Source systems use Oracle on a Windows platform.

Illinois Department of Public Aid – Springfield, IL

Performed data modeling for operational and analytical reporting for a system that processes a low-income heating assistance program. Source system uses SQL Server 2000 and is written in Visual Basic.NET.

Bunn-o-Matic – Springfield, IL

Performed data modeling and ETL processing for data warehouse that tracks machine performance. Used SQL Server and Cognos DecisionStream as database and ETL tool.

Illinois Department of Transportation – Springfield, IL

Studied requirements for Business Intelligence pilot project. Created and presented a high-level Data Warehousing overview presentation.

NCS Pearson – Iowa City, IA

Performed data modeling and ETL processing for data warehouse that tracks test scoring. Used SQL Server and Cognos DecisionStream as database and ETL tool.

DePuy Orthopedics – Warsaw, IN

Developed ETL process for data warehouse tracking price changes and buying agreements. Used Oracle and Cognos DecisionStream.

Wellpoint, Inc. – St. Louis, MO

Developed historical data warehouse extracts for two state Blue Cross systems. Purpose was to create a profit center in analysis of claim and pharmaceutical trends. Used Oracle as the database.

American Express Incentive Services – St. Louis, MO

Developed and maintained ETL process for updating sales representative information for Gift Cheques and Gift Cards. Target database is SQL Server 2000. ETL processing is done using Cognos DecisionStream, SQL, and DTS.

Country Insurance and Financial Services – Bloomington, IL

Wrote programs, modules, and procs for conversion of property/casualty insurance and human resources into Lawson accounting package. Used COBOL, DB2 for z/OS, and Easytrieve.

American Express Incentive Services – St. Louis, MO

Developed and maintained ETL process for reporting on Gift Cheques and Gift Cards. Target database is SQL Server 2000. ETL processing is done using Cognos DecisionStream, SQL, and DTS.

Bandag, Inc. – Muscatine, IA

Analyzed remote connectivity and update issues between PeopleSoft using SQL Server and legacy systems using DB2 for OS/390. Documented issues and provided short term and long term connectivity options.

Simon Property Group, LP – Indianapolis, IN

Developed data mart and ETL process to automate reporting on Temporary Tenants. Data sources are a Lotus Notes database and Excel spreadsheets. Target for the data mart is SQL Server 2000. ETL processing is done using Cognos DecisionStream, SQL, and DTS.

Illinois Department of Transportation – Springfield, IL

Worked on a data dictionary and requirements for anew reporting sub-system for the Project Planning System. Software included SQL Server 2000 and Access.

Euclid Beverage – North Aurora, IL

Developed a data repository for reporting using Cognos tools. SQL Server 7 is the DBMS software. ETL process done using DTS.

State University Retirement Systems – Champaign, IL

Worked on a team implementing a pilot data warehousing solution. Environment uses an Intel based server to host the data warehouse. SQL Server 2000 is the DBMS software. ETL and data delivery tools are from Microsoft and Cognos. The initial project tracked disbursements. Further projects tracked member changes and history. Performed data modeling and ETL processing on continuing work.

Levi, Ray & Shoup, Inc. (Internal Projects) – Springfield, IL

Provided DBA services for our internal applications group to tune the DB2 installation. Studied business intelligence and data warehousing.

Horace Mann Insurance – Springfield, IL

Analyzed requirements to implement EFT, monthly billing, and bill code changes in combined bill software. Created requirements document and general design. Devised methodology to create and modify payment schedules per the requirements. The environment uses an IBM OS/390 system using COBOL, VSAM, and CICS.

Illinois State Treasurer’s Office – Springfield, IL

Served as project leader and designer for a new accounting system to track State of Illinois expenditures and receipts. Analyzed business requirements and formulated options for necessary system. Defined business rules and developed business processes and system to do those processes. Designed all facets of the DB2 database, including tables, indexes, and relational integrity. Managed team of four consultants in construction of the system. Assisted in programming and testing of the system. Implemented and maintained the system. Provided DBA services for the client including DB2 installation and upgrade. Did disaster recovery and point in time recover planning and implementation. The environment uses an IBM VSE/ESA system, using COBOL, Easytrieve, VSAM, CICS, and DB2.

Illinois Office of the Comptroller – Springfield, IL

Served as team leader for LRS consultants responsible for interface and conversion programs. Continued work with file fixes, troubleshooting and hardware migrations to an IBM MVS/ESA system. Used COBOL, Easytrieve, VSAM, CICS, external CICS interface and DB2.

03/85 - 12/96 Illinois Department of Revenue – Springfield, IL

Public Service Administrator

Project Coordinator for a wide range of applications. As coordinator was responsible for analysis, design and ensuring that the final product met the needs of the users. Worked closely with the users during all phase of their project. At various times assigned and managed the work of eight programmer/analysts. Some major projects were:

Did a systematic write-off of income tax accounts receivable. Designed and implemented new subsystem to remove old inactive accounts from current accounts receivable according to user supplied criteria. Supervised team of four programmer/analysts for project.

Allowed taxpayers to specify a direct deposit option for their income tax refunds. Specified changes to IL1040 system. Coordinated data flow from the electronic filing system, through the income tax front-end system, into the IL1040 system, and then on to the State Comptroller’s refund generation system.

Coordinated year 2000 changes in IL1040 system. Selected year 2000 conversion method, assigned program and file conversions, and documented issues for year 2000 committee. Supervised team of eight programmer/analysts for project.

Designed and implemented system to compare IL1040 records with US1040 records. System identifies non-filers and under-reporters, generates correspondence, and provides management reporting. Supervised team of six programmer/analysts for project. Project used DB2 database and APS on-line CICS code generation.

Designed and implemented a time keeping reporting system for personnel department. System received input from State time keeping system and stored it in a DB2 database. Reporting was accomplished using QMF tool.

Coordinated conversion of refund warrants from paper into microfiche. Handled all communications between State Comptroller’s office who wanted records on microfiche, the Secretary of State’s office who generates the microfiche, and Revenue who generates the refund warrants.

Designed and implemented a system to gather information from various State and Federal sources for use in collection of delinquent taxes. System took data from these sources, stored it in VSAM files, and accessed it for batch and on-line reporting. System used APS for on-line CICS code generation.

Designed and implemented a PC/Mainframe system to systematically handle bad checks for income tax. PC system was written using dBase IV and provided data entry, batch balancing, data storage, correspondence, and management reporting. Mainframe system provided editing and systematic offset of payments. Interface between the two systems was done through bulk file transfer.

Designed and wrote a program to calculate unreported interest owed on sales tax accounts for management research. This was the first systematic calculation of sales tax accounts. Program was written using APS batch code generation and used a DB2 database as the information source.

Designed and implemented a test data generation system for sales tax. Project used APS on-line CICS code generation.

Participated in pilot project for APS product and DB2 database. Was solely responsible for the DB2 database design and implementation. Also did half the APS on-line and batch programming.

Worked on three separate hardware conversion projects. Was responsible for the program conversion of the IL1040 system when it was migrated from a Univac 90/80 system to an Amdahl system using the MVS/XA operating system. Supervised seven programmer/analysts for this project. Converted the sales tax JCL for the same hardware conversion. Was responsible for the entire conversion of an accounts receivable reporting system from a Univac 1100 system to the MVS system.

Was part of the technical team investigating new hardware and software to replace aging Revenue computer systems. Attended presentations and reviewed documentation from six computer vendors. The vendors were Burroughs, Univac, NCR, Digital, Honeywell, and IBM. Wrote findings on suitability of proposals, concentrating on issues involving data structures and COBOL.

During this time-frame have also been responsible for programming complex systems using COBOL II, CICS, DB2, VSAM, and APS.

01/87 - 12/95 Lincoln Land Community College – Springfield, IL

Adjunct Faculty

Prepared COBOL II class materials and taught for five semesters. The topics covered were table handling, internal sorts, sequential and random file updating.

Contact this candidate