PROFESSIONAL ASSETS
Total 20+ years of IT Experience with 15+ years of PeopleSoft Consulting,
specializing varioius applications in both HCM and FSCM
PeopleSoft HCM Version 9.0 Experience. PeopleSoft FSCM Version 8.9 Experience.
Extensive experience in both Technical and Functional areas; capable to put on
several “hats” as a Technical Developer, or a Business Analyst, or a QA tester or
a Project Coordinator.
Experience in Full Life Cycle of Implementation: User Requirement, Fit Gap
Analysis, Designing, Developing, Testing, Integrating, and Training.
Extensive experience with PeopleSoft in application configuration and system
set up.
Extensive experience with PeopleSoft Implementations, Upgrades, Bundles and Tax
updates.
Extensive experience in Sub-system consolidations and/or Transferring existing
data from legacy system to PeopleSoft application database tables using SQRs,
Component Interfaces, Application Engines & File Layouts.
Extensive experience in working with interfaces using Application Engine
programs and SQR’s.
Expertise in writing and Tuning SQL’s for performance improvement.
Experienced in Developing and customizing several reports using SQR, Crystal and
nVision.
Experienced in writing inbound and outbound interfaces using Integration
Broker.
Implementation , Maintenance, Production support of large applications.
Working knowledge of PeopleSoft Security, System/Record Audit, PS Security
Tree.
Working knowledge of Mainframe to PeopleSoft conversions.
COBOL Reports to SQR Reports and COBOL Processes to AE.
Extensive experience to consult/assist end users throughout QA process, data
validation, system integration test, user acceptance test, parallel testing and
user training.
Extensive experience to guide end users throughout merger payroll process, Tax
Audit, W-2 year-end processing, Benefit Open Enrollment, New Vendor
Implementations.
Excellent communication, presentation and training skills.
Ability to be an effective team player, work under time constraints and easily
adaptable to new environment.
Ability to work independently, remotely when nescessary.
TECHNICAL EXPERIENCE
PeopleSoft: PeopleSoft v 9.0/8.9/8.8/8.3/8.0/7.5/5.0/4.0
Modules: HCM: HR, Global Payroll, NA Payroll, Benefits, Payroll Interface,
T&L, E-Benefits, E-Pay, E-Compensation, eProfile, E-Recruitment, PS Global
Absence Management, Stock Administration, TAM, PS Security and PS Training; FSCM:
Financial GL, Project Cost, Grants.
People Tools: Application Designer, People code, App. Engine Program, Component
Interfaces, Process Scheduler, Application Package, Workflow, Query, Maintain
Security, Object Security, Tree Manager, Data Mover, Application Messaging,
Integration Broker, Upgrade Assistant, etc.
Reporting: SQR, PS Query, XML Publisher, Crystal Report, Easytrieve, MS-Project,
MS-Office, Visio, and nVision
Languages: COBOL, JCL, XML, SQL & SQL/SQR
Operating Systems: UNIX, ORACLE, Win 98/NT/2000/XP, IBM-Compatibles, MS-DOS.
IBM: COBOL, DB2, JCL, MVS, TSO/ISPF, ENDEVOR, VSAM, SAS, Dun and Brad Street
M:SDT, Millennium PDL, CA-7, etc.
Database Systems: Oracle 9i/10g, INFORMIX, SQL Server 2005.
Analysis and Debugging Tools: SQL Server, SQL+, SQL Tool, Toad, PS Query
EDUCATION/TRAINING
Completed courses in Certified Internet Web Master Program at Florida Atlantic
University.
Introduction to Human Resources, Introduction to Benefits, Introduction to
Payroll, PeopleTools I&II, PeopleCode, SQL/SQR, PS Query.
BA, Business Management, National-Louis University.
AAS, Computer Information System, Programming Specialization.
AAS, Computer Information System, Technical Support Specialization, Northern
Virginia Community College
PROFESSIONAL EXPERIENCE
PeopleSoft Functional-Technical Consultant
Queen Medical Center, Hawaii (October 2009 – Present)
Assist Queen Medical System (QMC) End Users to evaluate HCM TAM 9.0,
E-Recruitment to customize and stream line Queen Medical System hiring and
security process. Create new Pages, Components and People codes for different
views based on new security. Expertise on writing SQL’s for creating view data.
Utilized in PS Security to set up security based on different level of
managements and tasks. Involved in various rounds of Testing with proper
documentation to meet QMC standards. Involved in creating and Modifying System
Design Specifications, System Requirement Specifications. Expertise on writing
Unit Test Cases, Unit Testing. Utilize PeopleTools, PeopleCode, Application
Engine, File Layout, Component Interface, and Microsoft SQL Server to develop
customization procedures.
PeopleSoft Functional-Technical Consultant
The School Board of Lee County District, Fort Myer, FL (March 2008 – February
2009)
Involved in user requirement and design fit gap sessions to gather system
requirements for the implementation of PS Global Absence Management, Payroll, Ben
Admin modules, 8.9 version. Developed all deliverable documents such as Fit Gap
Solutions, Design Document, Function Specs, and Technical Specs. Set up
application system including Employee SS and Manager SS. Worked with outside
vendor such as Vanguard, Citibank to evaluate user requirements, to research and
design specification for implementing PS Stock Administration and re-writing 401K
interface process. Worked with Assisted in Conversion, Customization, and
Development process utilizing PeopleTools, PeopleCode, Application Engine, File
Layout, Component Interface, XML, Workflow and Microsoft SQL Server to test
conversion data, to customize the system, and to produce report. Develop Test
plan, Test Scenarios, Test scripts and work with End User throughout Integration
Test, System Test, and User Acceptance Test.
Software Developer Consultant
BSO, Fort Lauderdale, FL (August 2006 – February 2008)
Assisted with the implementation of the PeopleSoft Financial GL utilizing
PeopleTools, PeopleCode, Application Engine, File Layout, Component Interface,
ORACLE SQL tool, Crystal to convert data from SAS, customize the system, and
produce report. Developed and modified GL interface, AR and Billing, Grants,
Project Cost interface system. Customized 8.9 E-Benefits, E-Pay, E-Compensation
and eProfile; utilizing PeopleTools, PeopleCode, Application Engine, Work Flow.
Completed technical documentation for related developments.
Sr. Consultant
General Electric, Fort Myers, FL (January 2006 – August 2006)
Proficient in both Functional and Technical role in PS Global Payroll, Time and
Labor to validate the interface T&L and
Payroll files. Reviewed current Functional Design Specs and compare against the
test files to determined discrepancies to update the Functional Spec. Reviewed
production schedule to design, develop, and QA test a dynamic parameters
program; which automatically creates the run controls to submit jobs. Utilized
PS Query for QA test in Global Payroll Functional Unit Test and System
Integration test. Developed user procedures training manuals for client to be
prepared for their parallel test and final implementation
IS Project Lead/ Benefit - Payroll Business Analyst.
Philips PACE, Palm Beach Garden, FL (August 2001 – January 2006)
Benefits Project Lead: Managed new benefit implementation project, Benefits
Administration Open Enrollment, and HIPPA compliance transition project.
Coordination between the Functional User Groups, Benefits/Payroll Vendors
(Metlife, Caremark, BCBS, UHC, VSP, CIGNA, Citibank, Mellon) and the IS Groups to
evaluate user requirements, to research and design specification for converting
Benefit interface files to the ASC-X12-834 Benefit Enrollment and Maintenance
Transaction Set - HIPAA compliance. Development of the project plans to include
both functional benefits/payroll and IS activities. Called upon other IS
personnel to assist with the projects. Coordinated and insure IS Groups to be
aware of the project plan deadlines. Communicated changes in the project plan
activities and due dates to appropriate personnel. Communicated to IS management
any project issues which are impacting the project plan deadlines. Developed
documentation and coordination of Functional Specifications, Technical Specs and
QA test scripts. Worked with Payroll Tax Managers to gather requirements for Tax
Audit, W-2 process. Worked with Production Control to coordinate in applying tax
updates.
Payroll/Finance Analyst - Proficient in both Functional and Technical role in PS
Global Payroll, Base Benefits and Benefits Administration to involve in company
conversion process. Worked with Vanguard, Citibank and Equiserve, Stock Brokerage
Vendors, and Philips Management to evaluate user requirements, to research and
design specification for implementing PS Stock Administration and re-writing 401K
interface process. Utilized SQL/SQR, PeopleCode, PeoleTool to modify in house
timesheet load to PS Payroll, Bank Reconciliation, Benefits Administration
customization, and GL reconciliation process. Provided technical training to
functional colleagues due to the reorganization transition.
General Business System Analyst – Worked with team to upgrade from 7.5 to 8.8.
Maintained up-to-date knowledge of developments within area of expertise.
Re-engineering of daily processes. Assist and develop process improvement
initiatives. Identified issues and risk areas and assist with moving them toward
resolution. Reviewed the overall quality of processes and procedures. Ensured
compliance with established business controls. Ensured that other departments and
PACE management personnel are made aware of issues, which may affect processing
quality and metrics, and which, may have customer impact.
Served as a point of contact to the client for software functionality and
capability. Ensured consistent and ongoing communications of process improvement
opportunities. Maintained effective communications with customers, internal PACE
departments, and other Philips divisions to identify and resolve issues, and to
ensure prompt issue resolutions. Conducted meetings with customers and other
Philips business entities as appropriate and provides them with counsel,
coordination, and issues recommendations related to competencies and capabilities
of software functionality and process enhancement opportunities. Coordinated
project activities between the various internal IS groups. Coordinated technical
specifications development with Application Support Group. Facilitated a smooth
transition of software enhancements and functionality to production/operations.
Participated in QA testing of software enhancements/changes. Contributed to the
professional development of others through mentoring, education, and
knowledge-sharing.
Senior Programmer Consultant (October 1996- July 2001)
Citrix, Fort Lauderdale, FL (February 2001 July 2001)
Involve in Benefits Administration Event Maintenance and Payroll Interface
processes. In charge in maintaining Department Security Tree, responsible for
system maintenance, troubleshooting, and production support. Gather user
requirements and develop design functional/technical/test case specifications for
new requirements. Utilized PS SQR, Query, Crystal, MS Access to develop
HRMS/Benefits reports.
FedEx, Memphis, TN (October 2000 January 2001)
Developed Check Reversal Batch Process that enables FedEx to submit a high
volume of check reversals without online-interaction. Modified Tax Annual
Reports. Utilized SQR, PeopleCode, PeopleTool to customize in house system and
provide production support. Developed design functional and technical
specification, sources and test benefits interfaces.
MD Anderson, Houston, TX (June 2000-September 2000)
Evaluated current system, PS version 7.0 against PS version 7.5 to determine the
business solution for de-customizing in houses system to bring it back to vanilla
PS system which enable client to reduce cost for future upgrade. Provided
production support. Developed design specification, sources and test benefits
interfaces.
Intersil, Melbourne, FL (December 1999-March 2000)
Proficient in HRMS, PS Base Benefits module, 7.51 version to provide production
support and re-customizing Intersils HRMS system. Applied fixes and application
updates.
The New York Times, Norfolk, VA (September 1999 December 1999)
Familiar with PS Benefit Administration to customize and/or provide production
support for flex benefits program at Open Enrollment and Event Maintenance
schedule.
Talbots, Tampa, Florida (April 1999 September 1999)
Knowledgeable in PS Human Resources and PS Base Benefits module, 7.5 version to
provide production support. Worked with Benefits user and the carrier to analyze
and develop 401K interface.
Price Waterhouse Cooper, Tampa, Florida (June 1998 April 1999)
Proficient in PS Payroll, PS Human Resources and PS Base Benefits module, 7.5
version to assist Payroll/Benefits mangers to determine business rules to set up
PWC HR/Payroll/Benefits systems. Analyze PWC Payroll/Benefits mainframe legacy
system to utilize Convoy software application (data migration tools) for mapping,
setting up condition rules, generating COBOL programs to extract legacy data, and
generating SQR to load data into PS Payroll/Benefit system. Develop addition SQR
programs to handle complicate calculations and routines which are not handle by
Convoy software. Develop interface and conversion specifications. Assist users on
conversion data validation.
USDA, Riverdale, Maryland (March 1998 August 1998)
Proficient in PS Payroll Interface to set up Payroll related tables, Interface
System, Fields, Instances, Definition, File Handles, Interface Group Ids,
Configuration Tables, and Employee Ids tables. Provided assistance to client in
Payroll Interface processing. Analyzed National Finance Center (NFC) requirements
to set up and customize 7.0 Payroll Interface System Federal Version. Familiar
with Government Personnel Action, Position Management Structure and Payroll
Interface process to perform a full test cycle to ensure data integrity to
interface between USDA-HR and NFC.
AccuStaff, Jacksonville, Florida (October 1996 January 1998)
Assisted Payroll managers to adjust payroll balances and to set up Company tax
data, Tax parameters, Tax Form Definition for Year End and W-2 processing.
Implemented tax upgrade. Redesigned Leave Accrual system. Customized Pay Check
and Advise. Set up direct deposit system. Familiar with payroll files to
map/extract payroll data to export/import from/to PeopleSoft system and other
system. In charge of maintaining and resolving production problems.
Developed/customized payroll menus, panels, SQR reports.
Assisted Benefits User to determine requirements for setting up 401K, Deferred
Compensation plan, Health Benefit plan. Analyzed specification and developed 401K
eligibility report, 401K Contribution, 401K Loan Repayment and Health Deduction
interface file. Developed/customized Benefits menus, panels, SQR reports.
In charge of Application Upgrade, Security Tracking and Data Integrity. Applied
Tax Update. Set up Audit Trail and developed Audit report to capture Personnel
activities in particular time frame. Set up User Security. Developed SQR programs
to standardize Location and Establishment table and to merge employee records
when duplication occurred. Developed/customized HR menus, panels, SQR reports.
Programmer Consultant
Business Information Technology - (January 1995 - October 1996)
Fisher Price/Mattel (SHL), Buffalo, New York - (August 1996 October 1996)
Map all fields and tables from Fisher Prices system to PeopleSoft system.
Analyze and design interface file specifications for external systems.
Florida Power, St. Petersburg, Florida - (April 1996 August 1996)
Assisted with the implementation of the PeopleSoft HR, utilizing PeopleTools,
PeopleCode, ORACLE SQL to customize on-line Human Resource system. Developed and
modified SQRs to produce personnel reports.
Tower Perrin, Philadelphia, Pennsylvania (January 1996 March 1996)
Utilized PS PeopleTool and PeopleCode to customize in-house requirements for
PeopleSoft Benefit system.
BIT Main Office, Pennsylvania (November 1995 December 1995)
Developed BIT training materials which are used to conduct technical workshop
for clients.
TRW Inc, Fairfax, Virginia. (May 1995 October 1995)
Assisted with the implementation of the PeopleSoft HR/Payroll system. Utilized
SQL/SQR to develop personnel, payroll and labor journal entry reports. Analyzed
and mapped all fields and tables for conversion purpose. Utilized PeopleTools to
establish an archive audit system.
AAA - American Automobile Association, Orlando, Florida. (February 1995 - May
1995)
Developed SQRs to replace personnel reports that are produced by AAAs current
human resources system.
Programmer Analyst
PRC Inc. Mclean, Virginia. (November 1993 - January 1995)
Involved in implementation of PeopleSoft HR/Payroll/Benefits system from
Mainframe D&B HR/Payroll/Benefits. Assisted in mapping data, tables and initial
data population utilizing ORACLE SQL/SQR, PeopleCode, PeopleTool. Modified
delivered PeopleSoft SQR and developed new SQR to accommodate in-house system.
Programmer Analyst
Baylor Health Care System. Dallas, Texas. (October 1992 - November 1993)
Responsible for analysis, design, programming and testing of human resource
system conversion and upgrade for their D&B:HR. Utilized SDT/PDL and batch COBOL
to customize the D&B system to accommodate Baylors requirements. Involved in all
phases of the system life cycle from analysis and specifications to building test
data, creating testing and implementation plans and providing final
documentation.
Programmer Analyst
PRC Inc. Mclean, Virginia. (June 1989 - October 1992)
Provided design, programming and testing support HR/Payroll/Benefit, utilizing
COBOL, D&B M:SDT and Millennium PDL. |