Kate Phang

- Designed, develop & maintained the full BI stack: SQL databases, SSIS ETL packages, Power BI data models and reports. - Optimized SQL performance to ensure the highest levels of data integrity and processing efficiency. - Collaborate with stakeholders to translate requirements into actionable BI deliverables. - Create interactive Power BI dashboards with advanced DAX, drill-down filters & RLS security. - Leveraged Infor ERP system data for back-tracing and validating data lineage within BI solutions. Key Project – Purchasing KPI Dashboard (Power BI): Purchasing KPI Dashboard: Built a strategic Power BI dashboard for top management, enabling identification of cost-saving opportunities and supplier risks through automated KPI scorecards, which improved the supplier evaluation process. Technical Skills: - Languages & DAX: SQL, DAX - BI Platforms: Power BI (Certified) - ETL & Tools: SSIS - Systems: Infor ERP CERTIFICATION: Microsoft Certified: Power BI Data Analyst Associate (PL-300) Credential ID: 7FFB75-E7904F

- Played a pivotal role as pioneer in the establishment of a 1st greenfield Germany EMS company in Asia. (Euro-Asian Market). - Led the end-to-end setup of the factory, including IT infrastructure (server hardware, Wi-Fi, access points), security systems (employee access cards, boom gates, emergency exit doors), and facilities management. - Collaborated closely with the Germany infrastructure team F2F, providing 1st level on-site support to ensure seamless integration with global IT standards. - As the SAP key user supporting for SAP cross-module functionalities and a good understanding of the business process and procedures. - Led the end-to-end SAP setup, ensuring seamless SAP system integration. - Setting up Material Master (Direct, Indirect Materials, Assets), Vendor Master, GL Accounts, Cost Center & Profit Center. - Purchase Requisition & Purchase Order Process TRAINING ATTENDED: - MBrain MES Configuration: Tailoring to manufacturing facility requirements & workflows and Integrating with SAP for seamless data exchange & synchronization.

- SAP SD & WM configuration, SAP Transportation Execution & Management configuration - Order Management, Warehousing - Finished Goods (HU management, Pick-Pack, PGI, CI) & Transportation business process. - Works with MIW warehouse super user to solve incorrect sequence of storage bins proposed in the Transfer Order which indirectly reduce Ops placement TPT and effectiveness of material storage on time. Upon the re-index done, it’s tremendously improved placement TO’s creation around 80%. - Coverage of SAP MR ECC-W upgrade and manages to resolve the WM DEV testing issues during the ‘Q4 Support Pack Testing’ within the timeline and with all the testing pass to ensure no impact to production release in WW06.0’18. TRAINING ATTENDED: - SCM600 Business processes in Sales and Distribution - SCM610 Delivery Processing in SAP

- Providing L2/L3 horizontal support in Front End Reporting with MicroStrategy, BOBJ, BEX & Microsoft BI, receiving and responding to daily incident/problem, handling routine service requests, troubleshooting incident/problem and resolution. - As Early Engager in a few MicroStrategy to BOBJ conversion projects for 500+ reports, works closely with Project Manager and development team to ensure smooth project handoff, involves in UAT testing for BOBJ reports conversion. - Provides F2F operation and BOBJ technical training (universe, data foundation, business layer, Web Intelligence & CMC) to the global Costa Rica new team members. - Build the team competency and building up the working relationship with global team members. PROJECTS: - Global leadership for 3 Geos as Transition Project Manager leading the SC IT PS Front End Data & Reporting team to align vertically to their respective portfolio. - Leads the team went through 6 different transition phases in resource planning, knowledge transition, documentation, team task allocation & helps to remove roadblocks within 4 months period. The knowledge transition for the successors are going exceptionally well with the scoring goal of 80% and above across all the phases. TRAININGS ATTENDED: - BOID10 Information Design Tool - BOID20 Advanced Use of the Information Design Tool - BOW310 Web Intelligence: Report Design I - BOW320 SAP Business Objects Web Intelligence: Advanced Report Design - MS SQL Server 2012 Reporting Services (SSRS) - MS SQL Server 2012 Analysis Services (SSAS)

- Providing L2/L3 support in SAP BI/BW and work closely with service desk and downstream for daily production issue, resolves any critical production major incident. - Identifying the data in source, mapping data to the BW & identifying data quality gaps. - Monitor BI loads on on-call rotation basis and resolve load issues as needed. - Familiar with InfoObjects, InfoCubes, Data Sources, Transformations, DSO, Extractors & Process Chains. - Familiar with Extract, Transform and Load (ETL) in data warehouse with strong analytical skills. PROJECTS: - Develop permanent solution for SAP limitation of Early Watch Alert (EWA) 100000 requests which is useful for the cleanup & can be reuse to meets the business requirement for frequent data load in SAP BI environment & enable the system working normal & free from the performance issue. - Develop permanent code fix for the hex data issue on daily operation and successfully deployed to Production with no defects and eliminates job failure for 3 times daily. TRAININGS ATTENDED: - BW310 Data Warehousing - 7 Habits Of Highly Effective People

- Identifying options for potential solutions and assessing them for both technical and business suitability. - Creating logical and innovative solutions to complex problems and provide the customers with optimum, qualitative and reliable resolutions. - Problem manager - works closely with the functional/product manager as well as the developers to diagnosed application problems, including root cause analysis for incident elimination and solution is provided to the customers. - Use IDOCS (Intermediate documents)/EDI (Electronic Document interchange) technology and related business processes for incoming/ outgoing payments, as well as workflow. - New hierarchy setup – Configuration setup in area of house banks, automatic payment program to enable host to host house bank setup by working closely with Citibank and AP users. - Working closely with developers, basis support, procurement, managed inventory, finance, capital, vendor master team and downstream applications (EDW, Staging, supplier portal) in daily production support to ensure technical compatibility and user satisfaction. - Using Readsoft (Certified SAP Partner) Cockpit to handles the processing of invoices from scanning to final posting and archiving in SAP. - Involving in SAP re-platform to ECC by contributing in drill downs the ticket backlogs during the SAP P2P (Procure to Pay) stabilization. - Work with transport management and review change requests as part of the change management process using Solution Manager. - Performed Unit Testing on the system using different test scenarios and test cases. TRAININGS ATTENDED: - ITIL Foundation EXIN Certification in IT Service Management - SCM550 Customizing in Materials Management - SAP Change Management Overview Training - BC400 ABAP Workbench: Concepts and Tools - BC430 ABAP Dictionary - AP Invoice Processing in SAP ECC - AP GR/IR & Voucher Verification in SAP ECC

- Code development in all phases of the software development life cycle to deliver applications/solutions that meet business requirements - Provide Rock Solid 2nd /3rd Level production support to keep the business running. - Improve Total Cost of Ownership by proactively EOL applications and support outsourcing effort. - Deliver value to Intel by developing end to end solutions in support of SAP Re-platform program, User Enhancements and Legal Entity Restructuring. - Provides trainings (as content expert) for the Websuite/SPS applications to L1 production support, TCS as well as peers. PROJECTS: - .Net Dynamic discounting project which invest $50k and annual return $3M to Intel. - P2P/ESC code development and unit testing independently per committed milestones which avoided system issues post P2P landing. - eNeg application commodity conversion project to support CST EOL. - Transition of knowledge to MBS team and bringing MBS developer up to speed and filling in all the gaps. - Outsource of eRoom application support to TCS India by providing quality knowledge transfer to TCS to resolve issues independently and meet the customer SLA. TRAININGS ATTENDED: - Introduction to C# Programming Language - TERADATA BASICS AT INTEL - Core Web application Technologies with Microsoft Visual Studio 2005 - Updating your database development skills to Microsoft SQL server 2005 - Implementing and maintaining SQL server 2005 integration services

- Understand and explore in sales business process. - Familiar with Microsoft Excel Pivot Table. - Analyze on related sales metrics and reports. - Work closely with sales team and management by providing assistance and analysis. TRAININGS ATTENDED: - Inside Sales BMS - Sales Ops on backlog management and CE - Outside BMS - Improvement on target collection - Pricing - Sales Comm & Analysis - Understanding SQL data structure

Bachelor degree holder of Information Technology, with my major in data communication in Multimedia University. Good academic record throughout.