Profile Summary

• Around 7+ years of IT experience with an emphasis in PeopleSoft Implementation/Upgrade /Maintenance/Support.
• Currently working on PeopleSoft upgrade (HCM 8.9 to 9.1, PeopleTools 8.40 to 8.51).
• Diversified experience covering all stages of life cycle implementation: Requirements gathering and analysis, Fit-Gap analysis, design, development, data conversion, unit, integration and system testing, end user testing/training, Implementation, upgrade, Post-implementation support.
• Technical expert in using Application Designer, SQR, PeopleCode, Application Engine, ExcelToCI, Component Interface, Crystal Reports, nVision, Process Scheduler, PS Query, Process Monitor, Data Mover and File Layout.
• Developed complex reports using SQR, File Layouts, Application Engine, Crystal reports, PS Query and nVision.
• Excellent functional knowledge and project experience in the areas of PeopleSoft HCM Core HR, Base Benefits, Benefits Administration, Position Management, ePerformance,Profile Management, NA Payroll and functional understanding of all HCM modules.
• Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels.
• Motivated team player and leader willing to accept exciting new challenges and with sound understanding of the IT industry.

Skills

ERP : PeopleSoft HCM 8.x,8.8,8.9, 9.1  Core HR, Base Benefit, Benefits Administration, ePeformance, Profile Management and NA Payroll (Time and Labor, Position Management) Functional Understanding of all HR modules. PeopleSoft F/SCM 8.x, 8.4x, 8.8 (AP,AR)
PeopleTools : PeopleTools (8.18, 8.43, 8.45, 8.47, 8.48, 8.49, 8.50,8.51), Application  Designer, Application Engine, Process Scheduler, Data Mover,  Workflow, Tree Manager, Change Assistant
PeopleSoft Reporting : SQR, Crystal Reports, PS/Query, nVision
Integration Tools : File Layout, Integration Broker/AppMessaging ,Component Interface,ExcelToCI 
Languages : PeopleCode, SQL, COBOL, C
RDBMS : Oracle 9i, 10g,11i, MS-SQL Server 2000, 2005
OOP : C++, Java
Operating Systems : Windows 95/98, Windows 7/NT/2000/XP, UNIX
Others : Microsoft Office (Word, Excel, Power Point),Remedy, Putty, Toad,  beyond compare, Cisco VPN, Core FTP, Crimson Editor,  Oracle Enterprise Manager, HP QC, PHIRE, Editplus

Education

Masters in Computer Science
Bachelors in Computer Science

Training & Certification

PeopleTools Developer Certified Expert

Professional Experience

Confidential– Atlanta, GA Jan ’12 – Till Date

PS Techno-Functional Consultant

Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, Base Benefits, Benefits Administration and NA Payroll, Profile Management) PeopleTools 8.51

The scope of work for this project is to upgrade their existing PeopleSoft HCM 8.9 system to PeopleSoft HCM 9.1 along with implementation of newly added requirements. Retrofit customizations and use any new functionalities.

Key Responsibilities:

• Retrofit page and PeopleCode customizations
• Resolve and Interact with users for closure of issues
• Involved in data validation
• Help users configuring new application
• Retrofit Profile Management and eDevelopment customizations
• Retrofit COBOL, SQR and Application Engine programs
• Work on Tax updates and bundles in 9.1

Confidential– Richmond, VA June ’11 – December ‘11

Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, ePerformance, Base Benefits, Benefits Administration and Payroll Interface), PeopleTools 8.51

The scope of work for this project is to upgrade their existing PeopleSoft HCM 8.8 system to PeopleSoft HCM 9.1 along with implementation of newly added requirements. Retrofit customizations and use any new functionalities.

Key Responsibilities:

• Retrofit custom workflow
• Modify custom HTML and Java code to fit in new environment
• Retrofit page and PeopleCode customizations
• Interact with users for closure of issues
• Work with Oracle on issues/bugs
• Involved in data validation
• Create custom upgrade scripts
• Support during stabilization period

Confidential – Dallas, TX March ’10 – June 11

Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, Base Benefits, Benefits Administration and NA Payroll)

The scope of work for this project is to upgrade their existing PeopleSoft HCM 8.8 system to PeopleSoft HCM 9.1 along with implementation of newly added requirements. Retrofit customizations and use any new functionalities.

Key Responsibilities:

• Lead Activities:
• Project time/effort estimation and tracking. Reporting to program manager/steering committee
• Single point of contact to business for all upgrade project related issues/questions/concerns
• Coordinate with functional analysts to ensure application is rightly configured and designs meet user requirements
• Coordinate/support with offshore for upgrade activities
• Requirement Analysis/Fit Gap/Estimate LOEs/Project Planning:
• Analyzed client’s requirements with a view of fitting them to PeopleSoft HCM 9.1 application so as to minimize customizations and make the upgraded application maintenance friendly
• Estimated level of efforts and derived a high level project plan using compare reports, release notes and other tools
• Work with Oracle on issues/bugs
• Setups done include:
• Configure Job Subfunction and Job Code Table based on 8.8 Job Profile IDs
• Configure Employees refresh process (PER099)
• Retrofit Ethnic groups and Military status from custom fields
• Retrofit Dependents Effective date field from custom field
• Benefits Rate Tables
• Employee Name formats
• Personal information page defaults
• Turn off type ahead feature as it affects data entry
• Functional, Technical Designs:
• Major designs include:
• Document all custom processes and customizations identified in compare reports
• Document Surebridge process which moves files generated by processes to desired folders
• Document new functionalities that are going to be used in the new system
• Document changes to be done for process retrofit with time/effort
• Customizing pages/components/reports/views for flexible and efficient month-end closure
• Analyse, design, cleanse, retro fit PS-Queries
• Document Migration process
• Build & Testing:
• Coordinate build of the components per business design requirements
• Coordinate with functional analysts for unit testing
• Coordinate with users for UAT
• Lead UAT issues and assign/drive them to closure
• Maintained all upgrade environment servers
• Coordinate with DBAs for any server related issues
• Debugged conversion application engine programs to populate missing data
• Written complex custom sql/sqr/app engine scripts to correct/retrofit data (custom data)
• Re-applied/migrated PeopleCode customizations.
• Coordinate with load testing team to replicate some transactions in new environment for performance check
• Retrofitted queries. Replaced modified/replaced records/fields and joined with other records/fields in queries to match the results of 8.8. Created PS project through sqls to include queries for migration.
• Modified SQRs to run in 9.1 environment.
• Deployment:
• Moved approved retrofitted customization to GOLD (Upgrade Staging environment) using projects
• Managed security
• Coordinated dry runs
• Part of Managing environment creation, configuration and deployment
• Part of End-to-End Go-Live Deployment
• Performed and validated conversions
• Worked on change assistant for building environments

Confidential– Dallas, TX Dec ’08 – Feb ‘10

Environment: PeopleSoft HCM 8.8 (Core HR, Base Benefits, Benefits Administration and NA Payroll)

The scope of work is to support/maintain/enhance existing HCM 8.8 application.

Key Responsibilities: 
HCM 8.8 suite support/maintenance:

• Lead activities:
• Case analysis/assignment – Analyze cases and assign to appropriate team member. First level user contact for any questions/concerns about the case assignment, progress and delivery.
• Analyze and Estimate Time/Efforts: Analyze and estimate cost for all new enhancements. Gathering requirements, performing fit-gap, getting sign-off from the user. Assigning to team for low level design.
• Miscellaneous project activities - Quality control (check lists, approvals, reviews), delivery management (status meetings, approvals, sign-off) and migration management (migration docs).
• Prepare SOX Audit, QR100, WSR project reports
• Monitor Time entry of the project. Make sure time entered correctly for discretionary projects.
• Core Application Support:
• Common support issues include:
• Modify/maintain benefits enrollment forms
• Payroll: Setting up pay calendars, building paysheets, debug COBOL programs for payroll
• Kronos to PeopleSoft payline load issues
• Created functional and technical documents for change requests
• Customize reports/processes as per user requirements
• Monitor the system: Servers, process scheduler, schedule processes
• Applied Tax updates and standard patches
• Enhancements:
• Created 401k and pension vendor interfaces (Inbound and outbound) Written SQR interfaces as there was change in vendor. Outbound includes all employees personal, employment, loan and 401k deduction details for the report run period. Inbound contains new, default, closed, paid off and re-amortized loans details and deferral amounts.
• Organization wide company changes from alpha to numeric
• Identified interfaces and processes effecting the company format change. Updated Job data company with the new numeric format using component interface. Modified all processes affecting the change in format.
• Reporting tables generation.

Client wants to standardize the reporting of various HR and Payroll statistics. In the past, several individuals were involved in producing reports and sometimes different results were produced due to timing or a slight difference in calculating the statistics. To accomplish this task i developed reporting tables SQR refresh process where various statistics are pre-calculated and stored in records on a daily basis. These tables can be used for reporting by corporate and all the operating companies. This resolved data inconsistencies and standardized the reports.

• Fixing payroll issues and modifying/maintaining payroll interfaces.
• Created new projects/activities
• Written new (sqr/PS-Query) reports/queries

Confidential– Birmingham, AL Jun ’08 – Nov ‘08

Environment: PeopleSoft F/SCM 6.0, 9.0 (AP, AR,GL)

The scope of work is to upgrade existing Financial system from 6.0 to 9.0. As there is no upgrade tool available to upgrade 6.0 to 9.0, re-implemented along with newly added requirements.

Key Responsibilities:

• Requirement Analysis/Fit Gap/Estimate LOEs/Project Planning
• Created Technical Design documents as per functional requirements
• Estimated level of efforts for the technical requirements
• Build & Testing:
• Created custom upgrade scripts for Voucher, Vendor and Payment conversion.
• Applied customizations to Requisition Header page
• Created Wachovia bank Reconciliation process
• Modified GLS7002(General Ledger Detail) and PORQ009 (Requisition Reconciliation) reports
• Deployment:
• Coordinated dry runs
• Migrated customizations through projects across environments

Confidential– Plano, TX Aug \'07 – May‘08

Environment: PeopleSoft HCM 8.8 (Core HR, Base Benefits, Time and Labor, Learning and Development)

The scope of work is to support/maintain/enhance existing HCM 8.8 application.

Key Responsibilities: 
HCM 8.8 support/maintenance:

• Lead activities:
• Case analysis/assignment – Support Issues handled through Remedy tool. First level of contact for any Technical questions/concerns about the case assignment, progress and delivery. Analyze cases and assign to appropriate team member.
• Analyze and Estimate Time/Efforts: Analyze and estimate cost for all new enhancements. Gathering requirements, performing fit-gap, getting sign-off from the user. Assigning to team for low level design.
• Organizing user forums – Organize calls with user groups (APAC, Americas) to get feedback on support activities and gather new ideas and requirements.
• Miscellaneous project activities - Quality control (check lists, approvals, reviews), delivery management (status meetings, approvals, sign-off) and migration management (migration docs).
• Encourage team for new ideas for process improvement. Automated several manual process which improved support quality and accuracy.
• Core Application Support:
• Common support issues include:
• Time and Labor: Issues regarding Time entry and approval
• Document Nightly Batch Jobs on daily basis called Check-outs. Created an automated process using sqrs and shell scripts.
• Learning and Development: Issues regarding Course request and approval work flows
• Base Benefits: Issues regarding Employees Benefits changes
• Worked as a primary on call, dealing with production failures (Batch Process failures, rollback errors, script failures, etc) and its resolution. Troubleshooting support issues dealing with Application Engine, Component Interface, PeopleCode, SQR, Unix scripts, workflow
• Created custom SQL updates to the database with DBA for issues that can’t be modified through application.