We provide IT Staff Augmentation Services!

Finance Functional Consultant And Subject Matter Expert (sme) Resume

0/5 (Submit Your Rating)

ConnecticuT

SUMMARY:

  • 14 + Years of progressive functional and technical experience in the implementation, customization and maintenance of the PeopleSoft Financials and Supply chain 9.2/9.1/9.0/8.9 (eProcurement, Procurement, Accounts Payable, Customer Contracts, Grants, Project Costing, Billing, Accounts Receivable, Asset Management, Travel and Expense, Labor Distribution, Commitment Control and General Ledger).
  • Proven expertise in design, development and modification of PeopleSoft application, processes, reports and integrations using Application Engine, Component Interfaces, file layouts and Integration Broker.
  • Expert knowledge in customizing and developing enhancements for PeopleSoft Financials (Account Billing, Receivables, Procurement, Account Payables, Asset Management and General Ledger).
  • Extensively worked with People Tools - Application Designer, Component Interface, Integration Broker, XML Publisher, People Code, Workflow, Process Scheduler, Data Mover, import Manager, Application Upgrade, Security Administrator, Object Security, Tree Manager, Portal, etc., and reporting tools XMLP/Bi publisher, SQR, Query and nVision.
  • Strong skills in patches &Support, Production Support, testing and UPGRADE tasks.
  • Extensive knowledge in report writing using SQR, XML Publisher or BI Publisher, OBIEE and Cognos 10.2.3.
  • Experience in configuring and customizing PeopleSoft Workflow and Approval Workflow Engine for Voucher Approval Using (BU & ORIGIN).
  • Experience in UNIX Shell Programming and Autosys JIL jobs.
  • Excellent hands on experience of WSDL, Gateway services, Messaging - Transmission, Web services API’s and SOA (Service oriented Architecture)
  • Trained on Oracle Middleware Technology called as Oracle SOA 11g, SOAP, SOAPUI and BPEL.
  • Extensive knowledge in integrating LDAP with OIM, SOA and OAM in IAM Suite 11g.
  • Good exposure to Task Management like Estimation, planning, tracking, monitoring and communicating Task progress etc.
  • Strong presentation, documentation skills and developed various technical specs with Test Plans and Procedures.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, JDK 1.2, C/C++, Visual Basic 6.0, TOAD 4.0, People Code.

Databases: Oracle 10g/11g, 9i/8i, 12c, MS SQL Server 2000/7.0.

ETL: SAS 9.1/9.3 and Ab-Initio

ERP: PeopleSoft FSCM v 9.2/9.1/9.0/8.9 (eProcurement, PO, AP, AM, Billing, AR, Cash Management, GL, Customer Contracts, Grants, Project Costing), HRMS (Core HR, Base Benefits and Pension) Oracle Fusion Cloud Financials (R12 and R13) and Oracle Fusion Cloud PPM.

People Tools: 7.x/8.x/8.4x/8.5x

DM Tools: Data Mover and Import Manager.

Reporting Tools: BI Publisher, SQR 6.x/4.x/3.0, Oracle BI (OBIEE), Discover and Cognos 10.2.3.

Web Services: WSDL (Web Service Descriptive Language), SOAP (Simple Object Access Protocol) and REST (Representative State Transfer).

Migration tool: STAT 5.6.4 and 5.7.2 and PHIRE

Web Servers: Web Logic, WebSphere, Apache and IIS.

Web Programming: HTML and JSP.

O.S.: Windows 7/XP/2000/NT/98, UNIX and LINUX.

PROFESSIONAL EXPERIENCE:

Confidential

Finance Functional Consultant and Subject Matter Expert (SME)

Responsibilities:

  • Act as liaison (SME) between Confidential $ Confidential Business team and JCC to understand Confidential $ Confidential /PeopleSoft Functionalities, Client business needs and Product Enhancement.
  • Work closely with the Confidential $ Confidential Business SMEs on JCC’s functional requirements.
  • Participated in Fall Validation and Spring Validation test scripts execution and supported JCC business users to complete all the scripts execution.
  • Executed non-scripted functionalities with the support of Confidential $ Confidential business SMEs.
  • Worked with JUD and Confidential $ Confidential conversion teams on the following interface items.
  • Worked with Department users on the Inbound Billable Charges and Invoice Adjustments Interface file (INFAR005). Interface allows the following
  • New Invoice with Positive amounts to be billed.
  • New Invoices with credit amounts to be included on the invoice.
  • Adjustment invoices to send a new invoice with an adjustment.
  • Worked with department users to enter open receivables in the CSV file and interfaced into the Confidential $ Confidential system (INFAR006).
  • Performed month-end and Year-end close. Troubleshot out of balance Balance sheets.
  • Work closely with Confidential $ Confidential partner agency business users viz. Department of General Service (DGS), Department of Finance (DOF), State Controller’s Office (SCO) and State Treasurer’s Office in addressing the challenges faced in PeopleSoft Custom components.
  • Strategies and complete the tasks agreed upon in the Task Accomplishment Plans (TAP) in support of the replacement of the Judicial Council of California’s existing legacy system with the Confidential $ Confidential system using PeopleSoft ERP.
  • Provided a strategic solution to JUD to continue to handle SWOs in Confidential $ Confidential for the Facilities and Services unit with as little disruption to the current SWO process.
  • JCC reported 73 major issues which are road blocks to convert into Confidential $ Confidential . Did complete analysis and worked with Confidential $ Confidential SMEs to close all open items.
  • Provided solutions to JCC on all PO related open items like creation of blanket purchase orders, link b/w requisition, contract and PO.
  • Helped JCC team on Role mapping sheet update, chart strings mapping, approval workflows.
  • Tested and prepared documentation on below AP open items
  • Worked with FSC in addressing the Deposit Slip Print related issues
  • Assisted judicial users in clearing the Catch up Deposits which are stuck at various stages with reference to whether the deposit is Deposited in Bank, Remitted through EFITS, Entered and Posted in FISCAL.
  • Guided users in listing and explaining different scenarios of Customer Item Payments and Direct Journal Payments that will route for approval (through Workflow) and Interface to Legacy system for Remittances based on Deposit Types, Payment Types, Bank, Amount, Location and Fund combinations.
  • Helped Department users in clearing the duplicate payments which were posted through Deposit Slips and Regular Deposits post M2 release.
  • Provided support to users in clearing issues related to Chart field Inheritance, Combo Edits, Account out of Balance errors while posting their Abetment, Reimbursement and Revenue Items through pending groups.
  • Worked with Oracle Analysts to troubleshoot and figure out the Budget Date Override issues while posting Payments and Pending Items.
  • Helped users in reversing and reposting the accounting entries which were posted through Direct Journal Payments by educating them on $0 Deposit functionality.
  • Worked with FSC Analysts in resolving Issues related to Payments used to fail due to time lag between the Revenue Recognition and Collection process for Bills initiated through Contracts module.
  • Assisted users in generating Header and Line level Invoice formats with Judicial Logo.
  • Helped departmental users by guiding through correct Queries and Reports which will reduce the time for Month end closing activities.
  • Provided support to business users on how to process a dishonored check payment that has been remitted to Cash in State Treasury within the Account Receivable module.
  • Provided solution to JCC how PC asset data flows to AM module and Dependencies/conditions between PC and Activity to the AM module.
  • Involving in configuration, conversion and interface activities.
  • Extensive Functional Testing of the Issues before moving to QA Environment.
  • Responsible for coordinating with Oracle by raising Service Requests and PUM changes to implement in Confidential $ Confidential with no impact to existing business functionality.
  • Conduct the Business requirements gathering sessions for enhancement and Change Requests with Business Users and Management team.
  • Performed the unit/system testing, QA testing and various levels of application testing.
  • Assisted Business users and resolved issues related to Billing Worksheets, Proforma / Regular Invoice, Adjustment Invoices Printing Finalization of Bills, Subsystem Journal in PeopleSoft BI Modules.
  • Addressed Transactional Support related issues of AR module in Pending Item, Item, Deposits, Payments, Worksheets, AR UPDATE, Payment Predictor, Maintenance worksheets, Revenue Estimate, Budget Checking and Sub System Journals.
  • Thorough understanding and hands on existing Interfaces developed as part of WAVE, ABMS releases and support end users in related areas.
  • Support to delivered and custom Reports in Account Receivable and Billing Modules.
  • Work closely with State counterpart and other team members of Fiscal.
  • Support to Department users by updating the Configuration changes submitted through CMR duly approved by their managers.
  • Created PeopleSoft SQL and Queries for User reporting and to analyze data from debugging.
  • Involving in Organizational change management, business process reengineering, business analysis and technical analysis.
  • Created Forecast report by using PeopleSoft Query Manager Tool, which shows the current and future forecast budget details to the users.
  • Design, build, map Judicial Branch’s chart of account to Confidential $ Confidential chart of accounts.
  • Plan, Analyze, Configure, Document, Test, and Deploy Confidential $ Confidential ’s Accounting, Budgeting, Procurement, Cash Management solution for the Judicial Branch (Appellate Courts, HCRC, JCP, JCC offices).
  • Provided technical solution to JCC team to inactivate Vendors who doesn’t have active PO contracts for last 3 years.
  • Review, learn, master Confidential $ Confidential ’s functional Capabilities.
  • Review, evaluate, configure and implement Accounts Payable, Cash Management, Procurement, Grants, Customer Contracts, Project Costing, Billing, Accounts Receivable, Asset Management and General Ledger Functionalities.
  • Map and/or reengineer JCC business processes to meet Confidential $ Confidential ’s functional Capabilities.
  • Prepared Job Aids for all Functional Modules as per JCC business needs.
  • Prepared business flow diagrams from as per JCC business needs.
  • Providing operations support which includes analysis, expertise, and problem resolution of Production issues.
  • Guide and assist JCC staff by providing expert knowledge for interactions with the Confidential $ Confidential System on functional issues and provided detail fit gap analysis.
  • Perform data analysis, mapping, and development support of Legacy systems conversion.
  • Extensively worked on data conversions from Legacy system (JCC) into the Confidential $ Confidential and interface layouts.
  • Supporting JUD staff on functional issues when required across all functional modules in Confidential $ Confidential .
  • Working with JCC staff on month-end close and troubleshot out of balance Balance-sheets.

Environment: PeopleSoft FINANCE 9.2, Oracle 12c and Service Now.

Confidential

Financial Functional Consultant

Responsibilities:

  • Gathered functional requirements with help of Business Users from Legacy system (MEBEL) and Documented functional specifications. Used RICEFW IDs in the functional specifications.
  • Worked on PeopleSoft Fluid User Interface to be used on mobile devices. Created fluid pages to get classic View of Beneficiary designation pages, Member Data and core solution pages.
  • Created process flow diagrams using Microsoft Visio tool. Also created UNIT test scripts in the technical design document.
  • Configured Ledger Template, Ledger Group, Detail Ledger and setup Ledger for a Business unit.
  • Maintained Business Units and Accounts reporting tress using Tree Manager.
  • Assisted users in suspense journal corrections. Worked with enhanced 8.8 Spreadsheet Loader and Excel to CI utility.
  • Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables.
  • Designed HCM Integration to Finance process (EB003I) to report Member Contributions and Pensionable Earnings into the Finance system and populate data into the custom Reporting Finance Summary Table and Billing Finance Summary Table in FIN to delivered tables in the PeopleSoft Account Receivables (AR) and General Ledger (GL) modules.
  • Involved in creating the PeopleSoft web services for all integration points with MEBEL integration and assisted SOA team with mapping activities.
  • Developed complex Oracle BI publisher reports on Billing, Receivable and General Ledger modules.
  • Support to delivered and custom Reports in Account Receivable and Billing Modules.
  • Developed test plans and scripts for AR, and BI modules. Performed QA on many enhancements and frequently used processes and reports.
  • Assisted Business users and resolved issues related to Billing Worksheets, Proforma / Regular Invoice, Adjustment Invoices Printing Finalization of Bills, Subsystem Journal in PeopleSoft BI Modules.
  • Addressed Transactional Support related issues of AR module in Pending Item, Item, Deposits, Payments, Worksheets, AR UPDATE, Payment Predictor, Maintenance worksheets, Revenue Estimate, Budget Checking and Sub System Journals.
  • Support to Department users by updating the Configuration changes submitted through CMR duly approved by their managers.
  • Presenting and obtaining required approvals with Change Request Review Board before migrating them to production.
  • Performed AP-GL reconciliation and created queries.
  • Used Agile methodologies (SCRUM) to interact with the multiple teams and delivered requirements faster with consistent, successive iterations.
  • Created Custom App engine process NY LNSC INT to get the custom loan and service credit purchase payments from custom table made by self - service users in HCM to Accounts Receivables, thereby populating PS GROUP CONTROL, PS PENDING ITEM and PS PENDING DST tables in FSCM.
  • Created custom application engine process NY FIN HCM to move direct debit payments from DD CONTROL, DD IN BANK FILE table to HCM custom table NY PAYMENT to apply loan and service credit purchase payments back to loan accounts and employee accounts.
  • Designed EB006I functional specification to create Open Items in AR and Accounting Entries in GL.
  • Items are created in Receivables for inclusion on the Estimated/Final and Projected Invoices for Employer Billing and to track payments owed for Employer Reporting.
  • The scheduled nightly delivered ARUPDATE process posts the delivered Pending Items Table to the delivered Items Table and updates Customerbalances.
  • Created scheduled process (UNIX shell script) to run the Journal Generator process (FSGEN) on nightly.
  • Worked on Employer Billing Salary Listing Process (EB002E) import ACTYEF file into Projects & Contracts (Year End Reporting Table), Enrolled to Billed Plan Mapping page, processes to apply and update rates.
  • Modified Payment Predictor Application Engine processes (AR PREDICT1 and AR PREDICT2) to process the cash receipts. Payment Predictor is a process that matches and applies the cash receipts against the Employer’s Open Receivable Items using algorithms and configuration.
  • Customized the payment predictor process - Added new section in the AR PREDICT2 for the custom algorithm to write off the minimum underpayment and on account scenarios.
  • Involved in Grants business process by creating several proposals, establishing the proposal budget, processed the ‘Print a signature page’ for authorization and copied an existing proposal to create new proposals.
  • Involved in Grants Pre-Award business process by submitting proposals to various sponsors, negotiating award details with sponsors by tracking the type of negotiations, the status of negotiations and contact information. Managed an award projects with activities, managed award budgets and reviewed grant information.
  • Involved in Grants Post-Award business process by setting up a letter of credit contract, setting up cost reimbursement contract, approving the Billing worksheet for LOC/Non-LOC contract, billing interface process, single-action invoice process and applying payments in AR for invoices.
  • Created file layout and Application engine/CIs to load Plan information into the Health benefits page.
  • Created daily integration process for payments interface that selects all the eligible Loan Payments processed in PeopleSoft and sends the calculated results to MEBEL for check Processing.
  • Created Custom Beneficiary designation and Death Benefit page to maintain a member’s ‘Death’ benefit beneficiaries.
  • Configured and developed centralized Single Sign-On (SSO) login page.
  • Extensively worked on AAF (Active Analytics Framework) module in CRM to created CASE and correspondence to the beneficiaries.

Environment: PeopleSoft FINANCE/CRM 9.2, SQL Developer, Oracle 12c, PHIRE, Oracle BI Publisher, Lotus Notes, SharePoint and FileNet.

Confidential

Sr. Application Developer, Team Lead and Project Deployment Lead

Responsibilities:

  • Lead functional walk-thru sessions with clients and executives, including project status presentations.
  • Created Functional Requirement/Specification documents, Technical design Documents and Functional Navigation Documents and trained the users to use the above functionalities.
  • Involved in 32 major deliverables in the project without having issues in the PROD environment.
  • Used Agile methodologies (SCRUM and Extreme Programming) to interact with the multiple teams and delivered requirements faster with consistent, successive iterations.
  • Prepared and executed fit/gap sessions with the user community; analyze all functional requirements for translation into functional fits and gaps.
  • Prepare and maintain project plan, project scope, functional requirements, and functional solution specifications documents.
  • Assist with impact analysis, decision making, workarounds, and designs related to the functionality being implemented.
  • Worked to implement the Basel II Framework which is intended to promote a more forward-looking approach to capital supervision, one that encourages banks to identify the risks they may face, today and in the future, and to develop or improve their ability to manage those risks.
  • Extensively worked on the data interfaces between Main Frame and PeopleSoft systems. Main frame system generates data in the flat files and load the data into the Accounts Payables, Billing, Accounts Receivable and General Ledger modules.
  • Responsible for support of AP & GL and Implementation responsibility for Purchasing (PO) and Billing (BI).
  • Supported GL spreadsheet upload process to load journals intoproduction.
  • Adding new fields and applying people code changes to GL journals and custom journal entry pages. Adding new custom fields to JRNL1.XLS and records for Journal spreadsheet upload processing.
  • Wrote custom SQR program in GL to load journals from external interfaces into JRNL HEADER and JRNL LN tables.
  • Customized AP VCHRBLD to insert the voucher data of specific origin into custom tables.
  • Created the custom application engine (Z CUST INTC) to read data from flat file and loads customers into PS.
  • Created the custom application engine (Z AR ITEM LD) to read data from flat file and loads PS Accounts receivables staging tables (PS GROUP CONTROL, PS PENDING ITEM and PS PENDING DST) as pending items.
  • Created new BI publisher template (Z ATM) for billing invoice.
  • Modified delivered BI publisher template (BIXPRNT00 ENG) to meet the business requirement.
  • Customized the BI LINE page to store the client name and description.
  • Modified the delivered BI publisher template (AR AR32X000 ENG) for accounts receivables customer statements.
  • Customized the delivered XMLP Invoice Bursting Program (BIXMLPBURST) to send customer invoices as attachments via emails.
  • Modified the delivered application class(BI EXTRCT) in app package (SCM BI XMLP) to generate xml file based custom file layout definitions and custom BI extract tables.
  • Developed SOAP based XML messages to load the Inventory and Non inventory receipts, stock orders and to call PO RECVLOAD in batch mode to load the inbound transactions.
  • Worked on Special Request for services using the variable cost template.
  • Validations on Special Request Variable cost pages.
  • Handling customization in PO, AP and inventory modules.
  • Developed the AR AGING and INVOICE PS Query reports for different Aging buckets required by the client.
  • Customized PeopleSoft delivered App Engine processes to send PO’s to vendors that are neither direct merchants nor Marketplace vendors. The processes modified were Purchase Order Dispatch process (PV PO DISPATCH) and the Batch Dispatch process (PV DISPATCH).
  • Developed Several Custom Validations that need to be Done Prior to Expense Report and Cash Advance Submission.
  • Setup ACH and Bank Account Information for Expense users.
  • Customized the IMPORT FILES application engine program for the acknowledgement files.
  • Customized PMT DISPATCH application engine and various application packages in order to change the layout of the bank payment file and send to the bank through application message payment dispatch.
  • Extensively used Integration Broker (SOA) to integrate Risk and Finance Systems. Handled messages in formats like XML, SOAP and PS Row set based data. Used REST (Representative State Transfer) Services to capture current state of the resource, used HTTP and XML based operations to manage data between Risk and Finance systems.
  • Monitoring the Approval System in the organization by using Workflow functionality.
  • Expertise in working with CSV to CI for data uploads into the Application.
  • Participated in quarter, yearly closing and reconciliation of sub-module with GL.
  • Monitor market rate updating, closing & opening of periods, financial calendars, closing of records.
  • Developed and modify the reports like Financial Activity Report, Financial Detail Report, Current/ Prior year compare report, PO Expedite Report, Print Multiple Purchase Orders, and Budget Journal Inquiry.
  • Managed and tracked fixed fee budget vs. actual costs associated with the project.
  • Developed Interfaces using SQR/Application engine to extract data from flat files to Accounts payable.
  • Created Run control panels, panel groups, attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under ProcessScheduler.
  • Integrate PeopleSoft Asset management with IBM Maxima Asset management. Created interfaces to export data from IBM Maxima to PeopleSoft Asset management.
  • Implemented AWF (Approval Work flow) concepts for Travel and expensemodules.
  • Worked closely with users and testers to assist with their day-to-day needs and to fix the issues or defects.
  • Converted custom Crystal reports to XML publisher reports.
  • Customized the POSPAY (APY2055-) crystal report to send the positive payments to local banks and fixed the PT 8.51 crystal report Line feedbug.
  • Creation and modification of the reports like Statement, Dunning letters and Payment Summary etc. as per the user requirements using Crystal Reports and SQR.
  • Worked with PeopleSoft Admin team on development of OAM customizations related to login pages, error pages, authentication and authorization plugins and setting up OAM policies.
  • Involved in end-to-end implementation of IAM (Identity Access Manager) solution using Oracle's suite of Identity and Access Management.
  • Experience in developing Single Sign on Solutions (SSO) leveraging Oracle Access Manager (OAM) for traditional authentication, and risk based authentication.
  • Worked with PeopleSoft DBM team to Configure PeopleSoft Finance 9.2 upgrade environment to start upgrade process i.e. setting up change assistant, setup PeopleSoft Update Manager PUM, PeopleSoft Image 11, downloading template from oracle support, creating change assistant 8.53.11 job and follow through all the steps in change assistant job to finish the upgrade.
  • Provided a cost-effective, vendor supported and streamlined upgrade methodology that allows for the migration to Oracle’s latest release of the PeopleSoft software application.
  • Minimize development down-time during upgrade duration.
  • Initial Pass - This is the most manually intensive process of the whole upgrade duration. Analysis, compare reports, data conversion and retro-fits are done during this phase.
  • Upgrade Source - In order to establish a consistent and repeatable process the upgrade is executed using a static source.
  • Retro-Fit - The new application release will contain vendor modified versions of objects that may have already been customized by Citi. During the upgrade process some customizations may be overwritten. Customizations are identified during the initial phase of the project via a comparison of production with the existing demo environment. Collisions of customizations with delivered code are then identified via subsequent compare reports.
  • Update People Tools - This step is also known as the Rel-up process, and primarily involves the execution of SQL scripts to bring tools tables to the correct structure for the desired people tools release.
  • Execute Additional Project Migrations as needed - The metadata in the final upgraded target instance will be equivalent to that of the upgrade source. Thus any changes made after the upgrade source was created will need to be migrated to the target via a standard project migration.

Environment: PeopleSoft Finance 9.1/9.2, People Tools 8.52/8.53, Oracle 11.2.0.3, Toad, SQL Developer, SQR, Oracle BI publisher, OAM 11g (Oracle Access Management).

Confidential, Connecticut

Sr. Application Developer and Programmer Analyst

Responsibilities:

  • Prepared functional and technical specifications for Account Payables and Account receivable.
  • Customized several reports using SQR and also developed inbound and outbound Interfaces for third party providers using SQR.
  • Responsibilities also include page customization, component customization, menu customization, bug fixing, enhancements, and supporting the PeopleSoft applications Purchasing, AP, AR and GL.
  • Written SQR program for Purchase Contracts conversion from legacy to PeopleSoft Purchasing tables.
  • Debugged PeopleCode to resolve issues.
  • Extensively worked on the data interfaces between Main Frame and PeopleSoft systems. Load data into the Accounts Payable and General Ledger modules.
  • Created new component interface to load express bill data into billing.
  • Developed Interfaces using SQR to extract data from flat files to Accounts payable.
  • Created new Application Engine programs to load vendor data into Peoplesoft vendor tables.
  • Implemented Security Definitions for Permission Lists, Roles, and User Id’s.
  • Row Level Security is implemented using SQL Views to control the rows of data and Field Level Security has implemented using PeopleCode.
  • Involved in Handling the Production Problems related to Purchasing, AP, BI, AR, and GL.
  • Debugged SQR Programs using Show, Display and Debug statements.
  • Customized Workflow components like Rules, Roles and Routings.

Environment: PeopleSoft Financials 8.40, People Tools 8.45, SQR, Oracle 9i, Windows NT/2000.

Confidential, NJ

Software Engineer

Responsibilities:

  • Developed SQR (mlii009s.SQR) to load MetFACS2 Premium Projections file into the PS ML EXP FCTR GEN table, reports data Errors to the error reports, writes a control report for each inbound file processed and sends an email for each inbound file processed.
  • This SQR (mlir001s. SQR) program, NA/NSC Expense Volume Variance Extract, will provide the users with Variance levels between the current month and an average of the last three months.
  • This SQR (mlir002s. SQR) program, NA/NSC Weighted Volume Variance Extract, will provide the users with variance levels between the current month and an average of the last three months.
  • This SQR (mlir003s.SQR) Provides two detail transaction reports of the rows loaded into the Journal Staging Tables by the Flat File Journal Staging Loader program with different sort sequences.
  • Created File layouts and wrote Application Engine programs to transfer data from Microsoft Excel to the PS LEDGER table.
  • Providing functional expertise bundled with Technical PeopleSoft knowledge for testing out the applications.
  • Working on a process to load Billing data into staging tables (INTFC BI, INTFC BI2, INTFC BI NOTE, etc). This data is picked up by the billing interface to create the necessary Bill Headers and Lines.
  • Working on interfaces for AP, INV and PO module.
  • Made changes to the Finance/Overdue charges application Engine AR OVRDUE program to write the finance charge data into a custom table.
  • Created test cases based on Functional and Technical Design specifications.

Environment: PeopleSoft Financials 8.8, People Tools 8.44, SQR, Oracle 9i, Windows NT/2000, Citrix Server, Test Directory 8.0.

We'd love your feedback!