• No results found

Tax Compliance Infrastructure Data Warehouse Project

N/A
N/A
Protected

Academic year: 2021

Share "Tax Compliance Infrastructure Data Warehouse Project"

Copied!
25
0
0

Loading.... (view fulltext now)

Full text

(1)

Wisconsin Dept. of Revenue

Wisconsin Dept. of Revenue

Tax Compliance

Tax Compliance

Infrastructure

Infrastructure

Data Warehouse Project

Data Warehouse Project

Janna Baganz Janna Baganz Amy Bomkamp Amy Bomkamp Susan Dukes Susan Dukes May 2007 May 2007

(2)

Upside:

Upside: •

• Contractor built with a quick Contractor built with a quick project turnaround

project turnaround

• Successful audit projectsSuccessful audit projects

Downside:

Downside: •

• Difficult maintenance effortsDifficult maintenance efforts

Project Beginnings

Project Beginnings

Project Beginnings

Corporate Data Warehouse

(3)

Development Decision

Development Decision •

• Expand current corporate projectExpand current corporate project •

• Contract out new projectContract out new project •

• Build inBuild in--househouse

Project Turning Point

Project Turning Point

Project Turning Point

Developed Business Plan for

Developed Business Plan for

Individual Data Warehouse

(4)

Individual Data Warehouse

Individual Data Warehouse

Individual Data Warehouse

Build Data Warehouse In

Build Data Warehouse In

-

-

House

House

• Integrated team across IT and business unitsIntegrated team across IT and business units •

• Business users control what data to load and Business users control what data to load and surface from the data warehouse for reporting

surface from the data warehouse for reporting

• Phased approach to provide value along the way Phased approach to provide value along the way •

• Keeps technical and business knowledge inKeeps technical and business knowledge in- -house

house

(5)

Individual Data Warehouse

Individual Data Warehouse

Individual Data Warehouse

• Phase 1 Phase 1 –– WI tax returns, IRS individual tax WI tax returns, IRS individual tax returns, and electronically filed W

returns, and electronically filed W--2 forms2 forms

9

9 Users received five handUsers received five hand--coded reports for audit coded reports for audit identification and two look

identification and two look--up reportsup reports

• Phase 2 Phase 2 –– IRS informational returnsIRS informational returns

9

9 Users received endUsers received end--user query capability and user query capability and portal access

portal access

Phased Approach

(6)

Individual Data Warehouse

Individual Data Warehouse

• Phase 3 Phase 3 –– Vehicle title, drivers license and Vehicle title, drivers license and registration information

registration information

9

9Legislative direction authorizing other Legislative direction authorizing other agencies to assist in tax collection

agencies to assist in tax collection

9

9MOU secured with Department of MOU secured with Department of Transportation

Transportation

9

9Additional endAdditional end--user query capabilityuser query capability

Phased Approach

(7)

• Phase 4 Phase 4 –– Sales tax, corporation returns, IRS Sales tax, corporation returns, IRS business tax data, unemployment insurance

business tax data, unemployment insurance

employer records

employer records

9

9Integration of corporate and individual data Integration of corporate and individual data warehouses

warehouses

9

9six handsix hand--coded reports coded reports

9

9Enhanced ad hoc capabilityEnhanced ad hoc capability

Phased Approach

Phased Approach

Individual Data Warehouse

(8)

Iterative Approach

Iterative Approach

Iterative Approach

DW Steering Team determines Data Source

Business Requirements Meetings

(Audit, Compliance, & R&P)

Business Requirements Document (Deliverables Determined)

DW Team Begins Design Process

Steering Team votes on phase Deliverables Que stions bac k to use r gro ups

DW Build Process Begins

Build / Match User Data Match Testing Build Continue User Data Testing Raw Data Accepted / Report Build User Report Testing Report and Data Accepted by Users Steering Team Approves Phase Completion

DW Team moves phase data and reports into

Production

(9)

Iterative Approach

Iterative Approach

Work takes place on multiple phases at

Work takes place on multiple phases at

one time:

one time:

• Completion cycle of last Completion cycle of last

phase

phase

• Development of current Development of current

phase

phase

• Requirements of next phaseRequirements of next phase

• OnOn--going maintenance going maintenance

efforts to completed phases

(10)

Tax Compliance Infrastructure

Tax Compliance Infrastructure

Tax Compliance Infrastructure

• Matching individuals and entities allowing Matching individuals and entities allowing reports across data sources

reports across data sources

• Summarizing various data to the level of Summarizing various data to the level of tax return information for reporting

tax return information for reporting

purposes

purposes

• Identifies and tracks relationships Identifies and tracks relationships embedded in existing data

embedded in existing data

• Provides ability to track nonProvides ability to track non--filer activityfiler activity

Advantages of the Data Warehouse

(11)

Tax Compliance Infrastructure

Tax Compliance Infrastructure

Tax Compliance Infrastructure

• Continually modifying based on user Continually modifying based on user input

input

• More useful with each additional data More useful with each additional data source available

source available

• Useful for many bureaus Useful for many bureaus –– Audit, Audit,

Compliance, Research & Policy, etc.

Compliance, Research & Policy, etc.

More Advantages of the Data Warehouse

(12)

Data Warehouse Reports

Data Warehouse Reports

Data Warehouse Reports

Income and Asset report

Income and Asset report •

• All taxpayer information in one locationAll taxpayer information in one location

Current Financials

Current Financials •

• Sources for bank or employer collection Sources for bank or employer collection actions

actions

Address Report

Address Report •

• Complete address history across data Complete address history across data sources

(13)

Data Warehouse Reports

Data Warehouse Reports

Data Warehouse Reports

Multi

Multi--Year Compare Year Compare

• Shows data across subShows data across sub--set of yearsset of years

Relationship Look

Relationship Look--up up

• Research relationships of passResearch relationships of pass--through through entities

entities

Ad Hoc Capability

Ad Hoc Capability •

(14)

Data Warehouse Functionality

Data Warehouse Functionality

Security Measures

Security Measures

• Secure user name and password to accessSecure user name and password to access

• Session timeout when inactive • Software to track usage

(15)

Data Warehouse Functionality

Data Warehouse Functionality

Security Measures

Security Measures

• Authorization disclosureAuthorization disclosure

(16)

Data Warehouse Functionality

Data Warehouse Functionality

Audit User Portal

(17)

Data Warehouse Functionality

Data Warehouse Functionality

Compliance User Portal

(18)

Data Warehouse Functionality

Data Warehouse Functionality

Multi-Year Compare

Execution Options

Income and Asset Report

Current Financials Drivers Drivers

License: License: First Name: First Name: Last Name: Last Name: SSN: SSN: Top N: Top N: Taxpayer Search Taxpayer Search XXX-XX-XXXX Multi-Year Schedule C

This section contains representations of the reports available within the Data Warehouse and does not include actual taxpayer information.

(19)

Data Warehouse Reports

(20)

Data Warehouse Reports

(21)

Ad Hoc

(22)

WI Warehouse Success

WI Warehouse Success

• Data warehouse steering team providing Data warehouse steering team providing vision & direction

vision & direction

• Phased approach maximizing efficiencies Phased approach maximizing efficiencies and adding value

and adding value

• Focus on business user needs fostering Focus on business user needs fostering customer service environment

customer service environment

• Dynamic environment allowing for Dynamic environment allowing for

continuing evolution of useful reports and

continuing evolution of useful reports and

business projects

(23)

WI Warehouse Success

WI Warehouse Success

Workload and time savings

Workload and time savings •

• Consolidated IRS informational data with totalsConsolidated IRS informational data with totals •

• Ability to import data and extract files for projectsAbility to import data and extract files for projects

Audit projects

Audit projects •

• Merger of warehouses will help identify nonMerger of warehouses will help identify non--filersfilers •

• Project has identified $19 million in assessments by Project has identified $19 million in assessments by comparing Form K

comparing Form K--1 and Form 5S1 and Form 5S •

• Recycling surcharge project has already assessed Recycling surcharge project has already assessed $400,000 and collected $250,000

(24)

Tax Compliance Infrastructure

Tax Compliance Infrastructure

Summary

Summary

• Individual tax data warehouse infrastructure Individual tax data warehouse infrastructure is in place and end

is in place and end--users are impressed with users are impressed with query and reporting capabilities

query and reporting capabilities

• Integration of individual and corporate Integration of individual and corporate warehouses to further leverage data

warehouses to further leverage data

• Info center developed to bring users and Info center developed to bring users and developers together in dynamic

developers together in dynamic

environment

(25)

Questions?

Questions?

Tax Compliance Infrastructure

Tax Compliance Infrastructure

References

Related documents

Players can create characters and participate in any adventure allowed as a part of the D&D Adventurers League.. As they adventure, players track their characters’

The Business review of the Group can be found in the consolidated financial statements and Annual Report and Accounts of the Company for the year to December 31, 2013, prepared

Update Notes – This button updates all changes on the Early Alert form, and saves them into a row in the Current Student History Table.. Email & Print Letter – prints/emails

Section 41-b, para –4 : Every occupier shall, with the approval of the Chief Inspector, draw up an on site emergency plan and detailed disaster control measures for his factory and

Participation based upon informed synthesis of reading material (assigned as well as other retrieved information by the students from relevant publications) is

In these cases, directors and teachers are able to build partnerships with parents to meet the needs of young children with challenging behavior, with support from the mental

The accuracy of the clinical diagnosis of new-onset idiopathic pulmonary fibrosis and other interstitial lung disease: A prospective study. Raghu G, Weycker D, Edelsberg J,

The construction applies more generally: given any (sufficiently well-behaved) family of Riemann–Hilbert problems (RHP) where the jump matrices depend arbitrarily on