Lin (Jamie) Lan Email & Phone Number

Toronto, Ontario, Canada

• Design, develop, and automate data pipelines across key banking domains, delivering transformed data to GCP, MINIO, or Hive, for enterprise-wide consumption • Lead the creation of consumption views for the Customer domain, integrating business logic for critical initiatives, and collaborating with stakeholders for data analysis in BigQuery • Lead a team of data engineers in the On-Prem to Cloud migration, converting ETL scripts from Spark to DBT • Design DBT macros to streamline data transformation and implement best practices, optimizing DBT pipelines for performance and scalability • Oversee daily pipeline monitoring, troubleshoot issues, and communicate with stakeholders • Manage and mentor a team of Co-Ops, providing guidance and technical oversight • Lead the recruitment efforts for interns, ensuring the acquisitionof top-tier talent to support organizational objectives and initiatives. • Tools/Language used: Google Cloud Platform, DBT, Airflow, Python, Spark-PySpark, SQL, MINIO, Hive

Toronto, Canada Area

• Developed data solutions within the Internal Audit Data Ecosystem, collaborating with data scientists and auditors to leverage best-fit models for optimal audit solutions.• Built and supported scalable, automated ETL data pipelines from source to analytics, enabling continuous monitoring of key business risk areas.• Worked with large, diverse data sets in various formats, visualizing end products that are comprehensible, relevant, and reusable for business end-users.• Supported tooling and automation for the DevOps pipeline and various Software Development Life Cycle activities; assessed current solutions to identify opportunities for enhancement, integration, or expansion to better address client needs.• Tools/Language used: Python, Spark-PySpark, SQL, Tableau, Dataiku

Toronto, Canada Area

Toronto, Canada

• Documented technical requirements for back-office functionalities, including account setup, customer support, and reporting, while assisting in scheduling and budgeting.• Coordinated with other departments to ensure system integration during the requirements stage.• Managed development and QA timelines, facilitated testing, and resolved bugs before scheduled production during the development phase.• Tools/Languages used: Python, SQL, SAS, Tableau, Excel, MS Access

Department Of Computer Information Systems

• Assisted department committees in identifying data patterns, which help suggest improvements in the admission process and focus areas. • Generated analytical support to support key decision making for faculty recruiting and university events• Tools/Languages used: Tableau, Excel

Gibraltar

• Responsibilities included CRM information gathering, product promotion, sales data analysis, market research and member training • Provided Chinese/English translation of document for research and administration

Olympic Park, London

• Led volunteers to organize shuttle bus transportation for clients: athletes, International Olympic Committee officials. • Daily duties included: training volunteers on client service and radio communication, oversee multiple load zones, escort customers and provide professional service including Chinese/English translation• Conducted service for opening and closing ceremonies

Master Of Science (M.S.), Computer Information Systems, Current Gpa 3.83

Atlanta, GA Built a strong background in information systems and the application of information and communications technology in business.

Bachelor Of Arts (B.A.), Music & Music Technology, Graduated With Honours

Activities and Societies: Making it Happen in the Arts- Creative Enterprise Programme (Member); Insight into Enterprise and Employability.