Ying Liang-Lui

Experience

• 

  IGT

  Aug 2005 - Jan 2013

  Data Warehouse Developer

  * 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, optimizing performance and reliability* Conducted in-depth data analysis to help identify data gaps and integrity issues encountered during the design of data marts * Designed, developed and implemented a comprehensive financial and reporting data mart to aggregate raw data for player transactions, game transactions, player transfers, player verificationTechnology: Oracle 10g, PL/SQL, TOAD, Informix 11, SPL, Server Studio, MS SQL Server 2005, T-SQL, SQL Server Management Studio, OWB, OBIEE, Crystal Report 8.5, UNIX, Erwin, DB2, ETL Show less

• 

  Kaiser Permanente

  Jan 2013 - Nov 2013

  Sr. Business System Analyst

  * Performed data configuration, analysis, and quality monitoring for the Medicare Total Sales Systems (MTSS), ensuring data integrity and alignment with requirements* Maintained and conducted quality checks on master data files-including Medicare plan coverage, zip codes, facilities, and users-to ensure accuracy and consistency* Uploaded, transformed and transmitted Medicare data files to third party vendors, facilitating seamless data exchange* Extracted and merged data from multiple database for to support business reporting and analysisTechnology: Oracle 10g, PL/SQL, SQL Loader, MySQL, SQL, TOAD Show less

• 

  Pacific Gas and Electric Company

  May 2014 - Aug 2014

  Sr. Information Analyst

  * Ensured all data is accurately sourced and set up into the Marketing Decision Support System (MDSS) database* Developed the data validation policy and scripts to ensure data integrity * Maintained the key tables for Energy Efficiency Portfolio in MDSS to support all of PG&E’s Energy Efficiency programs that generates over 200,000-energy efficiency related rebates annuallyTechnology: Oracle, PL/SQL, SQL, TOAD

• 

  Cadreon

  Aug 2014 - Jan 2017

  Sr. Database Developer

  * Provided critical support for Cadreon's billing and reporting solution across 24 markets and 25+ Demand-Side Platforms (DSPs)* Participated in migrating Cadreon Intelligence Business Reporting (CIBR) to Salesforce Marketing Cloud Intelligence, integrating programmatic advertising campaign data for billing and performance reporting* Configured data connections, including APIconnect, TotalConnect and LiteConnect for data ingestion of the media buying and delivery data, facilitating financial data processing* Optimized data ingestion and transformation processes by mapping and transforming input data files (IDFs) to Salesforce Marketing Cloud Intelligence, ensuring accurate calculations* Enhanced financial reporting capabilities by implementing calculated measurements in Salesforce Marketing Cloud Intelligence for precise cost, fee, and tax computations* Successfully led the migration of CIBR source code from Apache Subversion (SVN) to GitHub, enhancing version control and collaboration Technology: Salesforce Marketing Cloud Intelligence (Datorama), Oracle, Redshift, MySQL, PL/SQL, SQL Show less

• 

  Intuit

  Feb 2017 - Feb 2018

  Business Data Analyst

  * Successfully executed UAT on the new Intuit On-Line Payroll (IOP) data mart, ensuring data integrity for accurate finance reporting * Conducted a thorough data analysis, identifying discrepancies and defects, and providing detailed root cause analysis to the development team for resolution* Developed a comprehensive UAT summary report and presentation, facilitating a smooth transition to the new systemTechnology: Vertica, SQL, Wiki, MS Excel, MS Word, MS PowerPoint

• 

  KINESSO

  Feb 2018 - Apr 2024

  Manager, Data Operations in Product

  * Led the operations team for 'Reporting and Billing' and 'Global Reporting' products, managing programmatic advertising campaign data integration from demand-side platforms (DSPs) and ad servers* Led the migrations of Global Reporting from Concierge data integration in Salesforce Marketing Cloud Intelligence to a standardized model in AWS, followed by a subsequent cloud infrastructure migration utilizing Snowflake* Partnered with Engineering and Product leaders to design processes and solutions that address complex support challenges and implement product improvements* Identified and addressed product-specific supportability gaps and developed several critical processes, including user onboarding, complex record-level security models, and key data quality metrics monitoring, to drive product success* Collaborated with the team to resolve escalated issues, ensuring timely and effective solutions that reduced user friction and improved overall customer satisfaction* Monitored and identified potential issues, translating them into improvement opportunities and proposing viable solutions* Fostered transparency by delivering regular reports and hosting review sessions with leadership, engineering, and product teams, driving informed decision-making and cross-functional alignmentTechnology: Snowflake, Salesforce Marketing Cloud Intelligence (Datorama), AWS S3, Athena, Redshift, Airflow, Oracle, MySQL, SQL, Jira, GitHub, Confluence, SharePoint, Excel, Word, PowerPoint Show less