PROFESSIONAL SUMMARY:

• 9+ years of experience in wide range of PeopleSoft Financials/SCM modules & HCM including Accounts Payable, Accounts Receivable, Core HR, Benefits, Payroll, ELM & TAM.
• Strong experience in technical role and good functional understanding during implementations, upgrades, interfaces reports development, conversion, migration, production support, operational procedures, scheduling, performance tuning, Application development and database solutions.
• Strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, Process Scheduler, PSQuery, Data Mover, Security Administrator), File layout, SQR (Inbound and Outbound Interfaces), and publisher (BI, XML).
• Expertise in the Fit - Gap Analysis, Design, Development, User Acceptance Testing, Conversion, Integration and User of PeopleSoft Financials and Supply Chain modules.
• Expertise in Legacy Systems Data Conversions using SQR, Application Engine, Component Interface, File Layout, and Excel to CI, SQL/ PLSQL
• Expertise in developing interfaces, both outbound and inbound with 3rd party systems using SQR, Application Engine, Component Interfaces, File Layout and Excel to CI.
• Extensive knowledge and experience developing and customizing of PeopleSoft Reports and Interfaces like SQR, Crystal Reports, n/Vision, PS Query, Publisher (BI, XML), and Application Engine.
• Familiarity with the Software Development Life Cycle (SDLC).
• Expertise in Interfaces, Conversions, Customizations, Reporting, Migrations and Performance Tuning.
• Proficient with People Tools, PeopleCode, Application Engine, SQR and Reporting Tools.
• Production Support and System support during System testing and User Acceptance testing.
• Resolve data quality issues and day to day production issues.

TECHNICAL SKILLS:

Operating Systems: Mainframes, UNIX Windows 95/98 and NT, Windows2000, Windows XP

Languages: SQL, SQR, PL/SQL, C and People Code

PeopleSoft: PeopleSoft Financials and Supply Chain

Database: SQL Server, Sybase, Oracle, ODI, MS Access

People Tools: People Code, Application Messaging, Application Package, Application Class, Application Engine, AWE, Workflow, Component Interface, File Layout, EDI Manager, Security, Process Scheduler, Portal, Tree Manager, and Data Mover

Data Mgmt Tools: Data Mover, Component Interface, Application Engine, Informatica ETL.

Reporting Tools: SQR, Crystal Reports, nVision, PS Query manager, Publisher (BI, XML)

Financial Modules: General Ledger, Accounts Payables, Billing, Accounts Receivables, eProcurement, Purchasing

HCM Modules: Core HR, Benefits, Payroll, TAM & ELM

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Techno Functional Consultant

Responsibilities:

• Developed Design Documents, Functional documents, and Unit Test cases for the custom Fields, Records, Pages and Components related to setting up the Organization Process for Acquisition Load, Mass HR Changes and Positions Updates Interface.
• Developed Integration Broker objects like Messages, Service Operations, Services and adding to the Queue for the Organization Process for Acquisition Load, Mass HR Changes and Positions Updates Interface.
• Developed Application Engine Programs for Staging the data, Hierarchical data and Loading the data related the Organization Process for Acquisition Load, Mass HR Changes and Positions Updates Interface.
• Developed Custom BI Publisher Reports for the Acquisition Load, Mass HR Changes and Positions Updates.
• Developed BI Publisher Reports for Comp Segment module.
• Helped the PeopleSoft Administration Team with running the Audit Reports like System Audit, Data Designer Audit and Alter Audit for the maintaining the Integrity of the system.
• Worked on executing the SQL and DMS Scripts for PeopleTools Upgrade.
• Defined the system testing and integration procedures for System testing and User Acceptance testing.
• Created test scripts and test scenarios based on the functional and the technical specifications.
• Supported the End Users during the User Acceptance Testing phase.
• Resolved critical, high and low issues as part of the production support.
• Provided support and resolved end user issues, such as data quality issues and day-to-day issues.
• Run pre and post migration compare reports as part of the PeopleSoft project migration.

Environment: UNIX, PeopleSoft HCM 9.2, People Tools 8.55.13, IBM DB2, IBM

Confidential, Pittsburgh, PA

Sr. Techno Functional Consultant

Responsibilities:

• Develop technical specifications based on the Business requirement document for Conversion, Interfaces, and Online Enhancements as part of the Asset Management, Contracts and Purchasing Implementation.
• Build Conversion and Interface Programs using Application engines and Component Interfaces for Procurements Contracts (VCM) and Purchasing.
• Developed Data Mapping documents for conversion of PeopleSoft contracts.
• Developed Digital Mailing Front Outbound Interface from PeopleSoft to Mainframes.
• Customized the delivered Material Picking Plan Report to maintain additional information from the Sales Order Report..
• Link the existing Procurement Purchase Orders in PeopleSoft to link them to the Procurement Contracts that are converted into PeopleSoft from VCM Database (Vendor and Content Management).
• Develop technical specifications based on the Business requirement document for the Issues/Enhancements and Defects as part of the Production Support.
• Developed Custom Voucher Automation Process using Application Engine to interface the Invoice Information from Documentum into PeopleSoft Accounts Receivables, from CONCUR to PeopleSoft Payables.
• As per requirement customized the BillingInterface.
• Modified the custom GL to Hyperion PeopleSoft process to provide the Projects Information to Hyperion for Forecasting and Budgeting
• Modified the delivered Voucher Workflow Comments Link in Accounts Payable and Length of Comments Field in Accounts Receivable per the client requirements.
• Fine-Tuned the delivered and the custom and delivered batch processes, queries and online pages as part of resolving the performance issues.
• Resolved online performance issues related to Vouchers with multiple lines.
• Created Indexes, rewrite queries, perform explain plan and identify the cost and tune the SQL using SQL Developer/Toad tools.
• Customized the requirement for the Mandatory Input of the department for each asset.
• Enable the hidden asset management fields on the requisition page to be used in creating assets.
• Customized the deliver templates used within the Asset Management for mass update of departments, locations etc.
• Developed summary, detail and comparative financial reports using PeopleSoft nVision.
• Implemented App Engine/ file layout interfaces for journals upload and EDI for vouchers.
• Developed functionality in PeopleSoft online for the business users to have the ability to maintain that accounts related to the Asset account table from the front-end.
• Developed Image Invoicing functionality.
• Developed queries/crystal, nVision report layouts, report requests, report books and scope definitions and also developed cross tabular reports using Crystal where PS nVision could not be used to develop the reports as there are certain limitations to nVision.
• Designed and developed the summary and the detail trees for the reporting.
• Developed custom ledger templates, defined ledger sets, configured the ledgers for a business unit as a part of the ledger and summary ledger setup.
• Developed daily, month to date, year to date and inception to date Profit and Loss Statement and Balance Sheet reports for Operations.
• Implemented AWE for voucher approval and customized the approval process.
• Hands on experience in Business intelligence publisher(XMLP/BI) and related content.
• Developed custom Reports for the PeopleSoft Financials.
• Defined the system testing and integration procedures for System testing and User Acceptance testing and presented it to the end users
• Worked with Accenture offshore team, handled a group of 6-7 people. Conducted daily scrum calls to check the status and also assigned work based on the requirement.

Environment: UNIX, PeopleSoft 9.2 (Financials & Supply Chain), People Tools 8.54, Oracle (12c), SQL Developer, Stat.

Confidential, Columbia, SC

PeopleSoft Techno-functional Consultant

Responsibilities:

• The project involved implementation, customization of PeopleSoft HCM (HR, Payroll, and Benefits).
• Gathered requirements, designed, developed and tested application enhancements.
• Played key role in development of Interfaces using SQR’s, Application Engine.
• Developed custom reports using SQR and XML Publisher.
• Created custom approval process using Application Workflow Engine (AWE) for terminations.
• Designed and developed an SQR process to generate files, containing all checks issued and reversed, to be used for Account Reconciliation.
• Developed an Application Engine program to generate a file (biweekly or annual) containing hours worked in Terminals to be used for staffing and budgeting purpose.
• Developed an automated process to calculate and load adjusted salary used to determine life and disability benefits for commissioned employees using Application Engine and Component Interface.
• Created a SQR process to load the file containing Short Term Disability monthly payments from Hartford. Developed custom objects to store short-term payments made to employees.
• Resolved various issues with Time Admin runs.
• Designed and developed a custom process to enroll employees in Time and Labor using Application Engine.
• Developed a Reconciliation process to report variances between Reported time and Payable time using SQR.
• Created Test scripts and executed various test cycles for System testing and parallel testing.
• Developed custom reports needed per the client requirements using PS Query.
• Worked in a Production Support role to resolve issues related to Payroll processing.
• Provided quality documentation including Design Documents, and Test Scripts.

Environment: HRMS 9.2, People Tools 8.53, SQR, Oracle 11i, Windows NT, UNIX, Toad.

Confidential, St. Louis, MO

PeopleSoft Technical Developer

Responsibilities:

• Involved in the PeopleSoft implementation and production support of Version 9.1 for Core HR, Payroll, Benefits and Benefits Administration
• Involved in data analysis and data conversion during the upgrade of the person model.
• Created/Customized/Modified Records, Pages, Components and Menu definitions as per the client requirements using Application Designer.
• Modified/Customized the existing Application Engine & SQR programs as per the table changes of 9.1 without affecting the existing functionality.
• Developed SQR reports and interfaces for Benefits, HR, Payroll, which have data of new hires and changes to certain HR/Payroll data & to generate flat files to be sent for third party.
• Retrofitted Annual Enrollment Process. Designed and customized various Employee Self Service Pages and Benefits Audit Reports. And got recognized for Best Performance.
• Customized and pages to populate data into Custom tables PS SC HRS EDU INFO and PS SC HRS .
• Developed custom PS Queries to enable Benefits Functional Users to identify specific employees.
• Created a new page where the user can enter his/her Schedule for the entire Week. This page will save the data into SCH ADHOC DTL with the help of a new work/derived record. Also added different functionality and validations for this page.
• Implemented Component Interface based Web Services for Integration broker between HR and Finance for Payroll Accounting Entries.
• Developed rules using delivered templates like Holiday, Shift Premium, Period Threshold, and Weekly Threshold and customized new rules as per the client requirement.
• Developed Custom Interface Programs using Application Engine and file layout to validate and then Load Time data from Flat files into Rapid time table.
• Retrofitted custom People Code programs according to the new table changes.
• Developed new Component Interfaces, Application Engine programs for FRS (Fidelity) system.
• Defined Exceptions for the reported time and created custom error/warning messages in message catalog.

Environment: PeopleSoft HRMS 9.1, People Tools 8.50, PS Query, SQR, SQL, Oracle 11g, JCL, Citrix (Remote Access), Lotus Notes, Data Mover, Change Assistant, Component Interface.

Confidential, Washington DC

Sr. Techno Functional Developer

Responsibilities:

• Developed technical specifications and built the process using application engine and PeopleCode for the inbound and outbound interfaces between the PeopleSoft and the Maximo for the Purchasing, Requisitions, Receipts, Vendors and GL Journals Integration based on the Functional requirement document and presented it to the end users.
• Developed the technical specifications for the conversion of the existing projects, project activities, and project budgets, open purchasing documents, budgets, GL balances currently in the PeopleSoft financial database.
• Created new receipts and new Purchase Orders thru Component Interface for the corrupted Purchase Orders.
• Created technical specifications and built the online vendor attachments, vendor performance bench marking, online vendor spending limits and vendor complaints to be added at the vendor level.
• Customized the delivered Purchase Order and Maintain Requisitions components/pages to maintain the status fields and Hold process flags as part of the integrating the Maximo system to PeopleSoft.
• Developed control reports, error reports and reconciliation reports for the interfaced and converted data.
• Developed custom reports, which lists the details of Purchase Orders across various modules.
• Created new reports using PeopleSoft XML Reports tool.
• Fine-Tuned the delivered and the custom and delivered batch processes, queries and online pages as part of resolving the performance issues.
• Worked through the entire upgrade process, including the completion of all testing and bug fixes. Worked in project teams on all aspects of the SDLC.
• Developed processing EDI invoices into PeopleSoft for more than one Business Unit
• Setup and maintain workflow for various MSS transactions using AWE
• Created Indexes, rewrite queries, perform explain plan and identify the cost and tune the sql using SQL Developer/Toad tools.
• Use datamover scripts to back up and restore security for lower environment during refreshes from production environment.
• Migrate Roles and Permissions lists between various databases using projects in Application Designer and/or datamover scripts.

Environment: Maximo, UNIX Servers, PeopleSoft FSCM 8.9 / 9.1, STAT Migration Tool & Autosys.

Confidential, New York, NY

Responsibilities:

• Gathered requirements and prepared the Business requirement document (BRD).
• Developed technical specifications based on the Business requirement document (BRD).
• Performed data mapping of the external systems to PeopleSoft data.
• Developed user based online PeopleSoft mapping rules pages for the interfaces and presented it to the end users.
• Developed interface program to load the mapping rules from the external files from QCare Claims system.
• Developed SQR program, which is executed on the remote applications (QCare) to improve the performance.
• Analysis of requirements, Design of specifications for Data Conversion, Online, batch Interfaces.
• Implemented App. Engine/File Layout interface for journals upload and EDI for vouchers. Setup security with Users, Roles, Permissions, user ps, Procurement controls.
• Developed application engine program to extract the Confidential data from PeopleSoft expense data to generate the file to be sent to the American Express and presented it to the end users
• Assist and provide guidance in setting up workflows for various transactions in Approval Workflow Engine (AWE)
• Supported the End Users during the User Acceptance Testing phase.
• Designed the nVisionreport from scratch in General Ledger (GL) module for one of the GL month end processes.
• Modified existing custom nVision reports
• Work with Identity Management team in creating/setup PeopleSoft integrations with OIM including integration broker, web profile set up, data confidentiality and message channel customizations
• Analyze and modify Integration Broker message channels to restrict PII information from being transferred out of HCM database
• Customized PeopleSoft delivered Posted Voucher Listing Crystal report APY1020.rpt for AP module.

Confidential

Responsibilities:

• Performed the data analysis and data mapping and designed and documented the conversion /interface /Report documents.
• Documented and designed the technical specifications for interfaces/data conversion and validation.
• Developed conversion programs, control reports, validation/reconciliation reports and custom reports, also wrote the SQL scripts for the data cleanup and re-sequencing and presented it to the end users.
• Developed and modified the production control reports which help in identifying the data integrity in the PeopleSoft tables.
• Generated error reports/files during data conversion as a part of the conversion process to handle the errors and send them to the users for cleaning/evaluation purposes.
• Incorporated the restartability logic in the conversion programs.
• Participated in Payables and Receivables configuration according to the Global multi-currency requirements.