Human Resources Office

Andrew Hill

**** ***** ******** **** ***. *** Alexandria, VA 22311 Cell 301-***-**** ***********@*****.***

SUMMARY

Accounting and Management Information Systems professional with experience in financial statement

preparation, data analytics, and creation of databases . Self-starting and innovative thinker who is

competent in solving complex issues and improving business processes through detail-attentive.

PROFESSIONAL EXPERIENCE

Bureau of Alcohol, Tobacco, Firearms and Explosives

Office of Human Resources & Professional Development (HRPD) Washington, D.C.

Program Analyst/Sunflower - Asset Center Representative/Site Coordinator Tech

Refresh/LearnATF Training Coordinator/HR Connect Proxy/Pathways Intern Jan. 2013 – Aug. 2014

• Create and maintain financial reports to monitor budget execution of funds and gathering data for

tracking and evaluation assigned program spending of $18 million budget

• Analyzing spending and performance of assigned areas for mid-year, third quarter, and end of

year reviews

•Perform analysis and prepare reports related to costs for Government Furnished Equipment (GFE)

and Government Furnished Property (GFP)

•Compile relevant information to aide command staff with the decision making for asset acquisition,

replacement, and distribution to 162 HRPD employees

• Recommend, plan, and conduct analytical studies using workforce data and metrics to identify

and address relevant, actionable Bureau business and mission concerns for HRPD and all other

directorates totaling 4,800 employees

• Design and implement queries to extract workforce information from various systems and

databases

•Initiated hiring and reassignments for all HRPD staffing

Baltimore Field Division Baltimore, MD

Program Analyst/Pathways Intern Nov. 2010-Jan. 2013

•Prepared financial reports on a $8 million tobacco smuggling/tax loss investigation

•Reconciled monthly expenditures and credit card statements for task force officers

•Performed analysis and prepared reports related to costs for equipment and other expenses

•Created and reviewed spreadsheets on time & attendance (T&A) and overtime reports totaling $500

thousand for task force officers

•Received Special Act Award in May 2012 for work on the tobacco smuggling investigation

Small Business Development Center

Saint Francis University Loretto, PA

Intern – Students in Entrepreneur and Economic Development Aug. 2006-May 2010

•Reviewed business plans and recommended changes for clients

•Developed database for Renewable Energy Center of energy saving companies

•Prepared projected balance sheets and cash flow statements for clients

Bureau of Alcohol, Tobacco, Firearms and Explosives

Financial Investigative Service Division Pittsburgh, PA

Intern May – August 2009

•Reconciled beginning and ending year purchases for insurance fraud investigations

•Analyzed bank statements and financial records for criminal prosecution of fraud cases

Andrew Hill

CERTIFICATIONS

• Six Sigma White Belt, Aveta Business Institute

EDUCATION

Saint Francis University Loretto, PA

Bachelor of Science in Accounting and Management Information 2014

University of Phoenix Expected Completion September 2014

Certificate in A+ Fundamentals Certificate

ACTIVITIES/VOLUNTEER EXPERIENCE

Psi Upsilon Fraternity

Treasurer March 2008 – May 2010

Responsible for overseeing the financial security of the fraternity and organizing/planning fundraisers.

Boy Scouts of America, Eagle Scout 2005

TECHNICAL SKILLS

Proficient in Microsoft Office (Excel, PowerPoint, Access, Word, and Outlook), HR Connect, and

Sunflower Systems

Contact this candidate