SUMMARY

• 7 years of working experiences in Analysis, Design, Development, Testing, Implementation and Upgrade of Software as a PeopleSoft Techno - Functional Consultant.
• Participates in all levels of the systems development life cycle (SDLC) of PeopleSoft projects including Gap analysis, Requirements gathering, Development, Interface Design, Configurations, Reporting, Data Conversion, Testing and Troubleshooting and Production support.
• Expertise in PeopleSoft Financial modules with GL, AP, AR, KK, OM, AM, Expenses, Project costing, Purchasing, Billing and Inventory.
• Areas of expertise include HR base modules including Time and Labor, Base Benefits, Benefits Administration, Payroll for North America, Payroll Interface, Recruiting including Talent Acquisition Manager and Candidate Gateway, eRecruit, Self-service, Manager Self-service, ePerformance, Profile Management, Workforce Administration, Security and Training.
• Solid working knowledge of Relational Database Management System.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture and SQL Query Writing.
• Strong documentation and written presentation skills, and developed various functional and technical specs with Test Plans and Procedures.
• Coordinate with business and technology partners to get feedback and sign off’s
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing on software both before and after completion; conducting and documenting UAT.
• Scoping and defining new business opportunities.
• Involves planning the requirements development process, determining which requirements are the highest priority for implementation, and managing change.
• Excellent Team player to work in conjunction with other testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

TECHNICAL SKILLS

Application Modules: PeopleSoft Financials and FSCM 8.8/8.9/9.0/9.1 (GL, AP, AR, Billing, Purchasing, KK, OM, AM, Expenses, Purchasing, Project costing and Inventory Modules) and HRMS Version 8.9/9.1 (Base Benefits, Benefits Administration, Payroll for North America, Payroll Interface, Time and Labor, Recruiting including Talent Acquisition Manager and Candidate Gateway, eRecruit, Self-service, Manager Self-service, ePerformance, Profile Management, Security and Training).

PeopleTools: Application Designer, Tree Manager, Work Flow, Process Scheduler, PeopleCode, Application Engine, Integration Broker, File Layout, Configuration Manager, Component Interfaces, Data Mover and Change Assistant.

Reporting Tools: SQR, Peoplecode, PS Query, Crystal Reports and PS/nVision

Operating Systems: Windows, Unix

Languages: SQL, SQR, PeopleCode, Shell Script, VB

Tools: PeopleTools 8.17, 8.42, 8.48, 8.49, 8.51, 8.52, SQL, SQR, Crystal Reports & Visual Basic, UPK

RDBMS: Oracle, MS SQL Server and MS Access

Web Programming: JSP, HTML, XML, VB Script, Java Script

Application Servers: Web Logic and Tuxedo

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

QA Lead

Responsibilities:

• Worked closely with Business users and HRIS in capturing requirements and creating Functional documents (BRD & FD)
• Utilize Functional expertise to lead fit-gap sessions with primary stakeholders to setup and configure the system
• Create test plans for System and Integration testing, Regression Testing, User Acceptance Testing
• Create and execute various test scripts as per test plans and execute them in different environments for Talent Acquisition Manager (Recruiting, Candidate Gateway), Workforce Administration, Base Benefits, Benefit Administration, Payroll for North America, Performance Management, Compensation modules
• Logging defect in Quality Center, track and update defects for the project
• Develop test plans and test scripts for Staffing projects relate to Associate pre-hire processing, Labor group (union), Time in Title change
• Develop test plans and test scripts for EEO report
• Develop PeopleSoft query to retrieve different tables data, verify and analyze.
• Strong Expertise in documenting the As-Is Process and performing Complete Fit-Gap Analysis
• Expertise in analyzing complex business process of various enterprise and design solutions in PeopleSoft.
• Worked closely with Developers, HRIS and UAT Testers to make sure work is progressing as expected, schedule meeting during the requirements gathering and daily defect call during testing
• Documented all new changes in requirements and maintained up-to-date specifications for developers and testers
• Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance
• Experienced in writing the test plans, cases and scripts based on system specifications and expertise in regression system integration functional and performance testing
• Extensively worked with Security Administrator to implement security in various levels creating Roles Permission Lists, User Profiles, Portal Security, Definition Security, Query Security & Row level security
• Analyzing and developing strategic imperatives for organization / business units using various strategic management methodologies
• Worked with PeopleSoft - HCM (Core HRMS) 9.1, Base benefits, Benefit Administration, vendor Profile, deductions, calculation rules and North American payroll & its interface(s), Manager self-service and employee self-service, e-performance, Global assignments, Career path and Succession planning, ELM (Enterprise learning Management), Absence Management, Configuration Maintenance, PS security, ATS: TAM (Talent acquisition manager) and Taleo and Time and Labor
• Experienced in People Tools (Application Designer, Import Manger, Data Mover, People Code, Security Administrator, Object Security, Maintain Security, SQR, PS/Query and Crystal Reports, Process Scheduler, Application Messaging, Utilities, Application Engine and Upgrade Assistant)
• Experience in designing databases and client-server architectures and expertise in PL/SQL and SQL*Plus. Performance Tuning and PeopleSoft Debugging

Confidential, Sylvania, OH

Techno-Functional Consultant

Responsibilities:

• Responsible for preparing Functional/Technical design specifications, Preparing Data Mappings, developing and testing interfaces in GL, AP, AR, Project costing, Purchasing, Expenses, Billing and Commitment Control modules
• Fit/Gap analysis and configuration on GL, AP, AR, Billing and Expenses
• Understand functionality and integration to create functional designs, test scripts, configuration documents and create and submit final documentation
• Gathered all requirements & created Design Specifications for a full turn around start to finish interface
• Designed & tested Component Interface for 3rd party Purchasing Portal. Interfaced all Invoices, Vendors & GL Accounts within compliance Chart of Account values.
• Processing Journals, Open Item Accounting, Financial Consolidations, Entry Events and Journal Entry Approvals etc.
• Set up and configure control tables for GL module
• Integration of General Ledger with Asset Management, Grants, Purchasing and Accounts Payable
• Modified the GL Balancing Crystal Report for Travel and Expenses per user’s new requirements
• Configured application/web/process scheduler
• Configured LDAP authentication and Troubleshooting LDAP authentication performance related issue
• Production system design/capacity planning/platform certification verification
• Installed third party software-Crystal report/MS Office/Cobol compiler/Verity search
• Participated in applying patch/bundle/maintenance files
• Integration broker configuration and troubleshooting
• Writing function specification for customized components and component interface design, using Application designer for Application Interface Design
• Support the technical team to develop Application Engine program to load data into Project costing
• Converted legacy system data into PeopleSoft application via Excel To CI and application engine programs
• Troubleshooting with data loading, developed scripts to automated American Express K1025 wallet transaction download file processing
• Troubleshoot various system support issue such as duplicate invoice issue, check printing process, user session kick out issue
• Developed UPK documentation for user training
• Conduct the workshops with power users and documented business requirements
• Responsible for developing testing procedures to meet business process requirements and solutions
• Handle the tasks of planning testing approaches to solve major business issues
• Conduct the testing followed by the test documentation that created by the lead including function test, UAT, key in transactions and unit test
• Perform responsibilities of developing test case, reviewing and evaluating final test results

Environment: PeopleSoft FINANCIALS 9.1, PeopleTools 8.48, 8.51, 8.52, Oracle 11g

Confidential, Cincinnati, OH

Techno-Functional Consultant

Responsibilities:

• Analyzed the legacy system on Time & Labor/Benefit/Payroll/GL areas, gathered the requirements, reports, processes needed to maintain the routine work for the corporate, compared with PeopleSoft HCM8.9, provided customization analysis and advised necessary changes on the business processes to minimize the amount of customizations
• Designed custom time sheet and scheduler module for Time & Labor to meet the business requirements
• Set up foundation tables for PeopleSoft HRSM Benefit/Payroll modules, wrote test plans and test scripts, designed test data, conducted unit/system/regression/integration/performance tests, verified workflows, approval processes and other processes
• Worked on designing the workflow for position request from department chair and escalation to HR department and having it approved from Budget. The system was designed flexible to add approver ad-hoc to fit in the requestor needs
• Worked on Development of Technical And Functional Spec for Payroll and Time & Labor Processes
• Used Change assistant to execute the upgrade activities
• Participated in applying patch/bundle/maintenance files
• Provided data conversion/migration requirement documents and templates for HR/Financial systems
• Communicated with HR users to clean up the data errors, review SQRs and made use of component interfaces to load the data into PeopleSoft
• Modified the Permission lists, Roles to meet the upgrade system navigation and customization
• Running the reconciliation report for Time & Labor, Benefits, Payroll modules to help client review their data
• Validating the benefit plans and family coverage and dependent information from their HR files and cross-validation with vendors for billing purposes
• Created functional spec for e-performance and manager dashboard and how documents created for period for group 11 and 12 employees and approval process for evaluation through reviewer and HR admin before updating the person profile
• Created functional spec on keeping the person profile and non-person profile in sync using batch process. The job specific, core competency and licensure were automatically updated for employees based on their job profiles
• Help user validate the courses available under each activities and how they are tied to each role during initial training roster for HR. Also help configuring the learner group based on their job and departments
• Apply and validate of Tax update
• Worked on building PS queries and security for users on ad-hoc reports
• Re-tested the processes and reports, conducted UAT tests and user training, worked with PeopleSoft admins to resolve issues
• Assigned responsibilities of coordinating with end users to identify issues to develop best testing techniques to improve the system
• Performed the tasks of testing the functionality and perform customization of component parts
• Handled responsibilities of writing test case, test result, and test traceability matrix
• Responsible for setting up functional systems as well as perform comprehensive system testing
• Assigned responsibilities of assisting senior tester in developing and implementing standard testing procedures for improvements

Environment: PeopleSoft HRSM 9.1, PeopleTools 8.51, 8.52, Oracle 11g

Confidential, New York, NY

Functional Consultant

Responsibilities:

• Responsible for functional design, data mapping, configuring job competencies and other functional roles
• Involved in design, development, testing, and enhancement of PeopleSoft HRMS for Time & Labor, Payroll and Base Benefits modules
• Worked gathering requirements on personal profile section of the employee self-service application where employee can be able to update their personal information - Name, Email and phone numbers and emergency contact
• Set up foundation table for Time & Labor, Base Benefits and Payroll
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
• Configuration and troubleshooting for Benefits module
• Running the reconciliation report for core HR, Benefits, ELM and profile management (E-performance) modules to help client look-up their data
• Involved in online changes to the delivered pages, components, menus and translate values
• Validating the benefit plans and family coverage and dependent information from their HR files and cross-validation with vendors for billing purposes
• Created functional spec on training to keep their training completion
• Worked on interface programs for migrating data from other systems to PeopleSoft
• Applied bundles for the process of solving the issues in the enhancements
• Conducted meetings with the users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements
• Writing the test case, test plan and conduct the UAT test with HR director and Testing manager

Environment: PeopleSoft HRSM 8.9, PeopleTools 8.49, DB2

Confidential, Horsham, PA

Functional Consultant

Responsibilities:

• Design & develop conceptual solutions addressing business requirements
• Creating and reviewing functional and technical specifications, project schedules, documentation and test plans
• Work with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives
• Conducted interviews with key business users to collect requirements and business process information
• Perform extensive requirement analysis including data analysis and gap analysis
• Designed and coordinated the development of control reports for validating AR converted data. Analyzed and resolved conversion issues related to AR and vendor consolidation
• Developed new crystal report for the AP Self Billing Invoice
• Designed and coordinated development of post conversion validation queries for identifying any missing conversion data in AP
• Researched and resolved a Voucher posting issue related to Group vouchers not posting after initial post and unpost operations
• Made changes to online Bill entry pages. Changes included adding additional pages (Custom pages specific to client) to the existing Bill entry Component
• Documented requirements associated with the reporting and paying employee travel and entertainment expenses
• Developed and Created SQR reports, Crystal reports for purchasing module
• Performed a business process improvement review of Purchasing practices and procedures to reduce requisition to dispatch time by making better use of PeopleSoft functional features
• Used PS Query with Crystal Reports and PS/nVision to create and run multiple layouts and reports
• Support to developers with Unit testing and Integration Testing the Interfaces and Processes and created the Test Scripts
• Design and develop Test cases to check module functionality as well as interaction between modules

Environment: PeopleSoft FINANCIALS 9.0, PeopleTools 8.49, MySQL