Jaidev Balchandani

• Working with Business Team , Legacy Team owners for finalizing the requirements to convert certain Business Units in Peoplesoft Inventory and Purchasing into a new entity.
• Working with Legacy Team Owners to finalize requirements in inbound and outbound interface files.
• Documenting and Creating Techincal Requirements for all Screen Changes, Peoplecode changes, Application Engine changes.
• Coding the Application Engine changes , migrating and testing changes through dev and test environment.
• Assisting Business in creating test cases, test data and performing user and quality testing.
• Participating in daily stand up calls , providing status update on user stories and working on any impediments.
• Worked on creating and scheduling PSQUERY's .
• Worked on designing and creating security objects like Permission Lists and Roles for granting access to Pages and peoplecode objects.

· Creating JIRA stories , technical specifications for loading SAP Data from datawarehouse into a Sql Sever Database.

· Performing Data Analysis in data warehouse , running queries, creating new queries , validating queries with Business•

· Designed Technical Scripts, data mapping documents , Jira Stories to load PeopleSoft Data from datawarehouse to Sql Server database

· Creating JIRA stories , technical specifications for loading Peoplesoft Data from datawarehouse into a Sql Sever Database.

· Performing Data Analysis in data warehouse, running queries, creating new queries, validating queries with Business•

· Designed Technical Scripts, data mapping documents , Jira Stories to load Peoplesoft Data from datawarehouse to Sql Server database

· Participated in daily stand up call , providing updates on coding progress and resolving impediments.

· Assigning stories to offshore resources, maintaining appropriate coding standards, performing code migrations to test environments.

· Participated in User and QA testing ,documenting test results , working with change management team to migrated code to Production

Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (PO, Inventory, GL, AP, AR)
• Designed and Developed Several Custom interfaces to AR, PO, AM, Inventory, AP and GL Modules.
• Designed Purchasing workflow process.
• Troubleshoot GL Journal Edit issues.
• Worked with Business unit, setup Ledger
• Designed and support of INV and ePro interfaces.
• Designed and developed custom interfaces. Interacted with the Users and Functional analysts to come up with new requirements for the business unit. Worked with Long Term and simple receivables.
• Troubleshoot and helped to resolve supplier purchase order and invoice issues
• Tested modifications to ensure they meet customer’s specifications. Provided on-call support to the end-user.
• Developed customizations using Application Designer for AP, PO and INV.
• Involved in the analysis and implementation of PeopleSoft OM for Capturing and Validating Orders.
• Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules.
• Fixing of problems and issues which come across during various stages of implementation like development, User acceptance and live of project costing
• Extensively involved in Post-Production Activities, Documentation and end user training.

Conducting Meetings with FInance Business Team to gather qualifying requirements to select transactions for archiving.

Conducting Meetings with Business Team to determine Months of transactional data to be stored in Peoplesoft.

Create Technical Design documents detailing the Application Engine , Pages and Record Peoplecode required for Archiving Project.

Worked on Application Engine Programs, PeopleCode, Modified and created Components as part of development work.

Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules.

Documenting and recording test cases , getting signoff from customer and product team , closing user stories.

Worked with Business Teams to design solution on how to process and journalize transactions happening between Peoplesoft and SAP Business Units.

Create new distribution Types , Accounting Rules to process Interunit transactions between SAP and Peoplesoft.

Designed New Inbound and Outbound Interfaces to calculate and create interface files to load cost from SAP and to SAP.

Designed New Application Engine Programs ,Record Definition, Custom Pages to create custom accounting entries for interunit transactions.

· Developed integration mapping templates between legacy and PeopleSoft Inventory.

· Developed application engine programs to write translation logic between legacy and PeopleSoft.

· Developed custom Application Engine programs to automate creation of Inventory Business Units.

· Developed custom Application Engine programs to create Inventory Business Units configurations, Interunit Shipping configurations creating interunit shipping relationship between items and business unit.

· Worked with business team to setup cost profiles for costing inventory transactions.

· Worked with business teams to setup configurations for creating accounting entries for inventory related transactions.

· Developed Custom Application Engine Programs to code complex Inventory Period end processes like quantity reconciliation and Dead and Excess.

· Developed Custom Application engine programs to code archiving logic for archiving inventory transactions.

· Developed Application Engine program to load Item Master Data from legacy to PeopleSoft tables including purchasing attributes.

· Developed custom application engine program to cost labor, machine, and contract manufacturing and calculating indirect overhead for production related transactions.

· Developed custom Application Engine programs to calculate manufacturing variances between Bill Of Material cost and the actual production cost. Variances are calculated and reported daily.

· Developed Component Interfaces to automate rtv adjustment transactions.

· Developed Excel to CI for interfaces to load labor, machine and miscellaneous charges rates via excel into peoplesoft.

· Developed custom interfaces between purchasing and inventory for bulk processing of rtv ship and rtv scrap transactions using App Package and Application Engine program

· Developed custom batch processes to loading custom Bill Of materials into PeopleSoft using Application Engine.

· Developed custom Application Engine programs to cost production completion transactions.

· Developed custom reports using sqr.

· Developed custom queries using PSQUERY.

· Created Journal Templates, Journal Definition for interfacing accounting entries between inventory and General Ledger.

· Developed custom Online Pages.

· Developed unit test cases and technical specification documents for converting business requirements into technical requirements.

· Worked in SLA driven environment which includes answering to business questions, queries based on priorities.

· Worked with business to do Fit Gap Analysis, suggest changes to system or configurations to accommodate business needs and also suggest best solutions in PeopleSoft.

· Worked in Production Support Model for Asset Management module which involved Loading Assets from interface tables into PeopleSoft, Fixing jobs abends related to Calc Depreciation process, resolving business users issues or inquiries regarding asset transfers. Balances.

· Worked on performance tuning of long running Application Engine programs which involved identifying long running queries working with DBA for creating indexes.

· Worked on creating Application Engine Programs for automation of repetitive tasks for business users.

· Planning and forecasting the project deliverables, monitoring the individual tasks and perform environment sync at regular intervals of time.
• Coordinating with the Legacy system consultants to understand the data volume in different modules like procurement, PO, Accounts Payable AP , Accounts Receivable AR, Asset Management AM , General Ledger GL and decide on the Cut Off date for data migration.
• Discussing with Clients and Finalizing the chart field information to be implemented in Peoplesoft
• Field to Field mapping from Legacy Systems GP, MCF to Peoplesoft
• Created data scripts for data migration.
• Writing Interface programs AE to connect third party systems which used to send data to Legacy systems to Peoplesoft
• Developed several SQR Crystal reports to generate similar reports which client demanded to be part of migration.
• Worked with end users for scheduling End User testing and getting testing done.