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 7 Plus Years of experience in IT industry.
• More than 7 plus 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 S and Financials.
• Worked as a Technical Analyst for Peoplesoft Enterprise Learning Management System (ELM) implementation project.
• Experience in Oracle Identity Manager Architecture, configuration, development and Oracle Identity Analytics.
• Proficient in gathering and analyzing requirements to successfully design applications based on user needs.
• Experience in LDAP connectors for Active Directory and Oracle Virtual Directory (OVD).
• 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 HCM (8.0/8.3/8.8/8.9/9.0/9.1/9.2 ), PeopleSoft CRM 9.2 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

Security Tools: Oracle Identity Manager 9.0.1 - 11.1.1.5 , Oracle Identity Analytics 11g, Oracle Access Manager 10g - 11g, Oracle Virtual Directory, Oracle Role Manager

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

PeopleSoft HCM Developer

Responsibilities:

• Design, implement, and support technical solutions supporting the new PeopleSoft HCM system based on input gathered from a variety of sources including Business Systems Analysts, UC locations, analysis results and industry best practices. Provide alternatives to customizations based on best practices.
• Initiates and recommends changes in development, maintenance and system standards. Understands industry practices and department policies and procedures relating to work assignments. Ensures that System Development Life Cycle and change management procedures are followed and documented to support each system development and change requests.
• Participate in peer reviews and inspections of requirements documents, functional and technical designs, and code.
• Applies advanced applications programming concepts in designing, developing, modifying, debugging, and evaluating highly complex conversion programs
• Develop and maintain interfaces and batch control scripts for the PeopleSoft HCM system and supporting processes; develop scripts to support optimal operation of the systems.
• Create migration packages and develop scripts for data and configuration to be migrated across instances.
• Provide technical PeopleSoft 9.2 HCM subject matter expertise and leadership to the team. Collaborates with other staff on complex technical issues and provides alternative solutions.
• Be a knowledgeable resource to mentor others less experienced in application development and production operations.
• Perform other duties and special projects as assigned. May lead a team of software development professionals. Enforces project plans. Provide support as needed to other project areas.
• Provides second-level operational support as needed.
• Every technical design in the environment may have a technical/functional glitch that may affect other technical backend processes/frontend functional processes.
• These need to be addressed in collaboration with the Functional team. A prior approval needs to be taken by self before going into the development of the module. Else this affects the other processes which eventually snowball to a major showstopper.
• Provide estimation for the development cycle is to be drafted and submitted to the reporting lead for final approval.
• Having the Technical Design Document approved, the development of the module is taken over. I use People Tools version 8.56, PeopleSoft Application Designer version 9.2 and PeopleSoft Internet Architecture version 9.2
• Design the Database management that needs to have the query connected to retrieve the data. PL SQL is the tool used for the same.
• Created Unit Test case Document and the functionality are forward to the Functional team for further phases of testing.

Environment: PeopleSoft HRMS 9.2, People Tools 8.56, Application designer, People Code, Process Scheduler, PS-Query, SQL Plus, Application Engine, Oracle 12C, MS Excel.

Confidential

PeopleSoft HCM Consultant

Responsibilities:

• Customizing existing PeopleSoft functionality as per user requirements.
• Working with Oracle Identity Manager (OIM) and integrating OIM and PeopleSoft applications.
• Developing inbound, outbound interface to receive and send data from PeopleSoft HCM 9.2.
• Developing Reports & queries for PeopleSoft users.
• Preparation of Technical Design document, Unit test case documents.
• Developing custom web services interface to Oracle Identity Manager’s API for password management use.
• PeopleCode has been extensively used at all levels like Component, Component record, Component record field, Page etc.
• Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
• Working on detailed designs for HR module for retrieving the employee’s historical data from Oracle Data Warehouse.
• Working on Smart HR template configurations and resolving issues around it.
• Developing and modifying People Code to implement specific business rules and validations to enable the system to perform the business process.
• Resolving issues with workflow approvals & AWE issues.
• Using Phire migration tool for migrating the projects across different PeopleSoft instances.
• Analysis and Design of the Functional specification, Preparation of Technical Specifications, Testing and issue resolution of PeopleSoft Interfaces and Enhancements objects.
• Worked on Custom process in View and Approval Workflow in Profile Manager
• Documentation and Migration (across pre-production/production environments) of PeopleSoft configurations to meet USC’s unique business requirements
• Responsible for Initial Test Plan and Finalizing the Test Planning and Execution of Approval Process. Responsible for Finalizing the Dates for Smoke Testing, Functional, System Integration Testing & User Acceptance Testing and Parallel Test
• Performed Fit/Gap analysis to highlight the business objectives fulfilled by the delivered 9.2 system and the business objectives that required customization.
• UAT, cut over support and post production support.
• Hosted weekly meetings on LATS-NY status with BSC (Business service center) and CMA.
• Supported technical team to custom security pages that enable Help Desk team to add or modify roles for an existing employee and also give the provision to create a user profile for new employees.

Environment: PeopleSoft 9.2, People Tools 8.55, Oracle 12c, Windows, UNIX.

Confidential, Philadelphia, PA

Senior PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the implementation of custom connector for PeopleSoft HCM and ELM v9.1.
• Integrated Oracle’s Active Directory, Oracle Internet Directory, and PeopleSoft User Management Connectors.
• Developed custom web services interface to Oracle Identity Manager’s API for password management use.
• Attended the training session for the Kerberos, DCE, PKI, SAML and other security related topics.
• Integrated Oracle Identity Manager & Oracle Role Manager with PeopleSoft HRMS/ELM systems including (Oracle databases).
• Developed custom Time and Labor 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 Time 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 Time Calendar, Weekly Elapsed Time Entry, and Punch Time Entry and Manager Time Approval pages as per the requirements. Extensively used PeopleCode and PeopleTools during the customization.
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing / advice form printing specific to client requirements.
• 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
• Analyze and redesign payroll to GL interface, defined various earnings types including regular earnings and additional pays, designated shift schedules and shift premium calculation rules.
• 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.

Confidential, Atlanta, GA

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.