Data Engineer/ Data Analyst

Roy Luo

PROFESSIONAL SUMMARY

Results-driven Data Engineer & Analyst with a master’s from UT Dallas and 7+ years of experience at tech leaders like Meituan and Ctrip. Expert in building scalable data architectures, ETL pipelines, and real-time Doris-based dashboards. Demonstrated success in automating large-scale reporting and driving business strategy through AI/LLM integration. No visa sponsorship required.

TECHNICAL SKILLS

●PROGRAMMING: SQL (Hive/MySQL/SQL Server), Python, R, JS, PHP, HTML/CSS

●BI&TOOLS: Power BI, Tableau, SAS, Doris, Git, Enterprise Internal Data Platforms (Zeus/Artnova/Vinci)

●CORE SKILLS: Data Governance, Data Cleansing, ETL, Data Modeling/Warehousing, AI (RAG/LLMs)

●LANGUAGES: English (Fluent), Mandarin (Native)

EDUCATION

UNIVERSITY OF TEXAS AT DALLAS Dallas, TX

Master of Information Technology and Management August 2013 – May 2015

BEIJING UNIVERSITY OF POSTS AND TELECOMUNICATIONS Beijing, China

Bachelor of Network Engineering September 2009 – June 2013

EXPERIENCE

MEITUAN HANHAI INFORMATION TECHNOLOGY Shanghai, China

Senior Data Engineer May 2021 – March 2023

●Data Governance & Metric Standardization: Redesigned multi-layer models to unify 900+ atomic, derived, and composite metrics on an internal governance platform; ensured data consistency between real-time and offline warehouses to achieve SSOT. Enabled direct backend computation calls, accelerating BI workflows by 50%.

●Reporting System Upgrade: Upgraded central reporting from v1.0 to v2.0 by rearchitecting intermediate layers; expanded metrics from 150 to 300+. Sustained 1,200+ daily visits across 30 RDCs and saving 2 specialists per center.

●NRT Operational Monitoring: Built Doris-based dashboards with 5-minute latency for front-line operations. Developed Data APIs to handle complex logic and live metrics, ensuring smooth and efficient on-site execution.

●0-to-1 Metric Development: Built T-1 offline reporting suites from scratch for Transfer Center and Pickup Service branches. Defined indicators to support routine business reviews and fill data gaps across new transport segments.

CTRIP CORPORATE TRAVEL Shanghai, China

Senior Data Analyst April 2018 – May 2021

●B2B Client Profiling & Insights: Collaborated with Marketing to publish the annual China Corporate Travel White Paper for 3 consecutive years. Developed a comprehensive corporate client persona database via Hive SQL, identified a 15% profit growth opportunity by developing a mixed payment model for targeted promotions.

●Churn Prediction: Built HiveSQL models to identify at-risk small to large enterprise clients. Automated weekly lists for the operations team to enable early interventions and improve client retention.

●Performance Management Automation: Partnered with cross-functional leaders to design annual KPI frameworks. Migrated manual tracking to an automated HiveSQL pipeline, providing transparent monthly performance dashboards that improved staff engagement and contributed to winning the Ctrip Group Best Employee Award (Top 1%)

●Operational Excellence: Partnered with HR and CRM admins to audit attendance data and standardize CRM data collection. Designed and built HiveSQL pipelines for weekly execution reports to enable granular management.

PLANNED CAREER BREAK Keller, Texas

April 2023 – Present

●Relocation & Work Authorization: Managed family relocation to the U.S. while finalizing U.S. work authorization.

●AI & BI Upskilling: Achieving Microsoft Power BI certification; mastering AI Engineering via LLM application development, RAG frameworks, and Prompt Engineering to automate complex data workflows.

C&A CULTURAL EXCHANGE LLC Garland, Texas

IT Specialist July 2016 – December 2017

●Managed web development (PHP/HTML/CSS) and IT Operations, including email systems and network setup.

●Synced multi-channel sales with Amazon FBA to optimize inventory and fulfillment.

VENSOFT INC. Glendale, Arizona

Data Analyst August 2015 – July 2016

●Used SQL Server to collect, clean, and analyze datasets to drive business reporting accuracy for PRONTOH.COM.

AWARDS & CERTIFICATIONS

●Microsoft Certified: Power BI Data Analyst Associate Issued Nov 2025

●The Best Excellent Staff Ctrip Group (2019)

●MCSA SQL Server 2012/2014 and SAS Statistical Business Analyst Certificate

Location: Keller, Texas, 76248 TEL: 682-***-****

Email: **********@*****.*** linkedin.com/in/roy-yi-luo-364aa585

Authorized to work for any U.S. employer without sponsorship

Contact this candidate