Summary:

• Over 8 years of experience in the field of Information Technology, Implementing Information Systems utilizing Client/Server, Web and Experience in Analysis, Design, Development, Testing, and Implementation.
• Progressive technical experience in Customization, Conversions, Interfaces, Upgrade and Implementation of PeopleSoft Financials General Ledger, Accounts Payable, Accounts Receivable, Asset Management and Billing , PeopleSoft SCM Purchasing, Inventory, Order Management modules.
• Strong technical expertise in module Interfacing, Upgrading, Conversion, Development, Data Migration, Module Development and Reporting based on People Tools and writing/debugging PeopleCode.
• Extensively utilized Application Engine and PeopleSoft Enterprise Integration Tools Application Messaging, Component Interface, and Integration Broker .
• Worked with Reporting and Analyzing tools such as SQR, Crystal Report. Used PS/Query, nVision and Tree Manager for reporting purpose to fulfill client's specific reporting configurations.
• Database Programming experience using Oracle, MS SQL Server, DB2, SQL, and PL/SQL.
• Involved in Functional QA Testing of FSCM and Platform Test by creating/running Test Cases, Test Scripts.
• Efficient team player, ability to multitask with excellent communication and interpersonal skills

Technical Skills:

Work Experience:

Confidential

Role: PeopleSoft Techno Functional Consultant

Responsibilities:

• Developed bolt on application to print bar codes for the journals, send over the barcodes along with journals to Doculogic via fax. All the barcode and journal images are stored at Doculogic and we can access from their server referring a URL with unique document id.
• Customized custom Application Engine program which loads the Document Id from Doculogic to PeopleSoft for the respective bar code associated to it.
• Developed custom SQR to extract Source and OperDefn table data for Audit purpose.
• Developed custom Application Engine program to load flat file into Speedcode table, on Run Control page user can browse add/delete/view the file attachment which will be used to load by Application Engine program
• Developed daily job Custom SQR which picks all the AP Journals which to be Amortized and insert into Amortization Header table. Handled logic to create unique Amortization ID based on Amortization Category.
• Developed monthly job Custom SQR which creates Amortization Journals for each Amortization ID from Amortization Header table and insert into Amortization Detail table based on Amortization Periods. Process these Amortization Journals into GL, from online give Undo and Transfer options for these Amortization Journals.
• Worked on modifying VMO related programs in extracting Project data and ftp to Procurestaff server, changed ftp server information in VMO Combo Edit program.
• Worked on Essbase extract in extracting Ledger data for Prior period and current period for ACTUALS and US FINAL, send to two different servers via ftp.
• Worked on User Roles data extract to SailPoint system and ftp to their server. Store ftp server information on a CIT CC Control Card table and retrieve it in SQR while ftp, with this we can have flexible to change the server information with out touching the actual program.
• Worked on Securitization Entries Interface, load multiple journal entries from Securitization Reporter application to PeopleSoft GL for specific Journal Source. Interface need to handle 15 separate Journal entry files with 30 to 40 journal detail lines. Modified existing JCL and Proc to handle multiple journal entry files and process.
• Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files with Third party systems like Essbase, SailPoint, Procurestaff and VOLT to AP Module.
• Involved in Supporting the Business in resolving all the Issues and keep the Application Error free.

Environment: PeopleSoft Financials 9.1, People Tools 8.51, People Code, Application Designer, Application Engine, Component Interface, PS Query, SQR, Mainframes, JCL, DB2, Control-M.

Confidential

Role: PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in the Production Support for the modules of GL, AP, PO
• Worked on production issues related to various Interface processes for General Ledger and Accounts Payables like Allocations and Reconciliation Process.
• Involved in troubleshooting and fixing bugs in General Ledger and Accounts Payable.
• Interacting with end users and technical resources. Troubleshoot AP, GL, PO process issues. Sufficiently unit test all coded programs prior to migration to the Test environment.
• Developed, Customized General Ledger Activity Report per Frontier requirements for their Financial Users.
• Involved in technical and online support in various stages of development to production environments.
• Developed a custom generic outbound interface in GL where data is sent based on the layout type selected on the run control page.
• Designed user friendly Inquiry Pages to trace the complete process of Workflow. Representing the current Work list, Current Role, Next Role in the hierarchy, the Initiator and the Approval Status.
• Developed a custom process for Open Item Reconciliation in General Ledger.
• Identified issues with the processes during support and developed custom fixes for Financials.
• Fixed different issues in the General Ledger like Journal Posting, Reversal Entries, Alternate Account Problems, Consolidations and doing Production Support for the different Issues.
• Used PS Query to created complex reports that combine different information in GL module.
• Designed and developed nVision reports to gather data on performance indicators such as Days Sales Outstanding DSO , Average Days to Invoice, and Average Days to Collect.
• Worked on Tree Manager and PS Query for analyzing and reporting the applications.
• Assisted functional and business analysts and prepared data mapping for conversion into Infinium and developed conversion strategy.
• Coded new SQR's and modified the existing ones using Trees, current tables and new tables for generating GL reports and for uploading and downloading data with brief descriptions and logs.
• Modified the Requisition online pages for adding the comments by users to vendors and warehouse which will reflect in the Purchase Order
• Used File layout, Application Engine and Component Interface to load data from legacy system into PeopleSoft financials application database tables.

Environment: PeopleSoft Financials 8.9, People Tools 8.48, People Code, Mainframes, ESP, DB2, Application Designer, Application Engine, Component Interface, PS Query, SQR, nVision, Query Manager.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Interacted with users and Client to understand Business Processes and worked with Functional people in designing Technical Specifications.
• Developed Technical Specifications and System Flows of Purchase Order to Oracle EBS Fulfillment Interface TSD, Sales Order from Oracle Interface TSD, Purchase Order to Oracle Replenishment Interface TSD and Purchase Order from Oracle Receipt Interface TSD from Functional Requirements.
• Developed Customer Contacts Conversion process to load Contacts from flat file into PeopleSoft using ExceltoCI spreadsheet upload process.
• Designed and Developed Open Item AR Conversion process to load Items into PeopleSoft from flat file using File Layout, DC PENDITEM CI Component Interface and Application Engine.
• Developed custom Purchasing Outbound Interfaces for Fulfillment and Replenishment which extracts the dispatched PO's into staging table using Application Engine and File Layout, with data validations using AE People Code and finally writes to flat file.
• Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files and XML files.
• Created several Functional flow diagrams for all customizations which will be more useful to the users to understand the flow of the customizations.
• Develop a secondary page to list, apply and substitute alternate products if available every time you enter a product Id in the sales order line.
• Worked on Setup Manager Documentation and created scripts to migrate configuration tables from one environment to other.
• Extensively worked with People code, application engine and reporting tools.
• Involved in the performance tuning of reports and processes using Load Lookup, Temp Tables and Views.
• Designed test scripts for system testing of new/modified custom pages, SQR Reports and People Code.
• Designed End-User Training documentations using UPK and trained business users on UPK.

Environment: PeopleSoft Financials 9.0, People Tools 8.48, People Code, Oracle 10g, Application Designer, Application Engine, Component Interface, PS Query, SQR, Crystal Reports, UPK, Query Manager.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Developed Project and Project Conversion App engine to load the legacy data into PeopleSoft Project Tables and also worked with Interface customization technical specification
• Worked on complete Data Mapping and Data Conversion Scripts between Legacy System and new FOCAS PeopleSoft System by using ODI and Data Transformation tools to load mass data into PeopleSoft System and Data Mover commands to export data.
• Developed a Projects Budgets conversion App engine program with Run control pages with input file parameters, this run control page is designed to use any conversion load programs with file paths input parameters.
• Utilized the delivered ExceltoCI tool to load the Grants data from CSV files / excel into the Grants Records. Validated the data as part of the conversion evaluation team
• Prepared strategy document which provides a strategy for designing and developing Bulkload Interface for Revenue Receipt, Extracts - Unclaimed Funds Transaction Interface and outbound inbound interfaces for Extracts - Tax Finance transactions.
• Prepared Functional Design Specification for Bulkload Interface Revenue Transaction, Extracts - Unclaimed Funds, Extracts Tax Finance by going through Business Requirements and Process Flows.
• Worked on integrating PeopleSoft Finance and PeopleSoft HR to synchronize User Profiles using Integration Broker.
• Worked on Transactional data from the state agencies to new FOCAS PeopleSoft System
• Provided nVision Reports and fixes for existing nVision reports. Provided setup and SQR reporting support for Inbound Interface deployment.
• Implemented Query Security, nVision security and Object Security.
• Used PS/nVision to import information directly from the database into an Excel spreadsheet.
• Involved in design, development and customization to PeopleSoft fields, records, pages, components, menus and projects using Application Designer and People Code.
• Worked on Bulkload File Layout/ASCII Bulkload document and LEGACY ASCII/EBCDIC file formats for mapping of data from legacy to PeopleSoft system
• Worked on ODI Setup, Creating Work Repositories and Master Repositories
• Preparing JAD Session material for Revenue Receipt Transfer Transaction, Tax Finance Transaction Unclaimed Funds Transaction
• Created various Route Control Types, Route Control Profiles, Roles, Routings and Approver Rule Sets.
• Implemented Query Security, nVision security and Object Security.
• Created /modified various Crystal Reports based on PS Queries.
• Gathered reporting specifications and developed reports using SQR and Crystal Reports Writer.
• Streamlined and tuned performance of some Crystal Reports using indexing and modifying the SQL
• Used PS Query to build queries and used Crystal Reports to generate all customer reports.
• Using PS/Query tool to build the SQL Queries and displaying them in Crystal Reports.
• Developed several reports using PS Query and SQR. Customized the Projects Transactional report to show only the approved vouchers being sent to Projects daily after PC AP PC Application Engine run.
• Gone through Data Transformation as it is new feature in 9.0 to implement in the new FOCAS PeopleSoft System
• Conducted operational training and presentations on Application Engine, Query Manager Crystal Reporting tool to State Employees.
• Developed configuration documents and migration documents for modules AP, AR, PO, GL, Projects and Budgets
• Involved in writing PeopleCode as per the requirement on different events to implement the business rules and validations.

Environment: PeopleSoft Financials 9.0, People Tools 8.49, PeopleCode, Oracle 10g, Application Engine, Component Interface, Integration Broker, SQR, n-Vision, Query Manager

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Upgraded PeopleSoft 8.4 to 9.0 and prepared groundwork for upgrading including evaluation of Customizations, Project Plan and Fit-Gap Analysis.
• Involved in Upgrades, Bundles and Patches and used extensively Change Assistance to maintain the tools/application upgrades.
• Analyzing Compare Reports and reapplying the customizations, cleaning of SYSAUDIT and DDAUDIT.
• Developed a custom page in Order Management for an order log to log order received from sales but not booked for some or the other reasons.
• Modified Order Close Process OMCLOSE.sqr to update the status of the sales orders meeting closing criteria to a custom page Maintain Order Log and developed a query to update the status of all the orders till date on to the order log in Order Management.
• Developed a report in Order Management H OMPRCH.sqr to list the order lines indicated as Drop ship which have vendor invoice voucher in Accounts Payables.
• Customized the application Engine program AP PSTPYMNT.BC050 to populate the APPL JRNL ID for the journal Generator to create Journal Lines.
• Worked extensively on the AP MATCHING, AP PSTVHCR and AP PSTPYMNT to figure out the various errors caused by missing objects.
• Developed custom Voucher Build and Matching processes to meet the business needs of the client.
• Trained the permanent employees at the county in using People Tools, People Code Debugger, CI, Component Registration Wizard and Compare Reports.
• Designed and developed new naming standard for the Route Control Profiles used by the County. This cleared the immediate cluster present in the current 8.4 production system where the workflow is not often routed to the proper approvers in the hierarchy.
• Supported Pay Cycle, Check Printing Integration, 1099 Processing, and Bank Reconciliation in PeopleSoft.
• Involved in the design and development of the Row Level Security for SETID, BU, Ledger and Pay cycle using the ROWSECCLASS field in PSOPRDEFN with custom security views.
• Replaced the Application Engine Program PC TO TL with an SQR to increase the performance of the interface as the volume of the transactions is high.
• Troubleshoot various Technical, Functional, Setup Issues with AR Update, Payment Predictor, Pay Cycle Manager, Payment Posting, Journal Generator, AM Depreciation Calculation, AP Check Printing, PO Dispatch, AM Transaction Loader and helped the client to Implement best PeopleSoft Practices by redefining functional requirements to use most of the PeopleSoft delivered functionality and to avoid customizations as much as possible.

Environment: PeopleSoft Financials 9.0 /8.4, People Tools 8.49/8.42 People Code, SQR, Oracle 10g, Process scheduler, AE, People Code, Component Interface, Integration Broker, SQR, Tree Manger, Unix Scripts, Security, Query Manager

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Involved in customization of Vendor, Invoice with holding pages.
• Streamlined and tuned performance of some Crystal Reports using indexing and modifying the SQL.
• Supported in troubleshooting AP and GL issues like offset balance between the AP and GL.
• Developed Custom SQR Reports like the Research Report, Vendor Payments listing Report, Cancelled Check Report etc.
• Customized some of the AP Reports like APY3020 Vendor outstanding Balance , APY2021 Check Printing and APY1090 Match exception .
• Gathered reporting specifications and developed reports using SQR and Crystal Reports Writer.
• Created Components for various PeopleSoft functions like, PO type Contract entry, Preview PO, and INV Replenishment, in order to increase the performance and also meet the requirements of the client.
• Loaded Vendors and Customer Data from Legacy system to PeopleSoft Financials Modules using File layout and App Engine Programs.
• Modified the Purchase Order POPO005.SQR to eliminate the Line totals, include Bill to address, sales tax, eliminate Freight and Misc charges etc
• Modified PeopleSoft objects like Pages, Components and People Code according to the business requirements in AP, GL.
• Involved in Writing Technical Specifications, Design, Development, Testing Customization along with Reports Development.
• Involved in detail Design, Development and testing of three major workflow areas PO Requisitions, Blanket PO Email Notification processes and GL Journals.
• Developed an interface in AP using Integration Broker which reads the XML files, that contains invoice data received through the fax and populate the custom staging tables using App Messaging.
• Provided Production Support in running SQR and Crystal reports for end users.

Environment: PeopleSoft Financials and SCM 8.9, People Tools 8.48, Application Engine, PeopleCode, SQR, Crystal Report, Oracle 9i, HTML, Web Logic 9.1.0, UNIX

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Designed and developed Workflow to Approve Voucher Payments from Expense Report based on the amount either to set the Voucher Status as Approved or to route to the appropriate Managers for Approval.
• Developed Purchasing Interface using File Layout, Application Engine, and Component Interface, which loads feed data into staging tables while doing various data validations using Application Engine PeopleCode and finally loads into PeopleSoft tables through Component Interface.
• Modified the Journal Status Inquiry to retrieve Journal Lines associated with the Business Unit of the Journal selected in GL.
• Designed and developed a custom General Ledger Reconciliation SQR program to provide flexibility to end users to choose either Range of accounts/individual accounts/both, which is an enhancement to delivered process gls7002.sqr General Ledger Activity Report.
• Conducted detailed work practice reviews for all of the business processes and identified the system requirements for business process improvement.
• Used Process Scheduler and Process Definitions extensively to define App Engine Batch processes and report programs to enable them to run from PeopleSoft on-line pages and created documentation for the users.
• Developed a SQR report that gives all the details related with Purchase Order with AP Details and Billing Information, report runs by Project/Customer.
• Developed Open Purchase Report that gives you all Purchase Order related details.
• Modified Customer Statement SQR AR32001.sqr and Crystal Report AR32001.rpt , added Purchase Order/Requisition Number/Vendor Info in Customer Statement.
• Involved in implementing BU Security on Queries. Creating Security View Definitions and secured all the views using Query Security Record and the Views were used to code the queries to achieve Row Level Security by BU and OPRID's.

Environment: PeopleSoft Financials/SCM 8.4 GL, AP, PO, AR, BI , People Tools 8.4, PeopleCode, SQR, Windows 2000, Oracle 8.0/8i. SQL Server, Toad

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Ran and reviewed the Initial Audit Reports against copy of production to ensure that database is clean and also checked performance.
• Used Upgrade Assistant tool, created and ran the jobs as listed in Upgrade Assistant.
• Applied pre and post upgrade fixes and customized the pages according change requests.
• Wrote Application Engine programs for the modifications and executing data mover scripts.
• Tested migration process, documented and worked on report work.
• Analyzing Compare Reports and reapplying the customizations to new database
• Used PSQuery to build queries and used Crystal Reports to generate all customer reports.
• Responsible for ensuring the customized SQR Reports work and compare/upgrade in the new release. Modified the SQR Interfaces for version 8 compatibility and fine-tuning of SQR reports.
• Extensively involved in Running Reports, Identifying Customizations and Re-Applying Customizations.
• Developed functional specification and preparation for upgrading process.
• Performed pre-upgrade tasks for AP, AR, AM and Billing and making necessary documentation.
• Created the email notification Application Engine for the blanket POs from scratch. This involves the use of People Code, Component Interfaces in the place of the database agents present in 7.5.
• Designed and developed 11 Custom Query trees, access groups and security settings to accommodate all the custom records existing in 7.5
• Extensively worked with Application Designer to create the new Record Definitions, Views, Pages, adding the Pages to Components and Menus, used PS query in developing queries and worked on other security access issues.
• Verifying the items for matching while loading data from AP to AM using account information page.
• Checking the Voucher Post Status to run the load assets process and reviewing data before sending data to pre-interface tables.
• Defining billing cycles, created billing reports for adjustments and troubleshooting the billing interface.
• Used workflow process for PO Requisition Process, PO Approval and PO Changes.
• Applied customizations on copy of production, based on the actions set by analyzing the compare reports and also participated in different customizations.
• Involved in running Upgrade scripts using Upgrade Assistant for the Upgrade process. Analyzed Upgrade Compare reports to identify and document existing customizations.

Environment: PeopleSoft Financials AP, AR, AM and Billing 8.4/7.5, People Tools, People Code, SQR, SQL, PS/Query, Crystal Reports 8.5, nVision, SQL Plus, Oracle 8i, Windows 2000, UNIX.