Colin Y.

• Data Entry Automation o Use of VBA and data mapping to automate entry of data from client reports to working paper spreadsheets. o Building and upgrading existing internal and client spreadsheets to be more efficient and to be able to integrate any form of automation required. • PDF Scripting/Data Mining o Ability to batch prepare PDFs from external data sources. o Data mining PDFs to extract data to working paper spreadsheet. o Building scripts to automate various PDF tasks. • SQL/Database Reporting Analysis o Using code to clean up data for use in software and spreadsheets. o Manipulating data to reconcile various working papers. o Using large data sets to create reports for analysis. • Excel to Software Mapping o Assistance with building new or improving existing tools that make use of Excel files to be integrated with current software. o Building Excel platforms to allow automating data between software and Excel datasets.