Ayan Chakraborty Email & Phone Number

Dubai, United Arab Emirates

Berlin, Germany

Have architected a data warehouse(Data Mesh) from scratch from S3 as adata 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 than15TBs 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 teamand designing agile process.

United Arab Emirates

- 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 from scratch to accommodate existing features and accommodate changes for the new features with 10TB 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 CXOs in Tableau, also reaching out to 450 school leaders who are making an impact on 150K student's life in a data-driven way.- Awarded as “Employee of the month” for the reporting framework and least response time Educating the whole organization by choosing team-wise volunteer to build a “Data-Driven Company”

Abu Dhabi, United Arab Emirates

- Design and architect data warehouse from scratch to accommodateexisting features and accommodate changes for new feature.- Creating automated reporting platform which have cut down 12K USD per year on licensing cost, the same platform will cut down 60% manual effortfor custom reports and manage multiple data source.- Doing A/B testing on the impact of new feature release.- Creating meaningful dashboard for 7 different team of stakeholdersincluding CXOs in Tableau.- Working with data pipeline team to build real time dashboard with Splunk.- Awarded as "Employee of the month" for the reporting framework andleast response time.- Educating the whole organization by choosing team wise volunteer to builta "Data Driven Company"

Malaysia

- Co-lead Marketing Data Mining projects and pushed data to datawarehouse in Redshift from multiple sources like Facebook, GoogleDoubleClick, Google AdWords and Datapoint.- Develop new data pipelines and workflows using Python and ApacheAirflow and Redshift which reduce cost by 15% on custom schedulers and also reduce cost of managing multiple platform by 60% and the whole SQL server maintenance cost.- Co-lead major analysis projects for blue chip companies such as COCA COLA, AMP International.

Bangalore, India

Software Service Provider- Lead 4 projects on Data Analytics domain where I had developed datamodel and Visualization in Qlik and Tableau.- Architected the Data Warehouse for Liaison International in Boston, MA,USA and made a growth of the team from 2 person to 6 for analysiseducation data for USA university applicants from all over the world.- Awarded as "Star Performer" for making new revenue impact by 12% ontwo project and client satisfaction.- Performance tuned SQL procedures for multiple clients such as "Deloitte", "Everest-Reinsurance".

Kolkata Area, India

- Design database schema and programming in TSQL Procedures andperformance 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.

Kolkata Area, India

- Develop DW projects regarding analysis sales and marketing data torestructure the cost and provide management a solid dash board 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.

Responsibilities• Involved in-depth analysis of the business requirements.• Design and implementation of critical business requirements for the interface design using Informatica.and Oracle Siebel• Unit testing of each of the routines and system testing of the whole process in various modes and types of scenarios.Achievements: • Awarded as best trainee of the Year, 2011• Grabbed the whole flow of a CRM system and how it helps business

Post Graduate Program, Data Science & Business Analytics

Business Statistics, Advanced Statistics, Machine Learning, Predictive Modelling, Tableau (Data Visualization), Time Series Forecasting.

B.Tech, Electronics And Communication

Activities and Societies: I was General Secretary of RCCIIT (2011 batch) student committee. I represented the college football team.

Secondary, Science