SUMMARY

• Over 8 years of professional work experience as PeopleSoft Technical consultant in PeopleSoft Finance/ HRMS domain.
• Strong experience working on ERP implementation, upgrade and support methodology and quality processes benchmarked.
• Member of their production support team for PeopleSoft FSCM 9.1 and HCM 9.1 systems while working on the upgrades. FSCM 9.0 to 9.2, PeopleTools, then HCM 9.0 to 9.2, PeopleTools .
• Analyzed Human Resources/ Core HR/ Time & Labor/ NA Payroll/Benefits/ Time and Labor/ TAM/ ESS/ MSS business processes work with business owners to achieve consensus for business process changes, and facilitate transition to best practices as supported by PeopleSoft HCM 8.9, 9.0, 9.2.
• Extensive work experience with People Tools such as Application Designer, Application Engine, Component Interface, People Code, Application Packages, File Layouts, Integration Broker, Approval Work Flow (AWE).
• Involved in design, development and testing of PeopleSoft modules General Ledger, Accounts Payable, Purchasing, supply chain management, Accounts receivable, eProcurement, eSupplier, Strategic Sourcing, Asset Management, Account Receivables, Billing, Inventory and Order Management.
• Experience on the Analysis (Fit - Gap), Design and Development of PeopleSoft Financials.
• Extensive knowledge on Data migration scripts.
• Worked in a variety of engagements involving all phases of SDLC such as system study, analysis, design, development, testing and implementation.
• Proficient in the creation of complex reports using SQR, XML Publisher / BI Publisher and Crystal Reports.
• Data conversion experience for FSCM modules (AP, GL, AR, BI, PO, IN).
• Setup the Test Control-M environment for PeopleSoft Financials.
• Developed complex reports using SQR, Application Engine, Crystal reports, PS Query and nVision with macros.
• Providing change management using Phire to promote customizations in the development life cycle path to production (go-live) for FS, CRM, CS, HCM, and Portal.
• Involved in end-to-end project life cycle, starting from initiating the kick-off meetings, Knowledge Transition, documentation, support levels, effort estimates, coordination with the client team to ensure quality of deliverables.
• Experience in fine-tuning the business processes across modules.
• Knowledge of best practices followed in IT industry in software development life cycle.
• Ability to work independently and in a team environment and interested to learn new technologies and emerging standards and have the ability to learn quickly.
• Good PeopleSoft technical knowledge and a sincere passion for resolving complex problems and business challenges through technical innovation/ treble shooting.
• Worked in membership Summary reports and Custom Benefit offset pages.
• Excellent Communication and Presentation skills.

TECHNICAL SKILLS

ERP PeopleSoft: PeopleSoft Tools Application Packages, AWE, Application Designer, PeopleCode, Application Engine, Change Assistant

Peoplesoft Tools: HRMS 9.2/9.1/9.0/8.8/8.4

PeopleSoft Modules: NA Payroll, Benefits, Benefit Administration, Time & Labor, TAM, WorkForce Admin, Absence Management, ePay, eBenefits, Candidate Gateway Account Payables, Account Receivables, General Ledger, Contracts, Projects, Inventory, Order management, Billing, Purchasing and Asset Management, Maintenance Management and ePro, PeopleSoft Enterprise Portal, ELM

Reporting Tools: XML Publisher, SQR, PS Query, Crystal Report, nVision.

Debugging Tools: SQL Trace, People Code Debugger, Application Engine Trace

Integration Tools: File Layout, Component Interface, Integration Broker, Application Messaging

Databases: Oracle 9i/10g, 11i, SQL Server, DB2.

Databases: Oracle 9i/10g, 11i, SQL Server, DB2.

Languages: SQL, PL/SQL, C, C++, Java.

Data Management & Batch Processing Tools: Data Mover, Application Engine, Import Manager and Process Scheduler, Data Archive Manager

Administration Tools: Portal Administration, Object Security, Workflow Administration and Query Security, STAT

Development Tools: Visual Basic 6.0, TOAD, SQL Navigator.

Operating Systems: Windows, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

PeopleSoft FSCM Techno Functional Consultant

Responsibilities:

• Developed functional flow diagrams for all customizations, which will be more useful to the users to understand the flow of the customizations.
• Performed requirement gathering, fit-gap analysis, design, development, Testing and documented processes.
• As a PeopleSoft Techno functional & Security Architect, Leading Finance Security for PeopleSoft Finance 9.0 to 9.2 upgrade with Fluid Framework for PeopleSoft application.
• Designed the technical design documents and maintained entire document repository containing Test Case documents, Test Plan output, Backup/BackOut Data Plan (For data issues).
• Established Excellence in Service Delivery standards (ESD) for HRIS/Payroll Services.
• Developed integration services using Integration Broker between PeopleSoft HR Time and Labor and PeopleSoft Financial Project Costing.
• Converted PO's, Vendors, Assets and accounts using SQR'S and ExcelToCI.
• Developed Sales Tax, Non Matched voucher line XMLP reports as per client's requirements.
• Customized PeopleSoft delivered Benefits Online Enrollment letter, Confirmation letter and Self-service pages (eBenefit) as per new Open enrollment setup.
• Worked on Time and Labor support and enhancements (which include various customizations to the delivered TL process) as per business requirements.
• Designed/Developed PO workflow as per clients requirements.
• Provided technical training on oracle RDBMS, PeopleTools, System Administration, Programming and general understanding of PeopleSoft.
• Customized workflow for AP as per client's requirement.
• Developed custom App Engine to register supplier and give them access to eSupplier.
• Good understanding of eSupplier Module.
• Developed custom module called eCap for Capital Gains Project.
• Established Excellence in Service Delivery standards (ESD) for HRIS/Payroll Services.
• Defined Supplier and Employees as Vendors and converted the data using ExcelToCI.
• Involved in Production Support of AP, PO, AR& BI modules.
• Designed, Developed and implemented Transcepta interface to automate the vouchers into AP.
• Absence Management integration with NA Payroll and Global Payroll for Unpaid days.
• Developed custom Application Engine to read the 3rd party xml file and creates the quick invoice.
• Worked on customizations in Purchase order dispatch process using XMLP.
• Resolved issues with AR UPDATE Process
• Developed custom inbound process using Component Interface and File Layout for Vendor component to import data from 3rd party system.
• Customized AP check printing process using XML publisher.
• Worked in Production Support Team to resolve SQR, People Code, Application Engine issues.
• As per requirement Customized the Billing Interface.
• Gathered Requirement for Asset Conversion using ExcelToCI
• Designed and Developed Interface to Capitalize Assets for Project Costing.
• Designed, Developed and implemented Procurement Card for Purchasing module.
• Customized PO CCLOADLD and PO CCPRCRDSTG Application engines for Procurement Card

Environment: Windows XP, PeopleSoft Financials 9.0/9.2(AP, PO, eSupplier, eprocurement, AR, BI, AM & PC) People Tools 8.50/54, HRMS, HRIS, People Code, SQR, Application Engine, CI, Integration Broker 9.1, RDMS, XML Publisher, Oracle 10G and Oracle 11i.

Confidential, Palo alto, CA

PeopleSoft Financial/ FSCM consultant

Responsibilities:

• Lead on Analysis and Design of customizations, conversions and interfaces.
• Converted Vendors, Assets, Items and Accounts using ExcelToCI and SQR.
• Converted Employees, Suppliers as Vendors in AP using ExcelToCI.
• Converted Vouchers from legacy systems using ExcelToCI and Integration Broker.
• Designed and developed Voucher approval rules in Voucher Approval Workflow.
• Configured and developed Payment Processing (ACH, EFT, SWIFT and Positive Pay) and Bank Reconciliation rules.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• Simplify data maintenance and administration using people tools.
• Developed and managed Payroll Interface processes to external Payroll and Benefits vendors.
• Conducted Fit/Gap Analysis for ACH & SWIFT Payments and creating AM Distribution Line for Voucher Adjustment.
• Analyzed and customized PayCheque Crystal Report and Positive Payfile format as per Bank of America, Wells Fargo and Wachovia.
• Designed and Developed Currency Interface to load Currency rates from Bloomberg into RT RATE TBL.
• Configured Integration Broker for Voucher Upload and profiles for various Assets.
• Customized Fin2025.sqc, Fineft94.sqc, Fineftsw, and Fineft20.sqc for ACH and SWIFT Payments as per Clients requirement.
• Performed Fit/Gap analysis for converting Ledger Balances. Designed and developed the conversion process.
• Designed and Developed interfaces to load Travel & Expense data, Capitalize Assets and to send payment details to Amex.
• Designed and Developed Retirement of Asset Report and Depreciation Report Using SQR.
• Designed and Customized PeopleSoft Delivered GL Open Close Accounting Period Page to accommodate the search and update wide range of accounting periods.
• Designed and Customized the Vendor Page in Vendor Component to attach multiple files.
• Used Financial Gateway for Voucher Payments and Bank Reconciliation.
• Customized the Application Package for Bank File Format(BOA - EDI820 Format)
• Customized PC AM Process to populate Due Date in Project Resource Table and to blank out unused Chartfields.
• Customized PCIntfcEdit process to put custom edit rules.

Environment: Windows XP, PeopleSoft Financials 8.9/9.1(AP, PO, AR, BI, AM, PC and GL) People Tools 8.49/8.52, People Code, Application Engine, CI, Integration Broker, Financial Gateway, Approval framework, XMLP, LDAP, Microsoft sql server 2008/2012.

Confidential - Boston, MA

PeopleSoft HRMS/ Technical Consultant

Responsibilities:

• Working as a Senior Technical Team member for Upgrade PeopleSoft HCM 9.1 from PeopleSoft HCM 8.9.
• Involved in requirements gathering and write specification for converting data from PeopleSoft 8.9 to PeopleSoft 9.1.
• Help in Implementation of sPro Module. Create Test cases for the sPro Module.
• Convert Crystals to BI Publisher and develop new BI Publisher reports.
• Perform Fit Gap Analysis based on the current and new PeopleSoft System for all the modules including GL, AP, eProcurement, sProcurement and Security in Financials using Agile methodology. Review the fit gap documents with business before finalizing
• Involved in Troubleshooting the peoplecode at the page, component, record field levels.
• Develop programs to transform data from PeopleSoft 8.9 to PeopleSoft 9.1
• Ensure the tasks is delivered on time and produce high quality deliverables.
• Involved in Resolving day-to-day production tickets in HR and Payroll.
• Involved in resolving day-to-day production tickets in eBenefits (Benefits enrollment, Health plan, Saving Pan and Dependent and beneficiary).
• Developed Time and Labor rules using Template built rules and SQL Objects.
• Retrofitted HR and Payroll based on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Created and maintained Benefit programs, Earnings, Deductions, Absence Take and Accumulator elements and calculation rules configurations.
• Worked on Time and Labor Employee and Manager Self Service.
• Designed and Developed Inbound Interfaces and processing procedures for processing and Loading Employee Benefits, Deferred Compensation, Loan and 401K Contributions and Vacation Buy and Health & Welfare information into PeopleSoft Tables.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Pay confirm, Tax Tables etc.
• Involved in running weekly and biweekly and Monthly payroll with functional team and error solving.
• Applied tax updates and Retrofitted customizations after each tax update.
• Worked on Data Mover Scripts(DMS Scripts) on HR and Benefits tables to validate in different environments
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Developed data migration strategies to load DB2 tables and convert Oracle data formats to DB2 using COBOL, SQR, SQL, Data Mover, DB2 Load, Copy, and Runstats Utilities.

Environment: People Tools 8.46, Peoplesoft HRMS/HCM (7.5/8.8/8.9), People code, SQR, Workflow, Integration Broker, File Layout, Application Engine, Component Interface, Data Mover Oracle 9.1.

Confidential

PeopleSoft HRMS Developer

Responsibilities:

• Worked on Interface of Benefits administration with Payroll.
• Also worked on SQR to populate election and coverage tables as per clients need.
• Was involved in developing reports and audit tables for employees with Family status change (FSA)
• Also developed programs to call the Application Messages and Component Interfaces from the Application Engine programs.
• Involved in Designed and developed Interfaces to enable the users to search for required data from external applications in a Synchronous mode.
• Designed and developed various Application Messages to publish data from PeopleSoft to other applications in an Asynchronous mode.
• The response messages were received using Subscription Messaging.
• Designed and developed Component Interfaces to populate the PeopleSoft database with data received from external applications.
• Created custom Application Engine programs to synchronously create user accounts in the Portal Database for new employees.
• Worked with Interface report on confirmation/worksheet file layout.
• Also was involved in running processes in Unix OS using shell scripts.
• Involved in keying the dependents and running the validation process before generating Interface.
• Worked on Interface for retiree employee letter.
• Also worked on QMSCO flag report, indicating the termination period of employees from the benefits.

Environment: PeopleSoft HRMS 8.3 (HR, Base Benefit, Benefits administration, pensions administer), Windows NT, Unix, App Messaging, Application Designer, PIA, People Code, SQR, SQL, PS/Query.

Confidential

Peoplesoft Technical Consultant

Responsibilities:

• Worked in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Time and Labor.
• Involved in writing App Engine Programs that which uses Component interfaces in order validate the components like Employee General Deductions and Additional Pay.
• Involved in finding and fixing the errors that were came out from the conversion programs which includes App Engines and Component Interfaces.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees' information after each day and load them into the PeopleSoft tables.
• Worked on interface programs for migrating data from other systems to People Soft.
• Also involved in acquiring Specifications from the functional team and modifying the SQR's as per the SPECS.
• Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• 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.
• Worked on Integration broker on messaging services to link PS HCM and third party applications.
• Retrofitted and performed end to end testing of SQR's to meet the functionality of new release.

Environment: PeopleSoft HRMS 8.8, People Tools 8.4x, Core HRMS, NA Payroll and Time & Labor.