Jeffrey Sham Email & Phone Number

Mississauga, Ontario, Canada

• Provided consulting services on employee benefits and HR administration services web platform to clients (fortunes 500 companies and government organizations)
• Gathered business requirements, questions, complaints, and technical incidences from client meetings. Translated clients’ requirements into Jira tickets
• Supported new client implementation projects, change requests, annual enrollment, smoke testing, UAT/CAT (user acceptance test/client acceptance test)
• Preformed RCA(root-cause analyses) and data tracing on incidences and documented in SharePoint.
• Based on urgencies and severity, investigated incidences and troubleshot software configuration issues including front-end UI (HTML, CSS), and back-end system or data issues (SQL database, system job running scripts.
• Designed unit testing based on use-cases and ensured correctness and reliability to the solution, designed and executed functional test procedures

Toronto, Canada Area

• Enterprise Risk Reporting Project
• Provided effective oversight within the Integrate Metrolinx and Cyber Security Risk Management Program. Collaborated with management stakeholders across the organization to promote decision making that established risk.
• Interviewed stakeholders on weekly bases to identify system and human resource risk, advise on risk mitigations, follow-up on solution implementations and escalate issues as appropriate. Provided quarterly updates to.
• Participated in data extraction from Oracle EBS, data conversion and data uploading to Oracle HCM using SQL and Excel
• Created mock data for testing different union/non union users, including user’s contact, benefit, absences.
• Helped external technical team (Deloitte) investigate data errors using Excel and provided recommendations to solve data errors

Toronto, Canada Area

• Performed 3-way matching, processed and monitored invoices and receipts in Oracle for purchase orders, Presto Funds’ drawdown, Capital Projects Group Receiving etc.
• Worked closely with financial analysts, senior business analysts and Project control officers to identify, investigate, resolve and update missing information of purchase orders in Oracle back-end.
• Converted and modified procurement data (for operating expense and capital expense accounts conversion) by using MS Excel (Vlookup, Function, Pivot Table) in order to export old data from PCS3
• system and imported converted new data into Oracle system, performed data cleansing and retrieved data from Oracle using SQL query in Toad for Oracle, consolidated data into reports and presented to stakeholders

Toronto, Canada Area

• Processed entries by using multiple steps and analyzed unique situations with critical thinking to ensure adjustments are posted directly to customer's accounts, operation centers or branches
• Received requests, verified information against documentation and did transactions data entry through MS Excel and in-house data base system
• Completed clerical duties such as filing, faxing, photocopying, stationery ordering, Client’s data entry, creating or modified established spreadsheets to provide administrative support to department
• Strived to meet high customer service levels by processing incoming requests efficiently and in accordance with banking procedures and policies to meet Service Level Agreements
• Prioritized and organized workload based on risk/severity and documents required to ensure deadlines are met according to banking policies and procedures and service level agreements
• Trained new incumbents or temporary staff on procedures and guidelines to ensure transfer of knowledge and consistency in process