Shawn Saggu
APU Intern · City of Anaheim Public Utilities
CAIn My Own Words
Analytical and detail-oriented professional positioned to manage and complete projects to the highest standards. An effective communicator and liaison who quickly builds and nurtures excellent working relationships with co-workers, management and customers to meet organizational goals. Ambitious self-starter ready to embrace new challenges and eager to put my education, research skills and knowledge to practical use in Finance and Accounting.
Work Experience
APU Intern
City of Anaheim Public Utilities2019 – 2019
* Performed residential and commercial bill analysis for both water and electric for various agencies in California using Excel. * Built charts and graphs to compare results with City of Anaheim billing and to show variances. * Helped with SIFMA Basis+ Points versus Actual charges analysis of interest and utility companies using Excel. * Reviewed financial statements and created cash flow statements using Excel & made charts & graphs. * Researched different governmental cities and presented them to the managers. * Used Word to create documents on Water Utility Fund. * Used Pivot Tables, Insert Slicer functions and Conditional Formatting and created financial statements. * Built What-If-Analysis (Data Table, Scenario Manager, and Goal Seek).
Intern
Henderson Financial Group2016 – 2016
* Developed and maintained clients using Excel for mainly professional baseball players about determining their contracts, salary, service time, and contact information. * Worked with individuals on client information and contact sheets using Sales Force.
Accounting & Tax Intern
Gress Income Tax Service2014 – 2015
* Recorded financial transactions and performed bookkeeping for tax clients using QuickBooks and Lacerte to assist the manager of what taxes clients can legally deduct in preparation for tax season. * Reviewed financial documents, including bank and credit card statements to see any overdrawn charges that the company might have overstated or understated and make proper adjustments in order to help clients maintain a one-on-one relationship with their financial advisor.
Tax Intern
Windes Audit, Tax and Advisory2014 – 2014
* Recorded financial transactions using internal financial system known as ProSystem. * Reviewed and modified tax returns and performed tax research as requested by partners and helped them achieve both their financial goals and objectives towards clients by reducing their taxes wherever feasible.
Volunteer
Camp James2011 – 2011
Talk About Curing Autism (Summer 2012 & 2013) Volunteer * Assisted with special event planning, community outreach, promotional materials and marketing, so that the organization can bring in as many clients as possible for their events and maintain a long-term relationship. Camp James (Summer 2011) Sports Specialist/Volunteer * Coached and motivated children to understand teamwork, cooperation and sportsmanship. * Was named Camp James employee of the week for helping children understand the importance of leadership, teamwork, dedication, motivation and sportsmanship.
Education
Bachelor of Arts
California State University2015
Bachelor of Arts