PROFILE:

Over Fifteen years of experience in the Information Technology Industry. Nearly 13 Years of experience as Techno - Functional consultant having strong skills in Analysis, Design, Development, Upgrade & Implementation of PeopleSoft HCM/FSCM in Multi-Tier Environment using PeopleSoft 9.1/9/8.9/8.8/ 7.5/7/6. Involved in 2 full life cycle implementations, 4 full upgrades and applying bundles/patches and fixes. Excellent Analytical, Organizational, Interpersonal and Communication skills.

PROFESSIONAL SKILLS:

ERP Packages: PeopleSoft 6.0/7.5/8.x/9/9.1

FCM: AP/GL

HCM: HR, Payroll(NA & Global), Base Benefits, Ben Admn, TnL, TnA, ESS, MSS.

Software/Languages: SQR, SQL, PL/SQL, JCL,Visual Basic, XML, COBOL

RDBMS (Databases): Oracle 7.x/8i/9i/10g, MS-SQL Server, SQL Base 4.5,DB2

Development / Administrative Tools (PeopleSoft): Application Designer, Process Scheduler, Application Engine, Import Manager, Data Mover, Object Security, Security Administrator, Query Manager Tree Manager, Process Monitor, Component Interface, Utilities, Mass Change, Workflow Administrator, Configuration Manager, Data Archive Manager and People Code.

PeopleSoft Reporting Tools: SQR, PS Query, Crystal Reports, n Vision.

Operating System: Windows 95/98 / NT/ 2000, HP-UX, OS 390, MVS

Schedulers: Process Scheduler, Maestro, Control M & Espresso.

Version Controller: Platinum CCC Harvest, PVCS, Source Safe. STAT

Testing Tools: Mercury Tools/Test Director.

DBA Tools: WinSQL5, SQL Navigator 5, Toad, PL/SQL Developer

Project Management Tools: RUP, Astoria, MS Projects 2003,Remedy

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Involved in user enhancement and maintenance of PeopleSoft Financials (General Ledger & Account Payables ) utilizing PTools and People Code.
• Involved in developing of new SQR reports and crystal reports and customizing PeopleSoft delivered report designs according to user requirements for GL, AP.
• Translate complex business requirements into functional and technical design specifications, taking into consideration usability, performance and design standards.
• Developed SQR’s such as Loading GL Accounts from flat file into customized tables.
• Setting up of Integration Broker Integrations and WF Applications in Expenses modules.
• Did Channel setup and involved in bouncing PUB/SUB servers for Integration Broker.
• Develop & design functional documents to analyze and re-configuring foundation tables.
• Created project plan using SDLC technology and executed successfully.
• Performed requirements and fit analysis including design of work-around and customizations.
• Configured foundation tables of HR/Global Payroll.
• Designed/re-configured and setup new setids, reg regions, created new dept security tree.
• Designed and setup new locations, companies, business units.
• Setup and executed snapshot for initial conversion to Ben Admin.
• Tested payroll processing with new setids, business units.
• Documented e-Benefits, e-Profile and e-Pay for employees and administrative staff.
• Identified and developed correction procedures for business process for Work Force Admn.
• Designed and developed new and modified action/action reasons.
• Developed SQRs for validating new business processes and created interfaces and reports.
• Developed SQRs to convert employee benefit enrollments from other systems to PeopleSoft tables.
• Developed a custom performance review process for employees with ability to record comments by manager from MSS and by employee from ESS.
• Developed custom employee reward program with new PeopleSoft style sheets and colors.
• Setup Process Scheduler job definitions.
• Modified/Developed several app engines/sqrs for inbound and outbound interfaces.
• Assisted in loading payroll data using ExcelToCI tool.

Environment: PeopleSoft HCM &FCM 9.0/9.1/PeopleTools 8.47/8.50,Oracle 11g

Confidential, CA

Responsibilities:

• Created functional designs for implementing e-benefits.
• Setting up rules for Marriage and Birth events for e-benefits.
• Testing Open Enrollment and Event Maintenance processes for OE11.
• Developed functional design document for implementation of Marriage and Birth events.
• Developed several PS queries waived on certain events, Dependent Document tracking, active dependents etc.
• Identifying changes needed for OE11 with the lessons learned from OE10 and creating functional designs.
• Interacting with business teams to identify and modify the confirmation statements.
• Interacting with business teams to identify and modify the enrollment forms on demand by people on leave.
• Assisted in loading benefits setup data using ExcelToCI tool.

Environment: PeopleSoft HCM 8.9/8.50,Oracle 11g

Confidential

Responsibilities:

• Develop & design functional documents.
• Performed requirements and fit analysis including design of work-around and customizations.
• Developed a custom security and workflow for store hierarchy setup.
• Developed a store manager delegation setup.
• Developed test scripts for various processes in HP Quality Center.
• Developed SQRs to convert employee information from other systems to PeopleSoft tables.
• Developed custom subsystems, edits and defaults using PeopleTools and PeopleCode.
• Setup Process Scheduler job definitions.
• Modified/Developed several app engines/sqrs for inbound and outbound interfaces.

Environment: PeopleSoft HCM 8.9/PeopleTools 8.47,Oracle 11g

Confidential, Pleasanton, CA

Techno-Functional Consultant

Responsibilities:

• Design, Development and testing of HR/Benefits/Payroll enhancements as per the user requirements.
• Worked on analyzing the system to upgrade Version 9.1.
• Developed a customized end to end automated process for Hire, Rehire and other Employee job changes like transfer, Pay and other data changes from the third party Recruitment system to the PeopleSoft HRIS system as part of multi phase implementation.
• Used Application Messaging to read the incoming data from the Taleo Recruitment system which is then inserted into a custom intermediary staging components in the PeopleSoft system using a Component Interface while performing all the complex data validations.
• Automatic work items were created for the users by integrating to the CRM system through Integration Broker and Application Messaging.
• Worked on couple of interfaces to new benefit vendors.
• Providing on-call support round the clock.
• Developed several functional/Technical documents for major customizations.
• Extensively worked on ADP interfaces for Garnishments, Taxes, 401K NDT etc.
• Worked on Contingent Workforce Management, a custom module developed for hiring and maintains the HR records of non-employees.
• Worked on Open Enrollment 2010.
• Modified several sqrs during open enrollment to accommodate the new business rules, new verbiage and new rates.
• Modified the Employee self service benefit enrollment page for new verbiage, eligible amounts calculated based on ben base rate or deduction amounts from payroll.
• Developed SQRs to convert employee benefit enrollments from other systems to PeopleSoft tables.
• Developed App Engines for generating outbound files to be sent to vendors.
• Worked on a HR Taleo App Messaging interface for hire, rehire and Job change transactions with XML services. Used Integration Broker tool extensively for this project.
• Worked on retrofit of PS objects and SQRs during the conversion of data from another PS instance to the current HR instance.
• Developed many interfaces such as Annual NDT for Vanguard, E-verify for TALX, I-9 process for TALX.
• ADPTax Filing. Extraction of PeopleSoftPayrolltax liability data (periodic and Quarterly) tointerfaceto third-party tax filing services.

Environment: PeopleSoft 8.8/9.1 HRMS/HCM, People Tools 8.47.04/8.50 , DB2, Mainframe.

Confidential, GA

Techno-Functional Consultant

Responsibilities:

• Technical Lead for Manager Self Service/Auto Pay/Retro Pay/Split Check projects and supported the payroll process (post upgrade/implement).
• Worked on customization/development of Manager Self Service such as Direct Reports To, Indirect Reports to (Drill Down) activities, email process various HR activities. Also developed a process to Timeout & Escalation of transactions.
• Developed a custom process to delegate authorities to different MSS transactions.(functionality from PeopleSoft V9.0).
• Developed a custom work list to isolate MSS transactions from the regular one.
• Extensively used work flow technology to create work lists and emails.
• Extensively used CI to integrate the MSS with Core HR system.
• Extensively worked on conversion of employee pay data for new acquisitions. Developed many reports, processes and interfaces in the HR/Payroll area.
• Extensively worked on creating new roles, permission lists and a consolidated security matrix.
• Designed Developed a custom process for Payroll to load hours into pay sheets after validating the data from excel spread sheets and applying different edits and rules based on business requirement.
• Worked extensively on Time&Attendance module to customize some of the programs.
• Developed a process to replace/split the issued checks for various reasons.
• Developed various SQRs/App Engines to generate payroll reports/XLS sheets.
• Developed various processes to load hours/bonus amounts into pay sheets.
• Customized the Retro Active Pay process.
• Developed a process for leave accruals.
• Developed a custom GL interface.
• Worked on ADP Garnishments.
• Extensively worked on implementation and customization of recruiting module.
• Customized PeopleSoft delivered Candidate-Gateway (e-Recruit) pages to add some fields.
• Involved in setting up the configuration for Resume Upload Process from External careers, Resume Upload Process from employee self service, and Load Resume Process from Administration areas.
• Worked on process to upload resumes received by central mail box via emails.
• Designed Technical specification for customization in Recruiting, Talent Acquisition Manager for employees to submit resumes and attachments online.
• Worked on Duplicate Applicants Merge Process.
• Customized the Prepare for Hire page by adding new fields and populated the new fields with the values related to the Applicant and the Job Opening ID.
• Developed a custom Application Engine to Inactivate the Applicant Status and to update the Status Reasons of the Terminated/Retired employees.
• Designed and developed people code to set up workflow for Hiring and triggering events to mail the new-hire details to all administrators such as Payroll, Benefits.
• Worked on XML transformation with the Mohomine Extractor.
• Developed many work around processes for PeopleSoft delivered SQR/ App Engine /COBOL to meet the business requirements.
• Developed many processes using CI/App Engine to load Pay Rate changes, Department Changes, General Deductions etc from flat files to PeopleSoft tables.
• Involved in Customization of Employee Self Service modules such as e-Pay, e-Benefits.
• Involved in applying bundles 7, 8, 9 &10 supplied by PeopleSoft and retrofitted the customizations.
• Developed Conversion Programs to load data from Legacy system to PeopleSoft tables and Interface programs.
• Used various Component Interface and Application Engine programs to load Roles of various users, loading of vendor data in AP module etc.
• Developed Application Engine to load Rate Template in Projects Costing.

Environment: PeopleSoft 8.8/8./9.1 HRMS/HCM, People Tools 8.47.04, Oracle, UNIX.

Confidential, FL

Techno-Functional Consultant

Responsibilities:

• Responsible for the upgrade of payroll module.
• Gather, review requirements and suggest changes to avoid impact on other processes.
• Customized and developed many SQRs, App Engines. For Benefit Interfaces for MetLife, Fidelity etc.
• Develop high-level estimates, Analysis & Design documents.
• Design and code any assigned programming within broad parameters.
• Create test cases, test and review test results with Business partner.
• Choose or recommend courses of action that can result in cost reduction or functional improvement for the user departments.
• Make modifications to an existing system to correct defects or to improve effectiveness.
• Develop ad-hoc queries for user group using PS/Query and generate crystal reports.
• Involved in Fit-Gap analysis during upgrade from 8.8 to 8.9
• Actively involved in upgrading the system to 8.9 in HR/Payroll/Benefits.
• Actively involved in customizing Person Mode functionality for the business requirements.
• Actively involved in upgrading/ customizing e-Pay, e-Benefits, e-comp modules.
• Actively involved in upgrading/ customizing Manager Self Service module.
• Designed Functional and Technical design documents for new customizations
• Developing new tables, pages, components, portal structures for business needs from time to time.
• Monitoring weekly North American Payroll.
• Interacting with business groups for cross-functional issues.
• Designed & Developed several interfaces to vendors such as Fidelity Financial Services/Skill Soft.
• Designed and developed a process, Component Inventory to identify the ownership for various components.
• Customized the Retro Pay/ Retro Benefits as per the business requirements.
• Customized GL functionality/Developed GL Interface to fit business needs within the delivered functionality with minimal customizations.
• Developed many sqrs on fly to debugs various issues like record count, PS objects Audit, Pay line status count etc.
• Developed several scripts/sqrs to compare earnings, taxes, deductions, and balances during parallel testing.
• Developed Call System to send reports/information via emails.
• Developed a security Matrix to accommodate the custom Roles and Permissions.
• Developed many sqr in TnL like Time Card Report, Emer Punch Time process etc.
• Customized Punch page as per business requirements.

Environment: PeopleSoft 8.8/8.9 HCM, PeopleTools8.46.11, PeopleCode, SQR, PS/Query, Process Scheduler, Unix, Oracle 9i/10g, Windows XP.

Confidential, FL

Techno-Functional Consultant

Responsibilities:

• Responsibilities include gather requirements, documentation, analyzing business issues, and development of reports, interfaces, and processes.
• Monitoring weekly payroll, both US Payroll and Canada Payroll.
• Interacted with other IT groups for cross-functional issues such as Data Ware House, Publishing repots on web etc.
• Developed several interfaces to Liberty Mutual for Worker’s Compensation, Smith Barney for Taxes.
• Worked on interfaces for ADP taxes, ADP payroll etc.
• Developed several audit reports by populating PSAUDIT and also by creating new tables for various tax tables, bonus table, payroll tables.
• Developed several processes in payroll such as Loading data from csv files to Rapid Data Entry tables and then loading to Pay lines.
• Developed several reports to audit the weekly payroll process such as future dated tax balance rows, pay line status count, payroll summary (comparing pay lines and T&L).
• Developed several fix programs such as setting pay line status flags, fixing vacation hours etc.
• Involved in setting up stock foundation tables, stock rule tables, Stock block out rules, Stock action table, stock action reason table etc.
• Modified several pages such as Stock Option Activity, Stocks Re-Purchased, Stocks Split History, Stock option Summary, Stock Option Information etc.
• Worked on creating work flow rules, roles and routings.
• Added new activities to send emails and work lists via work flow.
• Customized self service components for ESPP.
• Customized and developed many reports such as Refund-Carry forward, Stock purchase error message, ESPP, Governing rules, FMV method table etc.
• Involved actively in upgrading the payroll module from ver 8.8 to 8.9.
• Retrofitted all payroll SQRs and PS Objects.
• PeopleSoft Financials (GL, AR, AP, PO)
• Involved in user enhancement and maintenance of PeopleSoft Financials (General Ledger, Account Payables & Accounts Receivables) utilizing PTools and People Code.
• Involved in developing of new SQR reports and crystal reports and customizing PeopleSoft delivered report designs according to user requirements for GL, AP, AR.
• Translate complex business requirements into functional and technical design specifications, taking into consideration usability, performance and design standards.
• Modified Application engine programs delivered with PeopleSoft to add new custom fields, records to various sections in Payables, Receivables and Purchasing modules.
• Involved in giving security to messages and message channels in Application Messaging.
• Involved in setting up of Nodes and gateways and channels.
• Involved in the customizations and new development of business functionality using People Code for the GL, AP, AR, Billing financial modules.
• Involved in Production support, problem resolution and maintenance of current PeopleSoft AP, AR, GL, PO & Billing modules and checking the processes.

Environment: PeopleSoft 8.8/8.9 HCM/FCM, PeopleTools 8.42, PeopleCode, SQR, PS/Query, Process Scheduler, Application Engine, Component Interface, UNIX, Oracle, Windows XP.

Confidential, FL

Sr Systems Specialist (Techno-Functional Lead)

Responsibilities:

• Primary contact for payroll process/support.
• Implement, Upgrade and customization of PeopleSoft HRMS 8.8/7.5/6x(HR, Payroll, Benefits Administration).
• Responsibilities include business analysis, development of Reports, Interfaces, Testing and Functional, Technical documents.
• Involved with Functional team to gather specifications and information in designing applications and reports.
• Involved in design of new SQR reports and customize PeopleSoft delivered reports according to user requirement.
• Extensively worked on several Peoplecode events for customizations, validations, calculations and error handling required as per the business requirements.
• Involved in fit/gap analysis. Designed Automation of Leave Process Application.
• Involved in HR, Payroll and Benefits process Walk-Thru's. Used Utilities for creating the message catalog entries and also Record cross-references. Customized Pages as per the specification. Search record dialog boxes have been modified by modifying record definition and enabled security to the new pages.
• Extensively used PS/Query to develop ad-hoc queries, generate crystal reports and to produce analyzing reports using Excel.
• Developed Component Interface in order to integrate with third party tools. Scheduled to run processes at a specific time and/or run recursively at a specific interval using Process Scheduler. Used Process Monitor to view status of the processes.
• Developed and Implemented testing methodologies, strategies, test specifications, test cases, test scripts, test matrices, test validation, test execution as per the requirement. Involved in troubleshooting, fixing bugs and problems in HR, Payroll, and Benefits Administration.
• Extensively used Component Interface/Message Definition to develop HR Web, a self-service application. Customized the e-pay functionality to the business requirements. Developed several App Engine Programs for HR/ Compensation.
• Worked as a backup resource for Application Server configuration during upgrade.
• Worked extensively with configuration manager for various trace set-ups. Provided quality assurance on conversion programming and application configuration.
• Involved in Implementation, analysis and design of Enhancements/Customizations for AR, BI, GL, EX and AP Modules.
• Customized SQR and Crystal reports like AP Trail Balance Report, Pending items, Aging reports and Invoice printing.
• Developed Conversion Programs to load data from Legacy system to PeopleSoft tables and Interface programs.
• Used various Component Interface and Application Engine programs to load Roles of various users, loading of vendor data in AP module etc.
• Developed Application Engine to load Rate Template in Projects Costing.
• Worked on Integration Broker setup for Tools 8.48 and application engine Program (PC TL TO PC) from Time and Labor to Projects Costing.
• Worked with SQL Tuning team to tune processes like AR Lockbox, AR Payment predictor, AP Voucher Build.
• Developed the Balance Sheet, Budget Comparison Report, Income Statement and Trial Balance Report in GL using nVision.
• Developed SQR’s such as Loading GL Accounts from flat file into customized tables.
• Setting up of Integration Broker Integrations and WF Applications in Expenses modules.
• Did Channel setup and involved in bouncing PUB/SUB servers for Integration Broker.
• Involved in setting up of Service Operations and Routings.
• At the time of debugging turned off the integration broker from EX application package people code and just tested workflow to identify the problems.
• Also used Integration Broker in loading credit card data from flat file into Expenses.
• Did setup the routings and security in Integration Broker.
• Configured nodes, messages, queues and routings in Tools 8.48.
• Involved in setting up of Messages and also analyzing the XML generated from it.
• Involving in writing user test cases and also investigating Billing, AR interfaces failures and identify the root cause for failure and take necessary steps to fix the issues.
• Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR and effective use of Integration Broker (Application Messaging).
• Production support for day-to-day activities of PeopleSoft Contracts, Time and Labor, Projects, AR/Billing, and GL users.

Environment: PeopleSoft 8.8 HRMS/FSCM, PeopleTools 8.42, Unix, Oracle 8.3