JOSEPH SCHLUND
Technical Project and Team Lead on PeopleSoft Enterprise Human Capital Management implementations and upgrades. Detail-oriented with strong applied analytical and problem-solving skills. Possesses solid understanding of IT best practices and excellent organizational, interpersonal and communication skills. Proven ability to deliver projects on time and under tight deadlines with aggressive schedules.
- Personally recognized as #1 contractor on $200 million+ project consisting of over 200 contractors
- Saved over $200,000 in upgrade costs to VB 6.0 and SQL Server 7.0 of Float Management product
- Improved productivity for project by developing on-line workbench facility
- Significantly reduced development process by implementing team coding best practice methodology
- Managed up to 26 technical staff during development and implementation of MLS System
- Successful in meeting new technical challenges and finding creative solutions to customer needs
Professional Experience:
INDEPENDENT COMPUTER CONSULTANT 2008 – Present
• Enhanced custom Peoplesoft SQR and Peoplecode to incorporate global process
• Wrote or enhanced SQR interfaces
• Modified custom on-line workflow to terminate benefits
• Improved productivity by developing scripts to dynamically maintain reports in user directory
Key Clients: Textron
CHERRYROAD TECHNOLOGIES, INC - Senior Consultant 2006 – 2007
• Constructed vendor conversion program using Application Engine/Component Interface with Microsoft Access input
• Developed conversion strategy document for the implementation of Peoplesoft HCM 8.9 HR, Benefits, Payroll and Time & Labor
• Led in the identification and mapping of any required interfaces and conversions
• Coded conversion of Vendors, Grant Expenditures and AP Invoicing using PL/SQL
• Formalized Change Assistant installation and usage training document
Key Clients: Lucas County, Lexington-Fayette Urban County, NY State Thruway Authority
INDEPENDENT COMPUTER CONSULTANT 1993 – 2006
• Resolved critical go-no go issues and performed troubleshooting for Peoplesoft HCM 8.9 upgrade
• Reduced payroll batch process from 5.5 hours to less than 2 hours with tuning recommendations
• Determined error with delivered Peoplesoft COBRA program and sent fix to Oracle to be included in next patch
• Led Unit Acceptance Testing for the Peoplesoft 8.8 Payroll upgrade
• Configured App Messaging for Dynamic Role query roles security and permissions through • Initialized procedure for system/parallel tests in a secure environment before mid-quarter conversion
• Developed interfaces from Kronos, Campbell and Teletime TCD to Peoplesoft Time & Labor
• Design execution plan schedule, JCL and identified key reconciliation points
• Provided post-production and year-end support to Time & Labor and Payroll
• Mentored team members in DB2, SQL, SQR, Peoplecode, JCL, COBOL II, Easytrieve, testing and documentation standards
• Designed and implemented front-end benefits system for Interactive Voice Response (IVR) using Visual Basic, Crystal Reports and DB2/2 accessing Peoplesoft tables via ODBC
Key Clients: PepsiCo, Frito-Lay, Lowe’s Companies, JCP, Yellow Roadway, Novant Health
Education and Certifications:
SUNY College at Buffalo – Buffalo, NY
B.S. in Information Systems Management (ISM)
CompTIA Project+ – PMI, In progress
Oracle 11i: Financial Functional Fundamentals – Oracle University
Oracle 10g: XML Fundamentals – Oracle University
Oracle BPEL Process Mgr: Services Orchestration – Oracle University
Oracle 10g: Program with PL/SQL – Oracle University
SAP ABAP/4 – Lampton College
Programming in Visual Basic – Microsoft Educational Services
SQL/DB2 – IBM
Microsoft Development Environment – Cutler-Williams
Technology Summary:
Peoplesoft
• Absence Management • Application Designer • Application Messaging • Asset Management • Base Benefits • Benefits Administration • Change Assistant • Component Interface • Financials • General Ledger • Integration Broker • Payroll • Peopletools • Process Scheduler • Time & Labor
Languages
• Application Engine • CICS • CLIST • COBOL • Dialog Manager • Easytrieve • IMS DB/DC • JCL (OS/DOS) • Peoplecode • PL/SQL • SQL • SQR • Visual Basic
Tools
• AbendAid • Animator • CA-7 • Changeman • Crystal Reports • Data Junction • Datavantage • DB2 Connect • Excel • Expediter • File-Aid • JHS • Librarian • MS Project • Panvalet • Peregrine • QMF • Queryman • Spufi • Syncsort • Telon • Toad • TSO/ISPF • Visio • VSAM • Zeke