SUMMARY:

• PeopleSoft Techno Functional Consultant with over 11 years of experience specializing in Development, Customization, Implementation, Upgrade and Application Support & Maintenance of PeopleSoft HCM 9.x, PeopleSoft HRMS 8.x, Payroll, Benefits technologies.
• Over 11 years of IT experience with expertise in PeopleSoft Application Developing, Application Designing, Reporting, Maintenance, upgrade and Testing.
• Experience in Application Support & Maintenance of PeopleSoft HCM, Benefits, NA Payroll and Payroll Interface Applications.
• Accustomed in designing Business process flows, Creating use - case diagram, Generating effort estimates, work breakdown structures, and project plan tasks for major enhancements
• Experience in SQR, Application Engine, PS Query, Workflow, Component Interface, File Layout, Application Package PeopleCode and Web services.
• Seasoned Conversion and PeopleSoft Upgrade from 8.8 to 8.9 and 8.9 to 9.1
• Independently supported customer environment (includes analysis, retrofitting, testing and deployment)
• Good Technical knowledge in Support modules of PeopleSoft HRMS.
• Experience in Security Setup, PeopleSoft Process scheduler, Batch Jobs scheduling and Monitoring.
• Technically agile with diverse skill set including XML, HTML, Java Script, Oracle 9i/10g, and MS SQL Server
• Experience in working along with Oracle support on all delivered errors to get the fixes and apply the updates in the client environment.
• Experience in designing RFT template and Barcode Letters generating and forms using XML publisher in PeopleSoft 9.0
• Designed a custom Query Reporting Manger that was Application specific Query Builder Tool which allowed user to build queries based on the options in dropdown enabling complicated and multiple filters.
• Facilitated custom SQC ftptosync.sqc for reuse.
• Varied industry experience like Tele-communication, Healthcare, Marketing, Financial Services and Information Technology.

SKILLS:

ERP: PeopleSoft 8.3/8.9/9.1/9.2 (HRMS/HCM), PeopleTools 8.46 / 8.47/8.48/8.50 and 8.51/8.53/8.54

People Tools: Application Designer, Application Engine, Workflow, AWE, PeopleCode, Data Mover

Integration Tools: Component Interface, Application Messaging, Integration Broker

Reporting Tools: SQR, PS/Query, XML Publisher

Database: Oracle9i,10g, SQL Server, Toad

Operating System: Windows NT, Windows 2000 and Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• PeopleSoft support and maintenance using agile strategic methodology, Scrum Sprint software development approach, solution scoping and design document process.
• Designed and developed new inbound and outbound interfaces between Nationwide, Conexis and Fidelity.
• Created new Retiree Benefit programs like deferred compensation, Inactive feed, Past due notice, FOM/EOM pay group conversion.
• Created new records, pages, component, roles, permission lists to allow Business to hire a retiree in Retiree Company when his benefit packets are approved. Audits are maintained and excel report is generated for business to validate.
• Benefits Open Enrollment - Setting up new plans, providers, eligibility and event rules, rates, benefit programs, earning and deduction codes for automated open enrollment processing and regular event maintenance.
• Facilitating Fit/Gap sessions to determine configuration and customized Benefits Administration (Benefit Programs, Benefit Plans, Benefit Events, Rates and Calculation Rules).
• Created custom Dependent Ben verification page to check whether the Dependents/ Beneficiary has been verified or not by the approving manager.
• Worked on entire process flow from deferred compensation, IDC payout, Pay Calculation, Pay Confirmation.
• Developed new business processes, enabled workflow process to for HR and benefit transactions like Adoption/birth Notification, Employee Status Change Notification, and Employee Benefits Enrollment Confirmation.
• Worked on PeopleSoft integration tools - like application engine, component interface, file layouts, xml publisher and integration broker.
• Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.
• Developed Queries using Query Manager Depend on the Functional and Business to see the reports.
• Performed object and code migrations using Phire and maintenance patches and fixes. Issues and defects are tracked and resolved in Quality Centre. Transferring inbound/outbound files and batch jobs are scheduled using ESP jobs.

Environment: PeopleSoft HCM 9.1, People Tools 8.54, Oracle 11g

Confidential, Chicago, IL

PeopleSoft Techno Functional Consultant

Responsibilities:

• Implemented new Vendor proposal process. Scheduled meetings with Business users, HRIS, Vendor coordinators, account executives and management team to understand and analyze the business need and functionality to streamline the Onboard Hiring process, Market pay and Lawyers Travel processes.
• Worked on integration with 3rd party system using Restful webservices.
• Implemented custom online panels for Managing partners and was responsible throughout the lifecycle, including design, configuration, development, integration, testing, security setup and deployment.
• Responsible to identify technical feasibility to in corporate new business requirements within existing application.
• Created new Application Engine & Component Interface program to upload employee’s new Compensation rates from input file to Job component.
• Created SQR reports like Service Report, Special Income Reports, Applicant Data Flow Report, Audit for FSA Deduction Report for HR, Benefits and Payroll.
• Technical proficiency with SQL, PS/Query for reviewing data, troubleshooting and testing/validating source system data
• Developed and Managed application builds, functional designs, test planning execution and deployment activities.
• Maintained Visual SourceSafe tool for Version Control tool and Jira for handling and tracking Issues/Tickets.

Environment: PeopleSoft HCM 9.2, People Tools 8.54, Oracle 11g, SQL Server 2008

Confidential, Deerfield, IL

PeopleSoft Techno Functional Consultant

Responsibilities:

• Lead System design, configuration/code and unit test PeopleSoft related projects
• Gather business requirements, analyze business processes and provide options using best practices
• Develop and maintain integrations between PeopleSoft core HR and external applications like ADP ACR,LMS, Benefits, etc.
• Manage documents including business requirements, business process flows (As-Is and To-Be), functional and specifications, Technical design, Test scripts, etc.
• Develop test scripts tied to business requirements and act as an independent tester.
• Communicates with HRIS team and business process owners on a routine basis
• Manage mid-size projects within PeopleSoft while engaging key stakeholders
• Manage IT Service requests/incidents related to PeopleSoft and keep the cases within Target levels

Environment: PeopleSoft HCM 9.0, People Tools 8.53, Oracle 11g

Confidential, Ohio

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked in HR, Payroll, Benefits and ESS Module (eProfile, ePay, eBenefits).
• Supported Open Enrollment 2014.
• Created Data Mover scripts to migrate setup data.
• Developed new Payroll reports for Employee Earnings
• Developed new Payroll report to provide part time /Full time associates who are averaging 30 hours.
• Customized e-Benefits Enrollment Forms.
• Format the layout of Medical/Vision/Dental enrollment pages in Benefits Enrollment.\ (Compensation Page, Benefits Pages etc).
• Customized Life Event Pages (Birth/Adoption Pages, Marriage Pages).
• Customized ESS Pages Customized the dependent/Beneficiary rmation page
• Designed, developed and tested new Application Engine programs.
• Developed Application Engine and Component Interfaces to load mass data changes, Mass hires, terminations and transfers.
• Wrote validations and edits to include business logic. Designed, Developed and tested New SQR’s.
• Customized existing SQR’s as per the requirement of the client.
• Designed developed and tested SQR interface programs to import data from flat files to PeopleSoft tables.
• Developed and tested SQR interface programs to export data from PeopleSoft tables to flat files.
• Designed, Developed and Tested SQR to insert a row into Reported Time table from Staging Table
• Designed, Developed and Tested Application Engine (using CI) to load Rapid Time
• Analyzed and Fixed data issues while running Time & Labor Admin Application Engine
• Worked with Dynamic Group Time & Labor Security
• Modified existing Runcontrol Pages as per Runcontrol Parameter requirements. Used PeopleSoft Application Designer.
• Customized TimeOut Application Engine to send reminder email to HR Rep for Name Change and Martial Status Approval.
• Developed Test Plans and Test Cases/Scenarios for all the newly developed Reports/Processes, Customizations and Modifications.
• Prepared Technical Design Documents.
• Handled many PeopleSoft delivered fixes, bundles, maintenance packs and tax updates

Environment: PeopleSoft HRMS 9.2, People Tools 8.53, SQR, Oracle 11g

Confidential

Techno Functional Consultant

Responsibilities:

• Accountable for Database Design, Data flow diagram, Technical Design and Development activities.
• System designed to systematically track and monitor Safety measures Improving and Streamlining Business Rules, removing manual processing, overlooking, maintaining paper works there by assigning tasks, setting remainders and directing approvals.
• Created new Fields, Records, Pages, Components and Menus using Application Designer to meet the Business requirement.
• Executed on PeopleCode, Application Engine, Approval Workflow Engine and SQR.
• Implemented Business Process and Transactions for notifications and work list.
• Designed extensive and exhaustive Functional Test plan, Test Cases and Test Document for System Integration Testing and User Acceptance Testing.
• Prepared Migration scripts and migration request and coordinated with DBAs on migration issues.
• Involved in SIT, UAT phases coordinated with Testing Team and the actual Users illustrating the system behavior and capabilities.
• Addressed Issues identified during SIT/UAT and resolve the IRs.
• Provide Post Go-Live support for users to get acquainted with the new system and to stabilize the system

Environment: Windows 2000, People Tools 8.50, PeopleSoft HRMS 9.1, Oracle 10g, SQR, Application Engine, Workflow, PeopleCode, Process scheduler.

Confidential

Techno Functional Consultant

Responsibilities:

• As a senior consultant Responsible for Understanding the Confidential Bolt-on Benefit Enrolment system. winning project in terms of production release on time under minimal budget and minimal resources and NO defects in SIT/UAT phase.
• Coordinated calls with onsite clients for showcasing Demonstration of application screens, giving them multiple options to choose for Look and Feel of the system, sharing the best practices and building more work opportunities by integrating with other systems.
• Involved in Database Design and Technical Design Document preparation.
• Automated, Designed and Developed the system to track and maintain Benefit amount to be allotted for each vendor. Copy to excel and Mass Data upload with error handling and reprocessing were greatly appreciated.
• Identified various roles, created and assigned uses to user profiles, provided Security access to panels.
• Involved in Data conversion using data link in SQR processes.
• Worked along with Migration team and security professionals for deployment and security setup in Production environment.
• Provided Post Production support. Prepared Knowledge Acquisition document and User Manual Document.

Environment: Windows 2000, People Tools 8.50, PeopleSoft HRMS 9.1, Oracle 10g, SQR, Application Engine, Workflow, PeopleCode, Process scheduler.

Confidential

Techno Functional Consultant

Responsibilities:

• Direct client interaction for Knowledge acquisition and new feature enhancements.
• Impact Analysis, Design document, coding and unit testing for PeopleSoft 9.1 ASM tickets.
• Tweaked PeopleCode, Online pages, Application Engine and SQR for customization.
• Prepared Unit test Plan, use cases and involved in resolving UAT/SIT testing defects.
• Experienced in debugging, troubleshooting and fine-tuning applications for security, scalability & performance on time.
• Developed Barcode generation and Letter generation using XML Publisher
• Designed RTF Template for XML Publisher Report
• Provided solutions & fixes on PeopleSoft production issues. Taken corrective actions to avoid errors in future.
• Proficiently skilled, reduced multiple similar batch jobs and processed by grouping activity transaction thereby reducing processing time, table lock and making it easy to maintain.
• Generated ad hoc reports and computations on the fly.
• Facilitated custom SQC ftptosync.sqc for reuse.
• Lead the team by facilitating and PS technology to fresher and managed their task assignment.

Environment: Windows 2000, People Tools 8.50, PeopleSoft HRMS 9.1, Oracle 10g, SQR, Application Engine, Workflow, PeopleCode, Process scheduler.

Confidential

Techno Functional Consultant

Responsibilities:

• Responsible in design, development, coding, testing, Configuration Specification setup, creating user Manuals, defining Test plan, implementing and providing post production support.
• Implemented legacy system as a new Bolt-on module on Business Contingency Planning and Emergency Work Assignment Program modules.
• BCP was initially implemented in HRMS 8.9 and then upgraded to 9.1 for integrating with EWAP system.
• Involved in Data conversion, Data migration and Integration solutions using SQR, AE and Data Mover.
• Involved in running Upgrade Compare Reports between Demo database and Copy of production before we do the upgrade copy.
• Upgrade assistance to DBA, Ran release scripts to upgrade tools from version 8.9 to 9.1
• Designed a custom Query Manger Builder that was Application specific Query Builder Tool which allowed user to build queries based on the options in dropdown enabling complicated and multiple filters.

Environment: Windows 2000, People Tools 8.48, PeopleSoft HRMS 8.9, Oracle 10g, SQR, Application Engine, Workflow, PeopleCode, Process scheduler.

Confidential

Techno Functional Consultant

Responsibilities:

• Providing Production Support and taking up enhancements.
• Implemented and Designed Modules like Improve Performance and embedded Contractor.
• Impact Analysis done for daily tickets logged in QC -PeopleSoft 8.9 ASM tickets.
• Development, Testing & Implementation of new Interfaces for transferring the information between PeopleSoft and 3rd Party vendors.
• Preparation of UTP, UTR, Technical Specification and conduct Code review, Design review for tickets.
• Involved in Trouble Shooting and resolved them.
• Coordinated with onsite people for gathering requirement and knowledge transfer.
• Playing the role of SCM Co-coordinator.
• Performed Code Walk through and Design review for tickets which involves Application Engine, PeopleCode and SQR.
• Lead the team and mentored the junior consultants for smart working methods.

Environment: People Tools 8.48, Windows 2000, PeopleSoft HRMS 8.9, SQL Server, Oracle 10g, SQR, Application Engine, PeopleCode, Component Interface, Workflow, Integration Broker, Data Mover, Process scheduler, Remedy & VSS.