| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate RESUME
Name: Candidate's Name
Address: Street Address Valley View Court
Verona, Wisconsin Street Address
Home Phone: PHONE NUMBER AVAILABLE
Higher 9/Street Address 1/74 University of Chicago: Graduate work in Mathematics.
Education: 9/69 5/73 University of Wisconsin Madison:
B. S. degree with Honors in Mathematics
Work History: Department of Revenue
State Government of Wisconsin Madison
4/00 12/10 Permanent employee in the Office of Technology Services. For the past 6 years was a member of
the Departments Data Warehouse team which built an enterprise data warehouse from scratch,
including the selection process from among multiple vendors of a purchased suite of BI tools, including
ETL and querying and reporting, ultimately settling on SAS. Tax-related data was modeled and
divided into Fact and Dimension tables using ERWIN, Data Definition Language was generated and
tables were created for the ODS and Data Warehouse reporting tables. The overall effort was divided
up into smaller projects, each incorporating a new data source. First we incorporated W-2, Wisconsin
state income tax and Federal 1040 data, followed by vehicle and drivers license data from the
Department of Transportation.
More recently led the effort to convert a previous DOR data mart involving Corporate Sales Tax and
Income Tax audit-related information into the new SAS DW. The data in the Warehouse is used heavily
by audit staff, compliance staff and Research and
Policy to increase tax compliance and to shape tax policy for the Legislature and the Governors office.
Served later as project leader for a conversion of the data from 4 mainframe CICS/DB2 tax systems to
Prior
the SASto that
Web IReport
was the project manager and platform
Studio/SQL-SERVER systems analyst for several modification
environment.
projects involving the Business Tax Audit Data Mart. In one project, the front end and
ETL programs for the Warehouse were accommodated to new feeds of Business Tax Regist-
ration data and Sales Tax return data coming from the new Integrated Tax System. In the
other project, built an application in MS-ACCESS to track audit downloads, including a
PC-to-mainframe process which grabbed current corporate addresses. Wrote several complex programs
improving the data quality of this data mart. Consulted on BUSINESS OBJECTS and BO Designer to
assist customers with queries and reports. Before that, as Business Analyst,
worked on a number of desktop applications in MS-ACCESS and Visual Basic, one of which
was a screen-scraper for WISMART. Wrote a mainframe COBOL application to anal-
yze the monthly INFOTECH bill. Analyzed the CICS/COBOL Forms Inventory System
for replacement. Maintained the Employee Directory application for the Department. Mod-
ified the Business Tax Registration system, a complex batch DB2 COBOL mainframe system.
Wrote a user interface between mainframe personnel data and Training Partner, a purchased
client-server package for tracking employee training courses completed.
Finallly, worked on a project to build a user-friendly SAS data mart for querying the statewide
accounting system, WISMART, by the fiscal group at DOR. The application uses Slowly Changing
Dimensions.
3/98 12/99 CUNA Mutual Insurance Group
Madison, Wisconsin
Business Systems Consultant Maintained multi-million dollar Billing system for the
Corporate Property and Casualty division. Worked in a batch COBOL II/VSAM/DB2 main-
frame environment doing systems enhancement and production support.
8/97 3/98 Division of Information Technology (DOIT)
University of Wisconsin Madison
As Business Process Specialist, did systems analysis and design work for a systems integration
project where a new employee benefits system was to be integrated with existing payroll and
personnel information systems in IMS/COBOL, a faculty appointment system in DB2 and a
Deduction Services system in ORACLE. CASE Tool used was ORACLE Designer/2000 as
upper Tool and to generate DDL for databases.
7/96 7/97 Department of Workforce Development
State Government of Wisconsin Madison
Permanent employee in the Bureau of Information Technology Services. Was an inter-agency
exchange or loaner employee to the DOA Bureau of Statewide Systems Development working
on the SHRS system (Shared Human Resources System). This was to be the first statewide
client/server system in Wisconsin state government, utilizing DB2 on the INFOTECH mainframe
as an enterprise server. SHRS was the Wisconsin civil service scoring and tracking system,
developed with the integrated CASE Tool COMPOSER by IEF from Texas Instruments
(now called COOL:Gen) using the Rapid Prototyping path of the Information Engineering
methodology. Did data and process modeling, led BAA/JAD sessions, performed systems design,
prototyping and code generation using the Tool. Did system testing of SHRS and conversion of
the Personnel Management Information System (PMIS) data to SHRS.
3/87 6/96 Department of Health and Family Services
State Government of Wisconsin Madison
Permanent employee in the Bureau of Information Systems. As a project leader had systems
maintenance responsibility for the Low Income Home Energy Assistance Program (LIHEAP)
system, a medium-sized IMS/DB2/COBOL mainframe system with 30 on-line programs and
100 batch programs. As Designer/Analyst made major contributions to the analysis and redesign
of the Bureaus Billing and Property Administration systems using the CASE Tool KNOWL-
EDGEWARE with the FORESIGHT methodology. Did data analysis and system design for an
enterprise model of billing and property administration data contained in the NETMAN package.
Wrote and executed a system test plan for the new NETMAN release. Used the screen scraper
software, MOZART, to implement batch applications for the Human Services Reporting System.
As Programmer/Analyst made substantial additions to the Child Support Data System (CSDS)
and the Income and Eligibility Verification System (IEVS) used for welfare fraud detection. Using
COBOL in the IMS DB/DC and DB2 environments, designed and coded the Printed Fiscal Query
and the Bank Deposit functions for CSDS and the interstate case load match for IEVS. For the
latter project, dumped the 8400-byte CRN welfare record to a standard format. Also per-
formed systems analysis on the CRN/IMP Redesign project and KIDS Child Support system RFP.
Responsible for production support work and design, coding, testing, and documentation of large,
complex programs using database in both on-line and batch processing modes. Other software
used included FILE-AID, FILE-AID/IMS, Batch Terminal Simulator (BTS), EASYFLOW, VIA-
INSIGHT, VIA-SMARTEST, and the data dictionary, DATAMANAGER.
8/83 10/83 Department of Administration
State Government of Wisconsin Madison
Limited term employee in the Division of Executive Budget and Planning. Responsible for com-
pleting the computer programming for the 1983 population estimates and projections for counties
and municipalities in Wisconsin. This work was accomplished in batch mode in the COBOL and
FORTRAN languages on an IBM 3081 mainframe using TSO/SPF.
8/82 8/83 Department of Development
State Government of Wisconsin Madison
Permanent employee in the Division of Support Services. Responsible for the design, coding,
debugging, documentation and maintenance of many small systems at this agency, including
the Plat Review system, Permanent Property Inventory, Tourism Information Retrieval, and
Industrial Sites and Buildings systems. Also was technical support resource for computer users of
other applications. Work performed using TSO/SPF on an Amdahl 470 mainframe, and using IPF
related software on an IBM 8100 minicomputer. Languages used were COBOL and DMS.
12/80 8/ 82 Vocational, Technical and Adult Education Board
State Government of Wisconsin Madison
Permanent employee in the Bureau of Policy and Planning. Responsibilities included re-design,
programming, testing, documentation and maintenance of several key systems at this agency,
notably, the Student Follow-Up system, the VEDS statistical system, Teacher Certification, and
Course Approval. In addition, performed maintenance and technical support functions. Computer
work performed on an Amdahl 470 mainframe using TSO. Languages used were COBOL,
FORTRAN, and MARK IV. Used direct access method with FORTRAN and VSAM with
COBOL.
5/78 12/80 Department of Administration
State Government of Wisconsin Madison
Permanent employee in the Bureau of Information Development. Programming and analysis
performed on various automated systems, including Statewide Purchasing, Affirmative Action
Information, Population Estimation, and General Obligation Bonding. Languages used were
COBOL and FORTRAN in an IBM 370 host environment using TSO. Used direct access method
with FORTRAN and VSAM with COBOL.
11/76 11/77 H. E. Winklevoss and Associates
Philadelphia, Pa.
Pension actuarial work. Was responsible for designing and implementing a computerized
valuation system for large, complex multi-employer pension plans. Did systems design, program-
ing, testing, and implementation. Languages used for this computer model were FORTRAN in
batch mode on an IBM 370 mainframe with APL in time-sharing mode on an attached processor.
1/76 11/76 Martin E. Segal Company
New York, N. Y.
Valuation of corporate and multi-employer pension plans using a General Automation 18/30
minicomputer in the FORTRAN language.
4/74 10/75 Johnson & Higgins
New York, N. Y.
Performed pension valuation work using a computer system written in an IBM Basic Assembler
macro language. Work done on an IBM 370/145 mainframe computer.
SKILLS: Data modeling, process modeling, structured analysis (Yourdon, Constantine) , structured design
(Page-Jones), data analysis, applications architecture, CASE Tool development, Information
Engineering, GUI design, software testing, system reengineering, project management, JAD session
facilitation, coding in multiple programming languages, advanced debugging and reading MVS dumps,
writing test plans, methodology , statistical analysis, Data Warehouse, ETL, and Business Intelligence..
SOFTWARE: CHANGEMAN, VIA-SMARTEST, VIA-INSIGHT, Expediter, PLATINUM Tools, SPUFI, VSAM/ AMS,
JCL, PROCs, FILE-AID, FILEAID/IMS, DB2 EXPLAIN, DATAMANAGER, CASE Tools, MS-PROJECT,
MS-ACCESS, VBA, Net EXpress, DOS, CONTROL-M, CONTROL-O, ABEND-AID, TSO/SPF, CLISTS,
MOZART, HOST-ON-DEMAND, Attachmate EXTRA! Macro language, BUSINESS OBJECTS,
Command Center, MS-WORD, SAS Data Integration Studio, Web Report Studio, Enterprise
Guide, Information Map Studio, Base SAS, and Visio.
DATABASES: DB2, UDB (Universal Database, or DB2/2), MS SQL-SERVER, IMS DB, MS ACCESS.
|
