Ps Techno-functional Consultant, Upgrade Issues Lead Resume
Dallas, TX
PROFILE SUMMARY:
- Around 8 yrs of IT experience with an emphasis in PeopleSoft Implementation/Upgrade /Maintenance/Support.
- Currently working on PeopleSoft upgrade (HCM 8.8 to 9.1, PeopleTools ).
- 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.
- Excellent functional knowledge and experience in the areas of PeopleSoft HCM Core HR, Base Benefits, Benefits Administration and NA Payroll.
- 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.
SKILL:
ERP: PeopleSoft HCM 8.x,8.8, 9.1 (Core HR, Base Benefit, Benefits Administration and NA Payroll), (Position Management) Trained 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.5), Application DesignerApplication Engine, Process Scheduler, Data Mover, WorkflowTree Manager, Change Assistant
PeopleSoft Reporting: SQR, Crystal Reports, PS/Query
Integration Tools: File Layout, 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, Toadbeyond compare, Cisco VPN, Core FTP, Crimson EditorOracle Enterprise Manager
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
PS Techno-Functional Consultant, Upgrade Issues Lead
Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, Base Benefits, Benefits Administration and NA Payroll)
Responsibilities:
- Project time/effort estimation and tracking. Reporting to program manager/steering committee
- Single first 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 with and support 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
- 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:
- 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, de-duplicate 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 custom scripts to correct data (customize data)
- Coordinate with load testing team to replicate some transactions in new environment for performance check
- 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: Handled go live deployment
- Performed and validated conversions
- Worked on change assistant for building environments
PeopleSoft HCM Support
Confidential, Dallas, TX
Environment: PeopleSoft HCM 8.8 (Core HR, Base Benefits, Benefits Administration and NA Payroll)
Responsibilities:
- 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.
- 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
- Created 401k and pension vendor interfaces (Inbound and outbound)
- Written interfaces as there was change in vendors. 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 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.
- Created new projects/activities
- Written new (sqr/PS-Query) reports/queries
Confidential, Birmingham, AL
Senior Software Engineer
Environment: PeopleSoft F/SCM 6.0, 9.0 (AP, AR,GL)
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
Senior Software Engineer, Technical Support Lead
Environment: PeopleSoft HCM 8.8 (Core HR, Base Benefits, Time and Labor, Learning and Development)
Responsibilities:
- 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.
- 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.
- 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.