Responsible for data analytics, task automation, and ad hoc reporting to deliver executive level inventory and production dashboards and summary reports using MS Visual Studio, Tableau Desktop, MS Access, Excel, VB.NET, VBA, SQL, IBM Data Studio, and SharePoint.

Developed a database for Accounts Payable to provide management with a process for automated report creation and email distribution for Vendor statement reconciliation using MS Access, Excel, VBA, and SQL. • Designed a user-friendly dashboard style GUI Interface.• Created customized queries in Oracle PeopleSoft to provide the required data files for import.• Automated imports of CSV and Excel files created in PeopleSoft.• Automated Vendor Invoice reconciliation with advanced queries using SQL and VBA.• Automated Vendor Invoice statement requests created and sent through Lotus Notes email client.• Automated Vendor Reconciliation statements created as formatted Excel files and distributed to vendors as attachment.• Automated purge/archive of historical data files.• Automated statement tracking and report generation.

Development of an automated tool to provide Merchandise Planners with a user-friendly GUI interface that uses advanced form controls to give the user the ability to easily set up a report for their particular needDevelopment of an automated tool to give detailed reports of their Merchandise Inventory Documentation and redesign of source codeDeveloped an automated process to distribute key weekly meeting reportsCreated an automated process to query Oracle data using Access, and send a personalized email of an Exception report to each planner in the department.

Development of Retail Store associate and manager scheduling applicationDevelopment of Retail Training Tracker

Development of Salary Adjustment Tools and automated creation/delivery of tools to over 3,000 people leaders in less than 2 hours computing timeAutomated the compilation of data from multiple data sourcesDevelopment of International Assignment Salary Calculator and automated creation/delivery of tools to over 3,000 people leaders in less than 2 hours computing time

Creation of Human Resources - Performance Incentive Planning tool using MS Excel and VBA to automate the entire administration processDevelopment of Salary Planning tools and automated creation/delivery of tools to over 5,000 people leaders in less than 3 hours computing timeReport automation and file export to PeopleSoft HRIS systemAutomated electronic Incentive Plan agreement creation and distribution; thereby, saving the department $15,000 every Quarter in administration and supply expensesDevelopment of Performance Incentive Planning tool and automated creation/delivery of tools to over 5000 people leaders in less than 3 hours computing time (prevented a $2 million dollar outsource contract)Development of Salary Planning tool and automated creation/delivery to over 5000 people leaders in less than 3 hours computing timeAutomated Report Creation and DeliveryAutomated Audits and Data exports

Responsible for repairing desktop pc workstationsResponsible for repairing laptop workstationsAdministrator of MS Server 2003 and Active DirectoryImaging machines with Symantec GhostTroubleshoot Software and Hardware errors

Responsible for maintaining and enhancing State Mutual Fund registration database.Worked closely with senior management to develop an exceptions only report for state mutual fund registration database audit. The process was previously distributed among the staff via a paper report for manual review and error resolution. Created automated audit model resulting in three hour daily labor reduction, a 75% increase in efficiency, and completely eliminated the human error factor. Scheduled the task to run without staff assistance.Created automated reporting model for Mutual Fund Company’s state registration reporting function, resulting in a one hour manual labor reduction and increased efficiency by 75%. Led a project in coordination with senior management to develop a new service model for client cost savings, then automated the process with MS Excel and VBA script; thereby, creating a new revenue producing service with no additional overhead costs to the department.Created procedure database with Microsoft Access to streamline departmental training of new hires and expanding technical knowledge of current associates.Assisted the Company’s training department with video enhanced PowerPoint presentation.Enhanced department’s timesheet using if-then statements with MS Excel.

Designed Database for wire transfer signature verification. This procedure was previously done manually via a paper signature card binder.Automated Portfolio Balance reporting function, resulting in a two hour daily labor reduction.Responsible for making wire transfers of millions of dollars daily through database driven wire transfer system.Responsible for daily audit of all wire transactions.Automated audit process through VBA programming