VBA Developer
Resume:
*******@*****.***
MICHAEL DUFAUCHARD
SKILLS LANGUAGES & YEARS EXPERIENCE
VBA, SQL: 4+ years
Python, Java, C/C++: <1 year
SOFTWARE
Excel, Access, UIPath, Visual Studio
EXPERIENCE PROCESS/TECHNOLOGY ANALYST - Canon USA, Inc.
Create, maintain, and update solutions for tasks within Canon’s Program Management department
Developed and implemented an MS Access database to store information on thousands of rebate claims handled by the department
Automated database reporting used to track trends and discrepancies in customer claim data
Updated existing Excel claims template with an interface to allow users to query the database and validate claims in real time
Increase department workers’ efficiency by automating general Excel tasks
Integrate UIPath web automation with VBA macros to streamline data download and processing and minimize manual input
VBA CONSULTANT - Air Techniques
Developed algorithm to detect and tag monthly sales data based on predefined criteria
Processed and stored previous sales data to achieve more accurate results for current and future sales data
VBA CONSULTANT - Computer Associates
Worked with community team at CA to refine the process for issuing certification badges to members of Computer Associates’ community site.
Streamlined issuance of badges with Python and Selenium by parsing data from Excel sheets and feeding it to a web browser automator for issuance. TECH INTERN – Albert Einstein College of Family Medicine
Worked closely with the department head to conceptualize and implement a department records database in Microsoft Access
Utilized VBA macros in custom entry forms to allow end-users to easily access and manipulate data
Assisted in migrating existing data to the new database EDUCATION BINGHAMTON UNIVERSITY
Bachelor of Science in Computer Science
KOREA ADVANCED INSTITUTE OF SCIENCE AND TECHNOLOGY (KAIST) JAN 2017 -
PRESENT
MAR 2019 -
JUN 2019
JUN 2018 -
AUG 2018
JUN 2013 -
AUG 2013
MAY 2016
SPRING 2014
Contact this candidate