Resume Usha Katyal Profile Experience Summary

• Confidential is a Senior hands-on Oracle/Peoplesoft HCM/Payroll Functional Consultant/ Project Manager/Test leader/advisor/solution architect and has over thirty years of experience in Information Technology Management with a strong background in implementation of large systems, including experience in Project Planning, Requirements Definition, Business Process Re-engineering, Application Design Assessments, Test Planning, System Post implementation Audits and Reviews, Systems Integration Testing, Acceptance Testing, Parallel Testing, Data Conversion, Process Documentation and End User Training. Her twenty two years of experience in systems design, development, conversion, testing and HRMS implementation of large-scale client-server and mainframe projects when combined with expertise in management consulting gives her a unique ability to engineer and deliver solutions on time and within budget. Multiple project implementation experiences have provided her an in-depth knowledge of appropriate methodologies and professional practices. Packaged software implementation projects include PeopleSoft HRMS/Financials 16 yrs. Commitment Accounting/Encumbrances , Dun Bradstreet HRMS and Financials software including various interfaces. She has successfully led teams of up to 50 people for projects with budgets ranging from 5-20M.
• Confidential is both an educator and trainer and has conducted several training sessions for end user and system personnel to teach the processing and reporting of PeopleSoft HRMS Software at various US and Canadian organizations public and private sector including higher education institutes. Her other training sessions involved her in conducting sessions in the area of Systems Testing, Integration Testing , Parallel Testing and Users Acceptance Testing and training. Ms. Katyal is a Subject Matter Expert SME in both US and Canadian Federal and States/Provincial Rules for taxation including province of Quebec.
• Confidential has extensive ERP expertise and experience summarised as follows:
• Project Management of large ERP projects and custom developed systems implementation HRMS, Benefits, Payroll ,Interfaces, FINANCIALS and other administrative systems in the Financial, Telecommunications, Insurance, Education, Transportation, Medical, Human Resources, Construction, Mining, Power/Energy, Oil and Gas and Public Sectors
• Enjoy Client's Relationships and demonstrate subject matter expertise in the planning, design, execution, delivery and support of ERP implementations and upgrades
• Expertise in leading JAD and business process improvement initiatives
• Oversight and management of Consulting and customer project teams
• Independently develop sound business plans and proposals
• Exercise strong technical and professional judgement over a wide range of consulting engagements including mergers and acquisitions.
• Expert knowledge of ERP applications including Oracle and PeopleSoft HRMS, Financials and e-Business Suites
• Managed business process subject matter expertise in multiple industries
• Ability to successfully manage and plan across multiple clients and engagements
• Ability to lead and deliver effective formal and informal presentations to client and project teams
• Demonstrate expert functional and technical competency in PeopleSoft and Oracle ERP systems implementations and upgrades
• Managed the evaluation and development of solutions for technical problems
• Served as Quality assurance, test planner and technical oversight reviewer on various ERP implementations in both USA and Canadian fortune 100 company's ERP implementations
• Excellent hands on experience with HP Quality Centre Test Director , Load Runner and WinRunner.
• Bring new perspective or tools to create resolution for clients most troubling or complex issues
• ERP Software Package Selection, Evaluation and Implementation
• Excellent understanding of HR, Financial business processes and systems
• In-depth knowledge of business processes in area of Finance/HRMS and understanding of integration with other business processes and systems interfaces
• Proven expertise in providing guidance and direction on defined business procedures, and assist in the development, refinement and documentation of business processes.
• Expertise in Business Area Analysis, Business process mapping/ reviews and fit-gap analysis, post implementation review and recommending effective process-re-engineering
• Excellent experience in developing test strategies, test planning and execution,Business Process Reengineering and Work Flow analysis using best practices in the industry
• Superior Analytical, Problem Solving, Communication, change management and Presentation Skills
• Ability to effectively communicate with User and Technical community. Well developed verbal and written communication skills, including strong documentation skills
• Excellent customer service and interpersonal skills with a demonstrated ability to work effectively in a team environment
• Result oriented with ability to work under pressure and manage priorities
• Excellent experience in working with all levels of the organization including senior executives and key users
• Developing testing plans, scenarios and scripts and performing functional acceptance testing for system, Conversion, enhancements, modifications and upgrades
• Excellent experience in developing and executing project plans, project charters, budgets, resource plans, quality assurance processes reconciliations. audits and reporting to ensure data integrity and completeness
• Development of training materials and deliver training to user community and other team members
• Development of communication plans for the user community
• Well balanced knowledge of financial, human resources, IT disciplines and PC software

Confidential

Peoplesoft Solution Architect/SR. Business Analyst/Lead BA- HR/ Benefits/Payroll Functional Consultant/ Advisor/SME Canadian Payroll

PS HCM 9.1 Stablization Project-Current Project

• Responsible for performing a complete functional requirement/Fit/Gap analysis of GMU's collective bargaining contract changes
• Performed configuration of HR/ Effected Benefits Programs/Plans and Payroll processes including testing to implement these changes within tight time lines
• Currently analyzing the current HR/Benefits/Time and Labor/Payroll process problems and presenting the best practices to the senior management for optimum solutions to stabilize the Peoplesoft 9.1 implementation project.
• Responsible for analyzing the Module Integration problems between HRMS, Finance, Expenses and EPM/budget modules and presenting the management the solution using best practices of Peoplesoft in the industry. The integration includes the Application messaging between HR, Finance and EPM.
• Created several scope and Functional Specification documents for providing solution in HR, Benefits including several vacation Plans,benefit deductions, PTO, Payroll changes to implement Collective bargaining for Faculty Term employees.
• Responsible for testing the Faculty Work Load/Annual Reporting components of
• e-Performance module.
• Responsible for training the functional analysts in the area of HR/benefits and payroll including knowledge transfer.
• Responsible for developing functional requirements the Template based Hire with custom
• work Flow using Oracle AWE and Delegation for Term facility Hires and Rehires.

SR. Business Analyst-ERP HR/ Payroll Functional Consultant/ Advisor/SME Canadian Payroll-

Confidential

• Responsible for performing a complete requirement analysis of current HR, Health and Safety, Training, Benefits, Payroll, Time and Labor and Absence Management business functions.
• Responsible for interviewing business owners and SME's and developed process flows of their current processes using Visio charts.
• Conducted several JAD sessions in the area of HR/Payroll/benefits/Time and Attendance/Absence management and health and safety and training and developed several process maps using Visio.
• Developed a Request for Proposal to find a suitable software solution to replace the companies' current HR, Health and Safety, Training ,Benefits, Payroll and Time and Labor/ Absence Management systems.
• Evaluated ERP software including Ceridian, ADP, SuccessFactors and Peoplesoft 9.1 HCM/Payroll products for potential solution for clients current systems.

SR. Peoplesoft HR/Benefits/Payroll Functional Consultant/ Advisor/SME Canadian Payroll-

Confidential

• Responsible for performing a Fit/Gap and requirements analysis of current Canadian HR, Benefits and Payroll functions with PeopleSoft HR, Payroll and benefits for a new implementation and conversion from Ceridian to Peoplesoft Canadian Payroll/Benefits.
• Responsible for complete configuration of Canadian HR, Payroll and Benefit Tables, including earnings, deductions, Deduction tax classifications, tax effects, Canadian Pension Plans, saving plans, complete tax table set up and Vacations plans leave accrual/PTO plans .
• Responsible for configuration of Canadian Benefit plans for each province due to different legislations and Record of Employment set up requirements.
• Designed and configured different vacation plans, sick leave and Absent management including leave accruals using different benefit plans
• Responsible for providing information on Canadian tax laws including Canada Pension Plan, Employment Insurance and Registered Pension plans and Years end slips including federal tax reporting T4's, T4A's, RL-1 and RL-2's
• Responsible for performing functional testing of Payroll and benefits and problem solving specially in the area of Canadian taxation involving Canadian Revenue Agency involving all the provinces including Quebec related taxation for earnings, deductions and benefit related deductions.
• Documented the complete Payroll and Benefit set up and processing instructions and the
• to-be processes to run Canadian Payroll for the client

Project Manager/ Advisor to the Vice President of Talent Management, Organizational

Confidential

• Responsible for developing the program charter, scope and approach for the Total Rewards Program implementation using PeopleSoft HRMS software which included career development/Job Evaluation, compensation/salary structures, benefits administration including Flex benefits and terms and conditions of employment.
• Presented the current situation, issues with the development of the Total Reward Program and strategies and alternatives using industry best practices for implementing the program using PeopleSoft to Senior management SVP's, VP's from all regions .
• Interviewed several program leads and developed the process documentations and Visio charts for all the new HR/benefits processes being developed and changed.
• Attended various Sr. Management meetings and status reports.
• Provided advice and counseling to the Vice President of Talent Management and Total rewards program regarding the issues and their resolutions.

SR. Peoplesoft HRMS Functional Consultant/ Implementation Partner/Advisor/SME NA-

Confidential

• Responsible for performing a Fit/Gap analysis of current Canadian payroll functions with PeopleSoft Canadian Payroll and benefits for a new implementation and conversion from ADP to Peoplesoft Canadian Payroll/Benefits.
• Responsible for complete configuration of Canadian Payroll Tables, including earnings, deductions, Deduction tax classifications, tax effects, Retro Pay, Canadian Pension Plans, saving plans, Vacation Plans, complete tax table set up.
• Responsible for configuration of Canadian Garnishment set up, test scripts development to test Canadian Payroll and benefits, and Record of Employment set up requirements.
• Responsible for Canadian Year End Tax Form Definition set up tables for T4's, T4A's, RL-1 and RL-2's
• Responsible for providing expertise in test planning including Unit testing, Parallel Testing and problem solving specially in the area of Canadian taxation involving Canadian Revenue Agency involving all the provinces including Quebec related taxation for earnings, deductions and benefit related deductions.
• Documented the Canadian Garnishment set up and processing instructions and the to-be processes to run Canadian Payroll for the client

Sr. Program Control Manager/Functional Consultant/ Advisor to the Vice President of Special

Confidential

• Responsible for developing the project charter, scope and approach for the Oracle HRMS/Time and labor implementation project.
• Provided guidance and assistance to the implementation and client project manager to develop the detailed a road map including detailed project plan, including time lines, resource requirements, interfaces and budget for the entire project
• Provided advice and counseling to the Program Manager regarding the project planning and scope, risk factors and resource issues related to the Oracle HRMS/Payroll project
• Developed several templates to document As Is and To Be process documentation to capture the all ATCO group of company's HRMS processes.
• Conducted several demos to educate the project team in process mapping
• Developed complete Oracle HRMS/Payroll test strategy for the entire project seven companies including Unit, Systems,, Systems Integration, Parallel/Simulated production and User Acceptance Testing
• Developed change management plan with the implementation plan of Oracle HRMS/Financials

SR. Peoplesoft HRMS Functional Consultant/ Advisor

Confidential

• Responsible for performing the current Canadian HRMS implementation review and identify opportunities for improvements and implementation of several delivered features of various HR, benefits and Payroll modules i.e Canadian Provincial Holiday schedules, Retro Pay processing, Leave accrual and management paid and unpaid time-off , GST calculation for incorporated contractors in time and labor module, Billing contractors time to vendors in all provinces as there are different provincial taxes in different provinces specially in Quebec ,WCB, Record of Employment Web submission to HRDC, Final Check processing etc. etc.
• Performed requirement analysis, configurations and implementation of Leave Accrual and absence management for Allegis Group .Canada. Tasks include setting up of various leave plans using base benefit module as per company policies vacations, personal time off and celebration time off
• Analyzed several Payroll problems and resolved them within a given time frame
• Responsible for developing several requests for work for stream lining the existing Canadian Payroll manual processes so Peoplesoft delivered processes can be used. The processes involved were RetroPay, Final Pay check processing, Paid Time-off, Holiday Schedules, Goods and Services tax, Provincial sales Tax,,Time Entry, Record of Employment, RRSP and use of special accumulators etc. etc.
• Responsible for complete conversion/implementation of a newly acquired companies by Allegis Group in Peoplesoft from ADP and Great Plains platforms complete configuration including HR, benefit deductions , taxation and Payroll, testing and implementation including General Ledger and Time and Labor interfaces specially the general ledger interface was significantly changed due to Peoplesoft 89 table changes. Some of the newly acquired companies involved Quebec employees different taxation rules .
• Responsible for reviewing the GAPS and requirements for Peoplesoft HRMS upgrade from release 8 to release 8.9.
• Responsible for developing a complete Functional test plan including the level of effort, resources and time frame for Canadian HRMS, Benefits and Payroll modules using the Test Director
• Developed various test cases for HRMS including Talent Management and Payroll modules including the leave Accrual module using a testing tool test Director .
• Performed complete functional testing and identified the defects which were documented in the Test Director for Peoplesoft upgrade to 8.9 version.
• Tested the fixed defects and provided recommendations to the developers about the Peoplesoft 89 changes
• Provided recommendations on an ongoing basis on Payroll and Benefits issues to the Sr. management of Allegis Group.

HRMS/Benefits/Payroll Functional Lead-NA Payroll-Peoplesoft 8.9-TacWorldwide Boston MA- Confidential

• Performed requirement analysis and fit/gap analysis of HR, Base Benefits, US and Canadian Payroll and Employee self service modules for Peoplesoft 8.9 HRMS/Benefits /Payroll/Time and Labor, employee self service modules implementation for a very large staffing company.
• Conducted several sessions to present Peoplesoft best practices to implement HRMS/Benefits/Payroll to various User departments
• Performed requirement analysis to set up benefits for employees, contractors and executives
• Benefits plans included, medical dental, life insurance, disability, pension, vacation accrual and management sick, vacations, personal time off etc.
• Configured complete HR, Base Benefit and Payroll modules and the Financial interface as per the requirements
• Developed a complete testing plan with resource estimates to perform unit, system integration, UAT testing, risk factors for HR/benefits/time and labor and Payroll for budget estimates

Peoplesoft HR/Base benefits/Canadian Benefits and Payroll Functional Specialist-National

Confidential

• Performed requirement analysis and fit/gap analysis of HR and base benefit modules for Peoplesoft 8.8 HRMS/Payroll implementation for the Canadian Subsidiary of National Starch and Chemicals.
• Developed a complete project implementation plan
• Configured complete HR and Base Benefit and payroll modules as per the requirements
• Reviewed/Configured Payroll tax tables including earnings, deductions, taxation of deductions both provincial and federal, special accumulators for Canadian Payroll
• Reviewed entire suite of HRMS/Payroll configurations and provided recommendations
• Developed test strategy, test plan, scripts for the complete project
• Performed functional testing of HR/Base Benefit modules along with Payroll

Confidential

Sr. Peoplesoft HRMS/Payroll Functional Consultant/Advisor-Peoplesoft 8.8-Canadian Payroll

• Developed a detailed questionnaire for Canadian Operations for H R Block Canada to develop detailed requirement for Peoplesoft HRMS/Benefits/Payroll/Time and Labor implementations
• Interviewed several Sr. personal from HR, Payroll and Benefits including technical analysts to develop the detailed requirement document
• Developed a detailed requirement document for Peoplesoft HRMS, Time and Labor, Benefits and Payroll implementation
• Develop scope, approach and, high level implementation and resource plan for implementation of Peoplesoft HRMS/T L/Payroll release 8.8.

Sr. Peoplesoft HRMS/ Position

Confidential

• Responsible for Go Live production functional support in Peoplesoft 8.3 Time and Labor and Payroll upgrade
• Responsible for complete Payroll processing of boards various payrolls teachers, Subteachers, Contracts etc. including Payroll remittances to various government agencies federal, provincials etc.
• Responsible for reviewing all the HR, Benefits, T L and Payroll foundation tables to find out the configuration problems and set up/corrected/tested the codes in compliance with the statutory, legislative and taxation requirements
• Responsible for troubleshooting Payroll issues and identified problems within the Time and Labor module
• Worked with the end users and technical developers to define systems requirements and specifications for HRMS, T L and Payroll modules for enhancements to the systems as well strategies to clean up production data
• Prepared and executed a complete test plan to test enhancements to the Time and Labor module and payroll
• Responsible for developing biweekly and monthly payroll processing cycles. Responsible for managing, executing, and monitoring the Payroll process production cycles and schedules for Bi-weekly, and Monthly production processing.
• Responsible for balancing each Payroll cycle as well as maintained records for year end adjustments
• Responsible for validating Payroll data sent from Peoplesoft Payroll to Chartered Banks and other external interfacing institutions as well the Financial Interface. Catholic Schools uses Commitment /Encumbrance Accounting
• Responsible for analyzing Time and Labor and Payroll processing problems on a day to day operations of the School district.
• Worked with Technical team to discuss the design and enhancements to Time and labor and Payroll to accommodate board's specific needs including multiple jobs and assignments
• Supervised the payroll work unit utilizing the Peoplesoft HRMS, Time and Labor, Benefits and Payroll module
• Responsible for reviewing employee record adjustments, Year End Table set up/Corrections, Audit Year end Personal Data, tax Form Definition and Tax Foot Note definition tables
• Responsible for reviewing of T4',T4A's , responding to Revenue Canada Inquiries and correcting T4's information
• Ensured the accurate and timely processing of year end activities and Record of Employment etc.
• Developed several HR/ Payroll queries using PS query to find out data problems prior to running Calc, Confirm and Financial interface
• Prepared recommendations for process improvements in the area of HRMS Position Management, Applicant Tracking, multi-jobs processing , Absence Monitoring, Time and Labor rule processing and Payroll processes using Peoplesoft best practices including change management.
• Prepared a training plan in Peoplesoft Time and Labor and Payroll module and provided training to users and technical analysts on usage of Peoplesoft Time and Labor and Payroll module.

Confidential

• Completed an assessment on work performed todate of Peoplesoft 8.8 HRMS/T L/Payroll implementation for Telus Inc's Client in Vancouver B.C.
• Developed approach, methodology, best alternatives using industry practices along with an Implementation plan to Implement Peoplesoft 8.8.The modules being implemented were HRMS, Benefits, Time Labor, Payroll, Health safety, Training eRecruit along with Financial interfaces.
• Provided recommendations to the Sr, Management of Telus the method and approach to be used to implement the project.

Confidential

Senior Functional Consultant/Advisor-Peoplesoft Canadian Payroll

Responsible for Year End preparation, Tax Upgrades and Year End processing and Testing.

Other responsibilities included:

• Adjustment of Employee Records, Review Table Set-Up/Corrections, Audit Year End Personal Data, Tax Form Definition and Tax Footnote definition tables
• Produce Year-End earnings and Tax Reports
• Problem Assessment and providing solutions
• Printing Year-End slips T4's,T4A's Releve1 and 2 ,Reports and Magnetic Media Reporting
• Payroll and Benefit related problem solving
• Loading and review of next year data to ensure all tables are set-up correctly for 2003 processing
• Re-engineered and documented year end procedures

DTE Energy Detroit MI- Release 8.3 Implementation Project-Test Team Leader -Position Control, eRecruit, HR, Time Labor,eBenefits, Payroll, Pension, Financials-Re-Implementation of HRMS/Financial Interfaces of Two Company Merger from Peoplesoft 7.02-8.3 Version-Unionized Environment Merger-Acquisition

• Responsible for leading a project team of 50 team members consultants Employees to perform system, integration, end-to-end, simulated production Parallel test, security test, Performance Test and Stress Test of Peoplesoft HRMS, Benefits e-benefits , Time Labor, Employee self service, work flow, Payroll e-Pay , Pension, Kronos WFM, and all Financial Interfaces including Peoplesoft Financials and JDE Financials. Due to company merger, multiple Business Units/Setid's were added along with new Department Tree and security tree.
• Developed and executed an overall system test strategy, test plan for the two company merger
• Responsible for test strategy planning, test architecture, conversion planning, test script development, test case development /execution and team management of the project in all phases of testing.
• Responsible for developing the test strategy of all interfaces 50 including Two different Financial Systems, the customizations done in the e-Recruit,e-Pay, and e-benefits, due to the changes in PS release 8.3 web Based .
• Developed test inventory, test script development standards and conducted several training sessions for both end users, functional and technical users to develop system test scenarios, test cases/conditions and test scripts. Assisted the training group to develop various training materials and training database for class room training HR, benefits, Payroll, eRecruit, employee self service, workflow and Pension modules
• Conducted various test script/test case, test inventory development workshops for the entire project team i.e users and test analysts and coached the team to perform various tests during all phases of testing
• Managed the development and execution of all the test scripts and test scenarios for the entire HRMS, Payroll, Time labor, Pensions and Financials including 50 interfaces to external and internal systems
• Provided leadership on planning, execution of Performance Testing for PeopleSoft HCM including two company merger.
• Responsible for collaboration with project teams to pinpoint areas for performance improvement and retesting of performance improvements and measuring performance changes.
• Used Loadrunner/Clear Quest products to perform complex, large scale load testing and regression testing against the Peoplesoft HRMS/Financials product suite.
• Developed reporting and tracking of problems mechanism using Rational Suite of test products
• Provided reproducible test cases and work with other team members to close the problem reports
• Drove the test process to identify architecture bottlenecks following load test cycles by generating high quality metrics
• Conducted Peoplesoft HRMS/Financials manual testing as needed
• Other responsibilities included:
• Schedule testing in coordination with construction timelines
• Create and monitor test work plan and short interval schedules as needed
• Resolve and/or present issues to program management
• Participated in project initiation, design,development and peer review meetings of HR, Benefits,Time and Labor, Payroll and Pensions including Financial interfaces in an effort to ensure quality of all modules/customizations/Interfaces to be tested and integrated.
• Establish test strategy and assessments
• Define test problem report TPR control procedures
• Define test team roles and responsibilities
• Review system function processing
• Review test objectives for each function
• Review test environment
• Manage the preparation of System Integration test plans
• Review test plans and execution results for reasonableness with functions being tested
• Ensure that interfaces and conversions are incorporated into system test
• Review Test Problem Reports TPRs and System Change Requests SCRs
• Develop quality assurance standards and guidelines
• Coordinate with technical and other support teams
• Provide necessary status updates to program management
• Manage/monitor overall system resources to help control project costs
• Responsible for planning, development and testing the Conversion and validation Reports for the PS 8.3 e-benefits/Payroll and Pension conversion
• Responsible for design and development of baseline queries to test the simulation Production Test for HR, Benefits/Payroll, Pension and Financial data. Queries development included before and after conversion reports of PS 7.02 data to PS 8.3
• Responsible for analyzing systems and Payroll data problems during the entire duration of integration and simulated production testing of the HR, e-benefits,Time Labor and Payroll e-Pay and Pension modules
• Responsible for attending various functional and technical issues meetings regarding the implementation and participating in trouble shooting the HR/Benefits/Payroll/Pension/Financial interfaces problems
• Responsible for providing weekly status reports to the Project Steering Committee documenting the progress and issues related to the project
• Evaluated Rational suite of testing tools to be used in the testing process. Clear Quest, MercuryLoadrunner and SQA Robot were evaluated and used.
• Conformed Clear Quest tool to perform defect tracking during all phases of testing
• Developed defect tracking procedures and utilized them during all phases of testing
• Managed the priorotization of system defects resolution and the prioritization of testing activities to prepare the system for production readiness
• Peoplesoft version 8.3 was implemented as per schedule on November 1, 2002.

Confidential-PeopleSoft Release 8.12 Upgrade Project- Test Team Lead Integration/Production Simulation Testing-Position Control, HR, Time Labor, Benefits and Payroll-Upgrading of HRMS and NA Payroll to release 8.12 for state of Massachusetts 95,000 Employees including Boston Educational Institutions-Unionized Environment

• Responsible for leading and managing an upgrade team of 30 team members Consultants Employees to perform integration, system,,performance,simulated production test, , parallel test and , user Acceptance test of Peoplesoft HRMS, Benefits e-benefits , Time Labor and Payroll e-Pay and Financial interfaces.
• Developed and executed an overall system test plan for entire HRMS suite including the external and internal Financial interfaces. All schools under state of MA used Commitment/Encumbrance accounting using Financial interface.
• Provided leadership on planning, execution of Performance Testing for PeopleSoft HCM .
• Responsible for collaboration with project teams to pinpoint areas for performance improvement and retesting of performance improvements and measuring performance changes.
• Documented several performance issues with the newly implemented Time and labor Module and resolved them with vendor technical resources since Peoplesoft time and labour was very new.
• Managed the development and execution of test scripts, test conditions and test scenarios
• Responsible for test strategy planning, conversion planning test script development, test case execution and team management of the upgrade project.
• Responsible for advising the test of all interfaces including financial systems Peoplesoft , the customizations done in the e-Pay, e-benefits, Time Labor due to the changes in PS release 8.12 web Based .
• Responsible for coordination and testing of all the JobAids Peoplesoft Training/Business Procedures to provide web based training to the End Users for the new business procedures and changes due to PS 8.12 changes and customizations.
• Responsible for planning , development and testing the Payroll validation Reports for the PS 8.12 e-Pay conversion
• Responsible for design and development of baseline queries to test the simulation Production Test for HR/Time Labor/Benefits/Vacation accrual and management/Payroll/ Financial data. Query development included before and after conversion reports of PS 7.5 data to PS 8.12.
• Responsible for analyzing systems and Payroll data problems during the entire duration of integration and simulated production testing of the HR, e-benefits,Time Labor and Payroll e-Pay modules including the Year End W2's production and federal reporting.
• Responsible for attending various functional and technical issues meetings regarding the upgrade and participating in trouble shooting the Payroll and Benefits related problems
• Responsible for providing weekly status reports to the Project Steering Committee documenting the progress and issues related to the upgrade project

Confidential-PeopleSoft HRMS Payroll release 7.5-Senior PeopleSoft Change Management Business Consultant/Project Facilitator-Conversion of HRMS and Payroll release 7.5 for a Fortune 100 Corporation

• Responsible for management of the work of the PeopleSoft Change Leadership Team
• Responsible for providing assistance to the Director of HR and Benefit Administration client Project Manager in all aspect of the Project implementation design, development, testing, communication and implementation issues and change management
• Assisted the HR/Benefits/Payroll team and HRMS end users in development of new business forms to gather data for the new HRMS and Payroll system
• Re-engineered MckessonHBOC existing HRMS processes and developed new business processes to use best practices of PeopleSoft
• Reviewed the business and functional specifications and assisted the technical PeopleSoft consultants in setting up and finalizing the leave accrual plans design for McKessonHBOC. Extended Health Care employees including Union Employees using PeopleSoft delivered functionality
• Responsible for testing, validating data i.e. PeopleSoft HRMS tables, Workflows, department and security tree, interfaces and reports during the HRMS conversion process. Helped end users to use PeopleSoft query tool to perform data validation and special reporting requirements
• Responsible for providing assistance in developing HRMS Parallel Testing Plan strategy and developed Parallel Testing Procedures/Communications for the PeopleSoft Project Team
• Analyzed systems and Payroll data problems and provided solutions during Parallel Testing
• Performed business process mapping for PeopleSoft HRMS workflow including the HR and Payroll self service work flows using Visio Business Process diagramming tool
• Developed and coordinated the overall communication Plan for the PeopleSoft Project Implementation by interfacing with all levels of MckessonHBOC 's HRMS clients
• Developed a Web based communication program called Communicating The Human Resource Business Process Changes for all the districts using a tool called Brainshark.The program included the 'best practices methodologies to ensure that MckessonHBOC districts are aware of the administrative information system impact to their business
• Developed several presentations to provide knowledge transfer for the end users in specific usage of PeopleSoft HR, Benefits and Payroll software and its capabilities
• Defined and communicated the new changes and their effect on employees Paychecks so the employees understand what to expect before PeopleSoft HRMS/Payroll and other administrative systems changes were deployed
• Documented the HR Desk Reference manual for PeopleSoft users

Confidential-PeopleSoft HRMS/Financials Payroll 7.02 Senior Functional Consultant/Lead/SME- Conversion of Canadian HRMS and Payroll release 7.02 for a large Human Resource Company- 65,000 employees

• Responsible for configuration, test planning and execution of OASIS Financial system which is a Peoplesoft Financial AP, GL, expenses, billing system. Testing included testing changes involved included multi-currency aspect, provincial Sales tax, Goods Services Tax etc.
• Responsible for compiling Human Resources, Benefits and Payroll requirements for the Canadian subsidiary of Aerotek Inc.
• Developed a detailed questionnaire for compiling the Canadian Payroll conversion for Aerotek Inc.
• Interviewed the HR/Benefits/Payroll team and end user management and developed the requirement document for HR, Benefit and Payroll conversion for Canadian Offices.
• Responsible for compiling the detailed requirements from the benefit providers to set up the benefit plans, tables, eligibility rules, enrollment options for internal, contract employees and Sole Proprietors
• Completed Fit/Gap analysis for Aerotek's HR/Benefits/Payroll requirements with the delivered PeopleSoft functionality and customized version of PeopleSoft at Aerotek Inc.
• Set up benefit programs, plans and configured all related HR tables Company/Business Units/Department and Security Tree etc. in PeopleSoft and tested the benefit plans as per policies and procedures of the Canadian Benefit providers for Aerotek, Inc.
• Set up all HR/Payroll tables and populated them with as per the organization rules
• Responsible for design and set up of Leave Accrual process using PeopleSoft delivered functionality for both Internal and external employees as per the legislation requirements along with Canadian Aerotek's policies and procedures.
• Developed Human Resource policies and procedures for maternity benefits provided to Aerotek's employees
• Developed interface requirements to send employee Registered Retirement Saving plan RRSP deductions from Payroll to different financial organizations.
• Identified customization requirements to handle expense payments using PeopleSoft Payroll
• Designed customized panels to handle Canadian Goods Services Tax payments for Sole Proprietors invoices to be paid via Payroll. This included an interface by capturing GST payment amount from Sole Proprietor's invoices from client's PeopleSoft Financials system to Payroll.
• Set up all deductions for all the benefit programs including the general deductions along with their taxation classifications as per the Canadian legislation requirements and Aerotek's policies and procedures
• Provided assistance to the technical writer to document all related desk top procedures to set up benefits programs including, enrollment of employees, changing benefit status and termination of benefit procedures and all taxation rules for the Canadian offices.
• Conducted training sessions to provide knowledge transfer for the client in specific usage of PeopleSoft HR, Benefits and Payroll software and its capabilities.
• Analyzed the Record of Employment interface requirements from PeopleSoft Payroll to Human Resource Canada software for laser printing of the ROE.
• Developed a comprehensive functional/systems test plan to test the HR/Benefits/Payroll modules along with the interfaces. Executed functional test, including all customizations.
• Provided assistance in development of data conversion strategies from ADP to PeopleSoft HRMS.

Confidential-PeopleSoft HRSA Payroll release 7.5- Project Manager- Lead Requirements Analysis and Fit/gap Analysis of HRSA and Payroll release 7.5 for an Educational Institution

• Responsible for conducting the requirements analysis and Fit/Gap analysis of the Human Resources including the Student Administration, Benefits, Time and Labor and Payroll modules for the College of The Holy Cross.
• Planned and conducted various design sessions to gather requirements of the college's Human Resources, Student Administration, Benefits, Time and Labor, Payroll and Financial interfaces. Holy Cross College used Commitment accounting.
• Created Fit/Gap templates for the project team and performed a high level fit/gap analysis between the college's business requirements and PeopleSoft delivered functionality for HR/benefits/Time Labor and payroll modules.
• Managed the PeopleSoft Project Team including the business analysts, technical resources.
• Performed detailed Fit/Gap analysis between Holy Cross-Ss HRSA Human Resources and Student Administration requirements and PeopleSoft delivered functionality.
• Identified the customization required to satisfy college's HRSA requirements.
• Developed a detailed project plan including resource requirements and feasibility of implementing HRSA including Time and Labor , Kronos, and Payroll modules.
• Managed the project team within budget guidelines
• Approved project team's time sheets and expense reports
• Attended regularly scheduled project steering committee meetings
• Confidential-PeopleSoft HRMS Payroll 7.01- Canadian Payroll Project Coordinator/Testing Lead- Lead System Testing, Acceptance testing and conversion of HRMS and Payroll release 7.01 for a large insurance company- 90,000 employees
• Completed testing of PeopleSoft release 7.01 Application Upgrade Testing including the client's modifications to the PeopleSoft HRMS, Customized Time Labor and Payroll.
• Prepared the System Test Plan including the test strategy, test plan for testing the modifications and interfaces from and to PeopleSoft 7.01 HRMS Payroll and Finanicial system.
• Validated and reviewed the modifications specifications for all the redesign of a large Payroll including the Canadian Payroll systems for the client.
• Tested PeopleSoft HR, Benefits/Admin and Payroll with special emphasis to Canadian Payroll assisting in debugging the data conversion problems using SQA Robot..
• Created HR, Benefits/Admin and Payroll test scenarios/scripts and test data for Client's interfaces from PeopleSoft to other systems including PeopleSoft GL.
• Reviewed all procedures including PeopleSoft procedures to run the Canadian Payroll.
• Responsible for executing the System Test, Defect Logging and assisting the technical analysts to resolve the defects during the systems testing and integration phases of HR, Benefits/Administration, Payroll and Financial interfaces.
• Conducted training sessions to provide knowledge transfer for the client in specific usage of PeopleSoft HR, Benefit Admin. and Payroll modules and its capabilities including PS Query.
• Attended on-line presentations delivered by PeopleSoft on PeopleSoft release 8.0 changes
• Bloomberg Financial Commodities-New York-PeopleSoft HRMS Payroll 7.0
• Lead Unit, System, Acceptance testing and conversion of HRMS and Payroll release 7.0 for financial services firm 10,000 employees
• Prepared the SystemTest Strategy, test Plan including the test plan for testing the ADP interface from PeopleSoft 7.0.
• Validated functional specifications for monthly, quarterly and periodic files for ADP interface.
• Assisted the technical analyst in ADP interface development.
• Tested PeopleSoft HR, Benefits and Payroll and assisted in debugging data conversion problems.
• Created Payroll test scenarios/scripts and creating test data for Bloomberg interfaces from PeopleSoft to other external systems.
• Performed check reconciliation's and report reconciliations with PeopleSoft data files.
• Involved in reconciliation's of Bloomberg's old Payroll system Ceridian Payroll to PeopleSoft produced Payroll for ADP interface.
• Corrected data and format problems from data files sent to ADP.
• Developed and used PS Queries to validate Payroll calculations and results.
• National Film Board of Canada- PeopleSoft HRMS 6.0 5,000 Employees
• Performed functional requirement analysis to evaluate customization requirements to fit PeopleSoft HRMS release 6.0.
• Evaluated clients leave accruals and payouts business processes and developed business rules for fit, including current processes and reports to PeopleSoft HRMS version 6.0.
• Prepared complete functional requirements and technical design documents and wrote SQR specifications to customize the leave processing function
• Identified client's Time Data Entry requirements for regular, temporary and contract employees and prepared functional specifications to fit into PeopleSoft HRMS.
• Participated in identifying client's group benefit plans and statements including the reporting requirements and developed functional and technical specifications for the technical resources.
• London Life Insurance PeopleSoft- Flex Benefits 5.11 9,000 Employees
• Conducted a Needs and Fit Analysis for upgrading PeopleSoft Benefits Administration from 3.2.2 to 5.1.1.
• Evaluated client's benefit programs for fit, including mapping current programs to PeopleSoft Benefits Administration, population of tables and panels and their functionality compared with PeopleSoft 3.2.2, and recommended additional modules for implementation on customized benefit plans.
• Evaluated current database structure and made recommendations.
• Reviewed client's 3.2.2 customizations and identified differences from vanilla 5.1.1. Analyzed alternatives.
• Prepared an Implementation Feasibility Report with resource estimates for implementation of Flex Benefit Module of PeopleSoft for senior management approval.
• Presented the report recommendations to senior management along with the budget and resource estimates for their approval.
• The report and recommendations presented created an opportunity for BIT to implement complete PeopleSoft HRMS project.

Practice Development Activities:

• Developed PeopleSoft package implementation methodology, Business Process Improvement procedures for HRMS for global consulting organization
• Developed proposals to respond to RFPs and interviewed PeopleSoft consultants for placement.
• Developed RFP responses to the Government of Alberta HRMS implementation project involving seventeen ministries.
• Developed RFP responses for the Northern Alberta Institute of Technology for the implementation of the complete suite of PeopleSoft products including HRMS, Financials and Student Administration modules.
• Developed an implementation strategy for the implementation of PeopleSoft HRMS, Financials and Student Administration Package for Northern Alberta Institute of Technology.
• Department of Alberta Education, Education Information Exchange EIE Project Manager- Administration of 57 large School Boards - Approx. 5,500 schools
• Conducted a Business Area Analysis, Business Reengineering and Business System Design study for Student Course Information Project CIS using James Martin's Information Engineering Methodology and case tools ADW .
• Conducted several information gathering sessions to gather information from various stakeholders including schools and schools jurisdictions.
• Conducted various JAD sessions to develop business, process and data models of the Course Information Project. Involved in engineering and reengineering of current business processes to collect, process and report Course and Marks data for all high schools students in a cost effective manner.

Edmonton Telephones Sr. Consultant

• Gathered and documented current and future ED TEL Directory business, technical and interface requirements.
• Reviewed ED TEL's vision, key business drivers and goals in the context of future trends in the industry. Prepared an RFI request for information for directory integrated system software and submitted the RFI to selected vendors specialized in the publishing system software.
• Prepared a business case describing the business reasons for funding the Directory Publishing Project based on the analysis of closeness of fit of a solution to ED TEL's business and technical requirements, implementability risk assessment , viability, and costs and benefits.

Public Sector Dun Bradstreet Financial System-3,500 employees

• Completed a comprehensive evaluation of processing and reporting requirements of all the international offices of Alberta Government.
• Managed the conversion and implementation of Foreign Expense Tracking System as per department's functional requirements on Data General Network.

- Public Sector-Dun Bradstreet Financial System-Project Manager

• Conducted a comprehensive Functional Requirement Study, system design, development, quality assurance and implementation of FIGA's Hedging and Expense Tracking system.
• Prepared a Business, Data and Process Model for the proposed system for Alberta Treasury evaluation and approval.
• Re-engineered all existing manual and automated processes to improve efficiency and effectiveness in data collection, banking procedures, hedging contracts, invoicing, and account reconciliation of all foreign offices of Alberta Government.

- Public Sector-5,500 employees

Dun Bradstreet Financial and HRMS Systems-Project Manager

• Managed and coordinated the System design and technical specification phase of Third Party Decentralization Module of Financial Reporting and Control System FRACS of Alberta Transportation and Utilities using 3D methodology in IDMS environment.
• Conducted a business operation evaluation study for the Transportation Safety and National Safety Code Branch. Prepared a Strategic Plan including a Three year business operational plan specifying application and Information Technology in various areas including expected growth and requirements in each category. Developed a complete Application Portfolio for Motor Transport Services branch.
• Managed and coordinated the development and overall success of DFS/CFS conversion of Financial Reporting and Control System FRACS of Alberta Transportation and Utilities in IDMS environment. Managed and conducted Quality Assurance and Acceptance Testing of Salary, Wage, Private Equipment, Truck Hall, Job Cost, Reporting and Third Party Modules of FRACS.

Confidential-Project Manager-Implemented Dun Bradstreet Human Resource, Payroll and Financial Systems Education Sector 10,000 employees

• Managed and conducted a Functional Requirement Analysis, Vendor Package Search and Evaluation and selection , Cost/Benefit analysis and Implementation Strategy Plan study for the Payroll and Human Resource systems in a timely, secure, and cost-effective manner for Edmonton Public School Board.
• Identified, analyzed, re-engineered and developed various business processes associated with collecting, processing, storing, and reporting teachers and business staff information from schools.
• Conducted various JAD sessions to define the management and infrastructure required to support the new processes in Personnel, Benefits, Staffing, Substitute assignment, Payroll, teachers assignments, student count information collection, Commitment/Encumbrances business areas.
• Developed Data and Process Models of Human resource business areas.
• Prepared a comprehensive RFP for Human Resource Package and Vendor Selection.
• Developed an evaluation model to evaluate various software packages.
• Prepared a complete business case describing the business reasons for funding the payroll and human resource project based on the closeness of a fit solution to EPSB 's business and technical requirements, implementability, viability, costs and benefits and obtained approval from the senior management to fund the project. Managed all activities of the Steering Committee.
• Managed the implementation of MSA General Ledger and Information Expert Packaged Software Dun Bradstreet Software for Edmonton Public School Board.
• Designed, developed complete test strategy, test plan including testing of several interfaces from several Financial Commitment Accounting and administrative systems such as Payroll/Personnel, Purchasing, Work Order, Inventory, Accounts Payable and Receivable to MSA General Ledger.

Public Works, Supply And Services-Public Sector 25,000 employees

• Developed test strategy, test plan and complete test process to perform testing of Government Department billing system.
• Performed acceptance testing, quality assurance and implementation of Department Billing System. Tasks in the assignment included setting of acceptance test criteria, preparation of comprehensive test plans and test data, reviewing of all technical deliverables, user and system management liaison and conducting user training sessions. Department billing system produces invoices and interfaces with several systems including MSA General Ledger and Accounts Receivable. Department Billing system was developed/tested using PWSS computing facilities and SDM methodology.