2150 Ashby Ave; Berkeley, California 94705-1836 USA [San Francisco Bay Area]
Telephone: +1-510-666-8200 [Pacific Time Zone]
E-mail: mfoy@vitalita.com (or mfoy55@16mail.com)
( Latest resume available at my URL: http://www.vitalita.com/mfoy.html )
EXPERIENCE SUMMARY
Masters
Degree in Computer
Science.
19+ years
experience as an IT consultant.
15+ years
experience with Oracle.
9+ years
experience with Oracle Applications - Performing functional and technical work within the Customer Relationship
Management (CRM), Distribution, Manufacturing, Financial, and Self-Service
modules of Oracle Applications (Oracle Financials/Oracle E-Business Suite (eBS)
for Enterprise Resource Planning (ERP)).
7+ years
experience with Oracle CRM; including: TeleService, Install Base, Service Contracts,
iSupport, and TCA.
3+ years
working with large Oracle integrators such as Oracle Consulting, BearingPoint,
CGEY,
and Deloitte.
Started
working with Oracle as a software engineer/developer; then began working in Oracle
Applications; next moved to being a technical development team lead; finally
transitioned to also working as a functional lead.
Functional
responsibilities:
requirements gathering, functional gap analysis, application design,
configuration, module setup, test script generation, writing training guides,
training end users, and production support.
Technical
(technical lead,
developer, etc.) activities: interfacing with users, identifying functional and
technical gaps, estimating work, architecting system interfaces, designing
custom solutions, programming, leading developers, scheduling, producing
documentation, and providing production support.
JOB INTERESTS
Oracle
Applications Implementations and Upgrades / Functional Lead / Techno-Functional
Consultant / Business Analyst / Architect / Technical Lead ( Oracle / Oracle Applications: CRM, ERP,
Distribution, including Oracle 11i / Implementations, Upgrades, Customizations,
Extensions, Interfaces ).
EDUCATION
University of Illinois - Champaign-Urbana, Illinois, U.S.A.
(1990-1992)
Master of Computer Science (MCS) - Specialization
in Artificial Intelligence (AI).
Colorado School of Mines - Golden, Colorado, U.S.A.
(1986-1990)
B.S. in Mathematics (BS) - Computer Science (CS) Option - Minors in Physics and
Economics.
COMPUTER SKILLS
|
Software: |
Oracle: 9i, 8i, 8, 7.x, SQL, PL/SQL,
Pro*C (15 yrs) |
|||||
|
|
Oracle Applications/Oracle
E-Business Suite:
R11i, R11, R10.7, R10.6 (9 yrs); Customer Relationship Management
(CRM/JTF), Distribution (DIST), Manufacturing (MFG), Financials (FIN);
Self-Service Web Applications (OSSWA/ICX) modules; Most experience in CRM:
Service/TeleService/Service Requests/Customer Support/Customer Care
(CS/CSS/CSC), Installed Base (CSI/CSE), Service Contracts / Contracts Core
(OKS/OKC), CRM Foundation (JTF), Trading Community Architecture (TCA/HZ),
iSupport (IBU), Customers Online (OCO/IMC), Service Intelligence (BIV); Additional modules: Order
Management (OM/OE/ONT), Shipping Execution (WSH), Inventory (INV), Bill of
Materials (BOM), Spares Management (CSP), Field Service (CSF), Electronic
Commerce/EDI Gateway (EC), Accounts Receivable (AR), Customer Intelligence
(OCI/BIC), Accounts Payable (AP), General Ledger (GL), Purchasing (PO); Other Components:
Workflow/Workflow Builder, Alerts (ALR), Application Object Library
(AOL/FND), Concurrent Manager (CM), Flexfields; New System Implementations; New
Module Implementations; Upgrades; Customizations and Extensions; Interfaces
and Data Conversion. |
|||||
|
|
Oracle Tools/Components: Oracle Application Server (OAS),
Oracle Developer/2000 and Oracle iDeveloper (including Forms6i and
Reports6i), SQL*Plus, SQL*Loader, Browser/Query Builder, Oracle Discoverer,
Designer/2000 (15 yrs) |
|||||
|
|
Misc.: ClearCase, ClearQuest, CVS/RCS, PVCS, Kintana/Chain Link
(O*M, R*I, A*I), DBArtisan, SQL Navigator, TOAD, DDTS, Lotus, MS Access,
Remedy (Call Tracker) |
|||||
|
Languages: |
SQL (15 yrs) & PL/SQL (13 yrs) |
Pascal (3 yrs) |
HTML (3 yrs) |
|||
|
|
C/C++ (9 yrs) & Pro*C (10 yrs) |
FORTRAN (2 yrs) |
SAS (6 mos) |
|||
|
|
Korn/C/Bourne
UNIX shell scripts
(6 yrs) |
JavaScript (1 yr) |
||||
|
OS: |
UNIX (Sun/Solaris, HP, SGI, IBM/AIX) (17 yrs) |
MS-Windows & MS-DOS (19 yrs) |
||||
|
|
VM & MVS
(IBM mainframes) (6 mos) |
Mac OS (Macintosh) (15 yrs) |
||||
WORK EXPERIENCE
|
11/2007 – present |
TIBCO Software – Palo Alto, California,
U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i (11.5.10); Service
Contracts/Contracts Core (OKS/OKC), Installed Base (CSI)], Oracle (9i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Develops and sells integration
software. |
|
|
* Techno-Functional consulting on
the project to implement Maintenance Renewals within the Oracle 11i
application. Charged with all
tasks related to implementing the Service Contracts (SC/OKS/OKC) and Install
Base (IB/CSI) modules: gathering business requirements, identifying gaps,
design solutions to resolve gaps in the standard Oracle system,
configuration/setup, testing, training, and all documentation. |
|
|
* Designing and implementing the
data conversion methodology to bring Installed Base (IB) instances and
Service Contracts (SCs) from a legacy system into the Oracle 11i
application. Designing an
interface to send entitlement information from SC/IB/OM Oracle 11i to Digital
River (for Electronic Software Download entitlements) and to Siebel (for
support entitlement verification). |
|
|
Project Characteristics: * Interfacing Install Base and
Service Contract information from 11i to a an electronic software download
system and to a Siebel system for Service Request entitlement and tracking. |
|
|
|
|
9/2006 – 10/2007 |
Advent Software - San Francisco, California,
U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i (11.5.10); Installed Base
(CSI), Service Contracts/Contracts Core (OKS/OKC), Order Management (OM/ONT),
Inventory (INV)], Oracle (9i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Develops and sells investment
management software and portfolio data services. |
|
|
* Working as a business analyst for
the final 6 months of a project to expand the implementation of Service
Contracts (SC/OKS/OKC) and Install Base (IB/CSI). Involved in testing (both standard functionality and
custom functionality), working with Oracle on bugs, developing new business
processes, writing training documentation, and configuring the application
during go-live. |
|
|
* Functional lead on the Phase 2
project which will deliver a number of Service Contract enhancements, as well
as preparing the system to interface data to a data warehouse (OLAP). |
|
|
* Functional lead on the Oracle
11.5.8 to 11.5.10.2 upgrade project for the following areas: IB, SC, Advanced
Pricing, and integration of Oracle to ONYX CRM. |
|
|
* Analyst on a project to deliver
AdventÕs software to customer as Electronic Software Downloads (ESD). Working on integration between Oracle
Applications and IntrawareÕs SubscribeNet Electronic Software Delivery
Solution. |
|
|
(See below [4/2005] for more
information about my prior work at Advent Software.) |
|
|
|
|
1/2006 – 9/2006 |
VMware – Palo Alto, California,
U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i (11.5.10); Service
Contracts/Contracts Core (OKS/OKC), Installed Base (CSI)], Oracle (9i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Develops and sells virtualization
software. |
|
|
* Techno-Functional consulting on
the project to implement VMwareÕs Order to Cash process into the Oracle 11i
application. Charged with all
tasks related to implementing the Service Contracts (SC/OKS/OKC) and Install
Base (IB/CSI) modules: gathering business requirements, identifying gaps,
design solutions to resolve gaps in the standard Oracle system,
configuration/setup, testing, training, and all documentation. |
|
|
* Designing and implementing the
data conversion methodology to bring Installed Base (IB) instances and
Service Contracts (SC) from a legacy system into the Oracle 11i
application. Designing an
interface to send entitlement information from SC/IB Oracle 11i to Siebel so
those can be used by the support organization to verify a customerÕs right to
support. |
|
|
Project Characteristics: * Converting customers from 3
legacy systems; cleansing customer data with Dun and Bradstreet services. * Interfacing Install Base and
Service Contract information from 11i to a customer web portal and to a
Siebel system for Service Request entitlement and tracking. * Implementing iStore as part of
this Order to Cash process; this allows customer to place orders (product and
services) on the web. |
|
|
|
|
11/2005– 12/2005 |
Coherent – Santa Clara, California,
U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i (11.5.10); Installed Base
(CSI), Service Contracts/Contracts Core (OKS/OKC), TeleService (CSS), Field
Service (CSF), Depot Repair (CSD)], Oracle (9i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Manufactures Lasers. |
|
|
* (This project to implement Oracle
11i CRM into an existing 11i (11.5.10) environment was suspended before it
was instantiated into production.) |
|
|
* Techno-Functional consulting on
the project to implement Oracle CRM including: Install Base (CSI), Service
Contracts (OKS/OKC), TeleService (CSS), Field Service (CSF), and Depot Repair
(CSD). |
|
|
* Leading a 4-person development
team. Interfacing between
development team and users.
Resolving system issues with functional setup or technical work
(customization or extensions). |
|
|
* Designing and coordinating all data
conversion development/testing tasks (for IB instances with Counters,
Warranties, Service Agreements, and Service Contracts with Charges) and
custom development items (e.g., Field Service Debrief customizations to
facilitate data flow to order management (OM) and cost tracking). |
|
|
|
|
4/2005 – 11/2005 |
Advent Software - San Francisco, California,
U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i; Installed Base (CSI),
Service Contracts/Contracts Core (OKS/OKC), Order Management (OM/ONT),
Inventory (INV), Bill of Materials (BOM)], Oracle (9i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Develops and sells investment
management software and portfolio data services. |
|
|
* Consulting on a project to move
AdventÕs customer product install base and service contracts from an Onyx
legacy system into Oracle Applications.
Designing a complete re-architecture of inventory items and bill of
materials (BOM) to support all product and service sales, billing, and
renewal from the Oracle system.
New processes in Order Management (OM) so customer licensed software
ends up in the Installed Base (CSI) and Maintenance ends up in Service
Contracts (OKS/OKC). |
|
|
* Documenting business
requirements; Data design and process re-engineering to fit with the Oracle
system; Prototype new business processes; Design legacy data conversion;
Configure applications; Create test scenarios. |
|
|
* Developed custom programs: (1) a
program to send out updated software versions to entitled customers (utilizes
the standard Oracle order API to create and book orders) (results in a mass
shipment of the new software version to customers) (PL/SQL – 6000+
lines) and (2) a program to process a flat file containing inventory (INV)
and bill of material (BOM) data into the open interface tables to load these
items (utilizes the standard Oracle API for Importing Inventory Items, Inventory
Categories, and BOMs) (results in items loaded without users having to
manually enter them into Oracle) (PL/SQL – 3000+ lines). |
|
|
|
|
2/2005 - 3/2005 |
Xilinx - San Jose, California, U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i; Installed Base (CSI),
Service Contracts/Contracts Core (OKS/OKC), Trading Community Architecture
(TCA), Accounts Receivable (AR)], Oracle (8i): PL/SQL, SQL. Toad, Windows 2000. |
|
|
Business: Designs and produces programmable
logic devices (PLDs), and software tools for these devices. Provides world-wide solutions,
support, and service for PLDs. |
|
|
* Implemented Oracle Customers
Online (OCO/IMC) module. This
included enabling Data Sharing and Security (DSS) for OCO and Customer
Standard in AR so that users would not be able to modify restricted data as
per SOX requirements. |
|
|
* Post-production troubleshooting
and analysis of business process issues within: Service Contracts (OKS),
Install Base (CSI), and TCA/Customer Master. Gather requirements, write functional (MD050) and
technical (MD070) specifications, provide recommendations for user
challenges, and implement process and system modifications. (Utilized Oracle's Application
Implementation Method (AIM) approach, and documented the process using AIM
guidelines.) |
|
|
|
|
3/2004 – 11/2004 |
Wind River - Alameda, California, U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i (11.5.9+); Service
Suite/TeleService/Service Requests/Customer Support/Customer Care/Installed
Base (CS/CSS/CSC/CSI/CSE), Customers Online (OCO/IMC), Trading Community
Architecture (TCA/HZ), Service Intelligence (BIV), Service
Contracts/Contracts Core (OKS/OKC), iSupport Self-Service (IBU), CRM
Foundation (JTF), Application Object Library (AOL/FND), Concurrent Manager,
Flexfields], Oracle (9i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Designs, produces, sells, and
supports embedded software products. |
|
|
* Managed all aspects of
implementing the Customer Relationship Management (Oracle CRM) suite within
the Oracle Applications (E-Business Suite) R11i project; included the
following business flows: ÒCall to ResolutionÓ, ÒClick to ResolutionÓ, and
ÒContracts to RenewalÓ. Performed
the full configuration, testing, documentation, training, and post-production
support for the following modules: CRM foundation (JTF: Tasks, Resources, and
Escalation Management), the TeleService area (Service, Customer Support,
Enterprise Install Base, Service Requests, Solution Management System,
Customer Care, Contact Center) (CS/CSS/CSI/CSE/CSC), Customers Online
(OCO/IMC), Contracts/Service Agreement area (Service Contracts and Contracts
Core) (OKS/OKC), and iSupport (IBU).
Coordinated implementation details with 4 other functional track leads
in the areas of ÒRecord to ReportÓ (Financials), ÒProcure to PayÓ
(Manufacturing), ÒOrder to CashÓ (Distribution), and ÒRecruit to RetainÓ
(HRMS). The main business goal
of implementing the CRM/Service modules was to effectively manage customer
service contracts and entitlement. |
|
|
* Worked on all phase of the
project life-cycle: (1) Gathered all business requirements in the service
provider/service logistics area.
(2) Designed training materials to bring users up to speed with the
standard system functionality.
(3) Performed an initial configuration of the system to support
training and demonstration activities.
(4) Final design incorporated business processes throughout the
Support organization. (5)
Completed configuration and setup to meet these needs. (6) Three cycles of testing
performed: conference room pilots (CRPs) 1 and 2 and user acceptance testing
(UAT). (7) Trained super-users. (8) Supported all go-live activities
and post-production troubleshooting. * These activities where done
within the R2i implementation methodology since this project was lead by
BearingPoint. |
|
|
Project Characteristics: * Global implementation for 12
operating unit dispersed in the Americas, Europe (EMEA), and Asia (APAC)
completed in 6 months. * Re-implementation Oracle
Applications from legacy 10.7 system (and other custom and third party
systems) to 11i (11.5.9). * Customer Master re-engineered
from 10.7 to 11i TCA with de-duplication, address verification, and DUNS
number assignment using Dun and Bradstreet (DNB) services. * Converted the following data from
legacy systems into 11i: Service Requests, Installed Base Instances and
Systems, Service Contracts, and Customers. * Orders for new Service Contracts
come from Siebel (into 11i OM); renewals are completed using the 11i Service
Contracts module directly; pricing occurs using Advanced Pricing (QP). |
|
|
|
|
6/2003 - 12/2003 |
Xilinx - San Jose, California, U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i; Trading Community
Architecture (TCA), Service Contracts/Contracts Core (OKS/OKC), Installed
Base (CSI), Order Management/Entry (OM/OE), Accounts Receivable (AR), Service
Requests (CS), iSupport Self-Service (IBU), Customer Care (CSC), CRM
Foundation (JTF), Application Object Library (AOL/FND), Concurrent Manager,
Flexfields], Oracle (8i): PL/SQL, SQL. Toad, Windows 2000. |
|
|
Business: Designs and produces programmable
logic devices (PLDs), and software tools for these devices. Provides world-wide solutions,
support, and service for PLDs. |
|
|
* Analyze, design, configure, test,
and implement a pilot project to re-architect Xilinx's existing customer
model into the Oracle 11i TCA (Trading Community Architecture)
framework. Insure that TCA is
implemented correctly, and new customers are structured properly, so that:
(1) existing functionality and business processes (in the areas of Orders,
Contracts, Installed Base Instances, and Invoices) are improved, and (2)
future CRM module implementations can take advantage of this new TCA
framework. Performed prototype
implementations of the following CRM modules in an 11.5.9 instance: iSupport
(IBU), Service Requests (CS), Customer Care (CSC), Customers Online
(OCO/IMC), and CRM Foundation (JTF). |
|
|
* Post-production troubleshooting
and analysis of Service Agreements/Contracts (including Service Contracts and
Contracts Core (OKS/OKC) modules), Install Base (CSI), TCA, and tax issues
with Contracts (AR). Full
life-cycle from requirements to specifications to testing to deployment using
OracleÕs AIM approach. |
|
|
* Custom development to call
standard APIs in the Installed Base (CSI) and Contracts (OKC/OKS)
modules. This custom process
updates installed base instances and contract records to reflect correct
ownership information for drop ship orders (PL/SQL). |
|
|
* Design, prepare, and conduct
workshops and training sessions for Service Contracts (OKS) module users to
provide them with short cuts and point out lesser-known features so they can
improve their day-to-day productivity. |
|
|
* Analysis of system and process
improvements allowing users to perform more transactions, in less time, with
better quality. Areas researched
include: Oracle Customers Online (OCO/IMC) module, TCA framework, Service
Contracts templates, and other CRM areas. |
|
|
|
|
3/2003 - 4/2003 |
Neptium - Santa Clara, California, U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i; Order Management/Entry
(OM/OE), Shipping Execution (WSH), Inventory (INV), Application Object
Library (AOL/FND), Concurrent Manager, Flexfields], Oracle (8i): PL/SQL, SQL. Toad, Windows XP. |
|
|
Business: Develops software systems that
extended functionality of ERP systems. |
|
|
* Development, configuration, and
testing of interfaces from Neptium's various systems to Oracle Applications
(including the Order Management (OM/ONT), Shipping Execution (WSH), and
Inventory (INV) modules among others) (PL/SQL). |
|
|
|
|
8/2002 - 3/2003 |
ShopNBC
(NBC/GE/ValueVision Media) - Eden Prairie, Minnesota, U.S.A. |
|
|
Environment: Oracle E-Business Suite [R11i; Order Management/Entry
(OM/OE), Shipping Execution (WSH), Inventory (INV), Order Capture (ASO),
Workflow, Application Object Library (AOL/FND), Concurrent Manager,
Flexfields], Oracle (8i): PL/SQL, SQL. UNIX (AIX), SQLNavigator, Windows 2000. |
|
|
Business: E-Retail; B-to-C; web storefront
and telephone sales direct to end customers. |