Van Lam Email & Phone Number

New York, Ny, Us

- Infor Process Automation - Infor Configuration Console- Infor Landmark Security- Lawson Security- Lawson 4GL

Vienna, Us

- Led Lawson security LS9 upgrade project from start to finish. - Created project plan and work with end users to build the Business Design. - Built and maintained Lawson security classes and roles including writing rules.- Created and maintained Lawson EMSS user profiles. - Developed SQL stored procedures, UNIX shell scripts, Windows scripts to meet the business requirements.- Modified Lawson delivered programs to enhance and/or to add additional functionality as specified by users.- Provided day-to-day technical support to Finance users for the LBI reporting system.- Managed database to support LBI reporting system.- Participated in Infor Lawson 10 upgrade project.- Experienced with Landmark File Channels and Landmark User Management.- Experience with Infor Process Automation (IPA).- Used scripting technique, Lawson tokendef and recdef to automate jobs.- Awarded: Unsung Hero Award: for outstanding technical contributions, 2015

Falls Church, Virginia, Us

- Led the HL7 Lawson-EPIC (a patient clinical information system) Item Master interface project.- Led the implementation of new ATS (Applicant Tracking System) project.- Designed custom programs to parse the XML file receive from ATS and load into Lawson Database.- Collected business requirements and translate into technical design. - Converted and loaded non-Lawson data into Lawson conversion tables.- Developed custom forms, batch programs, reports, process flow, and interfaces.- Provided day-to-day technical support for the Lawson S3 ERP modules including EMSS portal pages and the process flows that support it.- Experience in customizing Lawson Portal bookmark.- Applied application patches (CTP) to address production issues.- Lawson Environment Utilities experience.- Working knowledge of Kronos Time Entry system and Healthcare Scheduling system.- Participated in a 24x7 on-call support rotation.- Awarded: IT Ace Award for excellent work on the Lawson-Epic Item Master Interface, 2012

- Responsible for Lawson application upgrade from 8.1 to 9.0.1 on LSF9 environment including inbound/outbound interfaces, customized programs and reports within Lawson HR/Payroll, Financials, and Supply Chain suites.- Created user exists and modified Lawson delivered programs to enhance and/or to add additional functionality as specified by users.- Performed Unit Test and provide UAT and go-live support.- Awarded: Certificate of Appreciation: In honor of outstanding performance and dedication in support of the Lawson 9.0.1 Upgrade, 2009.

• Developed interfaces to and from Lawson coding PL/SQL and MF COBOL.• Created Lawson Web Time Entry (ESS) interface to Lawson Payroll.• Created/maintenance ANSI834 interfaces between Lawson and external system.• Created custom tables, indexes, and system keys for drop down/drill around on custom forms.• Coded form rules used by custom online programs in system-code.sr file, run srgen to compile the rules.• Created a process to automatically update the pre-tax and post-tax yearly amounts for new employees enrolled their domestic partner in health and dental insurance.• Worked directly with Business Analysts and end users to analyze business requirements and to assist them in planning user acceptance testing.• Created technical specifications, change control documentation, production support documentation, work status/activity tracking, test scenarios and test data.• Modified Lawson delivered programs to enhance and to add additional functionality to Lawson HR/Payroll/Benefits suite as specified by users.• Participated in Lawson application upgrade projects.• Performed Lawson administration tasks (dbdef, blddbdict, dbreorg, pgmload, startladb, startladebug, laua, etc.). Reloaded and recompiled product lines, created and scheduled Lawson jobs (jobdef, tokendef, recdef), verified jobs waiting in Lawson job queue (jobschd), viewed log files (ladb, latm, lajs, lase, ios, etc.) to detect any database and/or system problems.• Participated in the yearly Open Enrollment project including developing and modifying custom interfaces, auto enrollment process, EOI process, and much more. • Working knowledge of Lawson standard Payroll procedure, new hire/termination process, and personnel action.• Applied application patches (CTPs)• Used scripting techniques (UNIX and SQL) to automate jobs.• Working knowledge of Oracle stored procedures, triggers, and views.