SUMMARY:

• Over 20 years of experience in PeopleSoft Fit - gap Analysis, Implementation, Configurations, Development, Major Upgrades, Security Design, Techno-Functional Analysis, Testing, Support, Data Conversions and Integrations in major industries of Public Sector, Mfg, Financial, Distribution, Hospitality, Insurance and Healthcare
• Six full implementation & supporting Software Development Life-Cycle (SDLC) of PeopleSoft applications in Finance/HRMS
• Experience in Project Costing configurations including Adding new Projects, Updating Trees, Allocations, Budgets, Integrations with General Ledger, Accounts Payable and Asset Management
• Experience in Commitment Control for defining the control budgets, setting up budget transactions review, budget load processes, trouble shoot and fix the issues in budget processes
• Techno-Functional experience in PSFT Application analysis in General Ledger, Accounts Payable, Asset Management, Purchasing, Project Costing, HRMS, Time and Labor, Payroll and Benefits
• Experience in People Tools - Application Designer, People Code, Application Packages, Trees, Maintain Security, Server Administration and reports repository setup, Process Scheduler, Utilities, Data Mover and Workflow Admin.
• Report Tools Experience in SQR, Crystal, App Engine, PS Queries, nVision Reports and BI/XML Publisher
• Experience in Integration Broker, Component Interface and Web services
• Expertise in Troubleshooting, Rel. Preparations and Batch Design of PSFT Apps
• Extensive experience in compare reports, code updates/retrofit and testing
• Experience in strategy making and implementation of PeopleSoft Maintenance Activities.
• Experience in Driving Architecture/Infrastructure ERP Applications and Hardware Upgrades and Disaster Recovery Activities
• Involved in applying PUM with Change Assistant - fixes, bundles and tax updates for Finance, HRMS and Payroll tax updates
• Experience in setting-up Manager self-services
• Extensively worked in Fluid User Interface setup/development/ Implementation
• Strong team player and very good in interacting with Business users, Functional and Technical team to meet the project deadline
• Personal- US Citizen. Lives in Dallas area, TX and interested to work in Local/ remote/Travel.

TECHNICAL SKILLS:

PeopleSoft Applications: General Ledger, Commitment Control, Accounts Payable, Purchasing, Asset Management, Project Costing, Accounts Receivable, Billing, CRM, HRMS, Time and Labor, Payroll and Benefits etc.

People Tools: App Designer, People Code, Application Engine, Integration Broker, PS Security, XML Publisher, Component Interface, Tree Manager, App Messaging, AWE, Utilities, Reports Mgr and PS Query

RDMS: Oracle 11g, MSSQL Server 2005/08/12/14 and DB2

Operating Systems: Unix, Linux, Win NT/Win Ser 2008/2012 and DB2

Prog. Languages: C++, SQR, SQL, COBOL, HTML, XML and Java

Other: ORCL Web Logic/ Tuxedo - 8.1/9.1/10.3/11.1, Autosys, Quest STAT, Agile, SSRS and OATS Etc.

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Techno-Functional Analysis in FSCM ver. 9.2- Project Costing/Accounts Payable/ Asset Management/Purchasing/General Ledger
• Upgrade People Tools from Ver. 8.51 to 8.55/Application Ver. from 9.0 to 9.2
• Understand various software solutions and ways that they can be leveraged and configured in PeopleSoft Applications
• Improve the flow and quality of information by analyzing the business processes for inefficiencies- Interfaces, between the modules and within the module
• Create, Validations and troubleshoot with SQL/ PS queries
• Configurations in Project Costing per business Requirements/Validations
• Analysis of Customizations/Modifications in People Code, App Engine and SQRs
• Analysis/Review of data conversions from ver. 9.0 to ver. 9.2
• Setup/Configuration of Fluid User Interface/Work Centers
• Develop the Test scripts/UAT/coordinate the system testing
• Updates/Participates as a team Lead in all Scrum/Agile events

Environment: PTools 8.55, PeopleSoft Apps Ver. 9.2 FSCM-Project Costing/Accounts Payable/ Purchasing/ Asset management/General Ledger/ Agile Methodology SDLC

Confidential, Dallas, TX

PeopleSoft Apps. Lead Developer/Senior Analyst

Responsibilities:

• Techno-Functional Support for General Ledger, Payables, Project Mgmt., HRMS, Time and Labor, Payroll and Benefits
• Develop Customizations/Modifications in People Code, App Engine and SQRs
• Troubleshoot and Develop the SQL scripts to fix the data
• Maintain/Revisit the security profiles and update per job roles
• Upgrade People Tools Ver. from 8.49 to 8.55
• Upgrade Financial and HRMS Applications Ver. from 9.0 to 9.2
• Compare reports Analysis and Retrofit all of the necessary customizations
• Configuration/setup/ fit and gap analysis in HCM 9.2/Payroll 9.2/TL 9.2/FSCM 9.2
• People Update Manager (PUM) - apply change packages as necessary
• Setup Oracle Secure Enterprise Search (SES) with PeopleSoft applications
• Setup/development of Fluid User Interface pages
• Setup Manager/employee self service

Environment: PTools 8.55, PeopleSoft Apps Ver 9.2 FSCM/HCM /Benefits/Payroll /Time and Labor

Confidential, New York, NY

PeopleSoft Apps. Lead Senior Analyst

Responsibilities:

• Analysis of the customizations in People Tools - App Engine, People Code and SQR
• Gather Business Users requirements, Create the Techno/Functional Specs for Custom Process in accounts payable check printing process
• Key role in Institutional mergers with financial systems, Financial Analysis and Chart of Accounts redesign including Project Costing Design, Configurations, Projects Data conversion, Project Resource Validations/Analysis, Integrations with General Ledger and Accounts Payable
• Fit/Gap Analysis in Project Costing processes including admin/Payroll charges back projects and 3rd party charges
• In-depth Knowledge in Grants Management, Commitment Control, budget checking process and Financials systems processes
• Key role in setting up Chart fields design, Combo Rules, Trees Structure and Allocations
• Review/Update of multi-currency payment process to automate the exchange rate updates.
• Production Support for purchasing, Accounts Payable, Project Costing Expenses, Treasury and General Ledger
• Integration Broker asynchronous and synchronous messages- OFAC validations with 3rd party, Chart fields sync and Voucher Load etc.
• Setup/Configuration of AWE(Approval Workflow Engine)
• Compare Reports Review/Retrofits of requires customizations
• Develop/modification of Reports in Queries, BI/XML publisher

Environment: People Tools 8.53, PeopleSoft Apps FSCM 9.0/9.1

Confidential, New York, NY

PeopleSoft Technical Consultant

• Gather requirements for upgrade people Tools Ver. from 8.49 to 8.52 and CRM Applications Ver. from 9.0 to 9.1
• Install Tuxedo Ver. 10.3, Web logic Ver. 10.3, People Tools Ver. 8.52, CRM Demo application Ver. 9.1x and Change Assistant
• Configure and setup for Application Server, Web logic server and Client
• Review the fit-gap analysis, compare reports and Customizations
• Running Initial Upgrade process including database setup, modify and running the scripts. Prepare the scripts for User Acceptance Test and fix the upgrade issues.
• Modify customizations - SQRs, People Code, App Engine and other People Tools
• CRM enhancements, maintenance patches and production support.
• Involved in integrations between CRM and other financial custom products using Integration Broker and TIBCO
• Setup/Configuration of AWE(Approval Workflow Engine)
• Application Support for PeopleSoft integrations in General Ledger, Accounts Payables, Accounts Receivable, Billing, Expenses and Purchasing

Environment: People Tools 8.49x/8.52, PeopleSoft Apps FSCM/CRM 9.0/9.1

Confidential, New York, NY

Lead/Senior Applications Developer

Responsibilities:

• Application support in Financials (General Ledger, Budgets, Accounts Payable, Purchasing and Inventory) and HRMS (Human Resources, Payroll and Benefits)
• Add new and modify app Designer definitions - records, views, pages, Components, Panels, Menus and People Code according to the requirements
• Adding and modifying People Tools- Trees, Application Engine, Process Scheduler, Translate values, Security and Utilities
• Develop the custom reports as per requirements in SQR, PS queries, crystal reports, nVision Reports, and App Engine etc.
• COBOL Compilation with Micro Focus Ver 4.x
• Monitor and maintain the Integrations PeopleSoft and Non-PeopleSoft applications
• Implementation of Application and People Tools Patches/ bundles, Maintenance Packs
• Change Management for migrating the PeopleSoft projects between the databases
• Setting up off site Disaster Recovery for all of the PeopleSoft regular functionality
• Various PeopleSoft Configurations - Report Manager, IB and process Scheduler
• Lead role in Upgrades/Architect in Server admin/ Key configurations

Environment: People Tools 8.49, PeopleSoft Apps FIN 8.8/9.0, HCM 8.8/9.0

Special/Major Projects:

Setup and Configure the Integrations:

Upgrade PeopleSoft Tools Ver 8.49x and Applications - Fin/HRMS Ver 9.0

Development and Setup of Commitment Control Accounting

Upgrade People Tools Ver 8.2x and Applications - Finance and HRMS Ver 8.8

Upgrade People Tools Ver 7.6x and Applications - Finance and HRMS Ver 7.5

Confidential, Stamford, CT

PeopleSoft Technical/Functional Consultant

• Analysis and modification of various SQR reports and interfaces for PeopleSoft
• Key role in upgrade from 6.0 to 7.5 in all phases including functional analysis, Testing and comparison analysis etc.
• Run and Review the compare reports, retrofitting Customizations, testing of the various People tools and People code
• Involved in applying fixes, bundles needed for PeopleSoft Finance/HRMS and North American Payroll
• Setting up SetIDs, Ledgers, Trees, Business Units, Chart of Accounts, Journal Generator, Multi Currency, Consolidations and Allocations.
• Prepare EDI purchase orders through EDI manager
• Add the trading partners, defining the Inbound and Outbound Mapping,
• Define the conversion data profiles and Unit testing the both inbound and outbound files processing.
• Trouble shooting of OMEC (Order Management Electronic Commerce) process Validate the Sales Order created by OMEC process
• Prepare the Advanced Shipping Notice (ASN) through EDI outbound process. Then Populate the Billing and generate the Invoices. Adding/Editing People Code according to the end user requirements

Environment: People Tools 7.5x, PeopleSoft Apps FIN 7.5x

Confidential, Princeton, NJ

PeopleSoft Technical/Functional Consultant

• Analysis of Report requirements and classified into different reports
• Prepare the design specifications for SQR and nVision reports in financial and management reporting.
• Code the complex reports in SQR using trees and different tables,
• Prepare the detailed documentation for SQR code and Technical specs
• Create/Develop Reports in SQRs/Crystal/Nvision
• People Tools - Application designer, People Code, Security, trees, tables, report books, PeopleSoft query and process scheduler.
• Develop the nVision reports - layout, report request and scope in financial and cost reporting with Summary ledgers and detailed ledgers, trees, query and drilldowns.
• Migrate the reports into a DB2 mainframe environment and schedule jobs in JCL for SQR reports,
• Test the programs in JCL and prepare the Unit testing documentation.
• Prepare unit testing, change management both configuration and program errors to move the programs into the production.
• Prepare current business process, defining business rules, Table Set Ids, Table set Sharing, General Options and Chart fields, Combo edit rules, journal approval process rules

Environment: People Tools 6.x/7.5x, PeopleSoft Apps FIN 6,x/7.5x- GL/AP/AR/AM

Confidential, Glendale, CA

Sr. Accountant

• Financial Reporting including General Ledger, month end closing work, year-end adjustments, financial statements, management reports
• Coordinated Audits, Work Papers for Auditors, Variance and Performance Analysis
• Activity-Based Costing System, annual operating budget and financial planning
• Special projects including operating efficiencies and cost cutting.
• Supervised the accounting staff and reviewed other functions.
• Analyze and prepare accounts payable, accounts receivable, payroll, fixed assets schedules and bank reconciliation for every month.
• Implemented computerized accounting systems, internal control procedures, and involved in management information systems group for software and hardware needs.

Environment: Health Info Sytems Ver 5.x, DOS, Windows NT

Confidential, Pomona, CA

Accountant

• Prepare/review vouchers, accounts payable, accounts receivable, month end closing, bank reconciliation, journal entries and fixed assets schedules
• Prepare General ledger, inter company accounts transactions, consolidated financial statements, and consolidated balance sheet accounts.
• Regulatory financials statements for banks and other financial institutions, Prepare Ratio analysis, cash management and corporate tax returns.
• Coordinated external audit include preparing audit work papers, audit schedules, accounts receivable and other balance sheet accounts analysis.

Environment: AccPAC Ver 6.x, Medical Info Systems, DOS etc