Jason (Jay) Ilstrup Email & Phone Number

Minneapolis, Minnesota, United States

•Ensure the timely and accurate accounting close each month using the General Ledger system and Power Plan applications. Responsible for overseeing the preparation of the quarterly tax depreciation and deferred tax reporting for corporation. Oversee the preparation and completion of plant related federal and state filing forms. •Responsible for the overall supervision, training and development of the Capital Asset Accounting (Tax) team.•Effectively manage tax related capital asset forecast processes and reporting activities supporting the quarterly five- year corporate forecast. Provide tax depreciation and deferred tax analytics and support to Operations and Finance.•Direct and supervise staff preparation of various mandatory external financial reports of the Company which support SEC, FERC, and state regulatory filings. •Maintain documentation and perform quarterly testing of Sarbanes Oxley controls. Coordinate internal and external audit activities.

Minneapolis, Minnesota

• Executed Sarbanes-Oxley 404 (SOX) annual internal control testing for assigned processes. Evaluated and analyzed the operational effectiveness of key controls and communicated results to business partners and leadership. • Planned, developed and executed internal audit and consultation activities for assigned engagements. Focus areas included FERC Accounting & Reporting, Human Resource Operations and Robotic Process Automations.

Greater Minneapolis-St. Paul Area

• Planned, developed and managed the execution of business and operational audits for key functional areas supporting the Twin Cities Region. Successfully partnered with internal clients to develop and implement remediation plans to address identified control gaps while optimizing efficiencies within functional areas. • Developed strategic partnerships with the Enterprise Business Intelligence Applied Analytics Team and successfully identified opportunities to automate and enhance existing Business Assurance compliance reporting using Tableau and enterprise warehouse data. Tableau based sales excellence and compliance reporting were developed and successfully rolled out across the West Division. • Partnered with the Supply Chain Team to develop a strategy and implement the required business process changes to efficiently facilitate CPE reconciliations across the region. The region is now in compliance with company policy and has effective monitoring and oversight of CPE assets. • Developed and maintained a collaborative partnership with Comcast’s Internal Security Team to support sales integrity, ethical and fraud investigations within the region.

Greater Minneapolis-St. Paul Area

• Managed four major concurrent system initiatives that impacted finance systems and delivered the required infrastructure to establish a sustainable program to drive regulatory compliance on hazardous waste disposal and reverse logistic activities for Target Corporation while enhancing financial reporting capabilities. • Proactively communicated project strategy, key decisions and potential issues to finance leaders ensuring stakeholders had the appropriate information to support proposed solutions which aligned with strategic objectives and resource constraints.• Managed finance end to end and integration test activities that validated system functionality, as well as the financial accuracy of transactional data supplied to downstream applications. • Ensured stable transition to upgraded finance and store systems by actively managing defect resolution process and focusing project team’s resources on issues that adversely impacted guests, store operation or the accuracy of financial data.

Greater Minneapolis-St. Paul Area

• Managed Target’s implementation of the SAP Fixed Asset application for both United States and international entities. The project was completed in less than two years, on time and within budget. • Led blueprint design activities and ensured final business process and system solutions met business requirements. • Directed configuration and functional testing activities which validated system functionality and accuracy of general ledger accounting transactions resulting from asset maintenance and posting of depreciation expense. • Ensured $43B asset base was accurately converted for existing and newly created financial and tax books.• Supported OCM change management strategy by developing comprehensive training materials and job aids that supported the technology implementation, process improvement initiatives and organizational design changes resulting from the ERP implementation.• Led and coached a staff of two Business Process Analysts and indirectly supervised five contractor resources.

Greater Minneapolis-St. Paul Area

• Planned, developed and managed the execution of Sarbanes-Oxley 404 (SOX) process reviews, miscellaneous financial audits and new technology consultations. • Supported annual SOX scoping of United States financial processes, systems and risk and controls.• Evaluated and analyzed the effectiveness of processes and key controls and communicated results to senior management. Focus areas include: Accounts Payable, Financial Statement Close (10Q & 10K), Inventory Accounting, and Property Accounting. • Planned, developed and managed integrated SAP consultations which validated the accuracy and completeness of financial and master data transferred between legacy and SAP applications and assessed the project’s impact to the existing internal control environment. • Responsible for the direct supervision four analysts. Indirectly supervised an additional six analysts.

Greater Minneapolis-St. Paul Area

• Managed Target’s Fixed Asset team and $27B asset base. Ensured financial and tax books were properly accounted for in compliance with GAAP and regulatory requirements. Recorded and monitored $1.5B in annual amortization and depreciation expense. • Partnered with the Capital Finance team to complete the monthly corporate gain/loss forecast.• Key accomplishments include supporting the sale of Mervyn’s and Marshall Field’s subsidiaries and subsequent 1031 exchange activities, effectively managing two major FA system software upgrades, and team reorganization to stabilize turnover and better align pay grades with job responsibilities.• Led and responsible for the overall supervision, training and development of nine Fixed Asset team members.

Greater Minneapolis-St. Paul Area

• Provided tax and accounting services to clients’ implementing complex corporate restructuring business plans. • Reviewed and analyzed financial statement data for corporations engaged in merger and acquisition activity to determine tax ramifications.• Developed comprehensive state income tax models to quantify pre and post restructuring state tax liabilities resulting from proposed restructurings.• Supervised the preparation of state income tax returns for assigned clients. • Supervised Accounting Associates supporting project.

Greater Minneapolis-St. Paul Area

• Provided tax and accounting services to clients’ implementing complex corporate restructuring business plans. • Reviewed and analyzed financial statement data for corporations engaged in merger and acquisition activity to determine tax ramifications.• Developed comprehensive state income tax models to quantify pre and post restructuring state tax liabilities resulting from proposed restructurings.• Supervised the preparation of state income tax returns for assigned clients. • Supervised Accounting Associates supporting project.

Greater Minneapolis-St. Paul Area

• Managed sales tax consulting projects which focused on identifying and recovering tax overpayments remitted to suppliers or filed directly as a self-assessment of use tax. • Provided guidance and audit defense for clients undergoing sales and use tax audits. • Supervised audit team consisting of three to five Accounting Associates.

Greater Minneapolis-St. Paul Area

• Responsible for preparing and reviewing multiple state sale and use tax returns.• Completed special projects to improve accuracy and integrity of sale and use tax returns.• Verification and cost allocation for contract payments and invoices on assigned construction projects.• Reconciled general ledger accounts.

Bachelor Of Arts (B.A.), Finance And Financial Management Services

Associate Of Arts (A.A.)