Ling W. Email & Phone Number

County Dublin, Ireland

Design and Implement high volume risk data solution with AWS data services (Redshift, Athena, Glue, Spectrum, RDS) to support modelling simulations.Hands-on experience on many BI solutions (Tableau, PowerBI, Dremio). Experienced MPP DWH dev and admin.

 Full responsible for designing the enterprise data warehouse and data analytics platform. Decision making on technologies and architecture roadmap. End to end prototyping, which includes ETL orchestration, data warehouse model design, real-time events handling and data analytics (BI & prediction modelling) functions

County Dublin, Ireland

Define and manage information architecture & data integration blueprints, data modelling, data analytics, data migration, data quality, metadata management, data auditing process, database versioning control & continuous integration deployment, conformance to database & BI standard.  Specialised on OLTP and data warehouse performance tuning, in-depth knowledge of SQL Server storage and query optimizer, coding efficiency, indexing strategy etc. Successfully improved multiple model risk application data warehouse and data mart performance.

Design and implement EDW framework to support fast-growing business requirements (e.g., finance, payment, marketing, online & local operations, SPSS & R data analysts, and SEOs). Contribute to technical decision making from the beginning and provides the detailed feasible recommendations to senior management. In-depth knowledge on EDW structure design & BI framework implementation, and proven experience at the latest Microsoft BI suits (SSIS & SSRS & SSAS).

Dublin

Senior BI developer, design and implement extreme large DW & BI applications with SQL Server 2005 & 2008 + BO XI. A solid understanding and proven experience of processing BIG data. Contribute to all tiers of development, e.g., data modelling & schema design, ETL & rollup implementation, data quality control, data analysis architect and application support. Design & implement financial KPI reports & dashboards that consumed by the senior management. Provide a complex and flexible BI solution for supporting market promotions and financial decisions. Successful delivered many projects require 3PP integrations, e.g., Unica campaign, Netinsight, SAS. Familiar with those market leading products admin & APIs. Solid knowledge on DW & BI design and administration.

Key member of Performance Management team Network Intelligence Quotient (ENIQ) project. ENIQ is the statistical data mart in Performance Management of Ericsson network system. Hands on experience on re-design EDW & BI structure on Solaris environment, e.g. schema design, retention process handling, ETL routine, BO universe and pre-defined reports design, etc. Specialise in Sybase 12.5 & 15 performance tuning technique.