Manager Developer

AMERICAN EXPRESS / HEWLETT-PACKARD, YORK CITY, NY March 2012 to Present

Consultant - Data Analyst / On Site Administrator (OSA)

• Responsible for the usage analysis of all Hewlett-Packard printers for the World Financial Center.

• MS Access 2007 database development for analysis of printer usage, asset tracking, asset labeling system, data import from Excel and text delimited files. Developed VBA code to export data to excel, Ad Hoc Access reports, Management Report

• Data cleansing, via Excel Data Tools (Remove Duplicates, Data Validation, Filtering, What-if Analysis).

• MS Excel Spreadsheet development (VBA, Forms, Vlookup, Hlookup, Pivot Tables),

• Development of MS Visio floor plans, of printer locations for inventory control and asset management.

• Coordinator of printer deployment across all locations based on end user usage.

SUCCESS-SYSTEMS, Stamford, CT March 2011 to March 2012

Consultant - CRM Database Manager / Customer Support Manager

• Responsible for the integrity of data being uploaded into CRM Dynamics 2011.

• Responsible for providing administrative support, case resolution, telephone support

• Established technical processes as well as updating all existing documentation related to IT.

• MS Access 97database development (VBA, Forms, Reports, Queries), Database conversions MS Access 97 to MS Access 2010 Excel spreadsheet (VBA, Forms, Vlookup, Hlookup, Pivot Tables), Report Development

FOOD BANK FOR NEW YORK CITY, NY Oct. 2010 to Feb. 2011

Data Entry (Temp)

• Responsible for the input of constituent’s donations into Razors Edge

MORTGAGE CONTRACTING SERVICES, Tampa, Florida Dec. 2009 to July 2010

Consultant - MS Access Database Analyst / Asset Preservation Coordinator

• Responsible for the securing of actively foreclosed loans for Wells Fargo

• Responsible for the maintenance and daily data upload, into a proprietary MS Access 2007 database.

• MS Access database development (VBA, Forms, Reports, Queries), Upgraded Ms Access 2007 to MS Access 2010,

• VBA scripting to export multiple record sets From MS Access 2010 to Excel.

• MS Excel spreadsheet development (VBA, Forms, Vlookup, Hlookup, Pivot Tables) and Report Development,

• Data Analysis concerning employee data input stats, vendor complaints, vendor insurance verification, and month vs. month task completion analysis. (MS Excel 2007, Pivot Tables, Macros)

• Updated legacy MS Access database on assigned tasks relevant to the preservation of foreclosed, vacant homes, condo, and commercial properties,

• Vendor interactions to assure all property are secured to HUD specifications and guidelines.

THOMAS SIGN & AWNING CO. INC., Clearwater, Fl. May 2007 to Aug. 2008

Consultant - Project Coordinator / MS Access Database Analyst / MS Access Report Developer

• MS Access 2003 database development (Queries, Macros, Forms, Reports, VBA), database upgrades Access 2003 to

Access 2010(Scripting, testing, custom ribbon development(XML))

• Developed MS Excel spreadsheets for project tracking (Macros, VBA).

• Responsible for the coordination, manufacturing and installation of signs.

• In charge of coordinating and contracting Sub-contractors for sign installations.

• Responsible for permitting all contracted work.

• Assigned to post permits on job sites.

MATRIX SPORTING GOODS, Safety Harbor, Fl. Nov. 2006 to March 2007

(Temp) - Inbound Customer Service / Internet Order Processor / Data Entry

• Processed incoming internet orders via PC.

• Processed inbound catalog orders.

• Batch processed daily Credit Card orders for authorization.

THE CYBERNET CAFÉ, Hudson, Fl. Oct. 2005 to Oct. 2006

Owner, Consultant

• MS Access developer, MS Excel spreadsheet developer, Excel data input, Conducted classes in MS Word, MS Excel, MS Access, Outlook, PowerPoint

AMALGAMATED BANK, New York April 2004 to May 2005

Consultant, Excel and Access Developer

• Developed Excel user input forms and Access databases with links from the Excel forms (VBA, VB6)

SIEMENS WESTINGHOUSE, Orlando, Fl. Nov. 1999 to Aug. 2003

Consultant - MS Access Database Developer / Sr. Programmer Analyst / Database Analyst / Database Manager

• MS Access database developer, established links between MS Excel and MS Access 97 (VBA & SQL) to produce a multi user Inventory database for tracking serial numbers company wide

• Linked Excel, Access and SAP for reporting month-end inventory and shipping statistics.

• Setup queries for exporting data into and out of SAP

• Data mapping in an enterprise data domain, building and maintaining data mapping documentation

• Established links between SAP tables (ODBC) and MS Access for daily system updates (BOM, MPS and MRP)

• Data conversions (TXT, DBF, XLS, ASCII)

• Assisted on multiple team projects to ensure data integrity

• Direct involvement with end-users to expand or update production database

• Developed management reports (Outlook, Word, and Crystal Report 8.0)

NEXTEL COMMUNICATIONS, Orlando, Fl. Sept. 1996 to Oct. 1999

MS Access Database Developer / Database Analyst / Data Analyst / Database Manager

• Data mapping in an enterprise data domain, building and maintaining data mapping documentation,

• Database normalization, Database developer, developed and managed an MS Access 97 Commissions and Lead Tracking Database (VBA, VB, Forms, Queries, Reports )

• Lead consultant on companywide Oracle Commissions Database conversion

• Analyzed and reported daily sales data to sales and marketing managers

• Developed IT Call Center Software using MS Access 97 for company-wide IT support

• Data conversions (TXT, DBF, XLS, ASCII)

EDUCATION:

COLORADO TECHNICAL UNIVERSITY

• Presently attending, majoring in Information and Technology with a major concentration in System Engineering

Contact this candidate