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 HRIS modules.
• Overall 8 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 PeopleSoft HR Modules - Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), Base Benefits, North American Payroll, Time & Labor and Talent Acquisition Management (TAM), position management .
• 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 8.9/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.
• Worked on multiple PeopleSoft upgrade projects for different modules: HCM 9.0 to 9.2, ELS 9.0 to 9.2 and CRM 9.0 to 9.2 and Finance 9.0 to 9.1, Applied patches and bundles using PeopleSoft Update Manager PUM images and installed Oracle Secured Enterprise Search database software and configuring it from within 9.2 applications
• Installed bundles PeopleSoft PUM Images using Oracle Virtual Box and configured and instruct client in use of the PeopleSoft Update manager PUM for their upgraded 9.2 HCM system. He has installed and configured of PeopleSoft Software in Dev, Customer Testing, QA and Prod regions and configured of PeopleSoft Internet Architecture PIA instances for various PeopleSoft/Oracle Database Instances in DEV, CUSTOMER TEST, QA and PRODS regions.
• Worked as a Technical Analyst for PeopleSoft Enterprise Learning Management System (ELM) implementation project.
• 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.
• 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 HRIS (9.0/9.1/9.2), PS HRIS (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, Naperville, IL

Sr. PeopleSoft HCM Techno-Functional Consultant

• 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. .
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing / advice form printing specific to client requirements.
• Developed custom functionality using excel services and the SharePoint API
• Developed SharePoint portals with extensive workflow capabilities to manage client projects
• 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
• 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.
• 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.
• 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.
• 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.
• 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.
• Involved in setting up the Workflow for the self-service transactions such as Job Requisition approval as per the business rules of the organization.
• Added custom awards like Parking Recognition Winner, Employee of the Month, Experience-based bonus points, etc. that added to the performance rating of the employees.
• Participated in design and development of mobile business functionality (Fluid) of Expense, Inventory, core HR ESS & MSS.
• Designed and configured the mobile approvals using Fluid UI for the Expenses, HR self service transactions like Job Opening, Job Offer, Transfer Employee, Retire Employee and Terminate Employee.
• Enabled and activated HMAP APPROVAL service, MAP file synchronization to implement the mobile approvals.
• Modified the PT GROUPLET and PT URL UTIL HTML objects to resolve multiple remote sessions issue in loading multiple remote tiles.
• Enabled and activated the push notification option in the transaction registry for the Approval Workflow Engine.
• Configured portal branding objects to add the client specific logo/images on Fluid tiles.
• Configured the home page with Navigation collections, pagelets based on the user role.
• Modified several classic PIA components to Fluid UI pages.
• Design and develop Expenses and Inventory transaction data pivot analytics on top of fluid architecture.
• Involved in Expense and Inventory module fluid pages design and development.
• Involved in creating new tiles and configuring the tiles for the Fluid Home page.
• Added custom code using HTML5/CSS/JQuery to modify the Fluid UI pages.

Environment: PeopleSoft HCM/ELM v9.2 (TAM, CG, T&L, Payroll, Benefits), 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 TAM & 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, Time & Labor, Position Management and Payroll
• Interface regularly with customers at various levels.
• 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.
• 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 time and exceptions pages.
• Involved in Testing & Defect tracking few processes in HR, Benefits & Payroll modules.
• Key technical team member in an effort to upgrade the existing PeopleSoft HRIS 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.
• Developed & Setup EDI transactions between PeopleSoft & Biz Manager using Integration broker, Created custom handlers for inbound / outbound transactions.
• Configuration and Administration of TAM & CG transactions Created Custom labor 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 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.
• Design and developed custom message based web Services to render equipment, personal and task related data to the custom java based Ops Board portal.

Environment: PeopleSoft HCM/ELM v9.2 (MSS, ESS, HR Help Desk), Portal, Tools v8.54, IB, AE, CI, Web Services

Confidential, Minneapolis, MN

Peoplesoft Techno-Functional Consultant

• Provide functional support to offshore for all Student Record customizations to include functional spec design, testing, and user acceptance testing
• Gathered requirements, drafted designs and tested requirements for course substitutions, foreign language waivers and certification waivers per client’s business processes
• Gathered requirements, drafted designs and tested requirements course equivalency transfer credit rules
• Gathered requirements, drafted designs, developed mapping and tested requirements for conversion of comments data from client’s legacy system
• Assisting with end-user training and UPK Development as required for Admissions, Campus Community and Student Records
• Researched and configured Self Service and FERPA based off client’s business needs
• Configuring PDL process for applications and test scores from clients’ legacy system
• Reconfiguration of set-up table to ensure items supports client business needs
• Troubleshooting security issue triggered during User Acceptance Testing
• Configuration validation between environments to ensure clean migrations.sessions, configuration, testing and end-user training
• 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
• Perform complex analysis, evaluation, design, development, testing, implementation, documentation and maintenance of PeopleSoft Campus Solutions application specific to the functional needs of Admissions, Student Services and Campus Community, including admission, recruitment, financial aid, student accounts, records, registration, transcript and diploma processing, graduation evaluation, and quality service operations

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

Confidential, Houston, Tx

Sr. PeopleSoft Technical Consultant

• Setup, configured and troubleshoot PeopleSoft Enterprise Integration Points (EIP’s) between ELM 9.1 system and HRIS 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 installation, maintenance of PeopleSoft ELM software and migration of configuration (i.e. setup data) between environments.
• 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.
• Worked on custom Disability batch process which calculates the number of pay hours of the Employees who are on disability in the current pay period.
• Worked on Performance tuning of Customized Application Engine and SQR Processes.
• Online development/customizations of pages, queries and also online validation using PeopleCode.
• 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.

Environment: PeopleSoft HCM v9.1 (T&L, Payroll, TAM, CG), Tools v8.50, SQR, BI Publisher.

Confidential, Tampa, FL

PeopleSoft HRIS Functional Consultant

• 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 in corporate new and complex validations.
• Developed many tax calculation reports like percentage of Tax variation from previous quarter current quarter. Federal and State tax reports.
• 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.
• Environment: PeopleSoft HCM (TAM, Profile Management, ePerformance, NA Payroll, T&L) v8.8/9.1, People Tools 8.52, AWE, IB, App Engine, Application Packages, Send Master, SOAP UI.

Confidential, Rochester hills, MI

PeopleSoft Developer

• 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.

Environment: PeopleSoft HCM (TAM, Profile Management, ePerformance, NA Payroll, T&L) v9.0, People Tools v8.49, AWE, IB, App Engine, Application Packages, Send Master, SOAP UI