Technical Skills
BI: Microsoft Power BI, SAP BusinessObjects, SAP Crystal Reports
Databases: Access, Oracle Database 11g
Languages: CSS, HTML, JavaScript, MS SQL, PL/SQL, SQL, VBA
Software: Adobe Illustrator, Microsoft Dynamics 365, Microsoft Office, NetSuite, Oracle SQL Developer, Photoshop, QuickBooks, Sage 50, SAP, Visual Studio, WordPress
Experience
Business System Analyst - Finance, Information Services
Sunnybrook Health Sciences Centre
August 2021 - Present
Responsible for supporting the Accounts Receivable System (HRCM), ensuring the integrity, accuracy, and availability of the data for the Patient Accounts team. Help the Finance team with the creation of ad-hoc datasets and reports and other technical needs.
- Led the data migration project including mapping the risks and potential impacts for Veterans Affairs Canada. This project required extracting, archiving, and moving the data and reports from Access Database to mitigate risk from unsupported software. Successfully implemented the new data and created new reports to HRCM with minimal impact on stakeholders and patients.
- Update and maintain tables (schedules, workflow patterns, etc.) on the application’s interface and backend (Oracle Database 11g)
- Create queries and operate processes to collect, consolidate, validate, and provide data for the Finance team
- Lead QA and productivity testing to ensure the system is functioning according to the business requirement
- Monitor interfaces from the Hospital’s Registration (Quadramed/HL7), and Finance (SAP) systems and coordinate a resolution for any identified issues
- Implement and maintain accounts receivable databases and ETL processes. Provide root cause analysis to investigate issues related to data discrepancies.
Office Manager
eurOptimum display Inc.
Oct. 2019 - August 2021
Oversee and ensure efficient execution of day-to-day operational office activities. Key responsibilities include office administration, reconciling expenses, inventory management and IT support.
- Researched, interviewed and evaluated vendors for new managed IT services contract. Successfully awarded the contract to a new vendor that offered a higher quality of services and with an annual cost savings of $12,000.
- Project lead for the head office relocation. Surveyed real estate agents that understood key stakeholders’ timeline, cost and needs and reviewed project management, design and construction proposals. Oversaw the logistics of the relocation and decommissioned the old office.
- Improved the file server and implemented SharePoint to free up storage space without allocating additional costs to increase the physical server. Utilized SharePoint to create a central portal for staff and setup wiki pages for processes, how-to tutorials, and forms.
- Provided L1 technical support. Deployed, maintained and supported workstations, printers and peripherals. Installed and maintained hardware and software components on computer stations and IT equipment.
Operations Manager
Nimbus Water Systems Inc.
Apr. 2018 - Oct. 2019
Monitor departmental performance against goals to ensure that targets are met, analyze and report on department KPIs, maintain vehicle logs and insurance policies, and maintain commercial accounts and contracts.
- Project manager for the largest water refill dispenser rollout in Canada. Point of contact with Sobeys key stakeholders. Oversaw the removal of the old equipment and installation of the new water refill dispensers in over 600 corporate and franchise stores across Canada.
- Improved the accounts receivable processes for current and aged customer accounts with outstanding balances. Eliminated manual entries on Excel spreadsheets to reduce clerical errors and developed a new report using VBA to automate the import/update process for new data.
- Facilitated the transition of going paperless and launched Aptora, a CRM platform, for the national service team. Trained the team on how to use the new platform which allowed the team to complete service calls through the app on their assigned iPads instead of mailing the service request paperwork.
Office Manager
Knight Realty Brokerage Inc.
Nov. 2016 - Nov. 2018
Responsible for the day-to-day operations of a fast-paced office. Duties included budgeting, bank reconciliation, design and create marketing campaigns and materials.
- Conducted an internal financial audit of all accounts in preparation for closing the fiscal year. Identified incorrect data entries made from the bookkeeper which resulted in assuming the accounting responsibilities
- Strategized marketing campaigns using SEO and Google AdWords that resulted in increased website traffic and leads
- Rebranded the company’s logo and designed new client presentations and reports to align with the new company’s look and feel
Systems Coordinator and Supervisor of Administration
Safway Group
Dec. 2014 - Oct. 2016
Analyze data entries, develop reports based on executive and client requirements using SQL through BusinessObjects, improve administrative processes and monitor key performance indicators (KPIs) for upper management and Suncor stakeholders.
- Developed multiple reports based on selected data identified in 3-year audit which resulted in a settlement for less than 0.02% of revenue based on the data retrieved from the reports
- Analyzed administrative procedures and designed VBA spreadsheets that eliminated task redundancies and improved employee efficiency
- Analyzed union scaffolders’ break schedule and proposed an alternative break schedule that increased field productivity and reduced payroll costs by 30%
Education
Seneca College
Computer Programming
Sep. 2020 - Present
Courses: Introduction to UNIX/Linux, Web Programming Principles, Introduction to Programming Using C, Introduction to Database Systems and Data Communications Fundamentals
Niagara College
Business - Accounting Diploma
Sep. 2009 - Apr. 2011