Open to opportunities

Usman Dauda

@usmandauda

Message

Data analyst skilled in Python and data visualization techniques.

Canada

Message

What I'm looking for

I am looking for opportunities that foster growth, innovation, and collaboration in data analytics.

I am a dedicated data analyst with a strong background in developing data-driven solutions that enhance business performance. Over the past three years at Aviva Canada, I have collaborated with product owners to create dashboards and data ingestion processes that supported the launch of a new telematics product, ultimately serving over 100,000 customers and generating more than $10 million in premiums.

My expertise in Python and Qlik Sense has enabled me to develop a web-scraping application that validated VINs against manufacturer recall websites, successfully identifying fraudulently insured vehicles and saving over $500,000 in premium leakage. Additionally, I have optimized and automated over 20 monthly reporting processes, significantly reducing manual effort and improving delivery times by over 40 hours each month.

Currently, as a Senior Data Systems Analyst, I am leading a cloud data migration project to Snowflake, ensuring data accuracy and usability post-migration. My experience with PostgreSQL and Agile methodologies has allowed me to troubleshoot data issues effectively and translate business requirements into technical specifications for developers.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Systems Analyst

Current

Aviva Canada

Jan 2024 - Present (1 year 5 months)

Led a cloud data migration project, transforming on-premises data into Snowflake using Airflow and dbt, and optimizing table structures into a star schema for performance. Maintained and optimized an enterprise PostgreSQL database with billions of rows, troubleshooting data issues and translating business requirements into technical specifications for developers.

Snowflake Airflow DBT PostgreSQL SQL Python Data Migration Optimization Agile Methodology

Data Analyst

Aviva Canada

Jan 2021 - Present (4 years 5 months)

Collaborated with product owners to develop dashboards and data ingestion processes for a new telematics product using Python and QlikSense, supporting 100K+ customers and $10M+ in premiums. Developed a web-scraping application with Selenium in Python to validate VINs, identifying fraudulently insured vehicles and saving over $500K in premium leakage. Optimized and automated 20+ monthly reporting

Python Selenium SQL VBA Data Ingestion Web Scraping Fraud Detection Reporting

Education

Degrees, certifications, and relevant coursework

University of Western Ontario

Bachelor of Engineering, Mechatronic Systems Engineering

Studied the integration of mechanical engineering, electronics, computer science, and control systems. Gained expertise in designing and controlling automated systems and robotics.

University of Western Ontario

Master of Data Analytics, Data Analytics

Completed a Master's degree focusing on advanced data analysis techniques, statistical modeling, and machine learning. Developed skills in extracting insights from complex datasets to support data-driven decision-making.