SUMMARY:

• PeopleSoft FSCM Senior technical consultant with 12 years of experience in Insurance, Retail, Manufacturing, Marketing and Automotive domains. Worked as a developer, Sr developer, team lead and project/module lead in different organizations.
• Oracle Certified PeopleSoft Application Developer with knowledge on PeopleSoft migration to Oracle Cloud Infrastructure, PUM image apply, Upgrade, Re - implementation and Support projects.
• Rich functional and technical knowledge (SME - Subject Matter Expertise) on AP, PO, BI-AR, GL. Experienced with CT, PC, Time and Expense module
• Experienced in various stages of SDLC - requirements gathering, Fit-Gap analysis, Technical & Functional specifications, design, development, customizations, workflow, data mapping, conversion, code reviews, Functional Testing, System Testing and Integration testing of PeopleSoft Applications, user and production support and project management.
• Experienced in multi-currency accounting entries and supported Peoplesoft application with global scope.
• Worked in PeopleSoft latest versions. FIN 9.2 and tools 8.57.
• Extensive knowledge on SQR, PeopleSoft App Package - Integration Broker (Synchronous and Asynchronous), CI, AE, SQR, File Layouts, Peoplecode, PS Query, Process Scheduler, Configuration Manager, PeopleSoft Security.
• Worked in proposal team of previous Organization on PeopleSoft Procure to Payment Flow.
• Worked in multiple customer engagements, Proof of concepts, Due diligences with rich experience in Business and IT Interfacing.
• Knowledge on tools like SOAP UI, PHIRE, STAT, QC, PPM, PVCS tracker, QPASA, AUTOSYS, BMTM, IBM MQ’s, MTE, SERVICE NOW, RALLY.
• Exp with Unix Command and Autosys Job/JIL scripts, PL scripts and Agile Methodology
• Flexible and experienced in developer, support, team lead and project management roles in ERP World.

TECHNICAL SKILLS:

PeopleSoft Functional Skills: PeopleSoft Financials7.0,, 8.8, 8.9, 9.0 and 9.1 and 9.2, Time and Expense, AP, PO, BI-AR, PC, CT, GL

PeopleSoft Development Tools: People tools 7.1, 8.48, 8.50, 8.55

Integration & Administration Tools: People Code, File Layout, Application Engine, Component Interface, ExcelToCI, App Package, Integration Broker, PS Security, Configuration Manager and all PeopleSoft objects, Tree Manager, Crystal reports, Microsoft Office Suite, MS Project, Visio, QuickBooks.

PeopleSoft Reporting Tools: PS Query, SQR, Oracle Reports and Pl/SQLOther Tools: STAT, PPM, PVCS tracker, SOAP UI, PHIRE, QC, QPASA, AUTOSYS, BMTM, IBM MQ s, MTE, SERVICE NOW, RALLY, PUTTY,ACCUREV,WINSCP, GITHUB

Database: My SQL, Oracle 9i, 10G, 12C, DB2, Microsoft SQL Server 2008&2012, Teradata

Scheduling Tools: PeopleSoft Process Scheduler, Windows Task Scheduler, Autosys, Unix jobs

WORK EXPERIENCE:

Confidential

Peoplesoft GL global Team lead

Responsibilities:

• Lead of PeopleSoft Global GL application which is spread across 50+ countries and 90+ global locations.
• Provide Tech lead and functional support to GL Allocations, Revaluations, Translations, Reversal and several other PeopleSoft GL functionalities.
• Provide SME support to SAP team for PeopleSoft GL to SAP Reimplementation. Worked on data migration for PeopleSoft to SAP and data center migration to cloud.
• Assess impact of various projects (new business launch or new interface) to PeopleSoft GL module. Design the projects, implement new business unit, configure PeopleSoft financials setup and interface processing as per the requirement and support end to end functionality.
• Provide application support (24x7) for PeopleSoft GL financials module using the knowledge of PeopleSoft Functional and technical objects like Application Engine, SQR, PeopleCode, Unix job scripts, Perl/shell scripts and scheduling tool Autosys.
• Troubleshoot day-to-day issues related to PeopleSoft financials GL (Allocation, Combo Edits, Revaluation and Translations, Consolidation) through data fixes or PeopleSoft online or through tools and provide solution in a timely manner adhering to the SLA of Ford’s global business.
• Create/Update/verify custom reports of Account reconciliation, Trial balance reports, financial close reports extracts in PeopleSoft as needed.
• Support critical month end and year end business processing by running and scheduling different PeopleSoft and Mainframe Jobs in Autosys.
• Perform Disaster Recovery on all the different servers. In addition, archival of the data from the table to History table on a timely manner.
• Streamline the Current Structured Query Language (SQL), PS Queries, stored Oracle/DB2 Procedures, UNIX scripts or job scripts for improved performance as per Business needs.
• Support PeopleSoft tools Upgrade. Worked on Performance issues with GL edit post and several other SQR reports.
• Support new Business Ventures in terms of system implementation when organization buys or acquires another product or company from market.

Confidential

Sr Business Analyst

Responsibilities:

• The position focuses on implementing new business units with a primary focus on collecting, interpreting and implementing local statutory requirements.
• The role has a significant focus on GL, VAT, TAX, WITHHOLDING, P2P, CONTRACTS, BI-AR, and AP TO PC, PC TO BI subsystems.
• The scope of the responsibility is global to serve as link between business and all application development, support, maintenance activities and provide strategic consulting-level guidance.
• As a new employee in this organization, first deliverable was to design Employee Self service under Expense module for Europe business units. Employees will be entering their expense bank account details which should align with the European banking standards and expense will be paid through AP Paycycle.
• Currently working on designing Voucher hold logic when interunit vouchers beyond a certain threshold amount will not be paid until same has been cleared by customer in billing.
• Created custom Approval Workflow process on PO and Vouchers.
• Worked on adhoc report creation from GL tables and Subsystem modules using both PS Query and SQR.
• Worked on subsystem accounts balancing issues after identifying error’ed out Journals.
• Cleared 10 years old subsystem accounting entry issues by creating new accounting entries through script to balance APA and EXP.

Confidential

Lead Developer and Support Lead

Responsibilities:

• Module lead of production support (24*7) and enhancement activity which includes new projects/requirements.
• Support responsibilities involve bug fixing and debugging existing SQR Jobs, Peoplecode, Application Engine, CI and Integration broker Synchronous and Asynchronous messages.
• Support responsibilities involve Paycycle processing and interface data processing and support all real time transactions. Job failures, root cause analysis of critical issues and providing permanent resolution.
• Support responsibilities include month end processing and posting accounts payable accounting entries to GL after validating SQL checks.
• Supporting custom built 1099 process and financial reporting designed through SQR.
• Support responsibilities also include application availability management for infrastructure related changes/outages/NAS migration/ UNIX server related changes.
• Created new Bank accounts setups for USA and Canadian BANKs including positive pay reconciliation. Experienced in setting up new USA and CAN bank accounts and BANK reconciliation process from scratch.
• Automations done on Supplier Creation, Dummy TIN generation and TIN maintenance.
• Creating and Modifying Voucher load process, STOP process, EFT Prenote Process, reporting, 1099 processing, month end processing/reporting through custom SQR process.
• Developed SQR, AE, CI, synchronous and Asynchronous IB for different interfaces. New APP packages for Web Service call.
• Involved in latest PUM image (Image 26) apply on current version9.2 (Image 19). SME support to 9.2 upgrade team on current application flow/functionalities.
• Providing Functional flow KT to business users on Voucher creation, Voucher Approval, Paycycle, Check creation, Bank reconciliation, GL posting, 1099 functionalities and BackUp Withholdoing.
• Creating new Batch/process with IB/CI to support and enhance real time processing.
• Creating Autosys and Unix based jobs and supporting Autosys scheduling.
• Creating W9 reporting docs with adhoc based SQR process every year during Year end processing
• Interacting with Client and Business users during analysis, design, development and delivery of enhancement requests in form of tickets/service requests to provide the quality deliverables.
• Performance Tuning of SQL and parallel processing.
• Tech lead review for PHIRE/STAT changes on both data fixes and Code migrations and getting update from team members on work progress during huddle calls.
• Driving team to Agile.

Confidential

Developer and Module Lead

Responsibilities:

• Working as a Subject Matter Expertise (SME) to customer and module lead for Accounts Receivable and Billing where Client maintains the financial transactions for the Policy holders under Group Benefits.
• Multiple Bug fixes and incident resolution on ARUPDATE, PAYMENT Predictor, Write-off, over payment Items.
• Providing resolution to Production Support critical issues within SLA. On call support to customers.
• Providing functional support in Billing and AR modules to end users.
• Designing new processes through SQR and AE to support new functionalities.
• Interacting with Client and Business users during analysis, design, development and delivery of enhancement requests in form of tickets/service requests to provide the quality deliverables.
• Maintaining the infrastructure of the application support and work on server migration.
• Imparting on application flow/functionality to new team members.
• Providing support and development in SQR, Application Engine under PeopleSoft 7.0 which is not supported by the vendor (Oracle).
• Support to Oracle Report components which are closely associated with the PeopleSoft application.
• Understanding the automation ideas from BPO team and designing processes to minimize manual work for the users and application Point of Contact for IT-BPO synergy.
• Application release support
• Creation of scripts/batch/utilities to manipulate data
• Involve in all stages of Project Development Life Cycle including System Business Process Analysis, Business process Re-engineering, Requirements Study, Fit-Gap Analysis, High Level Design, Detail Design, Application Development.
• Interacting with Business User to understand the business scenarios of day in day out transactions.
• Designing Functional and technical design documents for customized business scenario of GL module.
• Reviewing Technical Design docs for the newly developed processes to meet the existing business functionality in PeopleSoft FIN.
• Developing new processes in Application Engine and SQR.Involved in data conversion for the Accounts Payable module
• Worked in the requirement to run the Journal upload process for multiple files without changing the delivered app engine.

Confidential

Developer - Retail Client PeopleSoft Finance - Upgrade

Responsibilities:

• Analyzing the existing functionality of FIN 9.1 application and the customized objects used in PeopleSoft FIN 8.8.
• Comparing Support module of FIN 8.8 and FIN 9.1 to understand the difference in functionality and prepared the functional specification for upgrade.
• Understanding the requirements of the objects to be upgraded and involved in preparation of technical specification documents for online objects and SQR’s.
• Development of the customized objects that needs to be upgraded to 9.1 using Application Designer and People code.
• Reapply of online objects and SQR’s and reporting tools.
• Involved in the online reapply and retrofitting of objects and completed AP, PO, GL Subsystems with full ownership.
• Involved in preparation and execution of the test scripts and performed Unit Testing.
• Involved in fixing Critical defects related to Voucher Build, approval and Pay cycle.
• Work experience involves creating Technical design docs after analyzing the requirement from business users.
• Design document go through and review with the team members.
• Designed Application Engine for specific functionalities in AP, PO and performed multiple load testing in UAT environment.
• Designed Defect tracker tool for System testing as part of SIT support.