OVERVIEW SUMMATION

 

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.

 

 

JOB HISTORY

 

Las Vegas Water District, Las Vegas, NV (Oracle)

PEOPLESOFT CIS/ORACLE CC&B REPORT CONVERSION CONSULTANT, December, 2007 to present)

Heald College, San Francisco, CA (SQL Server)

PEOPLESOFT ASSET MANAGEMENT CONVERSION, January, 2008 to October, 2008 – part-time)

Heald College, San Francisco, CA (SQL Server)

PEOPLESOFT STUDENT FINANCIALS/FINANCIALS/SUPPLY CHAIN CONVERSION SPECIALIST, December, 2007 to January, 2008 – part-time)

3M, St. Paul, MN (DB2)

PEOPLESOFT SOURCING/ePROCUREMENT/eSUPPLIER GLOBAL IMPLEMENTATION DEVELOPER, (February, 2007 to November, 2007)

Brooklyn Polytechnic University, Brooklyn, NY (SQL Server)

PEOPLESOFT FINANCIALS TECHNICAL/SECURITY SPECIALIST, (November, 2006 to February, 2007)

Rogers, Rogers, CT (Oracle)

PEOPLESOFT ORDER MANAGEMENT/INVENTORY TECHNICAL LEAD, (August, 2006 to October, 2006)

3M, St. Paul, MN (DB2)

PEOPLESOFT SOURCING/ePROCUREMENT/eSUPPLIER DEVELOPER, (November, 2005 to August, 2006)

UbiquiTel, Conshohocken, PA (SQL Server)

PEOPLESOFT FINANCIALS/ASSET MANAGEMENT  SPECIALIST, (October, 2005 to October, 2005)

City of Sacramento, Sacramento, CA (Oracle)

PEOPLESOFT CIS REPORTING/INTERFACE SPECIALIST, (August, 2004 to July, 2005)

LoneStar SteakHouse, Wichita, KS (Oracle)

PEOPLESOFT FINANCIALS/HR UPGRADE/CONVERSION SPECIALIST, (March, 2004 to July, 2004)

ASTAR, Covington, KY (Oracle):

PEOPLESOFT FINANCIALS/HR INSTALLER & SUPPORT SPECIALIST, (October, 2003 to February, 2004)

US Oncology, Houston, TX (Oracle)

PEOPLESOFT FINANCIALS UPGRADE SPECIALIST, HR/PAYROLL DEVELOPER, (August, 2003 to October, 2003)

Hitachi Computer Products, Norman, OK (Oracle)

PEOPLESOFT NVISION/UPGRADE TECHNICAL SPECIALIST, (July, 2003 to August, 2003)

Georgia First (Georgia Southern University), Athens, GA (Oracle)

PEOPLESOFT FINANCIALS PRODUCTION SUPPORT CONSULTANT, (June, 2003 to July, 2003)

Hitachi Computer Products, Norman, OK (Oracle)

PEOPLESOFT SUPPLY CHAIN/MANUFACTURING TECHNICAL CONSULTANT, (January, 2003 to June, 2003)

Waste Management, Houston, TX (Oracle)

PEOPLESOFT CIS/CRM TECHNICAL CONSULTANT, (June, 2002 to December, 2002)

Drummond Company, Birmingham, AL (Sybase)

PEOPLESOFT PURCHASING FUNCTIONAL & PURCHASING/PAYABLES/INVENTORY TECHNICAL CONSULTANT, (December, 2000 to March, 2002)

Birmingham Health System, Birmingham, AL (DB2)

PEOPLESOFT A/P, PURCHASING TECHNICAL CONSULTANT, (April, 2000 to December, 2000)

Petroleum Geo-Services, Houston, TX (Oracle)

PEOPLESOFT A/P PRODUCTION SUPPORT, (April, 2000 to April, 2000)

Larson Manufacturing, Brookings, SD (Oracle)

PEOPLESOFT TECHNICAL CONSULTANT, INVENTORY/DISTRIBUTION, (February, 2000 to March, 2000)

Coastal Corporation, Houston, TX (DB2)

PEOPLESOFT TECHNICAL CONSULTANT, Purchasing/AP/AR/BILLING/BUDGETS/INVENTORY/PROJECT COSTING, (February, 1999 to December, 1999)

Fairchild Semiconductor, Portland, ME (Informix)

PEOPLESOFT TECHNICAL CONSULTANT, AR/BILLING/OM/MANUFACTURING, (September, 1998 to January, 1999)

Ogden Corporation, New York, NY (Oracle)

PEOPLESOFT CONSULTANT, PURCHASING/PROJECT COSTING, (February, 1998 to August, 1998)

Fannie Mae, Washington, DC (Oracle)

PEOPLESOFT PURCHASING, ACCOUNTS RECEIVABLE AND BILLING DEVELOPMENT MANAGER, (November, 1997 to February, 1998)

Fannie Mae, Washington, DC

PEOPLESOFT DEVELOPER, (August 1996 to November, 1997)

Fannie Mae, Washington, DC

SENIOR SECURITY ADMINISTRATOR, (April 1995 to August 1996)

New Boston Systems (Office Automation Contractors), under contract to Fannie Mae, Washington, DC

SENIOR SECURITY ADMINISTRATOR, (July 1994 to April 1995)

U.S. Senate,  The Capitol, Washington, DC

SENIOR LAN ADMINISTRATOR and SECURITY ADMINISTRATOR (Secret security clearance held), (May 1989 to July 1994)

WordPro, Inc. (Office Automation Consulting Firm), under contract to the Library of Congress Automated Information Systems

SYSTEMS ANALYST (May 1985 to May 1989)

 

PROFESSIONAL EXPERIENCE

 

PeopleSoft Development

Developed PLSQL scripts emulating SQR reports to port from CIS to CC&B using Business Objects.  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. 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.  In addition, wrote other programs (SQR, Application Engine, etc.) to convert customer data to new record layouts.   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 & 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 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.

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 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.

 

 

EDUCATION

 

PeopleSoft and Related Training Sessions

Database Upgrade and Portal Tols, ver 8, Tools I, Tools II, Business Process Design, Data Management Tools, Security Administration, Configuration Management, SQA for PeopleTools, nVision, General Ledger I, Oracle I.  Attended the 1997 PeopleSoft Conference in Orlando.

Various Specialized Training Sessions

Windows, Installing Windows on Netware, Netware Administrator I and II, Security on Netware.

Computer Careers Certificate Program

Strayer Business College, Washington, DC;    Maintained 4.0 GPA

Business Systems Analysis

Strayer Business College, Washington, DC;    Maintained 4.0 GPA

Communications Electronics

Springfield-Clark County Joint Vocational School;    Maintained 3.8 GPA