SUMMARY:

• 14+ years of implementation, upgrade, application development, conversion production support experience primarily on PeopleSoft applications and modules.
• Technical Experience and knowledge in PeopleSoft 9.2 Finance and HCM application and other latest technologies such as Integration using REST/SOAP based web services with external applications developing fluid mobile pages for PeopleSoft applications, Complex tiles for displaying data using pivot grids, HTML email approvals using AWE, Credit card integration using integration broker, Inbound flat file utility, Integration with outlook for form approvals, using PeopleSoft portal to develop integrated environment for all corporate applications, SSO authentications using LDAP.
• Functional experience and knowledge Functional experience and knowledge in Accounts Payable, General Ledger, requisitions, Contracts, Purchasing, requisitions, Asset management, maintenance management, e - procurement, Travel and Expenses, Procurement Cards, Real estate management (REM), North American Payroll, Global HR, Time & Labor, Global Payroll, Benefits, Pension, Employee Self Service, Manager Self Service, Absence Management, PeopleSoft Portal/Interaction Hub.
• Experience working with multi language implementation for 14 languages in PeopleSoft.
• Data conversion experience from various legacy applications into PeopleSoft.
• Experience on Acquisitions, Mergers and Divestiture, and Re-organization projects for HR and finance applications.
• Experience with end to end, fast passed Finance/HCM implementations and upgrades.
• Excellent communication, inter-personal and analytical skills.
• Accons Payables
• General Leger
• Réquisition
• Contracts
• Purchasing
• Asse management
• Maintenance management e-procurement
• Tavel and Expanses
• Procurement cards
• Real Estate management (REM)
• North American Payroll
• Global HR
• Time & Labor
• Global Payroll
• Benefits
• Pension
• Employée Self-Service
• Manager Self-Service
• Absence Management
• PeopleSoft Portal/Interaction Hub

TECHNICAL SKILLS:

Technology and Tools: People tools Web services (SOAP and Rest based) External Integrations (like outlook/SAS applications) Mobile fluid pages HTML Email approvals AWE Workflow SQR Application Engine Component Interface Pivot grids Oracle database Integration Broker Mobile application platform SQL Server Portal technology (Including HTML5, CSS3, Jason, java scripts, I script), Fluid page development Data Mover

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

PeopleSoft HCM/Portal/Lead developer

Environment: PeopleSoft FSCM, HCM, Portal 9.2, People Tools 8.56, Oracle, DBeaver, Phire, Agile methodology

Responsibilities:

• Review of compare reports between vanilla people tools and copy of production to understand customizations.
• Provide keep drop analysis of compare report.
• Create various DB links between Demo, 856 and production copy environments that helps to being in Non - App designer objects easily.
• Perform analysis of Non-App designer objects like portal CREF, tools tables, AWE tables and to analyze the impact of tools upgrade.
• Perform basic level of environment validation such as ESS/MSS validations, Payroll, Benefits, branding validation, IB validation etc.
• Work with business to perform testing, identify issues, log them into the QC tool and fix them.
• Work with business on enabling classic plus option for custom and delivered pages depending on business requirement.
• For tools related issues log defect in Oracle portal.
• Document all the testing process and obtain sign off from business.
• Work on deployment plan with all stakeholders.
• Work on Post go live issues and fixes.
• Provide hyper care support in production for any issues arising out of tools upgrade.
• Review compare reports between PT856 and PT855 demo to identify tools changes.
• Review compare report between PT856 and COP to identify customizations.
• Reapply customizations in new tools.
• Reapply COP objects to 856 tools.
• Code changes to LDAP People code.
• Complete SSO authentication with HCM, Finance, CRM, MTA and other applications.
• Perform URL changes on branding to reflect the new environment.
• Perform IB node changes to reflect tools and environment URL changes.
• Enable the security IB messages between various environments.
• Perform basic testing on connectivity and SSO authentications.
• Apply web server related objects like Singon.html and language files back in portal.
• Perform security changes for Pagelets/tiles on Portal side.
• UI/UX Enhancements - A common theme and branding across all portal /HCM/Finance applications.
• Include easy access tiles for GSS look like feature.
• Create a easy access and visible environment logo so that users identify the environment easily.

Confidential

Peoplesoft techno-functional analyst

Responsibilities:

• Created a detailed design document for the 4 major component of interface - Indicative data, contributions, deferral rates, loan amounts and GL interfaces.
• Initiated calls between fidelity, business and global scape FTP team to confirm requirements and bring clarity to the project.
• Design and develop setup pages which would identify various events based on the action /action reason and other fields in HR.
• Identify the place holder fields in the file layout so that business will be able to create rules based out of place holder field later on.
• Perform data analysis of the employer and employee contributions portions and impact on payroll.
• Work closely with fidelity FTP team and admins to make sure the PGP transmission happen smoothly.
• Work closely with business to understand the deferral rates file which will load to SAVINGS PLAN table for both 40 and 43 plans.
• Work with business in understanding the loans file, and the various status that come on file, this is especially important to differentiate between a new loan/change/close of loans, based on the status needed to insert into the PS GENL DEDUCTION table.
• Design and develop the GL interface back from the vendor, the main purpose is the reconcile the ER portion what was calculated on payroll side per employee is the same as what was calculated by fidelity.
• Perform end to end payroll testing with business by coordinating with fidelity tech team.
• Post production support and defect fixing .
• Design and develop the 12 reports using BI publisher.
• Create a data creation engine that will insert the data into master table.
• Create detailed test plan to test all those reports by trying different pay scenarios for employees and to check the accuracy of the reports.
• Deploy in production and provide post production support.
• Modify the already created conversion template and test using the acquired company data.
• Update the legacy id in the badge table so that we have mapping between the badge table and the data coming in the feed.
• Fix the excel-to-ci template to load the direct deposit data.
• Create script to update supervisor id in PS Job table.
• Create a new inbound process to load the data into PSHUP TXN table for hourly and salaried employees.
• Create an error report for the employees not loaded into PSHUP TXN table cause of certain rules like more than 80 hours etc.
• Run payroll cycle end to end to verify if the employees are paid properly.
• Deploy the changes in production and provide post go live support.
• Create a proof of concept for changing the label of USER FIELD2 to work order field and increasing the length to store a 50 char work order.
• Create a prompt for the field in report time entry page so that users are able to select the fields from prompt and also able to key in new values.
• Modify the budget ref app package code so that the data can be re-routed to user field2 tables.
• Create an interface to load the T&L data from file into reported time table.
• Perform end to end testing of T&L from reported time till payable time and then to finance.
• Create design document for the messages and present them to all the stakeholders.
• The MSD team had both the resource for the Inbound and outbound messages.
• Created the app engine to initiate the inbound message which will update the data back into peoplesoft.
• Work with MSD team to understand the authentication option for message.
• Work with network team to identify any issues.
• Deploy the changes to production and support.

Confidential

PeopleSoft lead developer - Upgrade 9.2 and Integration

Responsibilities:

• Analyze the compare reports of 9.1 demo, 9.2 demo, and the current cop environment to arrive at the exact level of customizations.
• Effort estimate for all the customization along with Keep drop analysis based on modules HR/Payroll/Benefits/T&L/Absence/Employee self-service/Manager self-service.
• Planning and executing the actual retrofits and development.
• Create customized tiles that are visible on the portal and HCM fluid home pages.
• Make the pages for ESS/MSS pages that are fluid work on all mobile devices like iPhone/Android/iPad etc.
• Perform complete testing of these pages and adjust the layout by adjusting the CSS style sheet.
• Adjust branding images and colors to provide a uniform green color theme throughout portal and HCM side.
• Enable POP3 HTML email server setting so that AWE transactions can be approved via HTML email links.
• Work with admin team and network team to enable the Outlook integration with PeopleSoft e-performance so that employees can enter notes which will reflect in the performance notes of the employees.
• Enhancement to enable users to forward appreciation emails to an email address, a program written to read the email from outlook server and retrieve the email and attach it to the performance document.
• Make sure the SSO works between Portal and native application such as HCM, Finance and MTA. Make sure the IB nodes are setup and have the correct URL and tools version.
• Enable the IB sync between environments like the security sync between HCM-Portal, and other messages like the workforce sync, Chatfield syncs, pull cost and other messages.
• Schedule jobs in test environments so that the jobs mimic what is in prod environment.
• Create a detailed cutover and deployment plan.
• Work on production cutover task like holding the Jobs in production and letting all the stakeholders understand the impact and on-board.
• Closely work with Admins on cutover activities and tasks for pushing the customized project into production using Phire tool.
• Make sure all the cleanup scripts are executed for the AWE transactions cleanup.
• Worked on all post productions issues like performance issues, job. Batch failure by tracking all the post productions issues in a tracking sheet resolving them.
• Create conversion plan for bringing legacy employee information into PeopleSoft.
• Analysis of all interfaces that need to include or exclude legacy employee id.
• Configure PeopleSoft Company groups departments and another setup information needed for payroll.
• Design /develop conversion programs (Tax data, Balances, Garnishments, GL)
• Changes to ExceltoCI template for termination and rehire of employee data.
• Create pay calendars for the newly hired employees.
• Send converted data into new GL platform in corporate finance
• Design and create conversion plan for bringing legacy employee information into PeopleSoft. We used spreadsheet to identify individual countries population first. The challenge was the data was not in English but some were native language and with special characters.
• Work with the country counterpart to identify the minimum fields required to bring in the data into the PeopleSoft application.
• Create a mapping document to identify the data and bring it over into PeopleSoft. The mapping document incudes the pay codes used in the legacy system, badge number mapping and other personal data field mappings.
• Created a mapping page based on country to identify these mappings for technical solution.
• Write a conversion program driven by different files for each country and be able to load into the language tables along with the regular PeopleSoft tables.
• The conversions program has detailed error logs to identify the errors and methods to correct them inside PeopleSoft.
• Extend ESS/MSS functionality to all regional countries, by providing access to the navigation/pagelets/tiles to the respective roles tied to each country.
• Reconfigure different country level approvals for all ESS/MSS transactions, for example the name change may require manager and HR approval for some regions, AWE configuration allows to create one approval routing for each of those transactions.
• Perform language based testing by login into the application as each of those languages.
• Payroll outbound interfaces with all country vendors respectively. The challenge was all 28 payroll vendors where different and it would be not until 1 year that all vendors will be consolidated. The challenge was to create those many interfaces, Solved this by creating a outbound framework which will allow simple configuration and SQL to determine the data that will be sent across on those files.
• Payroll inbound interfaces were created for all inbound payroll data for check/Earnings/Deductions/Taxes/Pay distributions. Since each of the payroll vendors being different we came up with a common file framework.
• Created a Payroll to GL interface for sending balanced GL data to finance, the errors need to be captured and individual employees whose payroll don’t match need to be displayed on report for correction.
• Design and create conversion programs to bring legacy data into PeopleSoft.
• Work on converting text into native language by working with language translators and google translate.
• Create app engine to insert data into the respective language tables after the base table data conversion.
• Create ESS/MSS approval routing got different countries depending on their requirement for approvals.
• Create portal pagelets and language property page corresponding to multi language.
• Translate some of the people tools data table into multi language by inserting data from DMS scripts.
• Create multiple pagelets to allow different countries to see different navigation links on the pagelets. This was controlled by different roles tied to the pagelets.

Confidential

PeopleSoft Integration developer/Portal developer

Responsibilities:

• Keep drop analysis of the compare report.
• Understand the present functionality and move towards a delivered approach.
• Change all the old workflow transactions into AWE framework.
• Complete SSO between Portal to HCM/Finance/MTA/CRM/E-CRM and other applications.
• Enable pagelets for additional users to be shown on home page.
• Retrofit branding to maintain the same look and feel across all the applications.
• Create brand new AWE transactions for Promotion/Termination/Leave request transactions.
• Remove all old s of old URL from PeopleSoft to point to new one.
• Use fiddler tool to debug any issues encountered on the user end.
• Retrofit the LDAP people code that allows users domain name in front of user name while authenticating.
• Rebrand the sign on page to make sure that multi language option and the property files are set correctly.
• Copy Content from native to PeopleSoft to make it work correctly
• Create new navigation collections to be shown inside the pagelets.
• Create new GL program to move the Canada payroll into PeopleSoft.
• Create a new IB message between HCM and finance that transfers the FMC values into finance.

Confidential, Rahway, NJ

PeopleSoft analyst

Responsibilities:

• Gathering requirements from payroll and accounting for restructuring.
• Analyzing impact to all the inbound and external interfaces (Labor distribution system, bonus interfaces, stock options)
• Impact analysis for check reversals and retro transactions after restructuring.
• Detailed impact analysis for General Ledger Interfaces for US and Puerto Rico system.
• Working with business to get sign off on the design.
• Work with development team in completing coding, unit testing and moving it to production environment.
• After production support and bug fixing.

Confidential, Toledo, Ohio

PeopleSoft Integration analyst

Responsibilities:

• Served as a PeopleSoft Design Specialist.
• Analysis of the Existing Interfaces for AP, GL, AR, Purchasing, T&E, P-Card.
• Preparing detailed requirement specifications for interfaces.
• Preparing detailed flow chart to show the business process flow to the clients for T&E, P-Card, AP modules.
• Schedule meeting with clients and explain the delivered functionality and customizations required.
• Coordinating with Offshore to make sure the requirements are understood correctly.
• Contacting the Banks like Amex and JPMC for setting up secured file transfer for interface files.
• Designing secure bank file transfer methods, implementing via PGP file encryption methods.
• Worked on AMEX billing process.
• Design and develop Credit Card expenses transaction load,
• Procurement card transaction data load from JPMC.
• Online customizations for GL, PO, T&E and Procurement Card modules.
• Organizational data setup for T&E and Procurement cards.
• Wrote Specs for Custom HR Data interface from Peoplesoft HR into T&E module.
• Configure T&E approval routing to work dynamically based on monetary value and other criteria
• Manual Journal Spreadsheet Upload into the Peoplesoft GL Module.
• Interfaces for loading various journals from internal departments to Peoplesoft GL.
• Designed a Custom payroll to GL interface.
• AP interfaces for creating files like Positive Pay file, wire transfer files, Check printing, EFT files.
• Setting up AP Pay cycle using Pay cycle manager and automating using tidal scheduler.
• Design and develop interfaces files from internal departments and load the transaction fees, Cash outs, Sales and Service fee files into Peoplesoft Billing module.
• Lockbox interface from JPMC to the AR staging table for the AR Payload program.
• Create Test plan and test the code delivered by offshore.
• Help business create database level scripts, SQL and PS Query to put a check point in the business process flow that allows verification of the results.
• Created the security matrix for access to Peoplesoft and integrated it with the active directory. Revoke access when employees are terminated in active directory.
• Thorough system testing of all the development.
• Reviewed materials like Presentations, workbooks and documentation created for end users.
• Setting up meeting with clients and show them the Customization demo.
• Help clients with system and integration testing.
• Job scheduling using Tidal scheduler and integrating it with third party vendors, Banks and internal departments. Program it on TIDAL to automatically pick up files once they are created and can FTP it to the third party.
• Implementing the end to end process for the entire interface

Confidential, Fort Worth, Texas

Peoplesoft developer

Environment: PeopleSoft Finance/HR 9.0, People Tools 8.49, Microsoft SQL Server 2005

Responsibilities:

• As a Senior developer worked on Implementation/ Customization in PeopleSoft
• Demonstrating the functional changes between Ceridian and Peoplesoft HRMS 9.0 in the demo environment.
• Assisting clients during Requirement Gathering phase of the project, and working with business analysts for performing Fit-Gap Analysis.
• Helping clients to understand the delivered PeopleSoft functionality and help them in making correct decisions.
• Prepare business process documents and as-is process flow charts.
• Analyzing the gaps and preparing Fit-Gap documents from the current system to Peoplesoft 9.0.
• Complete setup of all foundation and product related tables for HR module.
• Prepared configuration document for the setup changes and develop scripts to move it to testing environments.
• Prepare functional specification for the interfaces and customizations for HR module.
• Help the conversion team in converting data from Legacy system to Peoplesoft 9.0 environment.
• Testing the converted data and showing demo to the client of the prototype.

Confidential, Richmond, Virginia

Peoplesoft Technical Analyst

Environment: PeopleSoft FSCM, HCM 9.0, People Tools 8.49, Microsoft SQL Server 2005

Responsibilities:

• As a Senior HR consultant worked on Implementation/ Customization of HRMS 9.0.
• Demonstrating the functional changes between Ceridian and Peoplesoft HRMS 9.0 in the demo environment.
• Assisting clients during Requirement Gathering phase of the project, and working with business analysts for performing Fit-Gap Analysis.
• Helping clients to understand the delivered PeopleSoft functionality and help them in making correct decisions.
• Prepare business process documents and as-is process flow charts.
• Analyzing the gaps and preparing Fit-Gap documents from the current system to Peoplesoft 9.0.
• Complete setup of all foundation and product related tables for HR module.
• Prepared configuration document for the setup changes and develop scripts to move it to testing environments.
• Prepare functional specification for the interfaces and customizations for HR module.
• Help the conversion team in converting data from Legacy system to Peoplesoft 9.0 environment.
• Testing the converted data and showing demo to the client of the prototype.
• Fix any setup and configuration that arise during testing.
• Created detailed test plan for user acceptance testing.
• Creating security matrix, portal registry, portal permissions, roles and user profiles.
• Testing all the ESS and MSS transactions.
• Working with various vendors to facilitate testing of external interfaces.
• Perform complete system testing and 3 levels of parallel testing.

Confidential, Pittsburg, Pennsylvania

Technical Analyst

Responsibilities:

• Analyze Vanilla compare reports to determine the level of PeopleSoft Object customizations and to prepare the customization Inventory.
• Analyze interfaces and PS Query to determine the effort required to retrofit them.
• Work on tools to identify the level of impact on SQL objects, PS QUERY.

Confidential, Denver, CO

Technical Analyst

Responsibilities:

• Served as a PeopleSoft Design Specialist.
• Analysis of the Existing Interfaces for AP, GL, AR, Purchasing, T&E, P-Card.
• Preparing detailed requirement specifications for interfaces.
• Preparing detailed flow chart to show the business process flow to the clients for T&E, P-Card, AP modules.
• Schedule meeting with clients and explain the delivered functionality and customizations required.
• Coordinating with Offshore to make sure the requirements are understood correctly.
• Contacting the Banks like Amex and JPMC for setting up secured file transfer for interface files.
• Designing and documenting the Banks secured way of transferring the file and writing scripts to enable PGP file encryption.
• Worked on AMEX billing process and interfaces like Credit Card expenses transaction load, Credit card holder data load from Confidential using integration broker.
• Procurement card transaction data load from JPMC.
• Online customizations for GL, PO, T&E and Procurement Card modules.
• Organizational data setup for T&E and Procurement cards.
• Wrote Specs for Custom HR Data interface from Peoplesoft HR into T&E module.
• T&E workflow - including emails, wordlists for Expense approval by the employee’s supervisor based on approval level.
• Manual Journal Spreadsheet Upload into the Peoplesoft GL Module.
• Interfaces for loading various journals from internal departments to Peoplesoft GL.
• Designed a Custom payroll to GL interface.
• AP interfaces for creating files like Positive Pay file, wire transfer files, Check printing, EFT files.
• Setting up AP Pay cycle using Pay cycle manager and automating using tidal scheduler.
• Worked on creating interfaces files from internal departments and load the transaction fees, Cash outs, Sales and Service fee files into Peoplesoft Billing module.
• Lockbox interface from JPMC to the AR staging table for the AR Payload program.
• Create Test plan and test the code delivered by offshore.
• Help business create database level scripts, SQL and PS Query to put a check point in the business process flow that allows verification of the results.
• Created the security matrix for access to Peoplesoft and integrated it with the active directory. Revoke access when employees are terminated in active directory.
• Thorough system testing of all the development.
• Helped in creating materials like workbooks, manuals, Presentations and documentations for the end users.
• Setting up meeting with clients and show them the Customization demo.
• Help clients with system and integration testing.
• Job scheduling using Tidal scheduler and integrating it with third party vendors, Banks and internal departments. Program it on TIDAL to automatically pick up files once they are created and can FTP it to the third party.
• Implementing the end to end process for the entire interface

Confidential, Reston, Virginia

Technical Analyst

Responsibilities:

• Assist in day-to-day production support in NA Payroll, Time & Labor, Employee Self service issues.
• Assist in Time and Labor configuration changes and tickets.
• Annual Enrollment Changes involving interfaces to ADP, Online Changes for e-Benefits,
• Functional analysis and design of Long Term Incentives and short-term incentive enhancements on e-Compensation. End to end testing of the ESS and MSS transactions and compensation history pages.
• Worked on the integration of Confidential and Confidential employees. Worked on the Time and Labor integration and setting up T&L and self service for those employees.
• Worked on tax updates and testing them in test environment.

Confidential, Dallas, Texas

Upgrade Specialist

Responsibilities:

• Responsible for providing a technical assessment for the PeopleSoft HR Upgrade from version 8.0 to version 8.9
• Analyze Vanilla compare reports to determine the level of PeopleSoft Object customizations and to prepare the customization Inventory
• Analyze SQR reports and programs to determine the effort required to retrofit them.
• Develop tools to identify the level of impact on People code, SQL objects, PS QUERY and SQR.
• Responsible to setup the Demo Environment and Copy of Production for upgrade & analysis
• Impact Analysis of new Enhancement Requirements & Code Development
• Identified & Analyzed Online and batch customizations to arrive at keep and drop decisions
• Designed & create custom MSS Suspension transaction for Suspending Employees
• Was involved in organizational Succession Planning.
• MSS Termination involved Initiate, Approve/Deny, View Status functionality which involved PS Workflow & Approval Rule Set
• Analyzed & Modified the Application Packages in 8.9 for MSS transactions
• Involved in Creation of new Audit Tables & Modification of existing Audit tables
• Designed and developed the payroll to GL Interface.
• Designed and developed the custom ESS state and Local tax page.

Confidential, Dallas, Texas

Technical Analyst

Responsibilities:

• Preparation of Design documents of the Conversion Requirements from the client.
• Impact Analysis of Conversion Requirements on existing application.
• Design, development and Testing of Conversion scripts & SQRs.
• Worked on time and labor cross reporting of supervisors.
• Prepared the time and labor knowledge acquisition document for the production support group.

Confidential

Peoplesoft Developer

Responsibilities:

• Prepare Detailed Technical Design Document of the Business Requirements from the client.
• Analyze Production Help Desk tickets.
• Development, Testing & Deployment of new Enhancement by following the SDLC & SOX processes
• Impact Analysis of Client Requirements & Code Development.
• Preparation of Test Plans, Test Cases & Unit Testing.
• Preparation of functional specs for payroll Paperless Pay Stub
• Functional spec for Time & Labor Hardstop which prevents the employees from entering time after the setup hardstop datetime.
• Creating feed for contingent workers from domino to Peoplesoft.
• I9 Notification workflow, Surplus feed, Online changes, Logo Changes, interim cross reporting solution to maintain the supervisor reporting relationship

Confidential

Peoplesoft Technical Analyst

Responsibilities:

• Prepare Detailed Design for the various interfaces to external vendors for Kenya and Malaysia.
• Setting up earnings and deduction codes and creating bucket tables for the interface and reports.
• Show demo to clients to the various setups made for each country and run a demo payroll to show the functionality.
• Created interfacing between HRMS and GP.
• Created a global payroll tool which will load the data from spreadsheet into the global payroll tables.
• Create requirements for reports for various countries like Malaysia, India, Kenya, UK etc for business to use.
• Salary Register for various countries which is a consolidated final report of the payroll, which is used to verify if the payroll has run correctly for the countries.
• Design online customizations.
• Raise Case with PeopleSoft Customer Connect for any defects in PS delivered functionalities.