PROFESSIONAL SUMMARY:

• My career spans 35 - plus years of Senior level system design experience, including the last 20+ in PeopleSoft Techno-Functional Lead roles. I have a very deep skill set, with HCM expertise mixed with some Financial applications development. I also have a high level of database definition, optimization and performance tuning skills. I’m proficient in system design and architecture, and I have a proven track record of solid system delivery.
• 20+ years of PeopleSoft system design, architecture and technical development.
• Especially strong in Oracle and DB2 database design, definition and optimization.
• Effective with testing methodologies and system conversion validation.
• Very capable in Mainframe, Unix and Windows platforms and technologies.
• Very good rapport with user groups, technical peers and managers.
• Effective in a "go to" role; excellent problem solving skills.
• Willing and able related to knowledge transfer and project collaboration.
• Proficient in project, system and user documentation delivery.

TECHNICAL SKILLSET

OPERATING SYSTEMS: UNIX, LINUX, IBM-MVS, Windows 95/98/NT/2000/XP/7,8,10 DOS, OS/2.

DATABASES: Oracle, DB2, SQL Server, Sybase, Informix, IMS.

LANGUAGES & APPLICATIONS: PeopleSoft applications V3.0 through V9.2, PeopleTools V3.x through V85.x, SQR, SQL, PL/SQL, Crystal Reports, Lawson HCM, Cobol, MicroFocus Cobol, Huron/ObjectStar.

TOOLS: TOAD, SQL Query Analyzer, SQLplus, SQLtalk, SQL Navigator, SQL Developer, RapidSQL, DB2 Command Center, MicroSoft Word/Excel/Access/Outlook/Visio, TSO/ISPF, JCL, QMF, SPUFI, Platinum, Easytrieve Plus, Data-Xpert, File-Aid, Endevor, Lotus, Wordstar, ADW, Project Workbench.

WORK EXPERIENCE:

Senior PeopleSoft Analyst

Confidential

Responsibilities:

• Changed career path & began a new position in a permanent Developer/Analyst role. Projects include various HCM upgrades; V91 to V92, V92 to PUM21, V92 Migration to hosted Oracle platform, PUM21 to PUM33. Development Project hi-lites include
• Conversion of bolt-on custom HCM applications to newer PeopleSoft technology (BI-Publisher, File-Attachments, Application Packages, etc), Systematic PsQuery conversion, Payroll Bank Vendor conversion, Savings-Plan Vendor conversion. Responsibilities also include support tasks for design, enhancement and delivery of HR, Payroll, Benefits, ePay, eRecruit, ePerformance & TAM modules.

PeopleSoft Technical Consultant

Confidential

Responsibilities:

• Lead Developer for several projects & support tasks. Began in a back fill role for an extensive Pension System Rewrite. Responsible for completion of the redesigned Pension Interfaces and for new design and development of the online Maintenance and Adjustments applications. Ramped up very quickly, ensuring system delivery time frames, and providing fast turnaround n break/fix issues. Extended for design & development of Taleo, Disability, Teacher Substitute and Vision Benefit Implementation projects. Re-designed, developed and implemented the Bolt-
• On Educator Credentialing system, providing 2-way integration with the Illinois State Board Of Education. Designed, developed & deployed a Step-Progression Audit system used to identify incorrect position advancement and calculate incorrect salary payment. Re-built & designed a profile management conversion and re-configured custom systems for the v92 upgrade project.

PeopleSoft/Workday Technical Consultant, HCM

Confidential

Responsibilities:

• Compensation & Benefits Architect for a PeopleSoft HCM upgrade project.
• Responsible for analysis of current & future states, business process workflows and fit gap. Documented current systems' functionality and requirements for translation of current into future state.
• Provided direction for selection of Workday or PeopleSoft V91. Produced pro/con product assessment related to PeopleSoft V91 versus Workday V12, in preparation for steering committee presentation.

PeopleSoft Technical Support Consultant, HCM

Confidential

Responsibilities:

• Technical Developer role for multiple support projects, including: an expansion of an HCM absence management interface, design of a stock options Payroll Interface and design of an Unclaimed Property escheatment system. Utilized delivered payroll interfaces to standardize custom inbound interfaces (Paysheet Upload, Rapid Entry, SQR).
• Awarded multiple extensions based on timely and accurate project delivery. Final projects included technical development for Open Enrollment 2012, the new Learning Management System roll out and V91 upgrade development and support.

PeopleSoft Technical Support Consultant, HCM

Confidential

Responsibilities:

• Called back in a Techno-Functional Lead role for a system enhancement project. Rebuilt a back-end reporting/filing system used to submit school district staffing information to the Department
• Of Public Instruction (SQR, Profile Management, Crystal). Provided the school district with a preemptive error audit, allowing for corrective actions that increased accuracy and timeliness of the filings. Also handled support of custom apps eRoster & eDevelopment (Educational Development).

PeopleSoft Technical Support Consultant, HCM

Confidential, Northbrook, Ill.

Responsibilities:

• Technical support role for Open Enrollment, Workflow, Vendor Interfaces and Data Conversion projects. Provided technical knowledge and functional direction for existing HCM systems, utilizing Employee and Manager Self-Service applications as bolt-ons to Core HCM systems (PeopleTools, SQR, PeopleCode, Workflow).
• Built conversion SQR coding templates to provide one day turnover for extraction of the PBM employee base into the retail employee database. Also developed reports from Lawson payroll systems for historical unemployment and legal filings.

PeopleSoft Technical Support Consultant, HCM

Confidential

Responsibilities:

• Year-End Techno-Functional Support role; operated very independently, accomplishing a significant reduction of a support backlog (20-plus support tickets closed in 3 months). Redesigned the retiree benefits process and created new reporting schemes.
• Created new Oracle plans to improve batch SQL performance. Instantly connected to a remote user group, by building, executing and documenting very thorough test plans.

PeopleSoft Technical Lead Consultant, HCM

Confidential,

Responsibilities:

• Return engagement; Technical Lead for Benefits Outsourcing and Global Registry projects.
• Prepared project sizing analyses and new system designs (Excel, Visio), and redesigned custom Pension and Benefit-Costs systems based on database structure changes from the outsourcing. Re-designed the Benefits-Cost system, and created verification reports (Crystal) for validation of cost summary structures. Extended for a technical design role on a Global Registry project; designed & developed conversion of existing geographic regional structures as bolt-ons to the delivered Location component.
• Created synergy across business units, applying the regional roll-up concept universally across multiple business groups. Also redesigned a custom facility information system into a new online PeopleSoft component; done as a dual maintenance effort across multiple instances (V83 / V90).

PeopleSoft Technical Analyst, HCM / EPM

Confidential

Responsibilities:

• Technical Analyst role on a data consolidation / conversion project. Wrote specs for batch and online restructuring, to merge base HCM data across acquired branches. Designed test plans, validation processes and reports for the converted data (Crystal, SQR). Also developed audit reports detailing IRS compliance related to the converted data.
• Granted an extension for a v83 to v89 upgrade project. Had the same role for analysis, specs and coding of v89 structural & logical changes, to retrofit objects and processes updated in the conversion project. Applied an impact analysis for the upgrade, using Excel to track release changes pertinent to existing processes.

PeopleSoft Technical Lead Consultant, HCM

Confidential

Responsibilities:

• Technical Lead role, providing analysis and technical guidance for a new country roll out. Wrote specs for customizations, bug fixes, technical updates, and interface redesigns. Developed technical solutions to migrate an expanded employee base into existing reports. Managed issue assessment, user interaction and technical resolution independently.
• Extended for a new role as a lead analyst on a large acquisition project. Designed, tested and rolled out new payroll process cycles, conversion audit SQRs and data-flow processes. Also provided performance tuning analyses and solutions for batch and online functions.

PeopleSoft Technical Lead Consultant, HCM

Confidential

Responsibilities:

• Technical Support role for a v83 to v88 HCM upgrade. Tuned poorly performing queries and reports caused by data structure changes in the release changes. Built Oracle plans as a tool to improve performance. Rebuilt Crystal Forms used in the customized teacher applicant process. Also handled general support items for bug fixes, technical updates, interface fixes and year end processing.
• This role included tasks to analyze and re-apply customizations for payroll processing and Ben Admin setup structure upgrades. Also mentored permanent staffers in support roles.

PeopleSoft Technical Developer, Financials/HCM

Confidential

Responsibilities:

• Technical developer role on a Financials / ERP implementation project. Responsible for APAR and BI report and interface customizations. Executed top-to-bottom design, development and delivery of new systems and processes. Delivered Crystal AP check print & SQR Billing Invoice customizations under allotted time frames for the tasks.
• Was extended for implementation of a complete new AP pay cycle process, including voucher reconcilement via automated EDI configuration. Designed and developed customizations to delivered AR Crystals, to reconcile AR receipts from vendors with paychecks to nursing staff. Re-extended for roll out of Payroll & Benefit customizations, including design of a payroll comparison utility used as an upgrade review tool.

PeopleSoft Technical Lead, Financials/HCM.

Confidential

Responsibilities:

• Designed and implemented a legal IRS filing for an Arbitrage Bond Expenditure Tracking system. Solely responsible for system design and compliance mandated by City Auditors. Provided ad hoc audit-level analysis of project expenditures funded by public bond sales. Replaced a hands-on Excel reporting methodology that required substantial man-hours on demand from the IRS.
• Extended after implementation, for both Financials and HCM support. Designed & implemented a new FLSA Audit report, providing an ad hoc tracking mechanism to document the FLSA payroll calculation process step-by-step. This report included an instructions page that detailed the calculations step by step, eliminating many hours previously spent by the payroll support staff to do the same.

PeopleSoft Technical Developer, HR/PY/BA

Confidential

Responsibilities:

• Long term engagement, beginning with Year-End and W2 process support. Technical Lead for analysis, customization, and redesign of year end and W2 processes. Converted year-end manual balancing from an Excel-based system to an automated system using custom database tables and reports.
• Extended for a v7 to v8 upgrade & global rollout, specializing in query and reporting.
• Duties included analysis, design and database performance tuning. Designed a job history object and process to fix performance degradation caused by upgraded security. Re-extended for year-end & W2 processing for 2001. Designed a new W2 Audit report for the process, to identify scenarios that would result in incorrect W2s and/or off-balances.
• Completed stay as a lead support technician for the custom stock purchase and acquisition systems. Redesigned the custom employee stock purchase system to add audit capabilities; designed & delivered new reports to account for payroll deduction & stock purchase accuracy.