SUMMARY

• Over 10 years of professional experience in the information systems of finance industry with extensive experience in design, development, upgrade, implementation and support in PeopleSoft financials
• Experience in PeopleSoft FSCM 8.4 through 9.2 - Asset Management (AM), Accounts Payable (AP), General Ledger (GL), Grants Management(GM) Cash Management(CM), Treasury{Banking, CM, Financial Gateway}, Project Costing Contracts & Billing (PCB), Travel & Expense (TI & EXP), Accounts Receivables (AR), Purchase Order (PO) and Procurement (ePro){Procure to Pay Life Cycle}, Commitment Control
• Proficient with PeopleTools 8.x/9.x, including Application Designer, PeopleCode, Query, Process Scheduler, Workflow, Application Engine, Tree Manager, Security.
• Proficient in module development, production support, upgrade, interfacing, conversion, data migration and report writing using PeopleTools 8.x/9.x and SQR’s
• Extensively worked with Integration technologies such as Component Interfaces and Application Messaging Programs to integrate PeopleSoft Applications with external applications.
• Designed and documented various inbound/outbound interfaces for PeopleSoft with various 3rd party systems using AE and SQR.
• Participated in all phases of ERP life cycle; implementation, customization, development, production support and upgrade.
• Experienced in Integration Broker and financial gateway setups for different payments.
• Experienced in fluid setups, Workcenters and dashboards.
• Involved in Updates & Fixes; Production and post-implementation support. And provided Techno-Functional support to address any production issues/bugs and enhancements.
• Expertise in the creation of reports using SQR, PS/Query, PS/nVision and XML Publisher.

TECHNICAL SKILLS

ERP Tools: PeopleSoft Financials/Supply Chain Management Modules (Accounts Receivables, Billing, Contracts, Expenses, Inventory, e-Procurement, Projects, Cash Management, Treasury General Ledger, Project Costing, Accounts Payables, Purchase Order, Asset Management) and HR modules

Development Tools: Application Designer, Application Engine, and People Code

Administration Tools: Configuration Manager, Tree Manager, Process Scheduler, Process Monitor, Report Manager, Upgrade Assistant, Security Administrator and Utilities

Integration Tools: Application Messaging, AWE, Core Work Flow, Component Interfaces

Data Management Tools: Import Manager and Data Mover

Reporting Tools: SQR, CRYSTAL, PS/Query, PS/nVision, Oracle Discoverer and XML Publisher.

RDBMS: ORACLE 12/11g/10g/9i/8i, MS SQL Server, DB2

GUI: PeopleSoft Application Designer, Oracle Developer/2000

Languages: SQL, PL / SQL, SQR, JCL, People Code, XML, HTML, C#, VB.

Scripting Languages: PHP, PERL,PYTHON

Operating systems: Unix, Windows

PROFESSIONAL EXPERIENCE

Confidential, Livingston, New Jersey

Senior PeopleSoft Techno Functional Lead

Responsibilities:

• Reviewed current business process and gather requirements for future state business process for PeopleSoft 9.2 systems in Finance modules GL, AP, AM, Purchasing, eProcurement, Treasury{Banking, CM, Financial Gateway}.
• Fit/Gap Analysis ---Identified gaps and develop alternatives to meet requirements
• Design and develop PeopleSoft Custom features, such as enhancement to automated user Maintenance process which involves creation of user profiles/deletion of terminated users, dynamic role assignment.
• Develop program for attachment functionality to inbound vouchers from different third parties.
• Automated the manual task of entering consolidations and elimination sets into different environment using File layout and Cis.
• Created custom search attachment functionality component for all modules, journals attachment search, voucher attachment search, requisition search, purchase order attachment search, vendor attachment search.
• Lead the performance test effort of the project in reviewing the long running processes, reports and providing the solutions to improve the performance. Several nvision reports and Application engine and SQR’s are tuned as part of the process.
• Implemented and configured workflow through AWE framework for GL Journal Approvals and Vendor and Voucher Approval in 9.2.
• Create Function Design Specification documents for modifications and customizations Provide knowledge transfer to client’s technical team and assign work through Service Now.
• Create a business process narrative document in support of the process flow diagrams. Identify and document all system configuration changes related to automation project and complete configuration tasks.
• Responsible for the day to day operations of GL/AP/Purchasing/AM/Treasury.
• Assisted in several security related enquires from Users and resolved the issues.
• Worked on creating PS Queries and nVision reports for General Ledger.

Environment: PeopleSoft FSCM 9.0/9.2, PeopleTools 8.54/8.56/8.49 , Integration Broker, PeopleCode, PSQuery, Fluid, PUM, SQR, ServiceNow, HP QC

Confidential

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Planning, scheduling, and conducting in fit/gap sessions for implementation/upgrade of PeopleSoft Financials (Procure to Pay,AP, BI, AR, Expenses, CM, GL) with different stake holders to ensure the functionality changes of 9.2 for PeopleSoft Finance and Supply Chain and to verify if they can replace the existing customizations.
• Developed inbound and out bound AE interfaces for Taleo Reporting to Workday.
• Developed SQR programs to extract HR data from Workday and send it to AON servers.
• Developed GL conversion to convert historical data, journal activity and ledger balances from PeopleSoft 9.1 to PeopleSoft 9.2 system. and Supplier data is converted into new environment using the Excel to CI
• Different SQR, nVision reports are retrofitted as per the client needs and all of the Crystal Reports are converted to BI publisher reports. AP checks with MICR fonts are customized as per client needs.
• Assisted business users in the running the whole financial sanctions process.
• Used the data migration workbench tool for migrating configuration data.
• Automated the Kofax Invoice imaging with Account Payable.
• Integrated PeopleSoft financials gateway with CM and AP modules.
• Worked on PeopleSoft Integration Broker setup for bank statements, payments and payment acknowledgements.
• Worked on banking interfaces including EDI files, bank statements (BAI and Swift) and payment files (Wire, ACH, EFT)
• Worked on the setup of bank reconciliation rules and setting up reconciliation process.
• Configured PeopleSoft security, role and permission list setup in a manner which only the AP and Treasury administrators have access to payment dispatch pages and processes.
• Setup of the Work Centers and Dash Boards/Pivot Grids for AP, AR, GL and Treasury Management.
• Implemented the Integration of PeopleSoft with elastic search.
• Involved in the Cash management bank reconciliation process.
• Implemented Vendor self-service project.
• Involved in PeopleSoft Testing Framework (PTF) during the upgrade..
• Configured approvals for vouchers in Account Payable and in Expense modules for approving the expenses with the Fluid UI and assisted in Fluid UI setup.
• Extensively involved in configuration of different Business units, Chartfield Combination rules, allocations, consolidations, bank setups, procurement options and common definition setups in eprocurement, AP, AR, BI, EX, CM, GL modules.
• Modified the allocation rules to make use of utilizing the new functionality of excluded values in pool section to and tested the GL ALLOC process.

Environment: PeopleSoft Finance and Supply Chain 9.2 and 9.1, PeopleTools 8.56, nVision, PeopleCode, App Engine, File Layout, Excel to CI, App Packages, SQL Server, Oracle.

Confidential

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Configured different business units setup in epro, purchasing,AP and General Ledger modules in 9.2 version.
• Worked on development of Custom Interface program (CIP) which act single template for all the different custom inbound outbound interfaces in AP and Purchasing modules for vendors like URS, GENIUS, KYRIBA
• Involved in the development and successful implementation of Foreign exchange rate custom Interface using integration broker.
• Automated batch processing of different jobs and job sets by gathering the necessary information by Functional users and collaborated with QA team in providing Technical details for testing.
• Configured treasury work centers which centralizes and simplifies navigation for users who need to access processes and reports in cash management, banking and financial gateway.
• Leveraged Cash Forecast and positioning enhancements in the new 9.2 treasury environment.
• Customized Treasury accounting to prevent same user to approve their own accounting entry and utilized the setting up same substitution rules for different accounting templates.
• Utilized Financial Gateway security functionality to restrict sensitive Bank Information and processing Capabilities. These security features are based on Users and Roles.
• Enable the reversal accounting entry features in treasury for the users to access the new features.
• Developed and worked on several BI Publisher and nVision reports along with different queries
• Developed different AP approval rules for US Business Units and UK Business Units.
• Customized the Pay cycle Selection Criteria Page.
• Configured the audit tracking encompassing Chatfield and security maintenance
• Configured different Chatfield combination rules and has setup the rules for allocations in General Ledger.
• Different bank account setups and pay cycle, check printer settings are configured as per the business users requirements.
• Developed several data mover scripts effectively for migrating the several consolidation setups, Allocation Setups, Multi Currency Setups, Journal & Ledger data, account data map sets as and when needed by the end users.

Confidential, Boston, MA

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Responsible for designing, building, testing, documenting and implementation of new system functionality including system customizations, system data interfaces, programs, reports and queries according to industry best practices and vendor recommendations
• Provided technical and operational support to the users of the financial systems including answering questions; assisting users with processing, reporting and querying functions; developing new reports/queries as needed; providing training programs, etc in all the FSCM modules i.e eProcurement, purchasing, AP,GL,AM,BI,AR and PC modules.
• Designed and developed taxability update/change logic in Billing Module.
• Acted as the PeopleSoft Security administrator
• Involved in Epro Department amount Approval workflow definitions setups, user lists, related user roles.
• Designed and developed a program to mask the Bank and vendor SSN information on PeopleSoft online inquiry pages.
• Involved in conversions of Project costing codes such as Budget Category, Contract Category, Final Fund Category and Final Fund Code.
• Developed and implemented a component Interface program to inactive all the Projects that are identified by Project Costing manager and Accounting users.
• Setup Sub Customer 2 and developed New aging reports based on Sub customer 2 functionality.
• Implemented Hyperion Operating interfaces to load budget and actuals data into PeopleSoft and Hyperion respectively.
• Customizations AP Recurring Voucher Process.
• Customized SQR 2051 report
• Developed a report for General Accounting to evaluate the re-class entries.
• Designed and Developed new combination rules to validate TBD locations and purposes for capital transactions only.
• Completed the code conversions for purchasing orders which are identified by General Accounting and Purchasing to minimize the re-classes.
• Assisted Purchasing to setup new tolerance limits on the Purchase orders to make sure vendors are paid within the tolerance limits.
• Development of PC Crystal reports requested by Project Costing Manager for Capital Programs.
• Assisted General Accounting to setup combo edits for Logan Locations and Purpose.

Confidential, IL

Senior PeopleSoft Technical Consultant

Responsibilities:

• Retrofitted many inbound and outbound interfaces in AP/AR/Billing/EX/Epro/GL/AM modules and in Various Crystal reports/SQR’s.
• Developed online objects using Application Designer as per the design requirements and extensively used PeopleCode (Record PeopleCode, Application Engine PeopleCode and CI PeopleCode) for the online validation and to implement the business rules
• Worked on the customization on Expenses approver reports/ Expense receipts attachments in Expenses module.
• Worked on the scripts for scheduling the jobs to inactive/active during TMTP/production cutover as per the functional user requirements.
• Worked on developing export/import batch scripts for loading data in 8.9/9.1 test environments and Performed AP match testing and auto match reports testing after loading the data.
• Involved in the configuration of the Integration Broker nodes/services/routing/operations on PeopleSoft Financials 9.1.
• Configured PeopleSoft security as required.
• Worked on file layouts for loading vouchers and loaded vouchers by customizing the express payments page in Accounts Payable as per the requirements.

Environment: PeopleSoft FSCM 8.9/9.1 PeopleTools 8.51 (App Designer, Application Engine, PS Query) People Code, nVision, Crystal Reports, Trees, SQL Server 2008

Confidential

Financial Analyst/Programmer

Responsibilities:

• Developed proprietary solutions to automate customer inquiries and event-driven activities.
• Worked on development of fixed income analytical tools to calculate spreads and proprietary algorithms to calculate duration and convexity for basis trading using .NET.
• Integrated various Confidential tools with CQG client using C#.Net technology and CQG proxy DLL
• Designed web-based ASP.NET internet applications linked to firm-wide SQL Server databases.
• Created database objects tables, views, stored procedures and functions to store and retrieve the data from database in SQL Server.
• Developed win forms using C# and implemented data access layer to access database using ADO.NET.
• Performed unit testing and verifying enhancements using business logic and user requirements.
• Integrating various financial tools which are useful in the fixed income analysis.
• Implementing Data access layer using ADO.NET to connect and retrieve and manipulate database information.
• Reviewing Business Requirement Specification (BRS), System Requirement Specification (SRS) and preparing High Level Design (HDD), Detail Design Document (DDD).
• Extensive experience of designing and developing software applications with the .NET Framework using C#, ASP.NET and VB.NET

Environment: .NET Framework C#, ASP.NET, ADO.NET, .NET Remoting, Visual Studio, WPF, WWF, SQL Server, XML, Windows, UNIX.