Tasks:

·        Analyze current Office tools.

·        Using Microsoft Office re-program applicable templates.

Development Environment:

Microsoft Office VBA (Visual Basic for Applications), Microsoft Word, Excel, Access, Macros

Tasks:

·        Analyze current Staffing system.

·        Prepare and introduce a new Workforce Plan

·        Using Microsoft Office program the system.

·        Create databases using MS Access and designed numerous SQL queries.

·        Graphic User Interface design.

Development Environment:

Microsoft Office VBA (Visual Basic for Applications), Microsoft Word, Excel, Access, Macros.

Create the National Research Councils National Annual budget reporting system using VBA, Microsoft Word templates and Excel with the ability for the master document to automatically import information from returned templates and automatically produce the necessary reports.

Tasks:

·        Develop solutions using Visual Basic for Applications for the following projects:

·        Create the corporate Canadian National Research Council Annual Budget spreadsheets both outgoing and incoming with MS Office integration using Microsoft Word Macros, VBA.

·        Program the ability to mass produce spreadsheets for distribution to national Research Council Institutes using office macros VBA.

·        Program an importation process whereby the master file automatically imports returned Institute budgets and creates the necessary reports and templates, using Microsoft custom document templates, Word, Excel, macros and VBA.

·        Ensure workbooks calculate faster.

·        Conduct information sessions on using the software.

·        Be able to change the structure immediately according to new guidelines and procedures.

·        This comprehensive involved customizing command bar Menu Items in MS Office tools, MS Excel and MS Word for functionality.

·        Using Web browsers and search engines.

Development Environment:

Office 2003, Macros, VBA (Visual Basic for Applications), MS Word, MS Excel