SUMMARY:

• Uses Minimally Invasive and Surgically Price approach to customization to ensure upgrade cost is minimal.
• Multiple projects implementing various business solutions for multiple clients with multiple business units.
• Expert in PeopleSoft Purchasing, eProcurement, Payables, Order Management, Inventory, Billing, Receivables, Security, Workflow.
• Procure to Pay Process Improvement
• Order to Cash Process Improvement
• Proven track record at PeopleSoft and other major clients, delivering Financial and Supply Chain solutions, stabilization, improvements and ROI.
• Led & Supported multiple projects in various capacities during design, development, support & upgrade.
• Clients from multiple industries like HealthCare, Automotive, Retail, Insurance, Sales and Distributors, banking, airlines and hospitality, Benefit administration.

SKILLS SUMMARY:

PeopleSoft Functional Skills ( Version 9.2, 9.1, 8.9, 8.8, 7.5, 7.0)

Purchasing

Payables

Order Management eProcurement

Billing

Inventory

Receivables

GL - reporting

Security and Workflow

PeopleSoft Technical Skills:

People Tools

People Code

Application Engine

SQR

PS/ n Vision

File Layout

Crystal/ Query

Import Manager

Process Scheduler

Tree Manager

Data Mover

Query

Component Interface

Tree Manager

SQL

Oracle

SQL Server

DB2

Informix

MS Access

Operating Systems

Windows NT, XP

Mainframe

Unix

ADDITIONAL SKILLS:

Process Improvement

Fit/Gap Analysis

Global Organizations

Project Management

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Consultant - Support Analyst

Responsibilities:

• Analysis and Custom Logic for Book to Bank
• Various Report Modifications.
• Some new bolt on developments involving Forms. New fields not appearing during data entry

Confidential

PeopleSoft Consultant - Technical Analyst

Responsibilities:

• Application of Customization to the PUM31 image.
• Tools Objects like Records, Peoplecode, Page, etc
• Application Engine
• Modified the critical SQRs like POPO005.sqr, INS6000.sqr and few others.
• Assisted with some research occasional security and access
• Researching Automated AP Invoice process and recommendation for changes in current Read and Load processes,
• SQR
• Application Engine
• EDI810 and Imaging interfaces(Basware)
• Simplified and ReWrote Pick plan by removing old customization and in a portrait format.

Confidential

PeopleSoft Consultant - Support Analyst

Responsibilities:

• Joined the application support team for Custom Budget module.
• Quick learning and adaptability was required as team members had left abruptly.
• Helped internal new hire employee with learning before rolling off.

PeopleSoft Consultant - Developer

Confidential

Responsibilities:

• Joined a project mid-stream and had to deliver results in a short duration/time.
• Reviewing various Requirement Gathering Documents for pending work and offered insight and recommended changes as relevant.
• Modified the Custom Billing Program.
• Developed custom functionalities for grouping of Transfer Templates definitions.
• Modified various pages to allow use of Transfer groups to search for related templates during transaction creations retaining delivered search options.

Utilized Skill Sets: Insurance Billing, PeopleSoft FSCM 9.1 (Treasury, Bank, Billing, Invoicing), Application Engine(Query)

Confidential

Independent Consultant

Responsibilities:

• Designed and developed a custom solution to allow AP Users to upload a CSV file with Supplier Statement/Invoice detail and produce an excel output with pertinent Invoice/Voucher details in our system that can be sent back to the supplier as statement with payment date and amount details.
• Designed and developed an email solution with attachment for select PO Requestor group for missing receipts so that they can create the same to support the invoice matching requirements.
• Modified various SQRS processing AP EDI810 and Imaging based Voucher Load data to ensure AP BU consolidation remapping worked smoothly. Wrote supplemental Application Engine logic to catch any missed data before actual Voucher Build processing occurs. Fixed some logic issues.
• Designed and Developed CSV file based AP Invoice Upload process to replace multiple versions of Excel Template based Upload efforts. Idea was to ensure a common data format is used by all AP users with ability to review uploaded file/data that Excel process was not allowing. Ease of review using query was also an objective for the same so captured raw data in custom tables as well.
• Modified PO Dispatch program and delivered functionality to allow users to attach PDF documents to be faxed with the PO.
• Added/Fixed online page functionality for Expense Users to be able add/delete document from Expense Pages to assist with expense approval process.
• Managed Vendor Inactivation and Status Update in a controlled manner thru SQL means based on Item, PO and Voucher data.
• Designed and developed a repeat solution for COA cleanup effort for Accounts and Deptid. Staging Table, Upload and Custom Queries were created to identify impacted transactions in various modules like PO, ePro, AP, BI etc.
• Added new custom fields to Expense Pages to capture Destination information per travel itinerary.
• Modified Inventory Pickplan to add custom data and reformat the layout.

Utilized Skill Sets: Healthcare, PeopleSoft FSCM (Purchasing, eProcurement, Accounts Payable, Inventory, General Ledger), SQL, Application Engine, SQR, Query

Confidential

Independent Consultant

Responsibilities:

• Approval Framework Workflow design, configuration and testing for
• Purchase Order.
• PO Requisitions ePro Requisitions
• Journals in General Ledger
• Payable Voucher
• Facilitating requirement gathering and guiding and directing Business Analysts with requirement gathering for Requisition/ePro rollout as an extension of current Purchasing System Usage.
• PO/ePro demonstration using release 9.1 to the users to help facilitate decision making for using ePro versus Purchasing Requisition System for rollout of the new Requisition process from current centralized manual process. Encouraging use of dynamic workflow design rather than custom.
• Design and Development records, pages. Sqrs for a custom bolt-on application for generating Billing data (Bills and Invoices) allowing users to process Airfare and Expense data.
• Design, development and proposal for Customer to Vendor data alignment and AR to AP Refund processing. One time conversion of customer data to vendor details and daily net change updates to the vendor master.
• Interface Design & Development for
• Inbound General Ledger Journal data from a new source application.
• Outbound Expense and Airfare billing data for new application.
• Testing of Inbound Engagement and Travel Authorization data from a new source application.

Utilized Skill Sets: Healthcare, PeopleSoft FSCM (Purchasing, eProcurement, General Ledger, Billing), Approval Framework Workflow, SQR

Confidential, Chicago

Independent Consultant

Responsibilities:

• Joined a project mid-stream and had to deliver results in a short duration/time.
• Reviewing various Requirement Gathering Documents for pending work and offered insight and recommended changes as relevant.
• Understanding existing Application Engine programs and modified them to accommodate additional requirements for loading data from excel or text files.
• Using defined structure, developed new Application Engine programs to Load raw data from Excel or Text file.
• Modified or created multiple new Custom Query from Custom data tables to be used to generate custom reports and invoice statements as Excel Files.
• Generate Multiple worksheet based excel files with output data in Summary and Detail format per client requirements.
• Ensure previously coded logic generate reports as existed. Modified them as necessary per test results and user feedback.
• Modified logic to generate output files based on group of data where relevant.
• Added custom logic to consolidate and/or move data from one worksheet into one worksheet where applicable.

Utilized Skill Sets: Insurance, PeopleSoft FSCM 9.1 (Billing, Invoicing), Application Engine, Query

Confidential

Independent Consultant

Responsibilities:

• Reviewing various Requirement Gathering Documents and offering insights and recommending changes as relevant in a complex team structure and responsibility matrix.
• Coordination with Offshore testing resources to ensure testing is completed as needed and rotate between Onshore and Offshore resources.
• Developing and uploading test scripts to the HP/ALM test repository.
• Working closely with technical team to ensure various incidents and bug-fixes get tested as relevant before being released to productions.
• Activation of POXMLP feature for PO PDF generation in a selective manner resulting into significant saving on Pricing time for end users.
• Assessment of various bugs and defects coming up in Production and testing Oracle or in-house fixes.

Utilized Skill Sets: Healthcare, PeopleSoft FSCM 9.1 (Purchasing, eProcurement)

Independent Consultant

Confidential

Responsibilities:

• Assessment of various bugs and defects impacted by the PeopleSoft bundles 15 thru 23 on being applied to the client installation.
• Reviewing and Reclassification of marked complexity of the individual bug ids and assessing the risk and priority with SME on the team.
• Developed test scripts for testing individual bugs as relevant to the existing business process and system usage, and also for testing custom and delivered functionalities and processes
• Testing of various custom and delivered functionalities within PO, ePro, Inventory and Payables.
• Testing of End to End Processes PO, ePro, Inventory and Payables. For example Req to Voucehr, Replenishment to Purchase Orders.
• Document various defects and working with the SME and technical team to resolve and retest defects. (Bill-Only, Minimum Order, LUM, SciQuest, Special Request, Contract and Item sync etc)
• Assisted users during actual UAT testing to ensure scripts were executed in accordance with the fixes delivered where applicable. Participated in discussions to decide which scripts need not or could not be tested as per actual system usage and customizations.
• Assisted other consultant in Query and Report development as necessary.
• Custom Functionalities involving Minimum Order Consolidation, Least UOM, Contract Distributor and Markups, Bill Only and Repair Requisitions, etc.

Confidential

Independent Consultant (Integration lead, Solution architect & Support )

Responsibilities:

• Designed multiple new business process and technical integrations to support various business requirements. Worked with offshore resource on the development and testing the following.
• NEFT - Custom AR Credit to AP Refund process
• Mapped dealers to vendors thru delivered mapping fields. Loaded vendor data thru ExcelToCI component interface.
• Interface from legacy systems to Peoplesoft for the AR Credits
• Allowing users to manually select/deselect staged credits and/or add new.
• Redirecting those credits into the Refund process to feed to AP
• Managing the Vouchers with unique customer/vendor setup
• Managing payments thru individual pay group and paycycle
• Passing ACH details to related bank thru ftp with pgp encryption
• Ability to identify transactions that are in error or are stuck at any level.
• PART Notes - Customer AR to Financing/Note process based on various sales terms code
• Evaluating daily open AR to identify transactions eligible for financing
• Identifying the AR to Financing ratios per sales terms and other variables
• Consolidation of eligible transactions and generating corresponding credits and financing installments
• Tracking the processed transactions to prevent reprocessing
• Tracking the correlated AR Invoices with the corresponding credits and notes.
• Rate and Flat Charge - Ability to maintain various interest rates for dealers and service charges
• Dealer Interest Reimbursement for internal subsidiary
• Ability to identify Financed AR/Notes eligible for interest reimbursements
• Credit to be applied to customer AR for eligible interest reimbursement
• Ability to identify applied credits and print them as an invoice/report
• Ability to display monthly reimbursements to the dealer/customer thru customer portal
• Ability to generate and apply various service charges to dealers and family of dealers
• Different dealer groups have different level of service charges per month
• Dealer groups have individual or collective rates and caps per year.
• Eliminated the need to track charges manually and issue credits each month.
• Stellent repository for attachment
• Designed the logic to allow users to attach documents to newly entered Notes transactions
• Manage add/delete ability for such attachments based on if a note is approved or not
• Testing
• Participated in unit and system testing of above functionalities
• Worked with users in UAT and defect processing
• Participated in testing of other functionalities for interest processing different from reimbursement
• Coordinated partial go-live activities of pieces that were ready.
• Project lead during requirement, design, development and testing stages of the project. Coordinated weekly calls with internal and external partners to keep project moving forward.
• Designed and developed overall procure to pay process and solution to allow voucher details to be put on a trading portal/exchange for early payment for participating suppliers. It allowed better cash flow management for my client and early payments for the supplier.
• Developed custom extension to capture supplemental vendor attributes like pay terms, pay method, pay group bank and account at the AP business unit level.
• Developed custom extension to allow mass changes for vouchers for such attributes thru online screens.
• Developed an application engine that would realign new vouchers created thru online entry or batch interface to the above attributes before getting processed thru matching and posting. The same application engine also produced the outbound data file and applied inbound remit advice details.
• Outbound and Inbound solution used different approaches where data was moved thru SFTP, PGP Encryption, Unix and Mainframe.
• Senior process and data flow analyst during the assessment and discovery stages of the project to replace 40 year old mainframe based accounting and reporting systems.
• Analyzed data flow to various mainframe files and database tables and develop process and dataflow diagrams to identify ‘cut-off’ points of relevant data streams to identify the impact.
• Assessment involved data flow from various business activities like vehicle sales(new and used), warranty and notes/financing.
• Applied Bundles 14 thru 37 for Peoplesoft PO, ePro & SPro applications on version 8.9 and Oracle. Project was completed under budget.
• Lead Procure to Pay analyst and worked closely with business partners during testing stages.
• Served as data architect/integration lead for supplier and contract data across multiple systems impacted by the project. It included in-house demand planning system and new systems like eBS, ASCP and Demantra. Part of the project also included changes to the mainframe based payable system.
• Member of the strategic team which developed the cutover plan an environment builds. Contributed significantly in the decision and planning for the pilot go-live with select suppliers and develop parallel system maintenance between Pilot and ultimate full go-live.
• Designed the supplier and contract data interfaces from Peoplesoft to various application depending on it. Led the development team within Peoplesoft and WBI which developed web service based solution using integration broker and application engine. XML size was managed thru chunking.
• Participated in design conversation for Sourcing Engine and system splits and shut-down.

Confidential

Global Systems Administrator

Responsibilities:

• Implemented ePro/PO systems with workflow for UK. Led data conversion and testing efforts for the same. Developed the admin teams via knowledge transfer and mentoring. Defined high level Multi-Language requirements for Poland and other European countries.
• Designed and implemented workflow based Req to Contract process for UK and India.
• Defined business requirements and implemented best practices after detailed fit-gap analysis and designed dynamic solutions. Worked directly with various development and support teams in US and India (offshore) to optimize cost and use onshore/offshore model effectively and meet the budget and timelines with quality deliverables.
• Defined requirements and listed risk during implementation of Invoice Approval and Contract Release functionality to replace manual invoice processing steps. Used workflow for approvals.
• Defined requirements for a new PO Reconciliation and close process with user defined variables. Defined requirements for a new Receipt Close process to streamline accrual calculations.
• Collaborated with offshore developers and Dell technical team to integrate Dell-UK as a direct-link/Punch-out vendor.
• Reviewed, prioritized and tracked work pipeline from IT-teams as per the changing business requirements. Put various enhancements and fixes to stabilize the system.
• Maintained global ownership of the PO/ePro systems for functional setup, configuration, SOX-Audit and compliance; and leverage system functionalities to achieve higher user efficiency.

Confidential

Business and Technical Analyst

Responsibilities:

• Identified shortcomings and recommended best practices to save payroll cost for the payables, credit, purchasing, and warehouse teams respectively by system improvement and stabilization.
• Designed and developed multiple enhancements for specific business requirements and generated recurring savings of approx 250K per annum
• Analyzed, designed, and developed a new custom receipt accrual process replacing manual entries allowing better visibility to accruals in shorter timeframe and comply with SOX and audit
• Developed a new pricing system to ensure better price presentation at Order Entry time helping maintain and improve margins and profitability.
• Designed and automated the freight tracking process by developing a custom freight tracking and matching tool for real-time integration between warehouse and payable and reduce manual intervention and reconciliation
• Designed and developed a custom freight surcharge solution to Passover increased fuel and transport cost to customers and improve profitability thru auto-invoicing of the surcharges.
• Redesigned additional cost capturing tool, sales person charge backs, and improved sales and commission reporting.
• Implemented a complete EDI solution from PO thru EFT advisory earning an additional 1% rebate from a major vendor.
• Improved billing and invoicing process by changing the invoice sequencing and adding more details to the crystal invoices. This freed almost 2 hours per day for the Invoice sorting clerk Modified Pickplan, Packing Slip, Bill of Lading and Shipping functionality to assist warehouse operations gain efficiency. Implemented BlindShipping functionality via customization.
• Modified major application engines processes to develop customized solutions. (AP VCHRBLD, PO POCREATE, IN USG DSKTP, PO PORECON, BIIF0001) to meet specific business needs
• Implemented EDI Dispatch of Purchase Orders.
• Implemented EDI receipt of vendor invoices and auto generation of related Vouchers.