Gauri Khare

• Collaborated with the Finance Team at the David Geffen School on financial projects, performing budget analysis, forecasting, and reporting; utilized data analytics tools to streamline reporting processes and improve decision-making efficiency
• Led the development of product plans, release planning, and research of emerging trends in data & reporting technologies as a key member of the DGSOM Dean's Office Team.
• Collaborated closely with academic affairs and technology communities to provide faculty information and products to leaders to support design, testing, delivery, monitoring, and refinement of products at DGSOM.
• Conducted customer research and collaborated with key stakeholders across organization to develop and communicate a distinct product vision.
• Guided product teams to deliver and sustain end-to-end customer experience, enabling a thriving community of learners.
• Worked together with organizational leadership to use insights and data to deliver services comprehensively and consistently across projects.
• Proficient with Entrada, Gryphon and Epic educational products.
• Proficient with financial and faculty systems such as UCPATH, OPUS, Interfolio and MD Staff.

• Demonstrated an advanced comprehension of the current landscape including GRC, security, application design, and public policy to prepare for CCPA/GDPR.
• Formulate and implement data epics/features/stories/acceptance & strategies for new cloud- based (snowflake) enterprise data marts; direct data governance and privacy initiatives focused on supporting business, legal, regulatory, and operational objectives; analyze and identify potential risks to ensure business, processes, data, and support for compliance and risk policies.
• Assist Data Modeling teams with Feature Analysis ensure their proper application in Predictive models build for risk analysis/underwriting and investigative reporting.
• Direct a cross-functional team tasked with business and technical requirements by creating epics/features/stories/acceptance for Met Life (recent farmers acquisition) data integration.

Noted Accomplishments:

• Implemented data classification, dictionary tool and privacy practices for new Laws.
• Data Modeling & Feature Analysis for data modelling that saved 10 million in 2020 by writing better business for Farmers.
• Brought in 1 million new customers as part of Farmers Eastern Expansion.
• M&A Project to bring in Met life (3 Billion) data into Farmers.
• Product Owner for New Enterprise Data Marts build for cloud-based services.

Data Analyst for Personal Lines EDO organization, charged with ensuring BI Project implementation, data accuracy, completeness, and reporting for auto and home insurance projects. In support of the Personal Lines Data Warehouse Project, performed data mining, data modeling, statistical analysis, and BI gathering, trending, and benchmarking through epics/features/stories. Creating MVP and ensuring end to end implementation.

• Conceptualized source to target mapping and assisted as needed with ETL implementations.
• FDR (Farmers Data Repository) implement projects in FDR both policy and quotes systems.
• Help implement Projects in AOI/HOI (Auto outbound interface and Home outbound interface).
• BO and BI implementation for Signal program
• Development and data delivery for MVA Auto and Home.
• Analysis & Process update for Farmers Fast Quote system.

Product Analyst (Contract), Farmers Insurance, Los Angeles, CA (1/2015 to 7/2015)

Create ETL data mapping to find project trends and assist the business understand data capture and data analysis for the Personal Lines Enterprise BI Team (EDBI).

• Made significant contributions to this data warehouse project for personal lines of insurance; built a data warehouse for reporting auto/home insurance; and authored requirements and project kickoff documents.
• In conjunction with Development and the Project Manager, oversaw production releases, completed release planning, and managed production bugs and partnered with Production Support for corrections.
• Certified weekly, monthly, and annual financial reports and product performance.
• Conceptualized a client-based marketing solution that consistently met planning objectives.

Helped move data from an old on prem to a new cloud platform; oversaw the migration forklift. Through

epics/features/stories/acceptance criteria, Dashboarding for the process.

• Scrutinized project initiatives and conducted an impact analysis in support of the Data Migration Project; employed a comprehension of code and designed data flow diagrams, architecture documents, presentations, business glossary, user vetting, and analyses of the old system.
• Authored project plans and maintained schedule; wrote a test approach document; and helped create test cases.
• Tasked with validating production data and with performing reporting checks; managed production support issues; and developed solutions.
• Created a financial forecast and tracked performance.
• Helped senior managers and business owners better understand new functionality.

ETL/DW/BI role that compiled sales data from global movies and helped produce sales reporting per day/country and made it available to business users to provide reporting faster than IMDB Mojo.

• Data Reporting for Theatrical Group project was intended to generate theatrical reporting; employed Amazon cluster to produce/test tableau reports.
• Demonstrate proficiencies with multiple existing platforms such as Sparta.
• Used Rally to author user stories; attended Scrum meetings; partnered with Development Scrum Master.
• Directed QA releases and performed release planning; managed automation roadmaps; and built financial forecasts and tracked performance.

Product Owner Data, Walt Disney Company, Pasadena, CA (7/2014 to 1/2015)

Providing support to the RBI application; completed SQL tuning enhancements and bug fixes; automated an application to combine with ticketing systems for production failures.

• Demonstrated understanding of project designs and scheduling systems; built SSIS packages in support of incident management; oversaw releases; and deployed code to production.
• Resolved production support incidents and requests on SSIS/SQL Servers.
• Consistently delivered projects to schedule/cost; established data governance and risk roadmap.

Project Manager, The Walt Disney Co., Burbank, CA (12/2012 to 7/2014)

Completed two significant agile projects and 200 Jira’s for enhancements and bug fixes. The first project included a marketing project aimed at providing customers with promotional product data and to better understand customer behaviors and predict purchase patterns. The second project was a platform migration project to replace older databases.

• Used advanced multitasking to manage multiple projects concurrently; created project plans, specifications, and other project planning materials; gathered requirements; created test approaches, cases, and milestone reporting documents.
• Studied business/system/data mapping requirement specs and documented functional and supplementary requirements in Quality Center 9.2.
• Helped create fact and dimension table implementation in a Star Schema model based on requirements.
• Wrote complex SQL scripts to query Greenplum and Neoview; defined data requirements and elements for transactions; and analyzed/approved database modifications.
• Authored automation test suite for reusability and efficiency.
• Tested data reconciliation processes for multiple sources and target systems.
• Employed Informatica client tools to complete system analysis, designs, and development of OLAP application.