PROFILE Over 14 years of solid, progressive technology and business-focused leadership work-experience in diverse sectors and functional areas, including full life-cycle implementation of PeopleSoft projects. Have worked on information technology and business process re-engineering projects in financial services, licensing, banking and higher education. Have extensive hands-on experience in performing ERP package evaluations, functional fit/gap analysis, business process design and reengineering, testing, upgrade, customizations, process modeling, data modeling, joint application design/prototyping, implementing and supporting PeopleSoft. Possess a sound understanding of PeopleSoft architecture, along with the challenges and risks involved in projects, business processes, and project implementation methodologies. Significant experience with managing projects with success. Careers marked by successful adaptation of various project management methodologies to diverse business settings. Have a proven track record of achieving on-time success through business process engineering, complex ERP implementations and the ability to over-come barriers and roadblocks to project completion. Superior communication skills, strong decision making and organizational, analytical, and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems. Experience in Financials 9.x Accounts Payable, Accounts Receivable, Billing, Projects and Contracts, Purchasing, Grants, Project Costing, GL with Commitment Control , HCM 9.x NA Payroll and Core HR , 9.x Campus Solutions Student Records, Admissions, Financial Aid, Student Financials, and Student Administration , and EPM 9.x utilizing Oracle Business Intelligence Enterprise Edition 11g for reporting ware house.

CORE COMPETENCIES

• PS Implementation
• PeopleSoft Upgrade
• Tuning/Efficiencies
• Functional Documentation
• Global Implementation
• Change Management
• Security Administration
• Fit/Gap Analysis
• Functional Analysis
• Technical Analysis
• Development / Coding
• Technical Documentation
• PL/SQL Development
• XML Integration
• Application Integration
• OBIEE 11g
• Analytics
• Training

PEOPLESOFT SKILLSET

• Application Designer
• Application Engine
• PeopleCode
• Component Interface
• Integration Broker
• PS Query
• SQR
• Crystal Reports
• NVision
• App Packages
• DataMover
• Change Assistant
• PS Admin
• Workflow
• Equation Engine
• Oracle Customer Support
• SendMaster
• Process Scheduler
• SpreadSheet Upload
• iScripts
• BI Publisher

IT SKILLSET

• PL/SQL
• Windows/UNIX/Linux
• SQL Server
• Oracle
• SQR
• VB Script
• XML
• PL/SQL Web Toolkit
• ProC
• Perl
• OBIEE 11g
• PowerBuilder
• HTML
• DataStage
• CSS
• Java
• Encryption/Decryption
• T-SQL

DETAILED PROFESSIONAL EXPERIENCE Confidential

• PeopleSoft Financials 9.1 Oracle 11gr2 technical lead on implementation of Project Costing. Supporting Billing, Account Receivable, Products, GL,
• Fit/Gap, Design. Document, Developed customizations for on boarding 25 businesses into the PeopleSoft ERP using customized automated tool sets.
• Streamlined Security, implemented standards, developed reports, extracts to address internal audits and integrate PS Security data with company Security request tool.
• Established Development standards documentation, educated development team on best practices.
• Implement PHIRE tool for PeopleSoft migrations organized processes to meet SOX standards.

Confidential

• PeopleSoft EPM 9.1 Oracle 11gr2 Built Analytic tools development and coded QA scripts for Functional users combing FSCM, WorkDay HR, CA and custom datasets. Completed high level tuning for very large datasets and focused on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence, Continued Production Support.
• Fit/Gap, Design. Document, Developed independent EPM Analytics for validating prior version of Warehouse to OBIEE ETL version.
• Researched Reporting anomalies and ETL source data issues providing feedback to business users on correcting bugs/setup/missing data.
• Designed, Documented, Engineered automated PL/SQL and DataStage tools eliminating ETL development issues related to versioning of Indexes and Statistics
• Designed, Documented, Developed data integrity validations for Materialized Views and staging tables.
• Worked with Oracle SharePlex and Data Guard to facilitate Global reporting needs, made enhancement to work within limitations.
• Fit/Gap, Design, Extracted WorkDay HR XML messaging data and loaded it into staging tables in EPM.

Confidential

• Sole PeopleSoft technical resource for PeopleSoft FSCM 9.0 Oracle 11g AP, PO, GL, PC, Contracts, ePro, Grants Tools 8.53 and multiple MP 1-19 Upgrade. Reapplied needed customizations and added new enhancements per business requests.
• Prepared fit/gap analysis documents based on business owner input.
• Requirements gathering, requirements analysis, preparing requirements specification documents, and timelines.
• Executed and utilized compare reports, Delivered business users impact analysis of customizations and processes.
• Executed, Reviewed, Cleaned DDD and SYS audits pre and post upgrade.
• Retrofitting PeopleSoft internal and external objects with Application Designer, PeopleCode, Application Engine, Component Interface, BI/XML publisher, Crystal Reports, nVision, SQR and Integration Broker
• Testing sessions with end users obtained user acceptance testing sign-off per SDLC requirements
• Proactively scanned daily Oracle Workload Repository Report for RAC tuned highest cost SQLs as data grew to eliminate system load.
• Designed, Documented, Produced embellished compact 1099 reports eliminated need for impact printer, forms, and associated costs.
• Designed, Documented, Implemented pay file PPD/CCD layouts, integrated delivered PeopleSoft Paycycle processing with Domestic/International Banks
• Project lead on Design, Document, and implement JPMC PCard XML Interface, including PO's, Invoices, and Payments.

Confidential

• Technical Lead Consultant FSCM Oracle 11g AP, PO, GL, KK, PC, Grants, ePro detailed PeopleSoft prototyping and testing various scenarios for the client. Assessment, development and integration with several custom build application including detailed functionality walk-through sessions. Fit/gap analysis, business process documentation, detailed prototyping, designing, development and testing of functionality, identification of various test scenarios, detailed project planning and user training.
• Provided end user support during production rollout for PeopleSoft FSCM phases including troubleshooting of issues, use of the application functionality, and training of functionality in support of job functions.
• Fit/Gap, Design, Customize, Document, Implement multi-currency processing in AP,PO,GL,KK,PC,ePro across several Business Units.
• Year End Budget Checking processing FS BP running 24 hours, after tuning has not exceed 1 hour, with 95 of runs under 1 minute.
• Automated process for developer to paste SQL, PL/SQL, or SQC code for one-time fixes directly on a PeopleSoft Page, workflow integrated for business analyst to initiate a job generating/processing a fully documented program meeting all SDLC requirements from 3rd party auditors eliminated need for DBA/Migration team to execute one time fixes directly, greatly speeding up time and reducing manpower.
• Fit/Gap, Design, Document, and Coded centralized PL/SQL functions to accommodate data integrations for custom legacy subsystems unable to call IB Combo Edit XML messages directly.
• Designed, Created validation and reports for Voucher Spreadsheet Upload eliminating Integration Broker malformed XML queue issues and need for technical resource to correct IB queue. Trained users on reports.

Confidential

• Lead Consultant FSCM Oracle 10g/11g AP, PO, GL, KK, PC, Grants for 7.5 to 9.0 Implementation. After functional and technical analysis upgrade ruled out.
• Lead AP/PO tech for Fit Gap, Test Scripting, Functional and Technical Documentation, and Development Testing. Coordinated and reported all enhancements to Project Lead on 9 month implementation.
• Designed, Documented, Tested, Implemented Data Mappings using Application Engine CI process to load initial vendors, chart fields, and oprid data utilizing on line edits.
• Trained Security Administrators on 9.0 Security Permissions Lists, Roles, User Profiles, Query Trees, Row Level and Dynamic Security configuration and programming. Assist security team to resolve Audits.
• Requirements, design, development and testing of conversions using Application Engine, SQR and Component Interfaces.
• Fit/Gap, documented, Engineered PO subsystem to interface with PeopleSoft real time via XML.
• Created 10g/11g PL/SQL application used by 3rd party custom platforms for Journal Requests integrating to PeopleSoft using XML calls to Integration Broker.
• Developed, Documented, Training for standardized middleware for AP EDI processing, created metadata pages eliminating IT coding customizations for each feed, developed Single Pay Interfaces, Purchase Order Vouchering interfaces and XML interfaces feeding directly to outside Vendors.
• Impact analysis, engineering and implementing single Business Unit/currency to Multi-Business Unit/Multi-Currency for all Financials modules, Post go-live.

Confidential PeopleSoft 7.5 Oracle 9i Production Support

• Tuned SQR 75 custom GL tree consolidations. Trained user on efficient PS Query writing techniques. Runtime from 5 hours to 10 minutes.
• Bug fixes, Production issues, supported PO, AP, GL data corruption issues, with backend SQL updates for both University and Hospital.
• Took part in Functional/Technical design, documenting, testing, and implementing reimbursement custom application responsible for system integrations, data feeds, reporting, and data extracts.

Confidential

• PeopleSoft integration specialist Oracle 9i/10g/DB2/SQL Server for company requiring Component Interfaces converted to COM files to be integrated into proprietary software.
• Built CI Com's, documented, tested, and troubleshot issues with proprietary software using CI's to load People Data phone, email, address, status, ethnicity, etc , Prospect, Applications, Test Scores, Relationships, Emergency Contacts, Service Indicators, Communications, Checklist, External Academic, and other institutional data into HR and Campus applications.
• Fig/Gap, Designed, Exposed needed elements, Documented how to call, update, and save data PeopleSoft Campus and HR data using CI technology.
• Provided production support, debugging, CI tester.

Confidential

• PeopleSoft 7.56 to 8.8 FSCM SQL Server 7/2000 PO, AP, Grants, GL, PC , HCM 8.8 NA Payroll, Core HR , CA Finance, SR, Admission, Financial Aid upgrade and go live support issues.
• Documented functional system changes and organized on-site PeopleSoft training.
• Using Change Assistance Applied Campus Financial Regulation patches.
• Designed, Documented, Developed modified version of Person Delete, historical data merged into one Emplid for HCM and Campus.
• Fit/Gap, document, design, implement, tested AE CI's to populate required data for upgrade.
• Technical lead for 3 FTE and 4 consultants, balanced tasks across team. Completed upgrade on-time.
• Documented, Designed, and Retrofit Pay cycle processing, System check, journal processing, PO reporting, AP matching process customizations.
• Prepared Functional and Technical Design Documents with HR Department to gather requirements for generating notifications when employee is hired, rehired and terminated.

Confidential

• Lead PeopleSoft FSCM 7.5 to 8.9 Oracle 8/9i upgrade AP, AM, AR, Billing, Contracts, Purchasing, GL
• Performed Fit/Gap for PeopleSoft Financials 7.56 to 8.9 upgrade.
• Requirements, Design, Development and Testing of reporting using SQR, Crystal Reports, and nVision.
• Requirements, fit/gap, Retrofitting, upgrade using Change Assistant, Application Designer and Data Mover
• Authored software development life cycle SDLC SOX compliant narrative utilized by developers.
• Reengineered highly customized month end billing process. Created audit reports, streamlined tedious steps, developed self service tools for staff, and implemented. front end validations. Eliminated IT involvement. Time reduced from 2-5 days to approximately 1-2 hours per month.
• Created training documentation for AR/GL/PO modules.
• Designed, Documented, Developed highly customized reports replacing Accounting Dept manual calculations, including write off balances.
• Requirements, Designed, and tested reports for custom PowerBuilder applications using PeopleSoft data.
• Tuned ARUPDATE and PAYMENT PREDICTOR processes reducing time 700 .
• Reconciled IT audits. Created SOX compliant PL/SQL security package for legacy PowerBuilder applications, implemented naming conventions, and source control software for business applications, document Emergency protocols for PeopleSoft.
• Support Unix and Citrix PeopleSoft environment on Oracle Cron Jobs, Unix and Python scripting, C ProC , FeatureBank, and Java.

Confidential

• PeopleSoft Application Developer Campus 7.5/8/8.8 SR, Admissions, Financial Aid, Student Finance support and upgrade role.
• Lead technical Upgrade Developer on both HRMS/Campus PeopleSoft 7.5 to 8.0 and 8 to 8.8.
• Team leader on Fit/Gap, Documenting, Applying patches and tax regulations for PeopleSoft and Retrofitting PeopleSoft internal and external objects with Application Designer, PeopleCode, Application Engine, Component Interface , Crystal Reports, nVision, SQR.
• Track record of on-time project delivery with excellent ability to assess user needs, establish project specifications, evaluate resources available, and implement the project plan successfully.
• Requirement, Design, Implement, Test, Document CI's to automate new hire, annual increase, Electronic Test Score data.
• Designed, Documented and Taught, advanced PeopleSoft QUERY 7/8 training material to University Staff.
• Designed, Documented and implemented a recursive Perl Interval Error Scanner. Directly after the Major Upgrade/Patch technical staff was notified every 15 minutes. Adding to positive reputation of our Technical staff as issues were known before reported.
• Designed, documented, developed bolt-on applications in PeopleSoft 7.5/8/8.8, including menus, pages, views, queries, and reports.
• Technical Lead, Designed, Documented, Implemented Real Time Web-Based class registration system for students, professors, and advisors using Oracle 9i IAS PL/SQL packages, procedures, functions, tables, views, reports, and component interfaces. Used Oracle packages: HTP, HTF, OWA, OWA COOKIE, OWA SEC, OWA IMAGE, OWA PATTERN, OWA UTIL, UTL SMPT, UTL ENCODE, UTL DBWS. Allowed all students to drop and add courses with one Web Server running to handle the overhead.
• Designed, Documented, Implemented Integrations in/out of PeopleSoft for subsystems, including Library, Public Safety, Bookstore, Alumni Systems, etc.
• Designed, Developed more than 150 unique PeopleSoft SQR, Office, and Crystal reports most notable are the fully automated Financial FTP/Decryption process, Wesleyan University Transcript both official and unofficial versions, Admission Prospect Data one page form, with nearly all Prospect utilized by Admission Deans.
• Designed, documented, and implemented Centralized Electronic Mail System, to be used by all PS programs and web pages, removing stress from the PeopleSoft and Web servers when sending email, by calling a PL/SQL routine that populated a queue with the email data and a Unix Cron job uniformly sent emails without impact on University mail servers.
• Enhanced 1098 Tax Reporting by creating a Custom PeopleSoft Financials process, that generates reports, government electronic files, and official documents for mailing, downsized 1098 documents to one page reduced mailing and printing costs over 80 .
• Created an innovative live Web alumni/prospect geographic interview application using Oracle 9i IAS PL/SQL. Manual task required 4 people 50 reduced to 1 person at 20 .
• Instituted PGP encryption and decryption libraries to be called from SQR, PeopleCode, and Perl interfaces.
• Presented at HEUG and NERCOMP conferences. Personalized Web Inquiry Using Student Search Service Files and Connecting Your Alumni Prospects .
• Designed and Coded Perl unified script used by Autosys Batch Scheduler to run all jobs.
• Created technique for query users to use stored Oracle database Functions to speed up query development and training. Implemented storing How to Use documentation directly in these Functions. Created Live Oracle Web page displaying only the documentation for each function.
• Responsible for PeopleSoft 8.8 functional testing, stress testing, and deploying any technical modifications, indexing, SQL tuning, or Optimization for new developments or existing PeopleSoft 8.8.
• Replaced the Purge process in PeopleSoft 8.14 with custom code using same vanilla PeopleSoft requirements, process purged large sets of people faster than 1 person via the delivered process.

Confidential

• Client Server OCI implementation main job responsibility was migrating Banking software from 100 mainframe banks to OpenSolutions client server software running on Oracle.
• Fit/gap, Design, Document, Develop General Ledger GL , Electronic Fund Transfers EFT stored procedures, application data, and reports.
• Designed and Developed Electronic Funds Transfers reconciliation report for comparing delivered NYCE, DELUXE, and ORCC ATM transaction ascii reports and OpenSolutions data to identify suspect transactions for each of the 100 banks. By dynamically and intelligently scanning/extracting data from multiple text files with changing formatting. The Report reduced time necessary for functional staff to be on-site by weeks. Recognized by upper management for reduction in company costs and improved customer relations.
• Created and Documented test cases and performed Unit and System Testing, analyzed and checked referential integrity constraints, data integrity, statistics gathering, and troubleshooting.
• Utilized SQL Loader conversion scripts. Mapped data, created stored procedures to populate Application tables. Validated.
• Major upgrade experience for Oracle Client/Server Banking system, identified, tested, and maintained customizations in SQR programs, PL/SQL scripts, database packages, procedures, functions, triggers, tables, indexes and other database objects.