Professional Summary:

• About 11 years of IT experience in HCM, Payroll and Recruitment systems
• 8 years of experience in PeopleSoft HCM, Payroll application customization, enhancements, configuration and post implementation support
• Oracle Peopletools Certified
• Extensive experience in Peoplesoft Payroll enhancements and full cycle Payroll testing
• Experience in eRecruit module, Performance Management and Mainframe technologies (MVS, JCL, Cobol, Easytrieve) and databases (DB2 and Oracle)
• Delivered Benefits Year End and W2 projects
• Data migration expertise to and from Peoplesoft
• Worked on Interfaces, Peoplesoft to General Ledger, Kronos Time and attendance interface experience
• Experience in Tesseract and Geac HR systems
• Full Cycle SDLC implementation experience
• Simplification of business process, changes to Workflows
• Very good analytical skills aimed at Developing Solutions, Problem solving and Issue resolution
• Customer appreciations received for quick turnaround of activities and for quality implementations
• Result oriented techno-functional consultant, with strong analytical skills
• Team player, also been an individually contributor
• Good communication and people management skills

Technical Skill:

Application Software

PeopleSoft HRMS (version 8.8, 8.9), Tesseract, Geac

Programming Languages

PeopleCode, Application Engine, PS Query, SQR, COBOL, JCL, Eztrieve

Tools

Peopletools (version 8.45, 8.47), Application Designer

Databases

DB2, PLATINUM and File Manager for DB2, DB2 Control Center, IBM

DB2 tools/utilities Oracle, Oracle SQL Developer, PL/SQL

Utilities

Vantive Problem Management, Remedy Incident Management,CA-7 and ESP scheduler

Version Control

Endevor, VSS

Operating Systems

Mainframes OS, UNIX (OMVS), Windows NT

Work Experience:

Confidential, Dallas, TX

Project Lead & Peoplesoft Techno-Functional Consultant

Responsibilities:

• Coordinating with customers to get the functional requirements and documenting the technical requirements
• Enhancements made to the mandatory Ethics Statement and tracking the progress through worklists
• Peoplesoft General Ledger Interface programs analysis and modifications to accommodate new company, paygroup, deductions
• Benefits Year End modifications to existing Plans and absence entitlement and carryover and payout
• Compensation Year end enhancement with complete cycle Payroll testing
• Analyzed and optimized the Org Structure process
• Customizations on Succession Planning to fit in business rules
• Analyzed and modified existing Payroll programs for New Company and Paygroup setup and tested the payroll cycles
• Developed programs for Referral Payment Automation
• Part of the W2 Year End project
• Made changes as part of Quarterly ADP Tax government reporting
• Added Primary Language as part of recruitment pages
• Made changes to Referral pages, Referral rules and Eligibility rules
• Leading and guiding the offshore team with a peak strength of 8
• Estimating efforts and Preparing schedule and timeline
• Provide enhancements based on requirements including Application Engines, SQR, Workflows, Integration Broker
• Unit testing, Integration testing and User-acceptance testing
• Ensure the Production problems are resolved within SLA
• Ensure the overall quality of the project, review coding and testing

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.47, Talent Acquisition Management, ePerformance, SQR, COBOL, JCL, BAT, PL/SQL, Oracle 10g, Windows NT, Mainframes z/OS, VSS, Endevor, ESP, Remedy Incident Management

Responsibilities:

• Design new jobs for Merchandise remodelling project based on requirements
• Review functionality of existing batch job stream and online
• Coding using Cobol and JCL
• Unit Testing, Functionality testing, String testing, Smoke testing, Integration testing
• Migrating components to User Acceptance
• Review coding and testing done by team members

Environment: COBOL, JCL, DB2, PLATINUM for DB2, File Manager for DB2, Mainframes zOS, Endevor

Responsibilities:

• Provide enhancements based on requirements by developing new or modify existing Application Engines, SQR, Workflows, Application Messaging in Integration Broker
• Developed Mass job change program to make large data changes
• Made changes and executed and monitored the quarterly Performance management process
• As a part of the HR Simplification project created new components, pages and setup security to access them online
• Setting up new Workflows based on requirements
• Support the Peoplesoft HRMS system
• Maintaining the interfaces with Payroll, Time & Labor, AIMS, STMS/LDAP, ITAX and other systems like EDW, etc
• Resolving Application Messaging issues in Integration Broker
• Enhancements to the Peoplesoft Tesseract Payroll interface
• Leading and guiding the offshore team with a peak strength of 9 at offshore and 4 at onsite
• Project management with estimating efforts and Preparing schedule and timeline
• Ensure the Production problems are resolved within SLA
• Ensure the overall quality of the project and metrics Reporting
• Knowledge sharing with new team members and helping them learn project related tools
• Resolving PeopleSoft Tesseract HR payroll interface issues
• Providing support for the Peoplesoft HR batch jobs
• Taking care of online page issues in the Peoplesoft HR system
• Peoplesoft interface support with AIMS, APTRACK, Kronos 8d, Kronos WFC and other downstream systems
• Knowledge transition of THD HRMS system
• Knowledge transition for integration with Payroll, Recruiting system, LDAP, Enterprise Data Warehouse, Security
• THD HRMS System and Process documentation
• Playback session with THD

Environment: PeopleSoft HRMS 8.8, PeopleTools 8.45, SQR, COBOL, JCL, DB2, IBM DB2 Control Center, PLATINUM for DB2, CA-7, Mainframes zOS, Endevor, Vantive Problem Management

Responsibilities:

• Conversion from Tesseract to PeopleSoft
• Analysis for extracting data from the existing HR Payroll system
• Design of jobs and programs for extracting data
• Coding using Data Extractor, Cobol, EASYTRIEVE, JCL, SQR
• Converting data to the required format by developing programs and using tools
• Data conversion from Old to New Data Warehouse
• Analysis of existing TCD Hewitt system to give data to proposed EPM Data Warehouse
• Design and develop the interface from existing TCD system to new EPM Data Warehouse
• Freezing data from the existing RIDA FULL system in phases based on the implementation
• Develop the History Database which is a snapshot of the Production Database during implementation

Environment: Tesseract, SQR, COBOL, JCL, DB2, Platinum, Softtech, Mainframes zOS, Endevor, Tesseract Data Extractor

Target Corporation is the second largest discount retailer in the US. It has more than 1700 stores. The ESS MVS HR Payroll was established to provide enhancements, maintenance and support to the existing HR, Payroll and other integrating systems in Target as well as its other companies Marshal Fields and Mervyns.

Responsibilities:

• Modified programs as part of HR and Payroll enhancements
• Made changes as part of the yearly Benefits Enrollment project
• Involved in W2 form changes in the W2 year end project
• Worked on enhancements by analyzing the existing system for the requirement and also performing the changes based on the requirement
• Coding, testing and implementation of user requirement
• Retrieving the data from the database repository using Softtech and querying the information from the database using Spufi, QMF
• Working on job failure or abends and other issues while in the Support team
• Knowledge sharing with new team members and helping them in learning project related tools
• Documenting the changes made

Environment: Tesseract, Geac, COBOL, JCL, Easytrieve, DB2, Platinum, Softtech, CA7, Mainframes zOS, Endevor