● Owned the data model in BigQuery and Looker, responsible for table management, optimizing data structures, and facilitating accessibility for teams.● Collaborated with all teams as the sole data analyst, supporting marketing and growth experiments, creating finance billing dashboards, and assisting risk/fraud analysis and agent performance tracking.● Improved data processing efficiency by implementing partition keys and transitioning from daily table recreation to incremental updates, reducing processing costs.● Spearheaded Looker adoption by creating key dashboards for various teams, hosting training sessions for new employees, and establishing an organized Looker home page with links to critical dashboards. Automated recurring reports for efficiency. Designed new dashboards for new product launches● Consolidated testing data into a unified dashboard accessible to all teams, providing accurate user activity insights during experiments.● Managed the process of transferring data from Postgres to BigQuery by modifying Kubernetes files and using proto transforms.● Authored documents outlining processes and rationales, enhancing knowledge sharing and documentation practices within the organization.

● Overhauled the KPI Goals & Tracking process for War Dragons by migrating monthly emailed Excel reports to a live Tableau dashboard visible to all. This eliminated data lag, which enabled War Dragons game team to iterate on features faster and exceed yearly forecast by 15%.● Consolidated 5 different prototype team’s one-off SQL queries and prototype-specific charts into a Tableau dashboard with standardized measurements for retention. Dashboard used by executives and game leads to compare prototypes, which led to ending work on low-performing games and moving engineers and game designers to higher-potential projects.● Designed a calendar/person-month tracking model in Excel for prototype stages to capture previously unmeasured metrics. Resulted in changes to process such as: making pitch submissions less cumbersome and team’s proactively reducing headcount in early stages.● Analyzed War Dragons’ seasonal retention to aid the game team in annual planning which resulted in new features being unveiled to stem decay.● Wrote/Optimized queries for various financial and product metrics to be used in the new Episode gross bookings model.● Enabled track leads to estimate financial performance and validate assumptions of prototypes by building a simplified gross bookings forecast model in google sheets usable without the need of strategic finance assistance.

● Redesigned War Dragons gross bookings model leading to a 65% decrease in file size while enabling multiple scenario forecasting. Ideated and implemented a new long-term forecasting method enabling 5+ years forecasting.● Worked in conjunction with marketing to develop an analytical framework for quickly measuring success of ads which led to differentiating styles exploration.● Led the Finance team’s successful transition from Amazon Redshift to Google BigQuery with no negative effect on team’s output. Personally updated business critical queries to ensure no data discrepancies in team’s reporting and analysis.● Provided game teams and marketing with dashboards related to “valid-users” for better informed decision making regarding health and future of our user bases.

• Assisted Fee Schedule team with work such as Fee Validation, Quarterly Reviews, and RX Pricing.• Oversaw investigation of certain claims and their handling for submission to CMS for Risk Adjustment.• Aided with the successful switch-over of data sources for California claims by analyzing various cuts of data and communicating with teams to ensure a smooth transition.• Other ad-hoc investigations into Transfer Pricing and the relation between Allowed and Billed Fees.

• Created new National and Regional Member-Level Profit-and-Loss Report pulling data from various sources and formatting results to enable views of various populations.• Worked with the Individual and Small Group Reporting team at a national level to provide data and analytics to regional actuaries to assist in yearly rate filing.• Updated pricing models and rating tools used by regional actuaries for rate filing.• Coordinated efforts across seven regions to standardize reporting for membership and claims.• Used SQL to pull and used Access to compile regional and national level data for profit-and-loss reports on a quarterly and year-end basis for upper management. Reports were used to analyze profitable regions and lines-of-business.• Used SAS to create monthly reports on Reinsurance recovery projections based on claims data at a regional and national level. • Investigated and compared claims in the Special Enrollment (SEP) and Ordinary Enrollment population to find the causes of higher costs for the SEP.

•Mentored high school students in college level proof based math. Co-led a math problem session.•Trained a group of four strangers of different levels of math skills to work as a functional team.•Assisted in running a six week camp with 60 participants with a team of counselors.

•Assisted a group trading commodity options and futures through COMEX as well as ETF options and futures through CBOE. (Specifically Gold, Silver, Natural Gas and the ETFs GLD and SLV.)•Operated the ORC trading software. Also was exposed to PrecISE and Microhedge.•Coordinated trades between screen traders at Consolidated and pit traders at COMEX.•Calculated markets for brokers and maintained the group’s position to plan for future trades.