Timothy Schrag Email & Phone Number

Meridian, ID, US

• Lead solution design and design reviews on Customer Experience Project for CC&B Enhancements.
• Assisted with testing requirements, logistics, and resource needs.
• Provided data mining, ad hoc reports, and data analysis.

• CC&B Functional Solution Architect on multiple CC&B projects including:
• Functional Lead on C2M Upgrade
• Missouri and Kansas Default Time of Use Rate Programs
• Rate Tool Application
• Securitization Bond Project
• Debt Transfer Project

• Redesign of APS moratorium process (Credit and Collections Module).
• Solution Design and Design Review.
• Production Support including bugs, change requests, and enhancements.
• Assist with Testing Requirements, logistics and resource needs.
• Provide data mining and ad hoc reports.
• Provide data analysis.

Los Angeles, CA, US

• Facilitate business process flow sessions covering 215 Primary Utility Business Processes with CC&B or MWM interactions.
• Develop UAT Testing Methodology and Test Plan
• Develop scripts to upload Test Case Development and Test Case Execution into IBM Rational to track testing and results
• Developed over 195 Test Suites that included 1,200 Test Cases

Vancouver, British Columbia, CA

• Customer Self Service Implementation Project(Electric, Water, Wastewater, Gas)
• Facilitate business process and Web Service design sessions covering main Utility Business Processes: Start/Stop Processes, Auto Pay (Auto Debit), Bill Presentment, Payments, Arrears, Account Maintenance.
• Design, configure and test Inbound Web Services using SoapUI.
• Project management and issue tracking and resolution.

• Solution Architect for an electric utility in Pittsburgh, PA. Responsibilities include:
• Facilitate To Be, Fit/Gap, and Analysis/Design workshops across a variety of CC&B subsystems and Oracle Utilities applications (CC&B, MDM, MWM).
• Provide oversight in the planning, design and delivery of configurations and customizations for CC&B and integrations with other products and solutions.
• Verify that solutions contain high flexibility to adjust to future business needs.
• Provide oversight of the solution implementations to validate alignment with design, and advise projects on technical challenges and issues.

Mclean, VA, US

• Assist Booz Allen Hamilton's Doha, Qatar office with a CIS/CRM Replacement Project. Responsibilities include acting as a Subject Matter Expert on all Utility CIS/CRM processes (both Functional and Technical) and.
• Facilitate Business Process Redesign Meetings ("As Is" and "To Be")
• Requirements Gathering and building the Requirements Matrix
• Development of the RFI and RFP
• Provide CIS functional and technical oversight during vendor demonstrations and reviews

Los Angeles, CA, US

• Assist User Acceptance Test (UAT) Team to implement UAT Best Practices and documentation.
• Provide UAT support and testing of code fixes and enhancements.
• Developed an automated process to complete Pending Field Activities in test environment from Production XML messages. This allowed for the mass completion of Field Activities to capture test results saving days in.

• Project Lead/Solution Architect on multiple IT/Business Projects over a six year period with the primary goal of streamlining implementations by utilizing CC&B Best Practices and base functionality. Responsibilities.
• CC&B v2.4 Upgrade
• Cobol to Java Conversion Project
• Mandatory Conservation Program
• Bi-Monthly to Monthly Billing Project
• Rates Case Project

• Led Business Process Redesign project to convert monthly manual data validation processes into automated processes saving almost 500 work hours annually.
• Conversion Cutover Task Lead. Led effort to identify, analyze, and develop Business Processes to manually fix conversion data issues that could not be resolved through the conversion process.
• Conversion Quality Control. This includes development and documentation of conversion processes and writing SQL scripts to validate converted data in CC&B tables.
• CC&B Test Lead responsibility over Parallel Billing testing including writing SQL queries for payment, metering, and billing financials to validate against current Legacy Production.
• SQL and Reports development for Business departments.
• Post Production Support.

Las Vegas, NV, US

• Functional and Technical Design Review
• Business Process and Design Reviews over Billing and Credit and Collection Modules
• Code and Defect Triage
• Test Lead following Agile testing principles.
• Develop and maintain dynamic and adaptable Access testing database.
• Provide training on CC&B functionality

US

• Responsible for QA of in-development Business Intelligence software applications.
• Train R&D Team on software applications and functionality.
• Collaborate with team members to ensure excellence in testing practices and processes.
• Created and presented training on software features from end-user perspectives.
• Assisted in developing enhancements and add-ons to base product with objective to meet unique customer needs.
• Designed detailed test plans for next generation business analytic software.

Oakland, California, US

• Supported implementation of SPL WorldGroup’s CorDaptix™ system (precursor to CC&B).
• Facilitated Business Process Analysis, Business Process Redesign, and Requirements workshops for projects that impacted customer communications and billing.
• Mass Refund business process development.
• EDI interface design.
• Test Lead responsibility over the Energy Statement interfaces and programs.
• Wrote over 1000 test scenarios into an in-house developed Access testing database that I helped develop.

Boise, Idaho, US

• Project Lead over all aspects of Billing, Bill Print, Meter Read, Contracts, and Systems Financial Balancing for SPL CIS PLUS® implementation (precursor to Oracle CC&B).
• Subject Matter Expert for JAD sessions in Billing, Rates, and Meter Reads.
• Redesigned bill format and Bill Print Extract file.
• Project Management: responsible for implementation of new Mosaix system, Outage Management System, Online Bill Payment and Presentation, Skills Based Routing, PC hardware and software upgrades, and IVRU.
• Train End Users on system functionality.
• Performed system analysis, testing, and defect documentation in Test Director.