Ari Gaffen Email & Phone Number

San Diego, California, United States

Division: Clean Transportation• Maintained data integrity by combing through the data and holding meetings to fix issues when found• Created new views in the database to organize the data in a way that maximizes the value to the management team• Developed Power BI dashboards to support the staff’s daily tasks as well as show KPIs to upper management• Optimized data for regulatory reporting needs

Greater San Diego Area

Division: Envision Project• Redesigned business processes for the new ($250 MM) CIS implementation.• Supported Reporting & Analytics team by taking requirements and building multiple reports in Power BI using standardized templates• Tracked KPIs and supported team members by figuring out solutions using advanced query techniques (T-SQL, DB2)• Created and maintain analytics using Power BI on HANA models• Led trainings for Power BI and the new HANA EE data model• Worked with XSA developers to make changes to data models based on customer requirements

Greater San Diego Area

Senior Business Analyst - IIJuly 2016 - October 2018Business Systems Analyst - IIDecember 2015 - July 2016Department: Customer Operations Analytics and TechnologyIn addition to previous responsibilities:• Enhance efficiencies through improved technology - Noticed the current technology was a bottleneck for developing and implementing solutions. Held meetings with IT in order to brainstorm solutions and keep costs down. Led meetings for the future configuration of Customer Operations servers with key players.• Teach best practices for VBA and T-SQL - Develop my fellow analysts into more well-rounded members who can deliver larger impacts through more advanced solutions.• Improve processes by mapping them out, deciding which technology can help in each piece of the process, and then developing solutions which manage the current needs.• Support team members with reporting by using advanced query techniques (BI – SSIS/SSMS, DB2)• Advanced analysis using SQL Server Integration Services, SQL Server Management Studio, Excel, R, and R-studio.

Greater San Diego Area

Department: Billing Operations SupportBusiness Systems Analyst - IIJune 2015 - December 2015Business Systems Analyst - INovember 2012 - June 2015In addition to the previous responsibilities:• Transition from semi-automated solutions to fully automated system solutions using SQL Server Integration Services• Help others help themselves by teaching VBA and other languages/techniques to other analysts (Knowledge sharing)• Reconstruct and redefine Billing KPIs for 2014 using more accurate data sources and metrics to improve departmental insights• Active member of Sempra A.C.E (Analytics Center of Excellence) for Data Mining, Smart Meter Data Analytics, and Emergency Responders (EOC)Associate Business Systems AnalystMay 2011 - November 2012• Learn, document, analyze, and optimize processes from departments all around the company • Develop macros in Visual Basic to interface with the billing mainframe in order to implement the optimized processes• Create billing tools in Excel using VBA in order to fix problems with customer accounts faster• Run ad hoc reports using T-SQL in Microsoft SQL Server Management Studio and IBM DB2

Greater San Diego Area

Business Analyst in the Department of Customer Programs• Documented and presented Monthly Expenditure Reporting process using Visio, Word, and PowerPoint• Created workflows summarizing the Expenditure Reporting process• Implemented more efficient reporting process by replacing old macros using Excel VBA Programming• Developed additional Excel macros to save one person approximately 24 hours per month

Greater San Diego Area

• Tracked estimates vs. actual hours spent on the Dynamic Pricing Project using advanced Excel techniques • Organized and held meetings with team leads to obtain monthly estimates• Created vendor scoring evaluation spreadsheets and PowerPoint training presentations

United States

Ensure that a company is run in the most efficient way possible, thereby maximizing profits and customer satisfaction. Make strategic company decisions by reviewing and assessing the company's quality and efficiency.

San Diego, California, United States

Fowler College of BusinessMarketing DepartmentCurrently Teaching: MKTG 381 - Business Tools for Data Analysis and Visualization

Greater San Diego Area

• Break down complicated concepts in calculus and physics into easy to grasp ideas for students• Prepare students for math and science portions of the SAT and ACT• Build relationships with clientele and grow reputation throughout the San Diego area

Greater San Diego Area

• Supported the efforts of both the clinical development and business development functions• Built databases using excel after reviewing detailed individual patient results from a large clinical trial • Reviewed the competitive landscape in the field of topical analgesics

Overland Park, Kansas

• Demonstrated and sold food products at Costco• Spent work breaks selling computers in the electronics section

Ba, Mathematics And Economics

Activities and Societies: Alpha Epsilon Pi, Intramural Soccer, Veterans Administration Hospital volunteer

Master Of Arts (M.A.), Economics, 3.6

A program with a split focus between microeconomics and econometrics. Part time graduate student while working full time at SDG&E.