Abhijit Bhattacharya Email & Phone Number

San Mateo, CA, US

Wilmington, Delaware, US

* Mentoring engineers to data engineering career path

San Francisco, California, US

* Leading the migration of Mural's main data warehouse from Redshift to Databricks* Spearhead the data modeling effort to design core entities & metrics, ensuring single source being delivered to stakeholders* Use of DBT to increase developer productivity and improving the underlying data models* Up level the team to follow best practices in data pipeline.

San Francisco, California, US

* Addressed scalability, performance issues for data pipelines handling multiple of billions of records per day specially the ones with workspace and messages* Improving the core model to cater to time invariant reporting at scale and provide single source of truth to stakeholders* Leading initiatives in data quality, operational excellence and improving.

San Francisco, California, US

Slack data warehouse consists of hundreds of data pipelines bringing data from multitude of disparate sources like mySQL, Salesforce, Workday Financials, flat files, AWS s3 to name a few. These pipelines have complex dependencies on each other.My work involves interacting with business users, data scientists to understand and cater to their data.

Sydney, NSW, AU

I initiated the project to transition from legacy Pentaho/Kettle based ETL orchestration tool to Apache Airflow. That reduced the operational cost of supporting multiple orchestration framework and streamline data landing time of business critical metrics.Tools & Languages:AWS, Airflow, Python, Presto, Hive & Athena

Sunnyvale, CA, US

In the early days LinkedIn's main data warehouse was using Teradata appliance. I played lead role in moving out data transformation logic from Teradata to Hadoop based ecosystem, integrated Hadoop into traditional ETL landscape at LinkedIn. While working with workflows running across disparate platforms, I pioneered a metadata collection project to enable.

Jersey City, NJ, US

• I was instrumental in starting BI initiative in the company. As data architect of DW team my responsibilities were forming the team, running proof of concepts with ETL & reporting tool vendors, manage the data model in.
• Running proof of concepts to select appropriate ETL & reporting tool
• focal point for understanding data from the corporate perspective and representing the data so it can be understood uniformly throughout the company.
• Data modeling and physical design of database
• Scripting SQL/Shell/Perl to help in data analysis
• Delivering analytical solutions using Tableau & MicroStrategy

San Mateo, California, US

• Reporting directly to VP Business Intelligence, I started BI and data analytics initiative in the company. I led efforts to set up platform infrastructure for CRM solution, catalog analysis to provide insight to Nextag.
• Designed data model to store user level data in the main Oracle data warehouse. The main DW was storing 14 months of data allowing granular analysis of user behavior.
• Designed and developed ETL process to consolidate data from operational systems and product catalog to provide accurate actual revenue as well as projection for coming months.

Sunnyvale, CA, US

• Designed the database architecture of web analytical solution to unlock the richness of Yahoo’s sponsored search and display advertising business. The application became a cornerstone for account managers to understand.
• Responsible for dimensional modeling, star schema design to integrate search & display data in one unified platform
• Implemented fine grain access control (FGAC) mechanism to enforce application security and guard sensitive data
• Innovated implementation of views which can morph based upon input data selection of end users. Lead the effort to define centralize business logic, complex metric calculation in database APIs which are exposed to.
• Defined unit testing methodology for database centric ETL processes, reporting APIs and automated continuous integration effort. Tools and utilities designed to unload subset of data, automating setup and execution of.

Redwood City, CA, US

San Francisco, CA, US

Palo Alto, CA, US

Bentonville, Arkansas, US

Mcse, Computer Science

Nanodegree, Data Structures & Algorithms

Nanodegree, Data Analyst

Bcse, Computer Science & Engineering