SUMMARY

• Around 10 years’ experience in Information Technology gathering user requirements, systems analysis, design and development, deployment, integration, data conversion, training and support of a variety of Client Server and ERP applications.
• About 10 years of PeopleSoft experience as a Techno - Functional Consultant in design, development, implementation, conversion, up-gradation, and maintenance of PeopleSoft HRMS/HCM/ELM/FSCM applications with expertise in modules such as Core HR, North American Payroll, Time and Labor Payroll Interface, Absence Management, Base Benefits, Benefits administration, eBenefits, ePay, ecompensation, AP, GL, AR.
• Strong PeopleSoft Techno-Functional skills including People Tools (People Code, Application Engine, Integration Broker, Component Interface, Workflow, Security, Operator Security, Data Mover, Upgrade Assistant, People Code, PS/Query).
• Proficient in the creation of complex reports using SQR, Crystal Reports, BI Publisher and PS Query.
• Involved in the security administration of the PeopleSoft HCM/FSCM and ELM systems.
• Extensive experience in the areas of System Analysis, design, Fit-Gap-Analysis, Conversion, Development, Implementation and Unit Testing.
• Extensively Used STAT and Clear Quest for Change Control and Change Management Procedures.
• Expertise in Database backups, recovery and refreshes and maintaining PeopleSoft environments
• Experience in all phases of the complete lifecycle of the project involving Requirements, Analysis, Specification, Design, Development, Conversions, Installations, testing and Maintenance, Application Performance and Tuning.
• Proficient in Design, Analysis, Development and Implementation of Client / Server application and RDBMS.
• Extensively used Process Scheduler to schedule processes, Reports at specific time and for implementation of batch processing.
• Involved in full length Life-Cycle implementation of PeopleSoft modules.
• Experience in Objects and data migration using Application Designer and Data Mover.
• Proficient in working with HTML, ASP, XML, ActiveX, VB Scripting including working with SQL interfaces to Web pages.
• Did apply Patches/Fixes/Updates/Tax Updates from the PeopleSoft Customer Connection to the PeopleSoft databases on timely basis.
• Proficient in Object Oriented concepts, Web development and data warehousing concepts.
• Ambitious, Motivated, industrious with sound business judgment and strong work ethic.
• Strong interpersonal, communication skills and keen desire to learn new technologies that enables to work on multiple tasks simultaneously and meet project deadlines.
• Go live experience with several Application Upgrade Projects including application upgrades like PS 9.2 and PUM 21(Image).
• Go live experience with several Tools Upgrade Projects from 8.51 to 8.53 and 8.53 to 8.55
• Implemented ELM, Self Service, Manager Self Service, Taleo USA & International.
• Lead Developer & End-to-end Support Analyst for major Upgrade & Implementation Projects.
• Involved in conversion of PeopleSoft interfaces to Oracle Cloud Implementation project (One ERP).
• Worked on several mergers and acquisitions including Shaw to Confidential &I, Confidential &I to Confidential and Confidential to CBISTS.

TECHNICAL SKILLS:

Enterprise Applications: PeopleSoft (8.4/8.8/8.9/9.0/9.1/9.2/ PUM) and HCM Cloud

Languages: People Code, SQL, VB, VBScript and ASP

GUI / RDBMS: Visual Basic 5.0, Oracle 8/10i/11g/12c/12g

Operating Systems: Windows 95, Windows NT, MS-DOS, Unix, Linux/ Windows NT 6.2/Web logic

Development Tools: Application Designer, PeopleTools, Application Engine, Business Process Designer, Integration Broker, Component Interface, ExcelToCI.

Administration Tools: Data Mover, Security Administrator, Object Security, Import Manager, Process Scheduler, Mass Change, Workflow, Application Upgrade

Reporting Tools: PS/nvision, Crystal Reports, PS Query, BI Publisher

Other: MS-Project, Visio, MS-office

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. PeopleSoft HCM Technical Lead / HCM Cloud Consultant

Responsibilities:

• Created End to end design for Bank information project to include in Taleo USA hire/rehire during pre-employment process.
• Developed a separate panel for Bank information into Taleo existing pre-hire panels which involved people code efforts.
• Modified existing Application engine to include Bank information to receive data from Taleo system into PeopleSoft and maintain the received information in PeopleSoft HR system.
• Worked on huge people code to send information to JDE payroll system when there is a change/delete/new Bank information created in PeopleSoft.
• Undergoing training in Oracle Cloud.
• Working on various interfaces to transfer data from PeopleSoft and SAP system to Oracle Cloud systems.
• Worked on Work Force Administration related activities such as Job Title Changes for new business under Global HR framework.
• Supporting entire PeopleSoft HR application system on day to day basis.
• Created a panel which involved Application engine program and people code efforts to create a run control page in uploading the new csv/txt file from desktop/system to PeopleSoft server and load into staging table.
• Worked on several changes as per new business with the acquisition of Confidential &I which involved changes to third party interfaces and design.
• Created several Benefits reports for Confidential to Confidential &I Storage Tank Structures Divestiture project.
• Created SQR reports for LRN, Skill Soft and other legal related third party systems from PeopleSoft.
• Worked on creating an application engine program to read the SAP data, write into a PeopleSoft database table and added the data using an SQR report along with PS data and send the merged file to third party Exterro system.
• Created an Application Engine to generate email notifications to the population who are going as part of divestiture.
• Helped One ERP team in creating and grating service accounts to access PS tables for HCM Cloud implementation project.
• Helped ERP team in testing various Cloud interfaces from PeopleSoft for their UAT.
• Handled entire production support for PeopleSoft along with helping and creating interfaces for PeopleSoft to Oracle Cloud implementation project.

Confidential, Houston, TX

Sr. PeopleSoft HCM Techno-Functional Consultant / Upgrade/ Security/ Production Support Analyst

Responsibilities:

• Developed custom Application Engine programs, file layouts for Work force related activities such as Pay rate changes, promotions and Transfers in JOB Data.
• Developed custom SQR’s for ADP Payroll, Benefits, Affordable Care Act (ACA or Obama Care).
• Created custom Application Engine Interfaces required during the company Acquisitions (Shaw Group).
• Modified Delivered SQR’s for Absence Management Reports to customize per client requirement.
• Created custom online pages that involved huge People Code efforts at page and record level.
• Setup workflow roles and updated route control profiles as required.
• Developed BI publisher report to generate P38 information for employees. The development involved creation of Data Source Definition, RTF Templates, XML and XSD files, PS Query.
• Developed Custom SQR’s that involved Active Directory account information, Network information and other Confidential &I user related information.
• Created Custom reports for the company’s 401K information (Converted from Trowe price to Merrill Lync)
• Created custom Application Engine to automate HR documents and also created custom components to attach the HR documents manually by the users. These HR documents include Payroll, Benefits, Medical, General Employment, HSE, AMEX, etc.,
• Created several URL definitions to make the custom processes to be automated and get the attachments saved on to the database records.
• Created outbound interfaces for Taleo USA and International. Also created inbound interfaces to get the input file from Taleo and load into the respective components.
• Set up several Union templates and Capital Services templates based on the client requirement.
• Created several components to allow users to maintain & Hire/Rehire the union or capital services employees through the new components. Provided support for the issues encountered during the Hiri Hiring Process.

Security Administrator:

• Created custom versions of PER507, PER508 and PTUGAPTR interfaces for department security tree.
• Involved in the design of the HCM existing PeopleSoft security system.
• Created the scripts to compare Security Tables.
• Created Roles and permission lists as required and also managed component security.
• Created end user documentation and provided training for IT security Staff.
• Designed and developed customized Roles (Standard Roles and Report Roles), Permission lists and User ids as per the Business process provided by client.
• Maintained security in all Development and Test instances and migrated to Production via data mover/ application designer.
• Configured LDAP for Single sign on by assigning default role to the user profiles upon log in.
• Worked on Configuring Query Security and Object security for the system.
• Configured and designed row level security system to segregate and secure data.

Taleo USA & International Implementation Project:

• Implemented Taleo for US and International. This involved creation of new process to read the file and get information from Taleo system into PeopleSoft on regular basis and load them to the respective components (Singapore, UK, India, USA, CZE, NLD, etc.,). This implementation involved huge people code efforts on Record, field and component level.
• Helped business analysts to create requirements/ specifications for the Taleo International Implementation project.
• Developed Outbound interfaces for Taleo USA and International which include Supervisor’s listing, Internal Candidate Information, User grade, Professional & Craft Job information & other project assignment information.
• Developed Inbound interfaces to get the input file from Taleo and load into the respective components.
• Worked on People Code to include the feature of hiring/ re hiring the employees from the respective Taleo panels, which involved Component & Record People Code efforts.
• Supported the implementation throughout the assignment tenure.

Application & Tools Upgrade Project:

• Lead developer in two of the major Application Upgrade Projects from 9.0 to 9.2 and 9.2 to PUM 21 (Image)
• Lead developer in two of the major tools Upgrade Projects from 8.51 to 8.53 and 8.53 to 8.55
• Took complete responsibility and involved in all of the retrofit activities as well as migration.
• Involved in implementation of Self Service for the client which required workflow set up and client related functional set up.
• Set up Name Format types missing for various countries post tools upgrade live as part of Production support related to Personal data.
• Developed and Supported BI Publisher report for P38 Attachments post GO live for 9.2 PUM application upgrade. P38’s was crystal reports in old version. As Crystal does not support in 8.55, had to convert crystal to BI which involved Template Definition creation such as XML files, XDO files, RTF file format and Data Source Definitions.
• Created and managed custom CI for Emergency Contacts, Personal Data and Job data.

ELM Implementation Project:

• Implemented and Supported Enterprise Learning Management module which involved setting up new classes / courses and Enrollments.
• Involved in setting up new users in the PeopleSoft ELM System.
• Worked with Admin to set up IB for sync between HCM and ELM which includes user profile, Person Basic and workforce sync.
• Helped functional user create the new Leaner ID’s in ELM system.
• Worked as a functional user to set up entire ELM application for Locations like Lake Charles, Baton Rouge etc.,
• Help identify the missing learner ID’s in the system and set up the learner groups/learner ID’s as required.
• Built and ran several scripts for missing learner ID’s in the system so that the users could enroll their classes/courses and enrollments successfully.

Self-Service & MSS Implementation:

• Involved in implementation of Self Service for the client which required workflow set up and client related functional set up.
• Configured LDAP to provide users a feature to log in with their network credentials and automatically assign the generic role upon their initial log in (Single Sign-on feature).
• Created POC for implementation of MSS to business users and team for future use.

Confidential, Strongsville, OH

Sr. PeopleSoft Techno-Functional & Security Consultant

Responsibilities:

• Worked with full life cycle of PeopleSoft Financials and SCM Application Upgrade and People Tools Upgrade as per business requirement.
• Worked on FSCM Application Upgrade project from 9.0 to 9.2.
• Developed Techno-Functional specification documentation for the new changes brought out in version 9.2
• Developed custom on-line pages and components in FSCM as per the client's request.
• Retrofitted People Code, SQR to accommodate customizations to meet the business requirements.
• Did work with Post Production support, enhancements, fixing process issues, Batch Job Processing and Troubleshooting.
• Worked with SCM procurement process, AP, PO/e-Pro, with Matching and Exception Handling with Receipts, Purchase orders and Vouchers.
• Did Work with SCM Purchasing and e-Pro and Voucher approval work flow issues.
• Did Work with processing requisitions to generate Purchase orders and ensure Dispatch to the vendors correctly.
• Cleaned up the old inconsistent data in Inventory and Purchasing modules which enabled the open order to be cancelled.
• Developed several inquiry pages and modified existing pages for the users to enter data and run reports for the AR and Billing modules.
• Resolved known bugs or new issues for the existing reports and encountered during testing.
• Created custom reports and modified reports using XML publisher, SQR and Application Engine Programs.
• Involved in removing redundant information in security related records in PeopleSoft using combination of SQR, PS Query and Excel spreadsheets.
• Resolved issues in Query Manager and fix the issue to accommodate Users request.
• Resolved Issues using Application Engine, SQR, Component Interface, Application Package and PS Query Manager for complex issues involved with Supply chain modules.
• Configured domestic workflow set up using AWE (Approval Workflow Engine)
• Set up the criteria for self-approval, register transactions, user list definitions and e-mail notifications.
• Customized Voucher Page by adding Invoice Receipt Field as per the business requirements.
• Developed and implemented numerous queries and reports.
• Worked with Business Analyst, Systems Business Analysts towards support of upgrade of Financials.
• Designed User Id, roles, permission lists according to customer requirement and security trees for maintaining security within the AP and GL modules.
• Customized PeopleSoft objects to address future dated allocation issues
• Automated the process for running allocations.
• Created and posted journals using spreadsheet journal import template.
• Designed and developed the bridging process when an employee transfers from hourly (hourly population still on Legacy system) to salaried, utilized Application Engine, Component Interface, File Layouts & SQR’s to transfer the employee tax balances, job details, personal details, earnings and deductions to current PeopleSoft system.
• Involved in the security administration of the PeopleSoft HCM & FSCM systems.
• Created Roles and permission lists as required.
• Helped support and troubleshoot all end user security requests.
• Worked on assigning workflow roles as required.
• Worked on Configuring Query Security and Object security for the system.
• Configured and designed row level security system to segregate and secure data.
• Created end user documentation and provided training for IT security Staff.
• Worked with the functional coordinators to determine the right level of access for the accounting staff.
• Maintained security in all Development and Test instances.
• Involved in migration of project created for security roles and permission lists including query tree security with access group permissions.
• Built Custom Query trees and Access groups from scratch and added tables to appropriate Access groups so that the Functional users have no issues in accessing the tables in queries.
• Maintained security in all environments. Involved mostly in Query Security Access and Page access to the users.
• Used Oracle SQL developer to query all PeopleSoft security tables.
• Involved in setting up new users in the PeopleSoft Systems.
• Setup up workflow roles and updated route control profiles as required.
• Designed and developed customized Roles (Standard Roles and Report Roles), Permission lists and User ids as per the Business process provided by client.
• Documented several security documents like Security audits, Security procedures and maintenance etc.
• Created the scripts to compare Security Tables.
• Modified User Profile document with all the roles and description of roles using Excel.
• Also involved in some of the issues related to the Data conversion and converted the data using data mover tool.

Confidential, Houston, TX

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in complete full-life cycle implementation of PeopleSoft HRMS, gathered business requirements and collaborated to prepare functional designs, developed Tech designs and obtained approval from functional team.
• Actively involved with giving the Estimates for the Development work to be done for the Tech designs prepared.
• Developed outbound / inbound interface which generates / reads flat files to and from third party vendors, including HBSI, Fidelity, Ceridian COBRA and others.
• Designed batch processes for union seniority and MSI requirements. Created SQR process for paying loading pay sheets with One Time Deductions and One Time Pay.
• Designed and developed the bridging process when an employee transfers from hourly (hourly population still on Legacy system) to salaried, utilized Application Engine, Component Interface, File Layouts & SQR’s to transfer the employee tax balances, job details, personal details, earnings and deductions to current PeopleSoft system.
• Participated in scheduling / running the jobs in mainframes environment using JCL.
• Involved in several customizations for Benefits and HR to meet business needs for clients of different regions.
• Created employee self-service customizations for eBenefits (online enrollment), eCompensation (MSI), and payroll.
• Involved in Integrating PeopleSoft with Profits, Ceridian and Symmetry using PeopleSoft Payroll Interface.
• Designed SQR Interface from Ceridian Payroll to General Ledger
• Developed a custom version of PER099, HIPAA App engine program.
• Developed client specific reports in SQR and Crystal Reports.
• Produced multiple reports for Benefits, HR, and Payroll, including customization of several BASxxx reports, leave accrual reports, and compensation reports.
• Played a major role in applying the Tax updates / Patches / Bundles. Ran compare reports for tax updates, analyzed compare reports, retrofit customizations, and assisted DBAs in applying tax updates.
• Conducted unit testing and user acceptance testing.
• Experience in offshore-onsite model and Performed Team Lead role at onsite and co-ordination with offshore team.
• Responsible for doing the Migrations to the other Environments like Testing and Production using STAT for all the Interface migrations and creating versions controls.
• Using the Data Mover, loaded the demo data from the tables into development environment database.
• Involved in the design of the HCM existing security PeopleSoft system.
• Involved in setting up new users in the PeopleSoft Systems.
• Created Roles and permission lists as required.
• Implemented Row Level Security by creating the department trees from scratch.
• Created various custom interfaces for department security tree.
• Setup up workflow roles and updated route control profiles as required.
• Created the scripts to compare Security Tables.
• Modified User Profile document with all the roles and description of roles using Excel

Confidential, Cincinnati, OH

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Designed and developed custom Paycheck summary page which displays Contractor’s earnings, deduction, taxes and flex credits as per client’s requirement. Also implemented security for this page, the data is displayed based on the company, paygroup and grade band of the user.
• Designed and developed many inbound and outbound interfaces to and from PeopleSoft payroll system.
• Key Techno-Functional team member in an effort to upgrade the existing PeopleSoft HRMS/FSCM system to 8.8, which included requirements gathering, fit-gap analysis, Techno-Functional planning deadlines, unit testing and customer acceptance testing.
• Met with end-users to gather requirements and wrote Techno-Functional specifications for developing a batch process for SWW (Short Work Week).
• Was part of the Application Support team, helped end-users in debugging several Production related issues.
• Worked on Performance tuning of Customized Application Engines.
• Involved in documenting functional and Techno-Functional designs. Also involved in assisting in creating training manuals.
• Extensively used data mover tool to migrate setup table data from testing to production databases.
• Set up the new plan type, benefit plan and benefit program for 401k catch-up plan and performed various other setup procedures to facilitate the new 401K process implementation.
• Created screens that will allow the user to elect what part of the Settlement and Incentives will be deducted for ‘Service Account Deduction’ as well as ‘HR-10’.
• Was part of critical production support process, resolving various database issues and helping the business users during critical process runs.
• Developed custom workflow to send the work list to the benefits team to assign benefits when a new HIRE or Rehire transactions happens.
• Developed Custom Workflow for HR/FSCM modules using custom Business Process Maps.
• Developed SQR to achieve all the work list to the custom created achieve table which are not processed for more than 30 days.
• Developing custom reports for End Users using Crystal in both HRMS/FSCM.
• Configured and maintained security for HRMS/FSCM modules. Including permission lists, roles, user profiles and route controls using Security Administration, Tree Manager and Access groups.
• Created new permission list and assign the permission lists to the roles and assigns the role the user as per the business requirements.