Gary Sim Email & Phone Number

Singapore

Singapore

1) Data Analytic (Data Warehousing, Alteryx and Tableau reports) ● Conduct exploratory data analysis (EDA) on Manufacturing Production Lines. ● Collaborate with cross-functional teams to develop KPI dashboard and Machine Performance metrics ● Perform trending and reporting of Quality Control data ● Understand and analyze manufacturing data to generate reports. ● Responsibilities include defining problems, collecting data, establishing facts. ● Develop and tutor Peers. ● Develop Alteryx Workflow. ● Develop Report using Tableau Reporting. 2) DOQ MES System ● Subject Matter Expert (SME) for DOQ MES system. ● Design and Develop Project Documentation (URS, IQ, OQ, PQ) – Project Phrase. ● Maintained system documentation and update training materials 3) Siemens MES System ● Subject Matter Expert (SME) for Siemens MES system. ● Design and Develop Project Documentation (URS, FS, DS, IQ, OQ, PQ) – Project Phrase.

Singapore

1) SME MES – Weigh and Dispense (PASX)• Standardisation of Master Batch Record with Global Team• Working with production to resolve issues / requests• Interface with SAP system2) SME for Track and Trace System – Pharmaceutical Serialization (SYSTECH)● China Market – Carton, Bundle and Case aggregation.● Korean Market – Carton aggregation only.3) SME for Maximo System● Implementation of Mobility Module.● Working with Operations to resolve issues / requests.4) SME JDE Enterprise Resource Planner (One World) (Retired)● Working on the Distribution, Manufacturing and Finance Module.● 2nd level support on ERP System● Manage change request, user test script and training● Provide JDE solution to Business UserAccomplishments  Implement budget USD $5 million Serialization Track and Trace System as IT Lead Implement budget USD $2 Million PASX Manufacturing Execution System as a Project Manager Work as a Project Manager to implement GxP System using V-Model Methodologies.AccountabilitiesØ Develop and enhance relationships with key stakeholders, actively manage their expectations & monitor satisfaction levels.Ø Act as the primary connection between service delivery and the business.Ø Ensure business end-user requirements for regarding IT services are documented through Service Level Agreements (SLAs) and these SLA are met.Ø Highlight/identify gaps in existing functionality and review requirements with stakeholders.Ø Develop a comprehensive requirement specification including stake holder involvement that will determine the estimate of cost, time and resources to deploy solutions.Ø Establish project plan and initiate project mobilization by confirming project scope, estimate, resources, roles and responsibilities.Ø Monitor and control execution of project though Analyze, Design, Build, Test and Release.Ø Deliver IT Services, systems and applications to the business - Ensure adherence to quality standards as defined by the IT Organization.

1) JDE Enterprise Resource Planner (One World)Support Distribution (Sales Order, Purchase Order, Inventory), Manufacturing (Work Order, Bill-Of-Material) and Finance (AR, AP, GL) Module.Conduct training to users on the JDE softwareAbility to convert new business process into the system.Provide and conduct UAT testingCreate reports for the users. 2) AS400 ServerSQL Query3) Loftware Labelling SoftwareInvolving in Implementation and Maintenance stage of LoftwareDesign Label for Globally Harmonized System(GHS) StandardSupport from JDE to Loftware Print Server.Conduct Training to users.4) Laboratory Information Management System (WinLims)Involving in Implementation and Maintenance stage of WinlimsManage the data flow from JDE to Winlims Server.Conduct Training to users.Accomplishments Involvement in the Analysis, Design, Implementation and Maintenance phase to successfully implement JDE in MalaysiaInvolvement in the Implementation and Maintenance phrase to successfully roll out Full Product CostingInvolvement in the full SDLC cycle to roll out Online Approval Routing in JDE. Chairman of Recreational Activities year 2008 - 2010.

1) JDE Enterprise Resource Planner (Enterprise One)Support Distribution (Sales Order, Purchase Order and Inventory) and Finance (AR. AP, GL and Fixed Assets) Module.Conduct training to users on the JDE softwareEnsure users daily transaction is completed successfully.Determine the result that was reported by customers.Carry out application testing and solution and documenting functional specification.2) Datawarehouse (Microsoft SQL)Generate excel reports for the management.Ensure data integrity3) AS400 ServerBackup/Restore JDE data to the AS400 server.SQL QueryAccomplishments Base currency change from SGD to USDAsia price change

1) Navision Enterprise Resource Planner (ERP)Working with Vendor to fine-tune the ERP softwareControlling the access rights of different usersConduct training to users on how to use the ERP softwareProvide audit trails to the usersMaintaining the databaseBackup/Restore the data2) QlikviewCreate Qlikview reportingMeeting with each department to find out the departmental requirement for the reportConduct training to individual user on using the Qlikview 3) ServerManaging 2 server with windows server 2003Creating user account with active directoryCreating email account using Microsoft exchangeManaging database of the Enterprise Resource Planner Managing the intranet WebPages4) SupportProvide technical support to end user.Liaise with IT vendorsMaintaining the serversMaintaining MS Exchange 2003Maintaining MS SQL 2000Maintaining Intranet (VB.NET)

Diploma In Sap, It

Diploma in ERP System (SAP)

Bachelor, Information Technology; System Development And Business System

Diploma, Information Technology (Computer Studies); E; Commence And Multimedia