May 2018 – Jul 2019 · 1 yr 2 mos · San Francisco Bay Area

• Responsible for Analytics across the company for Finance, Marketing, Product, Sales and Customer care teams. Strategic partner to Gusto Leadership in decision making and bringing insights to help make key business decisions.
• Built high performing data analytics team.
• Led the team to architect and build centralized data warehouse.
• Key partner for Gusto’s $200M series D funding with Finance and BizOps.
• Created self serve data culture by setting up Tableau for visualization and creating corporate dashboards to serve Finance, Marketing and Customer Support teams.

Apr 2013 – Apr 2018 · 5 yrs

• Responsible for online transaction processing databases, enterprise-wide data warehouse platform, big data platform, adoption of business intelligence and reporting tools.
• Responsible for overall data strategy and architecture for the enterprise data needs.
• Responsible for developing and communicate goals, strategies, project plans, timelines and key performance metrics for moving the Company toward its established vision.
• Manage multimillion-dollar budget and oversee teams delivering all data projects including migration to new data technologies for unstructured, streaming and high volume data
• Collaborate with core architecture team to align all applications database design keeping product analytics needs and impact to core company KPI’s.

Dec 2008 – Feb 2011 · 2 yrs 2 mos

• Esurance provides Auto insurance to customers. I am Working in the business Intelligence department to provide data and analytical solutions to the internal business units. Joined Esurance in 2005 as a a data analyst. Learned the complete system and played key role in multiple projects and in the growth of the company. Work and talent was recognized by company and was promoted to sr. data analyst, manager and sr. manager with in 5 years of span.
• Reponsible for managing a team of 20 people, setting up the team norms and making sure that team is high performing.
• Lead role in architecting policy, claims and Marketing data mart in Esurance data warehouse
• Co-ordinate multiple projects in the data warehouse catering to a variety of business groups (Finance, Service center, Actuarial, Insurance Operations and Marketing)
• Worked on Google and MSN Bid Automations and designed analytical cube to study the data downloaded data from AdServer (Double click)
• Designed and implemented integration with 3rd Party systems like COPART, NetCost, eLoyalty
• Designed corporate dashboards and Key Performance Indicators for Senior Management
• Architected the new reporting portal after evaluating multiple solutions with the following components - dashboard, KPIs, cubes, flat reports
• Worked with dev team to retire Legacy Billing system and lead a team for conversion of all policies to new billing system and all warehouse reports to source data from new system.

Jan 2007 – Dec 2008 · 1 yr 11 mos

• Set up the Data Quality team and defined 100 buisness and data related metrics which run everyday to find the anomalies in production data. Set up the process to clean the impacted policy and billing data.
• Developed Algorithms and ETL for company financials such as Earned and Written Premium, Retention, Reserve and Loss Ratio.
• Designed muliple cubes using SSAS 2005, star schema and implemented slowly changing dimensions.
• Database architect for the policy management source system (source system of 250 tables)

Mar 2005 – Dec 2006 · 1 yr 9 mos

• Responsible for developing reports for Policy, Marketing and Claims
• Worked on multiple adhoc requests to extract and analyze data for senior exceutives to make critical decisions.
• While analyzing data identified multiple issues with the production data and then worked with dev to redesign the database for policy management system.
• Wrote Projection algorithms for New and Renewal Premium, Churn Rate and subrogation recovery

Feb 2011 – Apr 2013 · 2 yrs 2 mos

• Set up the Tableau platform for visualization tool and built executive level dashboards.
• Involved in Architecting/Implementing business driven Data warehouse and Business Intelligent solutions for Glam Adapt Reporting platforms.
• Built annual revenue plans and monthly forecast models for media sales business; also developed Sales reporting to expose different metrics resulting in improvement of sales team.
• Designed and implemented first generation of advertiser campaign reports, linking ad server performance metrics with Sales Force CRM Data and Micorsoft Dynamics Data to provide Holistic view of major KPI's.
• Created ‘Operational Excellence’ report, providing executive management intelligence on profitability by product, consistency of product quality, and competitive benchmarking.

Sep 2004 – Mar 2005 · 6 mos

• Responisble for developing new modules, client side installation and fixing customer issues for AgencyInsight (AI); a complete solution for employee benefits brokers, insurance agencies and wholesale insurance brokers. AI is an end-to-end solution that improves the overall quality and efficiency of both front and back office operations. The system has powerful capabilities for marketing, policy management, premium accounting, claims tracking and client servicing. Environment: VB.Net, ASP.Net, ASP, VB6 COM, VBA, SQL Server 2000, Visual Source Safe,Crystal Reports 9.

Jan 2004 – Sep 2004 · 8 mos

• Worked as a software developer for a small team involved in the design and development of a integrated solution for the Education industry using .NET technology for both smart client application and web based application and SQL Server as backend database. Responsible for design of custom database and writing complex scripts for stored procedures, triggers, views in SQL Server.
• Environment: VB.Net, C#, ASP.Net, SQL Server 2000, Visual Source Safe

Jul 2000 – Nov 2000 · 4 mos

• Responsible for development of a Web based Store system (Art-in Store) for managing and operating a store on the Internet and supporting e-commerce activities. Involved in Designing three-tier architecture model for use in Internet environment, design of database and analysis of the requirements to come up with use cases. Designed and developed COM components to interact with the database and business rules.
• Environment: Visual Basic 6, ASP, SQL Server 7, Visual Source Safe, Active-X DLLs, MTS, IIS, Visual Modeler

Jan 1998 – Jun 2000 · 2 yrs 5 mos

• Involved in Customer requirement specifications, Database designing, Programming and testing.
• Involved in setting up the Replication between intercontinental servers for transferring data between CMS server & various oversees transcription centers.
• Developed a scheduler for transferring data between CMS & MiniCMS.
• Responsible for writing VBA application to create word templates & integrating it with VB application.