HIGHLIGHTS OF EXPERIENCE

• Experienced PeopleSoft Architect with strong technical and project management skills, ability to work and manage projects independently with a proven ability to meet and exceed set goals and deadlines.
• Instrumental in PeopleSoft functional and technical solution, scope, fit gap analysis, requirements gathering, quality management, performance improvement, process reengineering, change management, global implementations, and production support.
• Five successful PeopleSoft implementations from selection through roll-out including development, major customization, testing, user and developer training, and technical team management.
• Four successful PeopleSoft Upgrades in PeopleSoft Financials and PeopleSoft HRMS.
• Extremely proficient in the use of PeopleSoft online development tools, Crystal, nVision, Security Administration, PeopleCode, Application Engine, Integration Broker, and SQL/SQR languages.
• Driven to provide excellent customer care and innovative user experience. Seasoned researcher and writer with excellent communication skills.
• Excels at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
• Worked with many Fortune 500 companies and a Big 5 consulting company with a strong background in client/server technology.
• Works effectively with colleagues and clients at all levels. Strategic thinker and planner, skilled in the design and execution of effective IT solutions.
• Strong skills in business process analysis and definition, relationship development and strategic alliances building.

TECHNICAL PROFICIENCIES
Applications: PeopleSoft Financials 9.1 with General Ledger, Accounts Payable, Accounts Receivable, eSettlement, Assets Management, Budget, OM, Purchasing, Inventory, Billing, Contracts, Grants Suite, Commitment Accounting, e-procurement, and Project Costing modules. PeopleSoft HRMS 9.0 with Payroll, Human resources, Time & Labor, Global Payroll 8.8, Variable Compensation, Pension, Base Benefits, Ben Admin, ELM, eProfile, and eRecruit modules. Education & Government HRMS.

Software: PeopleTools, PeopleCode, SQR/SQL, Process Scheduler, Application Designer, Application Messaging, PS Query, Crystal Reports, Operator Security, Application Reviewer, Upgrade Assistant, Change Assistant, Source Safe, AppWorks, Maestro, Autosys, JCL, MS Office, MS Access, Visio, Power Point, MS Project. PERL Scripts, Visual Basic and API\'s, ODBC, OLE 2.0.

Database: Informix SQL 7.1, Sybase 4.2, Oracle 8i, MS SQL Server 2000 and 2005 SP2, Hyperion Essbase 6.5, DB2, TSO/ISPF 5.2.

Operating System: DYNIX/PTX, OS/2, UNIX, Windows 64 bit, VM/CMS, AIX, MCP, MS-DOS, MVS.

Methodology: PMI PMBOK, SEI CMM, IBM Rational Unified Process (RUP), Summit (PWC), Unified Modeling Language (UML), Agile, Rapid application development (RAD), SCRUM, SDLC.

Testing Tools: Load Runner 6.5, Win Runner 6.0, Test Director from Mercury, and SQA Robot.

Component Interface: PeopleCode, PeopleTools, SQR, Business Object, Application Engine.

EDUCATION

• BS in Computer Science and Engineering in 1987 from Indian Institute of Technology Roorkee, India.
• Post Graduate Diploma in Business Administration in 1989 from K C College of Management Studies, Mumbai, India.

TECHNICAL TRAINING

• Successful Project Management
• PeopleSoft Educational Application Training: PeopleTools I/II, SQR/SQL, and PeopleCode
• PeopleSoft 7.5 Data Management Tools
• PeopleSoft 8.12 Accelerated Technical Week training
• PeopleSoft Server Administration 8.4x

DETAILED PROFESSIONAL EXPERIENCE

Feb 2009 – Present

PeopleSoft Architect
Confidential,

Upgrade of PeopleSoft Financial Supply Chain Management from 8.9 to 9.1, tools 8.48 to 8.50 with Accounts Payable, Accounts Receivable, Billing, Purchasing, Procurement, Asset Management, Inventory, project costing, contracts, and GL modules. My main responsibilities included:

• Actively involved in the entire PeopleSoft FSCM upgrade project starting from building the demo environment to various phases of the project life cycle. One point source of issue resolution during the upgrade project.
• Identify the changes / retrofit of the customization, and interfaces due to this upgrade. Wrote several Technical Design documents for the changes identified.
• Provide the development support, changes in application engine programs, SQRs, Peoplecode, file layout, integration broker messages, portal structure.
• Perform troubleshooting, debug application errors and performance tuning of various SQL scripts that were run during the upgrade. Used change assistant tool to run various application upgrade steps.
• Written test scripts for system testing, and integration testing.
• Data cleanup, and archive. Helping user in month end close and year end close by balancing the entries in AP, AR and billing modules. Created reconcile reports to accomplish the process.
• Customized Trial Balance Detail Report, and created new report to list outstanding encumbrance detail by purchase order distribution line.
• Provide change control and training on new release to several principals.
• Worked extensively with configuring Integration broker between PeopleSoft Financial and HCM.
• Worked on creating troubleshooting documents for post go live production support.
• Acted as a single point of contact for resolving technical issues in the production environment in all the Financial modules.
• Analyzed and recommended improvements to processes, procedures and systems. Created several control documents and streamlined the procedures to meet the need of stakeholders.
• Implemented the Performance Monitor tool to forecast a possible problem in future and taken steps to prevent them.
• Day to day PeopleSoft Security Administration, and System Administration activities including creation of new users, roles, permission lists, query access, security setup and access to the application designer.
• Design and develop various new custom reports using Application Engine, Crystal Report, nVision and SQRW.
• Created PeopleSoft Queries reports as requested by the users.
• Trained, mentored, and evaluated team across the group. Demonstrated excellent verbal and written communications skills, including effective presentation and strategic planning.
• Implemented automated process to run long running batch jobs using Schedule job-set definition for effective use of the available servers.

Environment: Microsoft SQL server 2005 SP2, Windows 2003 64 bit, PeopleSoft Financials 9.1, PeopleSoft HCM 9.0, PeopleTools 8.50, SQL, SQR, PeopleCode, Application Engine, Crystal Repots, nVision, Query, integration broker.

Nov 2004 – Jan 2009

PeopleSoft Confidential,

• Implementation of PeopleSoft Financials 8.8 SP1 with Purchasing, Accounts Payable, Accounts Receivable, Billing, Inventory, AM, GL and eSettlement. Implementation of PeopleSoft HRMS with HR, Global Payroll, Time and Labor, Benefits Administration, ePay, ePerformance and eRecruit modules.
• Upgrade of PeopleSoft Financials and HRMS applications from v8.8 to v9.0 and tools upgrade to v8.49.10.

My main responsibilities included:

• Developing the Solution, Scope, Implementation Planning, Security Administration, System Administration, and Fit Gap Analysis.
• Defining Business Process, and writing Functional and Technical Design of Customization, Interface, Data Conversion, and Reports Development.
• Implementation of Global Payroll in 4 countries USA, Canada, Mexico and China.
• Configuration and testing of Global Payroll Country Extensions (CEs) for Mexico. Execution of several parallel payrolls prior to go-live.
• Design and develop various reports using Application Engine, File Layout, Crystal Report, nVision and SQRW.
• Involved in month end reconcile process. Created query to list outstanding encumbrance by Budget Period and summary by chart-field combination, created query to list all encumbrance journals entered directly into the General Ledger.
• Produce pay roll with the FLSA hourly rate and verify payroll payments for overtime under FLSA.
• Converted Employee Salary Report from Crystal to XML Publisher.
• Heavy interaction with the users for requirements gathering and to analyze and rectify the error conditions. Implemented change requests and new development design, development and testing.
• Created PeopleSoft Queries reports as requested by the department managers.
• Implemented applicable PeopleSoft patches, fixes, 1099 fixes, tools upgrade and application upgrade.
• Acted as central point of contact for PeopleSoft Production techno functional support. Analyze and debug application errors using supplied PeopleSoft Tools.
• Worked on creating troubleshooting documents for production support as reference document for other members of the team.
• Worked extensively with configuring Integration broker between PeopleSoft financial and third party websites for Market data load, sanctions of vendors etc.
• Creating detailed audit reports verifying data inconsistencies between PeopleSoft and SMART.
• Creation of accounting entries in AR and extracting the data in a flat file and loaded into General Ledger module maintained on Werner System.
• Provided project training in tracing PeopleSoft applications, as well as mentoring team members in PeopleTools, SQL, and SQR.
• Support in resolving configuration, database, and platform and programming issues.
• Lead analyst during the implementation of eSettlement module. After go-live there were few show stoppers that were corrected by me. For example (a) eSettlement Vouchers that were created without a department were getting stuck in Pending status even after approver approves them. (b) the review invoices page was showing all the Vendors defined in the system and not just the Vendors authorized as suppliers in eSettlements.
• Day to day PeopleSoft system Administration activities including creation of new users, roles, permission lists, query access, security setup and access to the application designer.
• Responsible for refreshing of the development databases from production database and seeding test data for the testing of new development and customizations. Writing test scripts.
• Automated refresh of non-production databases and PeopleSoft file system from production environment.
• Created Demo, Development, Test and QA PeopleSoft environments for new tools and application upgrade and application testing.
• Install web servers, application servers, process schedulers, security, Infrastructure maintenance and troubleshooting. Performed performance tuning for PeopleSoft application server and process scheduler.
• Migration of different applications from development database to test database and then to production database.
• Making the process automated to run in the nightly Schedule job-set.

Environment: Microsoft SQL server 2005 SP2, Windows 2003 64 bit, PeopleSoft Financials 9.0, PeopleSoft HRMS 9.0, PeopleTools 8.49.10, SQL, SQR, PeopleCode, Application Engine, File Layout, Application Messaging, Crystal Repots, nVision, Query, integration broker.

Apr 2004 – Nov 2004

PeopleSoft Techno Confidential,

Involved in PeopleSoft Financials 8.4 implementation with Accounts Payable, Accounts Receivable, Billing, General Ledger, Purchasing, Contracts, Inventory, Project Costing and Grants Modules. My main responsibilities involved:

• Analyzing and implementing the business functionality related to Accounts Receivable, Billing, and Project Costing Modules.
• Configuration / Unit and Integration testing/ Customization of the various aspects of the GL,
• Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL
• Extensively worked on General Ledger n/Vision reports for Cash allotment, Cash Balance by Fund, Trial balance and Department level expenditure.
• Writing functional Design Specifications, test scripts and identifying test data.
• Responsible for core setup and configuration of AR, Billing and Project Costing modules.
• Responsible for legacy system conversion, and system testing.
• Facilitating Chart of Accounts design.
• Setting up Budget Transfer, Journals, Purchase Orders and Vouchers workflow.
• Reports and Interface Development. Reconciliation of Projects data with GL.
• Development of advance housekeeping queries and reports
• Development of conversion and archive data validation reports and Integration Warning Reports.

Environment: PeopleSoft Financials 8.4, PeopleTools 8.43, SQL, SQR, PeopleCode, Application Engine, Crystal Repots, nVision, Workflow, Advance Query, PeopleSoft Security, HP-UX 11, ORACLE 9

Apr 2003 – Mar 2004

PeopleSoft Techno-Functional Lead

Confidential,

Involved in PeopleSoft Financials 8.4 implementation with Accounts Payable, Accounts Receivable, Billing, Assets Management, General Ledger, eprocurement, Purchasing, Contracts, Commitment Accounting, Projects and Grants modules. My main responsibilities included:

• Gather and translate functional requirements into technical design.
• Writing test scripts and identifying/seeding test data.
• Mapping the current PI Portal, Web Financials, Project Digest and eActivity system with PeopleSoft.
• Seeding data for PI Portal Interface Testing - Creating a Proposal Header, project profile, create a budget header and budget line summary, setting up Institution, Budget, and Allowable F&A Rates, detailing personnel/salary, entering cost share, Submit proposal, generate Award Process, grant and contract reporting processes, grant and contract billing process and Commitment Accounting.
• Developed batch program to identify commitments made, commitments realized, and project overrun as compared to the Budgeted Amount.
• Set up chart of accounts; configure Analysis Types and Analysis Groups.
• Designed and developed conversion and audit programs to convert into PeopleSoft Grants, Contracts, Customers (Grant Sponsors), GL Journals, Purchase Orders, and Item Categories.
• Worked on budgeting for payroll expenses, encumber base pay, longevity, additional pay, and associated fringe benefits, track actual payroll costs, and exchange this information with the financial system.
• Design developed AR Billing Load Interface, Cashier AR Lockbox Interface Program.
• Support batch processing that includes resolving all errors in custom programs, ARUPDATE, and other associated PeopleSoft delivered AR/Billing processes.
• Design and develop various reports using Application Engine, File Layout, Crystal Report, nVision and SQRW. Development of housekeeping queries, salary detail reports, reconciliation of Projects data and Integration Warning Reports.
• Used Application Messaging feature to synchronize data between legacy PI Portal and PeopleSoft Project Resource Data.
• Heavy interaction with the users to analyze and rectify the error conditions.
• Analyzing and applying PeopleSoft fixes and patches.

Environment: HP-UX 11, ORACLE 9i, PeopleSoft Financials 8.4, BRIO Intelligence tool, Autosys, SQL, SQR, PeopleCode, Application Engine, File Layout, Application Messaging, Crystal Repots, nVision, Query, PeopleSoft Security

Jan 1997 -– Mar 2003

Confidential,

PeopleSoft Techno-Functional Consultant at Home Depot, Atlanta, GA

Nov 2002 – Mar 2003
Implementation of PeopleSoft HRMS 8.8 with Human Resources, Global Payroll, and Ben Admin modules.

PeopleSoft Techno-Functional Consultant at PricewaterhouseCoopers, Tampa, FL

Nov 2001 – Oct 2002
Conversion of a financial legacy system, supporting multi-company, multi-currency to PeopleSoft v8.4 with GL, AR, Budget, Purchasing, Inventory, AP, AR, Billing, OM and Project Costing modules.

PeopleSoft Techno-Functional Consultant at Bank of America, Charlotte, NC
Sep 2001 – Oct 2001
Worked in a PeopleSoft HRMS 8.3 conversion project. Nations Bank that was HRMS on Tesseract system, after merger with Bank of America converted their human resources system to run on PeopleSoft HRMS 8.3.

PeopleSoft Technical Consultant at Glaxo SmithKline, Durham, NC

Apr 2001 – Aug 2001
Worked in the merger of Glaxo and SmithKline Beecham’s Human Resources and Payroll systems to convert the legacy system of SmithKline Beecham from Tesseract to PeopleSoft HRMS 8.0 (HR, Payroll and Base Benefits modules).

PeopleSoft Technical Consultant at Henry Ford Health System Detroit, MI

November 1999 – Mar 2001
As a Project Lead for Henry Ford Health System led a team of 12 people in the Information Technology group. The team comprises of 6 consultants and 6 employees. Performed Financials 7.53 to 8.0x upgrade with AP, AR, GL, PC, AM, Purchasing, Billing, Budget, OM modules.

PeopleSoft Project Lead at St. Elizabeth Medical Center, Covington, KY

January 1999 – October 1999
Performed upgrade of PeopleSoft Financials 7.0 to 7.5 with GL, AP, AR, AM, and Billing.

PeopleSoft Technical Consultant at Toyota Motors Manufacturing, Georgetown, KY January 1997 – December 1997

Involved in the customization and new Implementation of PeopleSoft HRMS Application (6.0) with HR, Payroll, Ben Admin and Time & Labor modules.