Cathy Hsieh Email & Phone Number

Riverside, California

Anaheim

Provide production troubleshooting support for PeopleSoft FSCM9.2 applications including AR, AP, BI, AM, CA, PO, Cash Management, Project Costing and Lease Administration. Perform root cause analysis to resolve and prevent issue recurrence. Made process improvements and streamlined the interface processes between Hyperion Essbase, PeopleSoft Contract, Billing, Project Costing and Real Estates. Designed and developed user friendly processes starting from the front end data input to the end reconciliation queries. Performed as technical lead to research, cleanup and resolve post-implementation AM defect data by writing complex SQL statements. Resolved issues for Tax books Bonus Depreciation, Mass Change processes and daily open transactions for depreciation calculation. Wrote work instructions for functional users to archive data. Trimmed 95% of Depreciation reporting data to improve overall system performance.Applied PUM patches and fixes to AR, AM, BI, AP modules.Maintained Interface processes between PeopleSoft HCM and FSCM.Performed business analysis and supported the development of dashboard and reports. Create complex queries for new business functional needs in Customer Contract, Billing WorkCenter and Lease Assets. Modified and enhanced PeopleSoft-delivered BI Publisher reports. Developed and uploaded company’s customer contact information to collaborate with PeopleSoft delivered functions for Billing invoices email attachment requirements.Provided process improvements for Cash Management’s Treasury Accounting components.Provided technical support for the PeopleSoft FSCM 9.2 implementation project during UAT stage.Validated and troubleshoot UAT issues for customized codes in Application Engine, PeopleCode and SQR.

Glendale, Ca

Provided 24/7 production troubleshooting support for corporate PeopleSoft Financials Applications including AM, AP, AR, GL.Used IT project management techniques as a team lead and/or team member to implement many projects including PeopleSoft Applications and Tools upgrades, applying application bundles and patches, systems conversion, data cleansing, banks’ electronic files transfers and inbound/outbound interface files processes.Performed fit gap analysis and documented functional requirements. Wrote technical design specifications for PeopleSoft processes developments and customizations.Prepared Test plan, Test scripts and Test scenarios for unit testing, integration testing and user acceptance testing to ensure systems and applications integrity and quality.Fully utilized PeopleSoft Development Tools to convert and/or customize PeopleSoft delivered processes to be streamlined and automated scheduled to run. Proficient in the use of Application Designer, PeopleCode, Application Engine, Component Interface, Integration Broker, Data Mover and Process Scheduler. Designed and developed PeopleSoft Financials data reporting systems using PeopleSoft Reporting Tools like PS Query, XML and BI Publisher, Crystal reports, nVision and SQR.Utilized SQL performance tuning skills to enhance overall PeopleSoft applications performance. Fine-tuned SQL statements to speedup database processes.Established and maintained global PeopleSoft application development standards within IT development teams and provided technical guidance, as well as process expertise, to all developers to ensure projects and support tasks were efficient and in accordance with corporate policies.Developed and maintained the IT SOX general control programs for the PeopleSoft applications to ensure SOX compliance in all processes. Performed as STAT administrator to establish and execute PeopleSoft objects migration process.

Diamond Bar, Ca

Converted and implemented district’s payroll and HR system from mainframe to PeopleSoft. Worked closely with business functional users to set up business configurations.Supported and maintained district’s PeopleSoft applications modules including Financials AP, GL modules and HRMS Payroll/HR/Benefits in technical and functional aspects. Resolved functional users’ daily business process problems and issues.Applied PeopleSoft upgrades and performed system integration tests. Established the process steps for payroll interface to Financials GL. Designed and developed payroll, benefits costs, tax costs data interface to PeopleSoft Financials Project module. Led and supported year-end processing.Customized PeopleSoft delivered processes to meet the district’s special needs and tuned up slow delivered SQL statements to save overall system run time.