Philip T. Huffman
Newark,DE
Summary
Analyst with extensive experience in [Fields]. Proficiencies include [Skill set 1] and [Skill set 2].
Overview
19
19
years of professional experience
Work History
Business Analyst
HSBC
New Castle, DE
10.2009 - 12.2009
- Prepare monthly reports in Excel, Access, and PowerPoint in RAD environment.
- Write queries to extract data from Access database to export to Excel for charts and graphs for PowerPoint presentations.
- Requires advanced knowledge of program's capabilities.
Relational Databases
Champlain College
01.2009 - 03.2009
Business Analyst
DKR ent
Newark, DE
11.2008 - Current
- Develop MS Access database for Insurance Co.
- to track premium plans from Excel spreadsheet.
- Train personnel in MS Excel and Access usage to improve proficiency.
- Consult with DBA for Oracle database.
- Environment: MS Access, MS Excel, VBA.
Adjunct Faculty
DeVry University
10.2008 - 03.2018
- Course Title: 1.
- Data Analysis with Spreadsheets with Lab 2.
- Intro to Scripting & DB w/Labwit.
Barclay Card USA
Wilmington, DE
08.2008 - 11.2008
- Develop Access database for marketing product development with VBA programming.
- Train personnel in database usage.
- Create help manual for database.
- Document programming, data flow, streaming, and program logic.
Accounting/Database Consultant
VWR, Inc.\TEK Systems
West Chester, PA
09.2007 - 03.2008
- Developed Access database to track wireless assets for SOX internal controls.
- Prepared Access queries to analyze expenses for allocations, usage, and type.
- Trained personnel in corporate wide usage on manager level.
- Project reduced expense by 30% monthly.
Accounting/Database Consultant
Citibank
New Castle, DE
12.2006 - 06.2007
- DBA for 3 major production Access databases with 35 linked databases and 250 users for check proof processing system.
- Write VBA code to enhance performance and solve user requirements.
- Prepare accounting write-off reports for proof system.
- Perform ftp process for India transactions.
Grantham University
08.2006 - 03.2008
- Course Titles: 1.
- Programming in C++, 2.
- MS Access Database Applications Rasmussen College 7/11-5/12 Course Title: Computer Focused Principals for QUICKBOOKS.
Accounting/Database Consultant
Jones Lang LaSalle
Jenkintown, PA
05.2006 - 07.2006
- Performed Database development for budgeting process for 485 company sites in Access, Excel and VBA.
- Worked as functional team lead.
- Performed Data source analysis and import.
- Programmed for data collection.
- Developed database for customer service and invoice tracking.
- AIG-Marketing Inc., \RCG IT Wilmington, DE IT Finance/MS Access to SAP FI-CO Conversion Temporary Assignment 10/05-3/06 Created MS Access databases for data collection to generate IT Finance journal entries for SAP Financials.
- Worked as functional team lead in SAP.
- Performed Data source analysis and import to MS Access DBs via ODBC from legacy systems (Waves) and Ariba.
- Designed, coded and prototyped MS Access DB for vendor variance analysis.
- Used Hyperion Pillar and Essbase budgets for variance analysis against SAP Financials.
Comcast Cable/ Peopleflex
Philadelphia, PA
- Accounting/Database Consultant Temporary Assignment 8/06-10/06 Develop MS Access database for current VOD & DVD titles, 125 providers, and 75 national reporting areas Implemented use of MS Excel macros to decrease report processing time.
- Prepared monthly sales and operations reports for Program Accounting.
Education
M.S - Computer Information Systems
University of Phoenix Online
2002
B.S.B.A - Accounting
Thomas Edison State College
1982
Skills
SAP FI-CO G/L SD, Oracle Financials 11i Accounting System, QuickBooks
Tools: MS Excel, MS Access, MS Visio, MS Project, MS PowerPoint, C/C
- Accounting, Accounting System, budgeting, budgets, C, C, charts, Consultant, Conversion, customer service, Data Analysis, data collection, DBA, databases, Database, Database Applications, Database development, DVD, ERP, Essbase, Excel and VBA, Finance, Financials, ftp, functional, graphs, Hyperion, Insurance, team lead, logic, macros, Marketing, Access, Access database, MS Access, MS Excel, Excel, MS PowerPoint, PowerPoint, PowerPoint presentations, MS Project, ODBC, Oracle database, DB, Oracle Financials, personnel, marketing product, Programming, QuickBooks, RAD, reporting, sales, SAP FI, SAP, SD, Scripting, Spreadsheets, spreadsheet, type, variance analysis, Visio, VBA
Timeline
Business Analyst
HSBC
10.2009 - 12.2009
Relational Databases
Champlain College
01.2009 - 03.2009
Business Analyst
DKR ent
11.2008 - Current
Adjunct Faculty
DeVry University
10.2008 - 03.2018
Barclay Card USA
08.2008 - 11.2008
Accounting/Database Consultant
VWR, Inc.\TEK Systems
09.2007 - 03.2008
Accounting/Database Consultant
Citibank
12.2006 - 06.2007
Grantham University
08.2006 - 03.2008
Accounting/Database Consultant
Jones Lang LaSalle
05.2006 - 07.2006
Comcast Cable/ Peopleflex
M.S - Computer Information Systems
University of Phoenix Online
B.S.B.A - Accounting
Thomas Edison State College