Yossi Dukes

Experience

• 

  RLD Software Systems Ltd.

  Jul 1980 - now

  Owner

  As Chief Technology Officer of this company, Yossi is involved with all aspects of the business from Sales, Consulting, Analysis, Design, Development, Testing and Implementation of custom database solutions within various market spaces and various technologies.With a who’s who of Canadian clients from Microsoft Canada, Bell Sygma, McCains Foods, McDonalds Canada, Winnipeg Regional Health Authority, North American Van Lines, Manitoba Egg Marketing Board, Cancer Care Ontario, Allstate Insurance, AON Reed Stenhouse, CAMH and CIBC, Yossi applies his years of experience and knowledge in providing solutions that meet or exceeded client's expectations.- Environments : Access 97, 2003, 2007, 2010, SQL 2005, 2008 R2, Oracle 8i Show less

• 

  MBTelehealth - WRHA

  Oct 1999 - Aug 2004

  Consultant

   Analyzed existing data streams and office processes Designed and developed a Patient Management System for the Long Term Care Access Centre of the Winnipeg Regional Health Authority. Utilized by 20 case coordinators and 5 data entry clerks to manage over 5000 patients and associated data as they flow through the Long Term Care processes Trained staff, installed and provides continued support Provided reporting analytics and metrics to demonstrate they met required wait-time parameters Rights to the application were purchased by the WRHA Show less

• 

  Manitoba Egg Farmers

  Dec 2002 - Jul 2003

  Application Architect

  MB Egg Marketing Board Application ArchitectWinnipeg, MB Dec 2002 - ongoing maintenance Analyzed existing data streams from external sources Provided Access training to staff members Architect and developer for a management information system which monitors volumetric and financial data; provides internal analysis and reporting as well as integration of financial data to banking systems for payments. Demonstrated application functionality to CEMA (Central Egg Marketing Association) based in Ottawa Provided continued application support and maintenanceEnvironment: Windows XP, Access 2000/2003 migrate to 2007, Client/Server design, MS VSS, FMS 3rd Party Libraries, MS Office Integration, Excel extracts and transformations to standardized formats to load MIS databases.Migration to full web-based solution using SQL Server 2008 R2, IIS, VS with Producer Portal completed 2015 Show less

• 

  McDonald's Corporation

  Jan 2004 - Jan 2005

  Application Architect

  Aug 2004 to Dec 2004 Analyzed ETL requirements for data movement from Oracle 8 to Access 97 for use by custom internal VB application Liased with Project Leader and client on numerous design considerations Built queries and custom application to move data from Oracle RDBMS to Access 97 Created end user documentation manuals for installation and use. Provided Consulting and Development services in the implementation of various application and ETL processes to support the Sales and Marketing department across Canada.Environment: Oracle, PL/SQL, Access 97, VBA Show less

• 

  Thoughtcorp

  Jan 2004 - Jan 2005

  Business Analyst / Consultant

  Provided Consulting and Development services in the implementation of various application and ETL processes to support the Sales and Marketing department across Canada.

• 

  Keyrus Canada

  Dec 2005 - Jun 2007

  Consultant

  Provide consulting and development services to various high-profile KEYRUS clientele including Cancer Care Ontario, Allstate Insurance, Greater Toronto Airport Authority

• 

  Allstate Insurance

  Jan 2006 - Apr 2006

  Consultant

  Assited in creating a Data Warehouse readiness assessment to position Allstate's informatics 5 year direction strategy

• 

  Cancer Care Ontario

  Apr 2006 - Jun 2006

  Consultant

  QA Analyst assisting in implementation of LMS, training materials and Data Warehouse

• 

  Greater Toronto Airports Authority

  Jun 2006 - Jun 2007

  Consultant

  GTAA - Consultant, Toronto, ON June, 2006 - Jun, 2007Reviewed operations of various departments, provided recommendations for change and roadmap for implementation, and assisted in implementation plan.

• 

  Aon Reed Stenhouse Inc.

  Jul 2007 - Oct 2011

  Consultant / Analyst / Application Architect

  - Architect and develop a Group Risk Insurance Database application to support NGRS "Program Insurance" business- support existing "Program Insurance" database applications- Architect and develop a generic Rating Engine to support "Program Insurance"- Environment - Access 97, 2003, 2007, Oracle 8i

• 

  CAMH

  Oct 2008 - Apr 2009

  Systems Analyst, Application Architect, DB Architect

  Build client/server Client Management system for the management of the Psychological Treatment, Work Stress & Health, and Substance Abuse programs. Provide billing analysis and usage statistics to measure program effectiveness.

• 

  CIBC

  Jan 2012 - Apr 2013

  Systems Analyst / Application Architect

  Develop and implement Records Retention policy system.Develop auto-decisioning modelProvide support to existing decision support systemsRe-architect, design and build multi-user back-office decision support tool to assist Product Group Managers with their daily work load.Environment : Access 2003, Exchange, Outlook, SQL Server 2005

• 

  CIBC

  Nov 2013 - Jun 2016

  Technical Consultant

  2016-03-06 - Contract with CC services to May 28, 2016 relating to Win 7 / Office migration2015-12-01 - Contract extended to Feb 29, 20162015-08-01 - Contract extended to November, 20152014-11-01 - Contract extended until July, 2015 to assist in migration of multiple Access dbms to Office 20102014-01-18 - Project implemented and in production. Contract extended 6 months to address migration of multiple Access 2003 databases to 2007 / 20102013-11-17 - Short term contract to build screening and automation tools to assist Retail Operations in their ongoing monitoring of FASL accounts Show less

• 

  McKesson

  Jun 2016 - Nov 2022

  Senior Programmer/Analyst

  Maintain, enhance and develop in-house platform for our Patient Management System

• 

  Tata Consultancy Services

  Nov 2022 - now

  Software Engineer