Enterprise Resource Planning/Manufacturing Execution System Administrator

Berwyn, PA

Name: Albert Wong
Phone: (610) 647-9068
Home Location: US-PA-Berwyn-19312 (US Citizen)

Will Relocate To: US-CA-San Francisco (Citizen)

Most Recent Title: Enterprise Resource Planning/Manufacturing Execution System Administrator
Experience: 34 Years, 5 Months
Most Recent Pay: 93,000 USD per year
Managed Others: Yes (7 others)
Spoken languages:
Sec. Clearance: No
Military Experience: Veteran

Company Information
Start Date: January 2008 ~ End Date: Present
Company Name: Merck & Co
Job Title: Enterprise Resource Planning/Manufacturing Execution System Administrator

Start Date: January 2006 ~ End Date: January 2008
Company Name: WAM Systems, Inc
Job Title: Supply Chain Consultant

Start Date: January 2003 ~ End Date: January 2005
Company Name: Harte-Hanks
Job Title: Programming Manager

Start Date: January 1998 ~ End Date: January 2003
Company Name: SciQuest, Inc
Job Title: Technical Manager

Start Date: January 1996 ~ End Date: January 1998
Company Name: Omnitech Business Solutions
Job Title: Practice Manager, Software Development

Start Date: January 1993 ~ End Date: January 1996
Company Name: SSA MidAtlantic
Job Title: Business Consultant

Start Date: January 1987 ~ End Date: January 1993
Company Name: Digital Equipment Corporation
Job Title: Pharmaceutical and Chemical Sales Support Consultant

Start Date: January 1975 ~ End Date: January 1987
Company Name: BASF
Job Title: Project Leader

School:Rutgers University
Major:Computer Science
Degree:Master’s Degree
Graduation Date:

School:Cornell University
Major:Chemical Engineering
Degree:Bachelor’s Degree
Graduation Date:

Desired Position
Job Type: Full-Time
Desired Pay: 93,000 USD per year
Max Commute: 25 miles
Travel Preference: Up to 50%

Information Technology (25 Years experience)
Internet-E-Comerce (No experience)

617 Cascades Court

Berwyn, PA 19312

Albert T. Wong

(610) 647-9068 (h)

(610) 812-7066 (c)

Project/Technical Management utilizing focused analytical and

troubleshooting skills in a scientific or business Information Technology


Summary of Qualifications

Information Technology management professional with extensive hands-on

project management and consulting experience with a track record of

achievement interfacing with manufacturing, sales, marketing and

engineering professionals. Directed, guided, mentored and trained

cross-functional groups to achieve extraordinary results. Strong set of

management skills including: effective oral and written communications,

insightful problem solving, ability to conceptualize and analyze complex

business processes, and the drive to coordinate and manage work efforts.

Strong technical skills and experience in all aspects of Software

Development Life Cycle including analysis and requirements gathering,

solution architecture and data modeling, programming and testing,

implementation, user acceptance and application support. Successfully

delivered projects in the Pharmaceutical, Chemical and Manufacturing

industries. MS in Computer Science, Rutgers University, BS in Chemical

Engineering, Cornell University. Live in Metro Philadelphia and willing

to relocate for right opportunity.

Professional Competencies

Oracle Database Administration Rational Rose XDE Microsoft Office

SQL / PL / SQL Visual Basic Microsoft Project

Microsoft SQL Server Crystal Reports Microsoft Visio

ETL Data Conversion and migration QlikTech Erwin Data Modeler

Database Design Visual Studio.Net Quest SQL Navigator

Selected Achievements

• Managing a 7-person software development department, and serving

also as business/application analyst and database modeler/designer.

Created BMW’s innovative car sticker design software. Authored

Functional and Technical Specifications and directed programming and

testing. The result was the $650K project was delivered on time and

on budget. The software is producing BMW’s car stickers today.

• Coached junior Technical Managers working on PL/SQL procedure used

to load chemical properties in substance database that was not

working correctly. Structured and organized flow for 3 modes,

initial loading, maintenance and special updates. The result was a

working procedure that was more organized and readable for easier


• Charged with rebuilding the process control software for Polyol

chemical plant following devastating explosion. Designed and

programmed process control software to be table driven and not hard

coded for easier maintenance. The software was so successful that it

was re-sold to an engineering consulting company.

• Designed and created software to maintain pricing, premix recipes

and to calculate costs for a new division needing computer

capabilities to allow bidding for business against entrenched

industry leader. Software interfaced with plant process control

equipment to reduce errors in manufacturing which resulted in their

ability to gain market share.

• Successfully managed completion of major pharmaceutical company’s

systems implementation as their Technical Manager. Spearheaded the

efforts to better specify the requirements and rewrote the SQL and

PL/SQL procedures under tight time constraint. Reports became

standard components of the software.

Albert T. Wong … Page 2

Professional Experience

Merck & Co., West Point, PA 2008-Present

$24 Billion global pharmaceutical and research company.

Enterprise Resource Planning/Manufacturing Execution System Administrator


• Administrator of Honeywell POMS/JD Edwards One World ERP/MES custom

application for Merck’s Global Clinical Supply Operations (GCSO) to

support clinical trials. System operates in a Federal Drug

Administration (FDA) regulated environment. System runs on Oracle

10g Database.

• Coordinate End Users and IT to prioritize and track implementation

of bug fixes and enhancement requests in a FDA regulated

environment. Ensure all documentation and sign-offs meet cGMP and

internal SOP requirements.

• Use Oracle SQL to ensure POMS-JDE interface is working correctly.

Use SQL queries to investigate User reported bugs to provide initial

analysis to IT organization.

WAM Systems, inc, Plymouth Meeting, PA 2006-2008

$10 Million supply chain software & consulting services focused on

chemical and process industry companies.

Supply Chain Consultant

• Project managed implementations including software configuration,

migration and loading of SQL Server 2000/2005 databases, integration

with SAP ERP systems, development and customization of SQL

procedures. Created and maintained Decision Support and Dashboards

using Crystal Reports and QlikTech. Drive improvements in software

documentation, change control and upgrade procedures.

• Implemented projects at PetroChina, Degussa, Kraton, Oxea with

PetroChina representing a major expansion into Asian/Pacific market.

Provided technical support in winning $1.9 Million Ergon project

which is largest single WAM project to date.

Consulting 2003-2005

• Transcontinental Direct – Project managed migration of mainframe

based insurance focused software including Functional Requirements,

Oracle data models, User Acceptance Testing. Designed and

implemented Oracle Data Model for subscription based marketing

database. Drive use of analytical techniques and project artifacts

like functional specifications, technical design documents, project

schedules, and test plans. Instill Software Development Life Cycle

discipline in team.

• Harte-Hanks – Project managed 5 programmers. Gathered fulfillment

requirements for pharmaceutical direct marketing campaigns. Created

Functional and Technical specifications. Conducted code reviews.

Wrote and tested custom Oracle PL/SQL procedures and functions.

• Electronic Ink – Gathered Functional Requirements for Penn state

government Rehabilitation Program Administration functions.

Documented legacy mainframe system. Wrote Functional Specifications

• Janssen Pharmaceuticals – Participated in Six Sigma Process

Improvement initiatives for Physician Relationship Management

function. Performed data scrubbing, data loading, data modeling and

analysis. Calculated and graphed error correlations. Wrote ad hoc

query analysis SQL and PL/SQL.

SciQuest, Inc, Newtown Square, PA 1998-2003

$8 Million software and services focused on pharmaceutical drug discovery


Technical Manager

• Project Management responsibility for technical implementation of

Pharmaceutical focused software including Oracle ETL data migration,

application configuration, installation and testing.

• Designed, implemented Data Model additions for integration with

Legacy systems.

• Wrote, tested and implemented custom Oracle SQL procedures,

functions, triggers and packages. Modules include plate fulfillment

calculations, reagent purchasing performance statistics, integration

with waste management systems.

Omnitech Business Solutions, Englewood, NJ 1996-1998

$10 Million computer hardware, software and networking services company

serving small and large companies.

Practice Manager, Software Development

• Managed 7 person software development team with C++, Visual Basic

and Oracle Database skill sets.

• Served as Business Analyst defining requirements and served as

Oracle Data Architect defining data model to support our custom

solution. Wrote SQL procedures for application.

• Responsible for implementing $650K SDLC projects.

SSA MidAtlantic, Rochelle Park, NJ 1993-1996

$15 Million Enterprise Resource Planning software and services company

serving small and medium size manufacturing companies.

Business Consultant

• Responsible for $180K in annual consulting fees for application

configuration, customization, installation and training.

• Conducted training classes in BPCS Planning, Forecasting, and Shop

Floor Control modules.

Digital Equipment Corporation, Parsippany, NJ 1987-1993

$14 Billion global computer hardware, software and services company.

Pharmaceutical and Chemical Sales Support Consultant

Computer Integrated Manufacturing (CIM) Consultant

• Supported specific sales accounts resulting in account team meeting

$4.2M goal.

• Provided support for MRP-II, Integrated Manufacturing Execution

Systems, Laboratory Information Systems (LIMS), Warehousing and

Logistics Systems.

BASF Wyandotte, Parsippany, NJ 1975-1987

$2 Billion US subsidiary of BASF, a global $38 Billion chemical company.

Project Leader, Scientific Systems

• Managed implementation of scientific, manufacturing and engineering

IT projects.

• Used programming, analysis, project management skills to deliver

Plant Maintenance/Stores, Vitamin Premix, LIMS, QA, Process Control,

Data Acquisition projects.


MS, Computer Science, Rutgers University New Brunswick, NJ

BS, Chemical Engineering, Cornell University Ithaca, NY


  • Updated 2 years ago

To contact this candidate email

Contact using webmail: Gmail / AOL / Yahoo / Outlook

This entry was posted in . Bookmark the permalink.