John Yorke Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Leading a software define, design, develop, and deliver team which owns Marketing & Offer Management software for TD's Customer Experience - Shopping functions.

Toronto, Ontario, Canada

Senior IT Development Manager for AML.

Toronto, Ontario, Canada

Evaluated HCM vendors through RFP process. Technical Lead on the Workday implementation. Designed integration solutions using Workday EIB, Workday Studio, Hadoop, and Talend.

Toronto, Ontario, Canada

Implemented Oracle Fusion Compensation for Executives and TD Securities. Developed a custom solution to link compensation decisions, stock administration, and payroll together for automated processing.

Toronto, Ontario, Canada

Assisted in getting our US acquisitions migrated onto our PeopleSoft, SumTotal, and SAP SuccessFactors applications. Worked to build solutions to tie multiple identity providers into HR applications.

- One of three business partners involved in building a health, fitness, and training website which currently provides hundreds of clients with tools to run their gym and which will eventually sell fitness related equipment, health supplements, and other training services.- Designed the overall architecture of the database, software, and technical infrastructure required for this platform independent, highly available, and J2EE compliant project.- Created a secure Internet application which is multi-lingual and skinable to target a wider audience.- Created an on-line store component which handles multiple price lists, multiple currencies, recurring payments, and ties into the PayPal API.

- Lead a team of two to develop a script in 1½ months which could convert and clean all the PeopleSoft data and load it from HRMS 8.0 into HRMS 8.8 in 4 hours during an upgrade and e-enablement project. The script was designed to allow migration from PeopleSoft 8.0 to 8.8 to easily occur during a weekend.- Defined business rules for HR data entry activities, designed the method use to clean all HR action related data (leading to a Job table size reduction of over one third), and redefined business units, departments, and HR hierarchies.- Designed and developed the Payroll to GL interface.- Delivered a PeopleSoft HRMS 8 Benefits Administration implementation on a tight timeframe of only 2½ months. Performed as the only technical resource and as the only resource with any functional Benefits Administration experience on a very small implementation team.- Built a letter-writing module that creates dynamic content in e-mails and printed documents for the Learning & Growth department and for Benefits Administration.- Created a suite of tools for Employment Equity reporting.- Merged all payroll data into PeopleSoft during the merger of Andersen’s Canadian operations into Deloitte & Touche.- Created a complex reporting system for PeopleSoft that allows dynamic selection of the rows, columns, and criteria to be applied to the report.- Created Training Module enhancements to add additional eligibility criteria for courses.- Designed and built a routine to create a training database with confidential data “scrambled” to protect the privacy of that data.

- Managed a project to upgrade Scotiabank’s E.piphany software from version 4 to version 5. Prepared the Statement of Work and the Service Contract, created and updated the Project Plan, and provided status updates to Scotiabank and the professional services area director. Designed and made schema changes to the datamart the handle currency conversion for data from many different countries. Designed a data loading process to handle large amounts of data (250Gb).- Created sales demonstrations for use by KPMG and E.piphany complete with key performance indicators, executive portals, analytics, and targeted marketing functionality. Sales demonstrations were complete with ETL jobs loading fabricated data designed to feel like customer data that contained trends that show up in the analytical tools.- Provided assistance to HP Consulting during a business requirement analysis project for FedEx Canada’s marketing and finance departments. Created a product demonstration completely customized to match information gathered during discovery sessions.- Assisted AutoDesk in setting up E.piphany’s Analytic Platform in a Sun UNIX and Oracle 8i environment.- Kept current with E.piphany’s AP, RP and IP platforms through training classes and working with the tools in the office on down time in Windows NT environments with SQL Server or Oracle8i/9i on Linux databases.

- Was sent to ICG Commerce, Heilind Electronics, Tradewings, PPINetwork, and Intel Corporation to play an architecture role and provide technical expertise in the design and construction of B2B interfaces which used various toolsets including Java, Javascript, Vignette’s OnDisplay Toolset, Ariba supported cXML, and CommerceOne supported xCBL.

- As a Siebel Certified Consultant instructed new consultants and performed a full Siebel Sales Enterprise implementation internally at Edison Group. Work performed includes the gathering of business requirements, using EIM to import existing sales data, defining the overall architecture of the solution, using Siebel Tools to modify screens, views, applets, BCs, BOs, and make use of extension fields, and also the set up of server processes to synchronize remote-client databases.

- On a PeopleSoft 7.5 Student Administration implementation created new shipping and billing functionality for Gemological Institute of America. Work was performed in a combined NT, UNIX, and Oracle environment. Gathered all business requirementsrelated to the set-up of the student accounts receivable data and student billing. Designed the loading scripts in SQR to import student accounts receivable and student record information. Used PeopleCode extensively to create from scratch a large and complex shipping module that included an SQR to print bar codes to identify course material, an SQR that printed FedEx labels, and created custom user interfaces using PeopleTools and PeopleCode.- As technical lead on a full PeopleSoft 7 HRMS implementation for H&R Block, managed eight technical resources on a team of fifteen, developed key interfaces to ADP using SQR, provided technical time and resource information for the overall project plan, trained client IT staff in the complexities of applying patches and testing their success, and assisted the team working on a concurrent PeopleSoft Financials implementation. Using PeopleTools created user interfaces to access various customized interfaces. Used PeopleCode to ensure data validity.- Developed key interfaces using SQR between Payroll, Benefits, and Accounts Payable with outside agencies such as banks and credit unions and assisted in the business-side configuration of the Benefits Administration system during a full PeopleSoft 6 HRMS and Financials implementation for the South Texas Project nuclear facility.

- Offered the position of HRIS manager at London Life during a continually extended contract by an IT account manager.- Assisted in the data conversion and interface creation efforts on a PeopleSoft 6 HRMS implementation at London Life.- Used Data Designer to view tables’ structures and used SQR to create loading scripts for PeopleSoft HRMS.- Acted as project manager for a project to create London Life’s Regulatory Compliance System was responsible for ensuring design met the needs of the business sponsor, overall design of a new system from scratch, presenting solution demonstrations to London Life executives to ensure their support of the project, and coordinating the activities of other project members such as other developers, the DBA, support, and the roll-out specialist. The system was designed to store all the rules, regulations, and guidelines the insurance company had to follow and track the person or people responsible for ensuring regulatory compliance. The system also tracked filings with regulating bodies and printed many different reports.- Rewrote London Life’s Pay Administration System to make thesystem more reliable and to add some functionality. This system collected and integrated departmental budgets, employee pay, performance review data, and the reporting hierarchy information to allow managers to determine employee pay increases. The system also was designed so that a manager’s superior would approve the departmental budget.- Created London Life’s Flexible Benefit Enrolment System using Microsoft’s development tools such as Visual Basic which was deployed across Canada for the purpose of collecting employee flexible benefit enrolment data, calculating benefit costs, printing insurance and enrolment forms, and populating collected data into the PeopleSoft 3.22 Benefits Administration system.