SANDRA MCGREGOR
Temporary Address: *** – **** Morisset Ave, Ottawa ON K1Z 8H4
Temporary Home Phone: 613-***-**** Cell Phone: 613-***-****
E Mail: *************@*****.***
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