SUMMARY:

• Designed and executed process of assembling system test database taking components from a production database as well as development, configuration and conversion databases.
• Combined multiple pending Tax Updates into one to minimize process and impact in ongoing development.
• Troubleshoot multiple components of the HRMS systems and customizations, including Incentive Compensation Module, Payroll, HR, Benefits and Benefits Administration.
• Support programmers in tuning SQL statements for execution within SQLPlus and SQR.
• Support end users in resolution of PS Query performance and other issues.
• Developed initialization script in Kix for a Development Winframe environment.
• Designed and developed a process to compare Foundation tables' data between two databases and allow functional users to synchronize a production environment with ongoing development efforts.
• Planned and executed the application upgrade to HRMS 7.51. Activities included preparing technical infrastructure by installing the new delivered components over a copy of the existing software, setting up the Unix and Windows environment (libraries), executing database comparison reports to identify customizations by the client and new functionality in the new release, review comparison reports with application team members, execute object merge processes, troubleshoot issues as a result of merging clients customizations and PeopleSoft’s new functionality and moving the upgraded database and libraries (SQRs, Cobol and other programs) to production.
• Developed a process to scan all date fields, within the production HRMS database, for suspicious values during the Y2K transition.
• Designed and implemented a PeopleSoft HRMS Reporting Database for exclusive use of Queries by End Users. The Database is being refreshed on a nightly basis. Developed/Adapted Unix processes to be controlled by Maestro (Tivoli’s Unix scheduling system) to support the data refresh of the Reporting database.
• Setup and test maestro recurrent jobs to synchronize cross - platform processes.
• Performed DBA tasks such as Bring up and Shutdown Databases, Setup Application Servers and Process Scheduler Servers in Unix, perform database Exports and Imports, Setup database links, copy and refresh Peopletools system and data tables as well as evaluated the Oracle database security setup in Production, Development and Test Environments.

PROFESSIONAL EXPERIENCE:

Confidential, New Orleans, LA

Senior Technical PeopleSoft/CSS HRizon Consultant

Environment: Record, Panel, Menu Designers/Editor, Operator Security, SQR, Oracle-SQLPlus, WinFrame - NT, Keditw, MSOffice Word & Excel, etc.

Responsibilities:

• Participated in a conversion effort from a legacy system (MSA/GEAC) to CSS/HRizon Release 8. Developed conversion processes to load payroll and benefit employee enrollment data as well as custom Pension data using SQR, SQL Scripts and Import utility. Developed additional SQL scripts to perform post load data validation and allow client to clear data issues.
• Provided technical advice to team members during the conversion development effort.
• Devised a mechanism to allow data verification independently from row level security constrains.
• Developed various Demographic Data interfaces (SQRS) from the core employees' tables JOB, and other Foundation tables to 3 separate legacy systems.

Confidential, West Palm Beach, FL

Senior Technical PeopleSoft Consultant

Environment: Peopletools (application designer), Process Scheduler, PS Query, Unix Scripting language (Ksh), SQRW and SQR Unix, Oracle SQL Plus, Lotus Notes, Kedit for Windows, LAN Work Place Pro, Windows 95, Windows NT, HP Unix, amongst others.

Responsibilities:

• Technically lead the efforts to certify the PeopleSoft environment for the millennium.
• The assignment included evaluating the PeopleSoft Technical Architecture (2-tier and 3-tier) under a HRMS 7.0 / HRMS-Pension 7.5 environment for a planned time travel test which includes testing dates beyond 12/31/99.
• Development of automated tools to scan custom processes (SQRS and Unix Scripts) for potential y2k date issues.
• Analyze custom processes identified as critical business processes, including internal and external interfaces, with potential y2k date issues.
• Organize and lead users for development of test plan and cases focusing on y2k issues. Identify non-y2k compliant third party packages associated with PeopleSoft and propose solutions where available.
• Also provided technical advice to other team members in resolution of Maintenance Upgrade from HRMS 7.04Tools/7.01Apps to 7.05Tools/7.02Apps issues.
• Identify PeopleSoft fixes and patches through PeopleSoft Customer Connection Web Site related to y2k and coordinate application of critical ones within the timeframe for the testing where possible due to multiple projects going on at the same time

Confidential, Chicago, IL

Senior Technical PeopleSoft/CSS HRizon Consultant

Responsibilities:

• Assisted in application of various fixes and patches to the HR, Benefits and Payroll application.
• This involved guiding the in-house technical personnel in planning and executing the application of fixes to Records, Panels, Peoplecode, Menus, Operator Security, SQRs, COBOL batch processes and documentation, making use of selective upgrade methodology to migrate the fixes to multiple databases.

Confidential, New York City, NY

Senior PeopleSoft/CSS HRizon Consultant

Environment: Panel, Record, Menu Designer/Editor, Operator Security, SQR, and SQLPlus under an Oracle and NT environment accessed through Winframe (Citrix)

Responsibilities:

• Developed a series of customizations to the on-line application and batch processes including New Panels and records, Menus, Interfaces (Internal and external) as part of a Phase II implementation of HR, Benefits and Payroll.
• Development included Payroll GL interfaces to 3 separate systems, Pension Data outbound Interface, Health Benefit outbound Interface, 401k contribution amount update process, Online Service Dates Maintenance custom application, Outbound payroll to time collection system interface, secure sensitive employee information for training database preparation, customization of benefit panels adding new plan types, and other online modifications.

Confidential, Wakefern Edison, NJ

PeopleSoft Senior Systems Consultant

Responsibilities:

• Responsibilities included developing a conversion strategy from multiple source systems, advice functional users in mapping source systems to PeopleSoft HR, Benefits and Payroll as well as fixing table setup, develop technical mechanisms to perform actual conversion and assist/troubleshoot during payroll parallels prior to bringing each business unit live.
• Also played as technical advisor for the PeopleSoft in-house team and provided technical support to the production schedule (trouble-shooting and problem resolution).
• Also participated and guided upgrades from release 4 To 5 and 5 to 7 analyzing impact of upgrade in the rollout efforts as well as performing necessary modifications to bring old customizations to the new release level, as well as turning Workflow (Business Process Design) functions on and off according to users’ needs. Performed a review of early release of HRMS 7.5 to determine fit with users’ needs and readiness for upgrade.

Confidential, Whiteplains, NY

PeopleSoft Senior Technical Consultant

Environment: Oracle, UNIX, and Winframe

Responsibilities:

• Assigned to a major Developed technical specification for four Benefits interfaces and programmed three of them.
• Developed technical specifications for process to identify newly eligible employees to one of their subsidiaries’ 401(k) plan, and programmed the corresponding SQR process.
• Acted as technical advisor to three other technical and functional consultants to fill the gap between high-level functional specs and programming level in the Benefits and Payroll areas under release 6.01.

Confidential, New York City, NY

PeopleSoft Senior Techo-Functional Lead Consultant

Responsibilities:

• Acted as a key leading resource to assist management in the efforts to complete implementation within 6 months.
• Conducted design sessions to identify fit & gaps of foundation tables (HR, Benefits & Payroll) and worked with the client to configure the system, where manual configuration was needed.
• Worked with in house technical personnel to specify automated processes to convert legacy data into PeopleSoft and to define interface requirements with ADP, the outsourcing payroll processor.
• Performed various on-line customizations using PeopleTools, supporting reports, Developed GL interfaces, 401 k Interfaces and modified several SQRs for HR, Benefits and Payroll.
• Analyzed, designed and developed a simplified custom COBRA tracking application.

Confidential, Edison, NJ

PeopleSoft Senior Systems Consultant

Environment: 486's, Pentium, Windows, MS/PC DOS, Novel NetWare, Client/Server, Oracle, SQR, PeopleSoft PeopleTools and HRMS/Payroll, WinBatch.

Responsibilities:

• Developed a custom retirement system.
• Customized and implemented Benefits Administration 3.22, 4.0, & 4.1. Upgraded from 3.22 to 4.0 and 4.1.
• Customized PeopleSoft security system to drive it by job codes.
• Developed Profit Sharing compliance reports. Participated in initial Payroll design sessions and walk-through.
• Prototyped a custom paysheet panel. Customized payroll security to include company and paygroups.
• Developed an automated process to populate current and historical reporting tables.
• Developed an Employee Turnaround Report/Form. Evaluated Workflow features under release 5 to determine readiness for implementation.

Confidential, New York City, NY

PeopleSoft Consultant

Responsibilities:

• Responsible for the development and implementation of various GL interfaces between PeopleSoft Payroll and the GL System.
• This assignment involves Systems Requirements review, Records and Panels Prototype development and customization, PeopleCode modifications and additions, and SQR processes development to generate GL transactions for Earnings, Deductions/Taxes, as well as additional accrual Journal Entries for Domestic and International Companies.
• A major upgrade from PeopleSoft 2.03 to 3.02 was performed at the beginning of the project.
• Participated in the development of a series of "Front End" panels to allow Payroll data entry in preparation to send it to an external payroll-processing agent, ADP.

Confidential, Miami, FL

MIS Manager

Responsibilities:

• Conducted a conversion project from an existing accounting system (TRACLINE) to Xbase format, as a transition to a new Accounting Package.
• Lead the implementation of an Accounting Package (Forte), which included A/R, A/P, G/L, S/O, P/O and RMA modules. (PC Platform, LAN, Xenix/Unix, MS-DOS, Foxbase, FoxPro).
• Developed a "Product Technical Information Database" application to assist Sales and Customer Service Personnel. (PC Platform, LAN, MS-DOS, Foxbase, FoxPro). Also Developed a Serial Number Tracking System to allow verification of returned items.
• For a freight forward company, designed and developed a bill of lading reporting application. Also designed and developed an interface between an existing operational system and an Accounts Receivable module of an accounting package named SBT. (PC platform, LAN, Clipper, FoxPro).

Confidential, Miami, FL

Systems Analyst

Environment: IBM 3090, MVS, SPF & Tools, CICS COBOL II, PS/2, 386's, 486's, Windows, MS/PC DOS, Digital PCSA-LAN (Pathworks), Client/Server, DBASE III +, CLIPPER, Blinker, Flipper, DEC VAX 2xxx, 3xxx & 4xxx VAX/VMS, VAX/DCL, C, Rdb, SmartStar ISQL, GUPTA SQL, SQR, INFOREM, PeopleSoft HRMS/Payroll.

Responsibilities:

• Conducted a Conference Room Pilot and Evaluation of HRMS/Payroll Packages, where PeopleSoft was selected.
• Designed the Human Resources and Benefit Modules under PeopleSoft HRMS/Payroll Package.
• Participated in the Payroll Module Analysis and Design. Implemented "INFOREM", an Inventory Forecasting and Ordering Package. Developed Restaurant Sales Analysis System for the Franchisee Community.
• Designed and implemented an interface between EDGE, a Delivery System, and XATA, an Onboard Computer System for the company's trucks.
• Enhanced "Customer Delight", a Survey System to evaluate the customers' level of satisfaction.
• Developed a Cash Reconciliation System for Restaurants. Enhanced the Invoice Printing System to accommodate new pricing methods.

Confidential, Miami, FL

Systems Consultant

Environment: IBM PS/2, MS/PC DOS, Digital PCSA-LAN, DBASE III +, CLIPPER, Blinker, Flipper, DEC VAX's, VAX/VMS, VAX/DCL, C, Rdb, SmartStar Interactive SQL.

Responsibilities:

• Assigned to Burger King Distribution Services, developed and Implemented the "Service Level Reporting and Graphics System" for a PC/LAN environment as an integral part of the EDGE Distribution System.
• Designed and developed the Equipment Activity module for a VAX environment, designed an Item Data Base; performed system tests, keeping track of changes, maintained various programs.
• Developed utility reports to help in problem detection and provided nation-wide user support.

Confidential

National Systems Consultant

Environment: IBM 43xx, 30xx, VM/CMS, MVS, DOS/VSE, COBOL, PC XT, AT, 386's, MS/PC DOS, NOVELL NETWARE, DBASE III +, CLIPPER, LOTUS SYMPHONY & 123, MS WORD, BITCOM, KEDIT, GEM, 3COM.

Responsibilities:

• Developed a statistical information handle subsystem of the "Management Information System for Decision Making" to be implemented in several institutions of the Public Administration.
• Installed and supported Local Area Networks in four institutions.
• Developed a generalized textual data base subsystem and an application to support the functions of each LAN administrator and trained and assisted users of different levels of expertise using PCs.