Mark W. Taylor
home page: www.markwtaylor.com
I work well in a team environment, which allows me to participate in creating, maintaining and developing an effective and technologically innovative environment. I also excel in working in an environment where I am given a set of tasks to perform on my own, not needing supervision to get the maximum benefit for the client. I have been very successful in mentoring both Technical and non-Technical personnel, both new to, and experienced, in IT and PeopleSoft. I excel in providing clear communication, identifiable value and superior quality at the highest standard of service and integrity, as well as easily understood and detailed functional and technical documentation. My technical and management/organizational skills are excellent and can be taught to others to transition knowledge effectively.
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.
Wrote customizations for Student Admissions & Recruiting reporting based on school requirements. Wrote Student Admissions Web interface to allow students to apply for admission via any Web browser. Set up methodology where applicants can attach files via the Web Application. Wrote program to upload test scores to PeopleSoft. Wrote summarized reports for Dean?s office.
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. 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. Wrote, modified and troubleshoot JCL to run various batch jobs.
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.
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, Inventory, and Accounting 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. 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. Worked with various functional teams to
determine best methodology for managing and tracking data.
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 and beyond. Managed Test Lab resources to ensure that all upgrades
and third party software meet CIS standards.
Management, Training &
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 documentation and
classes 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.
Telecommunications. Planned, designed, installed, and administered several Local Area
Networks (LANs), ranging from 6 to 3000 users, spread throughout the country.
Installed and configured LAN 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 and Risk Analysis. Defined, configured and managed Materials Management, 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.