Administrative Assistant Quality Assurance
Resume:
Gary R. Whiteford
http://www.linkedin.com/in/garywhiteford
***********@***.***
[pic]
Expert user of Excel (PivotTables, VLOOKUPs, VBA) and Access with over 5
years of data analysis experience, including reconciliations, data mining
and quality assurance. Driven by learning new applications and becoming the
local expert and "go-to guy." Looking to grow toward a project-oriented,
data analyst job involving Excel.
[pic]
Work History:
Associate HR Operations Analyst
2007 - 2011 Medtronic, Inc.
Fridley, MN
Responsibilities: Report generation, metrics development and production,
Excel application development (VBA and project automation), systems
bridging (TALX I-9 eXpress and PeopleSoft), I-9 compliance and system
support, I-9 system training development and delivery, complex account
reconciliations support, skilled technical support, handling of sensitive
information, recognized leader in collaborative networking innovation
(leader of the ExcelUsers community).
Accomplishments: Started ExcelUsers community on Medtronic's Information
eXchange (internal collaboration site). Received Top Solver award FY11 Q2
for work on ExcelUsers community.
Contractor
2007 - 2007 Dolphin Staffing at Medtronic, Inc.
Shoreview, MN
Responsibilities: Creation of process flows in MS Visio. Data analysis in
MS Excel. Complex mail merges. General typing.
Client Service Assistant
2002 - 2006 Larson Allen Weishair & Co LLP
Minneapolis, MN
Responsibilities: Assemble and send documents to clients for submission to
federal and state tax and medical assistance reporting authorities.
Evaluate and use Sant Suite ProposalMaster proposal document management
software. Manage documents using CCH proSystem fx Engagement. Prepare
extensions and modify tax returns as directed using CCH proSystem fx Tax.
Prepare and finalize engagement letters and other correspondence. Make
travel arrangements, manage calendars and other direct support for two
principals, three managers and various staff in the health care industry
group.
Office Manager
2002 - 2002 Farmers Insurance Group
Maple Grove, MN
Responsibilities: Performed office manager and administrative assistant
functions (technology support, correspondence and presentations, customer
and agent calls, calendars, supplies). Worked on a contract basis.
Consultant
2000 - 2002 Davies Consulting Inc
Bethesda, MD
Responsibilities: Performed research and analysis functions using Internet
and MS Office suite. Tasks included pulling financial and system data via
Internet from a Federal database and using MS Access 2000 to combine that
data with performance survey data from a para-utility organization to plot
trends using MS Excel, researching company data from SEC filings of various
companies to contribute information to proposals for consulting work with
other companies, and performing other research and analysis functions.
Worked from home in Minneapolis.
Teacher
1997 - 2000 Fourth Baptist Christian School
Plymouth, MN
Responsibilities: Taught publishing/design class using PageMaker 6.5 and
MS FrontPage on a Windows platform.
Administrative Assistant
1992 - 1999 Xcel Energy (formerly Northern States Power Co)
Minneapolis, MN
Responsibilities: Provided administrative support at senior management
level (tasks included scheduling, processing correspondence and creating
presentations). Supervised office staff (included file room, supplies,
facilities, training, and general support). Maintained budgets and
departmental payroll records.
[pic]
Education:
Bob Jones University
Bachelor of Science (Complete)
Experience (Associate Report Analyst)
Skill/Requirement Related Experience
SQL Experience 3 years of Oracle SQL experience
Writing queries against PeopleSoft
database
Pulling data to meet customer
requests
MS Excel Experience 10+ years
Automating department processes
Metrics collection and production
Automating processes with Excel
VBA
Manipulating (import/export) files
Producing and modifying
PivotTables
Controlling objects (folders,
emails, etc.) in MS Outlook
Controlling objects (HTML,
documents, fields, etc.) in MS
Internet Explorer
Controlling objects (slides,
graphics, etc.) in MS PowerPoint
Proficient using lookup
methodologies, including
VLOOKUP, INDEX /MATCH, array
formulas, OFFSET, etc.
Generating regular and ad hoc
reports for management use
Created department metrics tool in
Excel that collected data and used
macros and buttons to update
summary tables, PivotTables and
charts, move results to
PowerPoint, upload to SharePoint
folder and update on a central
display.
Created tools to aid in accounting
reconciliations using one "What's
Next" button and VBA to walk user
with basic skills through complex
process (updating tables and
PivotTables behind the scenes)
MS Access 5+ years
Importing data from various
sources, including flat text and
Excel files (union queries, etc.)
Exporting tables and query results
Writing complex queries and
expressions to transform data and
perform analysis
MS Word Performing advanced merge
functions
Utilizing styles for document
consistency
Other advanced functions
MS PowerPoint, Outlook See notes under MS Excel (above)
Contact this candidate