Post Job Free

Resume

Sign in

QAD BI SQL

Location:
Menifee, CA
Posted:
March 18, 2021

Contact this candidate

Resume:

PROFILE Summary

Joe Lin

404-***-**** adk0k0@r.postjobfree.com

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

1-949-***-****

Annette Rattigan-

Leo

CEO Deputy Chief Sustainable Development

and Environment Office

Saint Lucia

+1-758-***-****

(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