Jalaj Mehta

Responsibilities/Deliverables (Development):

1. Coupa Implementation and Integration with PeopleSoft

2. Vertex Implementation for Billing and Payables

3. Digital Signature and GSTIN Tax System Implementation for India B2B Invoices

4. Standardize Layout for Inbound Invoices to optimize development efforts and develop a system for processing data of order of 100m rows

5. Digital Signature for XML for Latin America Region

6. New Billing Business Unit Setup for APAC region

7. AWE Implementation for Journal Approval and Requisition

8. PUM 33 Upgrade Retrofits

9. Peoplesoft Business Dashboards with high refresh rate

10. Strata, Epic and Remedy Integrations for Various PeopleSoft Modules

11. Automated PO and Receipt Load from Spreadsheet and External Systems (Remedy)

12. Java and Python APIs for tasks which are not possible with PeopleCode (QR Code, Multithreading in PeopleCode, Encryption)

13. Stored Procedures for various latency sensitive tasks.

Responsibilities/Deliverables (Infrastructure):

1. Disaster Recovery System Implementation and Testing

2. People Tools 8.59 Upgrade and Project Management

3. Data Archiving Inhouse Tool Development and Implementation

4. Database Shrinking

5. Regional PeopleSoft Instance Setup

6. PingID SSO for PeopleSoft

7. Remedy and Splunk Integration

8. File System Cleanup Tool

9. Automation for various manual tasks

10. Regional Instance Setup and Data Migration

11. NAS Implementation

12. Gradual Shift to ERP Cloud (Benchmarking, and research)

13. Vulnerability Fix and Mitigation

Responsibilities/Deliverables (Support and Project Management):

1. Performance Tuning – Optimized several applications to reduce time and space complexity at both database and algorithm level

2. Review and Approval of Production Changes

3. Functional Support [ OM/BI/AP/PO]

4. Keeping System SoX Compliant

5. Coupa Post Go Live Support

6. Creating Agile User Stories and PI Planning with Scrum Master (Rally)

7. Recruitment and Mentoring (Fresh Grads, and Experienced Professionals)

• Manage a team with a mix of Contractors and Employee to develop world class visualization using Tableau, Chart JS and other Visualization Tools
• Use Knime/Python to transform the raw data into a consumable of the Visualization tools
• Use AI/ML algorithms to help clients predict the usage of resources for future assignments
• Manage Offshore ERP team for Business As Usual Support, and Development Projects
• Design and Develop Integration Solutions using Oracle Server Oriented Architecture, and Peoplesoft Integration Broker
• Functional Support for AR, AP, AM, OM, and GL

• Application development and support covering all PS Finance modules such as: GL, AP, AR, AM, BI, PO, OM Project Costing, and Real Estate
• Worked on customization of several delivered programs like AR_REFUND, AP_VCHRBLD, GL_JEDIT, BIIF0001, POCALC, POCREATE, POAM Interface, OMBILL, OMBACKGROUND etc
• Application development using a wide range of Tools and Technologies: IB, XML Publisher, Workflow Engine, Application Classes, Application Engine, Peoplecode
• Database side tools such as Triggers, Stored Procedures, analyzing Explain plan, creating indices of optimizing query performance
• Algorithm optimization to develop efficient programs
• Case Study on Software Engineering processes used in Efficient planning and execution of a Project
• Assist with configuration of PeopleSoft modules and integrating with existing ones
• Coordinate technical efforts for on-boarding new customers onto Procure to Pay solution
• Design and develop real-time interfaces utilizing Integration Broker messages
• Develop Test-Plan, Test-Script in a lead as well as hands-on role
• Liaison between functional and technical groups
• Design integrated Procure to Pay solution for outsourcing customer print purchasing
• Develop engine to load Purchase Orders, Vouchers from external sources using Component Interface
• Develop interface to load bills into PeopleSoft Billing
• Develop XML Publisher reports to meet client and internal requirements
• Develop Application Packages to assist with framework requirements
• Chartfield design & combo editing, business unit setup, ledger setup, allocations, consolidations, inter-unit accounting, journal processing, and multi-currency
• Debugging and fixing Support issues related to all above mentioned modules
• Implementation of RESTful services through IB and PeopleCode
• Report development for Real Estate
• Workflow development and customization for Requisition
• Asset Mass Transfers and several XL Upload processes

Project 1: PeopleSoft Upgrade for Financials and FTP (Multiple Instances - UK and HK) Jul 2012 – Apr 2013

Responsibilities/Deliverables:

● Designed a Framework using Application Packages to automate most of the configuration work.

● Compare report analysis and upgrade of technologies, from ‘AIX to Linux’, ‘DB2 to Oracle’ and ‘Financials 8.9 to 9.1’. Created Process flow diagrams and Analysis documentation

● Retrofitted AE, Application Packages, People Code, SQRs, KSH Scripts, Control-m JDS for Financials and FTP.

● Extensive data conversion using SQL Loader, RDSP [custom interface program], and Data Mover.

● Worked on mapping functional requirements to technical requirements. Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.

● Functional, Unit and Systems Integration Testing during upgrade of People soft system from 8.9 to 9.1, to ensure quality and accuracy of deliverables.

● Coordinated the application of bundles & patches for the enhancements.

● Working on the release documentation of the upgrade, code deployment and site implementation.

Project 2 :PeopleSoft General Ledger Implementation for Latin America Jul 2012 – Apr 2013

Responsibilities/Deliverables:

● Implemented a close to PeopleSoft delivered Vanilla General Ledger module.

● Designed and Developed a very efficient, fully configurable Publish and Subscribe process to publish and subscribe the Chartfield and Non-Chartfield related data between PeopleSoft-PeopleSoft and PeopleSoft-Non-PeopleSoft based systems. Implemented several complex algorithms to make the process as fast as possible even after reporting Emergency Changes and any Conflicts in the subscribe.

● Participated in the General Ledger configuration including Chartfield Design, Business Unit and Ledgers Setup, Inter-unit accounting, Journal processing.

● Documented all problems using Microsoft SharePoint tracking system. Documentation included requirements, design, development and testing templates.

Project 3: PeopleSoft Financials implementation FTP V2 (Multiple

Instances – UK, HK and Malaysia)

Jul 2008 – Apr 2013

Responsibilities/Deliverables:

● Performed support for General Ledger and other financial modules by answering questions, providing user and offshore team training, resolving issues and identifying the root cause of the problem.

● Designed and developed a custom tree upload program using PeopleSoft Tree APIs for loading hierarchies generated by a Hyperion System into PeopleSoft.

● Designed and developed a custom and fully configurable file upload utility through which any file could be uploaded into a Record without writing any code. Highly reusable and scalable program with the help of dynamic rules configuration.

● Implemented multithreading and parallel processing using Jobs and JobSet.

● Worked closely with functional colleagues to accommodate many changes to requirements and get the results on time.

● Oversaw testing of all Designed modules.

● Performed support for General Ledger and other financial modules by answering questions, providing user and offshore team training, resolving issues and identifying the root cause of the problem.

● New Programs were written using XML Publisher, several PeopleSoft pages and Application Engine Programs were updated to support process. PeopleCode, Application Packages, Component Interface was used for several modifications. All Batch scripts to process were written using Unix Scripting and job created in Control-M. Reports were done in XML Publisher and SQR.

● Tree Flattener and Denormalizer: Used to simplify tree hierarchies structures. Customized delivered application engine to include new attributes and written an Application Engine to De-normalize the tree with a better approach and algorithm than delivered.

● Designed and Developed a very efficient, fully configurable Publish and Subscribe process to publish and subscribe the Chartfield and Non-Chartfield related data between PeopleSoft-PeopleSoft and PeopleSoft-Non-PeopleSoft based systems. Implemented several complex algorithms to make the process as fast as possible even after reporting Emergency Changes and any Conflicts in the subscribe. It is written in highly reusable and implemented in 4 regions already without any major changes.

● Worked on implementing Connect Direct Setup for transferring files between different Systems.

● Designed and Developed Chunking for existing PeopleSoft pages having low performance due to high volume of data. Instead of loading entire row set at once, pages were customized to load chunks from database after maintaining same functionalities. User can view all rows retrieved from database seamlessly like before by using custom navigation buttons on the page. Chunk size can also be configured by the user at any time.

● Designed Internal Transaction Matching module to identify intra company balances using Application Engine (to perform calculations and matching pairs), XML publisher (reporting) and PeopleSoft Pages (overriding matched pairs).

● Designed and Developed Database Partitioning approach to performance tune several existing underperforming processes.

● Provided technical and overall support to team members in all stages of the project.

● Documented all problems using Microsoft SharePoint tracking system. Documentation included requirements, design, development and testing templates.

Project 4: PeopleSoft General Ledger Implementation for HTSU and

Canada Jul 2006 – Apr 2008

Responsibilities/Deliverables:

● Participated in the General Ledger configuration including Chartfield Design, Business Unit and Ledgers Setup, Inter-unit accounting, Journal processing.

● Implemented Reconciliation and Responsibility process that insures the integrity and completeness of financial information identifies and escalates emerging control issues.

● Redesigned an Oracle delivered Elimination Set Audit report to enhance performance. (Implemented using SQR)

● Designed a Report to perform the audit of maintenance done by the User in Accounting Rules. Accounting Rules are closely coupled with PeopleSoft Chartfield information and are maintained in PeopleSoft. They are used to segregate and calculate the balances from the transaction data received from several source systems. (XML Publisher and Application Engine)

● Designed and developed the process of getting exchange rates into PS 8.9 System. Oversaw development and testing. Coordinated efforts with functional users.

● Customized PeopleSoft Delivered Journal Entry Module to enable input of custom attributes, enforce custom constraints, High Speed Entry for data entry Operators.

● Customize PeopleSoft Delivered Edit Process to take into account the custom attributes.

● Documented all problems using Microsoft SharePoint tracking system. Documentation included requirements, design, development and testing templates.