Division of Federal Finance Intern/Student Assistant
Job Function:
- Data Analyst:
- Microsoft Excel Spreadsheets
- Microsoft PowerBI
- ADA-compliant document remdiaiton
Example of Projects:
- Designed and developed a Microsoft Power BI dashboard to streamline the analysis of CA counties’ financial situations in housing, resulting in a 35% reduction in data processing time and improving reporting accuracy by 20%
- Created a user-friendly survey using SurveyMonkey to improve HUD 4710 reporting, saving 20 hours of work and improving data collection
- Utilized VBA in Excel to identify CA counties that failed to report financials, significantly reducing reporting time
What did you learn and how does it relate to your major?:
From my experience at CA’s HCD, I learned how to communicate, problem-solve, and work as a team within a professional environment. I was also able to relate the skills of 110A to my job by using Excel and PowerBI to show how data could be utilized to improve a company. These skills are essential as the MIS foundation is technology and business combined.