- Temple City US-CA
www.app.box.com/files/0/f/0/1/f_9858928516<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Highly organized, directed, and detail-oriented; able to juggle multiple responsibilities and remain calm in a fast-paced environment.Successfully worked with other departments to gather, research and automate data related to critical projects using Excel, Access, PowerPoint, Oracle Discoverer, SQL, Graphic Analyzer and SAP (BI/Bex Analyzer).Key competencies include
* Financial Analysis * Dashboards * Forecasting * Budgeting * Presentations
* Project Management * Vendor Management * Problem Solving * Reporting * Expense Control
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.
North American Printer/Projector Sales ($1.3B)
* Created monthly unit and revenue sales data extracts and automated this data into sales reporting schedules – saving many labor hours each month.* Produced North American revenue projection highlighting business opportunities and challenges. This information has been used to decide if air freighting in inventory is necessary to meet changing demands resulting in the savings of thousands of dollars in freight. It also highlighted potential inventory issues.* Created sales presentations for the monthly Japanese parent company video conference calls covering challenges and issues that are impacting business. * Reviewed and analyzed current sales against plan, including how the competition is impacting business through new product launches, promotions and price reductions. * Updated the customer and channel profitability report that is used by senior management during contract negotiations (with customers like Best Buy). * Consolidated and reviewed the monthly US sales forecast. This required working closely with product and sales managers during the review process for new, maturing and end-of-life products and the associated seasonality, promotions and price changes. * Outlined a new and improved forecast system that was used by the Canadian and US sales organization.