PROFESSIONAL SUMMARY:

• Experienced Professional in all stages of Systems Development Life Cycle including Business Requirement Gathering, Design, Data Conversions, Programming, System, Integration, User Acceptance Testing and Documentation. Expert level skills in PeopleSoft HCM and Campus Solution modules.
• 4+ yrs in Peoplesoft as a PeopleSoft Techno - Functional Consultant.
• Experience in Data Conversions between PeopleSoft and legacy systems including conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Expert understanding of Confidential Modules - Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), Base Benefits, North American Payroll, Confidential and Talent Acquisition Management ( Confidential ), position management .
• Experienced in Campus Solutions\Student Admin modules-Student Records,Campus community,Admissions,Academic advertisement,Student Financials,Financial Aid.
• Communicated with external vendors and resolved the issues to access the Peoplesoft data.
• ADP Enterprise experience in HR, Payroll and Benefits.
• Good experience on PeopleSoft 9.0 to 9.1/9.2 Application Upgrade.
• Extensive experience of different types of testing e.g. Unit Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Load and Performance Testing.
• Documentation - Involved in analysis, creation and updating the Functional Design Document (FDD), Technical Design Document (TDD), Process Flow, Processing Logic, Unit Test Plan Document (UTP), Migration Check List, Minutes of Meeting (MOM), Weekly Status Reports, Coding Standards Document, End User Training Documents, Data Mapping & Conversion Strategy Documents.
• Work Experience on UNIX, Windows Servers, Shell Script, Batch Scheduling Application Control-M, Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Control Tool STAT and Defect Tracking Tools like HP Quality Center and Test Director.
• Analyzed and Applied Tax Updates, HR Bundles & Patches extensively.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
• Proficient in gathering and analyzing requirements to successfully design applications based on user needs.
• Maintained,administered and supported Peoplesoft Campus Solutions.
• Proficient experience in Healthcare applications
• Provided extensive production support to HR, Payroll and Benefits modules.
• Ability to deliver the best even in the most critical phases of the project.
• Possess excellent communication skills, zeal to adapt to new technologies and good Team Player.

TECHNICAL\ FUNCTIONAL SKILLS:

ERP Module: PeopleSoft HRIS (9.0/9.1/9.2), PS HRIS (HR, Payroll, Benefits, Confidential, eBenefits, eProfile, eRecruit, T & L), PS CRM (Call Center), PS ELM (9.2/9.1/9.0), PS Portal(9.1/9.0)

People Tools: Application Designer, PeopleCode, Application Engine, Component Interface, Security, Data Mover

ETL Tools: Abinitio, Ascential Datastage

Reporting Tools: SQR, Crystal Reports, Nvision, Business Objects, BI Publisher, OBIEE

Databases: Oracle11g,DB2 and MS SQL Server

Operating Systems: Windows Server 2008, UNIX (AIX, HP, Solaris).

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

PeopleSoft HCM Techno-Functional Consultant

• Involved in upgrade of PeopleSoft HCM 9.2 and People Tools 8.55. Involved in the design, development and testing of all HR, Payroll, Confidential and Confidential, Benefits Administration, Manager Self Service and Employee Self Service..
• Developed custom Confidential and Confidential rules to take care of Rounding Rules, Meal over Times and Scheduled Day off. Also, created custom processes to have hourly employee counts based on the Full or Part Confidential status and the number of active hours worked.
• Created Template/Custom Built Rules using Daily Threshold, Holiday and Guaranteed Hours and customized the rules using SQL objects, actions and conditions as well as user exits Customized Daily Confidential Calendar, Weekly Elapsed Confidential Entry, and Punch Confidential Entry and Manager Confidential Approval pages as per the requirements. Extensively used PeopleCode and PeopleTools during the customization.
• Perform fit/gap analysis and development for providing long term access solution to PS HR system for terminated associates.
• Coordinated and applied number Bundles & Patches to keep the system to latest patch.
• Timely and regular application of  Confidential Payroll Tax Updates.
• Supporting issues for Confidential Payroll, Confidential and Confidential during bi-weekly payroll processing.
• Established pay calendars that reflect the various payroll periods, pay dates, and Fair Confidential Standards Act (FLSA) periods throughout the year.
• Applying latest bundles using PeopleSoft Upgrade Manager PUM and Virtual Box
• Install Change Assistant, run initial passes and MTPs, Install Oracle Secure Enterprise Search db software and configure it from within application, Install Bundles PUM Images using Oracle Virtual Box.
• Retrofitted the pay check generation (PAY003) SQR process and advice form generation (DDP003) SQR programs to include the client specific XML tags to pay check/advice form data source
• Implemented the Open Enrollment processes; Customization of enrollment forms and confirmation statements.
• Customization of Health, Disability, Savings Plan, Life panel, FMLA panel etc in the Benefits module.
• Designed & customized eBenefits Home Pages (Benefits enrollment) Flexible spending Accounts pages & life Events (Marital status Change) Using Application Designer, People Tools, People Code
• Involved in Integration, functional and regression testing using Manual Testing methods and QTP Automation Tool.Responsible for on Confidential and quality deliverables, preparing day-to-day testing status report
• Designed and developed the PeopleSoft applicant job search functionality in Candidate Gateway based on Job Category instead of delivered Job Family
• Customized various pages in Core HR, Confidential, Profile Management and ELM as per the client needs. Created custom application package for the Peoplecode.
• Involved in analysis, preparing specifications and development for customizations on Enroll Learners, Maintain Enrollments, catalogs and rosters pages and Setting-up Approval Work Flow Engine/Work lists for ELM application.
• Enabled access to ELM from Enterprise Portal by setting up a single link to PeopleSoft ELM application content provider and set up the single sign on.
• Reconfigured the existing learning programs/certifications/activities to resolve issues with integration with HR.
• Involved in Recruitment Templates setup, Questionnaire setup, Recruitment Source setup.
• Resolved complicated defects related to their custom hire and Confidential applications involving heavy Application Package Peoplecode.
• Designed Mass Enrolment Application Engine Process for ELM as per the business requirement.
• Designed and developed a custom Run Control Page for the XMLP Application Engine program where user can select the output format (XLS or PDF or RTF or HTML). Output for each interface file generated from the Application engine would be the format selected on the run control page
• Configured Work Experience ( Confidential /CG) as content type and modified the HRS application classes\CG pages to store the work experience data as content items.
• Configured the Resume Mirror/Hire Right vendor setup and customized the HRS HROI application classes for the client custom passive applicant type.
• Created and modified the Application Packages to validate and move the applicant data (custom fields in offer component) from eRecruit\ Confidential to HR module.
• Customizations and making necessary changes on a regular basis as per the client’s needs.
• Configured the PeopleSoft interaction Hub to develop the landing page for the self service applications.
• Rewrote the entire custom Hire Applicant Application Engine program which loads the data from the Applicant tables into the PERSONAL DATA AND JOB Components for New Hires, Rehires, Reinstates and Internal Transfers.
• Designed and Developed a custom Non-Employee hire Application Engine program which loads the data from a data file using File Layouts and Component Interfaces into PERSONAL DATA AND JOB DATA CWR components.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft HCM with third party services and publish the employee information from PS HCM to other application.
• Created a custom Application Package for implementing error handling for the custom Load Applicant Data and Hire Applicant Application Engine programs.

Environment: PeopleSoft HCM/Core HR v9.2 (ESS,MSS, Confidential, CG,T&LPayroll,Performance,Benefits), People Tools v8.55, AWE, App Package.

Confidential, Wilmington, DE

Sr. PeopleSoft Techno-Functional Consultant

• Create prototypes for new designs and walk through with business owners
• Develop functional specs for special projects, data flow diagrams flow charts and functional mapping for automated solutions in support of business process operations and functions
• Design of the Functional and Technical Specs for the Confidential & CG customizations
• Worked on setup of Manager Dashboard Pages and Direct Report Pagelet and Alerts Pagelet.
• Involved in creating Portal header and pages branding, styles on the menu.
• Involved in developing the Test strategy, planning, estimate, risk, assessment, mitigation and test cases for QA evaluations.
• Prepare detailed data maps spanning Human Resources, Benefits, Confidential & Confidential, Position Management and Payroll
• Interface regularly with customers at various levels.
• Online pages to view the Leave balance and Comp Confidential Balance at one place.
• Created training plans and documentation for functional users on the use of the product.
• Involved in logging all the defects: code, documentation, Data issue, and environmental bugs in Quality Center.
• Worked on PeopleSoft Branding and home page modifications.
• Worked on the misc. T&L customizations such as timesheet, payable Confidential and exceptions pages.
• Involved in Testing & Defect tracking few processes in HR, Benefits & Payroll modules.
• Key technical team member in an effort to the existing system to PeopleSoft HRIS 9.2, which included requirements gathering, fit-gap analysis, technical planning deadlines, unit testing and customer acceptance testing.
• Setting up of Confidential & CG related security like Recruiting roles, Recruiting row level permission list
• Functional setups including all Recruitment module setups for the Candidate Gateway and Confidential . Functional security and site setups for multiple web site entries for open positions in a World Wide environment.
• Design of the Functional and Technical Specs for the Confidential & CG customizations
• Configurations in Recruiting installation.
• Developed & Setup EDI transactions between PeopleSoft & Biz Manager using Integration broker, Created custom handlers for inbound / outbound transactions.
• Configuration and Administration of Confidential & CG transactions Created Custom Confidential distribution process using App Engine Program.
• Analyzed and designed the customizations of delivered Global Absence management for Vacations and Work Risk leaves for ASCI.
• Online pages to view the Leave balance and Comp Confidential Balance at one place.
• Created training plans and documentation for functional users on the use of the product.
• Created complex queries for functional users to support day to day processing.
• Online development/customizations of pages, queries and also online validation using PeopleCode.
• Supported PeopleSoft Payroll by debugging user and system errors in Payroll processes which includes SQR, Component Interface and Application Engine Processes.
• Involved in design and implementation of standard heading SQC’s customized to suit client requirements for all the payroll-related reports.
• Designed and developed several interfaces to load data into PeopleSoft Payroll from different vendors/systems using SQR, Application Engine and Component Interface.
• Designed and developed to modify Health and Safety module to add new fields to track if the accident is the result of the operation of motor vehicle.
• Designed and developed Component Interface to terminate the benefit due to death, Utilized Application Engine to invoke the Component Interfaces
• Managing the integration with ELM and HCM system
• Extensively worked on Integration Broker for Integrate with third party systems, Web Services, WSDL, XML, SOAP.
• Integration project between Candidate gateway module, Talent Management module and Web UI. 3rd party application/Web UI invokes SOAP web services to PeopleSoft. Moreover, PeopleSoft consumes WSDL from IBM content manager-FileNet.
• Extensive experience in developing applications for JBoss, Tomcat.
• Extensively worked on Integration Broker for Integrate with third party systems, Web Services, WSDL, XML, SOAP.
• Integration project between Candidate gateway module, Talent Management module and Web UI. 3rd party application/Web UI invokes SOAP web services to PeopleSoft. Moreover, PeopleSoft consumes WSDL from IBM content manager-FileNet.
• Analyzed and reapplied the customization in 9.2 BI publisher from Crystal reports.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Design and developed custom message based web Services to render equipment, personal and task related data to the custom java based Ops Board portal.
• Experience in testing tools like Mercury Test Director, Test Track Pro and standard industry practices for ERP QA Life Cycle.
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing / advice form printing specific to client requirements
• Configure, troubleshoot and Support all the tables involved in Payroll processing like Pay calendar, Job Code, Deductions and processes such as Pay Sheet creation, PayCalc, PayConfirm, Tax Tables etc.
• Developed Application Engine to generate XML publisher report for succession planning report, employee Interim and Year End performance.

Environment: PeopleSoft HCM/CRM v9.2 (MSS, ESS, ePerformance,HR Help Desk), Portal, Tools v8.54, IB, AE, CI, Web Services, DB-2 and UNIX

Confidential, Tampa, FL

PeopleSoft HRMS Technical Consultant

• Designing, coding and testing PeopleSoft Human Resource and Payroll modules.
• Worked on detailed designs for HR module for retrieving the employee’s historical data from Oracle Data Warehouse.
• Designed, Customized & Tuned Records, Fields, Pages, Menus, Components, SQL Queries, DMS scripts, PS Integration, PeopleCode events, Grids & Scrolls, Cursors & SQLEXEC.
• Developed and modified various interface SQR programs and reports in HR, Payroll and to meet the business requirements
• Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.
• Supported in Troubleshooting and fixing of batch processes for HR, payroll modules
• Extensively used People Tools for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR's/AE through People Soft environment.
• Supported in Troubleshooting and fixing of batch processes for HR, payroll modules. 
• Worked with Employee Self Service and Manager Self Service Modules. 
• Scheduled and monitored jobs using Process scheduler.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Confidential & Confidential Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Confidential & Confidential .
• Created custom processes to have hourly employee counts based on the Full or Part Confidential status and the number of active hours worked.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Design and developed custom message based web Services to render equipment, personal and task related data to the custom java based Ops Board portal.
• Designed and developed many inbound and outbound interfaces to and from PeopleSoft payroll system.
• Debugged and modified several batch processes like Vacation Process, Sub Credit Union Process for the Payroll team.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People code, which will be further populated into Corresponding PS tables using Conversion SQR programs..
• Analyzed the Customizations to the delivered SQR reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired.
• Designed and developed the Java classes to create the compressed images from the online Confidential Sheets. Created an Interface to store online Confidential Sheet images in LiveLink (Document Management System).
• Reapplied the Customizations to SQR reports in the new release
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over Confidential .
• Developed data mover scripts to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.
• Developed a series of Workflows to send an email and work list to appropriate roles on the event of Hire/ Rehire / Terminate, Promotions, Demotions, change of personal data, address, name etc to employees using Approval Workflow Engine to notify the changes to them so that they continue with their respective tasks.
• Involved in setting up the Workflow for the self-service transactions such as Job Requisition approval as per the business rules of the organization.

Environment: PeopleSoft HCM (ESS,MSS, Confidential, Profile Management, ePerformance, Confidential Payroll, T&L) 9.2, People Tools 8.54, AWE, IB, App Engine, Application Packages, Send Master, SOAP UI, DB-2, UNIX

Confidential

PeopleSoft Techno-Functional Consultant

• Played a key technical role in implementation of PeopleSoft Campus Solutions.
• Gathered requirements, drafted designs and tested requirements for course transfer credit rules, substitutions, foreign language waivers and certification waivers per client’s business processes  
• Used Application Designer to build new fields and modify existing record definitions, Create or Alter tables, creating new SQL views.
• Developed and customized online pages, according to the Business process as per Business area requirements.
• Online pages for financial administrators to manage earnings and work study awards.
• A complex Student Alert system in Campus Solutions for academic and student life advisors.
• Assist clients with the implementation and optimization of PeopleSoft Campus Solutions modules
• Structuring Campus Solutions Frameworks and utilities; 3C's (Communication, Checklists and Comments), AAWS, Pop Select, BI Publisher and PeopleSoft Query to improve client’s business processes 
• Work on high priority code fixes and new enhancements.
• Rewrote SQR processes used to gather and summarize data from the school's Adult Education Program and also
• the PeopleSoft integration program used to upload this data on a daily basis.
• Wrote an Application Engine process for School Certification Officials that recalculates tuition for Veterans at each campus attended whenever changes are made to that student's enrolled hours, types of classes taken or distribution of enrollment hours between campuses. Improved accuracy and efficiency of entire Veterans Compliance Process. Process was so accurate that it discovered flaws in the school's existing tuition calculations for Veterans and Non-Veterans.
• Developed application engine programs to load data from HR and financials systems to Oracel BI dataware house systems.
• Developed several integration broker messages between HR and Financials to exchange data,
• Involved in creating several PS queries in HR and Financials and nVision reports for GL reporting.
• Involved in database tuning to improve run Confidential performance.
• Work on high priority code fixes and new enhancements..
• Designed and implemented reports using SQR and BI Publisher.
• Developed Business Reports by using Crystal report tool.
• Maintaining Security to give security access to end-users for those existing and newly developed components.
• Involved in PS Query Profiles, opening, modifying and building queries, Query Tree using PeopleSoft Query Tool and assigning created new Query into Process scheduler for End User Reports and Batch processing.
• Used Application Engine to do bulk insert, bulk update and delete database
• Troubleshooting security issue triggered during User Acceptance Testing  
• Configuration validation between environments to ensure clean migrations.sessions, configuration, testing and end-user training.

Environment: PeopleSoft HCM 9.1,PeopleSoft  Campus  Solutions, Portal, Tools v8.52, IB, AE, CI, Web Services,crystal Reports.

Confidential

Jr. PeopleSoft Technical consultant

• Participate as a technical consultant in PeopleSoft projects in the technical / infrastructure area.
• Customisation of on-line various Records, Pages and Component definition according to the client’s requirements by using application designer.
• Day to day support to the PeopleSoft HRMS system.
• Prepare the Technical Design Documents for the enhancements.
• Resolved technical requests raised by Client as fix.
• Analyzed and developed SQR programs, People Code, Application Engine programs.
• Developed Run control Pages as per corporate requirements and attached to menu to run the SQRs online through Processes.
• Used AppEngine, File Layout and Component Interfaces when inserting data into PeopleSoft Tables comes from Third Party Customization as well as new enhancement in existing system.
• Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from technical perspective.
• Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People Code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Developed Crystal reports for Business users to enter HR Forms job data.
• Customized Application Engine to generate Crystal report for succession planning report, employee Interim and Year End performance.
• .Prepared the test cases for the issues fixed and verifies the code in different scenarios. 
• Work on high priority code fixes and new enhancements.

Environment: PeopleSoft HCM/Core HR v9.1 ( Confidential, CG,T&LPayroll,Benefits), Tools v8.50, AWE, App Package,webservices,Crystal Reports.