PROFESSIONAL SUMMARY

• 16 years of IT industry experience of which 12 years as a PeopleSoft HRMS Techno - functional Consultant.
• Experienced in different roles as Project Lead, Technical lead, Business Analyst, Systems Analyst and Developer.
• Experienced in upgrade from PeopleSoft HR/ELM from 9.1 to 9.2
• PeopleSoft 8.x/9.x HCMS experience in the modules of HR, Payroll, Benefits, Ben Admin, Pension Admin, Position Management, Absence Management, ELM, Time &Labor, self-service (ESS, MSS).
• Hands-on experience in scope study, requirements gathering, Functional Requirements, Fit-Gap Analysis, Design, Configuration, Change Management, Risk Assessment, End-User Acceptance Testing, Product Development, Quality Assurance and developing Functional and Tech. Specs.
• Expertise in People Tools, Application Designer, Workflow, Component Interface, Application Engine, Integration Broker, Application Messaging, Data Mover, Tree Manager, People Code, SQR, PS Query and Security Admin.
• Delivered end to end process/systems including business and user requirement analysis, process studies and constant improvement of the systems, functional documentations, managing consistency in quality and improvement in the process, production database updates, testing and validation.
• Mentored IT teams by orienting, training, assigning, scheduling, and coaching individuals for peak performance.
• Applying Maintenance Packs, Tax Updates, Patches, Bundles.
• Experienced in various stages of project development life cycle - Project Planning, Estimation, Requirement gathering, estimation, Analysis, Design, Implementation, Unit Testing, SIT, Acceptance Testing, preparing FDD/TDD, Training, Data Migration, Production Cutover, Incident & Problem Management, Transition Management and Configuration/Quality Management.
• Excellent communication, analytical, presentation, interpersonal, interaction and organizational skills, vibrant Team player/leader who loves taking additional individual responsibilities
• Has 10 years onsite experience in customer facing, relationship development, proactive demand generation and account mining roles
• Extensive experience in leading and managing teams in both onsite/offshore models.

TECHNICAL SKILLS

PeopleSoft HRMS Modules: PeopleSoft HCM (HRMS) v 9.x/ 8.9/8.8/8.3/8.0/7.5

People Tools/ Utilities: PeopleTools 8.1x, 8.2x, 8.4x, 8.5x, Peoplecode, Application Designer, Application Engine, AWE - Approval workflow engine, Component Interface, File Layout, Application Messaging, Integration Broker, Process Scheduler, PS Query, Data Mover, Import Manager, Workflow, Excel to CI, STAT and Security.

Reporting Tools: SQR, Pro*C, Oracle Forms, nVision, XML Publisher and Crystal Reports

Operating Systems: Windows NT/XP/95, MS DOS and UNIX

Languages: C, C++, HTML, XML, COBOL, SQL, and PL/SQL

RDBMS: Oracle 7.x/8.x/9i/10g/11g, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, WA

Sr. PeopleSoft Consultant

Roles & Responsibilities:

• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54
• Participating in Fit/Gap analysis & defining the organizational process related customizations to new functionality under 9.2
• Identifying the level of effort for retrofitting customization to 9.2
• Assisting in the initial tools upgrade and patch levels agreed upon by the project team.
• Besides the upgrade project assistance, conduct day to day operational production support & sub-initiatives activities. Some of them as below:
• Assisting in developing the compliance & reporting needs for Affordability Care Act and developed the process for 1095C.
• Assisted and designed Open enrollment process improvement and UI improvements so that user clicks will be reduced during the OE.
• Developed Batch Maintenance application.
• Helped in designing Strategies for Archiving to improve performance and organizational compliance.
• Implemented PCARD Process.
• Worked on Open Enrollment changes, Tax updates.
• Working on the Customizations of Recruitment/TAM, Core HR, ELM, T&L and Payroll Module.
• Developed 401K loan deductions process for both inbound and outbound interfaces.
• Developed Holiday hours load process.
• Conducted meetings with the Users and the involved in discussing their pain points and assisted with developing solutions/resolutions.
• Hands on experience in PTF to reduce overall system testing and addressing future patch related system testing.
• Developed Password challenge application to maintain the employee password challenge questions and answers and all these answers encrypted in database.
• Customized TL timesheets approval system so that anyone in the payroll team and higher managers can approve the time sheets instead of only manager.
• Assisted and developed dynamic distribution list application to maintain the company wide email distribution lists.
• Assisted and developed VISA notification application to inform HR managers and vendors about VISA expiry of employees and vendors.
• Involved in design and development and implementation of BenefitsFocus for Premera. Developed interfaces for demographic details and Payroll deductions.
• Customized HIPPA 834 process to produce the benefit enrollment and maintenance details file according to PREMERA

Environment: PS HRMS 9.x HR, Payroll, Benefits, TAM, Time and Labor, ELMPeople Tools 8.53, Application Designer, SQL server, PeopleCode, XML Publisher, AWE, Workflow, Integration Broker..

Confidential, TX

PeopleSoft Consultant

Responsibilities:

• Facilitated meetings with HRMS team members to identify business issues/challenges.
• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• Troubleshoot high priority issues during development.
• XML Publisher Report changes for SACS roster report and other reports.
• Modification/Creation of Interfaces.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement issues.
• Worked on the Customizations of Recruitment/TAM Module.
• Created application package to post GENL deductions online based on JOB data changes.
• Customer interaction and understand the business requirement, analyzing and preparing.
• Created new CI for JOB Data Salary changes and data loaded using ExceltoCI tool.
• Extensively involved in creating PS Queries for day to day operations.
• Worked on interface programs for migrating data from other systems to People Soft.
• Involved in trouble shooting Integration broker issues and solved data sync issues between HCM and CS & ELM.
• Involved in AWE changes for ESS/MSS transactions.

Environment: PS HRMS 9.1 HR, Payroll, Benefits, TAM, Time and AttendancePeople Tools 8.50, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, XML Publisher, AWE, Workflow, Integration Broker & Shell scripting.

Confidential, Seattle, WA

PeopleSoft Analyst

Responsibilities:

• Analyze the application and manage the list of processes related customizations.
• Applying maintenance packs and bundles.
• Managing the smaller development/enhancement projects.
• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• AWE customization & Troubleshoot high priority issues for business continuity activities/processes.
• Modified processes and corresponding Linux scripts based on the requirements.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement tickets..
• Oversaw and coordinated efforts of the functional team, technical team, testing team, application security and Responsible for successful delivery of technical development with quality.

Environment: Peoplesoft SCM 9.1 (Procurement and Purchasing)People Tools 8.50.21, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, AWE, Linux scripting.

Confidential, Maumee, OH

Team lead

Responsibilities:

• Facilitated meetings with HRMS team members to identify business requirements.
• Customer interaction and understand the business requirement, analyzing the FDD, preparing Technical Design, giving the estimation and working on client deliverables.
• Lead for all infrastructure related items with People Soft.
• Manage daily, weekly review of the team.
• Oversaw and coordinated efforts of the technical team, testing team, application security and
• Responsible for successful delivery of technical development from offshore, with quality.
• Deliverables meeting the business requirements, on time and on budget. Managed day to day activities project team members
• PeopleSoft HCM Application Security.
• Managing the customer & Vendor relationship.
• Applying Maintenance Packs, Tax Updates, Patches, Bundles.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation. Provided production support and functionality enhancements to improve HR and Payroll efficiencies.
• Created and managed Project Charter, Project Plan, Risk log, Issues log, Status reports, project team meetings and other project related project office activities and strategy documents in collaboration with the HCM Program manager
• Responsible for Design, development, implementation, testing and support of assigned software Projects and applications from offshore.
• Manage the New change request or development in the existing system.
• Managing Resource Allocation, Effort Estimation & project planning.
• Involved in Gathering and Analyzing requirements for HR Initiatives project to Outsource Health & Welfare Benefits to ACS.
• Prepared Functional Specification for Interfaces from ACS to Dana to bring in General Deduction Data.
• AWE customization. Worked on the Customizations of Recruitment/TAM Module.
• Worked extensively with eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on the Recruiting Process of eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
• Performed system study of current Base Benefits and Benefits Administration setup as part of Application support transition project.
• Providing Production Support, User Support and Enhancements in Payroll (8000 Hourly employee, 3000 Salaried Employee), Ben Admin, and Base Benefits modules.
• Monitored project deliverables and execution(Change Management, Implementation, production Support and Security) to meet Sarbanes-Oxley requirements
• Participated in External vendor management, including gathering 3rd party vendor requirements and communicating the same to the business, providing IT solutions to business as per need. Prepared functional technical design documents for respective PeopleSoft solutions
• Developed solutions based on specifications including application customizations, custom reports, and interfaces.(Using SQR, People Code, Application Engine, Component Interfaces, File layouts etc.)
• Worked in Taleo and TCC

Environment: PS HRMS 9.1 (HR, Payroll, Benefits, Pension Admin, Time and AttendanceAbsence Management, GL and AP) and TCC People Tools 8.50, Application Designer, Oracle 10g, SQL, PL/SQL, SQR, Peoplecode, Workflow, Unix.

Confidential, Phoenix, AZ

PeopleSoft Tech lead.

Responsibilities:

• Design, development and enforcement of the Quality Standards, document templates, test database creation, test plans and the document control procedures, Application Security Strategy, design, configuration, maintenance and troubleshooting.
• Quality Assurance of PeopleSoft objects including Components, Pages, Menus, Records, Peoplecode, Application Engine, Component Interfaces and Security.
• Testing the full functionality of new /existing reports using SQL and PeopleSoft Queries.
• Onsite- offshore co-ordination, requirements gathering, estimation, designing and planning.
• Ensure SLA compliance, customer satisfaction; provide weekly & monthly reports, trainings and mentoring.
• Production support for trouble shooting and bug fixing.
• Quality Assurance, reviews and system/integration testing.
• Preparing Functional and Technical specifications. Design and review the test plans.
• Developed Outbound Interface programs to process Employees Demographic Information, Basic Demographic Information, Payroll Data, Health, Medical and Dental Eligibility information from PeopleSoft System to 3rd party system.
• Designed and developed an online Enhancement to assign the Emplids with in the delivered PeopleSoft application and developed a custom program to identify which Emplids have been used and unused.
• Performed Code reviews to ensure that code meets best practices and functionality.
• Customized the Employee Self Service and Manager Self Service personal info summary pages.
• Developed a process to create interface between Benefits and Time & Labor which compares Employee's leaves recorded in Time & Labor against the allowed leaves.
• Customized the delivered SQR process BAS005 to generate Benefits confirmation statement that meets business requirement.
• Also Working on other Integration Tools for Integrating PeopleSoft Data with other Applications.
• Developing interfaces and reports.
• Working on customizations for self-services, core HR and Benefit HRMS modules.
• Modifications of SQR’s, people code, creating new process for uploading data using CI and application engines.
• Developing new interfaces for different vendors MetLife, BUCK, MetLaw etc.

Environment: Oracle 9i,SQL, PL-SQL, Windows, PeopleSoft HCM 8.8 Core HR, ESS&MSS Benefits, Payroll interface, Compensation, PeopleTools 8.45 and SQR.

Confidential, Santa Clara, CA

PeopleSoft Techno functional consultant

Responsibilities:

• Setting up security for users, permission list and roles for user to access specific page in PeopleSoft. Worked on benefit Admin process to get the employees enrolled.
• Working on production support and development and enhancements
• Preparing Technical specifications. Developed Outbound Interface programs to process Employees Demographic Information, Basic Demographic Information, Payroll Data, Health, Medical and Dental Eligibility information from PeopleSoft System to 3rd party system.
• Created custom reports on Base Benefits on Deduction Rate change and HI Enrollment.
• Calculate benefit costs and coverage amount in benefit administration.
• Preparing for open enrollment and event maintenance process.
• Scheduling the BenAdmin process. Worked on running the Ben Admin process to populate the Snap Table.
• Developing interfaces and reports. Also Involved in the development and customization of on-line panels and menus
• Working on customizations for self-services, core HR and Benefit HRMS modules.
• Providing Production Support for released work.
• Modifications of SQR’s, people code, creating new process for uploading data using CI and application engines.Major developments:
• Developed application engine process to upload JOBCODE’s using CI. Developed application engine process to upload JOB data changes and
• Upload employee salaries using CI. Developed different interfaces for Softscape, Worforce logic and HRSMART.
• Developed Hire process for both Workforce logic and HRSMART using application engine and CI which includes auto creation of user profiles.
• Open enrollment changes. Developed department sync between PeopleSoft finance and HRMS using IB.

Environment: Oracle 9i, SQL, PL/SQL, Windows, PeopleSoft 8.8 Core HR, ESS&MSS, Base Benefits, Benefits administration, Payroll Interface, PeopleTools 8.45 and SQR.

Confidential

PeopleSoft Technical consultant

Responsibilities:

• Developed Functional and Technical design documents for complex processes, customizations, enhancements, reports, interfaces and conversion programs.
• Gathered requirements, analyzed, designed and developed Interfaces and processes to integrate Legacy and 3rd party systems with the PeopleSoft HCM system.
• Designing Test plans by comparing the inputs and desired output
• Designed and developed Data Conversion programs to convert Employee data from a legacy mainframe HR/Payroll System to PeopleSoft HR/Payroll System using Component Interface and Application Engine.
• Developed Application Engine batch process to determine the Employee’s full vacation entitlement.
• Involved in analysis of COBRA Interface and writing Technical Specifications. Writing interface programs based on technical specs to send changes occurring in benefits.
• Developed an Inbound Interface program which processes the 401k contribution amount and loan deduction amount from 3rd party system to PeopleSoft HCM system.
• Developed reports to present the Benefit information, Job Anniversary, Retired Employees, Terminated Employees information.
• Also Involved in the development and customization of on-line panels and menus
• Timesheets Customization. Comptime, Shift Differential, Overtime, holiday rules developed.
• Trouble shooting HR/Payroll/ Time & Labor issues.
• Working on customizations for self-services, core HR and Benefit and Time & labor modules. Providing Production Support for released work.
• Worked on the Customizations of Recruitment/TAM Module.
• Worked extensively with eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on the Recruiting Process of eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
• Developed, customized and modified existing records, pages, components, menus, Sub-records using Application Designer to meet the Business requirements of the client.
• Customization of Application engine Programs to accommodate the requirements of the Client and to perform background SQL processing.
• Involved in applying Maintenance Packs, Tax Updates, Patches, Bundles and Objects migration
• Designed and Developed Inbound Interfaces and processing procedures for processing and Loading Employee Benefits, Deferred Compensation, Loan and 401K Contributions and Vacation Buy and Health & Welfare information in to PeopleSoft Tables.
• Created Data mover Scripts to move Roles, Users, and User Preferences with other security setup to be migrated from one instance to other.
• Involved in creating Technical documents, development and enhancement of PeopleSoft HR, Base Benefits and Payroll. Unit Testing of the Customizations.

Environment: Oracle 9i, SQL, PL/SQL, PeopleSoft 8.8 Core HR, ESS&MSS, Contract admin, Compensation, Time and Labor, Position Management, NA Payroll, Candidate Gateway,ELM, PeopleTools 8.45, SQR

Putnam Investments

Confidential

Roles& Responsibilities:

• Involved in KAP phase for 2 months in BOSTON, US at client place and prepared SMTD and EPD after the KAP.
• Managing Team of 4 Resources
• Working on PeopleSoft version 8.3, PeopleTools 8.18
• Designing Test plans by comparing the inputs and desired output
• Designing the Technical Design Document for the reports
• Coding for application Engine programs making File layouts etc for importing data from Flat files to PeopleSoft Database.
• Also Working on other Integration Tools for Integrating PeopleSoft Data with other Applications.
• Developing reports using the PeopleSoft Query, SQR.
• Also Involved in the development and customization of on-line panels and menus
• Providing Production Support.
• Created Object modification and Unit Test Plan documents for each change performed on all objects using quest stat.
• Tested and executed these UTPs to prepare System test and Implementation.
• Also Monitoring and providing user support, production support and enhancements for Vacation Accrual, Interfaces, Yearend process etc.
• Responsible for debugging and troubleshooting the payroll issues.

Environment: Peoplesoft HRMS v8.18 Core HR, Benefits, Applicant tracking/Recruit Workforce Payroll interfaces, Recruiting, People Tools v8.3, SQR, MS Access, Oracle v8.1.7, Win NT

Confidential

PeopleSoft

Responsibilities:

• Designed and developed various interface programs to move data from Legacy Systems to Peoplesoft database by using SQR, Application Engine.
• Worked with development team during the upgrade of PeopleSoft from version 7.5 to version 8.3.
• Retrofitted the batch programs SQR’s and SQL’s scripts for PS8 upgrade based on the analysis that was made.
• Analyzing the impact of new fields in custom programs developed.
• Identifying the batch programs SQR's and SQC's that needs to be retrofitted for PS8.
• Data validations, Setting default values, dynamically deriving the field values, implementing business rules etc. using People Code. Debugging the People Code using Debugger.
• Reviewed and modified Application Engine programs that are used to convert application data.
• Validated and modified People code changes.
• Responsible for unit and integration testing of the customized/modified applications and PeopleSoft delivered fixes and patches.
• Developed interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interface
• Developed new SQR programs to pull the data from PeopleSoft Database and it generate a Flat File, CSV file according to Technical specification.

Environment: HRMS v7.5 and 8.3, People Tools v8.16, SQR, MS Access, Oracle v8.1.6, Win NT and unix

Confidential

Responsibilities:

• Involved in Knowledge acquisition phase for around 2 months in Virginia, US, at client place.
• Prepared SMTD and EPD after the KAP.
• Involved in the technical detail designs, Troubleshooting panels. Fixed errors and bugs and tested the application.
• Tested and executed these UTPs to prepare System test and Implementation.
• Used Data Mover to move data from one environment to another for unit and integration testing.
• Created/modified Pro*C programs for processing and reporting purpose for various clients.
• Prepared Test cases and involved in the testing of different modules.
• Creation of database objects like tables, views, procedures and packages.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Involved in the designing of databases and developed the ER Diagrams with ERWIN.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN and HINTS

Environment: Window 2000/Win NT, MS Access, Oracle, SQL, PL/SQL and Pro*C

Confidential

Roles & Responsibilities

• As a development Team Member, was involved in design, Development, Testing and implementation of applications for batch processing and reports generation using Pro*C. Discussing with Project manager and Client.
• Prepared Specifications, technical documentation and test cases.
• Involved in the designing of databases and developed the ER Diagrams with ERWIN.
• Creation of database objects like tables, views, procedures and packages.
• Created and modified data entry screens.
• Creation of database objects like tables, views, procedures and packages.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Involved in the designing of databases and developed the ER Diagrams with ERWIN.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN and HINTS

Environment: Unix, Oracle, Oracle-Forms, SQL, PL/SQL and Pro*C