SUMMARY:

• 9 Years of IT Experience in Retail, Higher Education, Finance Industries and Government Agency.
• 9 years of PeopleSoft Development and experience in all phases of SDLC including PeopleSoft Analysis, Fit Gap, Design, Development, Customizations, Implementation, Upgrade, Production Support, Integration, Data Conversions, Data Migration, Training, Reporting .
• Expertise in developing EDI Solutions to Integrate and transact with PeopleSoft application.
• Experienced in techno - functional analysis, gathering user-requirements, project development, troubleshooting system issues, working closely with third party vendors.
• Proficiency in writing complex SQL’s in Oracle and SQL Server.
• Strong understanding & proficiency in implementing Interfaces/Batch Jobs/Conversion Programs using SQR’s and Application Engine Programs.
• Possess excellent communication and interpersonal skills and a very good team player.

TECHNICAL SKILLS:

People Tools Versions: 8.55,8.54,8.53,8.52, 8.51,8.48,8.46,8.45,8.42/8.x

People Tools: Application Designer, People Code, Application Engine, Component Interface, File Layout, Process Scheduler, Integration Broker, PS Query, Data Mover, Security), Application Packages, Pagelets, Excel to CI.

Reporting Tools: XML Publisher, SQR, nVision and Crystal Reports.

Modules: PeopleSoft FSCM (General Ledger, Accounts Payables, Purchasing, Inventory and Asset Management) PeopleSoft HCM (Payroll for North America, Base Benefits, Benefits Administration, Time and Labor, Global Payroll, Absence Management), Smart ERP, Concur (Expense Management Tool) Peoplesoft Campus Solutions (Financial Aid, Enrollment and degree planning).

Other: Approval Workflow Engine, Approval Process Setup, Server Administration, Notification Alerts, Dashboards, Forms.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

PeopleSoft Developer/Analyst

• Working on Time and Labor customized process to send information across different systems.
• Extensively developed customized pages for Employee Scheduling project.
• Converted customized pages to fluid pages to be accessed on mobile devices.
• Built complex BI publisher report that runs for 200 recently merged hospitals.
• Built pages that use HTML area in the grid that change dynamically based on the employees scheduled and open schedules. The manager could change the scheduling which will reflect the data in T&L modules.
• Modified delivered fluid App package to resolve the bug on the fluid-based approvals.
• Worked on security for fluid components and tiles.
• Developed Custom app engines that generate daily reports and sends across to the third-party systems as an email.

Environment: PeopleSoft HCM 9.2 (HR - T&L, Core HR), People Tools 8.55 People Code, App Engine, HTML, CSS.

Confidential,MD

PeopleSoft Developer/Analyst

• Worked on Absence Management and Global Payroll implementation project.
• Created formulas, brackets, rules and arrays for sick plans in Absence Management.
• Customize Absence Management with Fluid and Classic mode based on the requirement and roll out for different operating companies.
• Worked with Oracle to resolve the existing bug in AM system for Fluid.
• Worked on creating a CI for new hire load and employee data update for the new countries that were included in PeopleSoft.
• Implemented Global payroll for USA, CAN and GBR.
• Worked on GP Positive input CI were the data can fetch from a staging table/ file option on the run control page.
• Core HR Production support specialist handling production tickets.
• Worked on various People Tools such as Application Designer, Data Mover, Object Security, Process Scheduler, PS Query, XML Publisher, App Messaging, Integration broker and People Code.
• Did upgrade of PeopleSoft from 9.1 to 9.2 and did upgrade during GP project implementation and did PUM upgrades from 6 to 21.
• Enroll employees into benefit plans and setup dependent and beneficiary data.
• Working on a custom module (Concur) that handles expenses approver.
• Implemented New Hire Automation for the staffing firm’s custom module SmartERP.
• Designed front end pages, CI App engines.
• Worked on custom SQR starting from the technical Spec design, building new SQR’s and also modifying existing SQR’s to enhance performance.
• Created SQC and procedures to remodel existing SQR’s to avoid redundant code and robust performance.
• Worked as a technical resource who can work on implementing fluid for employee self-service where we can view the personal information of an employee and also status reports and also view benefits.
• Implemented pivot grids with in manager self-service where the grid dynamically shows the information in the form of graph of a pie chart as desired to see the information.
• Remodeled most of the SQR’s to use Load Runner to reduce the Database access and increase processing speed and overall system performance.
• Created JOB’s for batch of SQR’s that run as a stream of processes.
• Worked on Global Payroll Implementation Project which involves Germany, UK, India, Sweden, France, Dubai and Canada.
• Built a component Interface app engine that accepts two inbound data from file and staging table to process POSITIVE INPUT for employees for Global Payroll.
• Created custom App Engines for One Time Positive Input. Used Delivered CI for this process.
• Worked on Latest PUM updates and retrofitted the delta objects.
• Created complicated pages that take care of Approval rules which deal with Reordering and Re-Sequencing of the rules when the user makes any changes to the rules.
• Coded the pages for random inserts, deletes and modify of the rules on the page.
• Involved in Requirement gathering, creating technical design and conducted code reviews for the code developed by other users.
• Worked on custom module Smart ERP used New Hire Automation.
• Created App engine that sends out electronic Year End consent to the Employees based on their personal information.
• Modified personal data page to make the Year End Consent visible on the user data.

Environment: PeopleSoft HCM 9.2 (HR /TAM, GP, AM), People Tools 8.52/8.53/8.54/8.55 People Code, App Engine, Component Interface, SQR Oracle.

Confidential, TX

PeopleSoft Developer/Analyst

• Worked on fixing bugs in TAM conversion with related content services and web profile configuration.
• Heavily involved in system testing for TAM, Account Receivables and Account Payable modules.
• Modified existing App packages to add security for CAPPS customizations.
• Extensively involved in fixing the defects caused by the upgrade from 9.1 to 9.2.
• Retrofitted customizations in 9.2 environments that are needed for Texas state agencies.
• Generated compare reports between 9.1 and 9.2 environments to retrofit security for different roles in TAM such as Recruiter, Hiring Manager, Recruitment Administrator.
• Modified existing BEN100a SQR to fetch the termed dependents only from the past 35 days instead of getting the old data from the time the employee has been hired.
• Modified the Pay check program (Pay003 and Ddp003) XMLP to modify the report as per the user requirements.
• Involved in testing pages, components and role security for different modules by interacting with users and gathering requirements.

Environment: PeopleSoft HCM 9.2 (HR /TAM), FIN 9.2 (AP, AR) People Tools 8.52/8.53 People Code, App Engine, Component Interface, SQR Oracle, Windows 7.

Confidential, TX

PeopleSoft Developer/Analyst

• Extensively worked on core HR module for conversion of JOB, PERSONAL DATA and POSITION DATA in both 9.1 and 9.2 environment.
• Created DEPTID’s, JOBCODE’s, LOCATION’s mapping from old to new data and loaded the CSV file into records using File layouts which would be used for conversion process.
• Heavily involved in upgrade of peoplesoft from 9.1 to 9.2 and tools 8.52 to 8.53.
• Converted the benefit data and payroll data into the new environment after loading the job rows job rows only for the employees that were converted in the new system.
• Created new positions using Component Interface CI POSITION DATA for the conversion process in the new system.
• Loaded the Personal Data from the old system to the new system using CI PERSONAL DATA during the conversion process.
• Created the hire rows for the employees in the new system based on the source systems JOB information using CI JOB DATA EMP with the action HIR.
• Loaded update rows for the employees having a specific criteria based on the information gathered from the user using CI JOB DATA and loaded the rows that would be useful for the conversion process.
• Setting up TL rules, rule programs and the related TL configuration items.
• Setting up AWE, Time and Labor Security.
• Worked on Time Approvals and Payable Status.
• Integrating with third party Time entry systems using TCDs.
• Payroll processing, testing the Time and Labor and Payroll integration.
• Setting the various Time and Labor rules such as Accounting, Double-Time, Holiday, Meals, Miscellaneous and Overtime.
• Created Component interfaces which create job posting on the Job Portal using TAM.
• Modified the front end job portal to accommodate additional Applicant information needed by the third party websites for TAM.
• Integrated the third party company database with peoplesoft database for getting the application test information and results for TAM.
• Created conversion row for all the active employees in the new system with a conversion date which have position number in them along with reports to information.
• Worked on production support for the old system on Benefits, Payroll and core HR modules.
• Carried forwarded all the customizations made to the SQR’s and Application Engines during the process of upgrade from 9.1 to 9.2. In HR modules such as Payroll, Benefits and TAM.
• Worked on setting up full and incremental sync from HR to FIN using Integration Broker.
• The incremental Sync was setup to load a person data into finance when a person was added in HR using Integration Broker.
• Worked on Service operation, service handlers and routings to enable Integration Broker sync.
• Modify the Application engine (B BAS200) which would run after the PayCalc (PSPPYRUN) to calculate the adjustments that would be reflected on the Pawn stores side.
• Developed online objects using Application Designer as per the design requirements and extensively used PeopleCode (Record PeopleCode, Application Engine PeopleCode and CI PeopleCode) for the online validation and to implement the business rules.
• Provided functional assessment for current PeopleSoft business processes and recommended improvements for processing in 8.9 environments and also and provided documentation for all future JOB data load process.

Environment: PeopleSoft HCM 9.2 (HR /Payroll/ Benefits/TAM/Time and labor) People Tools 8.52/8.53 People Code, App Engine, Component Interface, SQR Oracle, Windows 7.

Confidential,MD

PeopleSoft Developer

• Provide production support for HCM, General Ledger and Asset Management Modules.
• Performed PeopleSoft Server administration for all Production and Non-Prod servers hosting HR and Finance applications.
• Was extensively involved in transition from Peoplesoft to SAP on HR modules.
• Wrote programs to convert legacy peoplesoft HR data to SAP acceptable data.
• Extensively involved with the Data Center Move and setting up the DR Environments.
• Modified the Startup and performance Unix Shell Scripts for the new 9.1 environments.
• Extensively involved in Administering PS Admin Tool and setting up and correcting the configuration settings of Tuxedo, Process Scheduler, Web Server and Jolt.
• Created a Benx040 which is a custom benefit integration process that was created to send over the Benefit information to PeopleSoft that the client receives from CYC (Connect your care).
• Created a Custom process to send over the information to TALX vendor for the employees enrolled into benefits.

Environment: PeopleSoft FSCM 8.8, HCM 9.1, People Tools 8.49, 8.51, Oracle 10g.

Confidential, TN

PeopleSoft Developer/Analyst

• Working on Performance Tuning the IC-AR Inbound - Item Status update process.
• Resolved issues for CARS Pending Items based Single Assessment Process.
• Resolved Issues in CLAIMS for Voucher Generations Process.
• Performance Tuning of PS Queries.
• Used FileNet Imaging System to store COMWC statement images.
• Involved in database upgrade from Sybase to Oracle 11g.
• Verified and compared all the process performances during the database upgrade.
• Worked on Modifying the nVision Reports per Business Requirements.
• Created and Modified PS Queries using AR, AP, CARS, CLAIMS, GL Tables as per Business Requirements.
• Resolved issues in GL where users were unable to use the "Drill to Source" Option to view underlying Vouchers for the Journals.
• Extensively worked with the HCM Upgrade team and functional users in order to develop, support and resolve technical issues in Workforce Administration, Payroll, Benefits, Time and Labor during the upgrade from v8.8 to v9.0.
• Extensively involved in data analysis and conversion programs and reviewed the compare reports, performed fit-gap between 8.8 and 9.0, tune the Data, load Application Engine programs and actively involved in the testing and issue resolution during the parallel test and the post production support.
• Developed several reports for Pension Administration which Provides summary information about a calculation and its benefit formulas. This SQR report showed each benefit formula processed during the specified calculation.
• Involved in setup and design of automated benefits enrollment process, setting up core tables in HR and Benefits Administration, defining eligibility rules and creating event rules.

Environment: PeopleSoft HCM 9.0, People Tools 8.49, Oracle 10g.

Confidential, NC

PeopleSoft Techno/Functional and Upgrade Consultant.

• Involved in Integrating PeopleSoft with, ADP using PeopleSoft Payroll Interface and Involved in implementing the Interface of PeopleSoft with external Payroll system, sending PeopleSoft HR data to ADP Payroll services
• Worked with creating a new Job entry process. This took care of the requests made by various departments to accept the new employees (or changes to the existing information) as entered by them.
• Modified existing workflows like promotion and salary change approval from a two step to three step process.
• Worked on AR Auto Maintenance Process modifications and made changes to the delivered (AR AUTOMNT) AE Program to meet Business Requirements.
• Worked on 2014 and 2015 fiscal years 1099 Process and generated 1099 forms for the Vendors.
• Worked on Customer statements issue where statements were being sent to Incorrect Customer Address. Modified the SQR.
• Developed an Interface process using sqr to load the invoice data from the external system IC2 to FMIS Accounts receivables (Inbound IC2- AR Process).
• Developed an Interface process using sqr to load the Penalties data from the external system CIS to FMIS Accounts receivables ( Inbound CIS - AR Process).

Environment: PeopleSoft HRMS/FSCM 8.3/8.9, People Tools 8.48, DB2.