Analytical Electrochemist by training, Business Intelligence/Data Technologist by profession.
Experience of building and leading BI and analytics teams, defining practices, competencies and standards.
Data Warehousing:
Data Warehouse Framework Architecture,
Data Modelling,
Database and Data Warehouse design,
Kimball Methodology
Microsoft BI Expert:
Microsoft SQL Server databases from 2000 to 2014,
ETL architecture with Microsoft SSIS 2005-2014
Microsoft Analysis Services,
Microsoft Reporting Services,
Microsoft PerformancePoint,
Microsoft PowerPivot
Microsoft PowerView
Microsoft Certified:
SQL Server 2000 Design
SQL Server 2000 Administration
SQL Server 2005 Maintenance and Administration
MCITP: Database Developer 2005
MCITP: Business Intelligence Developer 2008
70-461 Querying Microsoft SQL Server 2012
70-467 Designing Business Intelligence Solutions with SQL Server 2012
70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Data Analytics:
Tableau Certified Consultant
QlikView
Alteryx
Industry Specialties:
Healthcare - Primary and Secondary Care data - SUS, HES, GP, Community, Mental Health, Social Care, Risk models, QOF, TRUD
Finance - FX
Insurance - Lloyds Market
Government Open Data - Education, ONS
Media, Industrial
Supply Chain
Director of Business Intelligence @ Leading the BI and Data Warehouse strategy
Strategic technical partnerships
Key client development and relationships
Technical product development
Continual growth of BI/Analytics team capability From October 2014 to Present (1 year) London BridgeHead of Business Intelligence @ Responsible for:
Growing and managing the BI Development, BI Support and BI QA Teams
Overall BI solutions architecture and quality
Product workstreams and projects
Technical direction
Business Development
Direction and development of in-house IP, to drive efficiency, robustness and repeatability.
Resource planning
Client Relations
Product owner of the Patient Care Pathway Plus Data Warehouse offering a Patient level view across data sets including SUS, GP, Community, Mental Health, Discharge Summary, A And E Daily, Walk-In/Out Of Hours Centres, Social Care and Housing. In-built processes included pseudonomisation, SUS versioning, CPM risk stratification and QOF I & II.
Product owner of Concentra's Data Warehouse Accelerator Framework - a robust and scalable approach to data warehousing, encompassing in-built logging, auditing, data validation, error handling, progress and data-quality reporting.
http://blog.concentra.co.uk/author/weelin-lim/ From September 2011 to September 2014 (3 years 1 month) London BridgeLead Business Intelligence Developer @ Team lead responsible for a number of BI developers working on several projects.
Responsibility for technical architecture, project scoping, proposal writing, pre-sales technical expertise and developing the team's skill set.
Hands-on technical Data Warehouse, Cube and ETL design and development.
Setting BI technical standards.
Architected a dynamic Data Warehouse Process Framework to accelerate the development of Data Warehouse builds and ETL processes, including progress auditing, data validation reporting and batch validation.
Designed and delivered a successful Healthcare Data Warehouse product which has led to multiple deployments and major spin-off projects.
Expert knowledge of working with NHS SUS, Rio, GP and Community datasets. From January 2010 to September 2011 (1 year 9 months) London BridgeSenior Data Warehouse Developer @ Involved in Data Warehouse design, SSIS ETL and Analysis Services Cube design and implementations.
Worked with claims, premiums and returns data. From June 2008 to January 2010 (1 year 8 months) London, United KingdomSenior Business Intelligence Consultant @ Designing and building databases/data warehouses, ETL architecture, cubes and front-end reports.
Data Modelling.
Business Requirements gathering.
Technologies - SQL Server 2005, Integration Services, Analysis Services, Reporting Services, SQL Server 2000, DTS
From 2007-2008, worked on a new Data Warehouse for a major investment bank (Citi), loading and processing global FX data. Designed the ETL architecture for loading/cleansing data and processing cubes. This included dynamically building cube partitions and synchronising cubes across servers. This project won the Microsoft Global BI Award 2008.
The ETL Framework was then re-used for multiple projects.
Previous BI projects for Shell, BP, IMS Health, OFSTED From February 2002 to June 2008 (6 years 5 months) Business Intelligence Consultant @ Part of a small team from IMGroup, designing and building a new Data Warehouse and ETL process for Global Sales data, using Microsoft SQL Server 2000, DTS, MS Reporting Services and Panorama.
This project won the Microsoft Global BI Award 2005 From 2004 to 2006 (2 years) Support Developer @ Developing and maintaining E-Commerce sites for the Finance industry. Worked on sites for Deutche Bank, C Hoare Bank, Woolwich etc. From February 2001 to February 2002 (1 year 1 month) Systems Engineer @ Building IT systems for large organisations through the whole project life cycle:
Analysis, Design, Build, Test, Implement. From July 1997 to February 2001 (3 years 8 months)
B.Sc and Ph.D, Chemistry @ Queen Mary University of London From 1988 to 1995 Weelin Lim is skilled in: ETL, Data Warehousing, Analysis Services, SSIS, Business Intelligence, Microsoft SQL Server, SSRS, Data Modeling, Data Warehouse..., Tableau, Architecture, Databases, Cubes, T-SQL, OLAP, Dimensional Modeling, Data Visualization, Big Data, Master Data Management, Erwin, Business Requirements, MDX, Business Intelligence..., SQL, Solution Architecture, SSAS, SQL Server, Healthcare, Database Design, Data Migration, Data Visualisation, Microsoft Business..., Kimball Methodology, Dashboard, Performance Point, Data Integration, DTS, Data Quality, QlikView, Enterprise Architecture, Requirements Gathering, Alteryx, SharePoint, Crystal Reports
Websites:
http://www.concentra.co.uk