PROFESSIONAL ASSETS

• Total 20+ years of IT Experience with 16+ years of PeopleSoft Consulting, specializing varioius applications in both HCM and FSCM
• PeopleSoft HCM, FSCM Version 9.0, 9.1 experiences.
• 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 necessary.

TECHNICAL EXPERIENCE
PeopleSoft: PeopleSoft v 9.1/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, Time and Labor, E-Benefits, E-Pay, E-Compensation, eProfile, E-Recruitment, PS Global Absence Management, Stock Administration, TAM, ELM, PS Security and PS Training; FSCM: GL, AR and Billing, AM, 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,, 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
Introduction to Human Resources, Introduction to Benefits, Introduction to Payroll, PeopleTools I&II, PeopleCode, SQL/SQR, PS Query.
BA, Business Management.

PROFESSIONAL EXPERIENCE
Confidential,Technical Consultant (Semi-Remote work)
(July 2010 – Present)
Involve in user requirement, fit gap design to provide future solutions to complex requirements with upgrade simplification in mind; Develop Business Requirement Document, Technical Requirement Document for the implementation of PS Core Time and Labor. Perform T&L rules and Approval Process set up. Understand Data Architecture of the in house system to map and perform Data reconciliation for Company Subsidiary Merging/Conversion. Analyze current in house interface files to identify the requirements for new interface files under the PS system. Identify the impact to the internal, external system, and requirements to convert employee’s pay frequency. Analyze, identify requirements, design and develop interfaces to audit payroll data, to upload timesheet from various systems to maintain integrity and eliminate manual work for the business processes.

PeopleSoft Functional-Technical Finance/HR Consultant (Remote work)
Confidential,Hawaii (November 2009 – July 2010)
Assisted Queen Medical System (QMC) End Users to evaluate HCM TAM, E-Recruitment to customize and stream line Queen Medical System hiring and security process. Created 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. Utilized PeopleTools, PeopleCode, Application Engine, File Layout, Component Interface, and Microsoft SQL Server to develop customization procedures.

Financial Functional-Technical Consultant (Semi-Remote work)
Confidential, (February 2009 – November 2009)
Expertise in PeopleSoft Finance to offer comprehensive solutions to manage client’s business processes of AP/AR/BI/GL/PO/PC requirements with well detailed Technical designs. Worked on GL-Consolidation business process Flow with combo edit Analyzed system interfaces and design detail specifications to implement GL interface files to various systems. Developed PS Interfaces utilizing SQR, Application Engine, Component Interface and File Layouts. Performed Application tuning for AM and GL modules. Insured that requested customizations are necessary for business reasons and if so that they are implemented with least impact possible with future patches and upgrades in mind.

PeopleSoft Functional-Technical Consultant
Confidential, 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, Time and Labor, Ben Admin, ELM modules. . 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. Provide technical leadership in the support of Asset Management, Accounts Payable, Project Costing, General Ledger 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.

Financial/HR Developer Consultant
Confidential,FL (August 2006 – March 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, eProfil. Upgrade FSCM 8.8 to 9.0, utilizing PeopleTools, PeopleCode, Application Engine, Work Flow. Completed technical documentation for related developments.

Sr. Consultant
Confidential,FL (January 2006 – August 2006)
Proficient in both Functional and Technical role in PS Global Payroll, Time and Labor to validate the interface Time and Labor 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.
Confidential,FL (August 2001 – January 2006)

• Payroll/Finance Analyst - Proficient in both Functional and Technical role in PS Finance AM, AP and GL to involve in company conversion process. Assessed and adjusted Nightly batch processing for AM, AP and GL. 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.

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.

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)
Confidential,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.