SUMMARY

• Accomplished IT Professional with over 12 years of experience in PeopleSoft Development, Upgrade, Production Support and Maintenance projects which includes Design, Development, Testing, Upgrade, Production Support and Maintenance of PeopleSoft Applications.
• Highly Proficient in PeopleSoft, PeopleTools - Application Designer, Application Engine, Component Interface, Data Mover, PeopleCode, Application Packages, PS Integration Broker, PS Security, Interfaces, Excel to CI, SQR and various other developer tools.
• Strong PeopleSoft analytical experience in HR, Base Benefits, Payroll, Payroll Interface, Benefits administration, Absence Management, Time & Labor, Employee Self-Services, Manager Self-Services, eBenefits, ePerformance,eCompensation and complete understanding of complete project life cycle.
• Extensive knowledge in PL\SQL, Stored Procedures with Oracle and IBM DB2 databases.
• Proficient in mini upgrade deployment like Bundles, Tax Updates, Patches and Tools Upgrade.
• Proficient in developing, enhancing and retrofitting various PS objects, inbound and outbound interfaces using SQR, SQC, Application Engine and Component Interfaces, third party integrations(Java Integration with peoplesoft system).
• Extensive knowledge on Data conversion, Data mapping, Performance tuning, downstream interfaces, Online request handling, Change control, Version control and working with Third-Party systems.
• Maintaining and Scheduling Batch Jobs in Autosys and providing support through all the phases of development and implementation.
• Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists User Profiles, Portal Security, Folders, Content References and Definition Security.
• Efficient in coordinating with Business for productive solutions and in implementing workarounds.
• Expertise in full Software development life cycle experience (Solution design to UAT including POST Production Support) with Adequate technical competencies and methodologies like Agile, SCRUM, Waterfall SDLC methodologies.
• Experience leading a team in a development and support environment.
• Independently prepare functional designs, technical designs, code, documentation and review that meet the needs of complex business requirements and provide support for System and UAT testing, and supervise the work with other programmer analysts.
• Strong knowledge and adherence to development standards (including testing and migration procedures) and implementing best practices.
• Well versed in the Global Delivery Model for execution of projects involving onsite and offshore teams and in providing Knowledge Transfer sessions with clients and offshore team.
• Self-motivated fast learner, diligent, hardworking and active team player with high analytical and problem solving skills and effective communication. Skilled in proactive identification and resolution of critical issues.
• Demonstrated proficiency in leading and mentoring individuals to maximize productivity and forming cohesive team environment.

TECHNICAL SKILLS

ERP Packages: PeopleSoft HCM 8.4, 8.9, 9.1,9.2

PeopleTools: Application Designer, Application Engine, Process Scheduler, Data Mover, Excel to CI, PeopleSoft Security, Component Interface, Configuration Manager, PeopleCode, File LayoutPT Versions: Tools version - 8.45 to 8.55

Reporting Tools: Basics of SQR, PS Query, XML Publisher, BI publisher

Web Languages: HTML,XML,WebServices,REST services

Schedulers: PeopleSoft Process Scheduler,Autosys,Mainframes.

Database: Oracle, Oracle 9i, Oracle 10g, Oracle 11g, IBM DB2, Microsoft AccessOperating Systems: MS-Windows 7/8/NT/2000/XP/Vista

Migration Tools: STAT

Other Tools: Teradata, Toad, SQL Developer, SOAP UI

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids

Peoplesoft ITS Systems Coordinator

Responsibilities:

• Design and review of Business Solution document, High level design and detailed designed documents.
• Active participant for implementation and Support of HCM (Fit Gap, Functional Design, Configuration, Implementation, Conversion, Testing, Support, Training and Documentation)
• Gathered and Defined requirements, overall scope definition in terms of functional & technical requirements, Gap-Fit analysis, data mapping, legacy system integration and customizations
• Performed Functional Design provides Solution, Business Rules, Data Requirements, Reports, Interfaces, Frequency / Timings, Dependent Process, Impacted Process, Audience, Legislative Requirements, Security Requirements, Security Administration, Conversion Requirements, Acceptance Criteria information.
• Involved in the Full implementation of PeopleSoft ePerformance and Time & labor Module that includes Rule identification and specs, Rule Programs, TRC/TRC Program definitions, Workgroup definitions, and conversion specs for T&L enrollments.
• Actively involved with set up of employee Payroll deductions, pay calendars, running of the Payroll process from pay calendar, pay sheet/un-sheet, pay calculation to pay confirm/un-confirm
• Applied all tax updates, HR, T&L bundles, and tools updates.
• Worked as a Senior PeopleSoft Consultant to help client successfully complete US payroll year-end processing.
• Involved in complete Testing of Payroll Interface along with the end user and involved in running the Payroll interface process as a part of Payroll Admin
• Worked with Business users for Requirement gathering and solutions, was a major part of the testing Effort for T&L Upgrade.
• Involved in Production Support and successfully resolved various issues related to payroll and HR by interacting with Users and the Business team.
• Implemented Employee and Manager Self Service for Time & Labor,mPerformance & mPerks
• Providing recommendations on reengineering Workgroups, TRC/TRC Programs, Rule/Rule Programs, etc.
• Created and maintained custom Application Engine to apply multi-site, multi-contract specific overtime, holiday, and shift and labor rules to all employee population.
• Performed a lead role in Design, Implementation & Testing the PS Employee Self Service and Manager Self Service applications
• Responsible for setting up and running the Pay Calc, Pay Confirm, Pay sheet, Pay tables, deduction tables, tax tables for Payroll process during Holiday season.
• Project co-ordination between customers and technical staff.
• Responsible for writing Test plan and Test Scripts for upgrade HRMS modules
• Conducted Test Coordination meetings with QA teams.
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing the SQRs for payroll out bound interfaces. Worked on the TALX interface
• Troubleshoot self services Myinfo issues to determine source of issue and the best approach for a resolution.
• Sending Monthly and Quaterly tax reports to all the states.
• Run the Audit reports monthly and yearly and provided to third party Audit team.
• Overtime Report: Developed a report to provide overtime details for a specific pay period.
• Analyzed the issue with the delivered Overtime Request page functionality in Time and Labor. It was determined that this functionality was broken as delivered. As this was a show stopper, developed a customization to fix the PeopleSoft bug with this page.
• The PeopleSoft delivered Timesheet page had a bug in case of Holiday weeks/Schedule Deviation. The “Total Schedule Hours” and “Schedule Deviation” values were not populated in case of Holiday Schedule. A custom PeopleCode fix was applied to the Application Package Code.
• Developed number of SQR Reports, PS Queries and other application customizations for fixing issues and new enhancements.
• Worked on Integration Broker and Application Class PeopleCode, for automating the Enrollment/Maintenance process for re-hires and new hires.
• Security related issues for the stores and performance issues.
• Troubleshoot payroll processing issues to determine source of issue and the best approach for a resolution. Write SQL queries to research intermittent issues.
• Running Contract pay and late pay after payroll process and involved in developing the customized payroll reports.
• Fixed the setup issue with the Careers Page for the external Applicant. The link received by the external applicant in his email was not directing to the desired page in Recruiting.
• Implemented Core Row Level and Department Security in the Benefits and Payroll Interfaces.
• Scheduled the security processes to run on a nightly basis by using the “Job Definition” and “Schedule a Job Set” feature of PeopleSoft.
• Developed custom SQR programs and modifications according to Meijer specific business requirements using Application Designer, Component Interface, PeopleCode, SQL, SQR, ExcelToCI, etc.
• Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
• Analyzing the custom functionalities in PeopleSoft.
• Worked on Integration Broker created REST services for the integration of phone munbers in mPerks and team member appreciation cards using Application Class PeopleCode
• Creating complex SQL to retrieve the data from different time systems.
• Assign tasks to the offshore team and system test the offshore deliverables on Integrations.
• Participate in weekly and monthly status reporting and governance meetings with the customer.
• Involved in Production Support and join tech line calls to help resolve issues.
• Arranged review meetings and discussed issues with developers and other team members and Implemented Software Development Life Cycle (SDLC) using Agile (scrum).

Environment: PeopleSoft HRMS 9.1, People Tools 8.55, Windows NT,Mainframes, UNIX, DB2.

Confidential, TX USA

Peoplesoft Techno functional Lead Consultant

Responsibilities:

• Help in understanding the upgraded functionality with new online features and their setups to decide the Go\No - Go decisions with the new features and helping in upgrade activities.
• Operational support includes like object comparison, migrations, data validation, data conversion, supporting upgrade change process, quality assurance of all development work, helping in understanding team on new functionalities.
• Analyzing and identifying the impacted objects to decide retrofit or customize or retain the objects. The objects includes all kind of PS objects like PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs, Application Packages, style sheets and other type of objects.
• Involved in consolidation of the business processes, which reside in PeopleSoft 9.1 instances, and support US operations and Global operations.
• Involved in design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation
• Studying current business processes and recommending future businesses with new advanced PS features.
• Coordinating with users, onsite and offshore teams.
• Analyzed the impact on current production environment and support their processes simultaneously
• Carry out testing according to the test standards and procedures.
• Deploying Tax updates, Bundles and other mandatory patches delivered by Oracle.
• Extensively worked and given support to Payroll, ESS, MSS, HR users.
• Worked with customers to analyze and resolve the Payroll related issue for multiple regions.
• Provided 24x7 support including on-call support to customers resolving their priority issues.
• Experience with Microsoft Service Manager for daily ticket resolutions.
• Created SQR’s to pull applicant information from Taleo System (Recruiting Application) to Manager Hire process.
• Troubleshooting the problem areas in interfaces with Benefits programs, enrolling employees into Benefit plan (BEN PROG PARTIC), calculating payroll deductions in producing Benefits reports which indeed worked on tables like LEAVE PLAN, SAVINGS PLAN, HEALTH PLAN, DISABILITY PLAN, LIFE ADD BEN.
• Used PeopleCode to control the program flow, logic and validation to meet the current business requirement. Written the PeopleCode in save edit, save post change, save pre change.
• Resolved numerous Payroll, HR and custom modules production issues.
• Assisted/Managed the technical team members during critical payroll runs at onsite.
• Generate Reports for users and for Audit purpose.
• To schedule the jobs and monitor the same.
• To solve all the issues and request raise by business users.
• Ensure that the Inbound and Outbound interfaces of the application are working fine
• Assisted in analyzing various Production Issues pertaining to XML Publisher, Integration Broker, PS Queries, etc.

Environment: PeopleSoft HCM 9.1, People Tools 8.51, Oracle Database Application Designer, People code, Application Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, STATS, TOAD, XML Publisher, File Layout.

Confidential, MI

Peoplesoft Lead Technical Consultant

Responsibilities:

• Participating in project estimations, project plans, project plans review, discussion with users and providing inputs for enhancements.
• Operational support includes like design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation, object comparison, migrations, data validation, data conversion, quality assurance of all development work, training technical staff, training users on new functionalities.
• Studying current business processes and recommending future businesses with new advanced PS features.
• Working and retrofitting permission lists and roles.
• Developing web services for the third party related operations based on new system functionalities.
• Analyzing and identifying the impacted objects to decide solution approach. The objects includes all kind of PS objects like PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs, Application Packages, style sheets and other type of objects.
• Developing minor SQRs, SQCs and other impacted processes.
• Developing Oracle scripts to import and export data to different environments.
• Performing Unit testing based on the test plans and providing support for functional, integration, system, performance and UAT testing process.
• Testing end to end Client system functionalities.
• Fixing the defects reported during System testing, UAT and production support.
• Tracking and logging the defects identified and reported from QA, testers and users using Webstar tool.
• Coordinating with users, onsite and offshore teams and scheduling the knowledge transfer sessions.
• Working with Database team to proactively identifying the live performance issues in advance and helping the team to apply the fixes.
• Working with Oracle to report and to get the fix or workarounds for various issues identified as part of defect fixing based on various severities.
• Proactively communicating the expectations and limitations of the project and helping the team to reach the milestones as planned.
• Interacting with users, BA team, QA team and development team to understand the limitations and enhancements and helping them to understand the best functionalities in achieving the business needs based on latest advancements.
• Handled all the migrations between different environments through STAT tool and helped in audit reporting.
• Helped users to test the system thoroughly and timely fixed the bugs before implementing the system.
• Completed data conversion with minimal defects from old discipline system to new discipline system.
• Was part of the entire cycle of system development and implementation and received client appreciations after the Go Live.

Environment: People Tools 8.49, HCM 8.9, Application Designer, People code, Application-

Confidential CA

Technical Consultant

Responsibilities:

• The scope of the project involves support of PeopleSoft modules Core HR, Benefits, Payroll Interface and Base Benefits at Toyota on PeopleSoft version of 8.0.
• This includes smooth running of Payroll process every day, support the business during the open enrollment and enhancements to the existing functionalities as well as support the daily activities in PeopleSoft.
• Worked on Application Engine, Component Interfaces, SQR and JCL.
• Performance tuning of different processes which helped to peed up the production activities.
• Converting all the record level audits to Database level triggers.
• Studying current business processes and recommending future businesses with new advanced PS features.
• Performing Unit testing based on the test plans and providing support for functional, integration, system, performance and UAT testing for defect free upgrade process.
• Testing end to end Client system functionalities.
• Fixing the defects reported during System testing and UAT.
• Tracking and logging the defects identified and reported from testers and users.
• Coordinating with users, onsite and offshore teams.
• Providing support through all the phases of upgrade and preparing Go Live activities for applicable tasks.
• Analyzed the impact on current production environment and support their processes simultaneously
• Carry out testing according to the test standards and procedures.
• Analyzing the issues and providing solutions within timelines as per support SLA.
• Customized the Pay cycle Process- AP Module, for which got appreciation from Client.
• Deploying Tax updates, Bundles and other mandatory patches delivered by Oracle.

Environment: People Tools 8.49, 8.51, FSCM 9.1, Application Designer, People code, Application Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, STATS, TOAD, XML Publisher, File Layout.

Confidential

PeopleSoft Developer \ Software Engineer

Responsibilities:

• Providing impact analysis, estimating the effort required and preparing technical documents based on functionalities
• Preparing the design documents, developing the existing SQRs and processes
• Requirements gathering, analyzing the business cases, responding to the critical production issues and leading the offshore team.
• Played key role in Development and Testing of Interfaces, Online Customizations and data conversions using SQR, People Code, Application Engine and Component Interfaces for PeopleSoft HR module.
• Extensively worked on Preparing Test scenarios and scripts and executing the test cases and code fixes.
• Worked on critical Interfaces and tested the interfaces thoroughly.
• Was part of data conversion team and developed batch programs to convert data from legacy system to Peoplesoft using application engine, file layouts and peoplecode.
• Worked on Application Engine, Peoplecode and Component Interfaces, Inbound/Outbound Interfaces, SQR and queries.
• Development of Online pages, customizing PeopleSoft objects and Unit testing and preparing the test cases.
• Developing or enhancing App Engines and other online objects as per the business requirements.
• Deploying Tax updates, Bundles and other Oracle delivered mandatory patches.
• Developing or customizing Excel to CI for data load, PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs.
• Provided support to fix the production issues in different areas like PeopleSoft Customers, Order Capture, Inventory and PS Security
• Customizing the PS Security and providing required access to the people by assigning proper roles.
• Understanding the Functional Specifications from the client and Preparing Technical Specification.
• Developing the objects, Preparing Unit Test cases, preparing the Code review documents and reviewing the Code developed by fellow team members.
• Involved in preparing Reports for Users using PS Query and XML Publisher.
• Worked extensively on the People code.
• Participated in team planning activities and training sessions.
• Worked on interfaces and Mapping spec’s related concepts.
• Played in critical part in migration of the projects from the development environment to other testing environments.
• Reports-XML Publisher: Unified and Secured XML reporting for all reports through one module. Generating Reports and sending as Email to the customers.

Environment: PeopleSoft HRMS V8.4 and V9.0, Reports, Oracle 9i, People Tools 8.47Application Designer, People code, Application Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, TOAD, SQR, XML Publisher, File Layout

Confidential

PeopleSoft HRMS Technical Developer

Responsibilities:

• Involved in detail design, development and testing .
• Analyzing the SQR Code and People Code and retrofitting the same.
• Analyzed requirements and applied customizations.
• Performing unit testing and System Integration Testing
• Created the Fields, Records, Pages, Components and Menus for customization as per the requirement.
• Created new Permission list and Roles for the specific business rules.
• Created and registered the Processes, associated permission lists and run SQR Program through PIA.
• Involved in Scheduling the Batch Programs to run periodically through the Process Scheduler.
• Developed Data Mover Scripts to move the data between the environments.
• Developed Unix Shell Scripts to run the SQR, App Engine Programs and for FTP of the generatedOutbound files.
• Participated in migrating of project in different environments such as development, testing and production.
• Involved in extensive Data validation using SQL queries and back-end testing..
• Gathering requirements regarding the change specified by clients
• Technical developer and directing the project teams in-terms of business processes, gathering requirements on Implementation and support process
• Performing Fit-Gap analysis and Functional/Technical Design Documentations.
• Created functional design document for Journal Edit load balancer
• Performed configuration and setup for Allocations
• Integration Broker extensively used for event management functionality in AP
• Involved in PS Upgrade/Patches/Bundle Fixes/Compares and project Migration operations
• Create application packages for handling the vouchers from 3rd party system that are loaded through integration broker
• Experience in managing / troubleshooting Web Servers / Application Servers / Process Scheduler on UNIX as well as NT operating systems and involved configuring, monitoring and troubleshooting Integration Broker
• Developing Various Interfaces/Batch process through App Engine, SQR programs and several online customizations through People code and Cis
• Acted as key source of contact for current Production issue relating to all the system testing
• Involved in integration testing and system testing. Developed Testing Scenarios. Troubleshoot and fixed bugs and errors as per client requirement after applying patches and bundles
• Strong working experience on development of the technical Strategies and methodologies
• Developed nVision reports for providing users with the extract of vouchers on a daily basis part in migration of the projects from the development environment to other testing environments.
• Reports-XML Publisher: Unified and Secured XML reporting for all reports through one module. Generating Reports and sending as Email to the customers.

Environment: PeopleSoft 8.3/9.0, People Tools 8.49 People Code, App Engine, Component Interfaces, Integration Broker, SQR, Workflow, App Packages, XML Publisher, Crystal, Oracle, Remedy, Cybermation

Confidential

Technical Consultant

Responsibilities:

• Trained employees at different levels in People Tools, SQR, design and development.
• Designed, customized and developed various PeopleSoft custom applications with different organizations to meet their standards and respective requirements.
• Involved in detail design, development, testing, conversions and modifications of the client as part of implementation.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both the systems.
• Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files and XML files.
• Created Various SQR Interfaces (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, Derive various values based on the data from the external system.
• Designed, Developed various crystal reports across various modules for specific requirements.

Environment: PeopleSoft HRMS, Financials 8.4, People Tools, People Code, SR, Oracle 8i, Process Scheduler, Tree Manger, Unix Scripts, Security, Query Manager and Windows XP.