SUMMARY

• Deep knowledge of Oracle database development PL/SQL/Packages/Procedures/Functions/Types/Cursors ref inline /Data Warehousing and the CC B data model ci person, ci acct, ci sa, ci sa sp, ci sp, ci meter, ci meter read, ci ft, ci ft gl, ci bseg type cd, rates ci rs, ci rc, etc , interface DL and UL staging tables, etc, etc. - including the business information contained within.
• Successfully combine business, functional, and technical knowledge over 18 years of enterprise software
• implementations involving city/country governments, utility electric, water, wastewater, sanitation, and gas
• companies, healthcare, and internet marketing businesses.
• Successfully implemented full life cycle Oracle CC B system as an interface team lead via comprehensive
• design of middleware infrastructure using BPEL/SOA/JDeveloper/PL/SQL, creation of interface and application spec documents, development of customer interfaces and applications, and post go-live support. This includes taking on added responsibility of some custom report development billing reconciliations and data cleanup conversions that other resources where unable to complete.
• Build rapport among a diverse group of executives, managers, employees, project managers, team leads, business analysts, testers, and developers while insuring that the business objectives are reflected accurately in all documentation and development related to CC B.

WORK OBJECTIVE

To deliver software design, development, implementation support services accurately, punctually, and profitably.

Work Experience

Project Manager

Confidential

• People/Service: CI PERSON, CI ACCT, CI CUST DIVISION, CI SA
• Billing: SA TYPE CD, CI SA RCHG, BSEG TYPE CD billing and ft creation , ADJ TYPE CODES, CI BILL, CI BSEG, CI BSEG CALC, CI BSEG CALC LN, etc.
• Financial: CI FT, CI FT GL gl division, dst id, etc
• Payments: CI PAY, CI PAY SEG,CI PAY EVENT, CI PAY SEG TYPES
• Custom built this full scale billing system in the cloud to enable dentist offices to set up patients on financing agreements/payment plans, bill monthly principal/interest run credit reports, and process electronic payments.
• The system automatically configures primary codes for each tenant e.g. Adjustment type codes, etc , bills principal and interest, feeds general ledger accounts, creates automatic payment schedules, credit card API, generates NACHA payment files, and collects payment /remits payments. Also cancels bills re-bills and cancels payments.
• Includes rate setup, person/account/service agreement creation, monthly billing, payment transactions, adjustments, and dynamic program calls based on bill segment type codes and pay segment type codes, and flexible billing capabilities available for demo/showcase as well.

Confidential

Contractual responsibilities include:

• Efficient use of PL/SQL to resolve incorrectly converted data. e.g packages, procedure, conversion scripts
• Designed/Developed 2 Custom MWM/Wireless Field Activity Applications integrated with CC B. We replaced our first with a perfected second. This is a real time field order system that begins with a post CCB dispatch extract that populates outbound field activity staging tables. Software developed in javascript, Google Gears, and SQLite database.
• Understanding of CC B business processes configuration and technical processes tables/interfaces/reports
• Designed/Documented, Developed, Support Interfaces Credit/Collections, VA Debt Setoff, Payments, Meter Reads, Letters, Bills, IVR, GL, FTP.
• 10 years utility billing/functional architect prior to becoming technical architect
• Design/Spec Servers and Server Architecture
• Establish Version Control and Development Tools
• Oracle Fusion, JDeveloper, SOA Implementation of 50 critical enterprise class interfaces.
• Managed a team of 8 developers while managing client at the same time.
• Design and management of custom EDI application that edits, validates, and loads entire CCB account.
• Provided core leadership in daily logistics of software implementation having 5 implementations in 1.
• Managed the integration of Norfolk Newport News Waterworks concurrent billing projects.
• Directly developed the data conversion of James City County Newport News Waterworks
• Designed, Developed, Support Interfaces - Payments, Meter Reads, Letters, Bills, IVR, GL, FTP.
• Designed end to end Electronic Revenue Assurance automated File Workflow System
• Implemented SOA with Oracle BPEL software/web services as backbone
• Designed Developed web based error handling, EDI file handling, SQL reporting system
• Managed bill design/development, printer procurement, bill document archiving. Group1 Software.
• Website design development including web payments, Bank of America EDI
• Designed Developed Water Consumption Modeling - Data Warehousing Application
• Designed Developed Cost Accounting Application Interface to Oracle CC B
• XML, WSDL, SOA, AIA, JAVA, XAI, Oracle PL/SQL and web service based system.
• Skilled SQL, PLSQL, Oracle developer, technical and business leader
• Advised client on CC B Batch Control configuration
• Advised client on Interface Dependent CC B Configuration
• Provided direct conversion programming services when the Oracle team disbanded and HRSD needed o convert entire customer history and balances for James City County Service Authority who uses the system in their cloud. My knowledge of Pl/SQL, CC B business and data structure, and client business process enabled me to get this done for the client. This was a 6 to 7 week process after go-live where JCSA was not able to pr oduce bills. Needless to say the pressure was on and I delivered the data.

Confidential

Business Process Management/Testing Team Lead/SQL Development Manager: Peace Software Oracle based Utility Billing software project, requirements documentation, gap analysis, user acceptance testing management, business process documentation, data conversion consulting. Included design of multiple, third-party interfaces Diebold, Powertrack, Radix, Lawson, Utilisales, Docucorp , and data cleansing via SQL scripting project team training. January 2002 October 2003.

• Business process modeling and documentation for integration with Peace software.
• Included interactive with Peace Business Analysts, Technical Analysts, and Project Managers
• Utilization of customer care, periodic billing contracts, customer contacts, and bill design.
• Development of a rate matrix to manage configuration of tariff tables in Peace.
• Development and management of User Acceptance Testing Metrics

Confidential

Responsibilities included:

• Heavy travel to client sites for project management/training ensuring successful software implementations
• Analysis of current processes procedures unique to clients. SQL Development.
• Re-engineering of business process to fit client's unique needs and new software. Business Process Management
• Implementation of processes such as crew scheduling, preventive maintenance scheduling, meter reader route management, utility service order management, interdepartmental billing, activity based costing, inventory management/scheduling, project accounting, F.E.R.C. accounting, estimating, fixed asset valuations, depreciation