SUMMARY:

• Big 4 experience, government at the city, state and federal levels, and telecommunications summarize over eight years of my experience with both functional and technical aspects of PeopleSoft. I have modified numerous existing modules as well as having designed and created several more, employing every aspect of the PeopleTools suite. My experience began with v7.5 and runs through in v9.0, having also worked on several in between. I have significant experience with fit - gap analysis, requirements and business process design, management of development and implementation schedules, and day-to-day team coordination.
• My functional expertise includes Accounts Receivable, Billing, Asset Management, General Ledger, Account Payable, Banking, Purchasing, Vendors, Customers, Configuration and Security. I emphasize the benefits of effective teamwork, having successfully implemented several projects from a position as project manager, team lead,cohort and understudy throughout my career.

TECHNICAL SKILLS:

Technology and Tools: PeopleSoft FinancialsDatabase ExperienceOther software Configuration, Security Application Engine, SQROracle 8.0, 9i, 10gCrystal Reports, Brio PeopleCodeMS SQL Server03, 05Citrix, VPN,Remote Desktop Component Interface:Query AnalyzerInformatica Upgrade Assistant:Web, Application ServerPostalSoft, Nova Net / ViaWarp Queries, WorkflowGolden, ToadMany issue tracking tools

PROFESSIONAL EXPERIENCE:

Confidential

Functional Lead Consultant

Responsibilities:

• Functional Lead for Billing, Accounts Receivable and Asset Management.
• Requirements, Designs, Configuration, Data Conversion, Testing and Production Release.
• Conversion from Lawson Financials to PeopleSoft v9.0, Oracle 10g db.
• Four consultants, five modules, six months, end-to-end project from Requirements to Production.

Confidential

Director of IT Applications

Responsibilities:

• Oversight of technical applications and operations, coordinating and directing operational activities for this technology department - production support, help desk, servers, databases and everything in between.
• Maintain PeopleSoft Production systems while preparing for a v9.0 upgrade and Supply Chain Management merge.
• Manage day-to-day technical operations, backfilling an unexpectedly vacated position.
• Establish and maintain strong working relationships with business stakeholders and IT department colleagues.

Confidential

Receivables Lead Consultant - v8.9, Accounts Receivable

Responsibilities:

• Configuration, system testing, process design and documentation for the Accounts Receivable Optimization Project.
• Project focused on populating the AR Payment table structure with revenue collected at many external locations.
• External databases converted into text files using MS Access. Custom App Engine upload process populates Deposit Control, Payment and Pay Misc Dst tables, optionally creating accounting entries and marking as complete.
• MS Access previously stored detailed revenue transaction data; manual journal entry was the initial recording of revenue.
• Fit-Gap Analysis, Requirements, Detail Designs, Test Scripts, Users Guide and Configuration Workbook.
• Direct interaction with numerous department heads, including the Budget Agency, Director of DNR, DNR Budget Dept, and internal developers for the State.

Confidential

Receivables Lead Consultant - v8.8, Accounts Receivable

Responsibilities:

• Configuration, system testing, process design and documentation for credit card and ACH revenue processing.
• Provide recurring credit card and ACH payment options for all customers of Confidential .
• Complete project life cycle: fit-gap analysis, recommendation to management, requirements, detail designs, oversight of internal developers, coordination across several interdepartmental system users, system configuration for direct debit processing, functional demonstrations, communications with bank transaction processors, and product implementation.
• Deliverables consisted of documentation for Fit-Gap Analysis, Requirements, Detail Designs, Test Scripts, Users Guide, and Technical Specifications including diagrams, code and system configuration.
• Oversight of SQR, Application Engines, PeopleCode used by developers. Direct use of banking software for Confidential ACH processing and US Bank credit card processing (NovaNet / ViaWarp).
• Managed project coordination and status with Technical, Treasury, AR and Billing users, system developers, and banks.

Confidential

IT Project Manager

Responsibilities:

• Initiated the process and procedures for design, development and implementation of the information infrastructure for this twenty-million/yr project over the course of a year.
• Configured Accounts Receivable and Billing modules for the new business unit, auto-numbering items and invoice type.
• Coordinated activities through delegated members of the project team including Budget, Finance, HR, Facilities, Mail Services, County Tax Assessor, Stormwater and AMEC engineering consultants.
• Researched several postal integration software packages and negotiated purchase of final selection for use in streamlining our invoice delivery system through the USPS - estimated savings of at least sixty thousand dollars annually.
• Politically negotiated terms of access to El Paso County database, providing a method to update both data sources accurately and efficiently while minimizing redundancy of errant file transfers.
• Physically set up the Customer Service employee area when interdepartmental coordination broke down unexpectedly in the eleventh hour and the job had to get done.
• Functional liaison for users, maintaining direct contact with module user leads regarding concerns from aesthetics and configuration to fixing delivered system bugs and process customizations.
• Accounts Receivable / Billing
• System configuration and setup for Billing module, defining bill types, sources and cycles as well as manipulating the delivered invoice format to accommodate internal requirements.
• Accounts Payable / Purchasing
• Setup ACH processing with bank and provide user, having previously used only checks. Provide technical assistance and process-mentoring annually for 1099 processing, obtaining federal updates from the IRS, process updates from PeopleSoft, and ensuring timelines are met. PO Reconciliation process modified to account for variations from delivered matching functionality. Annual rollover processing of encumbrances performed closely with system users, providing reports and data verification as well as testing environment preparation and refresh when requested.
• Reconciliation with Receivables and Payables modules, ensuring query and report results incorporating various table structures are legitimate and logically synchronized. SQL or process adjustments implemented as required. Daily communication with system users, addressing concerns and researching process modifications. Modest Commitment Control exposure, typically reviewing KK Detail and KK Activity record data when the system indicated inconsistencies with GL.
• Built custom pages and tables for tracking Customer Service metrics and workflow interaction with Finance. Data processing through third party postal verification software; verifying, appending and correcting billing information which is then passed back to PeopleSoft prior to mailing invoices. Developed IT business rules and user manuals for Customer Service, Finance and IT.

Confidential

Systems Analyst - v7.5, v8.4, Department of Interior, MMS

Responsibilities:

• Involved with requirements, data design, application development, data conversion, implementation and maintenance.
• Extensive use of PeopleTools. Highly customized system with ample opportunity to develop pages, components, PeopleCode, SQRs and Application Engines.
• Informatica used for large-scale mapping of legacy mainframe data into Oracle, as well as daily conversion of smaller data segments gathered outside, but not initially converted to PeopleSoft.
• Brio used to create several custom reports and queries for remote access by system users across the country.
• Independently designed, developed and implemented over a dozen processes serving as the foundation for Exception Processing and Workflow across Billing, AR, AP and GL.
• Monthly, quarterly and annual General Ledger reconciliation of AR and AP sub-ledgers.