Sr. Data Engineer

YEN TRAN

*******.***@*****.***

https://www.linkedin.com/in/yentranlee/

PROFESSIONAL SUMMARY

Experienced Software Developer and Data Engineer with 15+ years in the IT industry, specializing in designing and implementing scalable data platforms solutions. Expertise in real-time streaming, Big Data processing (Hadoop, Hive, Kafka, Spark, PySpark, Apache Hudi, Kubernetes), and cloud-based data architectures (GCP, AWS). Proficient in building and automating data pipelines, modeling data warehouses, and orchestrating workflows with tools like Airflow, Matillion, Alteryx. Skilled in business intelligence tools (Power BI, Tableau) and adept at driving actionable insights through collaboration with cross-functional teams. Passionate about problem-solving, innovation, and leveraging emerging technologies to deliver reliable, high-availability data pipelines and data lakes platform. EDUCATION

Harvard Extension School 2025 - 2026

Principals of Finance GRAD Certificate

Portland State University Portland, OR Jan, 2013 – June, 2015 M.S. in Engineering and Technology Management. Graduated with Honor HUFLIT University Ho Chi Minh, Vietnam Oct 1996 – Oct 2000 B.S. in Computer Science

1. Entrepreneurial Venture Co-Founder & Software Engineer (Data) Fremont, CA ( Jul 2024 - Current)

• Build a data-driven startup, focusing on innovative solutions in data engineering and analytics. 2. Senior Data Engineer

Tesla, Fremont, CA (April, 2022 – May,2024)

• Designed and implemented scalable data pipelines processing billions of daily records using Spark, PySpark, Scala, Python, and SQL on AWS EMR, Kubernetes, unifying analytics across teams.

• Built and optimized batch & streaming ETL pipelines for Kafka-based data ingestion, transforming and storing massive datasets in Parquet on S3, enabling fast analytics with Trino, Presto, and Hive.

• Managed evolving data schemas, ensuring backward compatibility while supporting new business requirements for BI, reporting, and data science use cases.

• Collaborated with BI and Data Science teams to design and maintain aggregate tables and data marts, improving query efficiency for Tableau, Grafana, and JMP dashboards.

• Integrated new tools and frameworks into the data stack, implementing custom Python/PySpark Airflow operators to enhance automation and optimize ETL workflows.

• Provided on-call support and monitoring, leveraging Opsgenie for incident response and Splunk for real- time logging and troubleshooting.

• Mentored engineers and analysts on data engineering best practices, advocating for CI/CD automation

(GitHub Actions, Artifactory) and improving pipeline reliability. 3. Senior Data Engineer

The Home Depot, Vancouver, WA (Feb 2017 - Apr 2022)

● Architect, build and launch new data models of data warehouse and data marts that provide intuitive analytics to business partners

● Design, build and launch extremely efficient & reliable data pipelines to migrate data from on-prem databases (Teradata, Oracle, MS SQL, Salesforce) to Google Cloud BigQuery.

● Communicate with stakeholders and design, build data pipelines to move data from Cassandra, Elasticsearch, Salesforce, MSSQL Servers, Oracle to Data Lake (Big Query) on Google Cloud Platform PROFESSIONAL EXPERIENCE

using Python, Data Fusion, Dataflow, Data Studio, Data Catalog, Cloud Spanner, Pub/Sub, Airflow, CI/CD, Kafka, KSQL, Elasticsearch, Kibana, Microservice, Docker, GitHub, JenKins, Jira

● Collaboratively work and act as liaison with SRE, software developers, Product teams in a fast paced environment, to meet deadlines. Support Data consumers and Data Scientists with ad-hoc and data platform projects required across functional areas such as Operations, Merchandising, Pricing Strategy, Marketing, Sales, Finance, and Product Development as well as provide solutions to drive efficiency and improved results for The Home Depot Quote Center.

4. Senior ETL developer

Lattice Semiconductor, Portland, OR (Feb 2016 - Jan 2017)

● Develop, design, and support interactive Tableau based dashboards and workbooks. Admin Tableau servers 9.2 on PROD/TEST/DEV environments. Using Tableau’s JavaScript API in enhancing Tableau report’s view.

● Interact with business users and translate business requirements into sustainable and efficient visualizations and reporting. Work with a team to investigate data inconsistencies, perform analysis of data and troubleshoot data integrity issues.

● Extract/Query data from various database sources (Salesforce, OSC, CPQ, EBS) using SQL Developer

(ORACLE and SQL Server)

5. Senior Data warehouse Engineer

Nike, Beaverton OR (Oct 2015 - Feb 2016)

● Involved in the day to day support of Nike WHQ Global Customer Service (online Global sales, Call centers) reporting infrastructure. Work with all regions of the organization providing user support, making sure appropriate tickets or actions are taken.

● Maintained and troubleshoot DW and BI reports using SSIS, SSAS (Tabular), SSRS, T-SQL, SharePoint 2010, Tableau 9

6. Dynamics CRM SSRS Developer

Tektronix, Beaverton, OR (June 2015 - Oct 2015)

Upgraded and optimized existing reports that were built for Dynamics CRM 2013 as well as built new reports for Dynamics 2015 using SSRS in Visual Studio 2013

7. BI Developer Intern

OHSU Oregon Health & Science University, Portland, Oregon (Jul 2014 - Mar 2015)

● Delivered Cognos 10.2 Workspace Advanced training courses for more than 20 BI IT staffs

● Enhanced/migrate existed reports created by Oracle BI Discoverer by using IBM Cognos Report Studio, Cognos Framework Manager, Workspace, IBM Cognos Workspace Advanced, and IBM Cognos Active Report.

● Created ETL processes (sequences, jobs) using DataStage, PL/SQL, and T-SQL. Automation scheduled ETL jobs, which collect data from integrated data sources (EBS, ERP) for BI reports, using JobScheduler

(Unix shell scripts).

8. IT Manager, Business and Information Systems

Sacombank Investment, HoChiMinh, Vietnam (Feb 2007 - Jan 2011) Management:

● Created and structured Business Application Support Department

● Hired, coached, and managed in-house team of 11 including 2 database administrator, 5 System Engineers, and 4 Technical Supports; team has installed, maintained, and manipulated all the Business System Applications of the company including Securities Trading Core System, Financial System (Oracle E- Business Suite), Dynamics CRM for brokers, Pledging System, company Portal Website (Microsoft SharePoint Server); team has supported daily working tasks for over 300 employees.

● Led user requirements gathering, planning and design meetings among managers of function-groups, internal colleagues, external Software providers, and proposed the solution to upgrade the Securities Trading Core System (Front Office and Back Office), Dynamics CRM, EBS.

● Administered internal Portal site including SharePoint 2010 development and administration using ASP.net / C# and web parts for custom development.

Project Management:

● Made plans, selected software providers, and managed IT projects of upgrading all Information Systems for the company regarding changing business requirements. 9. Technical Trainer

TD&T - Microsoft Gold Partner, HCM, Vietnam (Jan 2004 - Feb 2007)

● Delivered technical training courses of Microsoft, Oracle, IBM (Lotus Notes), Sun, and Business Objects including database servers, application servers, programming, and creating reports; training method average ratings 9.5 out of 10

● Supported and maintained services for Oracle’s customers: Oracle Application/Database/Developer 9i

● Business System Analyst:

● Consulted SharePoint server 2005/2007 by liaising with end users/business partners to apply business area and system knowledge to provide integration solutions

● Liaison between clients and developers: implemented SharePoint 2010 / 2013 development and administration including ASP.net / C#

10. Technical Instructor

New Horizons Computer Learning Centers - Vietnam (Oct 2002 - Dec 2003)Taught IT courses designed by New Horizons; training method average ratings 9.2 out of 10 Microsoft Office XP, 2003. Object-Oriented: Java 2 Programming, J2EE . IBM: Using Lotus Notes 6.5 11. Software Engineer

FPT Software, Vietnam (Jan 2002 - Sep 2002)

Analyzed business requirements, communicated directly to customers Designed, developed, and deployed intranet websites 12. Software Engineer

CSC, Vietnam (Oct 2000 - Dec 2001)

● Designed, coded and debugged applications in various software languages including Java, .Net, HTML, JavaScript.

● Implemented tasks: software analysis, code analysis, requirements analysis (UML), software review, identification of code metrics, software testing, and quality assurance

● Supported, maintained and documented software functionality 1. Microsoft Solution Builder Program (2005)

● A Microsoft prize which hold for Microsoft Partners about Solution Builder Program for Business Collaboration using Microsoft Office System 2003:

● Provide Enterprise solution for Customer Management using Microsoft SharePoint Server 2003, Microsoft Office 2003 based on Microsoft Windows Server 2003 integrated with Microsoft Exchange server 2000 HONORS / ACTIVITIES

2. Dundar F. Kocaoglu Fellowship Award,Engineering and Technology Management - Portland State University (June, 2014)

3. International Student Scholarship, Portland State University (April, 2014) 4. Honor Student, Portland State University Chapter of the Omega Rho International Honor Society (Jan, 2015)

● Sun Certificate Java2 Programming (SCJP) 2001

● Certified Internet Web (CIW) Associate 2002

● Microsoft Certified Professional in ASP.Net 2003

● Microsoft Certified Professional in SQL programming 2003

● Oracle Certified Professional 10g (OCP) - DBA 2006

● Graduate Certificate in Project Management 2015

OMEGA RHO® International Honor Society for Operations Research and Management Science - The Honor Society of INFORMS (Mar 2015-Present)

Published article on IEEE Xplore

● Saatchi, B.; Pham, L.; Pham, H.; Pai, C.F.; Tran, Y., "Decision model for selecting a sedan car," TechnologyManagement in the IT-Driven Services (PICMET), 2013 Proceedings of PICMET '13:, vol., no., pp.393,400, July 28 2013-Aug. 1 2013 CERTIFICATE

AFFILIATION

PUBLICATION

REFERENCES are available as request

Contact this candidate