Brandon Lim

Experience

1. Consultant Strategy & Analytics

   Deloitte

   Jan 2022 — Present

   Client Engagement – Data Analyst Financial Sector/ Banking Jan 2023 – Present • Led all phases of the Data Warehouse development lifecycle from requirements gathering, design, profiling, implementation, testing and support for the digital subsidiary of a Japanese multinational banking and financial services institution • Coordinated and led comprehensive data profiling efforts to analyze the quality, consistency, and accuracy of complex data sets from three different data sources, resulting in the identification of critical data quality issues and recommendations for improvement • Built centralized & standardized Integrated Data Model currently used for all business analytical needs and requirements which enables specific business use cases for KPI & Metrics reporting purposes and integration of data across multiple systems • Collaborated with business stakeholders to gather and document data requirements and translate them into technical specifications • Built ETL (Extract, Transform, Load) processes to transform and integrate data from various sources into the data warehouse including the development of Target to Source Mapping, SQL queries, QA test cases and much more Client Engagement – Business Analyst Financial Sector/ Banking Jan 2022 – Dec 2022 • Led solutioning of American multinational financial services company’s data strategy for enterprise data management & governance in alliance with the client, vendors, and developers • Conducted user interviews & product discovery sessions gathering requirements to create business process flows that capture the newly set one-stop-shop data management transformation efforts for the enterprise’s product features • Coordinated firm’s efforts of implementing newly set Data Management Policies and Procedures through creating a strategy for automated workflows