Ralla King Email & Phone Number

Edmonton, Alberta, Canada

I provide enterprise data solution, from collecting business objectives to final deployment. Currently I build data integration solutions and data models using BigQuery and design dashboards in Looker. Over the past few years, I have worked on several different projects to deploy data solutions for unique business objective requirements that improve communication across departments. I enjoy creating comprehensive and interactive dashboards for various departments across the company using the single version of the truth.As the primary lead I provided training, as well as technical support, to on-board over 200 users to Looker, including designing a custom solution in Looker to improve ease-of-use for new users. Recently I undertook a project to optimize BigQuery and Looker query times to reduce query response times by 83%.Aside from working in GCP, I also assist with data quality improvements and cleansing to identify knowledge gaps and reduce errors or redundancies from source systems.I enjoy finding the little gems of insight that make it easier for people to achieve success and identify potential problems before they become ugly beasts. I am constantly looking for improvements and optimizations.

Edmonton, Alberta, Canada

Worked with consulting company to set up data warehouse in BigQuery, including designing models in Looker. Designed visual representations of the models using LucidChart. Wrote SQL queries and created models in Looker. Continued updates to sales Excel workbooks. Time investment for skills training for new BigQuery and Looker.

Edmonton, Alberta, Canada

Designed analytics solutions for sales, including tracking revenue to budget. Created Excel workbooks for cross-department communication with Operations and Charting. Created processes and reporting for managing issues with charting.Conceptualized new process for managing spec and template sheets to reduce errors and streamline process.

Edmonton, Alberta, Canada

Provided data insights using available tools, such as Microsoft Excel to reduce costs, increase profit and refine processes.Collaborated on a quarterly regional report, initially with Leasing but expanded to multiple departments, including defining metrics and reporting.

Edmonton, Alberta, Canada

Responsible for lease administration and transit charting for the prairie region, including designing reporting for leasing and managing process improvements for transit charting.

Winnipeg, Manitoba, Canada

Responsible for lease administration and transit charting for the prairie region. Managed two different teams within the region.

Winnipeg, Manitoba, Canada

Responsible for lease and payment details, including reporting, for lease administration within the Prairie Region. Designed new processes to improve communication between departments.Managed a team of six lease administrators in three provinces.

Winnipeg, Manitoba, Canada

Responsible for leases and payments for Manitoba and Saskatchewan. Created reporting for monitoring lease activity.Transit chartist for Manitoba and Thunder Bay. Conceptualized new process with software company and deployed the system across the country. Responsible for training transit chartists and operations personnel. Improved reporting for the country and streamlined access for all users.

Winnipeg, Manitoba, Canada

Took on new role for transit charting, including set-up for new transit authority.Managed relationship with transit authority. Coordinated with transit installers to deliver campaigns.

Winnipeg, Manitoba, Canada

Coverage for maternity leave for charting and sales coordination, as well as lease administration.

Winnipeg, Manitoba, Canada

Answered phones, communicated with contractors, coded invoices.Developed new process to manage utility payments to address redundancy and decrease time spent. Took on the lease admin responsibilities. Learned new software and became proficient using industry-specific software.

Edmonton, Alberta, Canada

Delivery of the Business Intelligence and Analytics certificate.