Mark W. Taylor
EXPERIENCE DETAILS
PROFESSIONAL EXPERIENCE
PeopleSoft/CC&B Development. Designed and wrote process to monitor Integration Broker messages and email errors or long-running messages to user-specified role users. Designed and wrote process to view, download and clear trace files on UNIX servers to eliminate the need to grant UNIX access to developers. Set up Integration Broker messaging to synch HR and Financial employee data, using custom encryption methodology for dynamic security while maintaining delivered encryption for all base fields. Developed and maintained Treasury feeds for AR and Billing, including a bolt-on application to claim wires that have been uploaded from bank statements. Developed bar-coding methodology in XML, Crystal and HTML used for automatic indexing into Optix Imaging systems. Developed and wrote bolt-on application to extract specified vendors to be transmitted to third-party company to be scrubbed and returned with demographic data, which was then re-imported to the database. Created interfaces to and from various PS applications, including Journals, Vouchers, Travel & Expenses, My Wallet, Budgeting & Grants. Developed banking feeds for ACH, Positive Payment, custom checks and forms. Wrote various data load scripts for conversions and interfaces. Wrote scripts for commitment control budgeting import and exports. Developed PLSQL scripts emulating SQR reports to port from CIS to CC&B using Business Objects and BOE. Developed and executed scripts to convert financial data from Fiscal Year to Calendar Year structures. Developed reporting structures and strategies for Utility company. Developed Conversion scripts and Interface programs to be used to convert or interface data between Legacy systems and PS CIS. Supported 26 Government Higher Education databases utilizing Budget and Encumbrance management of full acquisition lifecycle. Developed scripts to adjust Pre Encumbrances and Encumbrances to correct amounts and chartfields for Year End closing of 30 Colleges and Universities. Developed customizations using Application Designer, COBOL, Application Engine, SQR, Crystal and Application Messaging requested by Purchasing, Distribution, Project Costing, AR/Billing, AP, GL, Project Costing, Inventory, and HR customers, to include system modifications and workflow. Customized Application Engine and COBOL code, as well as Mass Change to meet the specific needs of the customer. These include PO Build, Item Loader, AP Matching, Posting, Putaway, Replenishment, AutoShip, AutoPick, and Depletion. Developed interface programs and procedures to migrate data between systems, including AP and OM to AR/BI, Legacy to AP, AR/BI, and PC. Maintain version control with Quest Stat! Help Desk/Change Control software. Developed bolt-on Production Control Analysis system to enable full Supply Chain and Manufacturing integration of requesting, analyzing, and finalizing of data to control production costs, ensure assembly volume capacity, and maximize profits by calculating most effective delta between purchasing product and manufacturing in-house. Wrote interface programs to port data between dissimilar versions of Student Admin and Financials.
Configured and installed Multi-Lingual and
Multi-Currency versions and modifications for International company. Worked with native speakers to
translate custom panels, data, and reports. Modified delivered, and wrote new, SQR programs, to
customize, provide new functionality, as well as address delivered
shortcomings. These included reports, importing/exporting data, and table
setups. Developed interface programs and procedures to migrate data between
systems, including AP and OM to AR/BI, Legacy to AP, AR/BI, and PC. Developed and tested interfaces to and
from Legacy systems, including G/L, A/P, Purchasing, and A/R. Wrote and maintained programs to
extract G/L data from Legacy, summarize, and post into PeopleSoft. At a separate site, wrote a similar
program to extract PeopleSoft G/L data, summarize, and post to a Legacy system. In addition, heavily customized delivered
interface programs for client complexities and requirements, including AR to
BI, AP to BI, Legacy to BI, and Custom BI to delivered BI. They served a number
of purposes from straightforward reporting to loading data to validation and
updating of existing data, as well as archiving off data that was no longer
necessary on the database to improve performance while keeping the archived
data available for historic purposes. Also assisted others in designing,
writing and troubleshooting of SQRs. Documented customizations for both
technical as well as functional audiences.
Performed analysis of prior
modifications and PeopleSoft methodologies to determine how best to remove
customizations and bring customer back to vanilla PeopleSoft, while maintaining
required functionality and flexibility.
Tuned various processes to perform faster, including PeopleCode,
Application Engine, and COBOL.
Evaluated the feasibility of developing a custom Application Engine
program to replace Item Loader. Developed Import Manager profiles to import
various sets of data into specific tables. These profiles were developed using
PeopleCode attached to the import records specifically for the import that
validated data and returned context-specific error messages. In addition, to
overcome Import Manager limitations, wrote code that allowed Import Manager to
execute inserts and other operations on tables other than the single table
allowed by Import Manager. Developed procedures for loading base tables through
the use of Data Transfer In/Out and Import Manager.
In addition, evaluated the
feasibility of developing a custom Application Engine program to replace Item
Loader. Developed Import Manager profiles to import various sets of data into
specific tables. These profiles were developed using PeopleCode attached to the
import records specifically for the import that validated data and returned
context-specific error messages. In addition, to overcome Import Manager
limitations, wrote code that allowed Import Manager to execute inserts and
other operations on tables other than the single table allowed by Import
Manager. Developed procedures for loading base tables through the use of Data
Transfer In/Out and Import Manager.
Configured Mass
Changes to perform various tasks, including granting access to back-end SQL
access without having to grant back-end SQL access, and providing back-out
procedures for reversing imported data. Configured and trained users on the use
of Item Loader for bulk loading Purchasing items. Evaluated Application Engine
code to determine best method of attaining specific goals set out by
customization requirements. Consulted with other developers to assist in
determining the best technical methodology for specific tasks. Provided
technical documentation and end-user demos to evaluate alternative ways of
achieving desired goals, ranking them by desirability based on development
effort required. Provided Level of Effort documentation for various
customizations requested by users. Developed Excel macros to simulate nVision
without the performance limitations of the delivered tool.
Set up Virtual
Approver in the Business Process Designer and Workflow Administrator for
workflow customizations, as well as connectivity with Lotus Notes for approval
from non-PS users using PSNotes connectivity. Developed methodology of testing
using SQA Robot, then trained developers in the use and procedures, to include
naming nomenclature to ensure solid documentation. Worked as liaison to
Purchasing customers to define tasks, resources, prioritization, and scheduling
for deliverables. This includes assisting customers in determining feasibility
of requirements in light of the possibility of altering procedures to make more
efficient use of the system, and more reliable customizations. Assisted in SQR
modifications necessary for customizations. Performed troubleshooting of COBOL
programs to determine whether code or customizations were causing specific
problems. Designed and maintained PeopleCode modifications as well as
troubleshooting delivered code. Customized and maintained nVision and Crystal
reports for various customizations. Documented customizations for both
technical as well as functional audiences.
PeopleSoft Installation and Administration. Installed and maintained Oracle database, with Financials and HR applications, including Application server (Tuxedo), Process Schedulers, and Web Server (Weblogic). This included setting up and tuning PIA and PeopleBooks search.
Managed staff responsible for Purchasing customizations targeted as Phase II,
after initial installation, as well as initial installation of Accounts
Receivable and Billing. Part of a 15-person team that installed PS 6.0 Accounts
Payable and Purchasing in 6 months, while upgrading PS GL from 5.1 to 6.0.
Concurrently worked on a separate team of 8 that installed PS HR 6.01 in 10
months. Configured and set up infrastructure of all PS systems to allow
consistency in product development cycle and production support. System
platform included Oracle on UNIX servers, Novell file servers, and NT/Windows
95 workstations. Designed security administration and configuration management
procedures in Object and Operator Security as well as trained staff to manage
these procedures.
Designed and implemented
Lotus Notes database to track recurring problems, PS patch implementations, and
development requests. This system tracked these items through all environments
up to production and reduced time spent on implementation of these tasks. In
addition, the database stored all development documentation in standardized
format. Routinely reviewed patches on PS Customer Connection to identify
potential need. Then, worked with all teams to determine need and
scheduling/implementation of said patches. Managed and implemented upgrades,
both Tools and Functional, using Data Mover, Application Upgrader, and upgrade
documentation from the Customer Connection and installation CDs. Installed and
configured the Application Server, Tuxedo and the Web Server.
Worked closely with
other administrative groups, such as Network Administration, Server Management,
Web Master, Access Management, Data Security, Technology Risk Management and
Production Readiness to ensure that the PeopleSoft implementations complied
with CIS policies and requirements for reliability, compatibility and Year 2000
compliance. Managed Test Lab resources to ensure that all upgrades and third
party software meet CIS standards.
Management,
Training & Service. Trained
college students to support PeopleSoft applications, which included intensive
Tools and functional training without formal PeopleSoft training. Directly
managed up to 30 individuals. Supported systems activities and provided
front-line hardware and software troubleshooting and problem solving. Trained
staff on effective use of systems, troubleshooting methodologies, and in many
cases, structured programming. Provided training designed to develop
self-reliance in the use of technology. Taught classes in various technologies.
Managed external service organizations to ensure timely problem resolution.
Tracked troubleshooting activities to ensure continuing acceptable turnaround
and quality of service.
Networks & Telecommunications. Planned, designed, installed, and administered
several Local Area Networks (LANs), ranging from 6 to 3000 users, spread
throughout the country. Installed and configured WAN with System Fault
Tolerance Level III. Installed and maintained an isolated LAN (for security),
that is solely for accounting purposes. Maintained secure, highly confidential
LAN systems on the Senate Floor for information retrieval. Implemented disaster
recovery program that provides means of recovering from a potential disaster
through hardware and software redundancy, as well as off-site backup storage.
Served as member of team assigned to re-design WAN communication base to meet
the requirements for proposed future systems growth for the following 10 years.
Security. Defined, configured and managed financial and Human
Resource application security for life cycle from development phase through
production. Ensured compliance to defined standards from developers, support
personnel, as well as end-users. Designed and produced methods of allowing
access and administrative flexibility, while maintaining integrity and security
of overall WAN environments. Investigated the feasibility and reliability of
various security methods, hardware, and software with the ultimate goal of
implementing C2 compliance. Designed a security system that is acceptable, from
a secure point of view as well as user acceptance. Performed risk analysis and
developed alternative methods of minimizing the risk, at the same time defining
inherent advantages and disadvantages of the alternatives.