SUMMARY:

• Dynamic innovative professional, with proven track record with designing, developing and delivering successful cost - effective, high-performance ERP technology and information technology solutions; analytical problem-solver with extensive experience in identifying opportunities and developing new business strategies and implementation framework to meet challenging multinational business demands. years of experience in the Information Technology Industry that includes Years of PeopleSoft Financials and HRMS experience implementing following PeopleSoft modules: General Ledger, Asset management, Accounts Payable, Accounts Receivable, Purchasing, Billing, Projects, PS nVision HRMS, Benefits and Admin, PeopleTools and upgrades

TECHNICAL SKILLS:

O/S: Sun Solaris Ver 10, Sun Sparc, HP-Unix Windows NT 4.0, XP, 2000, Vista. IBM Compatibles, Sun Classic, Citrix RAS, Sun Ultra.

PeopleSoft Financials: SCM - Ver 6.X to 9.2 - GL/AP/AR/PO/INV/EX/BI

PeopleSoft HRMS: HCM - Ver 8.x to 9.1 - Benefits and Payroll

Tools: and Technology: PeopleCode, PS Query, Application Engine, SQR, HTML, Unix Shell Scripting, COBOL, Designer/2000, Visual Basic, PowerBuilder, Oracle 11g, Autosys, Control M.

PROFESSIONAL EXPERIENCE:

Project Lead/Sr. Systems Analyst/Technical Lead

Confidential

Responsibilities:

• Involved in full life cycle of PeopleSoft Finance application upgrade from 9.1 to 9.2 during
• Retrofitted the customizations as per keep/drop analysis
• Created unit test cases, integration test cases and extensively involved in testing the 9.2 application
• Worked along with the onsite vendor (CTS) in all phases of application upgrade
• Created a custom interface to send customer and invoices data to the third party collections (GetPaid) system
• Involved in implementing the QTC (Quote to Cash) project
• Extensively worked in PeopleSoft enhancements after 9.2 upgrade following SDLC
• Worked closely with functional lead in analysis, system testing and UAT
• Delivered the assigned tasks/projects/tickets in timely manner and in high quality of work.
• Extensively coordinated with OMCS in scheduling the RFCs and getting the projects migrate to all environments and getting fixes migrate in timely manner
• Extensively used the OMCS PCM tool in project migrations and provided valid inputs to further develop the PCM tool as per requirements for Covanta
• Worked closely with business users in understanding the issue/requirements
• Followed the change management process and at same time delivered the projects on time
• Delivered the vendor migration requests along with the production support/projects.
• Developed web service to load the currency data load.
• Created an App package to load the CRM customer data into PeopleSoft.
• Loaded the customer DUNS numbers using ExceltoCI
• Created a custom app Engine to load the currency rates invoking web services and CI.

Project Lead / Sr. Systems Analyst

Confidential

Responsibilities:

• Upgraded PeopleTools from for HCM application
• Finance application upgrade from 8.19 to 9.0 and PeopleTools to 8.49,
• HCM application upgrade from 8.8 to 9.1 and PeopleTools to 8.50,
• Implementing ePerformance 9.1
• Upgraded PeopleTools version
• Currently upgrading PeopleSoft Finance from 9.0 to 9.2

Tech Team Lead - PeopleSoft Technical / Functional Consultant

Confidential, New York City, New York

Responsibilities:

• Provided day-to-day leadership and direction in all aspects of PeopleSoft Financials for USA Region.
• Project management and Production support, development and customization for General Ledger / Accounts Payable/ Asset Management/ eProcurement / Source-to-Pay modules and Workflow process.
• Leading a Team of Developers for doing implementation, development and support for the GL/AP/AM/PO modules in the Global Environment. Organize meetings with business users for optimizing the processes in Financials environment as it is regarded as mostly used module for extracting the data from Ledger and Journals. Designed and developed a Generic Application Engine and different SQRs to load the Feed from Different feeder systems into the GL systems.
• Resolving daily production issue, which was the result of Implementation Set Up issues, Functionality issues and Training issues. Worked closely with the clients to speed up the data entry and designed documentation for the training purposes for example while doing the Receiving of the Assets in the Receiving department.
• Designed Flattened Tree Tables that gets refreshed every night during the Batch Initiation process that increases the performance of Combination Editing during the Jgen processes for different feed loads
• Defined and maintained Combination Edit Rules using the Account, Department and Product Tree Structure, and attached the Combo Rules to the Proper Ledger of the Business Unit.
• Combination ChartField templates are created and linked to proper ledger templates and Identified/created combination edit rules and edits groups. Tree structures and hierarchies are created for query security and rollup groups.
• Identified and created business units, tablesets, and SetIDs and defined installation options and specified journal error processing options and approval options.
• Defined New Journal Sources and Journal Templates for New Feeds for GL module from different feeder systems.
• Defined ledgers, ledger templates and linked to ledger group and business unit. Journal sources, speed types and recurring journals are defined online.
• Designed Ledger Vs Journal Integrity SQR report which checks for all the Journals posted and unposted to Ledger and to check which Business Units are out of sync between Ledger and Journals before the main close period each month. Ran Mass change process to close the Period for all PeopleSoft Financials modules every month.
• Created PS/n Vision reports to create consolidate by BU reports, Month End Balance Sheets and customized the Income statement reports. Involved in meeting with Functional Users to understand the Business requirements. Involved in Fit & Gap analysis and was responsible for finding the gaps between the OnBase system and PeopleSoft Financials. Create and maintained Accounts, Security Access, Operator Classes.
• Applied SOX Controls for all the development work across globe.
• Using SDLC methodologies from Development to Migration into Production environment. Maintaining Business requirement documents into SDLC for future audit purposes.

Tech Team Lead - PeopleSoft Technical / Functional Consultant

Confidential, New York

Responsibilities:

• Led programmer, systems analysts, and systems administrator.
• Recruited to turn around high priority areas/modules.
• Designed, development, implementation and customization for General Ledger/Accounts Payable/ Asset Management/Purchase Order/ eProcurement modules and Workflow.
• Converted Ledger Balance, Journal Entry transaction, Assets, Vendors from Vytra Health Plans Company that got acquired by HIP. Defined System eligibility rules, Event rule in Benefits. Resolving daily tickets and doing production support.
• Maintained a team of 3 people for the ongoing development, production and customization of the Financials Modules.
• Customized the modules as per Business Partners Requirements.
• Applied all SDLC and PLC procedures while doing any projects or customization.
• Documented Project note book for each project and presented to Internal Audit and Sarbanes Oxley audits. Provided brown bag sessions & Trained colleagues in PeopleSoft Application development such as PeopleTools I & II, SQR, SQL, Crystals etc. Customizations / Development / Modifications of delivered Pages, Application Engines, Tables, SQRs, SQCs, Crystal reports. Upgrading from 8.0 to 8.8. Running DMS scripts to transfer the User Profiles from 8.0 to 8.8. Creating New Roles and Permission lists as per the new pages added to the 8.8 Version.
• Customized existing Views to improve efficiency of PeopleSoft modules. Work allotment to the team members as per the priorities set by the Accounting and Purchasing departments. Gave project timeline of the team members to the Assistant Directors and Directors.
• Developed & Customized Application Engine process to update the Open periods automatically for GL and AP modules. Customized Application Engine for bringing the PO Reference fields while doing automated requisition sourcing to PO.
• Modified the existing Mass change Template/Definition that can retire high volume of Assets and also do high volume of Asset Re-Categorizations. Designed & Developed Customized module called Contract Management Initiative for Purchasing Department to do a On-line Data Entry of the New Contracts and Supplier Contracts and also to do Query for the Q/Care Load.
• Designed a customized SQR program to upload Q/Care Data from Mainframe to PeopleSoft. This module will give you a List of Contracts & Supplier Contracts which is used to show the Federal Government for going Public.
• Customized the delivered SQR program to create Active Journal Entry transactions from the acquired Vytra Health plans company. Designed new SQR program to convert all the history ledger transactions into the ledger table.
• Modified the Journal Entry templates which uses only the specified ChartFields and amount fields required by the company.
• Tracked user Sign in and Sing out activity by running the system defined Audit table.
• Helped Business Partners in Defining New General Ledger Business Units and corresponding financials modules Business Units for newly acquired company and tested out the transaction flow from AP module to GL module and PO Module to AP module. Doing Production support and resolving business issues by customizing the PeopleCode, or doing Data manipulation using Oracle SQL plus as per the business requirements and approvals.

Tech Team Lead - PeopleSoft Technical / Functional Consultant

Confidential

Responsibilities:

• Development, Conversion and Production support for AR/BI/GL/AP/AM/INV/PO and PC for five months. 24X7 on-call production support.
• Resolved daily tickets. Applyied recent Bundles and Patches to improve the efficiency of PeopleSoft modules. Handling Converted and Interfaced from Third party software (Nucleus, Right Angle) system to PeopleSoft for all the Billing Invoices and Open pending Items. Customizations/Development of pages and application engines.
• Added PeopleCode to created default values for ActivityID, Resource Type, Resource Category, Resource Sub Category and Analysis type based on the PC Business Unit and ProjectID in the Journal Lines pages.
• Developed the data mapping, specifications for the conversion and interfaces.
• Developed data mapping of Vendors, Vouchers, Journals, and Bank Reconciliation for the conversion and interfaces. Programmed conversion, interfaces and reports programs using SQR, Application Engine. Worked on customization of PeopleSoft process using PeopleCode and Application Engine.
• Designed, Developed several SQR reports and interface programs for end-users to meet Business requirements. Applied Bundles and Patches for AR modules. Applying Patches for AR UPDATE Application Engine program to remove the unique constraint errors in PS PENDING ITEM and modified the AR UPDATE program. Involved in on-line changes & PeopleCode changes. Scheduled processes to run at a specific time and/or run recursively at a specific interval using Process Scheduler.
• Coding included SQRs, PL/SQL, Message Agents and Custom developed PeopleSoft pages. System administration managing upgrades, applying PeopleSoft patches, Installs, User security, Database Design & Tuning. Maintaining the NetOut Process and helped the users to do the NetOut process between Vendors in AP and Customers in AR and provided documentation to Users as to how to maintain Customer and Vendor relationships and to maintain Parent/Child relationships for more than one customer or vendors to be able to do Netouts. Running the Billing, Receivable and General Ledger interface to load all the Invoices from a third party system Right Angle into the PeopleSoft BI module then running AR Interface to load all the Pending Items in AR module, and then run the Journal Generator to load all the Accounting Entries into the GL module.
• Created a Customized SQR process to load all the AR Pending Items from third party system Nucleus into PeopleSoft.
• This SQR creates Accounting Entry lines rather than depending upon the AR UPDATE Application Engine process to create for it.
• Created and deleted Temp Tables during the conversion process dynamically to avoid any increase in the table space of the database.
• Automated the process of running LockBox process to apply payments of Customers and then to run AR PREDICT app engine to apply the payments as per the payment predictor.

Tech Team Lead - PeopleSoft Technical / Functional Consultant

Confidential

Responsibilities:

• Upgrade team member, Development and Production support member for PeopleSoft Financials 8.0/PeopleTools 8.17. Involved in Data Conversion for converting GL/AP/AR/AM/PC/INV/PO/BI from PeopleSoft 5.0 to PeopleSoft 7.59/ PeopleSoft 8.0 and PeopleSoft 7.59 to PeopleSoft 8.0. Supporting the team with Upgrades, SQR Customization, PeopleTools development, Customizations and PeopleCode Debugging using PeopleCode Debugger.
• Designed the UAT documents and submitted to all the Super Users. Helped the users in the on-going UAT testing for all the modules. Played as a Production support team member to support the users online in the Modules of Projects, Purchase Order, Accounts Receivable, General Ledger, Asset Management and Budgets.
• Upgraded PeopleSoft 7.5 Financials to PeopleSoft 8.17 using Upgrade Assistant, Data Mover. Ran numerous *.dms scripts, *.sqr scripts using Data Mover and also created a Flow Chart for the Client to let them know the flow of data from PeopleSoft 7.5 to PeopleSoft 8.17 using the new Upgrade Assistant Tool and Data Mover Tool. Defined the Upgrade Jobs and assigned to the Step process and then assigned to the Task in the Upgrade Assistant.
• Defined relationships between Multiple AR Business Units using Tree Manager, created Rollup Tree Nodes for Multiple AR Business Units. Defined Receivable processing for AR Business. Enabling GL distribution, Auto numbering and VAT.
• Converted all the System setup tables from database for testing of all the 8.0 modules and report to the development team and as well to PeopleSoft Customer Connection site for any updates on those typical problem which has any fixes. Data Conversion of Assets and Proj Resource data of PeopleSoft 5.0 to 7.59/8.0. This PeopleSoft Financials 5.0 is from the previously acquired company.
• Established Asset Processes by Defining the Accounting Entry Template, Defining Asset Books and setup of Asset Classes. Defined CAP types. Modified the SQRs of "Accounting Entry Detail Depreciation and Net Book Values". Customized the SQR program, which Loads Transactions into base Asset Management tables from the Financial and Lease Interface tables.
• Customized Application Engine programs for Asset Management, Project Costings and General Ledger modules also created customized Application Engine Program from AM -to -PC Interface. Customized the pages for Journal Entry, Purchase Order entry to remove (INVALID VALUES) Error, which has been reported as the common problem with PeopleSoft in most of the Translate or Prompt tables. Designed the SQR program so as to give exception reports, which gives the result of converted rows, not converted rows etc. Created Temp tables for the Conversion purpose dynamically and deleting the tables after conversion is completed.
• Defined new Process Definitions and appended new flags to get a good log file for any SQR Process ran for error. Upgraded SQRs from PeopleSoft 7.59 to 8.0. Upgraded these SQRs for their new tables of PeopleSoft 8.0 and new system variables for five months

Consultant PeopleSoft

Confidential

Responsibilities:

• As a team member performing Upgrade and Phase 2 Implementation. Involved solely with the Data Conversion of Project Costing module and General Ledger module from Legacy Dexter and PeopleSoft 7.5 system into PeopleSoft 8.13 through Application Designer, PeopleCode, SQR and Import Manager.
• Played as a Production support team member to support the users online in the Modules of Projects, Purchase Order, General Ledger, Asset Management and Budgets. Upgraded PeopleSoft 7.5 Financials to PeopleSoft 8.13 using Upgrade Assistant, Data Mover. Defined the Upgrade Jobs and assigned to the Step process and then assigned to the Task in the Upgrade Assistant.
• Flowchart and Documentation for the Conversion Process is being presented and explained to the client before any conversion process is run in the “Test” or in “Production” environment. Assigned Budget Users from the Tree Manager tool for their respective departments. Imported the Budget Cube data back into the Ledger by running the Import Cube process through the Import Cube pages. Imported only the Initial phase of the Budgets.
• Converted Lease Information into Asset Management Modules and also customized the AM001TAX.SQR program to calculate the correct flat rate tax. Created New Project IDs if not existing in the 2000 projects for 2001 Projects, these were also done dynamically to check if the 2000 Projects are present or not.
• Converted new Activity Ids, Categories and Subcategories. Converted all the detail budgets for the Projects, Activities, Category and SubCategories from a flat file to PeopleSoft tables using SQR. Created and modified the existing Excel macros, which give the Output files from the Input, excel files (Excel files of Dexter system) with all the Projects, Activities, Category and SubCategory and Budgets cost in a line. Built online queries using Query tools and gave to Users to run those queries and the users either used to update the data and send the file across to me, then I used to Upload them using SQR.
• Helped the Users on-line in running their SQR reports to setup defaults for Individual users in the Operator preference panels. New panels were designed and new process definitions are being added to run the customized SQR and Crystal from PeopleSoft panels. Mock runs of “Actual Data” converted in “Test” environment of PeopleSoft, then User Acceptance Testing was done. Sign-off being procured from users based on UAT on “Test” environment.
• Converted all the Chart Of Accounts like GL Accounts, Departments, and Products etc from Legacy Dexter system to PeopleSoft 8.13 online while converting the data into the system. Crosswalk and Mapping table are also created online using Application Engine and the PeopleCode 8.13. Using PeopleCode 8.13. And File Object types, Flat files are being open and close during the Conversion process.
• Involved on this project foe fourteen months