Summary

Over 10 years of experience as a Developer/Analyst/System Admin

Professional Experience

Confidential

System Admin

Highlight: TAMS Data Integration Project, People Tools 8.53.11, SQR, Mainframe DB2 JCL, SQR, Endevor , Data Warehouse, SharePoint, Quality Center

Technical:

• Technical support for testing 30 SQR conversion batch programs

Confidential

Highlight: TAMS Data Integration Project, People Tools 8.53.11, Application Package, Integration Broker, SQR, PS Query, People Code, Application Engine, Mainframe DB2 Endevor, JCL, SQR , Data Warehouse, SharePoint, Quality Center

Technical:

• Used Application Designer to create/modify People Code
• Wrote over 30 SQR conversion batch programs to support large volume flat files from IBM Kenexa to internal Data Warehouse
• Used Application Designer to create/modify Pages
• Used Application Designer for App Package code
• Wrote SQL scripts
• Wrote SQR Reports
• Wrote over 30 JCL conversion batch programs with job abend procedures to support large volume flat files from IBM Kenexa to internal Data Warehouse
• Used Integration Broker to transfer data asynchronous
• Wrote batch SQR programs to run on windows process scheduler

Functional:

• Wrote JCL restart documentation

Confidential

Highlight: PeopleSoft 9.2 LOA Benefits Integration Project, FSCM 9.2 PC, GL , People Tools 8.53.11, Upgrade from 8.4 to 9.1, PeopleSoft HCM 9.1, Admin Workforce, Base Benefits SQR, PS Query, People Code, Mainframe, SQL, Quality Center Test Tool, DB2 COBOL, JCL, SQR, Endevor , Clarity, Full Software Lifecycle

Technical:

• Technical Team lead for LOA Benefits Integration Project
• Work with end users to gather requirements
• Used Integration Broker to transfer LOA benefit data synchronous to external vendor's cloud application.
• Compared 8.4 People Code for accuracy to be integrated with 8.9 People Code for Financial Upgrade
• Wrote SQL scripts
• Wrote PowerShell script to stop and start NT servers
• Technical Team Lead for Cobol interface between Project Costing and external vendor Clarity

Functional:

Project Costing Module

• Create Projects
• Create Activities
• Create Transactions

GL

• Creating journal entries
• Creating journal entries using Journal Generator
• Editing journal entries
• Posting journal entries
• Importing journals via files
• Intraunit and interunit entries

Mainframe:

COBOL

JCL

ISPF editor

Documentation:

• Gather requirements and create BRD Business Requirement Document
• Create TDD Technical Design Document

Leadership:

• Conduct technical project meetings with staff

Confidential

Highlight: PeopleSoft FSCM 8.9 PC, GL , SDLC, System Admin, Fit Gap Analysis, 8.49 tools, Oracle 11g RAC, Integration tools, Unix Scripting, Data Mover, Component Interface, People Code, Application Engine, Mainframe, App Package, SQR, PS Query, Agile Development

Technical:

• Technical Team Lead
• Work with end users to gather requirements
• Built customized workflow approval for Purchasing
• Used Application Designer to create/modify People Code
• Used Application Designer to create/modify Pages
• Used Application Designer to create/modify Workflow
• Used Application Designer to create/modify Records
• Used Application Designer to create/modify App Engine
• Used Application Designer to create/modify Component Interface
• Setup user security Users, Roles, Permission List
• Wrote SQR data conversion programs
• Wrote SQL scripts
• Design Crystal Reports

Application Upgrade

1. apply patches using change assistant
2. apply bundles using change assistant
3. run compare reports
4. integrate/analyze custom People Code into delivered People Code
5. migrate code to environments

SYSTEM ADMIN

• Install PeopleSoft patches
• Build Web Servers
• Build App Servers
• Build PeopleSoft portals for test systems
• Troubleshoot Unix/NT server issues
• Create/Maintain Peoplesoft environments on Unix/NT servers
• Production support to ensure servers are running
• PeopleSoft Security

Confidential

Highlight: PeopleSoft Travel and Expense 8.8 Production Support, Oracle

• Production Support solved Remedy tickets created by end-user.
• Performed Analysis on end-user request, designed BRD documents
• Wrote SQL scripts

Confidential

Highlight: PeopleSoft HR 8.3, People Tools, MS SQL Server, DB2, Open Enrollment, Full Software Lifecycle

Technical:

Employee/Mgr Self-Service

• Design/ Test Open Enrollment applications for Base Benefits Dental, Medical, FSA, Dependent Benefits
• Design Employee/Mgr Self-Service
• Design/test applications to support Manager Delegation of Authority
• Design/test applications to support Manager Hires
• Design/test applications to support Manager Approval of pay, vacation, etc.
• Design/test applications to support Employee Personal Data
• Design/test applications to support Employee Add/drop Dependents
• Design/test applications to support Employee Add/drop Beneficiary
• Design/test applications to support Assign Employee Benefit
• Used Application Designer to create/modify People Code
• Used Application Designer to create/modify Pages
• Used Application Designer to create/modify Workflow
• Used Application Designer to create/modify Records
• Used Application Designer to create/modify App Engine
• Used Application Designer to create/modify Component Interface
• Setup user security Users, Roles, Permission List
• Portal Object Security Structure and Content
• Wrote SQR data conversion programs
• Wrote SQL scripts