Developer Peoplesoft

SHUPRATIM SAHA

*** ******* *** **** *** ***,

SEATTLE, WA 98102

U.S.A

Cell Phone: 510-***-****

Email: **********@*****.***

SUMMARY

Over 19 years of extensive exposure and experience in Application/Interface Development, Implementation and Development in ERP Systems with Financials Supply Chain (specializing in development on Procure-To-Pay and Order-To-Cash Modules), Human Resources, Benefits Administration, Payroll, Manufacturing, and Order Management/Distribution Modules like PeopleSoft, BaaN IV.

Experience with PeopleSoft 9.2, 9.1, 9.0, 8.8, 8.4x & 7.5x, designing, developing & customizing Financials Supply Chain – Inventory & Purchasing Modules (Procure-To-Pay), eProcurement General Ledger, Project Costing, Accounts Receivables, Billing, Accounts Payables, Grants

& Contracts, Commitment Control, Travel & Expense, Treasury, Cash Management, Banking, LCD (Labor Cost Distribution), Human Resources, Benefits Administration, Payroll, Order Management and Manufacturing Modules in FMS/HR Oracle PeopleSoft Enterprise – Version 9.2/9.1/9.0/8.4, BaaN IV, BI Tools like Cognos ReportNet, InfoAssist, Oracle BI/XML Publisher, PeopleSoft Security, Enterprise Warehouse and EPM Modules of PeopleSoft 8.0/8.8 (OLAP and ETL Tool), Scanning and Linking Software – ImageNow 6.

Knowledge and Experience with Oracle Cloud, PeopleSoft Fluid UI, PeopleSoft Upgrades and Applying and Retrofitting PeopleSoft PUM Images/Bundles/Patches.

Knowledge of PeopleSoft Self-Service Applications like eBenefits, eCompensation, eDevelopment, ePay, ePerformance and Recruiting Solutions like PeopleSoft Enterprise Candidate Gateway and Enterprise Talent Acquisition Manager.

Knowledge and expertise in CRM Package – Siebel 2000 with Sales and Marketing and Call Centre Modules.

Experience in Database Design and Development utilizing Oracle and MS Access.

Involved both in developing Functional/Technical Designs for Customizations, and programming and testing the customized software components like Program scripts, Forms, Menus, Reports, Tables, Include functions, DLLs etc.

Developed, tested and implemented conversions and interfaces.

Knowledge of client/server coding techniques & problems, generating reports using BI/XML Publisher, SQR, Crystal Report Writer, Cognos and Developer 2000.

Extensive knowledge of functionalities involved in the Manufacturing and Distribution, Financial

(INV, PO, AP, AR & GL) & Human Resources Modules, EDI (Electronic Data Interchange), PeopleSoft Workflow and Supply Chain Management Systems.

Excellent team worker with strong interpersonal and organizational skills. TECHNICAL SKILLS

Languages: SQL & PL/SQL, FORTRAN, Visual Basic 5.0, PeopleCode, Baan-SQL, C, Java Operating Systems: Windows 3.X/95/98/NT, MS-DOS, UNIX, (DB2/MVS) Mainframe Environment

Packages: Developer 2000, Forms 4.5 & Reports 2.5, Engineering Packages (Ausplume), MS Excel, MS Powerpoint, ImageNow 6, OnBase

Databases: MS Access, Microsoft SQL Server 2012, Oracle 12c, Oracle 11g, Oracle 9i, Oracle7.x, DB2, SQLBase

ERP: PeopleSoft 9.2/9.1/9.0/8.4/7.5x Financials and HRMS, BaaN-IV, BaaN Series (V) CRM: CRM – Siebel 2000

PS Development Tools: PS Application Designer, Application Engine, Component Interface, Import Manager, Data Mover, File Layout Definition, Tree Manager, PeopleSoft Workflow (AWE), PS/Query, PS/nVision, Integration Broker, Application Messaging, XML/BI Publisher, Application Package, Web Services, PeopleSoft Fluid UI, Data Migration Workbench

Test Automation Tools: HP LoadRunner (Virtual User Generator – VuGen), SilkTest, PTF (PeopleSoft Test Framework)

Administration Tools: Operator Security, Object Security, PeopleTools Utilities Reporting Tools: Oracle BI/XML Publisher, SQR (3.0), SQLTalk, Cognos Reportnet, Crystal Reports (9.0), Process Scheduler, nVision

BaaN Tools: Application Development, Project Customization Administration, User Management, BaaN 4GL Script, Utilities

DataWarehousing

Tools:

PeopleSoft EPM (Informatica PowerMart) – ETL, OLAP, Ascential DataStage Designer

Siebel Tools: Configuration Manager, Assignment Manager, Workflow Manager &Actuate Workbench

PROFESSIONAL EXPERIENCE

Company: Washington State Board for Community and Technical Colleges, Olympia, WA ERP - ctcLink PeopleSoft Finance Senior Developer

2018’ September till Date

Currently working as a PeopleSoft Finance Senior CEMLI Developer for ctcLink Project at SBCTC involved in and responsible for

Conversions/Customizations/Enhancements/Retrofits/SIT/UAT Testing/Production Support for the multiple Deployment Groups (DGs) for the 34 State Board Community Colleges

– supported the Cutover/Implementation/Post Go–Live Production Support activities for the Finance Pillar for a successful Go-Live of PeopleSoft 9.2 (Fluid UI) Deployment/Implementation for Deployment Group 2 and Deployment Group 3A and 3B consisting of Clark College, State Board, Olympic College, Lower Columbia College, Peninsula College, Pierce College and Cascadia College. Worked on Development/Enhancements/Modifications and Unit Testing of Application Engine Load Programs for AR/GL/AP/PO Conversion (Generation of Conversion Journals, AR Pending Item Group Entries, Vouchers and Purchase Orders) involving SQL Loader and CI

(Component Interface for AR Pending Item, PO Load) Load, Development of Custom Global

(SetID: WACTC) to Local BU Cross Walk generation Application Engine Program, Modifications to the Application Engine Program for AP Positive Pay File generation for US Bank for State Board, Modifications for AWE Workflow Approvals for Billing/Credit Invoices

(involving modifications to App Package PeopleCode: SCM_BI_INVOICE:InvoiceController.OnExecute to bypass AWE Workflow for Billing Source ID of Grants or Contracts), Requisitions, Purchase Orders and Vouchers, Development of the ctcLink Image Logo replacing the Oracle Logo on the 9.2 Fluid Landing/Home Page for the 3 Pillars (Finance/HCM/CS (Campus Solutions), Enhancement for PO Dispatch BI Publisher Report Template incorporating the BU Logos for Clark and State Board and PO Dispatch Email Text changes (involving modifications to App Package PeopleCode: PO_DISPATCH:PO_Dispatch_Email.OnExecute) and also development of the Bolt On Custom KK/Budget Status Report (SQR and SQC - ctcglskk.sqr and ctcrptcf.sqc) after cloning the delivered SQR/SQC – gls8020.sqr/fsrptcf.sqc. Also worked on DMS Scripts for the Export/Import of Configuration Data (including AWE Config Data for Travel and Expense/AP/PO Modules) for the various Modules, used Tree Mover for Export/Import of Trees and used Data Migration Workbench for migration of WorkCenter Configurations for modules like Treasury. Also worked on Development of CIs/ExcelToCIs for Procurement Card Holder Employee Profile Data, Requestor, Buyer, Item Category, Tax Authority, AR Distribution Codes, Billing Charge Codes, Speed Types, Customer, Treasury Settlement Instructions CI (PeopleCode Fix), GM Proposal, AM Location, Vendor, 1099 Withholding Data Uploads etc. Also, worked on Finance PUM Image # 28, 31, 32 and 33 Retrofits. Environment:

(PeopleSoft FMS 9.2 - PO/AP/AR/BI/GL/KK/AM/PC/CA/GM/EX (Travel and Expense)/Treasury/Cash Management/Banking, HCM 9.2 and CS 9.2 (Campus Solutions)), PeopleTools 8.56.12, PeopleCode, Application Engine, Workflow (AWE), App Package, Integration Broker, BI Publisher, Fluid UI, SQR, Stat 6.2.0, Oracle SQL Developer 18.1.0, Oracle 12c, Amazon Workspaces, Git/Bitbucket – PeopleSoft Infrastructure hosted on AWS Cloud. Company: Fred Hutchinson Cancer Research Center, Seattle, WA ERP - PeopleSoft Systems Analyst/PeopleSoft Senior Developer 2014’ December till 2018’ September

Worked as a Systems Analyst/PeopleSoft Senior Developer involved in & responsible for Customizations/Enhancements & Production Support both for PeopleSoft 9.2 Financials & 9.2 HCM Systems - International Project Implementation & Support (with Multi Currency turned on) – for Business Units: USA, South Africa & Uganda, Employee Faces & Places Project, Okta/PeopleSoft My Hutch Integration Project, PS to Click Interface, AR Cash Receipts & FMS/HR PS 9.2 Upgrade Projects - AE for Oanda Currency Exchange Rate Upload in PS

(Cloud App/SaaS), Data Mart Mods, BI Ilab Project and Charge Code Outbound Feed, Grants Proposal Component Interface (OSR Miscellaneous Enhancements), KK Audit, LCD Third Party Payroll Customizations for International BUs (Uganda and South Africa), Development and Unit Testing of Application Engine modifications for BI Ilab Projects Feed, Development and Unit Testing for AR Deposit Upload Functionality, Development and Unit Testing for Billing Invoices (Shared Resources and Miscellaneous Invoices) Email/Bursting Functionality, Development and Unit Testing for Fixed Price Contract PeopleCode Enhancements, Evaluation of the Event Mapping and Classic Plus features as a part of the PeopleTools 8.56 Upgrade Project, TIAA-CREF Interface Program in HR, AE for PS Photo Upload, AE for UW & Liberty Mutual SFTP, LCD (Labor Cost Distribution), Oracle HCM Cloud Phase Zero Fred Hutch SCCA Workshops, OnBase DocPop for HR. Also, involved in the Financials/HR 9.2 International Project Development & Production Support (resolving issues, Fixes for Bugs reported) of new & existing FHCRC/International Customizations/Enhancements/Interfaces/Reports for modules: eProcurement (involving Integration Broker - cXML App Messaging/Direct Connect/Punchout to SciQuest (Cloud App/SaaS)), Purchasing (PO Print/Dispatch, IB - PO EDX/XML Dispatch to SciQuest, FCA Customization on PO Line, Customization for BI Pub Report for Print Receiver Report etc.), Accounts Payable (involving OnBase Imaging & SciQuest Invoice Inbound App Messaging leveraging IB - Inbound Transformation using XSLT, BI Publisher AP Check), AR/Billing

(Development of XML/BI Publisher Reports for Shared & Miscellaneous Invoices, Inbound/Outbound Interface AE for SFTP for BI-ILAB, Chartfield Defaults - App Package Handler PeopleCode for Billing Spreadsheet Upload etc.), Grants & Commitment Control

(Mod for GMFACS AE Program, Non Sponsored Budget Upload process etc.), GL

(Customization of Journal Generator AE - FS_JGEN for AR to PC Direct Journal, WebLibGL mod for Journal Spreadsheet Upload etc.).

Environment:

(PeopleSoft FMS 9.2 - PO/eProcurement/AP/AR/BI/GL/KK/AM/PC/CA/GM & HCM 9.2) PeopleTools 8.56/8.55/8.54, PeopleCode, Application Engine, Workflow (AWE), App Package, Integration Broker, BI Publisher, Fluid UI, SQR, Crystal Reports, Jaggaer/SciQuest (Cloud App/SaaS), OnBase, Oanda FX (Cloud App/SaaS), iLab Solutions, Microsoft SQL Server 2012 Company: Ben E. Keith Company, Fort Worth, TX

ERP - PeopleSoft Technical Specialist

2014’ June till 2014’ November

Worked as a PeopleSoft Technical Specialist/Senior Programmer Analyst/Senior Developer involved in and responsible for Customizations/Enhancements and Production Support both for PeopleSoft 9.1 Financials and HRMS Systems. Worked on a customization for HTML Tags for ImageNow (Imaging System) on the AP Voucher Entry and Voucher Approval Pages and successfully implemented in Production Environment. Also working on modifying Interface Load/Publish Application Engine Programs and SQRs and Conversion SQRs for a GL Conversion Project (Mainframe to PeopleSoft and vice versa) as well as modifications for the custom AR Customer Statement SQRs (Print, Email and Fax). Also currently involved in the Upgrade effort for upgrading from HRMS/HCM 9.1 to 9.2 – worked on analysis of the Compare Reports and retrofitting of the BEK Customizations. Environment:

(PeopleSoft Financials/SCM 9.1 - AP/AR/PO/GL/AM & HRMS 9.1/9.2) PeopleTools 8.52.21/8.53.13, PeopleCode, Application Engine, Workflow (using AWE), Application Package, Integration Broker, XML/BI Publisher, SQR, Crystal Reports, ImageNow, Microsoft SQL Server 2012 Company: DIBON SOLUTIONS Inc.

Client: Texas Comptroller of Public Accounts, Austin, TX Implementation Consulting Company: Xerox Corporation (ACS) ERP - PeopleSoft Developer

2011' November till 2014’ June

Title: TxDOT Financial Prototype and Baseline Merge/CTIC/CAPPS - Implementation of FMS 9.1

(PeopleTools 8.51.14) & FMS 9.2(PeopleTools 8.53.08) along with Customizations/Enhancements

Worked as a PeopleSoft Senior Financial Developer/Technical Analyst involved in FMS 9.2 Implementation for 4 Agencies – DMV, PUC, RRC & TJJD and Production Support after the successful Upgrade from FMS 9.1 to 9.2, and prior to that was involved in retrofitting, development of new customizations/enhancements like Requisition Loader (leveraging CI

(Component Interface)), AM Capitalization, Crystal Report conversion to XML/BI Publisher Report for Reports like Class and Item Changes, Requisitions to be Sourced, Requisition Status, Voucher Print, Journal Print, Inventory Shipping Document and PO Dispatch/Print and support/resolving issues during System Testing /User Acceptance Testing (UAT) phase as well as Production Support for the Baseline Merge/CTIC/CAPPS Project and also was involved during the development of Prototype for Agency - TxDOT (Texas Department of Transportation).

Environment:

(PeopleSoft FMS 9.1/9.2 - INV/PO/eProcurement/AP/AR/BI/GL/KK/AM/PC/CA/GM) PeopleTools 8.51.14/8.53.06/8.53.08, PeopleCode, Application Engine, Workflow (using AWE), Application Package, Integration Broker, XML/BI Publisher, SQR, Crystal Reports, Oracle 11g Company: DIBON SOLUTIONS Inc.

Client: CB Richard Ellis (CBRE), Dallas, TX

Implementation Consulting Company: PricewaterhouseCoopers LLP ERP - PeopleSoft Developer

2011' March till 2011’ October

Title: (FPO) Financial Platform Optimization Project - Upgrade from PeopleSoft 8.8 to 9.1 (FMS) and Implementation of FMS 9.1 (PeopleTools 8.51.05) along with Customizations/Enhancements

Worked as a PeopleSoft Senior Financial Developer/Consultant involved in creating Technical Designs and developing and unit testing New Customizations & Enhancements like: Billing Invoice Upload process - developed a custom Application Engine program that calls a CI

(Component Interface), custom Billing Customer Invoice Extract and XML Publisher process for Billing Customer Invoice Report - developed custom Extract Application Engine and XML Publisher Application Engine programs along with custom XMLP Data Source, XMLP Report Definition and XMLP Template Definition, custom PeopleCode for Customer-Client Combo Edit etc. for Billing & Accounts Receivable modules, customization for PO Dispatch/Print XML Publisher Report involving modification of PO Dispatch/Print App Package, developing a custom GL Combo Data Interface to HR Application Engine process, developing a GL Blackline SQR Interface program, developing a SQR Process for Scotia Bank, Canada Bank Reconciliation process, developing custom Workflow leveraging AWE (Approval Framework) for eProcurement, Accounts Payable & Travel and Expenses modules and custom Workflow for Project Costing and Contracts modules. Environment: (PeopleSoft FMS 8.8 and FMS 9.1 – Financial Management System – PO/eProcurement/AP/AR/BI/GL/EX/PC/CA/AM) PeopleTools 8.49/8.50/8.51, PeopleCode, Application Engine, Workflow (using AWE), Application Package, Integration Broker, XML Publisher, SQR, Crystal Reports, Oracle 11g

Company: DIBON SOLUTIONS Inc.

Client: Texas Comptroller of Public Accounts, Austin, TX Implementation Consulting Company: Deloitte Consulting LLP ERP - PeopleSoft Developer

2010' May till 2011’ May

Title: Project One/CAPPS Implementation – Upgrade from PeopleSoft 9.0 to 9.1 (FMS) Project for Texas Comptroller of Public Accounts for the State of Texas and Implementation of FMS 9.1

(PeopleTools 8.51.03) along with Customizations for various Agencies - TxDOT (Texas Department of Transportation) and DIR (Department of Information Resources) for the State of Texas

Worked as a PeopleSoft Senior Financial Developer involved in the Upgrade/Retrofitting Customizations/New Customizations & Enhancements effort for the Upgrade Project for upgrading ISAS (Integrated Statewide Administrative System) Financial System from FMS 9.0 to 9.1 and implementing FMS 9.1 (PeopleTools 8.51.03) for TxDOT (Texas Department of Transportation) and DIR (Department of Information Resources) for the State of Texas. While working as a Developer on this Project – Project One, worked on resolution of Issues, Technical Designs, Coding and Unit Testing for approx 25 Mods so far

(Customizations/Enhancements, Interfaces, Workflow and Conversions) for the Modules/Functionalities covering Inventory, Asset Management, Purchasing (Requisitions, POs, RFQs, Receipts), Procurement Contracts, eProcurement (worked on a customization for Tx SmartBuy Real Time Interface – for this Direct Connect Method leveraging Integration Broker as delivered by PeopleSoft using cXML Messaging/PunchOut is used to connect in real time to the TxSmartBuy/Vinimaya Catalogs for adding items to the shopping cart and bringing the Line Items back to the eProcurement Requisition Line page), Accounts Payable and Accounts Receivable as a part of the successful upgrade to FMS 9.1 (PeopleTools 8.51.03) and migration of Release 1 deliverables/objects to System Test Environment and to User Acceptance Test Environment (UAT).

Environment: (PeopleSoft FMS 9.0 and FMS 9.1 – Financial Management System – INV/PO/eProcurement/AP/AR/BI/GL/KK/AM/PC/CA/GM) PeopleTools 8.49/8.50/8.51, PeopleCode, Application Engine, Workflow (using AWE), Application Package, Integration Broker, XML Publisher, SQR, Crystal Reports, Oracle 11g

Company: DIBON SOLUTIONS Inc.

Client: Kaiser Permanente, Emeryville/Pleasanton, CA ERP - PeopleSoft Consultant/Technical Analyst

2010' January till 2010’ April

Title: OneLink Project – PeopleSoft Financials Supply Chain Management System – General Ledger, Accounts Payable, Purchasing and Inventory, eProcurement, Imaging (Vignette), Enterprise Performance Management, AtPar Application for HandHelds

Worked as a Technical Analyst/PeopleSoft SME in the Performance Testing Team for the OneLink Project which is engaged in the Implementation, Testing and Support of General Ledger, Accounts Payable, Purchasing and Inventory Modules, eProcurement in PeopleSoft FSCM, Imaging (Vignette), AtPar Application for HandHelds (AtPar Modules include Cart Count, Stock Issue, Picking, Receiving, Bin to Bin Transfer etc.) Environment: (PeopleSoft FSCM 8.9 (INV/PO/GL/AP Modules)) PeopleTools 8.49, Oracle 9i Company: DIBON SOLUTIONS Inc.

Client: California Water Service Company, San Jose, CA ERP - PeopleSoft Consultant/Technical Analyst

2007'March till 2009’October

Title: Upgrade from PeopleSoft 8.4 to 9.0 Project for California Water and its subsidiaries – Hawaii, Washington and New Mexico/Production Support of Financials and Human Resources Modules

/Upgrade /Enhancements /Customizations for ERP Systems – Financials and Human Resources Modules

Worked as an ERP Consultant/Technical Analyst/Senior Developer, involved in Production Support, Upgrades, Enhancements and Customizations for (Procure-To-Pay) PeopleSoft Inventory, Purchasing, General Ledger, Accounts Payables, Asset Management, Project Costing/Management, Human Resources, Time & Labor, Payroll and to some extent on Revenue Management Systems Modules.

Worked on Conversion and Upgrade Project for Upgrading from FSCM 8.4 to FSCM 9.0, was involved in all the stages of the Upgrade from Fit-Gap Analysis to Retrofitting Customizations and working on Enhancements, Conversion Programs (Inventory Item and Inventory Item Balance Load using Excel To CI and Item Loader, Developed an Application Engine program for Item Balance Load for the conversion of Washington Subsidiary from their Legacy System to PeopleSoft FSCM 9.0), Unit Testing, System and User Acceptance Testing Support and Cutover Tasks and Go-Live and Production Support.

Worked on configuration of new Business Units for Purchasing and Inventory – Purchasing Definition, Purchasing Options, Procurement Options (Location, Ship To Locations configuration), Inventory Business Unit Definition, Default Putaway Location, Item Families, Item Categories, Purchasing Item Attributes, Item Replenishment etc.

Worked on Voucher Upload using Excel to CI and Integration Broker/Application Messaging and worked on developing and customizing AP Crystal Checks, AP Positive Pay programs and AP Aging Report, Automate Bank Reconciliation using Application Engine programs and Blackline Reconciliation program for AP and Inventory. Also worked on developing Excel To CI for Vendor Upload. Worked on customization for Vendor Insurance Tracking and Vendor Audit Trail report. Worked on customization for PeopleCode Hyperlink/Interface between the Vendor Pages (for Vendor 1099 and Vendor Insurance), Voucher Page and Journal Header and Line Pages and ImageNow 6.

Worked on modifications for CM_COSTING and CM_ACCTG (Inventory Costing and Accounting Line Creation) Application Engine Programs, Matching (3 way – Purchase Order, Receiver and Voucher), GL (General Ledger) Reconciliation (involving GL Activity Report, PPV – Purchase Price Variance, Journal Generator Process etc), Query for PO (Purchase Order) Remaining/Open Amount, Amount Ordered and Amount Received, SQR INS7000 (Inventory Value Report), Inventory Cycle Counting Variance Report modifications, Enhancements and Modifications to the PO Dispatch SQR, Requisition Print SQR etc., Set Up for Auto Daily Replenishment Jobs (involving processes like PO_REQLOAD, PO_REQSORC, PO_POCALC, PO_POCREATE etc.). Worked on modifications for MSR (Material Stock Request) and Receiving

(worked on the modification for implementing Department Level Security) – Set Up Jobs for Receiving and Depletion (Receipts/Autoputaway, Autoship/Depletion etc.)

Also worked on Customization for Contractors Authorization for Work involving Projects Module – developed Online Component (using PeopleCode) and Reporting using Crystal Reports 9.0. Worked on a major customization on Requisitions for Contractor Authorizations involving changes to the Requisition related records and PeopleCode and also Receipt Accrual process impacting the Purchasing and Accounts Payables modules.

Worked on WRAM/MCBA (Water Revenue Adjustment Mechanism and Modified Cost Balancing Account) Project involving creation of new nVision reports and SQR process impacting the General Ledger Module.

Also worked on enhancements for incorporating Copy from Template (using PeopleCode) and T&L History functionality impacting the Time and Labor module.

Worked on enhancing/automating the Bank Reconciliation process (Accounts Payables Module) using/leveraging Application Engine along with File Layout Definition. Also involved in the initial stages of eProcurement implementation and HR 8.8 to 9.0 Upgrade process including Recruiting Solutions like PeopleSoft Enterprise Candidate Gateway and Enterprise Talent Acquisition Manager.

Environment: (PeopleSoft FSCM/HCM 8.8 & PeopleSoft FSCM 9.0 – Financials Supply Chain and Human Resources Modules – INV/PO/GL/AP/AR/Billing/HR/Payroll Modules) PeopleTools 8.48/8.49, PeopleCode, Application Engine, Integration Broker, SQR, Crystal Reports 9.0, Oracle BI/XML Publisher, Microsoft SQL Server 2008

Company: DIBON SOLUTIONS Inc. & ACCENTURE Inc.

Client: Kaiser Foundation Hospitals, Kaiser Permanente, Oakland/Pleasanton, CA ERP Consultant/Systems Analyst

2004'June till 2007’February

Title: Kaiser Managed Inventory Project (“KMI Project”), Corporate Item Master Project (“CIM Project”) and Enterprise –Wide Implementation of PeopleSoft-based HRMS system ("HRIS Project")

Worked as an ERP Consultant with Dibon Solutions Inc on Kaiser KMI – Kaiser Managed Inventory Project. Following are the tasks accomplished so far in this project:

Fixing Application Engine Programs for Dispense Interfaces like KP_DISPENSE that involves CI

(Component Interface) and modifying Message Subscription PeopleCode.

Creating Application Engine Programs for prototyping the Advanced Shipping Receipt process to create the text file for Inbound File Publish and Load Receipts process within the Purchasing/Inventory module utilizing Advanced Shipping Receipt Message Subscription PeopleCode and Integration Broker in Performance Testing Environment. Also developed Inbound/Outbound/EDI Integration Application Engine Programs for the Interface Programs. Knowledge and expertise with Inbound/Outbound EDI Processes – EDI 850 – PO Dispatch, EDI 855 – PO Acknowledgement, EDI 856 – Advanced Shipment Notice and EDI 180 – Return to Vendor.

Created Application Engine Programs like - POS Item Locator (Point Of Sale) – KP_POS_ITLOC, Application Engine Program for Updating Process Status for Locations to Ignore

– KP_LOC_IGNR, Application Engine Program for Inbound Batch Integration – KP_BATCH_IN, Application Engine Program for KP Outbound Integration – KP_BATCH_OB, Application Engine for EDI Integration – KP_EDI_INT, Created SQR for Run Control Update – KPRUNUPD.

Worked on troubleshooting problems on Application Messaging – Integration Broker /MQ Series for the Dispense Messages and modified KP_DISPENSE Message - Message Subscription PeopleCode for KP_KMI_PIMS1 – For the different business validations.

Also created JobSets and Recurrences for Batch Processing/Scheduling in KMI.

Was involved intensely in the monitoring and troubleshooting of daily Batch Processing for the KMI Project.

Worked with Oracle Support on resolving a production issue on Receiving for Zero Divide Error with Application Engine PO_RECVPUSH after applying a patch.

Knowledge of automatically loading item contract pricing and terms from PSOS (Pharmacy Strategy and Operations System) into the PeopleSoft application, so that purchase orders have the correct purchase price.

Also worked on resolving and tuning performance issues for KMI Project for example for the PeopleCode changes and analyzing the indexes that would enhance the performance for Dispense Workbench for working the Dispense Staging Table Errors. Worked on the technical feasibility analysis of using PeopleSoft Integration Broker (Application Messaging), MQ Series, Application Engine and PeopleSoft Workflow Technology for the functional requirements identified during the fit gap analysis phase of the CIM project (Corporate Item Master project). Worked as a Systems Analyst with Dibon Solutions and Accenture on the HRIS Project for the client Kaiser Permanente, main tasks and responsibilities on this project that were accomplished are:

Conversion approach involving data mapping and design (Extract, Transform and Load) for the conversion of the Legacy HR systems at Kaiser Permanente to the HRIS/PeopleSoft 8.8 implementation involving toolsets like SQR, Application Engine/Component Interface etc. The HRMS modules touched are Benefits, Payroll and Human Resources.

Developed online customizations touching the Job Code Table component in HR (Human Resources) module and customizations in BN (Benefits) Module like design of SQR for updating Eligibility Deduction Counter. Also developed customizations involving Job Labor Page, Work Location Page, Salary Step Component, Union Code Table and Language Page etc.

Developed new customizations like MSI (Mass Step Increase) and Bilingual/Interpreter Pay.

Created Detailed Design for a SQR batch process involving turning off Additional Pay, Deductions and Direct Deposit for Termination, Actual Hours Worked Calculation for Benefit Eligibility and MSI Hours Accumulation Process.

Also Created Detailed Designs for SQR batch processes and developed and customised SQRs on

"Union Seniority Date – Online Job Action Batch" and "Union Seniority Date – Hours Calc Batch Process", “In Lieu Of Differential Batch”, “Pay Unsheet Process” etc.

Worked on Online development for Union Dues Processing and on ESS (Employee Self Service) customisations for Workflow/Email Notification.

Worked on Conversion Extraction Staging and Transform Load SQR Programs on Arrears Deduction, Additional Pay, General Deduction and Deduction Balance.

Worked on Interface SQR Programs like Hewitt Payroll, Union Deduction, Payroll Advice Print, Payroll Check Print -USA (Outbound Interface – Ceridian).

Worked on Ascential DataStage Designer to modify ETLS like for Server Jobs on ODS_HR_REPORTING_MAPS, ODS_HR_STAGING_MAPS for PS_EMAIL_ADDRESSES, PS_JOBCODE_TBL and PS_ODS_EMAILADR_DM records and Server Jobs on PS_UNION_ TBL record in PeopleSoft EPM Database.

Received Classroom Training for developing reports out of the PeopleSoft EPM database using COGNOS ReportNet and worked on Cognos Reportnet modifications using Frame work Manager.

Worked on resolving Production Issues – Production Support. Environment: (PeopleSoft FSCM/HCM/EPM 8.8 – Financials Supply Chain and Human Resources Module) PeopleTools, PeopleCode, Application Engine, SQR (3.0), DB2/MVS, Mainframe environment Company: ACCENTURE Inc., Toronto, Canada

Client: Royal Bank of Canada Financial Group, Toronto, Canada Systems Analyst/PeopleSoft Consultant

2002’ April till 2004’ May

Title: Enterprise General Ledger Implementation (PeopleSoft Financials 8.4 Supply Chain - FSCM) Worked as a Systems Analyst with Accenture on the eGL Project for the client Royal Bank of Canada Financial Group, main tasks and responsibilities on this project that were accomplished are:

Configuration including setting up of PeopleSoft Global Application Tables (Defining Chartfields) and Workflow configuration (Defining Route Controls, Roles and Approval Rule Sets) for the General Ledger (Financials) module using PeopleSoft 8.4.

Customization of the Online Journal Entry, Journal Inquiry, Ledger Inquiry and Journal Approval processes (Workflow Audit Trail and Journal Entry Granularity).

Functional, technical design, detailed design, development, unit testing, Enhancement and Production Support involved in the creation of new Global release online and batch processes - which includes development of critical work

Contact this candidate