Ayan Chakraborty

AYAN CHAKRABORTY Senior Data and Analytics Consultant(Data Vault, ETL/ ELT and BI) E -/- -q https://www.linkedin.com/in/ayanchakraborty-data/ SUMMARY CERTIFICATIONS A highly experienced Data Warehouse and Analytics Architect with a proven track record of 13 years in BI and Data Consulting. I possess strong technical skills in SQL and Python programming, specializing in cloud warehousing platforms like Snowflake, Redshift, AWS, and Azure. Furthermore, I hold certifications in GCP, AWS, and Snowflake, demonstrating my comprehensive knowledge and expertise in these leading cloud platforms. My postgraduate degree in Data Science and Business Analytics fuels my passion for leveraging data to drive informed decision-making. I'm an active speaker and play a key role in growth strategies for new products and live operations, implementing datadriven best practices. As a leader, I've overseen teams of up to 9 data champions, utilizing Agile practices to ensure alignment of individual goals with organizational objectives. I actively promote and champion data modeling and SQL optimization best practices to enhance overall data architecture efficiency and performance.  AWS Certified Solutions Architect - Associate  Snowpro Core Certified ACHIEVEMENTS  Creating an impact on 150000+ student's life EXPERIENCE  Consultant Data Architect Toptal Inc. 05/2021 - Present Remote Corporate Brand Analytics • Implement layer-based design using Azure, Databricks, and PySpark for automated data pipelines, with a focus on creating config-based PySpark Framework and Libraries on Databricks for data ETL through various storage layers. Additionally, emphasize automating data loads to Power BI to eliminate manual intervention for refreshing dashboards, and establish CI/CD pipeline and code management strategy in Azure DevOps. • Designed and Implemented Data Mesh End to End for Lotlinx.Inc and Pipeline with Google Data Flow, and BigQuery with Cloud function. • Managed Snowflake cluster as the new warehouse while supporting Redshift for both as old data warehouse and for expose data using rest API. • Cost optimization up to 41% in Snowflake cluster Team Lead Data and Analytics Mondia 10/2022 - 05/2023 Dubai Media and Digital Experience Company • Architecting the Data Vault with 8+ source databases with 2Million active customer base data • Agile data model deployment with best practices like PIT(Point in time Table), Bridges and SCD implementation inside Data Vault • Migration from old legacy Data Warehouse to new cloud implementation • Building pipeline with Airflow inside AWS and Spark with AWS Glue • Creating customer segmentation analysis, media usage and performance reporting in Tableau and Quick sight • Supporting 1200+ SAP reports for more than 80+ end users • Regular performance review, 1:1 with team and upskill the team to flourish within the organization • Implementing CI/CD process for the whole Data platform(Engineering, Warehousing and Analytics) Architected and Implemented E2E reporting platform from scratch for biggest ed-tech in UAE Part of the world's premier freelancing network Toptal which takes 3% people from all over the world. Architecting E2E data platforms for world renouned clients s Multiple award winning performance "Employee of the month" at Alef "Star Performer" at Nous "Best trainee of the Year" at Cognizant EDUCATION DATA SCIENCE & BUSINESS ANALYTICS(PGP-DSBA) The University of Texas at Austin - Red McCombs School of Business 01/2019 - 03/2020 B.tech in Electronics and Communication Engineering West Bengal University Of Technology GPA 7.87 / 10 07/2007 - 08/2011 SKILLS Data Warehousing Data Modeling Complex SQL Data Warehouse Optimization EXPERIENCE SKILLS Senior Data Warehouse Architect, BI and Data Consultant Languages Solaris Bank 07/2021 - 03/2022 Berlin Fintech company with a full banking license • Have architected a data warehouse(Data Mesh) from scratch from S3 as a data lake to Snowflake as a data warehouse. • Have handled data from multiple data platform for example Samsung Pay. • Have handle a design of data warehouse which is able to scale more than 15TBs of data. • Have mentored a team size more than 7+. • Was involved in recruiting, and data profile selection process. • Was involved in scrum process implementation for the first time in the team and designing agile process. Business Intelligence Development Lead Alef Education 06/2018 - 06/2021 Abu Dhabi Education Technology Startup • Founding member of the Data team and scaled the BI team to 7 people with a proven track record of managing and mentoring them to keep personal and organizational goals aligned. • Designed and architected data warehouse(Kimball Modelling and Data Vault) from scratch to accommodate existing features and accommodate changes for the new features with 10 TB of data size. • Initiated, developed, and managed an automated reporting platform that has cut down 12K USD per year on licensing cost, the same platform has cut down 60% manual effort for custom reports and ad hoc data requests. • Creating actionable dashboards for 9 different teams of stakeholders, including CXO in Tableau, also reaching out to 450+ school leaders who are making an impact on 150K+ student's life in a data-driven way. PL/SQL T-SQL Python Visualization Tools Tableau Qlik PowerBI DOMO Analytical Methods A/B Test Classification Predictive Modelling Statistical Analysis Workflow / ETL Airflow SSIS Talend Database and Technology Platform Redshift S3 Snowflake BigQuery Athena Sql Server AWS Glue Spectrum Azure DataBricks Senior Business Intelligence Analyst IPG Mediabrands SQL 02/2018 - 06/2018 Kuala lumpur Marketing and Branding Company • Co-lead Marketing Data Mining projects and pushed data to data warehouse in Redshift from multiple sources like Facebook, Google DoubleClick, Google AdWords and Data point. • Develop new data pipelines and workflows using Python and Apache Airflow and Redshift which reduce cost by 15% on custom schedulers and also reduce the cost of managing multiple platforms by 51% and the production SQL server cluster maintenance cost. • Co-lead major analysis projects for blue chip companies such as Coca-Cola, AMP International. AWS Lake Formation Azure Synapse MY TIME D A Senior Software Engineer(Data and Analytics) Nous Infosystems 08/2016 - 01/2018 Bangalore, Boston Software Service Provider • Lead 4 projects in the Data Analytics domain where I had developed data model and Visualization in Qlik and Tableau. • Architected the Data Warehouse for Liaison International in Boston, MA, USA, and scaled the team from 2 people to 6 for education data analysis for USA university applicants from all over the world. • Performance tuned SQL procedures for top clients such as "Deloitte", "Everest-Reinsurance". Sr. Database Designer and Programmer Altima Technologies 02/2016 - 07/2016 Kolkata Visual Data Center and Infrastructure Management • Design database schema and programming in TSQL Procedures and performance tuned up to 15% to 21% on response time. • Create dashboards with Tableau for CXO audience. • Implemented agile process to maintain teams from different geographic location. C B A Development and Technical stories B Architecture Design new project initiatives C Mentoring team members and taking decisions for tech and non-tech discussions D Communicating data-driven decisions to end-users and stakeholders. Coss-team project decision-building EXPERIENCE Development Team Lead Acronym Solutions 08/2014 - 01/2016 Kolkata Data Service Provider startup • Develop DW projects regarding analysis sales and marketing data to restructure the cost and provide management a dashboard to take better decisions for Khadim's India which reduces the cost of opening new showroom by 26%. • Worked with 2 data mining projects with 3 millions rows intake per day with SQL Server, Google cloud SQL. • Created new business opportunities with clients as Khadims India, Electrosteel private limited. CRM Consultant Cognizant Technology Solutions 10/2011 - 07/2014 Kolkata Software Service Provider (Fortune 500) • Design and implementation of critical business requirements for the interface design using Informatica and Oracle Siebel. • Awarded as "Best trainee of the Year" of 2011. CERTIFICATION Modelling data warehouse with Data Vault 2.0 Udemy - August, 2022 Hands On Course To Master Apache Airflow Udemy - June, 2019