5 Harper WayThornhill, ON ▪ L3T 5A3 ▪ (905) 747-0431

daniel@danielvantassel.com ▪ www.danielvantassel.com

 

PROFILE

 

 

Professional, analytical, and dependable Business Systems Consultant with over nine years experience developing business intelligence tools for the financial, marketing, and fleet management sectors.

 

PROFESSIONAL EXPERIENCE

 

 

Sep 99 - Present

Vantage Information Services

Markham, ON

 

 

A Business Systems Consultant, providing system enhancement, application development, database conversion, and user training services to small and large-sized companies. Projects met client needs and were completed in a timely manner by using a methodical, agile, rapid-development process based on international and industry standards.

 

Selected Contracts

§  Toronto District School Board (TDSB), Toronto, ON

     Developed application to compile and process data for board-level reports. Reduced file size by 98% (from 1,000 MB to 22 MB), reduced ERC processing time by 94% (from 35 h to 2 h), improved visibility of business rules (from 0% to 80%), and simplified user interface.

§  TD Waterhouse, Toronto, ON

     Developed new applications, enhanced existing software, and improved business processes in the fund accounting department. Specific applications include: bank reconciliation, cash sweep, cage reconciliation, custodian reports, GL balance certification, and trades.

§  BMO Nesbitt Burns, Toronto, ON

     Upgraded the Tax Summary and Slip Amendment Application for the Private Client Group. Corrected programming defects, improved efficiency of existing functions, and coded functions to satisfy new federal reporting requirements.

§  CIBC, Toronto, ON

     Developed the reporting module for the internal controls repository database.

     Developed the portable data capture system for the general entity controls project. Received program award for work on the system.

§  Petro-Canada, Toronto, ON

     Developed a compliance database for fleet management staff. Application scored full points on an Ontario Ministry of Transportation Level 1 Audit.

     Developed a customer-specific pricing tool for accounting managers. Improved accuracy and decreased processing time by 99% (from 60 h to 1 min.).

§  Siemens, Markham, ON

     Converted accounting system for water technologies division.

 


 

§  Anderson DDB, Toronto, ON

     Developed analysis and reporting application for CRM division. Reduced processing time by 89% (from approximately 18 h/report to 2 h/report).

§  Unisource Canada, Mississauga, ON

     Developed databases and enhanced existing applications for inventory management, customer service, accounting, and sales departments. Inventory management database saved over 6 months of work hours (from 100 h/month to 15 h/month). Report tool, for IT staff and management alone, saved 12 months of work hours (from 2,340 h/year to 390 h/year).

 

 

Jan 97 � Sep 99

Petro-Canada

Toronto, ON

 

 

A Database Administrator, maintaining accounting systems and improving business processes through automation.

 

Coded scripts to automate accounting processes. Annually saved 4 months of work hours (from 3 h/day to 45 min/day).

Developed CRM database for marketing department.

Developed timesheet database for fleet management department.

 

 

COMPUTER SKILLS

 

 

Development

§  Databases: Access, FileMaker, Paradox

 

§  Coding: Accpac WSM Script, Fortran, Java, SQL, VB, VBA (Access, Excel, Word)

 

§  Internet: ASP, CSS, FrontPage, HTML, JavaScript, VBScript

 

Other

§  Microsoft: Access, Developer, Digital Image, Excel, FrontPage, Outlook, PhotoDraw, PowerPoint, Project, Publisher, Visio, Word

 

§  General Accounting: Accpac, Great Plains, MAS, Simply Accounting, QuickBooks

 

§  Fund Accounting: Bloomberg, InvestOne, MoneyMonitor, PCView, Workbench

 

 

EDUCATION/CERTIFICATION

 

 

Associate Degree in Engineering (Saint Mary's University: Halifax, NS)

 

Certificates

  • Microsoft Office Specialist Master (Certiport: American Fork, UT)
  • ISO 9000 and SPC (Nova Scotia Community College: Halifax, NS)
  • Local Area Networks and Internet Security (Dalhousie University: Halifax, NS)