SUMMARY

• me is looking for a PeopleSoft developer plus tester. me have 3 years of experience in systems design and development including 2 years of technical expertise in the customization, upgrade and implementation of the HCM/ELM/FSCM 8.9/9.x.
• Participates in all levels of the systems development life cycle (SDLC) of PeopleSoft projects, including Technicial Fit/Gap Analysis, Testing and Troubleshooting and Production Support.
• Proficient in the use of People Tools, Application Designer, People Code, Application Engine, SQR, Process Scheduler, Portal, Integration Broker, Data Mover, Import Manager, Security Administrator, Object Security, PS Query, Component Interface and File layout.
• Implementing and Customization of Pages, Records and Menus using People Tools and Object oriented People Code.
• Experience also includes Debugging and performance tuning of processes. Well versed with Debugging tools like SQL trace, PC debugger, and Application Engine trace for troubleshooting.
• Proficient Knowledge in Oracle SQL, PL/SQL, Procedures, Functions and Triggers, Stored packages.
• Good understanding of PIA, App Server configuration, Internet Architecture, Process Scheduler, Web Server, Tuxedo and Jolt.
• Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, Folders, Content References and Definition Security.
• Excellent Team player to work in conjunction with other testers, developers, and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

TECHNICAL SKILLS

Programming: Java, C, HTML, PHP, .Net, C#, PeopleCode, SQL, PL/SQL.Reporting SQR, PS Query, Crystal Reports and XML Publisher.

OS: Platforms Windows 7/8.1, Windows NT 6.x Workstation, OS/2

Software and Tools: Peoplesoft 8.5x, SQR, SQL, PL/SQL, Application Engine, PeopleCode, Query Manager, Crystal Reports, Test Director - Mercury Quality Center 8.2, VMware Workstation, VirtualBox, Visual Basic 6.0, Process Flow Development (MS-Visio), Dreamweaver, Rational Rose, Erwin, Visual Studio

RDBMS: MS-ACCESS, Oracle, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Chadds Ford, PA

PeopleSoft HCM Systems Analyst

Responsibilities:

• Performed research and study of the existing system tables and business processes
• Involved in the in-depth study of the customizations to be made in the HR, Benefits and Payroll modules and prepared documentation for technical specifications
• Created an Application Engine process (Component Interface) to move direct deposit data available in holding table into the delivered DDP tables once hired and available in PeopleSoft.
• Customized the delivered Direct Deposit and Distribution records/pages to include a new account type Pay/Bank Card dat Kelly offers to its employees.
• Developed a process (Application Engine, CI and Message channels) to send the demographic employee changes on a daily basis to the Kelly Mainframe back office to keep the legacy system in sync. Changes include direct deposit account info, Hire date, Birth date, Benefits date etc.,
• Customized the Delivered Direct Deposit file programs (DDP001CN.sqr, DDP001.sqr) to include the Kelly specific business rules like flag advices as sent, exclude void advices etc.,
• Developed new run control pages for running the Direct deposit programs for both US and CAN to change the delivered run control parameters to SRC BANK ID.
• Developed several import/export data mover scripts for ftp scripts/data transfer between different environments
• PS stores data based on an EMPLID which the Kelly Employee will not no. Therefore, modified several delivered search records to create ability to search by KSN ID (Kelly employee id) or National ID (SSN) on the EMPLID field. The employee will tan be able to provide to allow the payroll department to service their needs in a timely manner
• Added validation of BANK CDs in DIR DEP DISTRIB which is a free form field, as delivered. The bank routing numbers are extracted from prompt view (built on BANK EC TBL) and to be selected from the drop down.
• Created a process to inactivate DDP records for EE’s dat exist in PS but have not been paid within the past 6 months. dis action will reduce the number of DDP’s dat are sent to old accounts when an employee TEMPhas a break in service, tan returns to work for Kelly after a period of time.
• Developed Time and Labor adjustments message. It populates Time and Labor holding table to adjust override rate for an employee/assignment. The message is sent from PeopleSoft Financials to PeopleSoft HR. Used Integration Broker/application messaging for dis task.
• Worked on Assignments rate change message. dis message is sent from external system to PeopleSoft HR and it updates employee assignment rates in FO ASGN RT DTL table. Used XML Publisher (Integration Broker)
• Created a report (SQR) to insert a new row to update collector to “New” (CUST OPTION) if customer is a re-activated customer (customer whose most recent item prior to dis new order was more TEMPthan 180 days ago) with no open AR.
• Developed a custom ‘Adjustments page’ dat provides users the ability to review event transactions stored in HCM Control Tracking Table (HCT) with statuses ‘PRC’ and allows them to update the ‘Event Status’ to ‘DON’ for a particular Pay group and Pay system.
• Created a page by Company, listing service lines with the ability to add/update svc line information and an underlying table containing threshold amounts by individual pay rate, expense, bonus, total gross and net pay for each country svc lines.
• Extensively worked on creating new objects and involved in customizing the existing PeopleSoft objects (Pages, Components, Menus, People Code and Process Definition)
• Worked on Component Interfaces, Integration Broker, Application messages and Business Interlinks to integrate with the third party systems
• Actively participated in meetings with customers like Chase, Wells Fargo, Royal Bank of Canada, BOA etc., to discuss the various scenarios like file layout specs, sending test files, transmissions etc.
• Analyzed end-user needs, satisfied user requests for queries/reports and progressed them to the senior management
• Involved in unit testing, integration testing in non-production environments and participated in preparing test scripts
• Actively participated in the weekly meetings and carried the reputation of timely producing the results

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Developed reports using People Soft Query tools.
• Created and tested new and customized existing People Soft objects (Records, Pages, Components, Menus, People Code) and applied Security.
• Performed testing to ensure the compliance with user requirements and validity of information.
• Used Mercury tool for creating Data Driven Tests for functionality testing for all modules. Wrote necessary people-code for online validations
• Executing PeopleSoft delivered and customized scripts using tools like Data Mover and SQL Plus.
• Tailored People Code to implement data validation and to enforce field level security.
• Wrote SQRs dat run on scheduled basis to copy the data into PS HRMS system and converted them to Application Engine.
• Extensively used Application engine, SQR and Peoplecode for new development.
• Worked on Application Designer to customized Run Control Pages and Menu, developed new process definitions and attached to PeopleSoft system.
• Involved in Fine Tuning the SQLs, which are used in Data Conversion Application Engine Programs to increase the performance.
• Documented the specifications on regular basis for every change required and implemented.

Confidential, Sylyania, OH

Application Developer

Responsibilities:

• Analyze, evaluate, modify, configure, test and implement business solutions.
• Assist with the evaluation of system needs and coordination of system upgrades, enhancements and maintenance with various departments utilizing PeopleSoft.
• Design and support application software with an emphasis on PeopleSoft and other related systems in conjunction with the HRIT team.
• Evaluate, design and maintain business processes in support of the HCM and FSCM Expense application utilizing the PeopleTools skill set.
• Modify delivered and customized PeopleSoft functionalities based on business requirements
• Utilize SQL to develop and maintain SQR reports and/or Application Engine processes for business needs
• Work with HR functional lead users in resolving system issues and problems
• Maintain working noledge of system functionality and the business processes they support
• Maintain integrity of PeopleSoft applications by applying new software releases, system upgrades, bundles and patches. Used Upgrade assistance to execute the upgrade activities.
• Maintains data files and monitors system configuration
• Develop and prepare application system specifications
• Install JDK for Oracle WebLogic. Install Oracle WebLogic and Tuxedo on Microsoft Windows. Install PeopleSoft PeopleTools 8.53 in GUI Mode.
• Designed various custom processes in ELM. These processes include but not limited to Auto registration process, Program updates for failures and data entry, update re-certifications process, Cornerstone interface.
• Defined and created learning components, delivery methods, activity templates, programs and certifications for ELM9.x.
• Designed security strategy and developed security by creating roles and permission lists in ELM 9.x.

Confidential

MicroSoft Technical Consultant

Responsibilities:

• Developed and maintained SQL Server Databases. Built, maintained, and scheduled DTS and SSIS packages and stored procedures for migrating and updating data.
• Created views, queries, and data warehouse reports using BI Query Analyzer, Crystal Reports, MS Access, and SSRS providing management with financial information from SQL Server production databases.
• Provided production support for applications. Assisted users experiencing errors within these applications and resolved errors.
• Provided administration duties on SQL Server. Created, maintained, backed up and restored databases.
• Developed ASP.NET C# application to interface with Visual Studio 2008.