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.