SUMMARY:

• 14 years of IT experience with more than 12 years of PeopleSoft HRMS/HCM (Recruitment, Human Resources, Base Benefits, Benefits Administration, Payroll, Time &Labor, Global Payroll & Absence Management, eRecruit, eProfile, ePerformance, eBenefits, ePay, eCompensation, ESS, MSS, Open Enrollment), and Financials/SCM (GL, AP, PO, AR, BI, AM, BD, KK, eProcurement, INV, Contracts, Expenses, Project Costing, Travel &Expenses); PS Enterprise Portal implementation, upgrade/development, and testing experience, with nearly 10 years of PeopleSoft 8.0/8.1/8.3/8.4/8.8/8.9/9.0/9.1 experience.
• Worked as Team Lead in different Projects with very good team co - ordination skills.
• Assisted functional analysts in developing business solutions by providing technical details required during Fit-Gap Phase. And also involved in converting Fit-Gap analysis exercise into Techno-Functional Specs.
• Involved in checking of the technical feasibility of the recommended solutions by the functional team.
• Very good at interacting with users and discussing about different PeopleSoft business issues, and the gathering business requirements, and translated them into to Techno-functional specifications.
• Very good functional flow knowledge and setup experience with proper table loading sequence in PeopleSoft HRMS/Financials /SCM modules implementation or upgrade implementation.
• Very good at Analysis, design, data modeling, build and implement custom applications from scratch, as required.
• Developed many Process flow diagrams, using MS Word, MS Visio, to clearly highlight the various business components involved, and the integration points between them.
• Participated in peer-to-peer design/code review, to ensure quality of the techno-Functional Specs and also the developed technical deliverables.
• Involved in data mapping, and designed many Data Conversion and Interface Programs between PS and non-PS applications using Integration Broker, SQR, App. Engine, Component Interfaces, and Excel-To-CI tools.
• Very good at developing new applications from scratch /customizing existing applications using Application Designer capabilities, PeopleCode, Workflow and other People Tools.
• Good at PeopleSoft Application Integration technologies like Component Interfaces, Application Messaging, and Business Interlinks.
• Developed many reports using PS/Query &Crystal; and SQR, including dynamically changing output-generating reports using SQR methods like Break Logic, Load-Lookup, Arrays, Multiple reports, and Form reports, Printing Logos etc.
• Experienced in PeopleSoft Upgrade and expert in using Application Designer, Upgrade Assistant, Data Mover, and also Quest Stat to migrate data between different environments.
• Very good in debugging, analytical thinking, error fixing, testing, and Performance tuning of the code.
• Involved in test plans &scenarios development, and in actual unit, system integration, performance and regression testing of various on-line application components and reports developed /upgraded.
• Provided technical expertise in migrating enhancements and new functionality to production environment.
• Involved in Updates &Fixes; Production and post-implementation support. And also provided Techno-Functional support to address any production issues/bugs and enhancements.
• Involved in addressing the issues with PeopleSoft Security related to Users, Roles, Permission Lists, Password related, Object and Query Security.
• More than 2 years experience in development of Oracle Client/Server applications, on UNIX platform. And got trained as Oracle 10g database administrator. Also got trained in data warehousing technologies.

TECHNICAL SKILLS:

Industries: Federal Government, Insurance, Mortgage Banking, HealthCare, Higher, Telecommunications, Energy, Utilities, Manufacturing, Trading, Shipping, Advertising, Technology Development.

ERP Tools: PeopleSoft 9.1/9.0/8.9/8.8/8.4/8.3/8.0/7.5/7.0/6.0/5.1 Financials/SCM and HRMS/HCM

Development Tools: Application Designer, Application Engine, and People Code

Administration Tools: Configuration Manager, Tree Manager, Process Scheduler, Process Monitor, Report Manager, Upgrade Assistant, Security Administrator, and Utilities.

Integration Tools: Integration Broker / Application Messaging, Work Flow, Approval Workflow Engine (AWE), Enterprise Portal, Component Interfaces, Business Interlinks, and EDI Manager

Data Management Tools: Import Manager, and Data Mover

Reporting Tools: SQR6.0/4.3/3.0, BCS SQR Express, Micro Focus 3.2/4.1 Cobol, CRYSTAL5.0/8.0/8.5, PS/Query and PS/nVision

RDBMS: ORACLE 10g/9i/8.0/7.x, MS SQL Server, IBM DB2 V7.0, and Informix 7.2

Operating systems: Unix (HP-UX, AIX, SUN, SCO), OS/390 for DB2, Win'NT 4.0, and Win'2000

Languages: SQL, PL / SQL, SQR, Cobol, JCL, People Code, XML, HTML, C++, VB.

Database Tools: SQL Navigator4.2, Oracle SQL*Plus, DB2 Command Center, Quest Toad, SQL Server Query Analyzer

Other Tools: PVCS, Vista Plus, Control M, Stat v4.0.4, Visio 10.0, and SNAG IT 8.1/6.0/5.0, Beyond Compare, Hummingbird, Ipswich WS FTP Pro v9.01, Remedy 2010 v7.1.0, Lotus Notes

EMPLOYER/ASSIGNMENT HISTORY:

Confidential, Philadelphia, PA

Sr. PeopleSoft Technical/Functional Consultant

Responsibilities:

• Involved in PeopleSoft Fin v9.1/8.51 upgrade from PeopleSoft v8.9 including design, development, Unit and System Integration testing.
• Involved in the design and development of Interfaces as per the needs.
• Involved in the design and development of a status change Application Engine process with different options.
• Involved the design and development of a Template for the Interface running and scheduling.
• Involved in the design & development of new reports and other processes as needed.
• Involved in developing the data mover scripts to migrate data over to the other environments.
• Involved in the design and development of Management Self Service for the Managers.

Environment: -PS HRMSv9.1/8.51 HR, Time& Labor, Payroll of NA, ESS/MSS, Recruit Workforce, Resume Processing, Candidate Gateway, TAM, Succession Planning, eCompensation, ePay, ePerformance, eProfile; HRMS Portal Pack; Application Engine, Data Mover, PS/Query, PeopleCode, SQR, SharePoint, HP Quality Center10.00.

Confidential

Sr. PeopleSoft Technical/Functional Consultant

Responsibilities:

• Involved in Fit-gap Analysis for PeopleSoft HRMS v9.1/8.51 on 64 bit application, to identify any additions over v8.9.
• Involved in PeopleSoft HRMS v9.1/8.51 upgrade from PeopleSoft v8.9 including design, development, Unit and System Integration Testing.
• Involved in comparing the newly delivered objects with that of v89.
• Involved in the fit gap analysis.
• Involved in the design & development of new reports and processes as needed.
• Involved in using Quest Stat.
• Involved in developing the test scripts and test sets to test all the functional areas being use.

Environment: -PS HRMS v9.1/8.51 HR, Benefits, Time &Labor, Payroll; Oracle 10g, Quest Stat 5.5.5, Application Engine, Component Interfaces, Data Mover, PS/Query, PeopleCode, SQR, TOAD, SharePoint, HP Quality Center.

Confidential

Sr. PeopleSoft Technical/Functional Consultant

Responsibilities:

• Involved in the high level mapping of federal Office of Personnel Management (OPM) HR Line of Business requirements with the delivered PeopleSoft 9.1 application, to identify the required PeopleSoft modules (like HR, Self Service, Base Benefits, Benefits Administration, Compensation etc…) to satisfy the those OPM requirements.
• Involved in the HR Connect Fit-gap Analysis with US Treasury for PeopleSoft HRMS v9.1/8.51 on 64 bit application, to identify any deficiencies.
• Fixed some of the PeopleSoft HRMS v9.1/8.51 Configuration issues, in the process of identifying the solutions to the errors found in PeopleSoft 91 functionality testing.
• Involved in PeopleSoft HRMS v 9.0/8.49.11 production support Project including design, development, Unit and System Integration Testing.
• Involved in the design & development of new reports and processes as needed.
• Involved in developing new pages, components, menus, and portal objects as needed.
• Involved in using Quest Stat for the Production maintenance and migration of the PeopleSoft objects.
• Involved in resolving production issues logged in Remedy.
• Developed new SQR reports generating both .PDF and well-defined .CSV (most challenging and sought after) outputs.
• Improved performance of the existing reports and processes.
• Improved the usability of the existing reports.
• Involved in the design, development of new payroll report as well as modification of the existing Time & Labor reports.
• Developed some of the critical queries.
• Converted old design documents in WordPerfect format to a single Excel file with relevant columns.

Environment: - PS HRMS v9.1/ bit & 9.0/8.49.14 Recruit, HR, Payroll and Hours &Expenses (Time &Labor); Oracle 10g, Quest Stat 5.4.1, Application Engine, Component Interfaces, Data Mover, PS/Query, n/Vision, PeopleCode, SQR, BCS SQR Express, Beyond Compare 3.0.9, TOAD for Oracle Xpert v9.6.1.1, Ipswich WS FTP Pro v9.01, Remedy 2010 v7.1.0, SnagIt32 v8.1.0, Hummingbird, Win XP (Pro), UNIX, Red Hat Linux

Confidential

Sr. PeopleSoft Technical/Functional Consultant

Responsibilities:

• Involved in PeopleSoft Financials/SCM v8.4/9.0 Upgrade Project including design, development, Functional &Technical Specifications, Unit and System Integration Testing.
• Involved in the design and development of custom process.
• Involved in developing Conversion Process.
• Involved in creating custom interfaces.
• Involved in creating separate processes and report queries for Entergy.
• Involved in using Quest Stat for the maintenance and migration of the PeopleSoft objects.
• Involved in System Integration Testing using Test Director.

Environment: - PS Fin/SCM 8.4/9.0 GL, AP, PO, AR, BI, OM, INV; Oracle, Quest Stat 5.4, Integration Broker, Application Engine, Component Interfaces, Data Mover, PS/Query, n/Vision, PeopleCode, Crystal Reports, SQR, Work Flow, Test Director / Mercury Quality Center, WIN XP (Pro)

Confidential

Sr. PeopleSoft Technical/Functional Lead Consultant

Responsibilities:

• Involved in the Implementation of PeopleSoft Global HRMS v8.9 along with Upgrade/Merging of PeopleSoft NA v8.9 HRMS and Legacy applications from the acquired companies.
• Involved in the design, Data Mapping and development of an Interface Program between legacy and PeopleSoft Global HRMS.
• Involved in the design of an Interface Programs.
• Involved in analyzing the existing processes in PeopleSoft NA environment as a basis for the design and development of the interfaces for the Global rollout.
• Involved in design and development of the cross- mappings wherever required in the design of the interfaces between Global environment and the providers.
• Involved in design and development of reports.

Environment: - PS Global HRMS 8.9/ 8.47.15 , HR, Benefits, Payroll for NA, Time &Labor, Global Payroll &Absence Management, Ceridian, Oracle, Integration Broker, Application Engine, Component Interfaces, Data Mover, PS/Query, Crystal, SQR, WIN XP (Pro)

A Scientific Company

Sr. PeopleSoft Technical/Functional Lead Consultant

Responsibilities:

• Involved in the design, Data Mapping and development of an Interface Program between legacy and PeopleSoft HRMS and PeopleSoft Project Costing.
• Involved in the design and development of an Interface Program to send Foundation data.
• Involved in design and development of other Interface Program to send the transactional data.

Environment: - PS Financials 8.9/8.46.01 GL, AP, PO, Expenses, Project Costing; PS HRMS 8.9/8.46.01 HR, Benefits, Payroll, and T&L, ADP, Oracle, Integration Broker, Application Engine, Component Interfaces, Data Mover, PS/Query, Crystal, SQR, WIN XP (Pro)

Confidential, Glenwood, MN

Sr. PeopleSoft Technical/Functional Lead Consultant

Responsibilities:

• Involved in PeopleSoft Financials/SCM v8.9 Implementation Project including design, development, Functional &Technical Specifications, Unit and Integration Testing.
• Involved in the design and development of Lockbox process.
• Involved in the Confidential Process Implementation.
• Involved in generating the required XSLT for the Integration Broker Transactions.

Environment: - PS Financials/SCM 8.9/8.48.06 GL, AP, AR, BI, OM, INV; SQL Server, Integration Broker, Application Engine, Component Interfaces, Data Mover, PS/Query, Crystal Reports, SQR, XML, XSLT, Work Flow, WIN XP (Pro), IE 7.0

Confidential

Sr. PeopleSoft Technical/Functional Lead Consultant

• Message to a third party in-house system to process a drop ship Invoice.
• Created a new AE process to process all the rows inserted into the custom table. And to format it into a message using a new message definition created, to send it to the third part Sales system at REL.
• Involved in creating another AE, to fetch the Duty Tax value for each Inventory Item for the combination of TO and FROM Business Units, from an external system.
• Created another AE program to calculate the new transfer price by adding the Customs Duty, obtained from an external system.
• Created a new SQR -- to be called at month end to create journal entries for in-transit items.
• Customized the delivered SQR reports used at REL.
• Implementation of Approval Workflow Engine (AWE)
• Involved in the design and development of Work Flow Monitors.

Environment: - PS Financials/SCM 8.9/8.48.03 GL, AP, PO, INV; Oracle 9i, Application Engine, Component Interfaces, Data Mover, PS/Query, Crystal Reports, SQR, Work Flow, WIN XP (Pro), Robinet, Nextlinx, IE 7.0, MS Visio Pro‘2003

A Shipping Company

Sr. PeopleSoft Technical/Functional Lead Consultant

Responsibilities:

• Involved in the design &development of Functional and Technical specifications, to automate the current manual Inventory Picking process, by using the Bar Code Reader Scanners, with Test Plans and Procedures.
• Involved in the development of high-level Flow diagrams for the total automated process of the Inventory Process. And also developed separate Flow diagrams that can be used by the end users, to understand and follow the new automated Inventory Picking Process.
• Involved in design and development of Inventory Items data migration from different legacy systems into PeopleSoft, by creating custom Component Interfaces for the delivered Components that were called in the Custom Application Engine program, with the client specific business rules.
• Involved in customizing Reports as per the requirement of the Client and scheduled them to run on every Friday at 8AM, to send the reports as PDF attachments to the respective Buyer email account.
• Involved in the design and development of a report.

Environment: - PS Financials/SCM 8.8/8.46.04 GL, AP, PO, INV, AM; SQL Server, Application Engine, Data Mover, PS/Query, Crystal Reports, SQR, Work Flow, WINNT, IE/6.0, MS Visio Pro‘2003

Confidential, IL

Sr. PeopleSoft Technical/Functional Lead Consultant

Responsibilities:

• Involved in the Data mapping from various Legacy Systems to PS88 Financials and PS89 HRMS, by developing the Excel mapping spread sheets with automated PS/Queries developed to fetch the target PeopleSoft record definition details that will be mapped to the Legacy Source information.
• Involved in the design and creation of Custom Cross- tables with a good data modeling, Manual Data Enquiry &Cleaning Pages, components, and other related objects for the data conversion effort.
• Involved in developing the Data Conversion Programs.
• Customized /Developed many Application Engine Programs to load the Legacy application data into PeopleSoft
• Involved in developing the business analysis Queries and reports.

Environment: - PS HRMS/HCM 8.9/8.46.04 HR, BB, PY; PS Financials/SCM 8.8/8.46.04 GL, AP, AR, AM; Application Engine, Data Mover, Oracle9i (v9.2), PS/Query, Crystal, SQR, Toad, WINNT, IE/6.0, MS Visio Pro‘2003 (v 11.43).

Confidential, CT

Sr. PeopleSoft Technical Lead Consultant

Responsibilities:

• Involved in the configuration of the Integration Broker on both PeopleSoft CRM and PeopleSoft Financials, to send the Customers, Employees, Contacts data from CRM to Financials.
• Involved in providing the Menu Folder security and Content security, and also in assigning the Component Permissions and Page Permissions to access the objects created.
• Involved in creating custom Portal Page-lets to group the user specific reports based on the user roles and adding to the components and registering the page-lets by giving the necessary security access.
• Involved in running the delivered Portal Security Synchronization application engine process, to enable the portal security.
• Developed many Application Engine Programs to load the Configuration data.
• Developed DMS scripts to migrate the configuration data between the environments.
• Developed some new and custom reports and developed Time and Expense reports as well.
• Designed and developed multiple field values run control functionality.

Environment: - PeopleSoft CRM 8.80.01/ 8.44.03 , PS Financials/SCM 8.8/8.45.06 , Integration Broker, PeopleSoft Enterprise Portal, Project Costing, Travel and Expenses, AR, Billing, MS SQL Server 8.0, SQL Query Analyzer 8.0, CRYSTAL 9.0, WINNT, IE/6.0, MS Visio Pro‘ 2003 (v 11.43).

Confidential

PeopleSoft 8.8 Global Financials &HRMS Sr. Consultant

Responsibilities:

• Involved in the design /development of a custom Employer-Burden Interface program in eRecruit, using SQR to send a data file to GL as well as to generate a report detailing the contents of the file; And also to produces a second report that outlines benefits cost information by establishment.
• Involved in the design/development of eRecruit system to handle requisition Management and the job applications within the ATS (Applicant Tracking System) project as required by Capital One.
• Developed E-Mail Notification process, using Work Flow to send e-mails to the data owners as reminders, when they fail to submit their entire data.
• Developed data conversion and interface programs from PeopleSoft to Peregrine, an IT Asset Management application.
• Involved in the design and customization required to populate due date field in eProcurement, with value passed through extrinsic tag in punch-out order message from direct merchants.
• Involved in defining custom menu folders, child folders, content s, and content link definitions.
• Involved in setting up various portal alert pages and activating the required page-lets like Employee Performance alert page-lets.

Environment: PS 8.8 Global HRMS (HR, Global Payroll, T&L, ESS, MSS, eRecruit, eBenefits, eCompensation, ePerformance, Open Enrollment, eTrade), PS 8.4/8.8 Global Financials/SCM (GL, AP, PO, AR, BI, Inventory, Project Costing, Expenses and Contracts), PeopleSoft Enterprise portal, UNIX, Oracle, Control M, SQR 6.0, CRYSTAL 8.5 with Win XP, MS Visio10.0, Stat 4.1.8

Confidential

PeopleSoft Sr. Programming developer / Analyst

Responsibilities:

• Involved in the development of Functional/Technical specifications for ACH/EFT payment files to send to Confidential .
• Developed a program to convert legacy sales data to PeopleSoft Franchisee Billing Module.
• Involved in loading small data loads into PeopleSoft application components using Excel to CI Utility.
• Customization of delivered Invoice report as per the client's needs.
• Customized the AR32000 Query/Crystal as per the requirements of the client.
• Developed data conversion programs to convert legacy asset profiles data to PS Asset Management system.
• Developed AE Interface Programs to calculate Pizza Hut Corporate co-op advertisement contribution through PS billing.
• Developed analysis Report for various brands under YUM Brands, Inc.
• Developed FBM Missing Sales Letter Report.
• Developed Customer Statements and various types of FORM LETTERS.

Environment: PS 8.4 SCM (GL, AP, AR, BI, FBM, AM, INV, Travel & Expenses, and PROJECTS), PS 8.8 HRMS (HR, Base Benefits, Benefits Administration, Payroll, and T&L; eRecruit, eBenefits, ePay); IBM DB2 on OS/390, SQR 6.0, Cobol, n/Vision, CRYSTAL 8.5, WinXP and IE 6.0

Confidential

Sr. PeopleSoft Programmer Analyst

Responsibilities:

• Customized and developed Application Engine Interface Programs like Bank reconciliation and Positive Pay Programs as per the needs of the client, including Workflow messages to the required users and User manages about the status and output summary of the program run.
• Involved in the design and development of the BPDs by including the necessary Activity and step diagrams, with appropriate events and work list / email routings.
• Created an SQR report, for Project Costing, with Budgets and Commitment Control.
• Developed a PS/Query report, to provide detailed budget, commitments, and payment information for Activities within a specified Project.
• Created other new reports as per the needs of the client.
• Created new Pay cycles, by defining new PayCycle step tables, step definitions, and other payment selection criteria, with the newly developed outbound interface to the different banks checks information, using Application Engine, as per the client requirements, to create express Check payments.

Environment: PeopleSoft Tools 8.43, Financials 8.4 (GL, AP, PO, AM, INV, BD, KK and PC), Oracle9i, SQR6.1, COBOL, n/Vision and CRYSTAL 8.5 with Win2000, Vista Plus, Quest Stat v4.0.4, SQL Navigator 4.2, Unix and IE/6.0

Confidential

PeopleSoft Programmer Analyst

Responsibilities:

• Created the Upgrade Check lists, which will be useful at the time of actual upgrade
• Analyzed /applied delivered Fixes &Patches, Year end Tax Upgrades for 2002, Update and Fixes bundles for 2001, 2002.
• Performed unit, Integration Testing for various development / customization tasks.
• Fixed problems related to year-end process and W2 forms printing.
• Resolved some of post implementation problems of online customizations interfaces and reports.
• Involved in the trouble shooting of various problems linked with upgrade testing Phase.

Environment: PS Tools 8.15, HRMS 8.0 (HR, BN, PY for NA, ePay and eProfile), DB2 UDB V7.0 for OS/390, SQR6.0, COBOL, CRYSTAL8.0 with Win2000 Pro, Browser: IE/6.0

Confidential

PeopleSoft HRMS/Financials Consultant

Responsibilities:

• Involved in development of client specific application, Exchange Fee Billing from scratch, and also involved in integration of the same with PeopleSoft Billing module.
• Design of high-level application flow diagrams, using Visio, to highlight the main tables, and process involved in the new application development.
• Developed, tested Trade and Non-Trade daily, Monthly Billing processes using SQR.
• Developed new CBOT Billing Interface program, to send data from newly developed Exchange Fee Billing application to PeopleSoft Billing interface tables.
• Involved in a Data conversion program.
• Data conversion SQR, to load Clearing Firms data in Excel CSV format to new application tables, with logic, to generate Exception report, to highlight data records with errors, and duplicate records eliminated, before loading.
• Involved in Application messaging integration, to integrate PS HRMS and Financials systems as Message Nodes, and defined the Message channel and Message definition to send necessary Payroll data to GL.
• Developed customer self-service pages with PeopleSoft Security login access. And Replaced PeopleSoft logo in the self-service pages with CBOT Dash Board logo.
• Modified delivered AR balance forward statement, in Crystal to CBOT requirements.
• Modified Crystal Invoice report (Portrait), in PeopleSoft Billing as per CBOT requirements.
• Customized TL001.SQR to access, the data of employees under the particular user only.
• Developed new interface programs in Benefits Administration.

Environment: PS Tools 8.4, PS Financials/SCM 8.4 (GL, AP, AR, AM, Billing), HRMS 8.3(HR, Ben, Benefits Administration, PY, Time and Labor), Oracle8i, SQR6.0, COBOL, and CRYSTAL 8.5 with WinNT and UNIX, IE/6.0

Confidential

PeopleSoft Financials Lead Consultant

Responsibilities:

• Developed a form letter using Crystal with State Farm Logo, called ‘Replacement Service Letter to Policyholder regarding his Claim’ that will tell about the details of the items being sent to the Policyholder.
• Developed a report, called Orders Open More than 15 Days to display all the PO’s with more than 15days OPEN status. This report is sort by BUYER, VENDOR and PO date. Open days will be calculated based on the Due Date.
• Developed Multiple Prompts Functionality using People Code, to use in run control Pages, as per PeopleSoft 8.0 Web Client requirements.
• Created interfaces between different legacy systems and AP and PO; and between Purchasing and Inventory modules.
• Created views to eliminate more number of table joins in creating the Queries, there by to increase the performance. And also created Views, to eliminate sub reports in Crystal, and thus to increase the performance of the reports.

Environment: PS8.15/8.1 FDM/SCM (GL, AP, Purchasing, Inventory, T&E, and PROJECTS), IBM DB2 V7.0 on OS/390, SQR 6.0, COBOL, n/Vision, Control X, CRYSTAL 8.0 with WinNT and IE 5.0

Confidential

PeopleSoft Financials and Student Administration/ Campus Solutions Consultant

Responsibilities:

• Wrote SQR reports such as Applicant Details by Recruiter/Recruiters, to print the progression & prospects of Applicants assigned to each individual recruiter, or particular recruiter, entered at the prompt, in SA module.
• Developed Trial balance, Vendor-information reports using SQR in GL and AP.
• Developed SQR and CRYSTAL reports to reflect the needs of the Company, both from scratch and also by customizing.
• Used Import Manager to move Data from legacy system to PeopleSoft System
• Involved in the creation of Loan Outbound EDI process, to insert Direct Lending Loan data, like Origination, promissory note, and disbursement files data, into Outbound Staging tables.

Environment: PeopleSoft 7.5/8.0 Fin &Dist (GL, AP, Purchasing, AR, BI), PeopleSoft 7.5/8.0 HRMS-SA (HR, BN, PY, CC, SA, SR, and FA), SQL Server, SQR 4.3, CRYSTAL 5.0, WinNT

Confidential

PeopleSoft Financials Lead Consultant

Responsibilities:

• Customized PS VOUCHER (AP Voucher Header Table) by changing one of the existing non-required fields INVOICE ID as required as per GRD requirement.
• Customized Check1.rpt in AP to generate Checks with stubs (for Customers/ Sales Agents /Miscellaneous payments) as per Guardian requirement at GIAVA business unit.
• Customized Crystal rpt APY2001 i.e., Summary Check Register, in AP, and modified the corresponding QUERY.APY2001 Payment Register to reflect the changes.
• Developed a new SQR - First Union Sure Pay to handle the extraction from AP in the format specified by First Union. The First Union Sure Pay extracts will be created automatically on daily basis and reflect checks generated on legacy system TriMark-Transcend.
• Customized BIIVCPN.SQR i.e. Invoice generating report in PeopleSoft Billing. Added logic to generate empty lines dynamically, based on the customer base of the Agent, to enter newly added customer remit amount details, along with the original Invoice amount.
• Created new Outbound Map definitions, using EDI Manager Integration Technology to send the details of the extract files created by SQR for the checks generated on the respective banks, in the specified format of the banks.
• Created a new Crystal report G ARGL02.rpt definition i.e. ACH Direct Debits, in PeopleSoft A/R as per the needs of client.
• Created a new Crystal report G BIGL01.rpt definition i.e. Invoice Register by Bill Type/Contract #, in PeopleSoft Billing as per the specific needs of the client.
• Involved in PeopleSoft Application Upgrade for IA module from version 7.5 to 7.6

Environment: PeopleSoft 7.52 Fin & Distrb (GL, AP, AR and BI), Oracle 8.0, SQR 4.3, CRYSTAL 5.0, Unix (Sun OS 5.6), Windows NT 4.0