SUMMARY

• 11 years of experience in PeopleSoft technology which includes Implementation, Customization, Upgrade, Maintenance, Support and Testing.
• Predominantly focused on design, customization and implementation of PeopleSoft FSCM (General Ledger, Account Payables, Account Receivables, Travel and Expenses, Project Costing, Customer Contracts, Purchasing, Asset Management and Billing), HCM & CS modules.
• Certified Expert as PeopleSoft People Tools Enterprise Developer by Oracle.
• Carried out data conversion/mapping efforts including preparation of Fit gap analysis and checklist in an effort to bring data from/to legacy system to PeopleSoft FSCM, HCM systems.
• Worked on Integration within PeopleSoft and 3rd Party systems.
• Proficient in creating and executing SQL queries using Oracle 10.x/9.x, MS SQL Server.
• Responsible for Defect Management that includes Defect Evaluation, Prioritization, Tracking and Resolution.
• Expertise in using Reporting Tools such XML Publisher, PS Query, SQR & Crystal Reports.
• Performed debugging of various processes.
• Working experience in implementing PeopleSoft Enterprise Workflow.
• Hands on experience with FTP, Winscp for file transferring & loggings.
• Experience working independently with no assistance; supported end users on various support issues; ability to quickly come up with solutions and providing excellent customer satisfaction.
• Well versed with Debugging tools like SQL trace, PC debugger and AE trace for troubleshooting and Performance Tuning.
• Worked with Security Administrator to implement security at various levels. Creating Roles, Permission Lists User Profiles, Portal Security, Folders, Content References and Definition Security.
• Good understanding of PIA and client server applications.
• Performed impact analysis for custom HCM interfaces, and processes for Payroll Processes, Leave Accrual, Sick Pay and General Ledger.
• Performed end to end testing for Full time, Temporary and Independent Contractor employee types.
• Communicated with Salesforce, Finance and Reporting teams for defining Internal and External interface requirements and perform design changes and Integration testing.
• Conducted meeting with development teams and business users for reviewing product changes and test scenarios to get sign - off.
• Extensive knowledge of full Software Development Life Cycle (SDLC) and Agile methodologies.

TECHNICAL SKILLS

PeopleSoft Applications: PeopleSoft FSCM 9.x/8.x, HCM 9.x/8.x, CS 9.x

PeopleSoft Tools: 8.4x, 8.5x

Reporting Tools: SQR, PS Query, XML/BI Publisher, Crystal Reports and nVisons

Knowledge Domain: FSCM, HCM, CS

Web Services: SOAP, REST

Database: ORACLE, MS SQL Server, TOAD, SQL Developer

Operating System: Win NT, Win2K, Win2K3, Win2K7, UNIX

Migration Tool: STAT, PHIRE

Tracking Tools: Quality Center, JIRA

Web Development Tools: HTML5, CSS3, XML

Programming Languages: C, C++, UNIX, Shell scripting, Java

PROFESSIONAL EXPERIENCE

Confidential, ChaddsFord, PA

Sr. PeopleSoft Techno Functional Consultant

Responsibilities:

• Developed Outbound HR Interface for Tangoe for Mobile Procurement for all Employees in US and Rest of the World.
• Developed Outbound HR Interfaces to send employee data to SumTotal for Learning Management.
• Created Bolt-on Pages in Finance for Exhibits and Displays for Sales Teams.
• Customized Travel and Expense pages with customization for validation depending on expense type and for attaching Receipts.
• Created Bolt-on page and Application Engine process for Requestor Change in Peoplesoft Finance.
• Worked on SAP GRC (Governance, Risk, and Compliance) tool to assign user profiles, roles and access management in Peoplesoft HR and Finance.
• Customized the Delivered Transfer and Termination MSS transaction for 9.2.
• Developed Bolt-on pages for Remove roles from Terminated employees.
• Implemented Bravo awards for employees.
• Created Process Definition, Run Control Record, Page, and Component to run the batch program through Process Scheduler; scheduled the jobs through process scheduler.
• Worked on resolving tickets related to module like AP and Contracts.
• Worked on test cycles and related defects.
• Configured GL Combo edits rules.
• Created Outbound file from Peoplesoft HR to Infinity HR with employee Information.
• Created Inbound file from Infinity Hr to Peoplesoft HR with Benefits Information.
• Created data mover scripts to move data from one environment to another.
• Documented Unit testing conditions.
• Provide post-production support across all deployed modules.
• Developed new queries using BI publisher to replace some SQRs.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Interacted with business users for Requirements Gathering and created Business Requirement Documents and Functional Requirements Documents for new and existing customization of pages, Interfaces and reports.
• Performed Defect Tracking using HP ALM tool. Responsible for identifying issues, recording details and determining criticality of the defects in the process.
• Worked on production backlog issues post go-live. Created change requests in JIRA and provided support end to end till closing of defect.
• Worked on Payroll Processing - Pay Sheet Creation, Pay Calculation, and Pay Confirmation for Biweekly and Monthly population.
• Configure tables involved in Payroll for Pay calendar, Job Code, Deductions.
• Performed payroll processing for new hires, promotions and terminations.
• Set up Earnings and associate Earnings programs to employees.
• Troubleshoot payroll and Core HR and provide problem resolution.
• Process and maintain garnishments.
• Developed & Setup transactions between PeopleSoft & 3rd party systems using Integration broker, Created custom handlers for inbound / outbound transactions.
• Excellent in providing the work around solution for production failures with in business hours and documenting the same for future use.
• Involved in requirement gathering from the business users and updated the specifications.
• Worked on day to day enhancements of the system and support for users especially in AP, AR, AM, GL modules.
• Performed system testing for ESS Life Events and Benefits Changes (OLE) for Marriage, Birth, Adoption, Divorce and benefit changes for AD&D, Disability and Life.
• Co-ordinated with business and developed Functional requirement documents and PS Queries for PS reports and supported testing of Cognos reports.
• Conducted meetings with Development teams and Business users for reviewing the product and test scenarios to get sign-off.
• Created artifacts and testing findings reports, which aids as documentation for business users.
• Created new positions and updated existing positions using Position Data.

Confidential, NewYork,NY

PeopleSoft Technical Consultant

Responsibilities:

• Converted Mailing Address classic page to fluid page.
• Debugged and resolved various issues on SQRs, Application Engines, Application Packages and Component Interfaces.
• Created SQL’s to generate one-time report as per the client requirements.
• Developed several custom Payroll reports like Income verification report which summarizes Regular Earning balance, Overtime-Double Time Earnings Balance, Shift Earnings balance, Performance Earnings balance and miscellaneous earnings balance.
• Proficient in Debugging and Tracing Application Engine, PeopleCode, SQR and Component Interface.
• Tuned the performance of custom Application Engine programs run time.
• Developed Complex Invoice XMLP templates in Billing.
• Conducted meetings with users to understand the business requirements and documented technical Specifications for developer team.
• Modified the Billing Extract logic to generate the XML file for the invoice templates in Billing.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Conducted meetings with users to understand the business requirements and documented technical Specifications for developer team.
• Worked on PS Security, handled the tasks related to security including access to various PS modules/ Pages on an individual user basis and permission lists.
• Involved in integration of PeopleSoft Components as Web Services to third Party Applications.
• Worked with the functional leads in ensuring that the project plan and deliverables meet the deadline and due dates during upgrade.
• Worked on General Ledger and Involved on data and application integration components into an end-end interface solution and Requirements gathering for new Enhancements, Design and Unit Testing and Preparing Technical Design documents for enhancements in different modules.
• Executed test scripts for Functional Unit Testing, System Testing and Data Conversion validation testing.
• Designed and Developed Automated Report Distribution process which distributes the report to Project Managers and Business Managers based on the setup.
• Developed new reports such as Time Notes and Pending Time sheet Reports using BI Publisher.
• Converted some of the existing Crystal Reports into BI Publisher Reports.
• Worked on the Performance Tuning of the WIP Report.
• Worked on POC like Single Sign on through e-Bill, Statements using XML Publisher, Loading Deposit files using Excel through Integration broker, customer load using web services, work flow using Approval frame work.
• Developed Purchasing Interface using File Layout, Application Engine, AE, People Code and Component Interface which loads data from flat file into staging tables while doing various data validations using Application Engine People Code and finally loads into PeopleSoft tables through Component Interface.
• Provided SQL tuning for some of the AM User Queries used for month end close analysis.
• Created a Technical Document repository for all customized AM and PC Application Engine processes.
• Hands on experience on SOAP web services.
• Technically proficient in developing and customizing Interfaces and Conversion programs using SQR & Application Engine.
• Involved in the PO - AP matching issues in PeopleSoft allowing the system to match the Purchase Order, Receipts and Vouchers - as the converted data was manually matched in legacy system. For this, I developed an interface inbound/outbound Application Engine process to make sure the data in PeopleSoft AP table are consistent with the ones in the third-party system.
• Analyze current customizations and present alternatives in the new version to minimize or remove these customizations.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Worked extensively in creating new Pages, Components and making enhancements to existing pages by adding new features through Application Designer.
• Presentation of all new features and explaining the functionality field by field in latest version.
• Extensively involved in requirements gathering and fit/gap analysis and customizing ‘Vanilla’ version of PeopleSoft. Solid experience in providing alternative solutions to gaps and evaluating level of effort.
• Preparing Fit & Gap Documents.
• Prepared Functional Design Documents for both ePerformance & ELMS modules on all new enhancements and taken sign off.
• Designed and developed prototypes for user requirements and demonstrated the same to end users
• Configured, Created Learning Environment, Additional Learner Groups (Criteria Based & Query Based), Categories, Courses, Classes, Programs (Includes Curriculum & Certifications) Configured New Delivery method types, and multiple Learning Resources in ELMS module
• Extensively involved in requirements gathering and fit/gap analysis and customizing ‘Vanilla’ version of PeopleSoft. Solid experience in providing alternative solutions to gaps and evaluating level of effort.
• Designed few customizations in ELMS & ePerformance Modules.
• Created user profiles, assigned permission lists and roles based on requirements, fixed all security related issues.
• Supported production team in resolving critical issues after development.
• Documents work accomplishments and implementation issues in clear, thorough and timely manner.
• Prepared an understanding Document for all new features which are accepted by County for v9.2 upgrade.
• Worked on Testing Strategy and Prepared test scripts for both ELMS & ePerformance Module
• Assisted County’s development team on Security related questions.
• Configured and monitored various operations in the system for better user experience.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Involved in creating an Application Messaging Programs, in order to send an email to the Benefits Administrator, Payroll Administrator when a new employee is hired.
• Adhere to SDLC steps of Plan, Design, Develop, Test and Migration of the projects.
• Retrofitted a lot of Custom sqr’s UHC Census Report, UHC Anniversary Report and UHC Anniversary
• Notification to Managers for Table changes in 9.1.
• Developed, unit tested programs using SQR, Application Engine, Component Interface and Integration Broker for HR, Benefits.
• Developed Interfaces for Payroll, such as Deduction Calculation: this SQR generates deduction codes for each employee’s benefit plans elected for that particular year; these deduction codes are used by the payroll department to process (Benefits Billing Process) the pay of employees.
• Involved in requirement specification, PeopleSoft application customizations, functional and technical design documentation as per business need of the clients.

Confidential, Washington, DC

PeopleSoft Technical Consultant

Responsibilities:

• Developed conversion program to load client garnishment files into PeopleSoft system while FSCM 9.0 implementation.
• Develop core conversions engines using Component Interface and Application engine program.
• Prepare test strategies and unit test plans. Performed planning and data conversion activities.
• Taken care of security/access issues for client users through use of ticketing system.
• Production support and troubleshooting various issues post implementation.
• Provided technical and overall support to team members in all stages of the project.
• Modifying custom SQL statements to run against database tables for analysis.
• Created application engine programs to load Purchase orders from excel sheet to PeopleSoft Purchasing tables through express PO create component.
• Customized PO pages and Modified Purchase Order SQR as per requirements.
• Worked on complete Data Mapping and Data Conversion Scripts between Legacy System and PeopleSoft System.
• Developed Application Engine Programs to move employee data from a flat file to custom PeopleSoft tables and to retrieve the data from the tables to comma-separated excel files.
• Involved in testing the objects created by other team members and the flow as cross testing activity.