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• Rate Designs

• 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 assisting in the following areas:• 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 manual data manipulation and completions for each test iteration.

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 covered Project Management, Business Analysis and Business Process Redesign, Design Development/Review, Business and IT Meeting Facilitation, Test Lead, Issue Analysis/Resolution and Code Review. Projects included:Automated Metering (AMI) Project ••• CC&B v2.4 Upgrade ••• Cobol to Java Conversion Project ••• Mandatory Conservation Program ••• Bi-Monthly to Monthly Billing Project ••• Rates Case Project ••• Fractional CCF Read/Billing Project ••• Mobile Field Work Implementation ••• SQL/Reports Development ••• Estimation Revisions Project ••• CC&B Configurations Analysis ••• Electric Utility Department Conversion ••• Developing XML Schematics for XAI ••• Implementation Pain Point Analysis and Resolution (Estimations, To Do Configurations, Installation Options, Frequency Configuration) ••• Production Support

• 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• Provide training on Agile testing methodology and understanding the Software Implementation Development Life Cycle.• Develop dynamic Rate Calculation Excel spreadsheets.• Develop SQL scripts to help with Data Mining and Database Preparation.• Post-implementation develop and implement Regression Test Plan.• Post-Production Support and Maintenance.

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.• Identified, researched, tracked, and closed defects.• Performed ad hoc and targeted testing to isolate defects.• Developed DB2 databases, data cubes, dashboards and Crystal reports.• Created SQL programs for testing and reporting to measure and analyze testing results.• Research escalated issues on released software and created detailed report on causes, effects, potential fixes and costs.

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.• Provided training on best practices in testing, Test Results Validations, general CorDaptixTM functionality, Understanding Meter Reads, Rates, etc.• Post-Implementation, supported the Production including To Do processes.• Post-Implementation regression testing development and implementation.

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.• Responsible for Bill Print Extract and Quality Assurance with 3rd party mailer, DocuCorp.• Responsible for maintaining Data Tables, emphasis in Rates and Meter Read Schedule.• Developed yearly Master Meter Read Schedule.• Provided post-implementation support and training.• Responsible for maintaining Legacy system prior to CIS PLUS® implementation.• Responsible for all areas of Y2K testing with regards to the Legacy system including facilitating meetings with subject matter experts, developing testing scripts, testing interfaces such as Mosaix, OMS and IVRU systems, and developing a Business Continuity Plan.• Developed and maintained procedural manuals for the Customer Service Department. Wrote Customer Service processes and procedures for several IPCo systems including CIS, Outage Management, IVR, and Metering. Coordinated publication and distribution of manuals, process implementation, and training.• Data Custodian for CIS system.• Maintained data tables.• Responsible for customer Contracts, Summary Billing and Level Pay programs.