SUMMARY:

• Certified PeopleSoft Consultant and information technology professional with over ten years of PeopleSoft experience.
• Big 5 experience, as a consultant employed by PeopleSoft Consulting.
• Completed seven full lifecycle implementations, and ten upgrades.
• A team player and excellent leader with over four years of management experience as a Naval Officer and IT consultant.
• He has lead projects at various client sites, including utilities, manufacturing, transportation, healthcare, banking, telecommunications, and the federal sector.
• He has written interface programs using SQR, PeopleCode, and Application Engine.
• In addition to HRMS, he has experience with Security, Payroll, Financials, Workflow, eRecruit, Employee Self - Service, Manager Self-Service, Fit-Gap Analysis, database architecture, query reporting, Portal Enterprise for the Web Client (version 9.1), and all aspects of PeopleTools.
• He has also created development standards, specification documents, naming conventions, cutover plans and project plans for PeopleSoft customers.

TECHNICAL SKILLS:

• PeopleTools (8.48) 8.54 SQR/SQL QMF
• Application Engine 8.54 Application Designer Windows NT
• Portal Solutions 8.54 Integration Broker UNIX/Informatica
• Data Management 8.54 COBOL II Oracle
• Query JCL DB2/Mainframe/3090
• LDAP STAT SQL Server 7.0
• PeopleCode CICS JAVA/HTML
• Security Administrator (9.1) 8.51
• Database Upgrade Assistant 8.42

EXPERIENCE:

Confidential, Dallas, TX

Senior Technical Consultant

PeopleTools v8.55: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler, Integration Broker, SharePoint

Responsibilities:

• Providing technical expertise and support during the client application upgrade from v9.1 to v9.2, and retrofitted over 100 customizations into the application to include the Portal and Fluid pages. Used the PeopleSoft Update Manager (PUM) and Change Assistant to update bugs/fixes during upgrade.
• Providing technical support to security set up (created roles and permission lists) and the development of Technical Design Documents for all customizations.
• Assisted during the Fit-Gap analysis and the development of Business Requirements Documents, as well as unit acceptance testing (UAT).

Confidential

Technical Lead, Washington, DC

PeopleTools v8.52: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler, Integration Broker, STAT

Responsibilities:

• Provided technical expertise and support during the Treasury’s application upgrade from v9.0 to v9.2, and customized over 50 application requests.
• Provided technical support to the operations and management of HRConnect (HRMS) application to resolve any and all production related issues and new customizations.
• Technical Lead on all pay adjustments and pay increases for all Federal agencies supported by the Confidential (i.e. IRS, FBI, Secret Service, Department of Commerce, etc.).
• Created SQR streamline programs to interface with the National Finance Center and the Confidential involving payroll and health benefits.
• Created Application Engine programs for application interfaces and financial reports.
• Created Dynamic Query roles for specific bureaus roles and permissions.
• Maintained and wrote technical design documents explaining and outlining any and all customizations implemented within the project timeframe.

Confidential

Technical Lead, Washington, DC

PeopleTools v8.52: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler, Integration Broker, Remedy, TALEO

Responsibilities:

• Manage HCM production support issues and provide resolutions and customizations.
• Supported the new employee onboarding process with interfacing data from TALEO to PeopleSoft. Custom Confidential new hire process within PeopleSoft.
• Interact with users and provide technical specifications to functional requirements.
• Created a new custom Hierarchy & Workflow process for department organizations.
• Created a new custom calculation page and Application Engine program for the annual leave payout process for employee separation and other custom processes.

Confidential

Senior Technical Consultant, Hartford, CT

PeopleTools v8.51: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler

Responsibilities:

• Created Application Engine programs to import employee legacy data into PeopleSoft (Job Data, Leave Accrual, Leave Plan, Bonus Earned Income, Cafeteria Debit Pay interface, etc.).
• Created PeopleSoft pages, components, menus, and records for new vendor interface for CSV import and export.
• UHS-Pruitt Corporation - Senior Technical Consultant for HRMS/Financials, Norcross, GA
• February 2013 - August 2013 (Independent Consultant)
• Senior Consultant to assist with customizations to the HRMS and Financials system.
• PeopleTools v8.51: App Designer, PeopleCode, Query, SQR, SQL, TOAD, App Packages, Security, Portal, FTP, Data Mover, Process Scheduler
• Created SQR programs to import and export vendor data for employee merchandise purchases of uniforms and equipment.
• Created PeopleSoft pages, components, menus, and records for new vendor interface on Portal.
• Created additional Financial SQRs for Journal Summary reports and Voucher Summary reports.

Confidential

Senior Technical Consultant, Atlanta, GA

PeopleTools v8.51: App Designer, PeopleCode, Query, SQR, SQL, TOAD, App Packages, Security, Portal, FTP, Data Mover, Process Scheduler

Responsibilities:

• Created SQR programs to create export data files for third party vendors to create compensation and stock statements.
• Created data conversion scripts to load employee stock data into PeopleSoft tables.
• Created a tracking system for the Executive Car program (new menus, pages, records, fields, etc.), and an Application Engine interface program to load car data from the Dossier system (3rd party).
• Created new stock table pages for Cox to enter and modify stock share prices and track employee shares.

Confidential

Senior Technical Consultant, Chattanooga, TN

PeopleTools v8.51: App Designer, PeopleCode, Query, SQR, SQL, TOAD, App Packages, Security, nVision, Portal, FTP, Data Mover, Process Scheduler

Responsibilities:

• Created Application Engine program to import TALEO data from a flat file into PeopleSoft tables.
• Created Application Engine program to import STD/LTD and benefit data from a flat file into PeopleSoft Payroll tables and created a SQR report to display detail data in PDF format.
• Created Application Engine program to import Employee Photos from a path directory into PeopleSoft tables.
• Created SQR reports for Benefits data
• Modified SQR reports to alter business requirements and add new data sets.

Senior Technical Consultant

Confidential, Philadelphia, PA

PeopleTools v8.51: App Designer, PeopleCode, Workflow (AWE), SQR, SQL, TOAD, App Packages, Security, Query, Portal, FTP, Data Mover, Process Scheduler

Responsibilities:

• Retrofit all customizations for Recruiting (TAM) from v8.9 to the new v9.1 application.
• Administer compare reports, data mover scripts, and projects for v9.1 upgrade.
• Develop new customizations and unit test all new PeopleCode (i.e. Application Packages).
• Built new configuration scripts for all functional menu, components, and pages for Recruiting set-up.
• Coded over 100 customization requirements for Recruiting (Find Applicants, Job Opening Details, Manager Access, Recruiter Access, Approvals (AWE), Worklist, etc.).
• Implemented Field Level Security based on roles (Hiring Manager, Recruiter and Recruiting Admin.) and set up Approval Workflow Engine (AWE).
• Completed Technical Specification document for all custom coding.

Confidential

Senior Technical Consultant, Austin, Texas

PeopleTools v8.49: App Designer, PeopleCode, Workflow, SQR, SQRw, SQL, TOAD, App Engine, Security, Query, Portal, FTP, Data Mover, Process Scheduler

Responsibilities:

• Provide on-going production support to resolve outstanding issues resulting from user acceptance testing.
• Resolve issues with customized PeopleCode in Application Engine programs, Application Packages, Components, Pages, Records and all related PeopleCode functions.
• Custom SQR programming and SQL/Query reporting.
• Meet with end-users to resolve any and all issues involving Financials and Treasury (Accounting).

Confidential

Senior Technical Consultant, Boca Raton, Florida

PeopleTools: v8.47, 8.48: App Designer, PeopleCode, Component Interface(CI) and Excel to CI, Workflow, SQR, SQRw, SQL, TOAD, App Engine, Security, Query, Portal, Quality Center, FTP, Data Mover, Process Scheduler

Responsibilities:

• Provided on-going production support to resolve outstanding issues on Quality Center task control logs.
• Created custom Component Interfaces to load employee data to all components of PeopleSoft for mass hires, data changes, and updates.
• Created Application Engine (AE) program to update Contract Data.
• Created SQR interface program for inbound Fidelity Stock File and Retirement data.
• Customized Applicant Recruiting and modified PeopleSoft Online Application (pages, menus, components) for the applicant tracking system.
• Created AE program for Pay Rate Changes.
• Modified Benefits Inbound interface SQR program.
• Created Workflow events and business processes for emails and worklist items.
• Wrote detail Technical Specifications for all customizations and updates to code.
• Developed custom SQR interface programs (creating CSV and TXT files).

Confidential

Senior Technical Consultant, Alpharetta, Georgia

PeopleTools v8.48: App Designer, PeopleCode, SQR, SQRw, SQL, TOAD, App Engine, Security, LDAP, Query, Portal, STAT, FTP, Data Mover, Process Scheduler

Responsibilities:

• Providing on-going production support and resolving outstanding issues.
• Developed custom SQR interface programs (creating CSV and TXT files).
• Use of Application Engine and SQR for reports and interfaces.
• Developed a custom Leave of Absence (LOA) and Leave Accrual process for the Human Resource end users that will allow them to automate the LOA and Leave Accrual requests submitted by managers.
• Created workflow functionality for all custom LOA processes to send email notifications to the appropriate Human Resource personnel.
• Registered the custom components and menus on the Portal Registry, configured the single sign-on with PeopleCode and LDAP, and customized Portal pagelets and page tabs.
• Developed custom SQR report programs for Payroll, Benefits, and Financials (i.e. GL reports).

Confidential

Senior Technical Consultant

PeopleTools v8.48: App Designer, PeopleCode, SQR, SQRPlus, SQL, TOAD, Data Mover, FTP, Security, Query, Crystal

Responsibilities:

• Created data conversion scripts (import and export scripts) for migrating data.
• Continued to analyze data conversion and functional requirements for data conversion of all HR and Payroll data.
• Reviewed standard reports and wrote custom queries and SQRs.

Confidential

Senior Technical Consultant, Omaha, Nebraska

PeopleTools v8.49: App Designer, PeopleCode, Application Package, SQR, SQL, TOAD, App Engine, Security, Portal, Query, Process Scheduler, Component Interface

Responsibilities:

• Develop customized HCM and TAM enhancements for internal and external job applicants.
• Customized workflow process for the approval process and job requisitions.
• Developed custom components in Manager Self-Service and Employee Self-Service.
• Developed custom pages in Workforce Administration and the TAM process.
• Using PeopleCode in Application Designer, modified components, pages, and application packages to include custom changes to the TAM process.
• Documented all custom processes in functional and technical documents for knowledge transfer.