SUMMARY:

• Extensive knowledge and skills in full system life cycle including applications upgrades, functional analysis, technical development, systems design and implementation.
• Over twenty years of information system experience in ERP implementation and integration of new and existing systems in Public Sectors (10+ yrs.), Healthcare (5+ yrs.) & Auto Industries (10+ yrs.). Qualified and certified technical system integrators in all levels of PeopleSoft’s modules and business processes.
• Over twenty years of information system experience in ERP implementation and integration of new and existing systems. Qualified and certified technical system integrators in all levels of PeopleSoft’s modules and business processes. Experience in PS/HRMS version 2.7 to 9.2
• PeopleSoft Advanced HCM/App Designer, SQR, Component Interface, Application Engine
• Oracle FMW/AIA/Foundation Pack/PIP
• Developed Functional and Technical specifications for Data Conversion and Systems Applications.

TECHNICAL SKILLS:

SDLC Methodology: Waterfall/Agile

Mainframe: OS390, CICS

Programming and Tools: Cobol, SQR, Java, XAI(XML), Eclipse/WebLogic, AIA, Visual.Net, C#, MVC, ASP.NET,HTML5, JavaScript

RDBMS: SQL Server, Oracle 11g, DB2

Reporting Tools / Job Scheduling Tools: SQR/SQL, Crystal Reports, PS Query, Mercury Test - Director, STAT 610, AutoSys, BI Publisher

PeopleTools: Version 4.0 - 8.5.6

Application: Engine, Application Package, Application Designer, BI Publisher, Workflow, PeopleCode, Component Interface & Integration Broker.

ERP: PeopleSoft Advanced HCMS 9.2, ADP TotalSource/EV4, Mainframe Business Apps HR, Payroll, Benefits, ESS, MSS, T&L, Compensation, Interface, Recruitment, Admin Workforce, Utilities, Automotive Industry

PROFESSIONAL ENGAGEMENTS:

Senior Technical Developer/Consultant

Confidential, Albany, New York

Environment: PeopleSoft 9.2, PeopleTools 8.55/8.56, Oracle 11g, Unix, NT, Citrix, SQL Developer, STAT, HPQC 11.52, JIRA

Responsibilities:

• Currently Retrofitting/Redesigning the 9.1 W4 Tax/ePay Self Service into 9.2 new functionality. Design requires creating new App Package/Methods/Classes/Component/Special Functions to in corporate custom fields and requirements to delivered PDF Online Tax Forms in 9.2. The process uses the delivered API setup to send/receive XML data between PDF Forms and PeopleSoft staging tables.
• Developing new component for JOB DATA REHIRE that requires integration of new logic into existing JOB DATA component.
• Developing Technical Design documents for upgrading custom 9.1 objects and processes to 9.2 for HRMS/Payroll/Benefits. Functional group review the technical document prior to development and testing.
• Developing new App Engine processes and retrofitting new requirements into existing SQRs/Cobol Payroll Processing.

Senior Technical Developer/Consultant

Confidential, Oakland, California

Environment: PeopleSoft 9.2, PeopleTools 8.55/8.56, Oracle 11g, Unix, NT, Citrix, SQL Developer, STAT, HPQC 11.52, JIRA

Responsibilities:

• Involved in App Dev implementation from writing Technical Design documents, development, testing through production support for UCOP (Administration Staff), Pilot (UCLA,UCR, UCI,UCM,UCD,UCSF,UCB) and D1 for the following universities, UCSB, UCSD, UCB, UCSC,University of Hastings to be completed by the end of December 2018. The Applications are in HR, Benefits, Payroll, Retirement and TAM.
• Designed technical solutions and developed Technical specs document for Off-shore development. Coordinated with Offshore from assigning the TDD for development through testing the changes onshore.
• Developed Retirement Interface modules for PeopleSoft. Tasks include Designing, Developed, testing and implementation all processes, objects and functions based on the Functional Design Documents.
• Developed Inbound and Outbound Interfaces to third party.
• Developed Integration Broker through SOA/PeopleSoft for Webservices. Also, developed Application Package Handlers.
• Participated in Development, FUT, System testing & Implementation.
• Worked on AM/Payroll/Benefits/HR/Retirement.
• Worked on several AWS objects when hiring employees.
• Involved in Data Conversion of HR and TAM’s location tables using SQL Scripts, Application Engine, Application Package and CI.

Senior Technical/Functional Consultant

Confidential, Portland, Oregon

Environment: PeopleSoft Advanced HCMS 8.9 - 9.1, PeopleTools 8.52.07, Oracle 11g, DB2/Mainframe, Unix, NT, Citrix, SQL Developer, DB2 Connect

Responsibilities:

• Developed Application Engine processes calling delivered CI for Job and Position to apply the Mass Update for Domestic and International Merits Increases, new Salary Admin Plan, Grade, Step, Position, Comprate and ComprateCd.
• Retrofitted SQR programs from Mainframe to Windows. Remediated the logic to use Oracle database instead of DB2.Rewrote custom mainframe functions to be available in PS windows.
• Modified and created new JCL to transfer files for Inbound and Outbound files - TSO TCI/IP
• Modified Cobol programs to synchronize the new business requirements applied in PS Windows environment.
• Participated on root causing issues during UAT of PS 9.1 Payroll, Benefits, Compensation and HR.

Senior Technical/Functional Consultant

Confidential, Folsom, CA

Environment: PeopleSoft Advanced HCMS 9.1, PeopleTools 8.52.07, Oracle 11g

Responsibilities:

• Developed SQR, CI and Application Engine programs integrating Inbound and Outbound data from and to Taleo/PeopleSoft. Modified delivered Application Package related to Personal Data/Job.
• Developed AE/PeopleCode HR, Benefits andPayroll Interface to ADP and SAP, and other 3rd party vendors.
• Worked on retrofitting SQRs, PeopleCode, Appl Engine and CI processes from PS V8.8 to 9.1
• Modified the ESS (Empoyee Self-Service) for employee profile, ePay and eBenefits.
• Participated in the Fit/Gap analysis to map business requirements to existing PeopleSoft Inbound and Outbound processes. Programs developed in SQRs an Application Engine.
• Created high-level flow of the current business process, and detailed design specifications to the proposed tools.
• Worked with offshore companies (Malaysia and India).
• Developed AE processes for UCOP - TAM, HR, Payroll and Benefits.
• Developed AE/SQL Scripts during data conversion of TAM. Created Conversion Technical Design Document.

Senior Technical/Functional Consultant

Confidential, Newport Beach, CA

Environment: PeopleSoft HRMS 9.1, PeopleTools 8.51, SQL Server 2008

Responsibilities:

• Developed PeopleCode that synchronize a custom Job Headcount scroll/table when there are split distribution of earnings for multiple departments and business units.
• Assisted end user(s) in analyzing, researching and proposing the highest quality solutions in day-to-day issues and problems. Captured and translated functional specifications into technical specifications/design. Provided feedback regarding effort estimates, complexity and feasibility when changes in original design and development are required to meet evolving business requirements
• Developed ePay, eBenefits and eProfile (Employee Self-Service) with workflow approval.
• Post Production support on Deductions issues, daily problems and questions, Created Interface files to Financials.
• Benefits (Base Benefits / Ben Admin)
• Post Production support on issues encountered in PSPBARUN/BAS005 process. One of the features of 9.1 is hiring temporary employees and keeping the same employee ID. Employee’s benefits participation is not getting populated properly and BAS Activity is getting deleted when Ben Admin process is executed.
• Configured the Setup for Empl Class/ScheduledID/Class Events/Even Rules ID/Benefit Programs/Plan types that are requirements to process Ben Admin.
• Developed SQR programs that interface with the 3rd Party Providers for ESPP, VSOP, Life, Savings, Dental, Medical and Disability. Processes were also incorporated into Process Scheduler.

Principal Consultant/Functional Designer

Confidential, Redwood, CA

Responsibilities:

• Developed Use Cases designs and scripts that contain business data, exception and alternative flows of the proposed processes (Level 3 of Workbench tools).
• Developed Scripting process that integrates student information from the ‘Student Loan System’ to OPA, Siebel, Fusion and existing reporting systems of NZ IRD using AIA 2.5/ Foundation Pack/PIP components and objects.
• Involved in analyzing, designing and development of the data integration between the Tax Billing and Payments processes to Financial System using Foundation Pack and PIP components an objects.
• Assigned to Post-Production support for testing and applying bugs and fixes. Enhanced the performance issue of the system by reviewing the codes, testing, data structures, and design issues.
• Participated in the walk-through of the business processes and requirements. Developed Level 4 diagram that contains high level solutions for the business requirements. Reviewed the Swim-lane, Level 1, Level 2 and Level 3 diagrams with CGI analysts and Kentucky project team members.
• Redesigned and developed Prototype for Correspondence using Eclipse tools and Scripting.

Sr. Functional/Technical Consultant

Confidential, Pasadena, California

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.45, Mainframe/DB2, OS390

Responsibilities:

• Performed performance testing for calculating FLSA, and executing the SQR programs through the Mainframe JCL, and coordinated with EPM/ETL team on any data loading issues.
• Participated in QA/Parallel/Functional testing of Payroll, Benefits (FLSA) & Time system.
• Administered the PeopleSoft “OneLink” system.
• Supported the QA testing group to resolve issues entered by users in the change request logged through the Mercury Director System.
• Assessed the impact of production support issues on current environment, and escalated to management in accordance with severity.
• Performed functional and technical analysis to identify the risk on the proposed and recommended solutions.
• Provided feedback regarding effort estimates, complexity and feasibility to resolve issues on the Change Control Management.

Sr. Technical Lead Consultant

Confidential, Anaheim, CA

Environment: PeopleSoft HRMS 8.8, PeopleTools 8.45, Oracle 9+

Responsibilities:

• Provided technical and functional support for Peoplesoft HRMS software modules (Payroll, Ben Admin, Time and Labor, HR), by maintaining Application Engine, Component Interface, EIP (Enterprise Integration Point) and SQR processes.
• Participated in the Data Conversion of Ceridian into PeopleSoft.
• Developed SQR programs, SQL Queries and PeopleCode that were incorporated into Application engine processes that load the data from PCN, XPIENT Time and Labor into PeopleSoft. Transaction records contain all different Action codes from Hire through Termination. G/L Interface to Financials.
• Implemented ADP process for the Taxes.
• Administered PS HCM/Payroll/Benefits/Portal applications.

Sr. Technical Lead Consultant

Confidential, Pleasanton, CA

Environment: PeopleSoft HRMS 8SP1, PeopleTools 8.18.14, Oracle 9

Responsibilities:

• Involved in customization, resolving outstanding Payroll/Base Benefits (i.e.; Cobra) issues and implemented new modules
• Re-applied customized changes (i.e., menus, pages, components, peoplecode, SQRs)
• Resolved and Implemented new modules for Payroll/Benefits (i.e., 401K Max Limit, Manual/Bank Reconciliation).
• Administered PS HCM/Payroll/Benefits/Portal applications.

Sr. Technical Consultant

Confidential, Azusa, CA

Environment: PeopleSoft HRMS 8SP1, PeopleTools 8.18.14, DB2, OS390

Responsibilities:

• Data Mapping and conversion of the current Legacy Business Applications programs to PeopleSoft
• Converted the Legacy systems into SAP.
• Developed PeopleCode, WorkFlow and Application Engine/Component Interface for the custom Self-service, epay, direct deposit, personal profile, taxes and leaves.
• Assigned in reviewing and creating remediation plan for SOX requirements.
• Administered PS HCM/Payroll/Benefits/Portal applications.

Sr. Technical Consultant

Confidential, Berkeley, CA

Environment: PeopleSoft HRMS 8.3/8.4 PeopleTools 8.4x, DB2

Responsibilities:

• Developed customized Peoplecode logic to directly apply changes to Employee Self Service (ePay, eRecruit, eBen, eProfile, Direct Deposit).
• Created Roles and Permissions for employee self-service.
• Developed a workflow notification of changes to department head based on employee’s deptid replacing the delivered workflow approval.

Sr. Technical Consultant

Confidential, Seattle, WA

Environment: PeopleSoft HRMS 7.2/8.3/8.4, PeopleTools 8.4x, DB2

Responsibilities:

• Upgraded 7.5 to 8SP1/8.3/8.4 (Public Sector)
• Created new roles and permissions for all users
• Coordinated technical and functional issues with users in development and implementation of Self-Service (ePay, eBen and eRecruit).
• Involved in setting up the SQL Servers and NT environments related to migration and change control issues.
• Modified existing SQR programs, Peoplecode and panels for HRMS, Base Benefits (i.e.; Cobra), Payroll modules, and Payroll Interface to Financials (G/L).
• Applied Updates/Fixes and Tax Updates 01G through 02F
• Coded and implemented an SQR program that converts and identifies employees’ Job Indicators for multiple jobs. The logic determined the appropriate job to be flagged as primary, based on a pre-defined set of criteria ( i.e., FTE Hours, Job Codes, Base Benefits, Employee Type, Employee Class, Employee Record Number).

Sr. Technical Consultant

Confidential, Irvine, CA

Environment: PeopleSoft HRMS 7.x/8.0, PeopleTools 8.x, SQL Server

Responsibilities:

• Administered the PS systems; Applied Tax Updates for year 2000 & Post Production Support.
• Created and developed ADP Payroll Interfaces using the PS delivered modules for Calculated Deductions, Export and Import.
• Created Interface programs for PS/HRMS to company’s Web HR systems for Bank of America and BP Gas companies.
• Developed SQR programs for G/L and Payroll Interface.
• Retrofitted SQR programs, PeopleCode, Menus, Components, Pages, Application Engine processes during the upgrade from 7.2 to 8.0.
• Established standard techniques for comparing SQRs/SQCs, COBOL programs, Application Engines, Mass Change Statements, Queries and Crystal/nVision.