SUMMARY:

• A Senior professional with over fourteen years of extensive experience in project planning & control, IT Design and development management, data conversion techniques, test planning & control, business requirements analysis, functional specifications, PeopleSoft implementation, system development lifecycle, and contingency planning.
• Over 8 years of experience in PeopleSoft Financials design and development.
• Experience working on large - scale PeopleSoft global implementations.
• Strong experience in Change Control management.
• Professional experience spans several industries, which includes Fortune 500 clients.
• Good understanding of Accounting process and systems.
• Excellent communication and interpersonal skills. An excellent team player with leadership skills. Detail oriented and highly organized.

TECHNICAL SKILLS:

Software:PeopleSoft, Peoplecode, PeopleTools, Tree Manager,PS-Query, MS-Project, Niku Workbench

EXPERIENCE:

SENIOR MANAGER

Confidential, NY, NY

Responsibilities:

• Participated in upgrade activities.
• Designed/implemented security for all modules including GL, AM and PC
• Participated in testing of GL, AM, PC and AP modules
• Configured and tested WorkCenters for all modules.
• Evaluated PO/AP and matching process
• Reviewed the entire outsourcing process
• Prepared process flow diagram
• Created a recommendations documents outlining short and long terms recommendations for the AP department
• Recommendations resulted in reduction of backlog from over 12,000 invoices to below 5,000
• Recommendations also resulted in reduction of over 90 man hours per month to resolve payment issues

Confidential, Atlanta, GA

Responsibilities:

• Managed an effort to harmonize combo edits across the enterprise. Reviewed GL allocations.
• Prepared project plan for the effort
• Updated GL configuration to accommodate.e new BU’s
• Recommended modifications to existing allocations. Created/modified allocations.
• Updated tress to accommodate new/update combo edits/allocations
• Conducted GL data cleansing exercise. Evaluated GL data for multicurrency processing issues. Recommended solution for multicurrency issues
• Utilized pivot tables and Vlookup functionality of Excel to trouble-shoot data
• Participated in closing activities

Confidential, St. Louis, Mo

Responsibilities:

• Participated in staggered data conversion activities from legacy systems to PeopleSoft 9.1 release for AM, AP, PC and GL modules
• Conducted meetings, updated project plans and provided feedback to the management
• Provided recommendations to automate conversion process and validate data
• Reviewed configuration data and suggested modifications to the design documents
• Participated in testing of converted data for GL, AM, PC, and AP modules for each release
• Prepared documents to reconcile converted data and prepared feedback reports
• Interfaced with the Hyperion team to send/receive data to/from Hyperion Planning
• Coordinated activities of functional and technical teams

MANAGER

Confidential

Responsibilities:

• Participated in various ERP implementation projects.
• Responsible for staff recruitment and training of personnel.
• Participated in RFP’s process and evaluation of vendors.

Confidential

Function Lead/Project Manager

Responsibilities:

• Conducted requirement gathering sessions
• Prepared project plans for each implementation and provided weekly status reports to the upper management
• Prepared process maps, configuration documents and configured each implementation.
• Participated in conversion activities of GL and AP module
• Conducted CRP and training sessions
• Participated in the AM conversion activities. Prepared reconciliation documents.
• Participated in merger of Swiss and non-Swiss instance of PeopleSoft
• Provide support to existing countries
• Participated in implementation of multi GAAP
• Identified and implemented best practices.
• Managed activities to various teams to rollout SWIFT payment system to new location.
• Conducted requirement gathering sessions.
• Prepared process maps, configuration documents and configured each implementation.
• Presented AR/BI functionality to user groups.
• Coordinated activities of development, DBA and infrastructure teams for each rollout.
• Configured global functionality such as VAT, document sequencing and multicurrency

Confidential

Functional Analyst

Responsibilities:

• Reviewed results of audit conducted by Deloitte for Financials and provided remediation/feedback on the audit report.
• Reviewed AR, BI, Fixed Assets and AP configuration as part of the audit review process.
• Reviewed invoice imaging functionality within the AP module and provided recommendations to fix a gap in it.
• Provided recommendations for workflow to automate system access process. The existing process was paper-based and very cumbersome.
• Participated in the cut-over exercises. Conducted cut-over sessions.
• Responsible for implementing PeopleSoft 9.0 security for the client.
• Security architecture included both roles-based and row level security including security sets and security join tables.
• Prepared functional/technical specifications and training material.
• Participated in the identity management program
• Organized and managed penetration/vulnerability testing for the PeopleSoft architecture.

Confidential, Chicago, IL

Functional Lead

Responsibilities:

• Functional Lead for global rollout of AP, GL, Projects and Fixed Assets modules to UK, Australia, Canada and Germany
• Conducted CRP, requirement gatherings and configuration sessions. Prepared functional specifications for customizations from the information gathered
• Analyzed conversion requirements and prepared functional design documents to convert AM, GL and AP data
• Created design documents and configuration checklists for each of the module
• Configured GL, AP, Fixed Assets and PC modules for new the business segments. Modified tableset control for localization
• Analyzed PC to AM and to GL reconciliation issues.
• Created and tested new allocations.
• Developed Mass Change templates and definitions. Over one hundred thousand assets were converted and included group assets and parent child relationships.
• Trouble-shooted depreciation related issues. Prepared specs to prepare new Asset Management reports. Identified core tables needed for Asset Books for the tax department and configured the Fixed Assets module accordingly.
• Configured system for global functionality such as VAT, Multicurrency, Multibook and consolidations.
• Identified and created steps for consolidations. Participated in revaluation process.
• Configured combo-edit rules for each of the new business unit.
• Participated in the design and testing session to convert calendar from fiscal to 442.
• Gathered VAT and Multicurrency requirements for each of the country. Configured VAT for Australia, UK and Germany and Vertex for US and Canada.
• Analyzed and implemented upstream/downstream system interfaces.
• Configured EDI to receive statements and electronic invoices.
• Prepared specs to reconcile vendor balances.
• Configured new vendors and customers for proper VAT and sales & use tax (Via Vertex) processing.
• Reconciled data for proper assessment of VAT and sales and use tax.
• Trouble-Shooted vendor liability processes
• Trouble-Shooted VAT and Vertex related issues.
• Identified integration points between the Billing module and Order Management, PO, Contracts and Projects module.
• Created scenarios and executed testing sessions to process data from the Order Management, PO, AP, Contracts and Projects module through the Billing interface to AR and GL modules.
• Prepared training manual for the AP/GL modules and trained end-users.
• Created training manual for nVision and trained end users in it.
• Participated in upgrade of internal CRM package integration of it with PeopleSoft
• Designed the strategy of batch testing to/from PeopleSoft
• Served as SME for AP, GLAM, and AR modules. Trouble-shooted production related issues
• Participated in de-coupling of PeopleSoft UK Membership business from rest of the company.
• Coordinated testing activities. Worked with various work stream to resolve defects in a timely manner. Utilized mercury Quality Center to organize defects and keep track of testing.
• Performed hands-on testing

Confidential, NY

QA Coordinator

Responsibilities:

• Responsible for designing the QA/Testing strategy for the entire PeopleSoft implementation
• Responsibilities included identifying resources, preparation of project plans and test plans
• Prepared QA strategy document.
• Prepared PeopleSoft environment strategy. Identified processes for manual and automated testing using Mercury suite of testing tools.

Confidential, Maryland

Responsibilities:

• Responsible for configuring PeopleSoft GL and AP modules for VAT functionality for Japan, Hong Kong and other Latin American countries.
• Participated in the roll-out of PeopleSoft to these countries.
• Participated in the Regression Testing for GL, AP and PO modules for the modified PeopleSoft system.
• Participated in HRMS (PR, Benefits, HR, eBen) in the upgrade of 8.3 to 8.9 release. Major responsibilities included design of upgrade strategy of security between the two versions.
• Participated in resolution of defects arising out testing of various environments.

Confidential

Platform: UNIX and Oracle

Responsibilities:

• Participated in configuration of PC module. Analyzed PC to AM and to GL reconciliation issues.
• Involved in modifying various PeopleSoft supplied Crystal report such as Project Estimate and Project Variance reports. These reports were modified to include tree tables to be summarized at different tree levels.
• Participated in adding new analysis types, analysis groups, categories, and sub-categories.
• Tested integration of PC module with AM, GL, AM, Expense and CM. Trouble-Shooted interface related issues amongst the modules.
• Participated in the configuration and testing of Expense module.
• Participated in testing of GL, AP, PO, AM, PC and Expense modules for code changes and Tools upgrade. Identified integration points between PC and other modules and performed regression testing of these integration points.
• Participated in PC to AM and to GL reconciliation.
• Prepared training material for the AM, PC and GL modules. Documented process changes
• Coordinated testing activities for a global roll-out of Finance (AM, GL, AP, Projects, and Expenses) and Quote to Cash (AR, BI, OM, CM, IN) modules.
• Participated in the configuration and testing of European functionality. Tested and trouble-shooted VAT and Multicurrency related activities.
• Updated Trees and COA as necessary. Created ad hoc reports and queries. Participated in the budget creation process. Created and tested new Combo Edit rules.
• Participated in implementation and testing of Workflow.
• Prepared training material for the GL, AM, PC and AP modules. Documented process changes.
• Created and resolved TPRs (Service requests).
• Conducted PS-Security class of 7 students for Oracle, Netherlands.
• Utilized PeopleSoft implementation experience to deliver this class

Confidential

Platform: UNIX and Oracle

Responsibilities:

• Participated in post-implementation data integration effort.
• Trouble-shooted reconciliation issues amongst AP, GL and Projects modules.
• Prepared documentation outlining the procedures necessary to reconcile data amongst various modules.
• Participated in the conversion strategy for the Projects and Contracts module. Conducted user interviews and designed mapping documents from legacy to PC/Contracts. Prepared conversion design documents and programming specs to convert legacy data to PeopleSoft.
• Responsible for implementation of Financials and HR security for Wyoming - DOT
• Prepared Security Strategy document.
• Conducted user interviews analyze security requirements. Translated the requirements into Permission Lists and Role.
• Trained client users in creation of PeopleSoft security

Confidential

Platform:UNIX, Windows and Oracle

Responsibilities:

• Managed a team to conduct Performance Testing of PeopleSoft environment (GL, AM, AP, PO, BI, AR, EPM, HCM). Served as the functional SME for the Financials module.
• Trained the testing team in AP, GL, AM, AR and BI modules.
• Identified integration points of GL, AM, AP and AR/BI modules required for performance testing.
• Assisted PeopleSoft Security team in identify roles and permissions and implement them.
• Directed DBA’s work to trouble-shoot performance issues.
• Utilized Mercury LoadRunner to simulate multiple users.
• Presented findings and recommendations to the upper management. Prepared project plans and Power Point presentations as reporting tools.

Confidential

Platform: UNIX and Oracle

Responsibilities:

• Led a team of developers and functional users through the post-implementation UAT process for Projects, AP, PO, AM, GL and ELM reports.
• Created Accounts Payable/Project Costing interface program. This was SQR process, which retrieved data from AP tables such as Voucher, Voucher Line, and Voucher Accounting Line and moved to proj resource table in Project Costing module.
• Participated in the design of Projects and GL universes.
• Trouble-Shooted and configured AM depreciation related issues. Resolved AM conversion related issues.
• Prepared functional specs for modification of AM tax and depreciation reports.
• Performed requirements analysis for Tagged assets. Supervised the design and development of online modifications for the AM, GL, and PC modules.
• Customized the delivered reports for Asset Management for using Asset tag ID field instead of asset id for reports like Auto-Retired asset reports, Depreciation activity by Category, Depreciation by account, Asset net book value by account, asset net book value by location, Depreciation by period and all other delivered asset reports.
• Gathered functional requirements and translated them into technical specifications for Crystal/Query and SQR reports. Coordinated the activities of developers, infrastructure, Business Objects and users teams to manage the scope and timeline of the project.
• Manage object migration request and formulated change control standards.
• This effort resulted in successful development and acceptance of PeopleSoft reports.

Confidential

Responsibilities:

• Led a team of testers for Integration and System Testing phases of PeopleSoft Financials 8.4 upgrade/global implementation. Prepared project plans using MS-Project.
• Utilized knowledge of PeopleSoft and global functionality (VAT and multi-currency) to identify associated risks and created test scenarios and cases to minimize such risks. Participated in testing of VAT and Multi Currency functionality for European and Asia-Pacific countries.
• Participated in lab sessions with teams from UK, Germany and France to identify local country requirements including VAT and Multi Currency.
• Created and modified test scripts and tested all aspects of PeopleSoft modules (AP, GL, AR, Billing).
• Created Vendors, withholding codes, withholding classes, withholding entities and withholding types.
• Processed withholding and created associated reports. Trouble-shooted problems related to Pay Cycle and Invoice processing.
• Configured EDI manager. Presented new functionality of AP module to user group.
• Escalated and resolved technical and functional issues.
• Utilized PS-Query to validate test results.
• Responsible for all change control activities (creation of SIRs, coordination of objects migration,) related to PeopleSoft and non-PeopleSoft objects.
• Identified and corrected change control leaks.
• This project resulted in smooth testing/implementation of PeopleSoft project.

PROJECT MANAGER

Confidential

Responsibilities:

• Assisted Functional team lead in gathering requirements for the design on AM, AP and GL modules. Participated in establishing business processes standards for AP, GL, and AM. Conducted user interviews and prepared Fit-Gap analysis for the GL module. Participated in all facets of implementation. Made extensive use of Tree Manager and PeopleTools to create and modify trees and Pages. Participated in the configuration of AP and GL modules. Familiar with PeopleSoft Component Interfaces application.
• Participant of project steering committee. Participated in the evaluation of technologies and provided recommendations. Ensured that strategic goals of the company and clients were met and best practices were fully leveraged during the implementations. Participated in establishing change control standards. Participated in the development of an internal change management control tool (OMR tool).
• Participated in the implementation phase of a large-scale (over 100 team members) BPI and PeopleSoft 8.4 project for a major utility client (Exelon Corporation). Participated in the business requirement definition, technical and application architecture design, and in the data staging activities.
• Participated in unit and system testing of GL, AP, and Projects module. Responsibilities also included tree modification and configuration of GL and AP module.
• Responsible for requirement gathering and analysis, designing and implementation of an enterprise reporting architecture.
• Utilized Business Objects to create universes and designed a set of GL and Projects related core financial reports. The reports extracted data from the PeopleSoft and Power Plan databases and were utilized to balance the reports generated from data marts. Utilized PS-Query to balance the reports.
• Made extensive use of Microsoft’s VSS tool to control objects modification and migration. Identified issues, created SIRs and coordinated migration of objects. Presented SIRs status to the Change Control review board.
• Responsible for the design, construction, implementation and security of the Business Objects universes and reports.
• Participated in the design and configuration of PeopleSoft Security permission lists, roles and users, which included row-level security, object security, query security and LDAP authentication.
• Participated in PeopleSoft version 8.4 upgrade assessment responsible for the requirements gathering and fit gap of the Asset Management module. Responsible for identifying integration points and assessing the impact of the PeopleSoft Financials Version 8.4 upgrade on the client's technical infrastructure.
• Functional /Technical Analyst on the Financials project responsible for the implementation of PeopleSoft Asset Management 7.5 at a large waste services company. Participated in requirements gathering, design, development, testing, and nationwide phased implementation. modules.
• Participated in requirements gathering, system design, system development, testing, and implementation of AP module. Gathered clients requirements and performed fit/gap analysis. Designed configuration documents. Conducted conference room pilot.
• Analyzed impact of online customization on interfaces, reports (SQR, Crystal) and other delivered processes.
• Served as a point of contact for the successful execution of Integration tests between external parties and Clients international business divisions.
• Managed an Integration Testing Team responsible for ensuring all system functionality of PeopleSoft GL, AM, and AP modules were properly tested prior to deployment.
• Coordinated design of test objectives and cycles, test steps and expected results. Coordinated all change control activities.
• Produced test data sets and manual and automated test scripts using SQA Robot.
• Utilized SQL to extract data from PeopleSoft tables to match expected and actual result.
• Produce testing schedule and coordinated test execution.
• Ensured appropriate documentation was maintained for completed test phases.
• Executed and log test cycles and managed sign off of completed and satisfactory test cycles. Reviewed test results with project directors and area controllers. Filed test results for completed test cycles.
• Responsible for ensuring that testing environment was in place for each of the test cycles. Coordinated the efforts of technical, functional and user teams during the roll-out of PeopleSoft.
• This effort was spread over 11 months and resulted in smooth deployment to over 2900 business units.
• Directed a project design team of 9 consultants, contractors and client resources to facilitate the conversion of vendors, assets, and general ledger data from a legacy system to PeopleSoft system and to design multiple interfaces. Responsible for work plan development and maintenance, resource management, deliverable creation, and presentation of project status to the upper management at the weekly status meetings. The combined effort resulted in conversion of over 425,000 assets, over 200,000 vendors, conversion of 32 million rows of general ledger data, and successful implementation of 18 interfaces.
• Developed interface design methodology and conversion approach documents. Participated in establishing change control standards for updates to PeopleSoft objects. Created SIRs and coordinated object migration.
• Introduced the tip sheet concept as a knowledge transfer tool for the support center that resulted in shortened learning curve for the support center resources. Established standards and SLA’s for internal/external entities.
• Coordinated activities of client’s computer security team to establish security policies to establish windows in the firewall so outside vendors can place interface files on client’s computing environments.

SENIOR ANALYST

Confidential

Responsibilities:

• Participated in the PeopleSoft Data Management (Upgrade) class. Participated in the PeopleSoft upgrade from V6.0 to V7.5 for AM, GL, AP, AR and IM modules. Performed business/Technical fit gap for GL module. Utilized Access database to keep track of objects modification. Participated in the comparison of upgrade reports decide which objects should be tagged for upgrade. Utilized a compare utility identify differences between objects. Remediated custom objects for upgrade.
• Participated in the User Lab session to perform fit analysis between the client’s business and AM and GL modules. Participated in the configuration of GL module. Prepared specs to convert data from legacy system to Peoplesoft.
• Developed process flows, test approach/procedures, error-handling specifications for the GL module.
• Prepared training manuals and conducted a road show to train end-users across various sites located throughout the US.
• Prepared manual and automated scripts for testing of AM and GL modules. Utilized SQA Robot extensively for system and stress testing.
• Provided post implementation level 2 support for AM, GL, AR, and IM modules. Created/modified SQRs, and nVision reports. Participated in the month-end close process.
• Created UNIX scripts to execute batch process and send alerts/e-mail when a batch process failed.
• Created batch schedules using Tivoli Maestro to minimize human interaction.
• Performed DBA duties.
• Designed and developed an approach to convert client’s legacy systems (D&B Asset Management) into PeopleSoft Asset Management system. Prepared SQL scripts to load D&B AM data into PeopleSoft.
• Designed a spread-sheet program utilizing Excel and Visual Basic to edit and load data into PeopleSoft.

SENIOR SYSTEMS ANALYST

Confidential, California

Responsibilities:

• Architect of a system to correct year-end tax information to be reported to the federal and state tax collection agencies.
• The project received Productivity and Quality Award from Confidential Quality and Productivity Commission.
• Spearheaded an effort to electronically transfer data to/from outside vendors and between IBM and Unisys data centers instead of tapes.
• Prepared JCL and ECL scripts.
• The new approach cut down the processing turnaround time from days to hours.
• Assisted the IBM mainframe security team in establishing security policies to provide outside entities foolproof access to County’s computing environments.
• Managed and/or participated in several mainframe and PC based software development project. Prepared detailed programming specifications for new applications and enhancements and modifications to the existing ones. Prepared training manuals and trained end-users.
• Streamlined the efficiency of the operations by recommending modifications to the business processes. Recommendations resulted in significant saving of time and labor.