SUMMARY

Detailed, efficient PeopleSoft professional with 12 years experience and a strong background in financial systems. Comprehensive understanding of PeopleSoft Financial Management process throughout lifecycle, including design, configuration, development, integration, testing, and deployment. Extensive knowledge of PeopleSoft reporting tools including nVision, Query, SQL, SQR, Application Engine and XML. In-depth financial project experience working with clients and end users. Self-motivated with exceptional analytical and organizational expertise along with superior troubleshooting skills. Also possess excellent verbal and written communication skills

SKILLS

PEOPLESOFT FINANCIALS, HUMAN RESOURCES and DATABASE MANAGEMENT SYSTEMS

PeopleSoft 7 7.5 8.3 8.4 8.8 8.9 9.1 Oracle 8i 9i 10g 11g Access MS SQL Server DB2

PEOPLESOFT MODULES

General Ledger Expenses Purchasing Projects Project Costing Accounts Payable Accounts Receivable Banking Billing Asset Management Setup Financials Budgets Tree Manager

EXPERIENCE

Confidential

PeopleSoft Technical Developer

• Handled technical requirements related to Expenses, Asset Management, Accounts Payable, General Ledger and Purchasing
• Created and modified, SQRs, nVision, Crystal, Query and XML reports
• Developed, updated and validated PeopleSoft components, records, pages, PeopleCode and SQL queries
• Modified, created and updated Users, Security, Permissions and Roles
• Handled PeopleSoft issues and incidents
• Created PeopleSoft documentation, including design documents and test scripts
• Functional and technical testing of applications

Confidential

PeopleSoft Technical Developer

• Handled technical requirements related to General Ledger and Purchasing
• Created Workflows for Purchase Orders and Requisitions using Approval Workflow Engine
• Developed, updated and validated PeopleSoft components, records, pages, PeopleCode and SQL queries
• Modified, created and updated Users, Security, Permissions and Roles
• Updated tables and databases and created data backups using DataMover
• Created PeopleSoft documentation, including design documents and test scripts

Confidential

PeopleSoft nVision Developer

• Created, modified, analyzed and validated multi currency nVision layouts, scopes and reports
• Modified, created and corrected PeopleSoft Trees to meet GL reporting requirements.
• Creating, updating and validating PeopleSoft and SQL queries

Confidential

ERP Product Specialist

• Handling technical requirements relating to General Ledger, Payables, Billing and Accounts Receivables for New York Health Exchange
• Developed, analyzed, modified and validated nVision, SQR, Crystal and XML reports
• nVision setup and configuration
• Lead technical information and training classes
• Updated PeopleSoft applications using Data Mover
• Created PeopleSoft Account Trees

Confidential

Accounts Payable PeopleSoft Consultant

• Assisted end users with Accounts Payable issues, including vouchers and payments
• Developed an Accounts Payable database with contact, account, property and payment data
• Created reference documentation for Accounts Payable database and processes

Confidential

PeopleSoft Consultant

• Updated, corrected and validated nVision layouts and reports
• Set up Timespans to be used with nVision reporting
• Created and modified PeopleSoft Trees for reporting

Confidential

• Provided production support by troubleshooting query and report issues, working with business users when needed
• Developed, modified and validated multi-currency nVision layouts and reports
• Created and updated Scopes, Calendars and Timespans to be used with nVision Reporting
• Created and updated journal entries to perform unit testing on reports
• Created training and reference documentation for nVision developers and end users

Confidential

PeopleSoft Human Resources and Financials Developer

• Provided production support for General Ledger, Time and Labor, Benefits, Accounts Payable, Project Costing, Asset Management and Purchasing modules and worked with business users to gather requirements and data to assist with issues and updates
• Configured user security and created PeopleSoft projects, PeopleCode, Records, Views, Pages, Menus, Components, Application Engine, Workflows and Component Interfaces with Application Designer
• Developed, wrote, updated and tested PeopleSoft nVision reports, Application Engines, SQRs and queries with PeopleTools, PeopleCode, SQL and XML Publisher
• Registered components on PeopleSoft Portal and updated Portal entries for Procurement
• Created and maintained PeopleSoft documentation, including design documents and test plans

Confidential

PeopleSoft Technical Support Consultant

• Created, updated, tested and migrated PeopleSoft Projects and pages with PeopleTools
• Troubleshot, corrected, updated, tested and migrated PeopleSoft nVision reports and queries
• Modified and validated crystal reports for Project Costing and General Ledger
• Wrote scripts using SQL to update PeopleSoft data tables an updated user security
• Worked with business users to gather requirements, answer questions and assist with any issues

Confidential

PeopleSoft Consultant

PeopleSoft Functional Support Consultant

• Analyzed, upgraded, updated, migrated and validated PeopleSoft nVision reports and queries
• Assisted with General Ledger and Payables setup, chartfield configuration, trees and data validation
• Trained users to modify and run reports on the web server and using report manager with documentation
• Provided production support for General Ledger, Accounts Payable, Asset Management, Purchasing and nVision
• Troubleshot and corrected financial application issues, including reports, trees, process scheduler, report nodes, workflow, report repository, report files, integration broker and security

Report Developer

• Developed, wrote and tested financial reports using nVision, Query, views and Application Designer
• Improved performance on existing reports by shortening queries, redefining criteria and tuning trees
• Analyzed, validated, troubleshot and corrected financial reports using PeopleSoft Query and views
• Installed and configured PeopleTools upgrade for end users
• Assisted end users with PeopleSoft questions, issues and training, including documentation to run and modify reports

General Ledger Analyst

• Entered, analyzed and validated PeopleSoft General Ledger data
• Troubleshot, analyzed, updated and maintained existing financial reports using PeopleSoft Query
• Evaluated and validated PeopleSoft report data and generated reports
• Created and maintained client documentation for General Ledger, metadata, reports, queries and journals
• Edited and verified general ledger journals while maintaining and updating PeopleSoft trees

PeopleSoft Developer

• Reviewed and analyzed PeopleSoft data for Freddie Mac's customized financial system
• Developed and unit tested application components and implemented code using SQL, SQR, PeopleSoft Query and Application Designer to satisfy requested requirements
• Troubleshot Unix, Oracle, SQR and PeopleSoft technical issues
• Updated financial data using SQL, SQR, Unix and PeopleTools

Configuration Lead Analyst

• Worked with Ernst Young Global offices to gather financial information, design project plans and create schedules needed to configure countries for Ernst Young's Global Financial Information System
• Reviewed, analyzed and validated global configuration data for Ernst Young's financial business model
• Entered and updated country configuration data for financial modules including General Ledger and Asset Management using PeopleSoft exceltoCI, SQL and online pages

Confidential

PeopleSoft Technical Lead

• STAR project Human Resources Manangement System upgrade from PeopleSoft 8.0 to 8.9, PeopleTools 8.4
• Examined design documentation to ensure upgrade functional and technical requirements were accurately reflected and met, included validation of PeopleCode, PeopleSoft objects, SQR and SQL views using PeopleSoft Application Designer
• Evaluated System Investigative Requests SIRS to ensure that bugs discovered during system testing were successfully resolved, implemented and documented
• Developed queries to validate PeopleSoft Human Resources Pensions upgrade data and fixes

Confidential

PeopleSoft Consultant

• Analyst, Federal Aviation Administration using PeopleSoft 7.02
• Developed, wrote and tested financial reports for General Ledger using nVision, SQL, Views and Query
• Updated and corrected financial Business Object and PeopleSoft reports
• Used PeopleSoft Queries, Views and SQL to modify or correct client financial reports
• Updated and maintained client documentation for reports, views and queries

Quality Assurance Tester, PeopleSoft

Tested the functionality within the PeopleSoft 8.8 Financials Application for PeopleSoft, included General Ledger, Commitment Control, Budgets, Journals, Financial Setup, Business Unit Setup, Ledger setup and Worklist

Database Developer, Transportation Security Administration

Designed, developed and created Correspondence Tracking Access database

PeopleSoft Analyst

• Assisted with an upgrade from PeopleSoft 7.5 Financials to 8.4 and performed validations
• Assisted with General Ledger setup and inquiries and handled Accounts Payable and Purchase Order errors

Confidential

PeopleSoft Developer

Developed reports in PeopleSoft 8.4, using nVision, Query, Crystal, SQR and SQL and used Application Designer to make interface/portal modifications

Confidential

Fiscal Officer

• Supervised Fiscal department while handling all Solomon, PeopleSoft and Novell system and server support and updates
• Trained employees on Human Resource, Accounts Payable and General Ledger modules of PeopleSoft and Solomon
• Maintained Employee Benefits and Payroll using PeopleSoft and used SQL to fix General Ledger issues
• Reconciled general ledger, bank accounts, financial books, trial balance and investment books