Experience

• 

  Fintelics

  Mar 2022 - Sept 2022

  Data analyst

  • Managed large-scale data using Azure Data Lake and Databricks by converting file structures from CSV to Parquet, reducing file sizes by 60% and improving data storage and processing performance.• Constructed end-to-end data pipelines using Python to clean and process raw client data, partitioning the data by time (month, year) for optimizing query and data processing performances.• Implemented data quality assurance using SQL queries, validating data integrity by checking for missing values, duplicates, which improved data accuracy and reliability in the pipeline. Show less

• 

  Purolator inc.

  Sept 2022 - Sept 2023

  Data engineer

  • Designed and implemented a fully automated Cost and Usage Report system with AWS services to streamline financial tracking, following Agile. Created a System Architecture Diagram with detailed annotations.• Built PySpark-based ETL pipelines, processing over 30 million records from Amazon weekly. Ensured data integrity during migration from S3 to Redshift Serverless, improving data processing efficiency by 20%.• Architected event-driven data workflows using AWS Step Functions and EventBridge. Introduced proactive alert systems, reducing troubleshooting time by 40% and cutting manual intervention to near-zero.• Created real-time interactive dashboards using Power BI and AWS Quicksight, which provided key insights that helped reduce cloud costs and informed critical resource allocation decisions. Show less

• 

  Voithos labs inc.

  Sept 2023 - Apr 2024

  Software engineer

  • Collaborated with data scientists and engineers to develop an AI powered note-taking application. Built reusable and scalable frontend components(e.g. search bar, to-do list, calendar), seamlessly integrating GPT models.• Designed a document-based schema in MongoDB, optimizing core data models into separate collections with referencing strategies, enhancing scalability and performance for a high-demand note-taking app.• Utilized Snowflake’s VARIANT data type to handle schema mismatches in cloud backup for application note data stored in JSON format, ensuring seamless storage and transformation of semi-structured data. Show less