- BUILT AND MAINTAINED SEVERAL CORE FINANCIAL REPORTS AND ANAYLYSIS TOOLS: PROJECT CONTRIBUTION, FEE INCOME AND PM PERFORMANCE, UTILIZATION RATE, PROJECT CLOSING, PROJECT CLOSE PRE-SCREENING, AFDA, FIXED PRICE REPORT, LABOUR ALLOCATION, CRA TRANSACTION LISTING AND AGGREGATED SUMMARY… ETC. - BUILT COMPANY WIDE BUDGET TEMPLATES WITH VBA USER LEVEL SECURITY, AUTHENTICAED USERS AGAINST NETWORK CREDENTIALS AND GRANTED APPROPRIATE ACCESS THROUGH PREDEFINED ROLES. - PRIMARILY USE EXCEL VBA/POWER QUERY WITH DATA CONNECTIONS TO AX 2012/D365 AND BUILT SQL QUERIES USING AZURE DATA STUDIO. USED EXCEL FORMULAS TO PASS USER PARAMETERS TO SERVER. - TRAINED JUNIOR ANALYSTS.

- MAINTAINED REVENUE RECOGNITION, GENERATED GL AND PROJECT ADJUSTMENTS, AND CREATED/ UPDATED MONTHLY FINANCIALS FOR THREE WESTERN CANADA AND QUEBEC BUSINESS UNITS. PERFORMED POST MONTH-END REPORTING AND RECONCILIATIONS INCLUDING SALES/WORK ON HAND. - PERFORMED QUARTERLY FEE INCOME RECONCILIATIONS FOR GL TO PROJECT MODULES, THEN GENERATED COMPANY- WIDE FEE INCOME AND PM/PRINCIPAL PERFORMANCE REPORTS. - NUMEROUS AD-HOC REPORTS AND ANALYSIS AS REQUIRED (VBA, SQL, MS QUERY, SSRS), AND RECONCILIATIONS. VARIOUS DATA SUBMISSIONS AND SUMMARIES FOR RFP SUBMISSIONS AND FINANCIAL AUDIT REQUESTS. - ASSISTED WITH BUDGET PREPARATION. - BUILT AND DEPLOYED COMPANY-LEVEL TIMESHEET STATUS REPORT THROUGH SSRS, CUSTOMIZED AND DISTRIBUTED TO INDIVIDUAL BUSINESS UNITS.

- PERFORMED CORE AR LEAD DUTIES INCLUDING OVERSEEING INVOICING AND CASH RECEIPTS, COLLECTIONS EFFORTS, WORKER TRAINING AND DEVELOPMENT, AND ESTABLISHING POLICIES AND PROCEDURES. - ACHIEVED < 5% BAD DEBTS EXPENSES. - AUTOMATED PMIS (PROJECT MANAGEMENT INVOICING SYSTEM) INVOICE NAMING ROUTINE WITH OUTLOOK AND EXCEL VBA. (DISCOUNTED HUNDREDS OF HOURS OF MANUAL ENTRY) - PERFORMED FULL FINANCIALS DATA MIGRATION (ETL) FROM DELTEK ADVANTAGE TO MS DYNAMICS AX PRIMARILY THROUGH MS ACCESS QUERIES, AND EXCEL VBA SCRIPTED ROUTINES.

- TRAINING OF NEW CLERKS AND FORMING AR POLICIES AND PROCEDURES. ASSIST AR TEAM IN VARIOUS REPORTING AND ANALYTICAL TASKS. - CUSTOM BUILT HARRIS’S WORKING CAPITAL REPORT (EXCEL PIVOT TABLE/VBA AUTOMATION). - CUSTOM BUILT HARD COPY COLLECTIONS LETTERS TOOL USED BY HIGH VOLUME BUSINESS UNITS; GREATLY IMPROVED CURRENT WORKING CAPITAL PERFORMANCE AGAINST BENCHMARK QUOTAS. - AUTOMATED FORMS RECONCILIATION PROCESS. - PROMOTED AND TESTED E-MAILER GREAT PLAINS ADD-ON. INCLUDES E-INVOICING, E-STATEMENTS AND POTENTIAL USE OF ELECTRONIC TRANSMISSION FOR ACH PAYMENT REMITTANCES. - COMPANY LIAISON FOR GREAT PLAINS TECHNICAL SUPPORT ISSUES WITH SUPPORT PROVIDER. - RETAINED FULL AR CLERKING RESPONSIBILITIES FOR NORTHSTAR BUSINESS UNIT, ALONG WITH DEPOSIT PROCESSING FOR THE TEXAS BUSINESS UNIT.

- PERFORMING CORE ACCOUNTS RECEIVABLE FUNCTIONS INCLUDING PROCESSING OF DAILY DEPOSITS, PROCESSING INVOICES AND CREDIT MEMOS, MAINTENANCE OF VARIOUS ACCOUNT SCHEDULES, RESPONDING TO INTERNAL AND CLIENT INQUIRIES, CUSTOMER COLLECTIONS.

- ANALYZED CRA AND RQ AUTOCOMPENSATION TRANSACTIONS. BUILT AND USED CUSTOM AD HOC APPLICATION FOR TRANSACTION RECONCILING OVER 4.2 MILLION TRANSACTIONS ($8 BILLION) BETWEEN THE 2 SYSTEMS USING GRADUATING LEVELS OF CONFIDENCE. (BUILT WITH MS EXCEL AND ACCESS) - PERFORMED SEVERAL POST-MATCHING ANALYSES ON RESIDUAL (UNRECONCILED) TRANSACTIONS ON BOTH CRA AND RQ RECORDS INCLUDING COMPARISONS OF CLIENT ACCOUNTS VS. BANK TRANSACTIONS, CHECKS FOR TRANSACTION DUPLICATION, AND FURTHER MATCHINGS USING ALTERNATE CRITERIA. - PERIODICALLY COMMUNICATED FINDINGS, PROVIDED PRESENTATIONS AND DEMONSTRATIONS, AS WELL AS ANALYTICAL REPORTS TO INTERNAL CRA AUDITORS AND MANAGEMENT. - FINALIZED DATABASE AND DOCUMENTED USER INSTRUCTIONS FOR 3RD PARTY USERS TO UTILIZE THE APPLICATION AND PROVIDED DETAILED AND SUMMARY STATISTICS USED IN THE FINAL PROJECT REPORT.

- SUPPORTING VARIOUS MULTIVIEW PRODUCTS INCLUDING THE CORE FINANCIALS PACKAGE. MAINLY SUPPORTED GL, AP, AR MODULES AND CS DAVE ONLINE FINANCIAL REPORTING PACKAGE. - TESTED AND TAUGHT ON LEDGER AND SUB-LEDGER FUNCTIONALITY (I.E. BANK RECONCILIATION, FULL CYCLE PROCESSING, PERIOD END AND CLOSING PROCEDURES, SECURITY FEATURES, FINANCIAL REPORTING…ETC.). - TESTED AND REPORTED BUGS, COMMUNICATED PRODUCT ENHANCEMENT REQUESTS. OCCASIONALLY CREATED CUSTOM MS QUERIES FOR CUSTOM FINANCIAL REPORTING REQUESTS. - ASSISTED AND ADVISED ON THE IMPLEMENTATION OF SYSTEM SECURITY AND INTERNAL CONTROLS THROUGH FUNCTIONAL (ROLES/MODULES) AND USER (ACCOUNTS/UNIT/PROJECTS) LEVELS FOR SOX OBLIGATIONS.

- PERFORMING FULL ACCOUNTS RECEIVABLE RESPONSIBILITIES FOR HEALTHCARE FOOD SERVICES (HFS) AND HEALTHCARE LINEN SERVICES (HLS) INCLUDING: GENERATING AND MAILING OF VARIOUS INVOICES AND CREDIT MEMOS, PROCESSING DAILY DEPOSITS, MANAGING CUSTOMER INVOICING AND STATEMENT INQUIRIES, AND AGED RECEIVABLES FOLLOW-UP. - GENERATING AUXILIARY INVOICES FOR BACKHAULING SERVICES AND CREDIT MEMOS FOR BLACK BAG AND SHIPMENT DISCREPANCIES. - PERFORMING MULTIPLE BANK RECONCILIATIONS AND MAINTAINED VARIOUS GENERAL LEDGER SCHEDULES SUCH AS CART AND BARRIER CIRCULATIONS, AND RECONCILED PAYROLL HOURS WITH SUPERVISOR SUBMITTED EFFICIENCY HOURS. - ENTERING MONTHLY G/L STATUTORY REMITTANCES AND ASSISTED IN INVENTORY, PETTY CASH DISBURSEMENTS, PURCHASE AND MAINTENANCE OF OFFICE SUPPLIES AND EQUIPMENT.