QAD BI SQL
Resume:
PROFILE Summary
Joe Lin
404-***-**** *******@*****.***
Hard-working and dependable IT professional with 15 years experiences in IT system implementation, support and business workflow analysis.
7 years IT project experience within depth PMP certified, proven ability to deliver high quality IT products and services on schedule and within budget.
10 years Business process improvement & Intelligent report architecture experiences. Adept at contributing to team effort in all aspects of the system life cycle.
Excellent analytical and problem-solving / conflict-solving skills with proven ability to hit the ground running. Executive Summary:
14.5 Years - IT department
4 Years - Marketing/Sales - International Trading
Management experiences
- 11 Years ITS Department Leader, 8 Years Project Manager
- Handle Multi-Country Team Members in Project
- Handle e-Government’s Project: 5 million / per year and driving 3 years License: PMP Certificate (2006-2013)
PMP #: 432467
KEY Experiences
EDI & SCM - SCM & EDI system implement project (SAP - QAD)
- Government e-System Upgrade
DMV/Civil record / Criminal record / Hospital & insurance record BI/DW & Data center Architect
- Government ICT data center infrastructure deployment
- BI & DW system: financial consolidation project
- Integrated Progress DB/ Oracle DB/SQL DB/SAP/Hyperion Work Flow Experience - e-Flow & Business Process Reengineering system implement project
Working Experience (Most Recent 15 years)
The Pasco Scientific.
Senior Business Systems Analyst Oct/28/2019 to present 1. Work with both technical and nontechnical stakeholders in gathering and documenting requirements to build business cases
2. Technical support in developing systems that meet requirements included ERP system and B2C system interface process.
3. EDI configuration in QAD (WebService) & CRM(SQL DB) and Credit card (authorize.net) system. 4. Establishes project portfolio management road maps for driving the implementation and ongoing maturity of IT's project governance.
The Magna Corp.
System Architect & QAD Developer Sep/28/2015 to Jul/12/2019 1. EDI configuration in QAD & Solidat, Updating and upgrade patch of EAM & QAD 2. Implement and Design data warehouse drill down application via Cyber Query and Power BI. 3. Critique and improve accuracy and flow of technical documentation through interaction with manufacturing, engineering and R&D associates.
4. Implement CEBOS system for QC and Engineering Department. 5. Be a Project Manager of upgrade QAD 2011SE to 2014EE. The Hamida Pharma Inc.(Lake Forest, CA)
IT Project Manager Mar/01/2012 to Aug/30/2015
Managed intranet work including: E-commerce services and training, e-learning services
Hands on experience in all aspects of building a user interactive, secure, e-commerce website utilizing Java applets, HTML and Java script programming.
E-commerce market : North Europe, North Africa, Asia
Applies knowledge and skills to a wide range of standard and non-standard situations.
Translates user needs into clinical product requirements
Provided leadership in the implementation and support of factory automation, data management and shop floor systems.
EDI configuration in QAD & E-commerce, Updating and upgrade patch of QAD . The OPTOPLEX Corporation.( Fremont, CA)
IT Project Manager AUG/01/2011 to Feb/29/2012
Work with key business stakeholders and PMO leaders to define a delivery strategy and roadmaps
Planned and developed methods and procedures for implementing program.
Reviewed, evaluated, and approved specifications for ERP system supplier.
Work with internal constituents to understand business requirements and goals, and help EPIC ERP system capture the strategy roadmap.
The JMART Department Store Group Enterprise (Taipei, Taiwan) CIO Nov/15/2010 to APR/30/2011
Determined boundaries and priorities of new POS system and discussed system capacity and equipment acquisitions.
Planned and developed methods and procedures for BI program
Business Discovery
Analyzed data processing requirements to plan data processing system that will provide capabilities required for projected workloads.
Conferred with data processing and project managers to obtain information on the limitations of existing system.
Data Warehouse Logical and Data Modeling
ETL Structure process define
Hardware networking / backup/ recovery deployment.
Financial validation.
Accounting code control rule validation.
Financial process improvement.
The HYWEB Technology Co., LTD(Caribbean Area)
Senior Program Manager Jun/01/2007 to Nov/30/2010
Responsible for the Government IT software and hardware improvement
Preparing RFP/RFQ for Government department tender issue
Budget Issues. 5 millions / per year and driving 3 years
5 to 7 Projects per years, Have to finish and delivering object in 7 month from Initial to close phase.
Supervised planning and execution of the program
Control Project schedule process, Resolving conflict.
ICT center Technical support including (Level 2 & Level3 )
Work with key business stakeholders to define a delivery strategy and roadmaps
Managed a 55 person’s team performing ICT center implementation.
Successfully handled e-Government system:
Saint Lucia:
ICT data center deploy infrastructure deployment.
e-Gov System Implementation
DMV system
Criminal information System
Agriculture Resource System
Civil Status Registry System
Saint Kitts:
ICT center infrastructure Build up
e-Gov System Implementation:
e-Mail System
Country Root DNS(Domain Name service) build up
Government Web Portal
Hospital of Government system
Saint Vincent:
The Criminal information system
Belize:
ICT center building construction and infrastructure deploy.
e-Gov System Implementation:
Government Web Portal
Database System of Supply Control Unit
Archives Information Management System
Database System of Investment Unit
TECHNICAL PORTFOLIO
Methodologies Project Management Body of Knowledge PMI member.
Software Engineering Management
Data Mining
Progress SQL Designer
Platforms Unix
Microsoft Windows
Linux, Novel Suse
Novell Netware
Databases Microsoft SQL Server 2003up
Sybase ASE
Oracle Database
Progress
DB2
ERP QAD / SAP / Axapta / Hyperion
Production Planning (PP)
Sales Distribution (SD)
Finance & Accounting (FA)
EAI & BPM Brog Business E-Flow
CorVu Business Intelligence Ware
Crystal Reports(Microsoft & SAP)
SQL Server Reporting Services
Programming Languages Object Pascal (Using Borland Delphi) Unix & Mainframe COBOL
Unix Shell
Microsoft WinScript
Microsoft SQL
Visual Foxpro
Sybase Power Builder
Progress 4GL
Technologies Database Mining & deployment
Process Clustering Design
Network Security Design
Business Process Improve
Education
Education: Chung Yuan Christian University.
Taipei, Taiwan
Bachelor of Industry Engineering
Languages: English, Chinese
References
Name Title Company Contact Info.
Natasha Hamida CFO The Hamida Pharma LTD
Annette Rattigan-
Leo
CEO Deputy Chief Sustainable Development
and Environment Office
Saint Lucia
(Saint Lucia)
PO-Hsiu Cheng
CEO The Optoplex Corporation +886*********
(Taiwan)
Tony Chen IT Manager The KHS Company +886**-******** EXT 7311(Taiwan)
Contact this candidate