SUMMARY:

• Almost 9 years of experience in Information Technology and Services.
• Over six years of extensive experience as PeopleSoft HRMS Techno Functional Consultant in full life cycle implementations and upgrade of PeopleSoft applications.
• Almost 3 years’ of experience in Webservices ( API’s).
• Expert level experience in PeopleTools, Application Designer, PeopleCode, Application Engine, Security Administrator, Process scheduler, Component Interface, PS Query, Workflow and Data Mover.
• Hands - on experience in Analysis, Design, Upgrade, Implementation, Customization, Production support and Maintenance of PeopleSoft HRMS modules.
• Extensively worked with Reporting tools used in People Soft such as SQR’s and PS Query.
• Experienced in Data conversions, and developing interfaces using SQR’s and Application engines.
• Excellent in Database programming of MS SQL server, Oracle and DB2.
• Excellent knowledge of XML, XSD, Webservices- SOAP and REST technologies.
• Experienced in writing Functional-Technical design documents, test plans, test cases.
• Strong Analytical, interpersonal and communication skills.

TECHNICAL SKILLS:

• PeopleSoft HRMS (9.1, 9.0, 8.x)
• Application Designer
• PeopleTools
• PeopleCode
• Application Engine
• File Layout
• Component Interface
• Security Administrator
• Object Security
• Portal
• PS Query
• Workflow
• SQR
• Data Mover
• Webservices
• Oracle 11g/10g/9i/8/7.x, MS SQL Server, DB2
• HR
• Base Benefits
• Workforce Administration
• Time and Labor
• Erecruit
• Compensation ePerformance
• Position Management
• Training Administration
• BenAdmin
• PeopleSoft Security

EXPERIENCE:

Confidential

Data Integration Analyst, Dallas, TX

Responsibilities:

• Create and provide technical design documents and requirements, including workflow designs to programmers, architects and users of Confidential Application Programming Interface.
• Participate in design and planning meeting with customers to determine best practices of Confidential API’s
• Create and maintain all details technical documentation for Confidential API’s.
• Controls customer and vendor access to Confidential API’s using proprietary authentication and authorization tools.
• Designs, monitor regression and unit testing scenario in order to assist customers during integration testing and debugging tasks.
• Resolves data issues and manages request from customers regarding operations of Confidential Applications Programming Interface, including Inbound/Outbound SOAP Webservices and RESTful Webservices calls using analytics tools such as SQL, JSON, JAVA, REST, CSV, SOAP UI, Advanced REST client for chrome.
• Collaborates with developers and SME to analyse trade-off between usability and performance needs.

Tools: & Technologies: Webservices, REST, SOAP UI, XSD, XML, Java script and portals changes.

Confidential

PeopleSoft Techno-Functional Consultant, Houston, TX

Responsibilities:

• Developed several Inbound and Outbound Interfaces to send and receive interface files to and from vendors.
• Modified delivered SQR’s to meet business needs.
• Developed custom reports for reconciliation of reporting, developed new reports like History of changes, active employee, quarterly pay check reports.
• Setting up of the module control tables in Benefits such as benefit plan table, coverage group table, leave plan table, salary rate table, retirement plan table, include field for employee deduction and company contributions.
• Maintained and provide front line support for existing PeopleSoft System.
• Loaded data from ADP files into PeopleSoft environment using uploading tools like Component Interface, SQR etc.
• Customized existing Pages, People Code to meet company’s business requirements such as benefits summary page, benefits enrolment page, Timesheet page in self-service, Approve time and exceptions in MSS.
• Developed a series of work flow 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.
• Created process definitions and new run control pages, components to run different reports and processes. Also created Job definitions and scheduled jobs.
• Setting up Users, Roles, Permission lists to maintain Security.
• Production Support, maintenance and Rotational- On call support.

Tools: & Technologies: People Tools, HRMS version 8.8/9.1, Time and Labor, Pay roll, SQR, Application Engine, Application Messaging, Workflow, SQL, People code.

Confidential

PeopleSoft Techno-Functional Consultant/ Team Lead, Houston, TX

Responsibilities:

• Global Payroll Access module which was a customized module developed for Confidential to enable its HR dept. to do job changes for Hire, transfer and status changes. Workflow and approvals were created at each level and final data was sent to PS tables at final approval by creating Component Interface.
• Workflow was designed and developed to handle business process.
• Created Custom Reports, Processes and Interfaces that were used.
• Worked extensively on various table structures, record layouts of the output files generated by various Interfaces.
• Setup the Process Scheduler to enable end user to do multi- process jobs to run on a UNIX server and also used Process Monitor to keep track of status of the report.
• Used PeopleTools, PeopleCode, Component Interface extensively to meet the business requirements.
• Created record groups and message catalogs entries.
• Created and modified many panels and added to existing menus to reflect the customized panels and controlled the program flow with PeopleCode.
• Created and customized SQL queries to meet business requirements.

Tools: PeopleSoft 9.0 HRMS (HR, Interface Payroll) People Tools 8.50, Peoplecode, SQL, Component Interface

Confidential

PeopleSoft Techno-Functional Consultant/ Team Lead

Responsibilities:

• Extensively worked with the HCM Upgrade team and functional users in order to develop, support and resolve technical issues in Workforce Administration and Payroll during the upgrade from v8.8 to v9.1.
• Developed and updated technical design documents due to upgrade changes.
• Reviewing the compare reports, mapping the gap between 8.8 and 9.1, tune the Data, load AE programs.
• Extensively involved in data conversions and generated the flat files from tables then used Import Manager, SQR, and SQL Plus to insert the data into PeopleSoft.
• Retrofitted and Modified code as per previous system.
• Monitored the flow of work through the system and troubleshoot the HR issues.
• Actively involved in the testing and issue resolution during the parallel test and the post production support.

Environment: People Tools, HRMS version 8.8/9.1, Pay roll, SQR, Application Engine, Workflow, SQL, People code, DB2

Confidential

PeopleSoft HRMS Technical Consultant

Responsibilities:

• Training Management system was customized module developed for Confidential to enable each of their employees to manage his/her training program.
• To consolidate accounts of all users and user-roles.
• Registering and Approval process was handled for hierarchy.
• Security was handled for different roles of users.
• Custom Workflow was designed and developed to handle business process.
• Involved in Customization.
• Design new Records, Pages, Components and Menus for HR Department (HR).
• Developed Interfaces using Application engine to take data from 3rd party vendor and input into custom record for processing.
• Responsible for Implementation of Direct Report UI for manager self-service module.
• Provided security to various records and attached to different access groups.
• Worked in setting up workflows, resolving problems related to workflows for existing setup and creating new business process/activities.
• Modified predefined PeopleCode for HR, Self-Service.
• Created number of custom fields, record definitions, pages, component and documented Interface programs and updates.
• Unit testing to minimize errors.
• Help users during UAT, fixed issues and provided post implementation support.
• Handling Tickets and Enhancements, Offshore Co-Ordination, Requirements gathering, Functional and Technical Design. Coding, Testing and Migration. Also handled payroll module for Confidential, which includes payroll for more than 10,000 employees.
• Internal Job Vacancy Posting was customized module developed for Confidential to enable its HR dept. to create Job vacancy for internal hiring and its employees to apply, approve and conduct interviews.
• Interaction with users to gather requirement, documenting the function specification with optimal design.
• To consolidate accounts of all users and role.
• Security was handled for different roles of users.
• Workflow was designed and developed to handle business process.
• Developing all pages where user can create job vacancy and designing workflow.
• Designing Report Specification Document.
• Report development using SQR’s.
• Interaction between team members, client department & business users.
• Reviewing all the deliverables and ensuring timely and defect free delivery.
• Testing and recording test results with strict adherence to Quality Procedures.
• Participated in conference calls with client
• Analysis of the specifications provided by the client'
• Altered various Records and Panels for the current requirements and done changes accordingly in the database
• Created various SQRs required for generating the reports according to the requirements and specifications of the client
• Modified various existing SQRs for generating required output as per the client.
• Designed Shell Scripts in UNIX for the FTP of the output generated by the SQR reports to various servers of the client.
• Done Migration of the Projects from one Database to another.
• Designed, Tested, debugged the projects in development, and moved them to Production successfully.

Environment: PeopleSoft 8.3/8.9 HRMS (HR, Training Management, Self-Service and MSS) modules, PeopleTools, Mainframe and DB2.