SUMMARY:

• Experienced senior technical architect and developer with 11 years of experience in the end - to-end design, customization, deployment and support of PeopleSoft Applications.
• My experience spans a wide swath of industry verticals including Healthcare, Financial Services, Technology, Government and nonprofit.
• I am effective at applying variety of new generation and legacy technologies as part of providing comprehensive solutions to meet customers changing needs.
• Worked on two Full-Life Cycle Upgrade and Implementation Projects of HCM.
• Have expertise in various PeopleSoft HRMS and FSCM Modules such as Core HR, Payroll, Benefits, Benefits Administration, Time and Labor, MSS, ESS, ePerformance, eRecruit, eProfile, AP, AR, EXP, Purchasing and GL
• Expertise in HTML5 and CSS to support latest PeopleSoft Fluid UI.
• Completed Oracle training on PT 8.55 Fluid UI development.
• Extensively worked on People Tools such as Application Designer, Application Engine, Data Mover, Component Interface, File Layout, Integration Broker, Web services and Workflow(AWE).
• Extensively worked with most of the Reporting tools used in People Soft such as SQR, Crystal Reports, PS Query and BI Publisher.
• Have strong skills in coding and debugging SQR, SQL and People Code.
• Experience in Debugging and Tracing People Code, Application engine and SQR’s
• Hands on experience in using Quest Stat tools for change management and version control.
• Accomplished tasks involved in developing interface, conversion, and Data Migration processes.
• Good understanding of PIA such as Application Server configuration, Process Scheduler, Web Server, Tuxedo & 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 oral and written Communication skills, Work spirit Team player and interpersonal skills.

TECHNICAL SKILLS:

ERP: PeopleSoft 8.8/8.9/9.0/9.1/9.2

Modules: HR, Payroll, Benefits, Benefits Administration, T&L, eApps (ePerformance, eRecruit, eBenefits, eCompensation, eProfile), AP, AR, Expenses, Purchasing and GL

People Tools: Application Designer, Application Engine, Process Scheduler, Import Manager, Maintain Security, Object Security, Tree Manager, Data Mover, Query, Integration Broker, Workflow and Change Assistant.

Reporting: SQR, Crystal Reports, PS Query, nVision, XML Publisher

Languages: C, JavaScript, HTML, CSS, SQL & PL/SQL

MSOffice Application: Microsoft Project, Microsoft Word, Microsoft Excel, Microsoft PowerPoint.

Operating Systems: Windows-95/98/2k/XP/NT, Unix.

RDBMS: Oracle 7i/8i/9i/10g/12c, DB2, MS-Access and SQL-Server.

PROFESSIONAL EXPERIENCE:

Confidential, Melville, NY

Sr. PeopleSoft Architect/Developer

Responsibilities:

• Developed and documented upgrade plan to upgrade HCM 9.1 to Oracle certified upgrade image level in 9.2 and to apply maintenance update images as part of the upgrade process.
• Advised client on best practices and Oracle recommendations to follow during the upgrade process.
• Analyzed compare reports and retrofitted customizations.
• Developed custom scripts tailored to client needs to be run during upgrade process to selectively retain some of the 9.1 security, trees and queries.
• Worked extensively with payroll team to resolve issues reported during the upgrade process.
• Modified the custom permission lists to give users access to new fluid functionality in 9.2.
• Created custom fluid pages for manager self service to mass approve documents in ePerformance to bring in the custom 9.1 functionality in to 9.2.
• Customized 9.2 ePerformance self service pages as per the business needs.
• Created custom approval workflow(AWE) for ePerformance.
• Developed an app engine process to mass upload T4/RL-1 year end electronic consents for Canadian payroll.

Environment: PeopleSoft HCM 9.1 & 9.2, People Tools 8.51 & 8.55, SQR, Application Engine, PS Query, Oracle12c, UNIX.

Confidential, Hartford, CT

ERP Applications Architect/Team Lead

Responsibilities:

• As an Architect & Team lead, I was responsible to design, develop and deploy customizations to meet business requirements along with mentoring and leading other developers.
• Acted as a liaison between Business and technical team in base benefits implementation.
• Prepared technical specification documents for Base benefits implementation.
• Designed conversion programs to convert data from various legacy systems in to PeopleSoft.
• Developed App engine to CI programs to convert Job, Person, Payroll data from other systems in to Peoplesoft.
• Partnered with variety of stakeholders including analysts, business users and HR leaders to understand business objectives and organizational policies in order to customize and deploy various Self -Service Fluid pages.
• Designed, Customized and deployed Self Service functionality in Fluid UI for both desktop and hand held devices.
• Customized delivered fluid pages on small form factor devices (Mobile) to display different data from desktop version.
• Developed custom fluid page for time correction submission with AWE. This allowed users to submit time corrections from mobile devices.
• Customized fluid grids on My team page to display custom data on List and card views.
• Updated the branding on mobile fluid pages to fit within the small form factor framework.
• Customized SES search for fluid company directory.
• Customized fluid Self Services pages to fit in to Organizations business needs.
• Modified delivered classic pages to fit in to new fluid framework.
• Converted the employee profiles from legacy system in to PeopleSoft.
• Developed custom miscellaneous transaction page in FSCM.
• Developed custom USERID update process in HCM and FSCM.

Confidential, Hartford, CT

Sr. PeopleSoft Consultant

Responsibilities:

• My responsibilities as a consultant at HHC included providing technical assistance for upgrade, data conversions, developing Interfaces, performance tuning, trouble-shooting issues and providing resolutions.
• Served as primary technical resource for HCM upgrade from 9.1 to 9.2.
• Worked closely with all the stake holders like Functional users, DBA’s, PeopleSoft Admin’s and Security team in planning and executing the 9.2 upgrade process.
• Retrofitted customizations and resolved issues as part of the upgrade.
• Leveraged the new branding functionality, modified the html files and stylesheets in 9.2 to provide the custom look and feel to the UI.
• Set up Integration broker messaging between HCM and FSCM.
• Developed a complex custom Leave accrual process involving multiple App engines with batch processing for leave calculations and interfaces with Kronos (Timekeeping system).
• Involved in requirement gathering for custom leave accrual process from multiple companies (15 companies) as each company has its own policies and procedures in administering leave accrual benefit.
• Designed and developed a custom leave plan set up page to accommodate the requirements of multiple entities.
• Customized pay003 and ddp003 sqr’s to generate custom XML tags to be used on custom BI publisher templates for online pay checks.
• Customized payroll to GL interface (paygl01) to distribute earnings as per the business requirement.
• Developed multiple outbound interfaces to Kronos for transferring demographic and leave time data.
• Written conversion programs to bring in the employee data from newly acquired companies.
• Been part of the Taleo (Recruitment system) implementation team.
• Developed multiple App engine to CI interfaces to get the recruitment and onboarding data from Taleo and load in to PeopleSoft Person, Job and Tax data components.
• Created custom pages to stage the data coming in from Taleo.
• Extensively involved in requirement gathering and design phase of the Taleo implementation.
• Provided production support for payroll issues.
• Helped in setting up of new special accumulators and earning codes.
• Modified the macros on excel to CI spreadsheets to provide delete rows functionality to users as per the requirement.

Environment: PeopleSoft HRMS 9.1 & 9.2, People Tools 8.52 & 8.54, SQR, Application Engine, PS Query, Oracle10g, Windows XP.

Confidential, Washington, DC

Sr. PeopleSoft Developer

Responsibilities:

• As a senior PeopleSoft Developer my responsibilities at NeighborWorks America included Development and production support of HCM/FSCM modules.
• Crated custom Vendor threshold program which notifies the business when payments to a vendor reach a threshold in a fiscal year.
• Assisted users in payments reconciliation efforts by generating reports, analyzing the data and resolving the issues.
• Created custom interfaces between GrantWorks(Third party Grants application) and Peoplesoft.
• Helped users in setting up of eligibility/event rules, rates and new benefit program structures as part of Open enrollment 2014 . Documented and trained users in processing Open enrollment.
• Gathered requirements from Health insurance providers and prepared SQR interfaces to send the employee health benefits information to insurance providers.
• Customized the Open enrollment pages in self services as per the business requirement.
• Advised users in resolving issues related to position management.
• Developed custom nVision reports to calculate the number of employees working in various funds and their salaries by Division/departments and Position to help with budgeting.
• Set up Excel to CI utility to load the new position data, job data and salary grades as part of the restructuring of the organization.
• Created custom roles and permission lists in a bid to improve the security set up by limiting the user access to various modules.
• Modified payroll check print SQR and Finance check print crystal report to accommodate signatures of multiple users.
• Developed a custom SQR to send emails to employees and their supervisors in case of pending timesheets.
• Modified the custom labor allocation process to take in to account the employees on short term disability and calculate the labor as per the organization policies.
• Analyzed and retrofitted the customizations during tax updates.
• Developed and customized workflow for various self-service transactions as per the organization requirement.
• Customized many self services pages to show the employees business title from position data instead of their job titles.
• Written custom T&L rules to calculate the OTP and OTS (Overtime) as the employees are not expected to enter the holiday hours in their timesheets.
• Provided production support and resolved issues relating to Payroll, T&L, HR, Benefits administration, AP, Expenses and GL

Environment: PeopleSoft HRMS 9.1, FSCM 9.1, People Tools 8.51, SQR, Application Engine, PS Query, Crystal Reports, nVision, AWE(Approval workflow engine), Oracle9i, Windows XP.

Confidential, Atlanta, GA

PeopleSoft Support Lead

Responsibilities:

• Worked closely with business analysts and end users in identifying and troubleshooting Production issues.
• Mentored and assigned responsibilities to the Offshore support team.
• Assisted the client in maintenance of all the PeopleSoft Application servers and web servers.
• Solved various issues with moth end compensation reports.
• Made customizations to Officer Title change page in MSS to remove 30 day restriction for managers to submit an officer title change.
• Made code changes to TL SEC XX (custom T&L security refresh) job to send a mail to business users when a supervisor is found reporting to one of his direct reportees instead of going in to infinite loop.
• Provided technical support during payroll run.
• Made code changes to general deduction load job (which loads the deduction amounts from a spread sheet) to accept a new deduction type.
• Reconfigured the App server configuration for a pre-production environment as the IP addresses of the servers changed.
• Developed custom Data Mover scripts and ran for Data Imports and Exports between different Data bases.
• Used Process Scheduler to run scheduled processes at a specific time and/or run recursively at a specific interval and used Process Monitor to view status of the process.
• Monitored the payroll jobs which are being run on Mainframes during the payroll run.
• Made customizations to a SQR process which runs on Mainframes daily to send out employee data to Third party vendor.
• Provided on call support during afterhours.
• Involved in discussions with third party vendors like Xerox to resolve the integration issues with HR application.

Environment: PeopleSoft HRMS 8.9, People Tools 8.49, SQR, Application Engine, PS Query, DB2, Windows XP and Mainframes.

Confidential, Coppell, TX

Sr. PeopleSoft Developer

Responsibilities:

• Extensively worked as a resource for development and Support in core HR Benefits and Payroll.
• Designed and developed custom PeopleSoft components with extensive People Code, conversion and interface programs for the HR, Payroll and Benefits.
• Created an Application engine which would send a group message to the selected employees based on the certain criteria like entity location, location, company, employee type, agent or non-agent.
• Added new fields on the run control page and written the code for the search criteria in the Send Group Message to Employees application. created and worked on Custom tables & State records in Application Engine Programs
• Created custom components provide the facility to send receive and check the messages to and from employees who do not have official email with Confidential .
• Created an interface using Application Engine and file layout which would take the input file VIP containing emplid, name and Amount to and generate an output file which additional information which can be used to load information in pay sheets.
• Created File Layout to convert the Health Benefits Details and Deduction Balances Data.
• Created a Agents average hours report CB104550.sqr which would calculate the agents average hours between the certain period of time.
• Modified the existing benefits deductions report CB102180.sqr to include features like running report for the specified entity location, excluded certain benefit plans.
• Proficient in Debugging and Tracing Application Engine, People Code SQR and Component Interface.
• Extensively used PS/Query to develop ad-hoc queries, generate Crystal Reports and to produce analyzing reports using excel.
• Developed Functional and Technical specs for the interface and reports in HR, Payroll and Benefits.
• Used Process Scheduler to make SQRs available from with in PeopleSoft and schedules various periodic reports
• Provided support on interfaces and SQR’s related to HR, Benefits and worked on the related issues.
• Directly interacted with the end user for training them and resolving the issues in production.
• Attended regular meetings with the Manager and Users group about the status of the project.

Environment: PeopleSoft HRMS 9.1, People Tools 8.51, SQR, Application Engine, PS Query, Crystal Reports 9.2, Oracle9i, Toad8.6.1, UNIX and Windows XP.

Confidential, Jacksonville, FL

Sr. PeopleSoft Developer

Responsibilities:

• Involved in the full life-cycle up gradation of HRMS 8.8 to HCM 9.0, Fit-Gap Analysis and Retrofitting for fixing the existing customizations in the newer version of PeopleSoft.
• Performed various scripts modifications and ran them using Change Assistant.
• Modified several baseline SQRs and Application Engine processes to mass create and maintain ePerformance Appraisal Documents.
• Designed XML Publisher Report Definitions, Templates and Data Sources to generate ePerformance reports using PeopleCode and Process Scheduler.
• Ran cross reference reports, DDDAUDIT and SYSAUDIT to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
• Involved in the database activities using PeopleSoft tools for import and export of the database using Data mover and Import manager among different databases.
• Developed Functional/Technical Specifications and Field Mappings for various Interfaces.
• Developed various outbound / inbound interfaces as per the business requirements like Fidelity, Met Life and Cigna etc.
• Developed Conversion programs using SQR, Application Engine and Component Interface to load data to PeopleSoft tables.
• Worked on complete life cycle of payroll process starting from creating Pay Calendars to Pay Confirmation Process and running reports Pay034, Pay035, Pay036, DDP001, and DDP003.
• Used Application Engine, File Layout and Component Interfaces when inserting data into PeopleSoft Tables coming from Third Party Applications.
• Wrote DMS scripts, Export and Import between various Environments using Data Mover.
• Ran Compare Reports and moved Objects from one Database to another when required.
• Designed and developed custom Paycheck summary page which displays Employee’s earnings, deduction, taxes, and bonds and flex credits as per client’s requirement. Also implemented Security for this page, the data is displayed based on the company, pay group and grade band of the user.
• Designed and developed a new Application Engine with Component Interface which would automate a supervisor change in the Job Data for an employee when the supervisor is terminated or changed.
• Modified custom Job Data Component Interfaces to handle custom logic for tracking benefits of company employees (Component Interface, People Code).
• Developed an Application Engine with Component Interface to automate the process of assigning Benefits for Employees working in different companies.
• Customized an Application Engine to assign the benefits of the employee to their dependent upon a change in event, in a Benefits administration process.
• Designed and developed many inbound and outbound interfaces to and from PeopleSoft payroll system.
• Responsible for maintenance and configuration of PeopleSoft’s Integration Broker between PeopleSoft and third party applications (configuring gateways, creating nodes, connectors, and XML schemas).
• Configured and maintained Security for HRMS modules. Including permission lists, roles, user profiles and route controls using Security Administration, Tree Manager and Access groups.
• Provided written documentation support for existing system functionality as well as future upgrade functions to maintain a baseline of customizations and standards for the modules and applications.
• Created, modified SQL, SQRs, Crystal Reports and People Code /Application Engine customizations.

  Built vendor interface that sent payroll deduction information (SQR, SQL)

• Extensively used PS/Query to develop ad-hoc queries, generate Crystal Reports and to produce analyzing reports using excel.
• Generated reports using XML Publisher with Query, Row set and XML as data source and into PDF, RTF, HTML and XLS as output format.
• Responsible for troubleshooting of Time Load to Payroll issues (COBOL Trace, SQL)
• Run pay calculations, corrected errors in pay calculations and review the final pay calculations.

Environment: PeopleSoft HCM 9.0, People Tools 8.49, SQR, Application Engine, Integration Broker, Work Flow, SQR, PS Query, Crystal Reports,XML Publisher, Oracle9i, Toad, Windows XP.

Confidential, Phoenix, AZ

PeopleSoft Developer

Responsibilities:

• Analyzed, designed and developed a new Component for rehire check and quick hiring/rehiring which involved in development of new custom pages to look up data from the Personal Data and Job Data.
• Validations in the Component ensured data quality, thus preventing bad into the Personal Data and Job Data components in the PeopleSoft system.
• Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement. Approval rule set and Activities were modified to route approval transactions and email notifications to administrators based on location.
• Configuration of Self Service Workflow, transactions included setting up the approval process; allow Database updates, setting up direct reports for managers based on partial position management.
• Creating Self Service permission lists that would be given to the manager and employee roles, Creating administrator roles, assign it to the user profile
• Designed and developed a new component for Location - Shift Management which is not managed using the Table Set Sharing.
• Analyst and Developer for Express Release Projects group, a project to analyze users’ requests and develop customizations on a monthly basis.
• Customized the search for Job Data, Personal Data and other components to enforce search based on the custom fields - Login name and Phone tool name.
• Designed and developed a new Application Engine with Component Interface which would automate a supervisor change in the Job Data for an employee when the supervisor is terminated.
• Developed a Job an SQR as an interface to the Badging system and Time Management systems and a new Application Engine which would send errors to the corresponding supervisor.
• Analyst, Designer and Developer for the cleanup of duplicate data in the Personal Data Component.
• Developed SQR to Read from file and Write to file as part of the Data Cleanup.
• Customized the pages in Benefits based on the Plan Type and region.
• Developed an Application Engine with Component Interface to automate the process of assigning Benefits for Employees in Europe.
• Customized the PeopleSoft Employee License Management System. As part of it developed a new Application Engine to manage and notify, the employee, supervisor and the business partner of any employee licenses nearing its expiration.
• Developed new SQR to generate reports based on the License Management System.
• Extensively used PS/Query to develop ad-hoc queries, generate Crystal Reports and to produce analyzing reports using excel.
• Generated reports using XML Publisher with Query, Row set and XML as data source and into PDF, RTF, HTML and XLS as output format.

Environment: PeopleSoft HRMS 9.0 (HR, Benefits, Payroll), People Tools 8.49, People Code, Application Designer, Application Engine, Component Interface, File Layout, Process Scheduler, PS Query, SQR, Crystal Reports, Toad, Oracle 10G, UNIX

Confidential, Dallas, TX

PeopleSoft Developer

Responsibilities:

• Created custom Application Engine programs to synchronously create user accounts in the Portal Database for new employees.
• Developed programs to call the Application Messages and Component Interfaces from the Application Engine programs.
• Worked on various Self Service screens to hide or display only some of the options on the pages using People Code, based on certain conditions driven by functional requirements.
• Designed and developed various Application Messages to publish data from PeopleSoft to other applications in an Asynchronous mode. The response messages were received using Subscription Messaging.
• Customized Application Engine programs to load payable times to Pay Sheet table from the Time & Labor table to meet the client’s business requirements.
• Developed and customized Time and Labor enrollment process using Application Engine programs and Component Interfaces and thoroughly tested it.
• Involved in mapping TRC to earning codes. Tested the Application Engine programs with respect to Time and Labor for performance issues and proper functionality.
• Developed rules using Rules templates and compiled to add relevant section in the Application Engine (TL TA RULES) controlling the time administration process.
• Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.
• Involved in creating static and dynamic groups and assigned permission lists for Security through Maintain Security.
• Worked with Time Reporting Codes (TRC), TRC programs, Value Lists, synchronizing of Earning Codes and prepared documents.

Environment: PeopleSoft HRMS 8.8, People Tools 8.46, PS Query, Crystal Reports, SQR, DB2, Oracle8.0.6, Windows NT4.0.