Jia-Yuan Lin
4F., No. 7, Ln. 6868, Sec. 4, Zhongyang Rd., Tucheng Dist., New Taipei City, Taiwan
+886-9-63116650
[email protected]
SUMMARY
- An importer, trainer and consultant of power BI.
- An administrator for maintaining EDI(Electronic Data Interchange) and ETL(Extract Transform Load) services, and developing the transaction processes with Java, webMethods, and Informatica. Seven year's experience in the fields of EDI and ETL.
- One year of experience as an administrator of SSIS.
- A solution provider for digitalization projects by integrating SharePoint, Forms, Lists, Power Platform.
- Familiar with Oracle, MSSQL, MySQL, H2.
- A junior infrastructure engineer with a one-year experience, and responsible for the work of BIG-IP LTM, and network monitoring systems.
WORK EXPERIENCE
Application Analyst DHL Express Taiwan, Taipei, Taiwan
Nov. 2021 - Now
- Training non-IT staff on Power BI, and being a consultant.
- Improved 50% of the rate of commercial invoices providing by establishing a Power BI dashboard for sales.
- Created a Power BI dashboard for analyzing digitalization projects, and made the project managers keep track of their progress.
- Created a Power BI dashboard to monitor the activity of the customer who is the first-time buyer in DHL.
- Replaced the paper work in GEMBA walk by using Microsoft Form, Power Automate, Power Apps, and Power BI.
- Decreased 50% of the login time on the payroll system by establishing the Signal Sign On with Azure AD.
- Reduced 30% of time integrating the file links in Sharepoint by Power BI dashboard.
Deputy Project Manager Synnex Technology International Corporation, Taipei, Taiwan
Oct. 2018 - Aug. 2021
- Reviewing the system architecture from SA(System Architect), giving suggestions and fixing the architecture.
- Improved the management of digital certificates by creating the dashboard of Tableau.
- Prevented servers from crashing by establishing the alert system for network equipment and servers.
- Collaborated with the infrastructure team to migrate application services from Unix to Linux.
- Being the bridge of communication between network and developer team in the project of BIG-IP LTM (Local Traffic Manager) upgrade.
- Increased 5% of efficiency for AD Sync by removing accounts and groups which don't be used anymore.
- Decreased 10% of spam mails sent from ERP(Enterprise Resource Planning) systems by designing the analysis report with Informatica.
Senior Engineer Synnex Technology International Corporation, Taipei, Taiwan
Nov. 2014 - Oct. 2018
- Advanced the transaction efficiency of EDI systems by 10% by establishing a function for data cleaning.
- Improved the processing time of EDI transactions by 30% by designing the cache for catching parameters in webMethods.
- Collaborated with the developer teams and clients to troubleshoot the connection of EDI systems.
- Reduced the process time of BI (Business Intelligence) modules by 20% in Informatica by resolving the bottleneck.
- Planned the procedure and integrated all the departments in the migration of data center.
Equipment Engineer AU Optronics Corporation, Taoyuan, Taiwan
July 2011 - June 2014
- Maintained the equipment which produces the panel in the photo process.
- Improved the production yield rate of the panel with process engineers.
- Decreased 20% of the time for the analysis of process quality by establishing a VBA(Visual Basic for Applications) tool.
- Avoided the full disk on Unix by coding a cleaning process.
EDUCATION
Bachelor's Degree in Chemistry
Sep 2006 - June 2011
National Central University, Taoyuan, Taiwan
SKILL
Familiar applications
Power BI
Tableau
Informatica
MSSQL
SSMS
SSIS
Oracle
MySQL
H2
Webmethods
Power Automate
Power Apps
Forms
Lists
SharePoint
Serv-U
Weblogic
WildFly
Tomcat
IIS
Sevone
BIG-IP LTM
Programing languages
SQL
DAX
MDX
VBA
Java
JavaScript
PowerShell
HTML
XML
Common skills
communication
Integration
Data analysis
Corporation
