A seasoned Software Engineer/Programmer/System Analyst with 25+ years of experience in various programming platforms including MS SQL Server, T-SQL, SSRS, Red Gate, Git, Agile, VB.NET, Linux, Azure, Docker, REACT, Angular, AS400 (IBM iSeries) RPG/ILE, CL, and SQL Embedded RPG.
Experience
2020 — Now
2020 — Now
United States
A warehouse material handling equipment (Conveyor Belt) and services provider.
• Develop and implement software descriptions and database layouts using the Visual Basic.NET and MS SQL Server for initial internal review and subsequent customer approval.
• Develop and perform in the tests of system rates.
• Develop and implement in the interfaces to controls department.
• Develop and implement PC Code programs and prepares documentation based on project design specifications.
• Develop and perform Internal testing with controls engineering on system integration details.
• Field start-up on PC-controlled projects; support controls engineering on start-ups.
• Maintain up-to-date files of all relevant paperwork on projects.
• Consult with controls engineers and project managers to ensure proper coordination and adherence to schedules in mechanical installation, electrical installation and field start-up.
• Attend to service calls when required.
2015 — 2020
2015 — 2020
Livingston, NJ
A large integrated manufacturer of plastic resins and petrochemicals.
• Used WebSmart (PML), PDM, CL, SQL, and RPG IV/ILE on the IBM AS/400 (iSeries) to investigate issues, design new applications, and maintain the existing ones.
• Managed and owned the database in the HR/Payroll/Benefits area and created new ones as required by the projects.
• Lead and created the Healthcare Savings Account (The HSA Plan) System from scratch.
• Lead and created an In-House ACA System that allows the employees to print their own 1095-C Form from a web-based Employee Self Service System, and allows the HR to file the 1094-C and 1095-C electronically.
• Dissected the Payroll System and created a full technical spec including the flow charts.
• Worked closely with the business analyst in researching and implementing the statutory compliance changes. This includes design, construct, coding, conduct QA testing, presenting demo, implementation, and documentation. The specific applications in charge are Human Resource, Time Clock, Payroll, and Benefits.
• Worked closely with the users in processing the Time Clock Reports, and Payroll Reports during each payroll run. As well as the W-2, 401(k), FSA, HSA, annual Open Enrollment, and quarterly reports processing. Resolve any issues they might have.
• Communicated with vendors to set up file exchange protocol using FTP/SFTP standards.
• Provided ad-hoc reports as requested by the HR or Payroll Team for analytical purpose.
• Created interface files and post to the G/L and AP Systems.
• Coordinated and collaborated with others in analyzing collected requirements to ensure plans and identified solutions meet customer needs and expectations.
• Established and maintained security, integrity, and business continuity controls and documents.
• Participated in special studies, marketing efforts and formal proposals. Stayed current on emerging tools, techniques, and technologies.
2012 — 2015
The world's pre-eminent distributor of beverage alcohol.
• Resolved the ticketed issues created by the users.
• Communicated with users to obtain detailed specs, design, and proposed solutions prior to actual coding. After the coding is completed, conducted QA testing, implemented to Production, and documented the projects.
• The specific applications I was involved while utilizing the WMS/Supply Chain/Financial systems include Sales, Inventory, Shipping, and Accounting.
• Most of the programs were coded in RPG IV with embedded SQL.
• Monitored the systems and provided help desk services (On-call duty).
• Participated in disaster recovery.
• Created a document to illustrate the flow of an order coming in from TOPAZ (A third-party order entry PC software), processed, and backup to the sales history. This is helpful for finding the reason(s) why the order(s) did not ship or partially shipped.
2008 — 2012
2008 — 2012
A leading supplier of respiratory-therapy products and services.
• Worked with team leader to obtain detailed specs, design, and proposed solutions prior to actual coding.
• Worked closely with the QA Team after the coding is completed. Fixed additional issues if any before implementing to Production.
• Specific Systems/Applications worked on the most: AP, AR, Customer Service, and Sales Tracking Systems. Most of the developments were done within AS/400 using RPG IV.
2001 — 2006
Allendale, NJ
A photographic chemicals and ink manufacturer.
• Communicated with users to obtain detailed specs, design, and proposed solutions prior to actual coding. After the coding is completed, conduct QA testing, implemented to Production, and documented the projects.
• Administered the Systems on the IBM AS400 machine, which is consisted of monitoring, backup, security control, OS installation/upgrade, IPL, disaster recovery, and hardware maintenance.
• Maintained and managed the existing database in all area and created new ones as required.
• Participated in disaster recovery.
• Specific Systems/Applications worked on the most: Sales Order, EDI (EXTOL), AP, AR, General Ledger, Inventory, and Formulary Systems. Most of the development is done within AS/400 using JDEdwards World A7.3, CL, and RPGIII.
Education
Penn State Great Valley
Bachelor of Science (BSc)
Ithaca High