PROFESSIONAL SUMMARY:

• Over 15 years PeopleSoft consulting experience ranging from full life-cycle implementations, major upgrades and enhancements and production support. - Experience in the design, implementation, and management of business systems solutions. - Strong leadership experience as lead consultant on major implementation and upgrade projects - Solid working knowledge of both functional and technical aspects of PeopleSoft products - Solid working knowledge of implementation methodologies - Excellent analytical, trouble-shooting and business process design skills - Outstanding interpersonal, facilitation, communication, and business writing skills - Skilled in accounting and process analysis, improvement evaluation, requirements, development and process/system change management - Consistent and proven track record of delivering value and results
• Implementation/Upgrade/Production Support Skills: Fit-Gap Analysis, Requirements Gathering, Functional Design, Report Writing, Business Process Design, Project Charter Development, Test Planning , Test script development and execution, End User Training, 3rd Party Integration, Project Management, Security Design, Cutover Planning, Address all production support tickets functional and technical issues PeopleSoft Products: General Ledger , Accounts Payable, Bank Setup, eProcurement/Purchasing, Asset Management, Project Costing, Contracts, Accounts Receivable, Billing, Cash Management, Commitment Control, HRMS HR, Payroll, Payroll Interface, Benefits, Self Service PeopleSoft Technical: PeopleTools, People Code, SQR / SQL, AE, Query, n Vision, Application Engine, EIP App Message, Tree Manager, File Layout, Data Mover, , MS SQL and Oracle SQL, Workflow and Approval Framework , Business Process Workflow, Component Interface, Excel to CI, Data Mover, Crystal Report, PS Security, MS SQL Server 2005 Integration Services SSIS, SSAS, SSRS,PPS-Performance Point, Share point Services

Industry: Financial Services, Higher Education, Healthcare, Oil Gas, Media Company, Public Sector, Insurance, Professional Services, Retail Manufacturing

Confidential

Sr. PeopleSoft 9.2 Functional Upgrade

• Assessment Project for client PS 9.2 Upgrade
• Preparation of materials for presentation needed in CRP.
• Tested current demo environment for specific features to be demo to client
• Successful Conference Room Pilot CRP Presentation of eProcurement and Accounts Payable new features for Peoplesoft 9.2. Presentation done first to IT users and later to Functional users. Assisted as well to CRP on other modules such as General Ledger, Contracts, Project Costing, Asset Management, Accounts Receivable and Billing as needed.
• Reviewed client Allocation setup and possible improvement on performance issues.
• Discussed possible use of Consolidation Elimination functionality in GL.

Confidential

Sr. PeopleSoft Functional/Technical Implementation and Production Support Consultant

Responsibilities:

• Successful implementation of GL C E. Configured GL Consolidation and Equitization for more than 400 business units, tested and support validation of resulting calculation for both all elimination unit and equitization calculation as well between parent and subsidiary ownership
• Created various nVision report tabular and matrix for required C E.
• Created audit records, audit triggers and audit nVision reports
• Implemented new Combo Edit rule to address new validation issues
• Make additional changes in revaluation setup for new accounts and sub accounts and reconciled/proof reval / proof issue/questions
• Reviewed, re-designed security roles, permission security for AR/BI for SOX compliance and implemented AWE workflow for Billing for legal compliance requirement for broker/dealer business unit.
• Successful implementation of Revenue Billing. Configured AR/BI for Revenue Billing Project. Developed customization where warranted based on user requirements using Application Designer PeopleTools and Peoplecode. Configured Billing Workflow using AWE.
• Assist in all daily production support issues for GL, AP, AM, TE, Project Costing, CA, AR, BI for all ticketed Service Now incidents.
• Created test scripts for AM as part of overall testing of MP10 AND MP11
• Developed various audit security, triggers and reports using nVision.
• Developed Custom AM Mass Change Definition to transfers close to 200 assets from one department to another
• Primary production support consultant for AM Module
• Provided production support to Treasury Cash Management
• Development of various Row Level Security Permission List by Legal Entity
• Use STAT for migration of all development done in the system

Confidential

Sr. PeopleSoft Functional Production Support Consultant

Responsibilities:

• Completed PCI Compliance Project that went live Feb 2012
• Assist in all daily production support issues for GL, AP, PO, AM, AR, BI, Project Costing
• Modify reports using Query, Crystal and nVision layout both matrix and tabular.

Confidential

Responsibilities:

• Develop an implementation plan. Develop an overall project plan that includes milestones and phase of the project life.
• Develop the process flows for accounts payable. This includes flowcharts that document the departmental handoff points.
• Perform a Fit/Gap analysis and develop the PeopleSoft Payables module design
• Configure the Payables Module.
• Create functional specifications for report development and invoice pdf attachment customization.
• Designed and developed all conversion strategy and conversion programming for all AP vouchers conversion and AP payments conversion as well as vendor conversion using Component Interface EXCEL to CI . Developed also custom Bank Statement Load for Bank Reconciliation coded in Application Engine programming.
• Develop test scripts. Develop and oversee UAT. Perform Unit and System testing, troubleshoot issues.
• Develop a training program. Create training materials and train end users.
• Configured Treasury Module to use Cash Management Automated Treasury Accounting Entries generated from TR TO GL- for Automatic Reconciliation of Bank Statement Processing BSP- non check related transactions of AP Banks
• Completed the AP Voucher Workflow implementation, design/configuration and custom development.
• Year end 1099 for Vendors
• Developed Application Engine Component Interface program for Market Rate required for Multi-Currency GL interface.
• Worked on special projects for GL Global business unit multicurrency implementation redesign all AE to accommodate.
• Recon Frontier application reconciliation to PeopleSoft GL cash accounting entry interface, developed custom application engine program for legacy system interface to PS and developed another application engine program to extract file layout from PS system to interface back to Recon Frontier application.
• Provide production support issue on online and report modification

Confidential

Responsibilities:

• PeopleSoft HRMS/EPM/ FIN Implementation V9.0 Tools 8.49.2 Oracle DB
• Design Technical Document
• Conduct build phase customization for work units as assigned using PeopleTools, Peoplecode, AE, SQR, Crystal etc
• Assessed Finance analysis of finance records for migration to EPM
• Developed various reports using Query/Crystal and SQR
• Developed nVision matrix layout and tabular layout report from scratch
• Modified existing GL IS QTR ACT.xnv
• Customized AR/BI page/processes to fit client requirement using People Tools , People code
• Retrofitting SQR/App Engines for PS 9.0
• Retrofitting and customization of Online pages, Processes and reports
• Perform various unit testing

Confidential

Responsibilities:

• Led merger of two Financial PeopleSoft Project version 8.8 and version 9.0 integration to new system PS V9 with complete chart of accounts redesign.
• Developed conversion programs for GL Journals and Ledger information of both companies to the new Version 9.0 system with the new redesign chart field information.
• Tested and reconciled journals and ledger balances for all financial information converted.
• Created custom Tree structure id and custom Tree and various custom query as the foundation for the various custom Matrix nVision report due to custom tables foundation for the nVision Reports .
• Converted AP Vendors including VAT related vendors.
• Developed custom nVision Drilldown.
• Developed various reports using SQL/Query.
• Developed PeopleSoft HRMS/Benefit interface for United Health Group and 3rd party software Concur Expenses interface integration to PeopleSoft GL and AP and to 3rd party software payroll Ceridian.
• Developed various custom objects using PeopleTools, PeopleCode, AE, SQR. Conversion of other modules and testing of other modules

Confidential

Responsibilities:

• Project - Mizuho Capital financial company , functional upgrade lead for AM and PO. PeopleSoft V8 to PeopleSoft V9. Upgrade all AM and PO Setup configuration. Develop conversion mapping of transaction and setup tables from V8 to V9. Lead PO and AM Conference Room Pilot prototype session for NYC, UK and HK business unit. Developed job aides or training documentation for PO and AM. Converted some AM and PO setup tables from V8 to V9 using Microsoft BIDS SSIS ETL Tool . Backend Platform Oracle 11G
• Project - intrepid Healthcare Company based in Dallas , functional implementation lead- Solomon Legacy System to PeopleSoft V9 GL and AP. Setup all configuration tables for GL and AP using setup manager. Setup inter unit of all business unit total of 68 BU and intra unit for chart field operating unit. Conducted various testing for both GL and AP. Converted Vendor Data from Solomon legacy system into various PeopleSoft vendor tables using Microsoft BIDS SSIS ETL Tool . Backend Platform Microsoft SQL Server

Confidential

Responsibilities:

• PS Financial 9.0 Production Support in Oracle Database Environment
• PeopleSoft Financial GL, Projects Costing, AM, AP, PO Production Support.
• Did all audit queries for external auditor as requested by Controller reconciling the version 7 and version 9 data that was done for the upgrade
• Did all Cost Collection for Project Costing
• Did some AP/GL trouble shooting for issues
• Reviewed the Grants Module as it relates to Project Costing and Contract as requested by Finance Controller

Confidential

Sr. Functional Upgrade GL/Contract /Project Costing Lead

Responsibilities:

• PS Financial 8.4 to 9.0 Upgrade in Oracle Database Environment. Upgrade Lead Consultant 8.4 to 9.0
• PeopleSoft Financial GL, Project Costing, Contract, Billing, AR, AM, AP, PO
• Functional Upgrade Leader for GL, Projects Costing , Contract and also integration to other module like , Billing, AR, AM, AP, PO
• Led comprehensive upgrade of the financial accounting system PeopleSoft v9. Responsible for requirements gathering, fit/gap analysis, prototyping sessions, review of current business processes and developed expected future state with the new version of the accounting system for General Ledger, Projects, and Contracts Government Contracting . Solved issues concerning Project Cost Accounting and Revenue Recognition.
• Determined alternative solution in guiding the client to decommission from the old system with bulk customizations while achieving few customizations in the new version of the accounting system and still achieving the client's system requirement.
• Analyzed, tested and documented all integration points of Accounts Payable, Purchasing, AR, Billing to General Ledger, and Projects and Contracts. Conducted comprehensive financial application testing.

Confidential

Sr. Functional GL/AP/PO/CA/PC/AR/BI/ Time and Expense Production Support Consultant / BA

Responsibilities:

• Led support of Enterprise Service Automation Financial Application for General Ledger, Projects, Contracts, AR, BI, AP, and PO. Partnered with stakeholders to perform fit / gap analyses and requirements gathering to address revenue recognition and billing process issues. Conducted testing, business process redesign and system customization to solve billing and accounting issues.
• Resolved 34M Balance Sheet production reconciliation issue after extensive review and analysis of transactions and provided value added recommendations for various business process changes to streamline support processes and reported results to executive management. Responsible for unit testing of all production issues tracked via HP Quality Center prior to any object migration to production
• Assisted in data mapping of PS Financial Project module for EPM data warehouse of the client.

Confidential

Sr. Technical / Functional Consultant Project Costing,

Responsibilities:

• Subcontracted through Deloitte and Touch for Full Life Cycle implementation of PeopleSoft Financial modules GL/Project Costing /Contract/BI/AR/AM . Prepared detailed business process model for existing government contracting system. Responsible for planning, designing and getting buy-in for business support of the new government contracting system. Instrumental in identifying the resources required for design and development of various customizations to the contracting system cost plus requirement and various 3rd party interfaces to the new PeopleSoft system implementation. Later remote Production Support for nine months after Go Live.
• Developed technical design document and prototype design. Participated in requirements gathering, gap analysis, solutions development and identified resource needs. Tested process functionality and module interfaces. Collaborated with team to create n Vision reports, Crystal Reports, and SQR reports. Led development of custom solutions, developing various application engine programs/sqr programs and other online custom code to meet specific business requirements. Developed test scripts and led testing effort/execution of all custom and delivered functionality for GL, Project and Contract Modules
• Developed/ coded AE program for Custom Contract Processing. Customized delivered AE for Contract, Project and Billing such as PC Pricing, Contract to Billing Interface namely PC PRICING, CA LOAD GL1, PSA ACCTGGL, CA BI INTFC, PC CA TO PC, PC BI TO PC . Created custom Inter Unit Accounting AE program for Contract Revenue Redistribution.
• Tested Variable Pricing to demo to users for possible used.
• Developed various report requirement using SQR and Crystal.
• Assisted in various questions regarding data mapping for conversions.
• Designed integration of SAP Account Payable transactions to PeopleSoft General Ledger and Project Costing.
• Provided remote technical production support for PeopleSoft Financials GL / Contract / Project costing, / BI / AR modules after go live

Confidential

Responsibilities:

• Supported PeopleSoft Financials, including GL, AP, PO, E Pro, Expenses, and Security, Asset Management, and Project Costing modules in a Microsoft SQL Server / Quest STAT environment.
• Implemented Delegation of Authority Project for expense approval routing utilizing Workflow, PeopleCode, and Travel and Expense module objects. Developed custom account to related PS account to Hyperion account and vise versa.
• Developed, tested and documented requirements for compliance to SOX audits.

Confidential

Sr. Implementation Functional Lead / Production Functional and Technical Support Consultant

Responsibilities:

• Led ERP vendor evaluation, selection and full life cycle implementation of PeopleSoft Financial Applications GL/AP/PO . Authored project charter and project plan, determined resource needs, conducted business and technical analysis to determine necessary customizations, drafted design documents, and coordinated design and development efforts for PeopleSoft Financials. Developed custom interface program for ADP Payroll and GL. Ensured adherence with HIPAA regulations. Implemented Commitment Control, to include rules and all KK ledgers activated expense tracking.
• Developed and implemented budget application and supported Corporate Budget Controller in annual budget preparation and reporting
• Production Support of PeopleSoft Financial, GL, AP, PO, Budgets, AM, PC, and HRMS HR, Benefits, Payroll, Recruit Workforce, Self Service version
• Application MHRP Management Human Resource Review Process using People Tools, Peoplecode, SQR, Workflow
• Implemented Commitment Control, setting up all required rules, KK ledgers for budget, pre-encumbrance, encumbrance and expense and ledger group and setups for KK. Activating all KK for PO, AP, GL tracking specific expenses account/deptid combination
• Created various custom reports such Daily Vouchers Aging Report, Daily Vouchers Entered Report, Daily Vouchers Delete and Voucher Close which include Payment Cancellation which are close liability falling under vouchers close, required by the Accounts Payable Department. Setup all 1099 Withholding setups and run all 1099 Processes from Withholding Post AE , 1099 Report Post AE , 1099 Report APY1099.sqr -Created 1099 File for the IRS and 1099 Copy B Report AE and Crystal for the Vendors

Confidential

Responsibilities:

Supported PS General Ledger Multi-currency and Multi Book providing both functional and technical assistance to users covering areas of configuration, journal preparation and processing, edit and posting, month end close, financial preparation, revaluation process due to multi-currency, position accounting, average daily balance ADB , allocation, consolidation, and financial reporting using Business Objects and SQR. Provided training for international users such as those from Japan and Brazil providing training on how to use the PeopleSoft System.

Confidential

• Provided consulting services for the following client:
• American Insurance Group AIG Parsippany NJ 06/1999 to 01/2000 insurance industry developed accounting applications software and assisted in process improvements for the worker's compensation division. Applications included Accounts Receivable and Billing.
• McManus Advertising Troy Michigan 07/98 to 05/99 advertising industry Led Full Life Cycle Financial System Implementation. Developed custom application for PC/AR/BI/GL.
• Fox wood Casino, Mashantucket CT 02/98 to 06/98 entertainment industry Led PeopleSoft security implementation. Developed security mapping, performed development, implementation and documentation tasks.
• Suburban Propane Whippany NJ 12/97 to 01/98 energy industry Provided production support for PeopleSoft Human Resources, Benefits, Payroll. Developed various HRMS custom reports