Sql Server Management

NICHOLAS DAVID STENGER

**** *. ***** **. *****: 720-***-****

Denver, Colorado 80222 Email: ****.*******@*****.***

[pic]

EDUCATION

University of Colorado, Denver, CO

M.S., Accounting

Graduation: 12/2004

Colorado State University, Fort Collins, CO

B.S., Business Administration

Emphasis: Computer Information Systems

Graduation: 5/2002

EXPERIENCE

TeleTech Holdings: 3/2008 - Present

Manager - IT Audit and Data Analysis

. Managed Sarbanes-Oxley Section 404 testing of Information Technology

General Controls (ITGC) for over ten critical systems including SAP,

Windows Active Directory and UNIX operating systems

. Identified key controls and created ITGC narratives based on interviews

with system owners and observation of job performance

. Managed follow-up procedures for existing audit issues using TeamMate and

TeamCentral

. Presented audit results to senior management

. Ensured compliance with company-wide information security requirements

for key information systems

. Performed an enterprise-wide risk assessment of the TeleTech Information

Technology environment and developed audit plans to address identified

risks

. Executed a network and data security audit to identify weaknesses in the

internal and business partner network environment

. Supervised and executed multiple audits simultaneously

. Assisted in the performance and review of business process internal

controls testing for Fixed Assets, Accounts Payable, Payroll, FSCP,

Leases and ELCs

. Planned, developed and executed audits of construction management, lease

processing, accounts payable, fixed assets, payroll and the consolidation

process

. Produced audit reports presented to the audit committee and senior

management

. Identified and recovered over $500,000 in previously unidentified

duplicate payments to vendors via targeted database analysis

. Implemented a three tiered continuous auditing environment using SQL

Server 2008, C# and SQL Server Reporting Services

. Designed and implemented disaggregated cost and revenue reporting

retrieved from disparate TeleTech application systems at the request of

senior level executives

. Developed reports on an ad-hoc basis at the request of the Chief

Financial Officer and management within the Finance organization

PricewaterhouseCoopers LLP: 4/2005 - 3/2008

Senior Associate - Advisory Services, Technology

. Developed technical and user requirements documents for a business

activity monitoring software implementation within a highly visible

government client

. Led meetings with key client stakeholders to develop high level project

plans and identify key milestones

. Created detailed project schedules outlining tasks and responsible

parties

. Responsible for managing associates in advisory and assurance engagements

with a focus on establishing roles, providing direction, and ensuring the

use of best practices

. Evaluated and documented business processes based on interviews with

client contacts in accounting, management and information technology

. Designed and implemented an automated targeted transaction testing system

for the assurance practice using SQL Server 2005, Oracle 10g and SQL

Server Reporting Services

. Analyzed financial accounting data extracts from financial systems

including Oracle, PeopleSoft, SAP, and J.D. Edwards

. Designed and developed databases for independent analysis of client data

. Performed targeted assessment of transactional data underlying the

Hyperion consolidation process which focused on evaluating the effect of

manual journal entries having material impact on financial statements

U.S. Department of the Interior: 6/2003 - 4/2005

Staff Accountant - Branch of Financial Statements

. Assisted in the development of month/quarter/year-end financial

statements

. Performed internal audits of account balance reconciliations

. Coordinated responses to auditor inquiries

. Managed the reconciliation of property, equipment and capitalized lease

transactions between subsidiary ledgers and the general ledger

. Developed activity based cost accounting reports providing expenditure

and overhead allocation information to assist management in the

distribution of limited resources

. Created Crystal Reports for system users to view relevant managerial

accounting information

SKILLS

Programming: C#, VB.NET, ASP.NET 2.0

Database: SQL Server 2005, SQL Server 2008, SQL Server Integration

Services, SQL Server Analysis Services, SQL Server Reporting

Services, Oracle 9i/10g, SQL*Plus, Toad, Audit Command Language, MS

Access

Web Services/Scripting: SOAP, XML, XSLT

Software: BizTalk 2006, SharePoint 2007, MS Office Suite, Crystal Reports,

Business Objects, TeamMate

ERP: Oracle, SAP, Hyperion, PeopleSoft

Federal: USSGL, Appropriations Law

Frameworks: COSO, COBIT

CERTIFICATIONS

. Certified Information Systems Auditor (CISA)

. Microsoft Certified Technology Specialist: SQL Server 2005

MEMBERSHIPS

. ISACA

. IIA

Contact this candidate