We Lim
Calgary,AB
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
19
19
years of professional experience
Work History
Data Analyst/Compensation Advisor
Canada Energy Regulator
Calgary, AB
08.2017 - Current
- Perform project-based work such as Pay and deduction audits (complex audits and reconciliations to make pay adjustments such as overpayment/underpayment adjustments, leave adjustments, mass retro pay adjustments, etc in the Phoenix Pay System
- Create custom built reconciliation and audit calculators and extract CAD Phoenix/HR reports from various systems such as Peoplesoft HRMS v. 9.2 and the Phoenix pay system into the Microsoft Excel spreadsheets to perform audits and analyze data to identify root causes of problems and recommend corrective actions.
- Advanced Excel skills including using pivot tables, V-Lookups, macros, mathematics, data validation, name manager, conditional formatting to create custom built calculators and spreadsheets with charts and visualizations to effectively communicate business insights.
- Develop ad hoc custom reports and dashboards to provide management with up-to-date information on key compensation metrics.
- Generate biweekly/ monthly/ quarterly/ annually reporting in Microsoft Excel, Word and PowerPoint and and analyze trends using large data-sets for the purpose of providing statistical, financial and compensation payroll data for internal and external clients to support strategic planning, leading to more informed decision-making.
- Prepare and summarize reports to provide recommendations to management, researching, compiling, and analyzing data or information from various sources/systems, and drafting correspondences (briefing notes) and presentations for the management
- Assist OAG (Office of Auditor General) by providing required pay information for auditing purposes such as extracting and generating various financial payroll and HR data reports
- Perform leave, pay event administration and reconciliation in MYGCHR (Peoplesoft HRMS v. 9.2) including employee leave entries and pay action entries such as Taken on Strength, actings, promotions, long term leave of absence, leave income averaging, pre-retirement leave arrangement, termination of employment etc
- Perform Sec 33 authorizer role function in Phoenix Pay System on behalf of finance in accordance to the pay period processing schedules
- Familiarity with various Compensation, Human Resources and Financial systems such as Oracle Phoenix Pay system, HRMS v. 8.9, MyGCHR (HRMS v. 9.2), SAP financial system, SQL system, and Tableau
- Experience in applying and interpreting pay administration guide, multi union collective agreements, Superannuation administration manual, insurance manuals (such as PSHCP, Dental, PSMIP, Disability, and Long Term Disability), compensation directives, term and condition of employments, etc
- Providing client services by maintaining good relationships and active interactions through digital, phone and in person communications and providing professional advice and guidance in compensation and benefits matters using the available compensation resources and reference
TradeMark Examiner
CANADIAN INTELLECTUAL PROPERTY OFFICE
Gatineau, QC
09.2016 - 08.2017
- Perform examination on trademark applications submitted by trademark applicants for the registration of trademarks in Canada
- Ensure the registrability of the trademarks in accordance to the Trademark Regulations and Acts, Trademark Examination Manual, case laws and Practice Notices
- Perform research using internet, Trademark Onscope Program, dictionaries and other tools to assist in the process of analyzing the use of the trademarks
- Prepare correspondence by issuing trademark reports to the applicants to obtain more information to remedy any objections to the applications
- Make decision in approving/rejecting applications based on the information provided in the applications
Compensation Advisor
Correctional Service Canada
Abbotsford, BC
12.2009 - 08.2016
- Provided expert guidance on compensation-related matters to managers during recruitment, special leave arrangement, long term leave arrangement, terminations, the terms and conditions of employment, collective agreements, pay, benefits, insurances, disability claims and Worker's Compensation Benefits (WCB)
- Interpret and apply pay, pension and benefits policies, guidelines and procedures such as the Term and conditions of employment, Treasury board policies, collective agreements and various insurance and superannuation manuals
- Develop custom reports and dashboards to provide management with up-to-date information on key compensation metrics.
- Implemented new software tools for more efficient tracking of employee salaries, bonuses, and benefits packages.
- Update employees' records to keep files accurate and up-to-date.
- Perform quality control checks to ensure compliance to the departmental payment and Human Resources signing authorities as outlined in the Financial Signing Authorities Matrix, and the Instrument of Delegation of Authority in the area of HRM
- Experience working with large volume payrolls (over 2500 employees) by using the Online Pay System and HRMS v. 8.9
- Pay Integrity project includes analyzing and troubleshooting to maintain data integrity between HRMS v. 8.9 and Oracle Pay System during the Federal Government Pay transitional Initiative in 2016
- Create custom built calculators and tools by using the Microsoft Excel to compile and compute the employees' financial data such as the classification level, assigned work week, increments, acting pay and leave without pay start and end dates to streamline the work processes in Compensation
- Received the Certificate of Appreciation from the RDC and the Certificate of Extra Miles from Compensation for the recognition of work excellence during the implementation of the CX collective agreement in 2013
Finance Specialist - Temporary Assignment
Correctional Service Canada
Abbotsford, BC
01.2014 - 04.2015
- Perform accounting operation include verifying and auditing all the invoices from various business units, Government Acquisition Cards, travel claims (paper and online Expense Management Tool) and contract invoices to ensure they are compliant with the proper Sec 34 signatures and the financial coding requirements
- Perform manual batching, entering the journal entries and preparing monthly DRCTC reports by using the IFMMS (Oracle Financial System)to reconcile the expense claims with the proper financial coding
- Prepare year end reporting and reconciliation functions such as Petty cash and PAYE reports
- Verify and audit accounts in compliance with the financial policies and directives (such as the Travel directive, Government Acquisition Card directive, Financial Signing Authorities Matrix, and the Instrument of Delegation of Authority and the financial coding manual)
- Prepare reconciliation reports relating to the financial transactions such as from the Expense Management System and IFMMS to provide relevant information to HQ management to support the accuracy of financial transactions and the effectiveness of CSC financial policies, procedures, practices and systems
- Provide advice and support to the managers and business administrative staffs in issues related to account payable, Government Acquisition Cards (GAC) and travel claims
- Provide training to the new financial specialists
Pay and Pension Agent
Public Services and Procurement Canada
Edmonton, AB
03.2007 - 12.2009
- Establish and maintain a good relationship with the client departmental Compensation Advisors by providing support and maintaining communication to ensure that the pay and pension functions are performed in a timely manner
- Perform pension calculations and adjustments to ensure that accurate pension deductions are remitted for every pay periods during interruptions in the employment period such as long term leave without pay
- Execute pension reconciliations and audits to ensure that accurate remittances for the entire lifecycle of the account
- Issue pension refunds by generating a Return of Contribution form for employment periods less than two years
- Initiate various pension forms for terminating employees
- Received recognition for my client service excellency from the departmental Director
Senior Sales Auditor
The Brick
Edmonton, AB
09.2005 - 03.2007
- Analyze and synthesize financial data retrieved from the Oracle Financial System into an Excel sheet to audit the credibility of miscellaneous credits issued by over 200 stores nationwide and to ensure that they are compliant to the company's regulations and policies
- Prepare month end reports for tax charge backs and make any recommendations for improvement
- Perform monthly tax audits such as sales tax exemptions, treaty Indians tax exemptions, business resale tax exemptions, government employees and non-resident tax exemptions to ensure that the stores adhere to the government tax regulations (GST, PST and QST)
- Prepare monthly reports to present my findings to the management for review
- Nominated as the Employee of the Month for recovering over $45,000 in my monthly sales audits
Education
Bachelor's Degree - Mathematics and Finance
University of Alberta
Edmonton, AB11.1999
Skills
- Data Visualization and Presentations
- Data Analysis
- SQL
- Data Cleaning
- Analytical Problem Solving
- Statistical Analysis
- Tableau
- Attention to Detail
- Data Validation
- Report Preparation
- Report Writing
- Data Mining
- Data and Analytics
- Trend Data Analysis
- Excel Functions
Languages
English
Full Professional
Additionalinformation - References
- Spencer Bownes, 403-461-4737, spencer.bownes@cer-rec.gc.ca, Supervisor
- Jepharry Brennan, 819-635-7729, jepharry.brennan@ised-isde.gc.ca, Supervisor
- Lynn Eaglechild, 403-827-1252, lynn.eaglechildgeer@gmail.com, Coworker
Timeline
Data Analyst/Compensation Advisor
Canada Energy Regulator
08.2017 - Current
TradeMark Examiner
CANADIAN INTELLECTUAL PROPERTY OFFICE
09.2016 - 08.2017
Finance Specialist - Temporary Assignment
Correctional Service Canada
01.2014 - 04.2015
Compensation Advisor
Correctional Service Canada
12.2009 - 08.2016
Pay and Pension Agent
Public Services and Procurement Canada
03.2007 - 12.2009
Senior Sales Auditor
The Brick
09.2005 - 03.2007
Bachelor's Degree - Mathematics and Finance
University of Alberta