吳宗錡
Combining the education in Linguistics and Supply Chain Management (MS) with previous experience in Data Analyst and System Integration Engineer, I can offer diverse skill sets in different areas. My educational and work experience also enable me to acquire knowledge and skills, and to provide quick and precise analyst in different fields. Furthermore, I’m experienced in Python, Java, SQL, Tableau and Adaptive Insights.
結合語言學和供應鏈管理的學位，與商業分析師、資料分析師的工作經驗，能夠提供多元的知識和技能；多元的教育和工作經驗，快速的學習和適應不同類型的專案和任務。除了需求預測、銷售分析、設計統計模型外，也有Python、SQL、Tableau、SAP, MS Excel, Adaptive Insight, NetSuite 等程式語言和商用軟體能力。
Data Analyst
Tainan, Taiwan
0975-191-889
技能
Python
Data Visualization
MySQL
Adaptive Insight
工作經歷
Active Cyber, Dallas, Texas 2019/4 - 2019/11
Systems Integration Engineer
. Integrating enterprise data from 2 NetSuite ERP system to Adaptive Insight system, using API connecter,
Pentaho, and JavaScript based CCDS ( Customized Cloud Data Source .
. Processing and cleaning customer's financial data from Intacct, SalesForce, NetSuite and Oracle, utilizing
complex SQL queries and table joins.
. Integrating financial and sales data from 2 Intacct system to Adaptive Insight system.
. Investigating integration failures with 3 NetSuite project and restoring the full connection.
. Managing time usage and status updates for 15+ integration projects, using SmartSheet and Projector.
. Designing and implementing sales planning model, including sales reps, capacity, top-down cost and
commission calculations.
. Developing visualization reports and analytical reports for 4 demand planning projects.
Falcon Farms, Coppell, Texas 2018/12 - 2019/2
Data Analyst
. Collected and processed sales and inventory data for 20 vendor routes and 200 Walgreen stores
. Collaborated data from ERP and EDI to perform cross validation and analysis with Spreadsheet and Tableau
. Analyzed data from 3 ERP platforms to create Tableau and Python reports to support daily operations,
including ordering, production and shipping
. Forecasted demands and trends to determine weekly shipment and production for over 200 Walgreen stores
. Visualized and exanimated historical data from Miami headquarter to validate the similarity of markets
behaviors to build statistic model for DFW area.
. Programed 2 tailor-made python applications for data querying and for demand forecasting
Alloy Tool Steel Inc
Business System Analyst 2018/8 - 2018/12
. Developed vendor evaluation process by creating the Python routine program to monitor on-time delivery rate
and chemical composition report for 14 suppliers
. Forecasted demand for MRP purchase orders by implementing 12 machine learning models, including
Logistic Regression, Support Vector Machines, Naive Bays and Random Forest Classifier
. Maintained inventory accuracy by amending logical errors in the ERP system
. Coordinated with 2 suppliers for POs and with brokers for incoming containers
National Cheng Kung University 2013/9 - 2015/6
English Tutor
. Tutored over 10 students in preparation for English tests such as the GSAT and IELTS, resulting in a 2-3 ( out
of 15 ) rank improvement for GSAT, and 1.5 to 2 rank improvement on the IELTS.
學歷
The University of Texas at Dallas (德州大學達拉斯分校)
M.S. in Supply Chain Management e
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam porttitor dapibus ipsum ut efficitur. Aliquam feugiat nec sem dapibus blandit.
National Cheng Kung University, B.A Foreign Languages and Literature Spanish GPA, 2015
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam porttitor dapibus ipsum ut efficitur. Aliquam feugiat nec sem dapibus blandit.
社團活動
APICS Student Membership
ISM Industry Mentor Program, UTD
ADDITIONAL INFORMATION
Technical Skills: Python, SQL, MySQL, Java, JavaScript, Tableau, Adaptive Insight, SAS Enterprise, Advanced MS Excel, VBA(Macro), MS Access, MS Project, Lean Six Sigma, KNIME
Languages: Native Mandarin and Taiwanese, Fluent English, Intermediate Spanish Certificates: Certified in Transportation and Logistics (CTL)
