SUMMARY

• PeopleSoft HRIS/HCM/EPM Applications specialist with over 10 years of professional experience.
• Expert knowledge in PeopleSoftPayroll forNorth America, Core HR, Base Benefits, Compensation, Time and labor, ESS, MSS, eRecruitment, Trainingmodules.
• Molded a professional with keen problem solving skills, succinct communication, analytical in nature, innovative programmer with ability to foster team effort.
• Expertise includes extensive technical knowledge and work experience on Oracle 8x/8i/9i/10g/11g, Sql Server 2000, 2012 using Sql*Plus, PL/SQL, T - SQL, Query Analyzer, PeopleSoft Enterprise 8.1/8.4/8.8/9.0/9.1/9.2, encryption/decryption automation, FTP automation, Data Stage, among other tools.
• Technically adept at Design, Development, Implementation, Customization, Upgrade and Maintenance, Support of PeopleSoft Applications.
• Involved infit/gap analysis, designing gap strategies and recommending business process changes to take advantages of delivered functionality and eliminate obsolete customization.
• Proficient in creating functional, technical specification documents, system test plans and Integration test plans.
• Warehousing, Data modeling, dimensional modeling, develop ETL Data Stage tools and techniques.
• Integration specialist across various internal and external systems.
• Expertise in developing inbound and outbound interfaces to Payroll and other external systems.
• Expert in data validation, analyzing, mining and data fixes.
• Expert in providing alternate successful methods for overcoming the existing risks.
• Expert in identifying root cause of issues and provide immediate solutions.
• Expert in tuning long running SQL queries.
• Good experience with Agile Methodology for ongoing and changing requirements.
• Conversant withGlobal Delivery Modelinvolving onsite/offshore teams.
• Strong technical expertise in Oracle SQL and TOAD.
• Strong experience HRMS Data Conversion projects.
• Strong technical expertise in object-oriented technologies/concepts.
• Ability to develop effective working relationships that improve the quality of work products.
• Strong organizational skills and able to handle competing priorities.
• Ability to maintain focus and develop proficiency in new skills rapidly.
• Ability to work in a fast paced environment.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS 8.x/9.x, EPM 8.x/9.x (Workforce Administration, ESS, MSS, Payroll, Core HR, Base Benefits, Compensation, Time & Labor, eRecruitment, Campus Solutions)

Software: PeopleTools 8.4x/8.5x

Tools: Application Designer, PeopleCode, Application Engine, Component interface, Process Scheduler, Application Package, XML publisher, Work Flow, Integration Broker, Tree Manager, PS Security, Data Mover

Reporting: SQR, PSQuery, nVision, Crystal Reports

Databases: Oracle 11g 10g 9i, MS SQL Server 2012

Languages: C, C+, HTML

OS: Windows XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

Senior Developer

Responsibilities:

• Involved in running the PS Delivered Application Engine process for data conversion from current version to the newer version.
• Involved in multiple activities as part of Peoplesoft HR upgrade project from 9.1 to 9.2.
• Modified the standard and custom peoplecode, app engine, app package programs to inherit the new 9.2 changes and existing customizations.
• Converted peoplesoft Classic pages to Fluid pages.
• Worked with Page Composer tools to provide smooth approval functionality for users on mobile.
• Worked on WorkCenters to provide quick links and access to Reports/Queries.
• Involved in implementing Elastic Search.
• Involved in maintenance of HR, Benefits, Payroll and eApps.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes like Paysheet creation, PayCalc, Payconfirm, Tax Tables etc.
• Customized and modified ePerformance, eCompensation, eRecruit pages upon user requests.
• Built custom configuration pages to the users to be able to add items that are used in ePerformance documents.
• Modified Custom 9.0 SQR's into PeopleSoft 9.1 standards as per field name and record name changes.
• As part of the leave accrual customization developed online page for vacation requests. Developed an App Engine program that sends vacation hours to Payroll and e-mail about the request to the manager. eProfile -Added workflow to send email notifications to users and supervisor upon changes to name/address.
• Created new Application Engine & Component Interface programs to move employees from some of the Jobcodes to another Jobcodes to make them qualify for new Pay Rate increase.
• Developed new Application Engine programs and also customized existing Application Engine programs for TIME REPORT CODE for TIME&LABOUR (PS TCD INTERFACE).
• Used STAT for all versions of your PeopleSoft objects (including non-application designer objects) AND flat files (including COBOL, SQR, SQL, nVision, Crystal, SQL scripts, etc.,) are versioned and stored indefinitely in the Stat repository.
• Involved in Data Conversion for payroll from external system using SQR and Application Engine.
• Fixed any inconsistencies among the database objects before initiating the upgrade process using the initial Audit Reports.
• Created SQR reports like Service Award Report, Special Income Reports, Applicant Data Flow Report, Audit for FSA Deduction Report for HR, Benefits and Payroll.
• Used Process Scheduler to schedule various SQR’s programs.
• Developed the Application message to be triggered to update the tables in HRMS, when there is a change made to Financials Business unit data.
• Involved in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.

Confidential, Hartford, CT

PeopleSoft HCM Upgrade from 9.1 to 9.2 Developer

Responsibilities:

• Performed Fit-Gap Analysis to come up with requirement matrix based on new features/changes in PeopleSoft 9.2 features as part of the upgrade from 9.1 to 9.2.
• Configuration of several HCM components in 9.2 and migration of data from 9.1.
• Conduct regular meetings with Users, Business Analysts and SMEs to gather the requirements.
• Responsible for accelerating PeopleSoft Upgrade Process with self-developed PeopleSoft Upgrade Accelerator Tool.
• Responsible for ensuring that all existing customizations are successfully retrofitted in upgraded environment.
• Developed the reusable program utilities to identify various impacted custom/customized objects that are using PeopleSoft modified objects.
• Developed SQR programs to synchronize vendors between the PeopleSoft HRMS payroll system and the PeopleSoft AP system.
• Integrated HRIS system with FIN app to sync the new employee information entered in HR system.
• Performed data validation tasks for the conversion of HR data from external sources.
• Applied peoplesoft security across all the user pages to restrict access levels.
• Provided facility to map Legacy department values with target peoplesoft values.
• Developed a workflow process using AWE to approve the new departments.
• Replaced Crystal Checks with BI Publisher.
• Developed a program to read the XML file (Mapping Info) sent by 3rd party search tool.
• Created a process to auto generate new department ids using Component Interfaces.
• Worked with Multi Language objects and second language descriptions.
• Developed configuration pages to define Integration and Mapping rules.
• Developed a process to load Combo mapping templates with dynamic structure.
• Data Conversion from Legacy Systems to PeopleSoft.
• Worked with SQRs to create reports and interface files.
• Worked with Style Sheets to fix page display bugs in Chrome browser.
• Created PS queries for Ledger data reporting purposes.
• Prepared Design Documents, Estimates and Unit Test cases for the given requirements.
• Tuning specialist for slow running Financial Processes.
• Worked on DR Plan for the HR System.
• Worked on DATP Reports for peoplesoft code base.
• Migrated PeopleSoft projects using STAT.
• Upgraded Stat Tool from version 5.4 to 5.7.

Confidential, Hartford, CT

PeopleSoft EPM Maintenance Lead

Responsibilities:

• Single Point of Contact for all Payroll/Benefits issues during following phases of the project: Unit Testing, Functional Testing, Integration Testing and User Acceptance Testing.
• Prepared detailed system test plans and parallel test plans.
• Conducted parallel payroll runs and matched payroll results cent-to-cent. Responsible for explaining differences in parallel payroll run to business partners and get sign-off from business users.
• Responsible for accelerating PeopleSoft Upgrade Process with vast upgrade experience from various projects.
• Performed Fit-Gap analysis and Explain the new functionality in 9.1 to client and get approval to use the delivered functional and retire appropriate customizations.
• Single Point of Contact for Functional/Technical/Data Conversion issues.
• Validated the upgraded environment data with self-developed utilities to ensure that data is consistent and security is still intact.
• Responsible for fixing Data Conversion issues while preparing Upgraded Environment.
• Responsible for implementing Security across the Payroll and Benefits Module.
• Automated the process of reviewing huge number of upgrade retrofits.
• Developed Payroll Interface Files to third party systems using Application Engine and SQRs.
• Responsible to sync the deduction and policy codes into third party systems using Integration Broker.
• Prepared detailed system test plans and parallel test plans.
• Conducted parallel payroll runs and matched payroll results cent-to-cent. Responsible for explaining differences in parallel payroll run to business partners and get sign-off from business users.
• Prepared Go-Live project plan and check list of all activities during Go-Live.
• Conducted Feasibility study to move hourly employees to existing PeopleSoft North American payroll system.

Confidential, New York, NY

PeopleSoft HR Payroll Feed Processing Lead Developer

Responsibilities:

• Lead and facilitate business process improvement change. Provide business expertise and input to the design, improvement and overall solution architecture of the Time & Labor, Absence Management and Payroll systems.
• Analyzed business needs and work with technical resources to develop, design and test the solution for customizations, interfaces, and reports.
• Developed and implemented plans to assist in legacy system data clean up and data mapping.
• Defined user roles, responsibilities and security.
• Configured Take elements and calculation rules for Vacation, Sick, Paid Time Off, Extended Leaves, Bereavement, Jury Duty, Office Closed etc.
• Configured absence accrual and leave request processing functionality, including a rules engine to compute the most complex accrual, consumption, payout and carryover logic.
• Setups of Extended Leave Templates and configuration of extended leave calculation rules for client's FMLA, Maternity, Worker's Compensation and Infant Care leave types.
• Configured request approval functionality, including multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service and Approval Workflow Engine.
• Automated Leave Donation, Leave Receipt, and Leave Return administration processes.
• Created custom Workgroups, Schedules, template-built Rules and Rules Programs.
• Configured rules for Overtime, California Overtime, Additional Straight time, Holiday for FT and PT, Comp time and Meals.
• Developed Configuration/ Setup pages for relocation process.
• Implemented workflow & worklist activities throughout the Relocation Process.
• Created Relocation Submit Form.
• Used XML publisher to generate HR signed forms to Employee after HR approvals.
• Developed process for Estimation of Reimbursement Payment Items.
• Developed Vendor Payments approval and payment process.
• Developed the process to Approve/Reject the submitted Payment Requests.
• Created Interfaces to send and receive feed files to and from various other systems.
• Created process to manageRelocation upon EE Termination and Manage Deviation of Policy Request.
• Created Reminder Reports that send notification of pending activities to Relocation Coordinators.
• Processed multiple HR Payroll Feed files from External systems using PeopleSoft and loaded the data into various tables of PS Job Component with all validations.
• Provided a facility to download the error records for the submitted file and resubmit with corrections.
• Integrated PeopleSoft with DataStage to automatically process the uploaded files on server.
• Used CI to load Employee Performance Ratings.
• Created Tax Update components.
• Implemented Single Sign-on to connect from External Systems to PeopleSoft HCM/EPM.

Confidential

PeopleSoft HCM Upgrade 8.8 to 9.0 - Lead/Developer/Analyst

Responsibilities:

• Analyzed 9.0 Base Benefits setup changes and conduct sessions with HR department to understand the company Benefit plans and Pension policies.
• Configured and created new Formula ID’s for the Life and AD/D Plan table and Disability Plan tables.
• Analysis and walk thru sessions with HR team to identify the Calculation Rules and Coverage codes, Rate IDs. Explain and map the new changes in 9.0.
• Documented the Benefit and Pension rule changes with 8.8 and 9.0.
• Worked on Custom Benefit Premium report by Vendor and Plan Types and CICS reports, Benefit Program Table report to retrofit the 9.0 Flat Table/Formula changes.
• Worked on PeopleSoft 8.8 MSS 4 level of workflow for Retire, Terminate and Job Change including HR BP and HR Trans Administrator approvals.
• Upgrade and retrofit the custom and bolt on definitions/PeopleCode from 8.8 to 9.0.
• Configured and redesigned ESS/MSS 8.8 workflow in 9.0 using AWE and delegation process.
• Involved in Technical assessment on eRecruitment customizations on Weighting Factor and Person and Non-Person validations.
• Develop prototype for initial eRecruitment development changes to the Business users.
• Implemented Internal and External Candidate Gateway for profile submission.
• Involved in solution design for External/Internal Gateway access architecture sessions.
• Implemented 4 levels of HRBP/HR Trans AWE workflow in eRecruitment 9.0.
• Worked with HR users on Fit/Gap analysis for Base Benefits 8.8 and 9.0 Rate Table changes.

Confidential

PeopleSoft Upgrades and Enhancements Senior Developer/Analyst

Responsibilities:

• Handled various types of SR’s related to technical way like SQL Scripts, PeopleCode, Application Engine programs and Component Interface.
• Customized the Workflows to send the mails to treasury box for accounting details.
• Developed Reports by using reporting tools SQR, Crystal Reports and Ps-Query.
• Worked in component Interface to create interface to PS and Taleo process.
• Written various types of sturdy PeopleCode as per the requirement to implement the business rules and validations.
• Developed the Application Engine program to send email attachment to HR box for employee leave details.
• Developed the component interface for outbound to Ariba application.
• Technical developer on Major Upgrade from HRMS PeopleSoft 8.4 to 8.8.
• Team leader on applying vendor patches and tax regulations for PeopleSoft 8.8.
• Track record of on-time; project delivery with excellent ability to assess user needs, establish project specifications, evaluate resources available, and implement the project plan successfully.
• Wrote PeopleSoft Application Engine and Component Interface programs to load data and automate data entry, including new hire, annual increase, Electronic Test Score data.
• Developed advanced PeopleSoft QUERY training material and taught custom training sessions to users.
• Coded major enhancement for all PeopleSoft jobs (Application Engine, SQR, Component Interface, Cobol) and external Batch jobs.
• Developed and implemented full-cycle applications in PeopleSoft 8.4/8.8, including menus, pages, views, queries, and reports.
• Developed more than 150 unique PeopleSoft SQRs.
• Implemented and designed data warehouses including denormalizing data, creating fields/tables, queries, menus, pages, tuning database objects, and migration of the data.
• Created technique for query users to use stored Oracle database Functions to speed up query development and training. Implemented storing technical documentation directly in these Functions.
• Responsible for PeopleSoft 8.8 functional testing, stress testing, and deploying any technical modifications, indexing, SQL tuning, or Optimization for new developments or existing PeopleSoft 8.8 processes that run slow.
• Replaced the Purge process in PeopleSoft 8.8 with custom code using same vanilla PeopleSoft requirements, process purged large sets of people faster than 1 person via the delivered process.

Confidential

Responsibilities:

• Performed new Implementation of PeopleSoft Global HR 8.8 at the BHC
• Developed new Views, Pages, Components, and Records for HR users for data entry purposes
• Worked hand with the functional development team from Bearing Point
• Provided technical support for PeopleSoft Payroll to ADP Interface
• Worked with PeopleSoft 8.8 Recruit modules. Added pages to existing components.
• Investigated PeopleCode functionalities for the Recruit module
• Implemented PeopleSoft HR 8.8 Portal administration and Security administration.
• Implemented security based on both location and department. Implemented portal security as well
• Submitted processes to the Process Scheduler to run daily tasks recursively at specific intervals
• Responsible to Upgrade the PeopleSoft Financials 8.0 (SP2) to 8.8 work on Functional analysis
• Responsible to Upgrade PeopleTools v8.47
• Fit-gap analysis and compare release across PeopleSoft modules
• Upgrade configuration documents, Vanilla Compare reports, SQR jumpstart compare reports
• Created UAT scripts and perform testing in coordination with users in UAT phases
• Coordinated Project meetings, Oracle Upgrade (Sandbox) Lab meetings, Vendor team meetings and technical framework for development activities.