Ashley DeBernardo

2213 31^st Ave SW T2T 1T7 │ (587) 582-6454 │ Ashley.d@shaw.ca

https://sites.google.com/view/ashleydebernardo/home

SKILLS

● Coding: Over 4 years of working with R, SQL, VBA, and Groovy in both a classroom and professional setting

● Excel Proficiency: Built specialized macros in Excel and Word to automate redundant tasks performed daily at my workplace

● Teamwork & Leadership: Over 7 years working on a team of coworkers to maintain a successful working environment in a retail, corporate and athletic environment

● Stakeholder Relations: Over 6 years of working with both internal and external stakeholders to provide support for existing processes and develop new business solutions from scratch

EDUCATION

Bachelor of Commerce (2020) – Business Analytics Sep 2016 – Apr 2020

University of Calgary - Haskayne School of Business

● Nexen Scholarship ($2,000 per year, totalling in $8,000 over my 4 year degree)

● Alexander Rutherford Scholarship ($2,500)

● Majoring in Business Analytics gave me both the technical skills to collect and organize data in a meaningful way as well as the business knowledge required to assess and address that data

EMPLOYMENT HISTORY

CNOOC International January 2022 – Present

Business Focal Point – Finance Team

● Developed Excel Macros to automate time intensive processes

● Created millions of dollars in purchase requisitions and services entries and processed millions of dollars of invoices in SAP

● Provided support for both team leads within my team, acting as the main point of contact for both the business and external stakeholders during their absences

● Developed reporting features with BW reporting to streamline reporting for the overall finance team as well as within my own group

● Provided training to both internal employees and external users of our systems in all business processes required to achieve accurate and efficient payment approvals.

GRID Dynamics Inc. September 2020 – December 2021

Enterprise Performance Management Consultant

● Assessed business and technical requirements of clients to create data models and reporting features that addressed all client needs

● Worked with R script and SQL to manipulate client data to create ETLs that cleaned and organized available data

● Created highly specialized Microsoft Excel Reports that allowed end users to easily view and assess available data

● Worked directly with clients and end users to improve existing reports and models to better address client needs

● Developed budgeting systems that allowed users to load data into their EPM system in a more efficient manner while still maintaining appropriate controls

CNOOC International Ltd. September – April 2018 / September 2019 – September 2020

Accounts Payable Analyst – Casual Employee

● Created Excel macros for daily reports and processes in accounts payable and other departments within the company to reduce an average of 7-10 hours of work per week

● Reached out to an average of 5 vendors a day to encourage a switch to invoice submission through OpenInvoice

● Trained new and current accounts payable employees in Calgary, British Columbia, Houston, and the UK in all accounts payable processes

● Acted as the main point of contact for those internal and external to the business for the majority of inquiries regarding accounts payable

University of Calgary September 2018 – April 2020

Teaching Assistant – MGST 391 (Business Analytics) & OPMA 317 (Fundamentals of Operations Management)

● Led tutorials for students and answered any questions regarding assignments and related course concepts

● Marked an average of 400 exams and assignments per semester

● Showed students in the class how to use Excel in an effective way to complete the necessary course requirements

● Assisted the professor in entering grades and organizing student materials

ALY Consulting June 2019 – April 2020

Small Business Consultant

● Met with clients to identify business needs and pain points

● Worked with clients to establish project scope and outline the service contract

● Reviewed financial statements and other information provided by the clients to offer recommendations

CNOOC International Ltd. May – August 2017 / May – August 2018 / May – August 2019

Accounts Payable Analyst – Summer Student

● Processed and average of 200 invoices per day

● Worked with the Business Focal Point group to ensure invoices were processed correctly with the appropriate approvals and controls

● Assisted in daily reporting and streamlining existing reporting processes to eliminate tedious aspects of each report