Ernest Yee Email & Phone Number

Sacramento, California Area

Innovo Consulting is a Sacramento-based company that delivers end-to-end solutions for complex IT projects. Our team has expertise in Business Analysis, Technical Architecture, Software Development Life Cycle, and Project Management.

Sacramento, California

thinkAhead, Inc is a professional services company providing technical sales and recruitment support to organizations..

Sacramento, California, United States

• Responsible for providing PeopleSoft onboarding guidance for Fi$Cal 2019 PeopleSoft Release - California PeopleSoft Financials 9.2 installation (Fi$Cal). Project successfully deployed 9/2019
• Significantly contributed to getting department to fully close period 1. (subsystem module close and allocations)
• Subsystem module close through current period
• Identified Accounts Payable errant voucher entries causing reconciliation imbalances
• Identified Office Revolving Fund (ORF) advance types that were created incorrectly causing reconciliation imbalancesProcurement
• Provided guidance on updating Year End procedures in Fi$Cal to accommodate for client’s continuous appropriation encumbrances

Sacramento, California Area

• Responsible for providing PeopleSoft guidance to conversion, configuration, and business process activities for 2018 Release - California PeopleSoft Financials 9.2 installation (Fi$Cal).Project successfully deployed.
• Significantly contributed to getting department to fully close period 1. (subsystem module close, labor, allocations, PFA, GL reconciliation). One of the first 2018 departments to accomplish this.
• Subsystem module close through period 3.Accounts Receivable
• Worked through new SCO Deposit Slip / Automatic Remittance functionality. (Resolved issues due to non-remitted monies, transition week corrections due to uncleared collections account change, pre and post Deposit Slip.
• Developed business processes for Advanced Collections (Direct Journal to Unearned Revenue, Receivable creation for Unpaid receivables in new fiscal year, $0 Deposit to move monies from Unearned to Earned.
• Developed business processes for Dishonored Check handling (AP Buyback Voucher, AP SCO Refund Voucher, AR Dishonored Check Receivable, AR Cashiering Direct Journal of SCO Warrant)

Sacramento, California Area

• Responsible for providing PeopleSoft guidance to conversion, configuration, and business processes for 2016 Release - California PeopleSoft Financials 9.1 installation (Fi$Cal). Assisted in upgrade and transition.
• Led discussions to identify department specific changes and impacts for PeopleSoft modules and workflows
• Mapped existing CALSTARS business processes to new PeopleSoft functionality
• Provided guidance to department module configuration activities
• Developed Pre Go-Live tools such as End-to-End transaction documentation for both Accounting and Procurement divisions, onsite demo/testing environments, and department specific user test scenarios
• Created Post Go-Live training documentation to record department specific processes

Sacramento, California

• Responsible for providing knowledge transfer, training, and implementation recommendations for new PeopleSoft Financials 9.1 installation.
• Created Client Business Process to PeopleSoft Process Maps
• Reviewed and responded to Change Control document proposals
• Provided cross module training to department leads for site-wide training
• Provided recommendations to customization inquiries by showing / configuring functionality in demo PeopleSoft environments
• Setup and installed PeopleSoft demo environments

Sacramento, California

• Lead Functional Consultant responsible for stabilizing initial deployment of eProcurement 9.1,performing upgrades, configuration additions, and customizations to Supplier Contracts 9.1,building new DVBE module for.
• Managed System Test / User Acceptance / End to End testing and resolved supply chain / budget related issues
• Reconfigured existing configuration to expand functionality (Change Requests)
• Process Mapped and expanded on workflow functionality
• Developed test scripts and training documentation
• Project successfully deployed 7/2014Supplier Contracts

Mississauga, Ontario - Canada

• Lead Functional Consultant responsible for gathering requirements, design, and development coordination of Accounts Receivables within PeopleSoft Financials 9.1 for a healthcare client consisting of more than 60.
• Project successfully deployed 11/2013.
• Led functional requirement gathering meetings to develop business analysis / functional requirements document
• Oversaw and managed workloads for offshore developers throughout project
• Designed customer interface to integrate with client’s existing patient scheduler
• Configured Receivables module and Distribution Accounting Receivables

Sacramento, California, United States

• Lead Business Analyst responsible for solution design and development of Payments and Collections (Dunning and Delinquency programs) within PeopleSoft Financials 8.8. Project entailed compatibility and functionality.
• Project successfully deployed 9/2011.
• Led and participated in various user requirement, functional design, and technical design meetings throughout development lifecycle
• Oversaw and managed workloads for three developers throughout project
• Significantly contributed to both functional and technical design documents Payments
• Mitigated misapplication of receivables and misappropriation of funds across bank accounts through use of various online validations

Sacramento, California, United States

• Functional Consultant responsible for leading implementation of Billing, Collections, and a Pension bolt-on customization to Accounts Receivable.
• Project successfully deployed 3/2008.Billing
• Automated monthly and quarterly invoicing through use of Installment Billing, leading to the replacement of manual invoicing (both entry and printing)
• Streamlined Billing workflow by consolidating Invoice Types and reworking the corresponding templatesCollections
• Configured Condition Monitor process to generate call actions and dunning letters for late paying customers
• Establish companywide configuration of interest penalties for Overdue Charge process to induce more timely payments from customers

• Resolution of issues arising from both domestic and international offices, giving consideration to multiple business units, multiple currencies, and multiple tax structures (VAT/GST).
• Lead functional member of project team working closely with PeopleSoft developers to design and deploy a CyberSource-based integrated credit card solution within Peoplesoft, resulting in a reduction of 100 hours of.
• Analyzed requirements of (Automatic) Entry Type / Entry Reasons using gap/fit methodology to redeploy Payment and Maintenance worksheet functionality
• Reengineered payment application through Lockbox Banking implementation (two separate PGP flat file implementations with two banking entities)
• Assisted in design, testing, and deployment of Payment Predictor to automate payment application thereby reducing manual application by approximately 50%

• Developed a multi-arrayed MS Excel workbook to automate GL reconciliation processes
• Accelerated journal and check processing from one week to one day
• Reconciled twenty year old petty cash ledger involving research of Open Item Keys

• Automated daily cash receipt reconciliation through Excel workbooks• Assisted in converting company to Peachtree Accounting 2003

• Created sector analysis toolset through integration of Smith Barney NexGen live ticker feed with Microsoft Excel
• Researched and created stock analysis reports

• Implemented a Returns Department / RMA procedures at a remote distribution center allowing the company to effectively eliminate two years of returns buildup
• Recovered $75,000 from unrealized returns opportunities
• Established standard operating procedures for new internet web order initiative

• Led college-wide workshops in Microsoft applications as well as Internet security
• Resolved computer issues for on-campus students (Approx. 1000 students)