Yoko Miyata
617-***-**** **********@*****.***
Profile
Yoko Miyata is a certified professional with twenty years of IT experience in all phases of large scale
implementations. She is an expert in PeopleSoft technologies with twelve years of experience in
development, design, integration, architecture, system support and troubleshooting. Areas of
experience with PeopleSoft product suites include Financials, Supply Chain Management and Human
Capital Management.
Yoko's objective is to obtain a technical position on a large scale implementation utilizing her technical
PeopleSoft expertise in development, architecture, and best practice methodology.
Specialties: PeopleSoft technology expert and developer
PeopleSoft: PeopleTools including Application Designer, Application Engine, PeopleCode, Component
Interface, File Layout, Integration Technologies, Workflow, Security. SQR, nVision, Crystal, Conversion,
System Administration, Bundles/Patches/Upgrades/Migrations
Programming Languages: PeopleCode, SQL, Assembler, Basic, C, Cobol, dBase III, Fortran, Lisp,
Pascal, Prolog, SQR, Unix Shell, VB
Databases: Oracle(to 10g), Microsoft SQL Server(to 2008), Informix, Access, Amins/V32 4GL DB
Operating Environments: DEC PDP 11/XX, DEC VAX, HP/UX 10.20-11.0, HP-9000 HPUX, VAX II, ISI
Creator Model 8, Motorola 68000 ECB, CDC Cyber 175/200(NOS2.3), Harris H100-10A(Vulcan), MS
Windows OS series, Macintosh (MacOS), Micro Netware, Novell, VAX/VMS Unix, Emacs, SQL Loader,
Toad, Vi, Visio
PeopleSoft Profile
Southern Ute Growth Fund (2007 - 2009), PeopleSoft Developer:
PeopleSoft FSCM/HCM/Portal/Integration Upgrade/Development
Fairchild Semiconductor (2004 - 2006), Senior Consultant:
PeopleSoft FSCM/MFG Upgrade
Computer Science Corporation (1998 - 2004), Senior Consultant:
PeopleSoft FSCM/CRM Solution Assessment for Raymond James (2003)
PeopleSoft FSCM Upgrade for Valley Baptist Hospital (2003)
PeopleSoft FSCM Upgrade for L.A. Children’s Hospital (2003)
PeopleSoft FSCM/CRM Solution Assessment for GTSI (2003)
PeopleSoft FSCM/MFG Solution Assessment for Richardson Electronics (2003)
PeopleSoft FSCM/CRM Development/Implementation for ETS (2002)
PeopleSoft SCM Implementation for Fairchild Semiconductor (2000 - 2002)
PeopleSoft FIN Production Support for Jitney Jungle (1999)
PeopleSoft FIN Go Live Support for Heidrick and Struggles (1999)
PeopleSoft FIN Upgrade for NASD/NASDAQ (1998 - 1999)
PeopleSoft Financials/Distribution Implementation for Dixie Yarn (1998)
Massachusetts Port Authority (1996 - 1998), Systems Administrator/Analyst:
PeopleSoft FSCM Implementation
Experience
PeopleSoft Developer for Southern Ute Growth Fund (2007 to 2009):
PeopleSoft FSCM8.9/HCM8.9/Portal8.9 Development/Support/Problem Resolution
• Developed and customized numerous GUI and other objects using Online
Page/Component/Menu, PeopleCode, Application Engine program, Component Interface,
File Layout, interface script, SQR, and SQL script, for General Ledger, Payables,
Receivables, Purchasing, Workflow, Asset Management, and Project Costing products.
• Supported production system, testing, training and UPK for FSCM, HCM, Portal,
Integration, Application Messaging, Workflow, Security and Query.
• Upgraded PeopleTools from 8.47 and 8.48, to 8.49 pertaining Integration Meta Data.
Configured Integration Broker and App Messages for PeopleTools 8.49. Applied
Maintenance Packs for FSCM.
• Developed Automate!Test scripts using java scripts for FSCM/HCM/Portal suites. Troubleshot
and supported configuration of Benefit Administration, HR, and North American Payroll
modules in conjunction with Automate!Test. Administered Automate!Test.
• Troubleshot and developed J2EE application files, XSL, XML and java scripts for pagelets such
as Employee Self Service Portal User Interfaces and UPK User Interfaces.
• Completed numerous Service Requests via user interview, requirement definition, design,
development, test, code/process tracing for debugging and performance-tuning, and
documentation. Examples are below.
• Re-engineered “balancing journal creation” of Payroll interface processes to troubleshoot and
correct recurring errors.
rd
• Re-engineered previously incomplete “3 party to General Ledger” custom journal interfaces to
implement into production.
rd
• Designed and developed “3 party to General Ledger” budget load into production.
• Environment: PeopleSoft FSCM 8.4 / 8.9, HCM 8.9, Portal 8.9, PeopleTools 8.47 / 8.48 /
8.49, SQL Servers 2000 - 2008, SQL Query Analyzer, SSMS, Application Engine, SQR, nVision
and Crystal Reports
Senior Consultant for Fairchild Semiconductor (2004 to 2006):
PeopleSoft SCM Upgrade
• Upgraded, re-engineered, consolidated, and customized numerous GUI and other objects in
Online Page/Component/Menu, Application Engine, Component Interface, File Layout,
SQR, PeopleCode, UNIX interface script and SQL script for Inventory, Cost Management,
Order Management, and Manufacturing modules. Performance-tuned, tested, created
technical/functional specs and migrated to production.
• Tested and validated data conversion for all suites for the PeopleSoft version upgrade and
RDB platform conversion from Informix to Oracle.
• Supported go-live and post-go-live, which included code/process tracing for debugging and
performance-tuning
• Applied necessary patches and validated their functionality for all suites.
• Provided change management of all application projects to production.
• Environment: PeopleSoft FSCM 8.4 (CM, INV, OM), PeopleTools 8.4x, Unix, Oracle 9i/10g,
Informix, Application Engine, SQR, Crystal Reports, Toad, SQL Loader
Senior Consultant for Computer Science Corporation (1998 to 2004):
PeopleSoft FSCM/CRM Implementation Solution Assessment for Raymond James (2003)
• Conducted client interviews and developed current and future state technical application
architecture diagrams, future state interface and PeopleSoft Enterprise Integration Point
requirements documents.
• Completed the technical sections of the Solution Assessment Report including the future
integration effort estimate.
• Environment: PeopleSoft FIN 8.4 (AP, AR, BI, GL), CRM8.8, PeopleTools 8.4x, Unix, Toad
PeopleSoft FSCM Upgrade for Valley Baptist Hospital (2003)
• Troubleshot and corrected check/voucher printing, budget check COBOL abortion, and
withholdable voucher line issues.
• Created a detailed how-to documentation on Process Scheduler usage, and on methods to
initiate Processes using various objects/tools.
• Environment: PeopleSoft FSCM 8.4 (AP, AR, GL), PeopleTools 8.4x, Toad, Unix, Crystal
Reports
PeopleSoft FSCM Upgrade for L.A. Children’s Hospital (2003)
• Interviewed users to gather report requirements.
• Developed technical specifications for Purchasing, Inventory, Accounts Payable, and General
Ledger reports.
• Developed above reports using SQRs.
• Developed custom pages and custom code using PeopleTools and PeopleCode.
• Conducted testing with the assistance of the users to verify accuracy of reports.
• Environment: PeopleSoft FSCM 8.4 (AP, AR, BI, GL, PO), PeopleTools 8.4x, Unix, Toad
PeopleSoft FSCM/CRM Implementation Solution Assessment for GTSI : Leading National
Provider of IT Solutions for Government and Non-Profit Agencies (2003)
• Conducted interviews to assess and analyze technical infrastructure, applications, and
interfaces.
• Developed current and future state technical architecture diagrams, and future state interface
and data conversion requirements documents.
• Participated in preparation of the Solution Assessment Report, Statement of Work for
implementation, effort estimate for the next phase, and project schedule for implementation.
• Environment: PeopleSoft FSCM 8.4 (AP, AR, GL, INV, PO), CRM8.8, PeopleTools 8.4x, Toad,
Unix
PeopleSoft FSCM/MFG Implementation Solution Assessment for Richardson Electronics (2003)
• Similar tasks as above client.
PeopleSoft FSCM/CRM Development/Implementation for ETS : Global Educational Testing
Services Organization (2002)
• Collaborated with a Java user interface design team and PeopleSoft FIN/SCM/CRM teams to
design integration of the Java UI using PeopleSoft as database of records.
• Participated in a pilot using SeeBeyond Integration Tools and PeopleSoft Component Interface
for SCM and CRM integration.
• Worked with staff from multiple legacy systems to design integration from the legacy systems to
PeopleSoft FIN/SCM to enable use of PeopleSoft as centralized shipping system.
• Worked with the client IT staff and end-users to identify and design interfaces between existing
legacy systems and PeopleSoft FIN/SCM.
• Environment: PeopleSoft FSCM 8.4 (AM, AP, AR, GL, INV, PO), CRM8.8, PeopleTools 8.4x,
Toad, Unix
PeopleSoft SCM Implementation for Fairchild Semiconductor (2000 to 2002)
• Worked independently with the client's IT Logistics team as a technical expert, translating
client's business requirements into technical requirements and assisting team members in
implementing the solution for the new Warehouse Management System, which was a cross-
platform data process system that used EXE, PeopleSoft, and ExpoSoft for multiple business
units worldwide.
• Originally worked with CSC team and the client to identify requirements and requests for new
and additional functionality for the client's Inventory system. Designed and developed user
interfaces and underlying tables to facilitate new functionality.
• Documented code customizations and development as technical specifications and project
standards to the Inventory application
• Environment: PeopleSoft SCM 7.5 (INV, OM), PeopleTools 7.5x, Toad, Unix, Informix
PeopleSoft Financials AR Production Support for Jitney Jungle : Large Regional Retailer (1999)
Trained the client's Accounts Receivable staff to improve their ability to be self-sufficient using
•
the AR system.
Processed and documented production support requests and corrections to the AR application.
•
Documented customizations and report development to the AR application.
Developed SQR reports to reconcile AR to GL and to capture all transaction activities by
•
customer.
Investigated, identified and corrected posting issues by data manipulation, data cleanup, and
•
correct data setup, using SQRs, SQL scripts, online panels, and Application Engine process
trace.
Trained the technical staff in how to monitor Application Engine processes, how to prevent
•
problems, and how to recover from problems
PeopleSoft Financials Go Live Support for Heidrick and Struggles : Global Executive Search
Firm (1999)
• Developed an SQR to load operator preferences for all employees.
• Developed SQL scripts to clean out parallel data from the GL, AP, EX, and PC transaction
tables.
PeopleSoft Financials Upgrade for NASD /NASDAQ (1998 to 1999)
• Developed and customized interface SQRs for GL, Budget, AP, and AR.
• Developed and customized SQR reports for Asset Management and Billing modules.
• Designed and conducted data conversion for GL and Budget module.
• Supported functional and technical staff in attaining correct environment on application server
and client platforms.
PeopleSoft Financials/Distribution Implementation for Dixie Yarn : Large Manufacturing
Company (1998)
• Applied and validated PeopleSoft Inventory and Purchasing upgrades and fixes.
• Advised on use of Application Engine to resolve AP matching rule issues.
• Developed Crystal reports for Inventory and Purchasing.
Systems Administrator/Developer for Massachusetts Port Authority (1996 to 1998)
• Administered HP-UX servers, Process Scheduler, Tuxedo, and Oracle RDB platforms to
support PeopleSoft application.
• Customized PeopleSoft Financials and Distribution. Developed interfaces using
PeopleTools, PeopleCode, and SQL/SQR.
• Propagated PeopleSoft customization, upgrades, and fixes using Data Mover and Application
Upgrader.
• Supported and trained 60 users in PeopleSoft.
Consultant/Sr. Analyst for City of Cambridge (1987 to 1996)
• Managed all phases of system development from needs assessment to implementation,
documentation, and user training.
Converted existing systems from 3GL to 4GL environment.
•
Maintained and enhanced municipal applications software to streamline office functions.
•
Computer Consultant for University of Massachusetts, Computer Center (1985 to 1987)
• Provided user technical support and system troubleshooting on VAX and PC platforms.
• Presented workshops on text editors and operating systems, UNIX and VMS.
Assistant to Aquatics Director and Sail Master for University of Massachusetts, Athletic Dept
(1980 to 1987)
• Supervised 28 employees, processed weekly payroll and course records.
Designed, developed, and implemented various organizational systems: e.g. monthly staff
•
evaluation, seasonal staff training session, annual promotional publication, annual update of
departmental manual, and statistics of facility usage.
• Organized and administered aquatic and sailing programs for all ages.
Education
University of Massachusetts, Master of Science in Computer Science pending thesis
University of Massachusetts, BS in Business Management concentration in MIS
PeopleSoft (v. 8) Certified Technology Consultant with CSC
Bilingual in English and Japanese.