Thomas C Hill

** ******** ***.

Marcellus, NY ***08

512-***-**** abivo5@r.postjobfree.com

DATA ANALYST/OFFICE ADMINISTRATOR

Solutions-oriented developer with a proven record of success in working

with MS ACCESS and MS EXCEL applications, building and revamping relational

databases, EXCEL spreadsheet analysis, report presentation design, and end

user training

> Demonstrated expert knowledge of the stages of database construction

using MS ACCESS including: data modeling with table relationships,

import/export functions, ODBC interfacing, advanced form & report

design, high-level query writing, macro automation and user training

within the application

> Have distinguished myself as an advanced MS EXCEL user displaying

proficiency with charts, pivot tables, V-Lookups, macros, if

statements, advanced formulas, formula cell linking, protection, add-

ins, automation with MS ACCESS, and more

> Possess an excellent record of training on developed applications that

spans from the hands-on instruction of small groups of individuals to

classroom presentations to employees through the use of overhead

presentation and teaching aids

> Displayed leadership skills, initiative, and a self-motivated work

ethic that has always resulted in increasing responsibilities, and the

overall satisfaction of middle and front office management

> Have functioned as an extremely effective liaison between IT

professionals and employees working with developed applications which

had led to training responsibilities often in the past

Core Competencies

V MS applications development

V Report Design & Presentation

V A/P-A/R invoicing expertise

V Extensive Training Acumen

V Marketing Data Analysis

Technical Proficiencies

Platforms: Windows XP/Vista/Windows 7

Languages: SQL

Tools: Microsoft Office Pro (Word, PowerPoint, EXCEL, ACCESS), Norton

Anti-Virus, McAfee Firewall, Crystal reports, SQL Server

PROFESSIONAL HISTORY

Transaver Inc

November 2005-February 2007

Data Analyst

Utilized extensive reporting techniques using MS ACCESS and MS EXCEL in an

effort to target various "market segments" of customers to determine

marketing strategies that will maximize sales dollars, sales volume and

acceptable general margins for adequate pricing.

Key Contributions

* Automation of monthly reporting functions for the company using

Scheduled Tasks and advanced ACCESS macros

* Customized EXCEL spreadsheets with macros and cell formulas to

automate data calculations

* Worked with advanced EXCEL graphing techniques, using pivot

tables/cross tabs to pinpoint deficiencies in current marketing

strategies (bids, contracts, catalogs, mailings, email)

* Changed the database modeling to provide referential integrity to the

record sets, and cascading table information which resulted in an

improved integration of MS ACCESS data

Allright Central Parking

September 2004-December 2004

Office Manager

Used and implemented advanced EXCEL spreadsheets to monitor money and

employee performance for local office in Syracuse, NY. Responsibilities

included all AP/AR functions for the office

Key Contributions

* Managed account balancing for local office

* Complete automation of the reporting tools, allowing the end-user a

simple process by which to obtain data through the use of MS EXCEL

* Prepared a replacement for full-time office management capacities

working with designed software applications

Clearcube Technologies

May 2002-September 2002

JD Edwards IT Analyst

Worked within the JD Edwards One World proprietary application to clean

corrupted files, restore integrity to the data, and revamp the data

modeling & table relationships through the use of SQL code and the

application itself

Key Contributions

* Was responsible for the elimination of corrupt data and

duplicate/orphan records within the database

* Perfected the report presentation within the application so that

reports generated were accurate, concise, and easy to interpret

* Enjoyed the privilege of presentation during numerous front office

management review meetings. Presentations indicating the progress of

the project were prepared using PowerPoint, ACCESS, and Crystal

applications, and subsequently presented in a clear, smooth and

professional manner

Newport News Shipbuilding

September 2000-Dec 2001

Associate Operations Coordinator/Data Analyst

Developed and maintained MS ACCESS Databases that tracked the allocation of

funding for DOD Confidential Nuclear Aircraft Carrier Overhauls. These

databases where required to have sound, accurate data, while discretion &

attention to detail in this environment was a must. This position also

entailed the heavy use of the MS EXCEL application for reporting and

calculating purposes

Key Contributions

* Reporting functions were automated to perform without fail in an

exacting, as well as highly bureaucratic IT client/server environment

* Confidential demographic material was analyzed to the consistent

satisfaction of management as a result of expert use of the MS EXCEL

application

* Many successful presentations (using PowerPoint, Crystal) as well as

employee training seminars were conceived & executed while serving

the Navy as a civilian developer

*This position required the obtainment of DOD CONFIDENTIAL government

security clearance

Education & Credentials

Bachelor of Arts in History

SUNY GENESEO

Professional Training & Certifications

MS ACCESS

MS EXCEL

Contact this candidate