Enterprise Resource Planning/Manufacturing Execution System Administrator
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)
Sec. Clearance: No
Military Experience: Veteran
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
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.
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
• 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
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
• 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.
• 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
• 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
• 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.
• 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
• Provided support for MRP-II, Integrated Manufacturing Execution
Systems, Laboratory Information Systems (LIMS), Warehousing and
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
• 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