Open to opportunities

Ying Liang-Lui

@yinglianglui

Message

Experienced data analyst with a focus on operational process improvement.

United States

Message

What I'm looking for

I am looking for a role that fosters collaboration and innovation, with opportunities for growth and impactful projects.

I am a seasoned data analyst with over 10 years of experience in business and data analysis. My expertise lies in translating complex business requirements into actionable plans, identifying key issues, and articulating their impact effectively. I have spent 8 years specializing in digital marketing and advertising data, focusing on data operations and workflow improvement.

Throughout my career, I have overseen data operations, facilitating cross-functional communication to ensure the delivery of high-quality data to clients. My project management experience spans from initiation to execution, particularly in data migration and integration. At Kinesso, I successfully managed diverse teams across multiple countries, enhancing collaboration and ensuring data quality management.

My technical skills include proficiency in various data management tools such as Snowflake, AWS, and SQL, which I have utilized to refine data structures and develop validation frameworks. I am passionate about leveraging data to drive insights and improve operational efficiency, and I am committed to delivering optimal user experiences through reliable data solutions.

Experience

Work history, roles, and key accomplishments

Manager, Data Operations in Product

Kinesso

Feb 2018 - Apr 2024 (6 years 2 months)

Led migrations of Global Reporting to AWS and Snowflake, followed by a subsequent cloud infrastructure migration. Reorganized and integrated legacy reporting teams into a unified Data Operations group, enhancing flexibility and resource allocation. Identified supportability gaps and developed critical processes, including user onboarding and data quality metrics monitoring, to drive product succes

Snowflake AWS Data Migration Data Integration Data Quality Process Improvement MongoDB

Business Data Analyst

Intuit

Jan 2017 - Feb 2018 (1 year 1 month)

Successfully executed UAT on the new Intuit On-Line Payroll data mart, ensuring data integrity for accurate finance reporting. Conducted thorough data analysis, identifying discrepancies and defects, and providing detailed root cause analysis to the development team. Developed a comprehensive UAT summary report and presentation, facilitating a smooth transition to the new system.

UAT Data Analysis Data Integrity Root Cause Analysis Reporting

Senior Database Developer

Cadreon

Aug 2014 - Jan 2017 (2 years 5 months)

Supported Cadreon's billing and reporting solution across 24 markets and 25+ Demand-Side Platforms. Participated in migrating Cadreon Intelligence Business Reporting to Salesforce Marketing Cloud Intelligence, integrating programmatic advertising campaign data. Optimized data ingestion and transformation processes by mapping and transforming input data files, ensuring accurate calculations.

Database Development Billing Reporting Systems Salesforce Marketing Cloud Data Integration Financial Reporting DSPs

Senior Information Analyst

PG&E

May 2014 - Aug 2014 (3 months)

Ensured all data was accurately sourced and set up into the Marketing Decision Support System database. Developed the data validation policy and scripts to ensure data integrity. Maintained key tables for the Energy Efficiency Portfolio in MDSS to support programs generating over 200,000 energy efficiency related rebates annually.

Database Management Data Validation Data Integrity Scripting

Senior Business System Analyst

Kaiser Permanente

Jan 2013 - Nov 2013 (10 months)

Performed data configuration, analysis, and quality monitoring for the Medicare Total Sales Systems. Maintained and conducted quality checks on master data files including Medicare plan coverage, zip codes, facilities, and users. Uploaded, transformed, and transmitted Medicare data files to third party vendors, facilitating seamless data exchange.

Data Analysis Data Quality Data Extraction

Data Warehouse Developer

IGT (International Game Technology)

Aug 2005 - Jan 2013 (7 years 5 months)

Designed and implemented scalable data warehouse solutions, leveraging star schema modeling to support efficient querying and analytics. Developed robust ETL processes for seamless data loading and transformation using PL/SQL. Designed, developed, and implemented a comprehensive financial and reporting data mart to aggregate raw data.