Summary
Overview
Work History
Education
Skills
Languages
Affiliations
Websites
Timeline
Generic

Diana Lorena Rodriguez Avila

Data/Systems Specialist
Mississauga,Ontario

Summary

Results-driven Systems/Data Specialist with expertise in business intelligence, data analysis, and process automation. Currently serving at Zeiss Vision Canada, responsible for optimizing IT systems and driving improvements in data management, Power BI report design, and system architecture. Proficient in automating data extraction, transformation, and reporting processes to enhance operational efficiency and reduce inconsistencies. Previously, as a Software Development Associate at Accenture, I led technical and functional initiatives, resolving critical application issues and improving service delivery, which boosted SLA compliance from 70% to 98%. Passionate about leveraging data-driven insights to support decision-making and drive continuous process improvements across diverse sectors.

4o mini

Overview

11
11
years of professional experience

Work History

Data/Systems Specialist

Carl Zeiss Vision Canada In
Toronto, Ontario
09.2022 - Current

Responsibilities:

  • Managed and optimized IT systems for lab operations (LMS, OE, DVI), including maintenance, implementation, and process updates.
  • Developed and modified Power BI reports, collaborating with production teams to identify opportunities for improvement and increase operational efficiency.
  • Responsible for system integration and the implementation of new data architectures, including process automation using UNIX and database extraction.
  • Worked with internal departments to improve data processes and ensure the quality of information used for decision-making.

Achievements:

  • Designed Power BI reports that have been instrumental in strategic decision-making, reducing production breakage and enhancing productivity.
  • Optimized automated workflows, improving operational efficiency and reducing data processing time.
  • Contributed to continuous process improvement, increasing production and facilitating decision-making by clearly presenting key data.

Business Intelligence Analysis Intern

Region of Waterloo
Waterloo, ON
09.2021 - 12.2021

Responsibilities:

  • Designed and developed reports to analyze and improve understanding within the Facilities and Fleet Management (FFM) area.
  • Monitored the impact of strategic decisions and initiatives, ensuring they align with operational goals.
  • Analyzed data and evaluated results to optimize reports and ensure accurate decision-making.
  • Collaborated with the supervisor to enhance reports and achieve optimal results for operational planning.
  • Automated data extraction, transformation, and reporting processes, reducing inefficiencies and minimizing inconsistencies.

Key Achievements:

  • Optimized Power BI and SQL Server reports, enabling managers to make timely, data-driven financial and planning decisions in the Facilities and Fleet Management area.

Software Development Associate/Analyst Consultant

Accenture
Bogota, Colombia
04.2014 - 09.2019

Responsibilities:

  • Led the technical and functional aspects of the applications for the AM LATAM TELEFONICA COLOMBIA project.
  • Acted as a backup for team members, ensuring workload distribution and support in case of absence.
  • Participated as a member of the project quality team, working to improve processes and reduce inconsistencies in software build artifacts.
  • Collaborated with the integration team to enhance the working environment and streamline team activities.
  • Addressed incidents promptly, ensuring that delivery requirements and SLA compliance were met.

Key Achievement:

  • Resolved an application issue by applying Oracle PL-SQL, Pro*C, Unix Shell, and Java best practices, resulting in a significant decrease in incidents and an increase in SLA compliance from 70% to 98%.

Education

Graduate Certificate - /Big Data Solution Architecture

Conestoga College Institute of Technology And Advanced Learning
Kitchener, None
12-2021

Bachelor of Science - Systems Engineering

University El Bosque
Bogota, Colombia
08-2015

Skills

  • Database Management & Optimization
  • Relational Data Models
  • SQL, Power BI, Tableau
  • Data Extraction, Transformation & Reporting (ETL)
  • Process Automation (UNIX, Scripts)
  • Data Analysis & Reporting
  • Business Intelligence & Dashboard Design
  • Strategic Planning & Process Improvement

Languages

Spanish
Native/ Bilingual
English
Professional
American Sign Language
Native/ Bilingual

Affiliations

  • Passionate about fitness, regularly attending the gym and training for marathons, half marathons, and 10 km races.
  • Enthusiast of nature and wildlife photography, capturing the beauty of the natural world and animals.

Timeline

Data/Systems Specialist

Carl Zeiss Vision Canada In
09.2022 - Current

Business Intelligence Analysis Intern

Region of Waterloo
09.2021 - 12.2021

Software Development Associate/Analyst Consultant

Accenture
04.2014 - 09.2019

Graduate Certificate - /Big Data Solution Architecture

Conestoga College Institute of Technology And Advanced Learning

Bachelor of Science - Systems Engineering

University El Bosque
Diana Lorena Rodriguez AvilaData/Systems Specialist