Versatile data expert with 15 years experience in Data Warehouse, Business Intelligence, Master Data Management and Data Integration solutions. Keenly interested in large scale data engineering and analytics that extract most intrinsic value out of data to build enduring products and services. Played diverse roles in data space spanning Data Engineering, Data Analytics, Data Architecture, Data Product Management, Business Intelligence and Data Modeling disciplines. Worked on Digital Marketing, Financial Services, Insurance and Healthcare domains' data across US, EU and Asia regions.

Senior Data Engineer - Data Science & Engineering @ From June 2015 to Present (7 months) San Francisco Bay AreaData Warehouse Analytics Lead @ From October 2013 to June 2015 (1 year 9 months) San Francisco Bay AreaSr. Data Architect and DW & BI Practice Lead @ Executing engineering assignments - Led data model, (DW) database, ETL and BI components’ design for Claims function of $4 billion insurance carrier - Tuned database, SQL, ETL performance for operational data integration system of Fortune 100 financial institution - Reviewed financial DW database, ETL, BI design and made performance tuning changes for online - services division of Fortune 100 technology company - Evaluated visualization tools for online services division of Fortune 100 technology company - Assessed ETL code, data model and made reusability, scalability recommendations (to integrate new data sources) for Clinical DW of large healthcare solutions provider - Reviewed design and recommended code changes leading to 95% automated patients’ data matching for MDM system of large healthcare providers group Establishing DW & BI Practice - Building and leading common DW & BI team across Insurance core systems (Billing, Policy, Claims) and Professional IT Services projects - Leading product requirements, prototype, solution design (BI, Data store, ETL) for operational reporting components of Insurance core systems - Led DW & BI framework definition with 350 reports, dashboards, KPIs and conceptual, relational, dimensional data models, data dictionary for Professional IT Services projects - Evaluated BI and Analytics technologies for integration with Insurance core systems and 3rd party tool vendors for developing joint solutions - Led DW & BI pre-sales, achieving 100% revenue target and 40% win ratio and preparing, presenting data strategies, solution designs to internal and external C level executives From March 2011 to September 2013 (2 years 7 months) Sr. DW, BI, Data Engineer & Architect @ Worked on Secondary Uses Services (SUS), the largest Healthcare DW with 65 TB of data, integrating 24 healthcare datasets. It provides DW & BI framework to measure and improve quality of care to 55 million registered patients of National Health Services (NHS). Technology stack includes Oracle RDBMS 9i/10g, OWB 9i/10g, SAP BO XI R2. - Designed DW solution with Files Reception, Staging, Warehouse, Marts, ETL and Audit layers - Led BI architecture with Metadata, User Access, Data Extracts and Diagnostic Audit layers - Prepared dimensional bus architecture, data model integrating 24 healthcare datasets - Tuned performance of ETL, SQL, Data Models and BI tool’s integration with database - Delivered MDM solution for 300 data entities and data quality solution for 250 validations - Designed, implemented 3 layered, metadata driven data privacy, masking, encryption solution - Implemented data migration for 19 billion rows, 4 TB data, achieving zero system downtime - Designed Oracle OWB 9i to 10g upgrade approach, achieving zero system downtime - Reviewed code written by 60 engineers for design, coding standards, performance compliance - Estimated projects totalling 30,000 man days efforts with resource profiles, risks quantification - Gathered reporting, analyses requirements on Clinical, Mental Health, Demographic datasets - Presented solution designs to NHS architecture, executive boards and secured sign-off From September 2005 to February 2011 (5 years 6 months) DW, Data Engineer @ Worked on Payments by Results (PbR) that measures & monitors financial flows worth £35B across NHS secondary care services. It aggregates clinical data from hospitals, calculates payments using national tariff regime and reports it. Technology stack includes Oracle RDBMS 9i/10g, OWB 9i, Cassius BI tool. - Designed DW, data marts, prepared data models using dimensional modeling techniques - Designed ETL framework including fine grain SQL audit, data reconciliation - Led team of 7 ETL and SQL engineers across UK and India - Prepared component design and technical program specifications Worked on NHS SPINE ERS that captures patient data access audit and performance of NHS Spine sub-systems. It collates 250 GB of Audit, Performance & Availability data daily and presents reports & dashboards in near real time. Technology stack includes Oracle RDBMS 9i, OWB 9i, SAP BO 6.x. - Designed, developed ETL framework, operational data store, data marts and BO integration - Implemented near real-time data processing with team of 4 ETL & SQL engineers - Exploited SQL analytics and windowing functions for complex metric calculations From October 2003 to August 2005 (1 year 11 months) Software, BI Engineer @ MIS provided operational reporting to minimize dependency and performance impact on CIEB OLTP. Technology stack included Oracle RDBMS 8i, Cognos Impromptu 6. - Developed 150 BI reports, operational data store, ETL routines - Performed project scheduling, tracking and customer coordination Developed modules for depot sales web application on Microsoft.NET (Beta 1), SQL Server 2000. Developed product administration module for auto insurance web application on Java, Oracle 8i. From August 2000 to September 2003 (3 years 2 months) Mumbai Area, India

MBA (MMS), Information Systems Management @ MBA - JBIMS University of Mumbai From 1998 to 2000 Bachelor of Commerce (B.Com.), Accounting and Finance @ University of Mumbai From 1995 to 1998 Kanak Chavda is skilled in: Solution Architecture, Business Intelligence, Data Warehousing, Requirements Analysis, Business Analysis, SOA, Pre-sales, Data Quality, ETL, Master Data Management, Oracle, Data Integration, Data Migration, Data Warehouse Architecture, Microsoft SQL Server