SANDRA MCGREGOR

Temporary Address: *** – **** Morisset Ave, Ottawa ON K1Z 8H4

Temporary Home Phone: 613-***-**** Cell Phone: 613-***-****

E Mail: acyfp4@r.postjobfree.com

TECHNICAL ENVIRONMENTS

Oracle HRMS JD Edwards Enterprise One HRMS

Kronos Workforce Scheduler ADP HRIS – DOS-based database

VIP HRIS (Vendor – DLGL) – Oracle-based relational database

PeopleSoft HRMS

Crystal Report Writer Visio

Microsoft Access Microsoft Project

Microsoft Excel Microsoft Word

Microsoft PowerPoint Microsoft Outlook

CAREER HISTORY AND EXPERIENCE

THE ROYAL OTTAWA HOSPITAL February 2016 – December 2016

(Temporary position)

Ottawa, Ontario

Approximately 1,500 employees

Using EmPath

HRIS Analyst

Produced ad hoc reports for Human Resources

Verified and input union changes, grade changes and organization changes into the set-up tables

Audited data

Documented system processes and interfaces

Maintained interfaces to various other applications

Resolved and communicated resolutions for day-to-day issues

CNL (Canadian Nuclear Laboratories) December 2014 – February 2016

Chalk River, Ontario

Approximately 3,500 employees

Using PeopleSoft

Implemented Oracle R12

HRMS Analyst (July 2015 to February 2016)

Produced ad hoc reports for Human Resources

Set up and trained new users

Verified and input union changes, grade changes and organization changes into the set-up tables

Audited data

Maintained interfaces to various other applications

Resolved and communicated resolutions for day-to-day issues

NAV CANADA July 2013 – February 2014

Ottawa, ON

Approximately 5,000 employees

Using Oracle 11i

Business Solutions Analyst - Senior

Worked with Human Resources, Benefits and Payroll departments to implement requested system changes

Prepared all SDLC documentation including Business Requirements, Project Plans, Testing and Client Acceptance documents

CALGARY CO-OPERATIVE ASSOCIATION LTD. May 2011 – June 2013

Calgary, Alberta

Approximately 3,500 employees

Using Oracle 11i

Business Solutions Analyst - Senior

Worked with Benefits, Payroll, Human Resources and Finance departments to implement requested changes

Supported the Payroll year-end

Developed documentation and trained the store personnel on Kronos Workforce Scheduling application

Processed the bi weekly payroll

Supervised and coordinated the project teams ensuring all changes were implemented on time and with no outstanding defects

Developed reports for Payroll and Human Resources departments using SQL and analyzed the data using MS Excel

Configured the Payroll and Human Resources modules in the system and developed queries to maintain the integrity of the system during the Oracle R12 upgrade

Provided Tier 2 technical support for Payroll, Benefits, Human Resources and Finance

Supported Production environment for the Pharmacy system, travel application (Global Matrix), membership Web Application (internal database) and HRAR (internal access database for recruitment)

PTI GROUP INC. December 2010 – May 2011

Edmonton, Alberta

Approximately 2,500 employees

Using JD Edwards

Senior Business Analyst

Learned the HRIS/Payroll application within weeks to support the Payroll year-end

Worked with Benefits and Payroll departments to implement requested changes

Supported the Benefits department to ensure monthly benefits reports were completed and payments were made correctly and on time

Prepared all SDLC documentation including Business Requirements, Project Plan, Testing and Client Acceptance documents

Supervised and coordinated the project teams ensuring all changes were implemented on time and with no outstanding defects

Provided Tier 2 technical support

Worked on several projects simultaneously

STANTEC CONSULTING LTD. March 2007 – December 2010

Edmonton, Alberta

Approximately 9,000 employees

Using Oracle 11i

Functional Business Analyst, HRMS

HR Business Systems Analyst

Developed, documented and updated workflows, instructions and processes

Processed the Canadian and US bi weekly pay

In consultation with Human resources, implemented

On-line Performance Appraisal system

Manager self service

Various new timecard rules in the Oracle OTL module using proper change management techniques

Provided recommendations to resolve issues and make changes in the system

Provided Tier 3 level support for problems and issues arising from timecard entry

Supervised and coordinated the project teams ensuring all changes were implemented on time and with no outstanding defects

Provided timecard training for employees hired through acquisitions

Worked with the Learning department to ensure information was updated for timecard training presentations

Worked with the Learning department and intranet team for the development of timecard tutorial for corporate intranet site

Maintained and updated employee timecard rule documentation

UNIVERSITY HEALTH NETWORK 1999 - 2007

Toronto, Ontario

Approximately 11,000 employees

1,000 Users

13 Different unions

Using VIP (vendor is DLGL)

Senior H.R.I.S. Administrator

Supported the Payroll year-end

Processed the bi weekly and monthly payrolls including resolving errors generated

Was the lead for system upgrades/enhancements and coordinated implementations

Developed, documented and updated workflows, instructions and processes

Analyzed turnover, sick time and overtime data to identify trends

Created audit reports and reviewed data on a regular basis for data integrity

Developed and supported ad-hoc reports for over 80 users in the Human Resources department using Crystal and SQL tools

Developed and provided data analysis and statistical information for senior management

Supervised and coordinated the project teams ensuring all changes were implemented on time and with no outstanding defects

Implemented system training and created user manuals for various aspects of HRIS / Payroll system

Identified, determined possible solutions and resolved technical system issues

Documented system processes, procedures and system testing

Provided technical support for HR and Payroll users

EDUCATION

Formal

Durham College - General Business – Human Resources Diploma

Concentrated in Human Resources and Information Technology. Major courses included: Labour Relations; Compensation; Recruitment and Organizational Behaviour.

Professional

Various computer courses including Excel, Word, Outlook and Access

Carswell Payroll Courses Levels 1, 2 and 3

CEBS - Pension Plans and Other Retirement Arrangements

NAIT (Northern Alberta Institute of Technology) – Business Analyst Certificate

Algonquin College – enrolled in Nursing Unit Clerk Certificate program

Seneca College – Quick Books

Enrolled in CPA Payroll Compliance Practitioner Certificate program

REFERENCES

Available on request

January 2017

Contact this candidate