Built extensive dashboards aggregating millions of student records into summary metrics for use by educational practitionersUsed predictive modeling and machine learning methods including random forest and k-means to analyze topics such as factors impacting student success or state performanceCollaborated with individuals of varying backgrounds including stakeholders, project funders, and UI developersServed as data team lead on projects involving coordination of work between analyst team, project management, and external partners or clientsConsulted as subject matter expert on nuances of specific data setsSupported and led other team members as most senior analyst on teamProjects and AccomplishmentsServed as data team lead on dashboard summarizing Adult Education programsIndependently planned and built process for dynamically aggregating 100+ independent metric tables into format for use by UI developersTied together student and employment data to build dashboard showing employment and wage outcomes for Bay Area transfers and graduatesUsed k-means clustering to analyze young adult lives by state, used results as predictor variable to regression models attempting to predict using K-12 education

Completed analysis on all segments of the business to drive efficiency and profitabilityQueried large amounts of complex and messy data using SQL and delivered cleaned and summarizedTied together data from disparate sourcesOwned companywide reporting - created new and improved upon existing reportingTurned complex business processes and calculations into automated queries and reportsModeled future sales patterns based on historical dataTurned results of analysis and models into actionable and measurable dataPlayed key role in implementation of ERP and Business Intelligence systemsServed as data and analysis subject matter expertManaged and mentored interns in development of analysis and technical skills

Targeted one-to-one marketing campaigns using customer segmentation and transaction dataAnalyzed results and measured uplift of campaignsCompleted analyses to better understand customer behavior and improve future marketing tacticsPrepared insights for presentation out to business as a wholeProvided data driven guidance on development of plans for campaign strategy and executionServed as subject matter expert on customer data and campaign measurementPerformed ad hoc analyses in response to requests from a variety of different internal departmentsConverted inefficient SQL queries to SAS code

Completed advanced analyses on a wide range of Verisk productsCreated advanced SQL queries and functions to carry out recurring tasks and analysesTook lead on identifying need and implementation of process and program improvementsDiagnosed and ensured correction of issues in recurring processesOversaw data acquisition for department including supervising summer internsTrained and mentored other analysts

Ran, troubleshot, and evaluated results of predictive analytics models with monthly client dataProduced ad hoc analyses as requested by clients as well as other departmentsCreated SQL queries and functions to carry out recurring tasks and analysesResearched, tested, and evaluated potential new data sourcesLoaded data received from vendors and performed quality assurance checksOrganized and coordinated with other departments for development and implementation of new clients and programsTested internally developed web tools for data accuracy and functionality

Collected, setup, and maintained customer data, organization, and formatting in GreenTraks Energy ManagerInterfaced with customers to understand individual energy tracking needsResearched energy efficiency products and projects for potential customer implementationPerformed analysis of customer data including evaluating energy saving project efficacy, energy saving project ROI calculations, and energy usage trendsAudited customer data for billing errors. Created energy usage reports based on customer needs and requestsProvided customer training and support for GreenTraks Energy Manager

Transported passengers throughout the city of Davis while providing excellent customer serviceCompleted bus safety inspections at check-out and turn-inHeld a Class B license

Lead generation and market research on potential clients for internet presence managementResearched and analyzed company funding, hiring, growth potential and key decision makers; evaluated current internet presence including website design, social networking adoption, traffic rank, and user demographic profilePrepared slides for presentations with potential clientsCreated and maintained databases containing information gathered from research