Resume

Sign in

Data Project Manager

Location:
Verona, Wisconsin, 53593, United States
Posted:
March 12, 2018

Contact this candidate

Resume:

Mitch Cohen

Professional Experience in Data Warehousing

Department of Revenue, State of Wisconsin - Madison, WI April 2000-Dec 2010

ETL Developer / Data Modeler

**** – Member of two-person team which built a user-friendly SAS data mart for point-and-click querying of the state government accounting system, WiSMART, by the fiscal group at DOR

2004 – 2009 - For the past 5 years served on the Department’s Data Warehouse team, which built an enterprise data warehouse for tax compliance 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

Generated Data Definition Language and tables were created for the ODS and Data Warehouse reporting tables. The overall effort was divided up into smaller Extract, Transform and Load projects, using SAS BI Studio, each incorporating a new data source, including W-2, state income tax and Federal 1040 data, vehicle and drivers license data from the Department of Transportation, and Real Estate Transfer electronic returns.

2004 - Led the effort to convert a previous DOR data mart involving Corporate Income Tax and Sales Tax audit-related information into the new SAS DW.

2002 – 2003 - Prior to that I was the project manager and systems analyst for several modification 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 Registration 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 program improving the data quality of this data mart. Consulted on BUSINESS OBJECTS and BO Designer to assist customers with queries and reports.

Department of Health and Family Services, State of Wisconsin – Madison, WI

March 1987 – June 1996

Business Analyst

1994 – 1995 - Performed the planning, analysis, design and construction of a department Data Warehouse to aid customers in the tracking and billing of IT property. Used the CASE Tool, KNOWLEDGEWARE, to model the Property Administration function of the enterprise and to create Data Definition Language for tables resident on the OS/2 platform. Tables were fed data from the NETMAN inventory package and from the BIS Billing system.

Environments:

SAS DW – MS SQL-SERVER

Business Tax Data Mart – UDB

Higher Education

University of Chicago - Graduate work in Mathematics Sept 1973 – Jan 1974

University of Wisconsin, Madison - B. S. with Honors in Mathematics Sept 1969 – May 1973



Contact this candidate