EMPLOYMENT HISTORY

Confidential

Senior Technical Consultant

Dallas, TX

• PeopleTools v8.55: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler, Integration Broker, SharePoint
• 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).

Technical Lead

Washington, DC

• PeopleTools v8.52: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler, Integration Broker, STAT
• 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 US Treasury (i.e. IRS, FBI, Secret Service, Confidential, etc.).
• Created SQR streamline programs to interface with the National Finance Center and the Department of 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.

Technical Lead

Washington, DC

• PeopleTools v8.52: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler, Integration Broker, Remedy, TALEO
• Manage HCM production support issues and provide resolutions and customizations.
• Supported the new employee onboarding process with interfacing data from TALEO to PeopleSoft. Custom IMF 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.

Senior Technical Consultant

 Hartford, CT

• PeopleTools v8.51: App Designer, PeopleCode, Query, SQR, SQL, App Engine, Security, Portal, Process Scheduler
• 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.

Senior Technical Consultant

Atlanta, GA

• PeopleTools v8.51: App Designer, PeopleCode, Query, SQR, SQL, TOAD, App Packages, Security, Portal, FTP, Data Mover, Process Scheduler
• 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.

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

Philadelphia, PA

• PeopleTools v8.51: App Designer, PeopleCode, Workflow (AWE), SQR, SQL, TOAD, App Packages, Security, Query, Portal, FTP, Data Mover, Process Scheduler
• 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.

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

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

Senior Technical Consultant 

• PeopleTools v8.48: App Designer, PeopleCode, SQR, SQRPlus, SQL, TOAD, Data Mover, FTP, Security, Query, Crystal
• Developed data mapping documents and spreadsheets for data conversion project.
• 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.

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

Senior Technical Consultant

Atlanta, Georgia

• PeopleTools v8.48: App Designer, PeopleCode, SQR, SQRw, SQL, SQLPlus, App Engine, Component Interface, Query, Security
• Provided on-going production support and resolving outstanding issues.
• Developed custom SQR reports and interface programs.
• Created technical standards documents for custom development work and coding.
• Developed in Application Designer using PeopleTools (v8.48), PeopleCode, Application Engines, SQL, Component Interfaces, Query tools, and object oriented definitions.
• Developed on an Oracle/UNIX platform.

Confidential

Senior Technical Consultant

Suwanee, Georgia

• PeopleTools v8.48: App Designer, PeopleCode, SQR, SQL, SQLPlus, SQRw,App Engine, Query, Crystal, Component Interface, FTP, Data Mover, Security, Process Scheduler, Portal
• Developed upgrade plan to include architecture design, data conversions, record counts, and security set-up.
• Wrote Fit Gaps and business process maps for proposed upgrade and implementation changes.
• Run and review compare reports between source and target databases.
• Monitored the upgrade process with DBAs using Upgrade Assistant.
• Wrote PeopleCode (v8.48), Application Engine programs, and SQRs for various interfaces and changes to both the Financials and HRMS systems during the upgrade.
• Wrote the complete online interface program for GCPS and the state of Georgia’s Teachers Retirement System (TRS) with customizations to Compensation Administration.
• Using Portal Solutions v8.9 on HRMS v8.9. Portal Administrator managing the structure and content folders and Portal Security.
• Created a SQR interface program to send outbound flat files to various 3rd party vendors.
• Performed test moves to production on the Oracle database.
• Updated user profiles, row level security classes, and data permission lists for users.
• Approved all customized component permission lists for security page access.
• Developed upgrade template for Upgrade Assistant and modified scripts as needed.
• Developed change control documents and procedures for data migrations.
• Implemented custom pages and registered pages with the Portal Registry.

Confidential

Senior Technical Consultant

Houston, Texas

• PeopleTools v8.46: App Designer, PeopleCode, SQR, SQRw, SQL, SQLPlus, App Engine, Security, Process Scheduler, Portal
• Assisted with Fit Gap Analysis and identifying key issues.
• Created Application Engine interface program to ADP for tax data.
• Developed business process design for client’s unique pay structure.
• Created custom T&L rules for payroll interface.
• Plan to develop custom pages, components, and menus for custom business processes.

Confidential

Senior Functional/Technical Developer

New York, New York

• PeopleTools v8.2: App Designer, PeopleCode, SQL, SQLPlus, Java/HTML, Security, Portal
• Created 10 Activity Maps and 4 Business Process Maps for eRecruit Workflow.
• Developed Workflow PeopleCode for emails and worklists.
• Defined business process for email distributions, which included Create Job Requisitions, Applicant Activity, and Job Postings.
• Defined roles and permission lists for Manager and Applicant Self-Service.
• Created URL link to client’s web site for Recruit USA and job boards.
• Created custom pages and PeopleCode programs for Employee and Manager Self Service.
• Developed PeopleCode programs for Recruit Administration.
• Created SQL statements for query programs, database interfaces, and search views.

Senior Technical Developer

Atlanta, Georgia

• PeopleTools v8.42: App Designer, PeopleCode, SQR, SQL, SQLPlus App Engine, Component Interface, Security, Process Scheduler, Portal
• Created Fit Gap Analysis document for Administer Workforce job changes and Workflow design.
• Created custom records, pages, and menus for Workforce Administration, Employee Self Service, and Manager Self Service.
• Made PeopleCode modifications on record events and components.
• Designed Activity and Business Process maps for Workflow using both Manager Self Service and core application.

Confidential

Senior Technical Developer

New York, New York

Responsibilities:

• PeopleTools v8.17: App Designer, PeopleCode, SQR, SQL, SQLPlus App Engine, Component Interface, Security, Process Scheduler
• Created 12 Application Engine programs, SQRs, and Component Interfaces for a Department Reorganization batch process.
• Created custom pages and PeopleCode programs for Employee and Manager Self Service.
• Developed PeopleCode programs for Benefit Administration and HR customizations.
• Created SQL statements for Application Engine programs, database interfaces, and search views.
• Made custom changes to pages and menus, and created new components for modified pages.
• Assisted in functional and technical specifications for Canadian French modifications.