Meet regularly with users and key stakeholders to gather feedback and input on application functionality, enhancements, and defects. Manage the backlog, emphasizing on the product vision, and application maintenance and sustainability. • Reduced Crew Callout time by 18% through the streamlining and parallel execution of crew calls• Reduced overall CAIDI/SAIFI reliability minutes reported to the Oregon Public Utility Commission

Worked with the Transmission and Distribution business groups, and Maximo Mobile applications to troubleshoot, identify and resolve both business and system issues. Captured requirements for changes and system enhancement requests, or for implementation through system configuration. • Identified requirements for and created 60+ new operational reports, KPIs and Dashboards• Refactored code/reports to maximize system performance and tuning with SQL and PL/SQL• Created and enhanced the ‘Ready to Work’ process workflow that identified outstanding pre-requisites, and work that was, ready to schedule and dispatch.• Built the original Maximo data warehouse/lake ETL extract for work and Work and Scheduling

• Developed end user reports and dashboards using OBIEE• Supported/maintained Informatica ETL extracts into the data warehouse• Data standardization and transformation of enterprise data

Supported the CGI Work Management System, and 600 users to design, plan, schedule, and execute T&D work. This required regular upgrades, patches, and monitoring to ensure 98.7% uptime as well as High Availability as well as Disaster Recovery.• Supported 6 systems integrations ranging from GL, Receivables, Mobile Work dispatching, Work Design, Materials, and Customer systems using PL/SQL, SFTP automation, Appworx.• Built automations with PL/SQL and Unix/Linux scripting to monitor system errors, database size, and uptime• Built and supported various systems and apps, specifically the logical and physical table design for the Street Light Maintenance application project• Built the ServiceLink reporting logic and reports utilizing PL/SQL and dynamic SQL.

As an ETL and Reporting analyst, enhanced, and supported the Revenue and Consumption ETL, and Data Mart ensuring both daily and monthly extracts were completed successfully. This included troubleshooting, and resolving data discrepancies, and developing end user operational reports.• Addressed and improved system performance issues with the tuning of PL/SQL and ref cursors using, explain plan, query hints, and database system monitoring.• Automated sending of supplemental customer bill notifications using PL/SQL, and Crystal Reports• Gathered requirements for and built 120+ end user operational metrics and reports

As a Senior Programmer/Analyst, I built, supported and maintained customer specific marketing campaigns using Oracle Forms and Reports to capture operator and call recipient input • Developed a package to call phone numbers more efficiently and on time improving specific timed call metrics by 34%• Created a coding standard to improve readability and maintainability between developers• Developed a dynamic table view that would allow dynamic inclusion or exclusion of source tables

• Using PL/SQL, migrated user data from InterWorld to ATG• Was the Development DBA supporting the ATG and backend interface team developers

• Utilizing stored procedures and PL/SQL, developed an Oracle certified interface between Oracle Applications and the Tomax Retail.net application• Created an automated task-scheduling tool with GUI and PL/SQL API interfaces