SUMMARY:

Analyze, process, cleanse and report large amounts of data. Expertise in Excel, Access and VBA Programming. Develop in Access to create programs, databases, ETL applications, data analytic tools, and reporting tools. Program Excel workbooks to graphically represent data, (dashboards, charts, pivot tables), create Business Intelligence and Business Analysis tools. Seamlessly integrating MS Office applications to work cohesively together.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

VBA Developer/Access DBA

Environment: Access, Excel, Outlook, SAS, VBA, Visio, Word, JavaScript

Responsibilities:

• Maintain and upgrade several Human Resource databases in Access.
• Program and create Access applications in VBA.
• Create, maintain and program macros in VBA for Excel workbooks.
• Create and modify dashboards in Excel workbooks.
• Write ETL and data cleansing programs in VBA to upload to a SAS database.
• Assist with designing and implementing the Avilar Competency Management System.
• Write and maintain reports in the Adobe Cold Fusion Report Builder from a SAS database.
• Create and modify PDF documents in Adobe Acrobat Pro XI and DC Pro.
• Program PDF documents in Adobe Acrobat Pro XI and DC Pro in JavaScript.
• Create and update organizational charts in Visio.
• Modify PDF documents in LiveCycle ES4.

Confidential, Purchase, NY

VBA Developer

Environment: Access, Excel, Outlook, Word

Responsibilities:

• Working with the vendor verification department to create a risk reporting system to assess the security and vulnerability of vendors making credit cards. Modified a system to access the risk of and verify the accuracy of the data. Analyzed, reported and imported data from Word documents. Wrote, stored and reporting data in Access. Created and programmed Excel workbooks to retrieve and analyze data from vendors. Programmed PDF files from Access databases, Excel Workbooks or Word documents.

Confidential, New York, NY

VBA Developer/Access DBA

Environment: Access, Excel, JavaScript, Outlook, SAS. VBA, Visio, Word

Responsibilities:

• Developed Excel Workbooks to track time and leave reports for attendance, performance reviews and other HR reporting reports.
• Analyzed and enhanced HR related Access databases that include images, emails, reports and Excel workbooks.
• Modified existing Excel workbooks to change automated macros.
• Create a program to transfer data from Access databases to a SAS database.
• Wrote VBA code to extract data from Adobe Acrobat files and upload to a SAS database. Assist with designing and implementing the Avilar Competency Management System.
• Created reports on Cold Fusion Report Builder to generate reports.
• Created analysis reports to evaluate and analyze employees’ competency for promotion and transferring to other positions.
• Programmed Adobe Acrobat files with JavaScript.

Confidential, New Haven, CT

VBA Developer

Environment: Excel, PowerPoint, VBA, Word

Responsibilities:

• Working with the vendor verification department to create a risk reporting system to assess the security and vulnerability of vendors making credit cards.
• Modified a system to access the risk of and verify the accuracy of the data.
• Analyzed, reported and imported data from Word documents.
• Wrote, stored and reporting data in Access.
• Created and programmed Excel workbooks to retrieve and analyze data from vendors.
• Programmed PDF files from Access databases, Excel Workbooks or Word documents.

Confidential, New York, NY

VBA Developer/Access DBA

Environment: Access, Excel, Outlook, VBA, Visio, Word

Responsibilities:

• Developed Excel Workbooks to track time and leave reports for attendance, performance reviews and other HR reporting reports
• Analyzed and enhanced HR related Access databases that include images, emails, reports and Excel workbooks.
• Modified existing Excel workbooks to change automated macros.
• Document existing Access databases and Excel workbooks.

Confidential, New York, NY

VBA Developer/Access DBA

Environment: Access, Excel, Outlook, VBA, Word

Responsibilities:

• Analyzed and enhanced HR related Access databases that include images, emails, reports and Excel workbooks.
• Modified existing Excel workbooks to change automated macros.
• Document existing Access databases and Excel workbooks.

Confidential, Norwalk, CT

VBA Developer/Data Analyst

Environment: Access, Excel, Postgre SQL, PowerPoint, VBA, Word

Responsibilities:

• Developed a Risk reporting system utilizing Access, Excel, Postgre, PowerPoint, and Word.
• Used Postgre queries to create reports for employees to analyze risk data.
• Created Access database programs to do analysis for potential risks for Confidential .
• Created Access database to be able to create dynamic reporting for the employee to create own analysis tools and reporting.
• Programed Access to be able to create Excel Workbooks, Dashboards in Excel, and PowerPoint presentations utilizing macros, modules, functions and classes.
• Programmed Excel Dashboards to be able to do analysis from either the Postgre database, Access database or an Excel worksheet.
• Analyzed data and wrote reports on vulnerabilities to Confidential in Word and PowerPoint.

Confidential, White Plains, NY

Access Developer/Data Analyst

Environment: Access, Excel, SQL Server, VBA, Word

Responsibilities:

• Debug and document an Access databases that run on a nightly basis.
• Improve and move processes from the Access databases to a SQL Server data warehouse.

Confidential, New Canaan, CT

Access Developer

Environment: Access, Excel, VBA, Word

Responsibilities:

• A one month project to upgrade and improve Access databases that handled inventory, shipping, and invoicing.

Confidential, Norwalk, CT

VBA Developer/Data Analyst

Environment: Access, Excel, PowerPoint, VBA, Word

Responsibilities:

• As part of changing to ServiceNow my role was developing applications for ETL, data migration, and cleansing on User, Active Directory, CMDB, and ITIL information.
• Responsible for requirements documentation, data cleansing, transformation, and data validation.
• The applications are developed Access, Excel, PowerPoint and Word utilizing macros, functions and classes.

Confidential, Norwalk, CT

VBA Developer /Data Analyst

Environment: Access, Excel, VBA, Word

Responsibilities:

• Responsible for requirements, cleansing, transformation, and validation of data for Employee, Customer, Vendor, Credit, Material, Open Account Payables and Open Account Receivables. Develop applications in Access, Excel and Word utilizing macros, functions and classes.

Confidential, New York, NY

VBA Developer

Environment: Access, Excel, VBA, Word

Responsibilities:

• Brought in to develop Access applications to track financial information, enabling users to create custom reports and Excel worksheets in Microsoft Office 2010 as part of this hi net worth facility upgrade.

Confidential, New York, NY

VBA Developer/Data Analyst

Environment: Access, Excel, Outlook, Sybase, VBA, Word

Responsibilities:

• Development through deployment of applications and databases tracking fixed income trades in Office 2010.
• Developed prototype applications to aid in reconciliation of Trades, Positions, and P&L in Access.
• Developed ETL Access application to consolidate data from Sybase, text files, Excel and XML.
• Excel reporting applications utilized Charts, Pivot Tables, Dashboards, User forms, APIs and Classes.
• Wrote messaging applications to alert user of users of possible problems areas and status of trades and positions in Access and Outlook.

Confidential, Purchase, NY

VBA Developer/Data Analyst

Environment: Access, Excel, VBA, Word

Responsibilities:

• Coordinated, gathered and defined data requirements for global card benefits data with account managers.
• Designed / developed in Access report generation and data maintenance.
• Designed and developed a forecasting tool on card benefit revenues and expenses.
• Document and trained users on Access and Excel coding, process, and procedures.

Confidential, Norwalk, CT

Developer

Environment: Access, Excel, VBA, Word

Responsibilities:

• Develop databases to manage employee, machine and application data for upgrade to Vista and Office 2007.
• Coordinate and verify requirements for user machines and applications.
• Responsible for testing and development of Excel workbooks, Access databases and their Add - ins to verify compliance and operability in Office 2007 and Vista.

Confidential, Norwalk, CT

Data Analyst/Developer

Environment: Access, Excel, VBA, Word

Responsibilities:

• SAP data migration project taking data from one region into another to create a single instance of SAP data.
• Responsible for requirements, cleansing, transformation, and validation of data for Inventory. Pricing, Open Sales Orders, Customer Master, Product Allocation, and Open Account Receivables utilizing Access, Excel and Word.