Manager Data

NICOLE E. WOLCOTT

*********@*****.*** Tucson, Arizona 239-***-****

SUMMARY

Finance/Data analyst with a unique combination of 10 years data analysis and management along with five years of

experience working with financial statements. Skilled in using a variety of database, accounting, and Microsoft

Office software programs. Bring wealth of practical knowledge and understanding of best practices, with proven

experience as a team leader and manager.

EDUCATION

Master of Science, Information Systems, University of Phoenix, 2014

Bachelor of Science, Business/Accounting, University of Phoenix, 2011

Associate of Science, Computer Science, Bryant & Stratton College, 1997

PROFESSIONAL EXPERIENCE

Sierra Tucson, Tucson, AZ May 2013 to January 2014

Residential Rehabilitation and Psychiatric Hospital

Intake Analyst

Responsible for daily, monthly, and quarterly reporting of Intake Department data. Analyzed a variety of data

extractions for admissions trends using Pivot Tables, V-Lookup, and H-Lookup in Excel. Utilized Salesforce.com as

the primary data center.

• Used data mining to identify anomalies regarding the increased rate of patients leaving against medical

advice (AMA) decreasing the AMA rate by 35%

• Analyzed existing marketing strategy using specific data elements relating to referent contact information

uncovering a significant decrease in referent based leads

NPL Construction, Tucson, AZ June 2012 to May 2013

Builders of Energy-Distribution Systems

Systems Analyst - Contractor

Under temporary contract to maintain over 4 major database systems utilizing Microsoft Access. Custom built, as

requested, database systems to track the results of various projects in Arizona. Utilized Visual Basic and SQL

languages to create reports employing data manipulation to display results by geographic location.

• Constructed database fully automating the entry and tracking of random leak surveys limiting user access

based upon customer demographic data elements preventing the change of existing records

• Modified existing Customer Owned Yard Line (COYL) database to produce efficient reporting and entry of

program results

Modular Mining Systems, Tucson, AZ August 2011 to

April 2012

Engineers of Mining Hardware and Software

Senior Accountant - Contractor

Contracted to analyze nine international sets of financial statements. Efficient user of SAP ERP system.

• Based upon data manipulation results created two database programs for financial statement consolidation

NCA Financial Services, Tucson, AZ November 2010 to August 2011

Business Manager - Contractor

Contracted to streamline procedures for company and President’s personal business ventures. Ensured accurate

financial business reports due monthly, quarterly, and yearly to state and government agencies.

• Transferred data from Peachtree to QuickBooks

• Automated company and President’s household after the death of the owner’s wife

Nicole Wolcott Page 2

David Scott Madwar, MD, Naples, FL January 2008 to

September 2010

Concierge Medical Practice

Business Manager

Ensured cash accounting activities were performed accurately including accounts payable, accounts receivables,

and bank reconciliation. Analyzed trends, assets, and financial commitments using data mining to identify spending

patterns that effect future revenues/expenses.

• Assisted with growing medical practice from 50 patients to 250 patients in less than two years by analyzing

the distinct difference between patient medical data elements identifying those who receive a high level of

benefit from the investment

• Implemented and maintained new medical charting system to meet Florida Health Laws

• Manipulated budgetary data to identify a method to finalize line of credit in 1 year rather than 5 years

Ackerman Insurance Services, Naples, FL July 2006 to January 2008

Financial Reporting Analyst

Provided reports to president on monthly operations using Microsoft Excel Pivot Tables. Manipulated financial

data to ensure timely payment of debts and agent commissions.

• Assisted with the creation of internal controls which decreased risk by 20%

• Completed collection calls which prevented cancellation of insurance policies by 25%

• Maintained database and performed data mining to ensure the integrity of the data input

Gulf Coast American Fabrication, Naples, FL January 2001 to

July 2006

Window Covering Manufacturer

Program Coordinator

• Created, implemented and maintained seven Access databases for use in various areas of the company

• Developed/updated monthly reports for Credit departments using Excel macros and Pivot Tables to

manipulate data increasing receivables rate by 15%

• Trained employees in all aspects of Microsoft Office creating a more efficient staff

Walden University, Bonita Springs, FL March 2000 to January 2001

Online University

Systems Analyst

• Used Microsoft Access and Excel Pivot Tables and V-Lookup to mine data for applicants who met the

criteria for enrollment

• Designed a communications program using only e-mail, saving 27% of the overall cost of marketing

• Traveled extensively for training on the Datatel system in order to make more efficient use of the system

Global Success Publishing, Naples, FL July 1998 to

March 2000

Medical Newsletter Publisher

Database Administrator

• Decreased order entry time from 48 hours to 12 hours

• Decreased fulfillment of new orders from weekly to less than 24 hour turnaround

• Recommended upgrade of database and addition of Windows NT network server improving file storage

Gelia, Wells, & Mohr, Clarence, NY February 1996 to July 1998

Advertising Agency

Database Administrator

• Created and maintained new business development database averaging two new clients per month

• Analyzed new client prospect financial data elements to determine if a suitable fit for agency programs

• Mined IT expenses data leading to the addition of a T1 phone line saving 15% in first month

Contact this candidate