Summary of Business Accomplishments:

• Extensive experience in MS Access database development and design with the last 5 years in versions 2007 - 2010 VBA
• 8 years of SQL queries writing
• 21 years of MS Excel spreadsheet development, VBA Macros, Charts, Pivot Tables. Vlookup, Hlookup
• 5 years developing Data Warehousing in an SQL server environment 2005,2008
• Expert in business process engineering and software development life cycle SDLC , including analysis, design, development, testing and implementation of software applications.
• Adept at reducing development costs and providing traceability of projects.
• Excellent communication, analytical, interpersonal, and presentation skills expert at managing multiple projects simultaneously.

EXPERIENCE:

Confidential

Consultant MS Access Developer VBA Programmer

• Converted MS Excel 2010 spreadsheet to MS Access 2010 HR report generating tool for their call center located in Louisville, KY.
• Created data imports from Peoplesoft to update HR data in the MS Access reporting tool.

Confidential

Consultant MS Access Developer VBA Programmer - Remote

• Developed an MS Access 2010 ADO, VBA, SQL client server Time tracking database for tracking projects of individual employees.
• Set up procedures to export data into a text format for import to SAP
• Continued support and upgrades to the Time tracking database

Confidential

Consultant MS Access VBA Programmer / Business Analyst

• Developed an MS access 2003 database ADO, VBA, and SQL to create assemblies of electrical units and its sub electrical units.
• Worked with end users, managers to create a front end for assembly creation BRD's .
• Developed flow process using Visio, documented all technical end user requirements, as well as business set requirements.
• Assembly reports, Excel exports, Excel charts, pivot tables. Vlookup, Hlookup. Data imports

Confidential

Consultant Business Analyst / MS Access VBA Programmer

• Developed additional procedures and enhancements to an existing MS Access 2003 database ADO, VBA, SQL .
• Analysis of existing database and providing specific requirements for upgrading to MS Access 2010.

Confidential

Consultant - Data Analyst / Excel VBA Developer

• Developed an Excel 2010 tool to import data from SAP via ODBC, using VBA and SQL to create pipe delimited text file.
• Developed RFC for communication between SAP systems in NY and UK

Confidential

Consultant - Business Analyst / Access Developer

• Created an MS Access 2010 database ODBC, VBA, and SQL to extract financial General Ledger data from several data sources for migration to new ERP Database Agresso .
• Developed validation methods of extracts based on business requirement.
• Validation error reporting, Error analysis
• UAT analysis, and documentation BRD's
• MS Excel 2010 Spreadsheet development VBA, Vlookup, and Pivot Tables .
• SQL Server 2008 Tables, Queries

Confidential

Consultant - Business Analyst / Access Developer

• Analyzed, documented and implemented business processes and process flows within
• the AP department. technical and functional specifications and documentations, BRD's .
• Developed an MS Access 2007 database front end with ODBC to an SQL server for tracking
• Purchase Orders, Change Orders, and Invoices.
• Ad Hoc Access reports, Management Report, Graphs.
• MS Excel Spreadsheet development VBA, Forms, Vlookup, Hlookup, Match, Pivot Tables .

Confidential

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 with ODBC connection to an Oracle database for analysis of printer usage, global asset tracking and asset labeling system, data imports from Excel and text delimited files.
• Developed MS Access 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, Match, 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.

Confidential

CRM Database Manager / Customer Support Manager/ Business Analyst

• Responsible for the integrity of data being uploaded into CRM Dynamics 2011.
• Responsible for providing administrative support, case resolution, national telephone support.
• Established technical processes as well as updating all existing documentation related to IT.
• MS Access 2003 database development VBA, Forms, Reports, Queries, SQL , Database upgrade MS Access 2003 to MS Access 2010, Excel spreadsheet VBA, Forms, Vlookup, Hlookup, Match, Pivot Tables , Report Development.

Confidential

Data Entry Temp

Responsible for the input of constituent's donations into Razors Edge.

Confidential

Data 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 2003 to MS Access 2007.
• 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.

Confidential

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 2007 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.

Confidential

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

• Processed incoming internet orders via PC.
• Processed inbound catalog orders.

Confidential

Owner, Consultant

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

Confidential

Consultant - Excel and Access Developer

Developed Excel user input forms and Access databases with links from the Excel forms VBA, VB5 .

Confidential

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 .
• 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 .

Confidential

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, and 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 .