Data Analyst, Database Developer, Reports Developer
Resume:
Michael Lawson
Jackson Heights, NY 11372
email: **************@*****.***
Education: Bachelor of Arts in Computer Science
Queens College of the City University of New York
Languages: Access and Excel VBA, SQL SS, Python, XML
Experience:
February 2018 – present
Kobre & Kim, LLP
Consultant
Automated manual bi-weekly report with SQL Server as the back-end, which tracked attorneys’ hours and availability.
This application included a suite of reports based on this data, and output the results to Excel.
Also developed reports for the Finance Department, which analyzed financial and accounting data.
Translated the data for these reports from the company’s 3E system to SQL queries.
Created Excel macros to test and help design VB Project Modules.
Taught coworkers how to improve productivity by using Excel keyboard shortcuts and how to write macros.
September 2011 – April 2018
Benjamin Moore Paints, Montvale, New Jersey
Consultant
Created, maintained and enhanced complex pricing and job quote models which are deployed on the company’s retailer website portal using Microsoft Excel and Access VBA.
Automated the reconciliation of rejected skus sent in by our retailers in our rebate program.
Provided analysis to model to the new SAP application to ensure the accuracy of the new application.
Reverse-engineered the CCP Pricing Model to eliminate all VBA code; this enabled it to run on the Mac.
Performed various ad-hoc data queries and reports requests in Access.
June 2011 – September 2011
Hines International, Inc., New York, New York
Consultant
Developed solutions in Excel and Access VBA 2003 and 2007 to automate the processing of the annual real estate budgets.
Generated a suite of reports and charts using Access and Excel VBA which uploaded these results to Sharepoint.
April 2011 – June 2011
Leucadia International, Inc., New York, New York
Consultant
Built an application in Access for the Human Resources Department which tracked estimated budgets and the actual monies spent for different functions, categories and subcategories.
Created a reports module which summarized and output these results to Microsoft Excel.
Created customized graphs in Excel using VBA to supplement the reports.
Contact this candidate