SUMMARY

• Qualified Certified professional with over seven years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, programming, system / integration / user acceptance testing, documentation and exclusive experience in PeopleSoft HRMS/HCM and expert level Skills in PeopleTools.
• Over 9 Years of experience in IT industry.
• More than 9 years of experience in implementation, upgrade, writing interfaces and administration of PeopleSoft HRMS (HR, E - Performance, Payroll, Benefits, eRecruit, TAM, Manager Self Service, Employee Self Service, Time and Labor, Absence Management), PeopleSoft ELM (Catalog, Learners and Enrollment), PS CRM (Call Center).
• Extensive IT experience in Java and J2EE Technologies including Struts, Web Services, Servlets, JSP, JDBC, XML, HTML, CSS.
• Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, MS-SQL Server, MySQL, Postgre SQL.
• Involved in developing web applications using HTML, AJAX, XML, CSS, Perl and JavaScript (Knockout js).
• Created specifications and programmed interfaces to and from PeopleSoft system to satisfy business requirements.
• Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Extensively worked with PeopleTools such as Application Designer, Approval Workflow Engine, Application Engine, Integration Broker, Application Messaging, SOA architecture, Component Interface, PeopleCode, Security, Tree Manager, Process Scheduler, Data Mover and Query tools.
• Extensive experience in writing Interfaces between PeopleSoft HRMS and Financials.
• Worked as a Technical Analyst for Peoplesoft Enterprise Learning Management System (ELM) implementation project.
• 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.
• 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 SKILLS

ERP Module:  PeopleSoft Hrms (8.0/8.3/8.8/8.9/9.0/9.1 ), PS HRMS (HR, Payroll, Benefits, TAM, eBenefits, eProfile, eRecruit, T & L), PS CRM (Call Center), PS ELM (9.1/9.0), PS Portal(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:  Oracle,DB2 and MS SQL Server

Operating Systems:  Windows Server 2008, UNIX AIX, HP, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Senior PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• 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, TAM, 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 TAM 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 (TAM/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\TAM to HR module.

Confidential, New York, NY

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Key technical team member in an effort to upgrade the existing PeopleSoft HRMS system to 9.1, which included requirements gathering, fit-gap analysis, technical planning deadlines, unit testing and customer acceptance testing.
• Setting up of TAM & CG related security like Recruiting roles, Recruiting row level permission list
• Functional setups including all Recruitment module setups for the Candidate Gateway and TAM. 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 TAM & CG customizations
• Configurations in Recruiting installation
• Setting up of appropriate Statuses, Status Reasons & Status Areas
• Design & Creation of templates (Job Opening, Resume, Screening & Recruitment)
• Configuration and Administration of TAM & CG transactions Created Custom labor distribution process using App Engine Program.
• Online pages to view the Leave balance and Comp time 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.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Customized PeopleSoft Pages, Records and People Code to accommodate client functionality in HR and Payroll modules.
• 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.
• Developed SQR for one time deduction in Payroll.
• Customized Application Engine program to upload Time to Payroll Paysheets.
• Created Workflow for email notification of all employees based on business requirements.
• 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 to notify the changes to them so that they continue with their respective tasks using Approval Workflow Engine Tool.
• Created Unit test plans and involved in executing test conditions with the test data.
• PeopleCode has been extensively used at all levels like Component, Component record, Component record field, Page etc.
• Provide Technical Support to the business users.
• Created two custom pages, one for displaying the recent paycheck information and the other to display the previous paycheck information.
• Modified PeopleCode to validate the emergency contact information and display the error messages if key information is missing on the pages and to default country to USA if user has selected a different value other than USA.
• Designed and developed an outbound interface for stock options with Smith Barney using SQR to send participant transactions for active, terminated and retiree employees.
• Created a new outbound SQR to send all eligible enrollees and dependents to initialize the new Empire plan carrier.
• Created a new outbound SQR to extract all the enrollees who are eligible for low income subsidy as part of the medicare part D module and transmit the extracted file to Part D vendors.

Confidential , Philadelphia, PA

Senior Technical Consultant

Responsibilities:

• Involved in completing Implementation tasks for Peoplesoft Enterprise Learning Management System (ELM).
• Setup, configured and troubleshoot Peoplesoft Enterprise Integration Points (EIP’s) between ELM 9.1 system and HRMS 9.1 Peoplesoft system. Person and Organization, Objective and Competency EIP Messages (Full Sync and Incremental Sync EIP’s).
• Worked with ExcelToCI tool to import Learning Resources, update/map Learning references to objectives/competencies and written sql data loading scripts.
• Performed customizations to populate ELM Specific fields.
• Setup and configured Enterprise learning Approval framework. 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.
• Involved in auto creation of User Profiles by setting up Single Sign On between Enterprise Portal and ELM, configuring integration with Active Directory for LDAP, activating the Sign on PeopleCode functions to authenticate users against directory server, modifying the update User Profile function to populate ELM-specific fields.
• Prepared a test plan for integration, security test strategies along with test case documents.
• Performed installation, maintenance of PeopleSoft ELM software and migration of configuration (i.e. setup data) between environments.
• Worked towards Integrating ELM with AICC and SCORM compliant course vendors.

Confidential , Washington, DC

PeopleSoft HRMS 9.0 Consultant

Responsibilities:

• Designing, coding and testing PeopleSoft Human Resource and Payroll modules.
• Involved in converting the general designs to detailed designs for PeopleSoft HR/Payroll products for custom reports and online PeopleSoft processes according to the client requirements.
• Involved in design and implementation of standard heading SQCs customized to suit client requirements for all the payroll-related reports for PeopleSoft.
• Worked on detailed designs for HR module for retrieving the employee’s historical data from Oracle Data Warehouse.
• Worked on Automatic Union Dues Set-Up utilizing PeopleTools and PeopleCode to incorporate new and complex validations.
• Developed many tax calculation reports like percentage of Tax variation from previous quarter current quarter. Federal and State tax reports.
• Requirement analysis & program specifications.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared the Technical design specifications.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time & Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time & Labor.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over time.
• Developed data mover scripts to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.

Confidential, New York, NY

PeopleSoft Developer

Responsibilities:

• 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.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Reapplied the customizations to SQR reports in the new release.
• Retrofit the customizations and also involved in running the scripts and upgradation reports.
• Designed and developed international employee's compensation conversion program.
• Involved in Unit, Integration, System and User Acceptance Testing.