Professional Experience

Confidential

• 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:
• 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 People Code
• 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
• 1 Users, roles, permission list
• 2 Object security
• 3 Security tree
• 4 Portal security for PeopleSoft objects
• Functional:
• Project Costing
• Create Project, activities and transactions
• Project trees
• Budgets and Commitment Control
• Funding
• Procurement
• Integrate with GL
• Allocation
• Assets
• Archiving
• GL
• Creating journal entries
• Creating journal entries using Journal Generator
• Editing journal entries
• Posting journal entries
• Importing journals via files
• Intraunit and interunit entries
• Documentation:
• Gather requirements and create BRD Business Requirement Document
• Create TDD Technical Design Document
• Wrote UTS Unit Test Scripts
• Leadership:
• Conduct technical meetings with staff
• Conduct planning meetings with management

Confidential

MBI Security Clearance

Software: PeopleSoft CRM 8.8 sales marketing, BORM model , Implementation life cycle, Fit Gap Analysis, People Tools 8.43, Crystal Reports, DB2, Integration tools, PL/SQL, Full Software Lifecycle

Responsibilities:

• Functional:
• Setup Campaign budgets
• Setup Campaign event dates
• Setup Campaign owner
• Setup Campaign activities
• Setup Campaign tasks
• Setup Campaign teams
• Setup Campaign roll ups
• Setup Campaign trigger schedules
• Technical:
• 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
• Design Interface Applications
• Functional:
• Used Rose Modeling data flow diagrams
• Unit test and design test scripts
• Perform data validation
• Used STAT object tool to move objects through migration path

Confidential

• Highlight: PeopleSoft 8.8 Benefits, HR , Oracle, People Tools 8.43, Application Engine, SQR, Workflow. Built Employee Benefits Call Tracking System
• Technical:
• Analysis, development, test scripts, and testing on a in house Call Tracking Systems for employee
• 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

Confidential

MBI Security Clearance

• Software: PeopleSoft CRM 8.8 sales and marketing, BORM model , People Tools 8.43, Crystal Reports, DB2, PL/SQL
• Functional:
• Setup Campaign budgets
• Setup Campaign event dates
• Setup Campaign owner
• Setup Campaign activities
• Setup Campaign tasks
• Setup Campaign teams
• Setup Campaign roll ups
• Setup Campaign trigger schedules
• Technical:
• 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
• Design Interface Applications
• Functional:
• Used Rose Modeling data flow diagrams
• Unit test and design test scripts
• Perform data validation
• Used STAT object tool to move objects through migration path

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 Assign Employee Benefit
• Design/test applications to support Employee Add/drop Beneficiary
• Design/test applications to support Employee Add/drop Dependents
• Design/test applications to support Employee Personal Data
• Design/test applications to support Manager Approval of pay, vacation, etc.
• Design/test applications to support Manager Hires
• Design/test applications to support Manager Delegation of Authority
• 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
• Travel and Expenses
• Functional:
• Create expense report
• Create wallet transactions
• Create transactions via Hotel Wizard
• Create credit card transactions
• Manager approval
• Setup Interface with payroll
• Wrote Business Requirement Documents for Travel and Expense
• Wrote test script for Travel and Expense module.
• Performed unit testing for Travel and Expense module
• Documentation:
• Gather requirements and create BRD Business Requirement Document
• Create TDD Technical Design Document
• Wrote UTS Unit Test Scripts

Confidential

• Highlight: PeopleSoft HR 8.0, People Tools, MS SQL Server, Oracle, UNIX
• Technical:
• Design Interface App for benefits file into Payroll
• 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
• Setup user security Users, Roles, Permission List
• Portal Object Security Structure and Content
• Wrote SQR data conversion programs
• Wrote SQL scripts
• Functional:
• In charge of processing weekly, bi-weekly, monthly and yearly benefit compensation payment
• Daily interaction with end users to support the corporation's payroll system.
• Interact with business users to gather requirements
• Wrote BRD document based upon requirements
• Wrote technical specs based upon requirements
• Wrote test scripts based upon requirements
• Perform unit testing on modules
• Documentation:
• Gather requirements and create BRD Business Requirement Document
• Create TDD Technical Design Document
• Wrote UTS Unit Test Scripts

Confidential

• Highlight: PeopleSoft HR/Payroll 7.5, People Tools, OS390/DB2 database, Application Upgrade Convert Legacy system to PeopleSoft 7.0 HRMS, Cobol
• Technical:
• Used Application Designer to create/modify People Code, Pages, and Records
• Ran and analyzed PeopleSoft compare reports
• Wrote Cobol data conversion programs
• Wrote SQR data conversion programs
• Wrote SQL scripts
• Wrote JCL programs to execute jobs
• Used Import Manager for inserting data into tables
• Functional:
• Interact with business users to gather requirements
• Wrote BRD document based upon requirements
• Wrote technical specs based upon requirements
• Wrote test scripts based upon requirements
• Perform unit testing on modules
• Mainframe:
• Cobol
• JCL
• Navigate through ISPF editor
• Documentation:
• Gather requirements and create BRD Business Requirement Document
• Create TDD Technical Design Document
• Wrote UTS Unit Test Scripts