SUMMARY:

• 12+ years of experience in Oracle - PeopleSoft Finance applications
• Techno-Functional consultant with experience in Design, Development and testing of applications in PeopleSoft Financials suite
• Very strong implementation background in PeopleSoft modules including Billing, Contracts and Accounts Receivables, General Ledger, Accounts Payable, Project costing, Asset Management, Cash Management and HR benefits
• Sound knowledge of PeopleSoft Security administration, PeopleSoft Test Framework and UPK development.
• Development and debugging skills in PeopleTools like Application Designer, Application Engine, PeopleCode, File Layout, Component Interface, Application Packages, Excel to CI and Integration Broker.
• Expertise in reporting tools like SQR, PS Query, BI Publisher and nVision and database like IBM DB2, Oracle 10g and MS SQL server 2008
• Sound knowledge of ERP implementation methodology and relevant associated quality processes.
• Ability to take independent responsibilities as well as to contribute as a team member.

TECHNICAL SKILLS:

ERP PeopleSoft Functional: PeopleSoft Financials 8.4,8.8,8.9,9.0,9.1,9.2 (Billing, Account Receivables, Contracts, General Ledger, Project Costing, Asset Management, Accounts Payables)

ERP Tools: People Tools 8.46, 8.48, 8,49,8.53 Application Designer, Application Engine, Component Interface, File layouts, People Code, Application Package, Integration Broker, Excel To CI

Languages: SQL, PeopleCode

Database: DB2 UDB 8.2, Oracle 10g,11g, MS SQL Server 2005

Reporting Tools: SQRs, PS Query, BI Publisher, nVision

Testing Tools: HP Quality Center, PeopleSoft Test Framework

EMPLOYMENT HISTORY:

Confidential, San Francisco

Tools: PeopleSoft Financials 9.2, People Tools 8.53, PS Query, HP Quality Center

Onsite PeopleSoft lead

Responsibilities:

• Leading PeopleSoft and other Oracle testing projects from Onsite, attending meetings with Client Project Managers, Business Users, SME's and development teams,.
• Providing PMs the status of all SIT phases.
• Attending client meetings for understanding testings requirements
• Providing testing estimates and developing test plans and strategies.
• Driving defect triage calls and assigning defects to team members
• Sending out TEM reports to client PMOs
• Assigning work to offshore functional testers and managing their activities in test design, development and execution phases

Confidential, Pasadena

Tools: PeopleSoft Financials 9.2, People Tools 8.53, Application Designer, PeopleCode, Application Engine, SQR, File Layout, Application Packages

Sr. Developer

Responsibilities:

• Developed all HR Benefits interfaces (open enrollment and on-going) to different benefits vendor system from OWB PeopleSoft HR system such as Confidential Legal interface, BCBS FSA interface, Prudential Interface, Confidential Eligibility Interface, Matrix interface, CVS interface, Fidelity 401K interface and ADP Flexdirect interface for Confidential integration project.
• Supported UAT phase and post go-live phase for all above interfaces and resolved vendor queries/issues on time. Also worked with different teams to automate all the benefit interfaces in production.
• A new bank code #447 was created in IBS for the Confidential Bank online portfolio of accounts. So worked in enhancements of Confidential interfaces to GL, Deposit posting reconciliation interface, Confidential monarch reporting interfaces for regular, forex and cheque activities for integrating the online banking.
• Worked on customizing import bank statement process for wires coming from GFX. Also developed Malicious wire hold process for wires coming from High risk country.
• Developed internal watchlist process to monitor the wires coming to certain bank accounts. These processes were converted from legacy application processes.
• Developed FIRD GL interface for transactions coming from federal reserve system.
• Developed row level security and query security for Confidential east PS application
• Developed Invoice attachment to voucher pages and Copying PO information in Voucher entry page
• Prepared Unit testing and System Integration testing strategy and test scripts
• Handled lead tester role in Unit testing and SIT testing phase and also supportd UAT phase in Confidential data center migration from west to east location
• Co-ordinated with different internal teams and vendors for Integration testing of the other application
• Prepared cut-over plan and release plan for the go live of the project
• Developed query security and row level security on set up and transaction tables of AP, GL and AM modules in mass to restrict data accessed by users through PS queries.
• Developed quick invoice customizations in AP to copy invoice lines from PO.
• Developed compex PO remaining balance sqr report.
• Done analysis,retrofitting and testing of the customized objects affected by PUM and Peopletools upgrade.

Confidential, Dublin

Tools: PeopleSoft Financials 9.2, People Tools 8.53, Application Designer, PeopleCode, BI Publisher, Application Engine, Integration Broker, File Layout, Application Packages

Sr. Developer

Responsibilities:

• Developed subproject synchronization application engine program and its related fixes which included app package Peoplecode, pages and components, SQL views and testing of delivered Project costing and General Ledger processes to check the impact.
• Supported Cashflow reporting process in UAT phase.
• Customized Asset management lease payment interface process to include custom sales tax and service/disposal fees. Developed BI publisher report for payment status report.
• Unit tested and supported above projects in QA and UAT phases.
• Done required modifications post go-live.
• Done analysis and retrofitting under PUM12 upgrade in Billing, AR and AM module.

Confidential, Los Angeles

Tools: PeopleSoft Financials 9.2, People Tools 8.53, Application Designer, PeopleCode, SQR, Application Engine, PS Query, File Layout, BI Publisher, nVision, Component Interfaces, Excel To CI

Techno-Functional developer

Responsibilities:

• Gathering the business requirements from Confidential Business Team in Reports and Enhancement tracks.
• Preparing technical design documents.
• Developing reports in GL and AM Modules using SQR, PS query, nVision, BI Publisher and testing the same.
• Keeping the track of the project activities and reporting the same to Cognizant and Client Manager.
• Supporting the System testing phase and resolving the defects if any on timely basis.
• Developed HQA Interface using App engine and File layout to import the Journals from Legacy system to Peoplesoft GL.
• Developed the App engine processes and Excel to CI utilities to load data into COA custom components (Accounts and products) using csv files and component interfaces
• Providing status of the tasks to Client on development and Unit testing.
• Supporting System testing and UAT phase of the above projects and managing changes in requirements
• Participating in Go-Live activities in tasks such as Migration, Loading data into system for DMS scripts
• Performing sanity checks after migration.
• Executed monthly maintenance activities which include Account, Department updates, mass addition/closures, CF Attribute changes, Tree changes, Custom UB set ups etc.
• Implemented PeopleSoft security for AP, GL and Configuration functional team.
• Developed content in UPK (User productivity Kit) for Chart of accounts Enhancement project.

Confidential

Tools: PeopleSoft Financials 9.1, People Tools 8.51, Application Designer, PeopleCode, SQR, Application Engine, Integration Broker, File Layout.

Techno-Functional developer

Responsibilities:

• Worked on small demand work requests such as addition of Voucher Origin in Confidential ’s custom reports and voucher upload spreadsheet.
• Worked on Major enhancement of virtual Gift card project as Billing functional consultant and helped client in finalizing the functional design.
• Developed app engine process to generate Virtual gift file with decrypted gift card PINs and modified Invoice printing SQRs.
• Modified online people code on Order Entry and Order Fulfillment component.
• Created technical design documentation and Unit testing logs
• Worked on performance improvement of AM processes.
• Created app engine process for bulk upload of project-department mapping data.

Confidential, La Crosse, Wisconsin

Tools: PeopleSoft Financials 8.8, People Tools 8.49, Application Designer, People Code, SQR, Application Engine, PS Query, PS Security

Onsite Coordinator

Responsibilities:

• To resolve any failures in batch processes if any on daily basis. This used to be very critical activity on Month-End. This also included data change requests and data fixes. GL and AR module used to be very critical in batch process failures and needed immediate fix.
• To resolve any queries raised by Business users related to processes and business transactions.
• To arrange meetings with clients to understand their problems and provide proper guidelines.
• To take the business requirements from Client Managers and Contract Business Users and convert them into technical specifications for offshore team.
• To do the Contract Customization code review delivered by offshore team and test it before handing over to UAT.
• To do minor change request in AR module (Mainly used to be in SQR or Online Peoplecode)
• Assigning Bug fixes and Data fixes to offshore team and verifying them.
• To change the existing programs (SQR, Peoplecode, Application Engine) across all the custom and customized modules to support 4 digit product code replacing existing 6 digit product code
• To work with Client Manager for Internal and External PWC Audit of PeopleSoft Applications which mainly included tasks as taking evidences and sample collection for the Items asked by internal and external Auditors. This audit mainly included Application maintenance, Job scheduling, Application security and Database audit.

Confidential

Tools: PeopleSoft Financials 9.0, People Tools 8.48, SQR, Application designer, PeopleCode, PS query, Application engine

Techno-functional Consultant

Responsibilities:

• Worked on Bolt on and Enhancements in Contract Module.
• Invoice printing SQR enhancements for new Invoice formats in Agency division.
• Resolved performance related issues and Bug fixes in Invoice Printing.
• Team leader of 12 developers’ team from requirement analysis to QA phase.
• Understanding the business requirements and working with onsite team for radio requirement analysis, estimations, design and coding.
• Rectifying the understanding issues of the offshore team in Radio design and coding phase. Also I have been primary offshore POC for the technical deliverables.
• Project Maintenance through tools like VSS, C2, DPP and documentation standards.
• Prepared all the Technical Design Documents with respect to Function Design Document.
• Guided team members in the development of Radio Invoice format and consolidated invoice report.
• Developed Contract renewal calculation logic for Radio Division Rollout.
• Developed online pages for Radio, Cluster set up and done enhancements in Customer set up and Contracts components.
• Looked after Tax calculation issues in Invoice printing in Billing module.
• Done enhancements like Random contracts and some minor enhancements after Radio go live and also handled post go live production issues handed over to offshore
• Enhancements in Cluster Maintenance and Discount Maintenance utility pages and Contract header pages.
• Developed major Application engine for Mass market changes utility to change/add/remove market information in bulk in. This was bolt on utility in Contracts Module.
• PS queries for Confidential holds and warnings letters in AR module.
• Worked alongside with the senior teammates in estimating the efforts for anticipated upgrade project by using Cognizant Proprietary Tools and Production-To-Demo Database compare repots
• Handled production issues related to Contracts, Market and Releases, AR, Billing, ABS/PS - OLA interface and GL in timely manner and provided precise solution to the production users and FPM users.
• Worked on Custom Radio reports (Summarization of Contract Details) to handle contract credit hold status and modified TM1 views to include Cluster Information.
• Done the Functional testing of production enhancement releases.
• Guided Client business team from time to time for their queries on functional area of Contracts, Billing and AR.
• Worked as a Security Administrator from client location and handled security issues independently.
• Worked on Radio enhancement go-live cutover activities for UAT and production migration.
• Prepared complex PS queries as and when requested by Clients' FPM team in very less time span.
• Provided emergency bug fixes in case of production issues and handled Oracle support calls for delivered issues of PeopleSoft.

Confidential

Tools: PeopleSoft Financials 8.8, People Tools 8.48, Application Designer, People Code, SQR

Techno-Functional Consultant

Responsibilities:

• Fix Defects for AR, Billing and GL modules enhancements.
• Complete Development for enhancements and Unit testing of the same.
• Preparation of test cases and test logs.
• Provide Support to the Functional Team during testing of fixes
• Preparation of Technical design document