SUMMARY:

16+ years of PeopleSoft technical experience including full life cycle implementations, application and PeopleTools upgrades, reporting, interfacing, code development and production support

TECHNICAL SKILLS:

PeopleTools 8.52: Application Designer, SQR, SQL, PeopleCode, Application Engine, File Layout, Component Interface, Workflow Administrator, Change Assistant, Query Manager, Crystal Reports, Data Mover, Security

PeopleSoft 9.1: PeopleSoft HCM Human Resources, Base Benefits, Benefits Administration, Time and Labor, Manager/Employee Self Service, Payroll Interface, Payroll for North America, Person Model, Recruiting Solutions, Talent Management, Profile Management

PeopleSoft CRM: Helpdesk, Case Management

PeopleSoft ELM: Learning Management

PeopleSoft FM: AP, AR, GL

PeopleSoft SCM: Customer Order Management

RDBMS: Oracle 11G SQL Plus, SQL Developer, TOAD, SQL Server Query Analyzer

CLIENT HISTORY:

Confidential, Washington, DC

Responsibilities:

• Served as PeopleSoft Time and Labor 9.1 business analyst specializing as functional reviewer and drafted functional design documents for documenting change request specifications and proposed technical resolutions
• Performed functional testing of applied technical solutions to change requests and composed unit testing requirements documentation, test scripts, and completed solution verification

Confidential, Arlington, VA

Responsibilities:

• Performed technical production support on PeopleSoft HCM 9.1 and PeopleSoft Financials Management 9.1
• Ran custom SQL queries and SQR programs developed for weekly and year - end processing
• Created outbound interface on PeopleSoft HCM 9.0 using PeopleCode/Application Engine
• Developed Component Interface/Application Engine program for data conversion
• Production support, reporting and development of interface feeds on HCM 9.0 using Application Engine, Component Interface, SQR
• Assisted in the setup and troubleshooting of PeopleSoft Profile Management

Security Administrator

Confidential, Seattle, WA

Responsibilities:

• Created SQR interface from PeopleSoft HCM 9.0 to ADP Payroll for Confidential Co’s UK personnel
• Developed integration model synching three separate systems with PeopleSoft Financials Management 9.0 using Application Engine and Integration Broker.
• Coded data conversion application using SQR that converted Biographical, Person of Interest and Employee Profile data from GEAC legacy systems into PeopleSoft HCM 9.0
• Managed support cases on PeopleSoft CRM 9.0 and optimized custom reports by enhancing underlying code to make batch processes run more efficiently
• Participated in Payroll for North America implementation fit-gap sessions
• Designed future state conceptual model for analyzing purchasing and implementation costs, optimizing application setup, and determining ideal hardware and database architecture
• Designed infrastructure roadmap making technical analysis and recommendations to implement the overall technology architecture for PeopleSoft HCM 9.0 and ePerformance 9.0
• Composed architecture documentation for integrating PeopleSoft ELM 9.0 with third-party remote training application which included business requirements, functional design specifications, and project plan
• Managed technical team, led fit-gap analysis and developed field-to-field mapping architecture to convert nationwide business units from ADP Payroll and Kronos to PeopleSoft HCM 8.9
• Created data conversion applications in PeopleCode/Application Engine to extract HR, Benefits, Payroll and Balances from ADP into PeopleSoft.
• Managed and led development team of 8 consultants on PeopleSoft HCM 8.9 implementation for multi-national not-for-profit including HR, Base Benefits and North American Payroll
• Designed 23 inbound/outbound interfaces including a General Ledger interface and completed design specifications for developers
• Wrote entire data conversion program in PeopleCode for data migration with additional migration using Data Mover script

Confidential, Seattle, WA

Responsibilities:

• Led as the sole technical architect in a global implementation of PeopleSoft HCM 8.9 for a multi-national publicly-traded $2.22 billion company.
• Designed workflow messaging and routing network, coded online development on pages and components, programmed data conversion in Application Designer using Peoplecode, administered security for users, roles and permission lists.
• Designed Workflow in PeopleSoft HCM 8.8 Workflow to trigger email to approving manager when an employee requests Paid Time Off.
• Coded Paycheck Details Self-Service allowing Time Reporting employees to view their Overtime online.
• Designed Timesheet Approval page that allows Managers to approve timesheets submitted by employees.
• Created Payroll page allowing Payroll Administrators to log into PeopleSoft time manually compensated.
• Administered security for users, roles and permission lists to set up employee self-service for eTime on Time and Labor.

Confidential, Auburn, CA

Responsibilities:

• Completed multiple Application Engine interfaces using PeopleCode and SQL to output text files for loading PeopleSoft data into external applications on a UNIX platform.
• Wrote PeopleCode-based Application Engine data conversion programs to load legacy data into PeopleSoft HCM 8.8.
• Implmented PeopleSoft EPM 8.8 SP1 utilizing PowerMart Informatica 6.1 for loading data into Data Warehouse tables.
• Completed two PeopleSoft HCM application upgrades - from 7.02 to 7.5 and 7.5 to 8.8 - using manual steps and Change Assistant.
• Upgraded the RDBMS platform from SQL Server 7 to SQL Server 2000 in order to support PeopleSoft HCM 8.8.
• Served as the PeopleSoft System and Database Administrator and managed the Application, Process Scheduler and Weblogic Web Servers.
• Completed application upgrade of PeopleSoft HCM suite, featuring HR, Benefits and Payroll, from version 7.51 to 8.3 as the Technical Team Lead using Change Assistant
• Served as System and Database Administrator configuring and maintaining Application Server, the Process Scheduler Server, and PeopleSoft Internet Architecture.
• Applied numerous Payroll Tax Updates to bring client up-to-date with latest patches and updates
• Developed SQR programs that created a CSV output from Job, Earnings, Tax and Deduction data from PeopleSoft HRMS 8.
• Worked on assessment of PeopleSoft Time and Labor 8 versus third-party time and attendance application called STAR to improve STAR’s efficiency in processing T&L and to suggest if hardware upgrade or database tuning needed
• Assessment also intended to facilitate client decision to retain STAR or implement PS Time and Labor instead.

Confidential, New York, NY

Responsibilities:

• Mentored client developer in completing Application to PeopleSoft 8 using Change Assistant
• Functionally assessed compare reports and copy/delete object decisions
• Prepared data conversion documents to facilitate analysis of obsolete tables and fields
• Modified SQRs for PeopleSoft HRMS 8 compatibility and wrote Application Engine processes

Confidential, New York, NY

Responsibilities:

• Worked on full life cycle upgrade of PeopleSoft from 7.5 to 8 and led team of developers
• Updated SQR program generating legal courses for attorneys and inserting data into Job
• Created SQR interfaces from PeopleSoft to CMS and Essbase
• Built data migration procedure between Lotus Notes and PeopleSoft for data exchange
• Conducted remote PeopleSoft training sessions for recruiters
• Created database update and insert batch jobs on Application Engine
• Wrote workflow to generate automated emails upon new hire in PeopleSoft
• Modified PeopleSoft Financials SQRs, Qureries and Crystal Reports in AP, AR, GL modules
• Customized pages and applied security for custom PeopleTools projects
• Taught Beginners and Advanced level courses on PeopleSoft Query and Crystal Reports
• Modified multiple PeopleSoft FM/SCM 7.5 SQR programs to generate ad-hoc user reports
• Developed pages for user access to data displayed via custom views on Order Management in PeopleSoft Financials
• Unit tested existing reports using PeopleSoft Query in PeopleSoft HCM 7.5
• Wrote test plans and tested queries in SQL Plus and ran reports to Crystal Reports
• Demonstrated data entry methods to junior team member

Confidential, Dallas, TX

Responsibilities:

• Ensured SQR modification compatibility from PeopleSoft Financials Management 6.0 to Financials Management 7.0
• Instructed team member to perform the same task in supervisory role
• Created and tested Oracle triggers with SQL Plus and Developer 2000
• Modified multiple SQRs in Accounts Payable and Accounts on PeopleSoft Financials to enhance data loading and output formatting
• Performed data conversion and mapping using Import Manager on PeopleSoft HCM 7.5
• Exported and imported tables and databases using Data Mover tool
• Modified record fields online using Application Designer