Human Resources Developer

Vernon Reid

Vernon Reid

New York, NY

Phone: 347-***-**** Email: ********@*******.***

MS Access Developer / MS Excel Specialist / Reporting Analyst

Well rounded skill set. Able to function independently or as a cooperative team member.Noted for interpersonal and intercommunication skills combined

with the right blend of enthusiasm to function effectively at any level.

Key Accomplishments:

Received high accolades and awards for creative problem solving and client focus, (e.g. Prudential Champions of Change Award, and Achieving

Performance Excellence [APEX] Award).

Consistently achieved 95% to 100% client satisfaction rating when benchmark was 80% to 85%.

Highlights of qualifications and experience:

10+ years MS Access development • 15+yearscorporate experience• Extensive knowledge of MS Access/MS Excel

Microsoft Certified Access Expert • Microsoft Certified Excel Expert – Extensive reporting, automation and data analysis capabilities using MS

Access and MS Excel (any version up to 2010). Possess expert database design capabilities. Can customize, implement, and maintain MS Access

databases, applications, and solutions to support multiple programs including accounting, finance, marketing, human resources, etc.Utilizes VBA

(Visual Basic for Applications) to improve database functionalities and structure.Able to prepare and write detailed database design

documentation and user manuals. Able to integrate MS Access with MS SQL Server, full or partial upsizing. Possess strong Excel/Access data

analysisskillsutilizing advanced functionalities, e.g.Excel/Access integration, data quality assurance, data transformation, data cleansing, macros,

VLookup, HLookup, 2D lookup, charts, pivot tables, spreadsheet design, etc. etc.

WORK EXPERIENCE

May 2012 – Mar 2013 – CCSI Staffing (Contract) – Public Service Electricity and Gas (PSE&G), 80 Park Plaza, Newark, NJ

MS Access Developer / Database Analyst / Consultant

Designed, coded, tested, and delivered MS Access Database solutions using multiple data sources to automate processes related to management reporting for

solar energy generation, e.g. performance ratios measurement, lost revenue calculation, solar energy generation comparison,etc. The prior processes were

performed manually in Excel spreadsheets. The newprocesses which included MS Access VBA and Excel were 100% error free and produced cost savings and

efficiencies up to 95%.Conducted group overview sessions and wrote user friendly procedures manual(s) to enhance end users understanding of database

functionalities.

Sept 6 Sept 12, 2011 Creative Solutions Services (Contract) – Thomson Reuters – Human Resources, Times Square, NY City

MS Access/ Excel Consultant

Short term assignment (client needed in a hurry) to update features for combined MS Access/MS Excel Application to automate management reporting for

employee’s talent assessment. Application included data export from Access to Excel spreadsheet to populate report grid, plus Excel macros to refine data

presentation.

Apr 19 Apr 24, 2011 Bernard, Nickels & Assoc.(Contract) Henry Schein Inc. –Information Systems, Melville, Long Island, NY

MS Access Developer / Consultant

Emergency assignment to repair MS Access Database/Application that processes capital budget report. Rebuilt tables, queries, forms, report, and

other features to facilitate one click time saving generation of capital budget report. The required repairs improved efficiency and eliminated

potential errors.

May 2009 – Dec 2010 – Started Ecommerce home based business to offset difficult job market.Created personal websites (hosted by Yahoo) to promote

affiliate marketing with Google, Amazon, LinkConnector, ClickBank, Shareasale, etc. Utilized EBay platform to market multiple products, e.g. Microsoft

Windows, Tablet PCs, Cell Phones, etc. I decided to return to consulting in order to utilize my skills and background. The business was closed in December

2010.

Nov 2007 – July 2008, Network and Co (Contract) – Morgan Stanley Corporate Treasury& Private Wealth Mgmt, New York, NY

MS Access Developer /Consultant

Multiple Assignments: Developed combined MS Access/Excel application to automate daily P&L processing; including user interface to auto import over

twelve Excel spreadsheets into MS Accessto facilitate analysis and calculations (e.g. foreign exchange calculations, interest calculations, etc.) then auto

exported analyzed and calculated data back to Excel to populate P&L summary.The new automated process eliminated errors, improved efficiency, and

Page 1 of 3

Vernon Reid

Vernon Reid

New York, NY

Phone: 347-***-**** Email: ********@*******.***

reduced processing time by over 90% compared to prior manual MS Excel process. Developed MS Access application to automate long term debt financial

control process,current and non current maturity analysis, cash flow analysis, etc. Wrote procedures manual and provided training to users.

Nov 2006 – July 2007, Strategic Staffing Solutions (Contract) – JP Morgan Chase Global Tax Services, Chase Plaza, NY City, NY

MS Access Developer / Consultant

Designed and built MS Access Database/Application to report year end income for worldwide escrow accounts, achieving over 90% accuracyimprovement

versus prior manual MS Excel process. Built user interfaces to auto import multiple excel spreadsheets to analyze and report income. Utilized query and VBA

functionalities to insert income into reporting tables.Designed and built MS Access Application to automate validation of IRS tax forms for escrow product

line. Extracted data in real time via ODBC connection with SQL Server. Provided training to users and managers to operate databases.

Aug 2006 – Oct 2006, InSys Consulting (Contract) – AIG American International Group, Human Resources, New York City, NY

MS Access Developer / Consultant

Created MS Access Databases/Applicationsto automate Human Resources global bonus payout calculations,compensation market data analysis, and head count

reporting. The databases/applications improved overall turn around time and accuracy rate up to 95%. Developed data input screens with calculation

formulasand user friendly auto updates that eliminated errors and significantly improved controls. Designed import menu screens to auto upload data from

multiple Excel spreadsheets (local and international sources).Wrote procedures manual as reference material and provided training to managers and users.

Nov 2005 – Aug 2006, Analysts International (Contract) JP Morgan Chase Corporate Regulatory Reporting, Jersey City, NJ

MS Access Developer / Consultant

Customized and built user friendly, menu driven MS Access Databases/Applications to automate corporate regulatory reporting, e.g. Securitization and Asset

Sale Activities, etc. Designed and utilized templates to request Regulatory Reporting data from stakeholders. Designed and built additional MS Access

Applications for Market Risk, Derivatives, Project Tracking, plus variance analysis and general ledger balances inquiry. The new MS Access

Databases/Applications eliminated errors, decreased processing time, and improved overall efficiencies and processes up to 95% over prior manual MS Excel

process. Wrote user manuals for ongoing reference and provided training to users and managers.

Sept 2005 – Oct 2005, Randstad Staffing(Contract) CitiGroup Asset Management, Stamford, CT

MS Access Developer / Consultant

Reconstructed existing MS Access Database/Application designed to track Policies and Procedures for Asset Management compliance. Reconstructed database

objects (Forms, Queries, Reports, and Macros) to enhance and improve efficiency. Prepared and wrote procedures manual to train users on managing the

database/application.

June 2005 – Sept 2005, Kelly Financial Staffing (Contract) McGraw Hill, Platts Finance, NY City, NY

Financial Analyst / Consultant

Proactively investigated accounting processes to identify weaknesses and breakdowns in procedures. Performed financial analysis with MS Access and MS

Excel, e.g. variance analysis, direct contribution analysis, trend analysis, etc. Performed accounting functions for product line monthly close, revenue and

expense journals, final entries, reconciliation and analysis of prepaid expenses, deferred revenues, and accrued expenses.

April 2005 – May 2005, Advice Staffing (Contract) Jewish Board of Family and Children Services, NY City, NY

Accounts Receivable Reconciliation Consultant

Reconstructed accounts receivable sub ledger utilizing advanced Excel functionalities to facilitate more accurate reporting and reconciliation.

Developedandimplementednew guidelines and procedures to ensure better control and consistency in accounts receivablereconciliation. Researched

andresolved differences between dataposted to general ledger and data source for prior 3 years. Identified and corrected related internal control breakdowns.

2004 – 2005 Kelly Financial Staffing (Contract) McGraw Hill, Publishing Finance, NY City, NY

Analyst / Writer / Consultant

Prepared and wrote documentations (a total of 17 documents) for Contract Administration Policies & Procedures. Produced written documents through data

gathering via face to face meetings with user community. Assisted data gathering and reporting for Sarbanes Oxley (404) internal control risk assessment.

2003 – 2004, Adecco Financial Staffing (Contract) Allied Irish Bank, White Plains, NY

SAP General Ledger Conversion Project with MS Access Development

Key support on project thatconverted main frame General Ledger to SAP. Downloaded and reconciled data Fixed Assets, Vendor Files, etc., data integrity

assurance, data conversion and formatting to match new system, plus data validation of final output. Designed and implemented Microsoft Access Database to

perform expense reporting.

Page 2 of 3

Vernon Reid

Vernon Reid

New York, NY

Phone: 347-***-**** Email: ********@*******.***

1994 2002 Prudential Relocation Services (Operations Accounting) Valhalla, NY

Senior Accounting Associate

Accounted for revenues with overall responsibility. Monthly journals to Amortize deferred revenues.

Developed multiple MS Excel spreadsheets to perform reconciliation, analysis, and reporting.

Performed monthly G/L account reconciliation Balance Sheet and P&L.

Developed and implemented Microsoft Access Database/Application to perform revenue billing and reporting that improved efficiency and reduced

processing time by 90%.

Computer Applications:

Windows NT • Windows 2000 • Windows XP • Windows 7 • Client Server/Main Frame Environment • Lotus Notes • SmartStream Accounting

Software • Microsoft Excel, Access, Word, Front Page, PowerPoint, Visio, and Outlook.

EDUCATION

WAC University – Bachelor of Business Administration (BBA) Accounting 2003

Page 3 of 3

Contact this candidate