o17 years of experience in Software Development/Maintenance, Testing and Implementation.
oVery good understanding of business processes in procure to pay, order to cash, source to settle areas.
oHand-on Techno/Functional experience in PeopleSoft Financials and Supply Chain Management.
oHaving good interpersonal skills - work well with others, motivates and encourages
oProficient in various traditional and agile/scrum SDLC methodologies.
oExpertise in People Code, App Engine, Application Packages, Integration Broker, Web Services, AWE, CI, BI Publisher, nVision, Tree Manager, PeopleSoft Update Manager, PS Query, Composite Query, Connected Query, SQR, SOAPUI, UPGRADE & Data Mover.
oFunctional expertise in SRM modules (Purchasing, ePro, sPro, Strategic Sourcing, Procurement contracts, Supplier contract management, eSupplier), Fin core (Account Payables, Travel and expenses, Account Receivables, Billing, General Ledger, Commitment control, Asset Management, Financial Gateway, Banking), ESA (Project costing, Grants), SCM (Inventory, Order Management).
Certification and Awards
oPeople Tools Certification.
oCPIM – APICS (Basics of SCM).
oOracle Outstanding contributor Award for Q1 and Q2 of FY2013.
Community Foundation of NW Indiana, Munster, (April 2018 to Till Date)
Role: Senior ERP developer Analyst
Modules: eProcurement, Purchasing, Account Payables, Travel and expenses, Account receivables/Billing, Asset Management, General Ledger, Commitment Control and Project Costing.
oRetrofit the customization (both classic and fluid pages) using 8.56 event mapping framework.
oConverted custom SQR’s (Requestor Favorites and Item buyer maintenance process) to Application Engine.
oDesign and develop a program to delete the unnecessary run control values created by business users.
oTrack, Diagnose, replicate, troubleshoot and resolve the customer daily raised bugs/ requests.
oImplemented Asset management module for the new business unit.
oProvide necessary functional training at client/customer sites.
oManage full lifecycle of Requirement, Design and Testing phases.
oDevelop solution design and lead client throughout implementation and support phases.
oPerform daily activity reporting against plans and schedules.
oImplemented Supplier onboarding process, configured supplier setup related to supplier online registration.
oConfigured GL Journal approval work flow and supplier approval work flow.
oImplemented fluid expense report by customizing the fields using page configurator.
oCustomized purchase order and AP voucher to auto budget check non-capital transactions.
oCreated and configured fluid pagelets/ fluid tiles/ dash boards/ work centers/ pivot grids/ composite queries.
oImplemented Vendor approval using AWE by customizing (Set payment on hold) the delivered logic.
oCreated Chart field display template, configured for fluid pages.
oDesigned online forms using form builder, specify the approval process, and deploy them to users.
oImplemented chart field request page and structure request template for the fluid pages.
Freddie Mac, Mclean, VA (July 2016 to March 2018)
Role: Senior Techno Functional Consultant
Modules: Services Procurement, eProcurement, Purchasing, Strategic Sourcing, Supplier contract Management, Account Payables, Travel and expenses, Account receivables/Billing, Asset Management, General Ledger and Project Costing.
oAutomation of AP vendors to sPro Vendors and Convert service provider to Provider Contact.
oEnhancement on Flipping the service work order status from released to open.
oDesign and develop a program to send notification to the users (Requestor and service coordinator) when there are any changes in services work order.
oPrepare system design documentation and provide direction to customers and junior consultants on which part of functionalities should be implemented first.
oProvide necessary support for Supply Chain and Financial Solutions.
oConversion of resource and multi resource work order from the legacy system.
oCustomized sPro timesheet for validating invalid and past end date project/release codes.
oDevelop a program to create user profiles/vendor users/bidders/Provider contact Since External users should come via Sailpoint and TAM in FreddieMac. So that Bidder can login, register and engage in bidding process in strategic sourcing module. Vendors access to view and modify their own business information and supplier side information like company address, phone, and contact data.
oWorked on the latest toolset People tools 8.55. Converted regular pages/components to Fluid pages/components and worked on applying PUM images.
oDeveloped Component Interface to extract data from flat files to Asset Management loader tables.
oTroubleshoot and Fix various Asset Management issues like Transaction Edit, Transaction Loader, Depreciation Calc, Accounting Entry, Depreciation Close, Journal Generator Etc.
oCustomized Asset history report TBL report and retirement report (by chartfield) as per business need.
oCreated Custom Grouplets (Fluid home Page) and used Form Factor Overrides and Default style sheets provided by Peoplesoft in designing the Fluid pages.
oAutomated the services procurement self-invoicing process and pushes to AP and PCS.
oExpertise knowledge in STAT tool for migrating projects from one environment and another environment.
oCreated new reporting trees for DEPT chartfields.
oDeveloped an nVision report using a matrix layout to show the payment history by vendor detail for a given fiscal year range and Converted custom crystal reports to BI reports in financial modules.
oDeveloped a vendor and region-wise nVision report to forecast the accounts payable in the following month.
oUnderstanding the business process, gathered the requirement, design, develop and implementation of new feature of allowing Offsite rate in service work order.
oInvolved in Upgrade 9.2 process, performed compare report and retrofit the custom changes to the new environment.
oImplemented 9.2 Docsign feature in supplier contract management for digital signature.
oDeveloped App engine programs to transferring the data between Peoplesoft sPro and Workday like send sPro data to Workday during on-boarding process, receiving CWID information from Workday.
oConfigured and implemented 9.2 Supplier on-boarding/ Bidder Registration/ Supplier change request using Activity guides/ Train stops.
oGathered requirement and developed various PS queries to help the client day-to-day activity, troubleshoot the end user issue and provided technical resolution.
oPrepared Technical design document and perform code review for peers and documented internal processes and procedures.
oImplemented Multi Factor Authentications(MFA) for PPI information pages using event mapping feature and used synchronous web services to send and receive the authentication from third party.
oUsed HP ALM tool for capturing defects, resolve the bug and provided detailed resolution.
oDeploy and crawled the Elastic Search for multiple components in supplier contract document management, ePro catalog search and Financial Sanctions validation in account payables.
oConfigured and implemented the Financials Audit Framework (audit logging) provides efficient tracking of transaction processing that results in enhanced visibility and detailed audit trails.
oCreated database triggers for auditing the important tables and materialized views for complex SQL queries.
LivingSocial Inc., Washington DC, USA (May 2014 to June 2016)
Role: Senior Programmer/Analyst
Modules: Account payables, Treasury/ Cash Management, Purchasing, General Ledger, Asset Management, Billing and Account Receivables
oTrack, Diagnose, replicate, troubleshoot and resolve the customer daily raised bugs/ requests.
oCustomized the Product Operating Statements nVision report.
oDeveloped Matrix & Tabular layouts for Income statements reports, Cash-flow statement reports, Balance sheet reports, Equity reports.
oGlobal roll out purchasing modules to United Kingdom, Ireland, Australia and New Zealand.
oPay cycles issue, month end reconciliation issues, multi-currency and journal errors, year-end close, monitoring the batch jobs, integration broker issues, setting up user security.
oDeveloped Interfaces using Component Interface to extract data from flat files to Asset Management loader tables and EC tables.
oEvaluated, customized and set up workflow for Journal Entry Approval, Asset Transfers approval, Voucher Approval Processes, Receivable processes.
oProvided the interface to create Journals from the third party Concur system.
oSupported the third-party Auditing firm during Audit every quarter.
oPrepared monthly cash forecasts and reconciled cash and investment accounts.
oLead and directing the project teams in-terms of business processes, gathering requirements and involved in creating Fit-Gap analysis and Functional/Technical Design Documents.
oCreated multiple BI reports in purchasing to support different shipping methods.
oEnforced the PeopleSoft row level security and secured the data within teams.
oResponsible for syncing up the vendor from the third-party system (Baynes).
oAutomated ACH returns(ISO/NACHA) from banks and configured bank set-up/ bank layout for ACH/ WIRE methods.
oProvide the setup/values and upload the data into PSFT journal thru spreadsheet utility.
oDeveloped a bank statement reconciliation program.
oCreated nVision Balance Sheet, Income Statements, Trial Balances reports.
oLoad missing Deals across BU by GL teams and Populated voucher data from excel using SOAP UI.
oProvided a flexibility to make express payments easier - to allow exclusion by deal vs by vendor ID.
oReceipt Integration to PSFT from Warehouse system.
oDeveloped a program to schedule the merchant pay cycles.
oIdentifying and resolve all day to day recycling vouchers issues.
oInvolved in syncing the BSFT vouchers to PSFT.
oIntegrated with third party payroll system to create PSFT Journals.
oCreation of various drill down reports as per the user expectation using PS Queries.
Expedia Inc., Bellevue, USA (June 2013 to April 2014)
Role: Senior Financial Consultant
Modules: Account payables, Purchasing and General Ledger
oResolved the day to day customer raised bugs and requests.
oRun payment report to send the payment information for the expenses claimed to third party application CONCUR
oResponsible for vendor load program, which is used to create/update the vendor details from Affiliate system.
oCreated Tabular nVision reports as per client requirement and created various Summary Reports for General Ledger using nVision.
oParticipated in Configuration of Business unit, Approval work flow and Bank account creation.
oPoint of contact for any issues during the close month activities.
oRun monthly end report - consolidation process, Revaluation process, blackline account and currency extract process.
oResponsible for procurement and payment related activities.
oScheduling of PO/AP reports and batch jobs through Process Scheduler.
Oracle India Pvt. Ltd., (Nov 2005 to June 2013)
PeopleSoft Enterprise is a family of best-in-class applications based on Pure Internet Architecture designed for flexible configuration, open and multi-vendor integration.
Role : Lead Developer/ Code reviewer/Technical Architect
Environment : PeopleSoft FSCM 8.x/9.0/9.1/9.2
Module Handled : Purchasing, ePro, Supplier Contract Management, Account Payables, Travel and Expenses, Services Procurement, eSupplier, Strategic Sourcing, Inventory, Asset Management, General Ledger, Commitment Control, Order Management, Billing and Account Receivables.
oTo analyze the reported complaint and confirm it from the base functionality.
oTo derive at a possible defect point in the steps taken to replicate the customer scenario’s.
oTo debug the identified defect points and resolved 600+ bugs.
oTo perform impact analysis and come up with a solution plan that ensures less/no impacts.
oInvolved in maintenance and support development from release 7.5 to 9.2 releases.
oTo unit test the solution for all the requirements provided by the object of defect.
oEfficiently handled lot of critical and escalated bugs raised by customers. The issues were on India TDS, 1099 withholding, Matching, Pay Cycle, Voucher Posting and Payment Posting.
oConducting training to the new joinees and shared the process and procedures.
oDesigned and configured combination edits, closing rules, payment handling codes and payment term timing codes.
oCreated Inbound and Outbound interfaces using Application Engine.
oExpertise in PeopleTools 8.5x/8.4x/8.1x (Application Designer, Data Mover, PS/Query, Process Scheduler, Application Engine, Configuration Manager, Process Monitor), PeopleCode, Component Interfaces, Web services, Workflow, SQR, Crystal Reports, XML Publisher.
oDesigned and configured match rules, payment source and payment term timing codes.
oDedicated developer for Workflow issues
oWorked on the Verity Search feature, Handling Direct Connect Issues (Punchout, Roundtrip) in ePro module.
oResolved the Timesheet, Progress Log, Expense incidents/bugs for PeopleSoft service procurement.
oTuned the performance of the SQR reports/ AE programs using SQL, Stored Procedures and Temp Tables.
oPeopleSoft Enterprise Expertise in Procure to Pay Cycle, Source to Settle, Order management, Inventory and Billing.
9.1 New Features Developed:
Provided extended PO Rollover selection criteria that include the use of operation qualifiers and range of values to enhance flexibility.
Developed the disqualify purchase order exception reports using XMLP.
oPO XMLP dispatch:
PO Dispatch via XML Publisher allows you to easily configure the layout of your dispatched purchase orders to meet the needs of your organization and suppliers.
Use this data as a starting point to create your own layout for purchase orders using the XML Publisher.
oConversion of requisition HTML print to XMLP print.
Converted the HTML print version to XMLP print.
User can view/display the report with or without the distribution details options.
Displays the service line details depend on the system source.
oCreation of recurring voucher contract when awarding a strategic sourcing event.
Provided a new option to create recurring voucher contract from an award page.
Modified the component interface, pages, record and fields.
Other ERP’s Experience:
STEERPRISE (Elmaq Software Pvt Ltd., from Jan ‘03 –Jul ‘04.)
MAARSMAN (MAARS Software International Ltd., from March 2001 - December 2002)
Master of Computer Application, University of Madras, Chennai, TN, India
1995-1998 Bachelor of Science (Mathematics), Pachaiyappas College, Chennai, TN, India