Taichung City, Taichung City, Taiwan
Hello, I’m Erick. I am a Senior BI, Data, and Software Engineer with 11+ years of experience delivering enterprise-scale data platforms across manufacturing and public-sector environments in Canada and Taiwan. My background spans end-to-end system analysis, data engineering, and analytics solution delivery in complex, enterprise settings. I specialize in designing and optimizing Azure-based data warehouses, developing scalable ETL pipelines using SSIS and Python, and building high-performance T-SQL solutions to support reliable reporting and data-driven decision making. I have extensive experience working in secure, audit-compliant enterprise environments, accessing systems through CyberArk Privileged Access Management (PAM), and collaborating with cross-functional teams to automate processes, improve data quality, and enhance operational efficiency. I hold a Master’s degree in Information Management and a Certificate in Applied Data Analytics from the British Columbia Institute of Technology (BCIT). I am passionate about building robust, scalable, and practical data solutions that translate business needs into actionable insights.
Strong background in system analysis, solution design, and delivery of enterprise BI and data platforms. ★ Led end-to-end system analysis, solution design, development, testing, deployment, and production support for 100+ enterprise BI projects using T-SQL, ETL tools, SSIS, SSRS, Python, Power BI, and Azure. ★ Analyzed business and technical requirements, designed scalable ETL architectures, and developed SSIS, Python, and PowerShell pipelines along with T-SQL quries, views and stored procedures, reducing data processing time from 50 minutes to near real-time and eliminating manual effort. ★ Designed analytical data models and system workflows, delivering Fraud Analytics dashboards in Power BI; published datasets and reports to Power BI Service and led migration from legacy SSRS to Power BI. ★ Designed and maintained Azure-based Data Warehouse architectures to support enterprise-scale analytics, reporting, and data governance. ★ Worked in a highly secure, audit-compliant enterprise environment, accessing systems via CyberArk Privileged Access Management (PAM). ★ Designed and developed internal Python-based data utilities, deployed on Windows servers, including Excel automation tools and packaged (pip-based) applications. ★ Performed system-level database administration and migration planning, including Windows Server and SQL Server migrations, job validation, IP updates, and post-migration troubleshooting.
I strategically managed and developed the follows for systems with 22 end users for DELL and Tesla. ※ Quanta SQL Server Database ※ Business Intelligence system ※ Order Fulfillment systems ※ EDI B2B system development ☆Main Projects and Skills ★ T-SQL, Store Procedures., C# – Processing and data modeling in Quanta Computer 30 large-scale projects. For example, DELL NB WIN 8 and WIN 10 Components Data Analysis project. ★ SSRS - PO Overdue Report, 1 to 1 Mapping Report. ★ SSIS ETL- The materials from orders extracted, transformed and loaded into S.F. System. ★ B2B EDI - 850, 855, 856, 856 Ack, 810 and 810 Ack ☆Played an instrumental role in the company achieving US $791M+ earnings in 2015, growing by about $150M from 2014, through streamlining manufacturing and direct ship systems, covering purchase order, manufacturing notebooks, shipment, and billing processes with SAP ERP. ☆Simplified business analysis with BI tools of sales and employers by developing 30 electronic reports by SSRS and 10 SSIS ETL programs to transfer data between servers and 320 Stored Procedures in SQL server for IT managed systems. ☆Completed System Integration Test (SIT) with DELL IT teams and Users Acceptance Test (UAT) with end-user for 13 large-scale system projects. Improved end-user and customer satisfaction by managing calls and resolving system issues with long term solutions. ☆Managed yearly system project 'E-dictionary' implementation for all notebook accounts in only 10 months timeline which was a 1-year plan from solution idea to completion and implemented successfully. ☆Promoted twice from Junior Engineer to Specialist 1 in only 4 years, it usually takes 5~6 years, the highest senior engineering position.