Kathy Zhou

Successfully contributed to the recent LabVantage 8.8 upgrade; Configure and develop solutions within LabVantage and Optiva applications, test and verify completed configuration and development meet specifications.

Troubleshooting

LabVantage issues with existing processes and programs, working with Lab Manager to resolve different JIRA items, test and migrate fixes to Production environment. Creating technical process flows and requirements documentation (Work Ticket) that may be assigned to other development team members for execution. Creating, debugging and maintaining Jaspersoft report (6.21), crystal report (2016), and BarTender label and print.

Extensive experience in writing Transact-SQL statements, stored procedures, scripts, and views (samples, nutrition, formula, analysis etc).

LIMS Developer Analyst at Hormel Foods Corporate Services, LLC (2022-09 – Present)

Successfully contributed to the recent LabVantage 8.8 upgrade; Configure and develop solutions within LabVantage and Optiva applications, test and verify completed configuration and development meet specifications.

Troubleshooting

LabVantage issues with existing processes and programs, working with Lab Manager to resolve different JIRA items, test and migrate fixes to Production environment. Creating technical process flows and requirements documentation (Work Ticket) that may be assigned to other development team members for execution. Creating, debugging and maintaining Jaspersoft report (6.21), crystal report (2016), and BarTender label and print. Extensive experience in writing Transact-SQL statements, stored procedures, scripts, and views (samples, nutrition, formula, analysis etc).

QA Studio Programmer Analyst at Dairy.com (2015-06 – 2020-05)

QA Studio is a Lab Information Management System (LIMS) built to help reduce operational costs, manage and monitor quality throughout the manufacturing process. Successfully converted and upgraded QA Studio GUI application, including Module Raw, Fluid, Culture, and Ice Cream; Added new Custom View feature to the browser for all the modules to create and configure the custom views and reports; Re-designed and developed a new custom report printing tool which has abilities to customize the Certificate of Analysis (COA) and sales report to facilitate DFA audits, received positive feedbacks from clients. Coordinating with the front-end GUI requirements to write functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically.

LIMS Analyst Programmer at Computer Science Corp. – LIMS team (2014-06 – 2015-06)

Maintain & Support Sample Manager (SM2010, SM2004 & SM2003) and Integration Manager for DuPont Laboratory Information Management System (LIMS) on multiple servers. Complete daily assigned PQRs for user application issues, monitor system alerts, and troubleshoot problems. Perform weekly MS patching and system failover.

Regularly review, unit test and validate deliverables including master data, upgrades, and new functionality. Provide VGL code enforcements and break fixes for SampleManager; Proficient at creating custom reports and optimizing the existing ones for LIMS based on clients' requirements.

Senior Application Developer at Computer Science Corp (Dupont Performance Coatings) (2000-05 – 2014-06)

Member of the R&D development and support team; Worked directly with the DuPont clients; Delivered significant contributions to the development and support of Batch Card, TIPS-Rm, TIPS-Rx, Sourcing, Sample Weathering, and Testing GUI applications; Efficiently resolved clients' daily issues/problems to maintain user's satisfaction; Great experience in large scale and full life cycle software development.

• Use GUI tool (Omnis Studio) to design and maintain DuPont Performance Coatings applications.
• Analyze clients' requirements and write design specifications. Complete technical documentation and user test plans for new and existing applications.
• Daily customer support (US & Europe) and technical consulting, complete Block Release, delivered high-quality work products and ensured client satisfaction.

Programmer/Analyst at Professional Software System Corp (1997-10 – 2000-04)

PSS is a developer and manager of databases for clients in the advertising industry.

• Analyze client's application requirements to design, code, and test Job Management Systems (JMS), and Media Account Systems (FMS) using Omnis 7 GUI tool.
• Design and convert existing media applications to web-based systems using Java, HTML, and Oracle database.

Programmer/Analyst at Taconic Data Corporation (1996-10 – 1997-09)

TDC builds and manages large public records and professional reference libraries for statewide and regional Multiple Listing Services, providing more standardized and integrated data to real estate and related industries.

• Analyze Oracle database construction, data model development, Oracle tuning, optimization & performance.
• Well-developed skill in writing Oracle SQL and PL/SQL on a UNIX server for creating and loading tables in Oracle database from scratch.

Project Assistant (part-time) at OneLink Transit Systems Pty Ltd. (1994-02 – 1996-07)

OneLink is the Project Manager of Automatic Ticketing System being designed, built, installed, and commissioned for the city of Melbourne Australia.

• Maintain the Contractual Variations and Issues Database
• Analyze AT Project Progress against schedule baseline, writing monthly reports for Automatic Ticket System.

MS in Business Information Technology – Swinburne University

BS in Material Sciences – Shanghai University of Science and Technology