Business Analyst and Project Analyst
Southern California Edison
IT Operations, Change & Analytics Management
Project Analyst 3 (Feb 2011 to present) * Develop collaborative partnerships with clients to understand challenges, resulting in process improvements including:* Successful SLI Orders 5% improvement due to the creation of task worker reports.* Successful 50% decrease in average monthly repair time due to SAP training and creating how-to SAP procedure, making data transfer easier, and creation of a daily dashboard to monitor progress and identify issues.* Analyze vendor and internal service benchmarks through dashboards for issues and suggest process improvements or enhancements. Recent examples include:* Verizon dashboard enhancement that shows if SAP asset data is being updated timely. This will ensure the asset information is kept current. * Create a dashboard for Telecom tasks to better manage equipment upgrade with limited resources, routine maintenance and new employee requests.* Recommendation to reach out to Access Orders users with additional system training resulting in quicker processing time.* Compile data and produce adhoc reports. A recent report outcome is the “Good Neighbor” award from IT’s Senior Vice President for working with several organizations to gather and analyze the data to measure a TDBU training SLI. The monthly report was an important indicator if TDBU was successfully progressing toward their year-end goal -- which they did. * Produce and analyze monthly operational management charts including recommendations.
Business Analyst 3 (Sept 2007 to Feb 2011) CSBU Finance, Energy Efficiency Programs ($30M)* Produced monthly performance and variance reports for Self Generation, California Solar, CARE, Low Income and Residential Energy Efficiency programs using SAP BI. Provided monthly presentations on these program results which promoted a better understanding of the issues facing these programs. As a result, caught problems early.* Automated monthly program reports from SAP extracts. Also, automated budget templates from Excel for SAP upload. This saved a great deal and allowed me to meet the tight budget loading deadlines into SAP.* Troubleshooted finance related problems that the programs requested assistance problem solving and working with other departments for a resolution. When SCE went live with SAP, some CARE vendor payments were not made for a long time due to misunderstandings. I tracked down the correct team to work through the SAP requirements they needed to make the payments.* Performed month-end close accounting activities and provided variance analysis for management charts on the programs that I supported.* Produced monthly CPUC Self Generation, CSI program and NSHP reports using SAP extracts and look-up formulas -- saving many labor hours each month. The reports followed each contract’s requirements.* Created Energy Efficiency budgets for high-level managers and director.