Ayan Chakraborty Email and Phone Number
Experienced Data Warehouse Architect, BI, and Data Consultant | Driving Strategic Decision-Making through Data Insights | Top 3% Data Developers| 13+ Years of ExpertiseAs an accomplished Data Warehouse Architect, BI, and Data Consultant with over 13 years of experience, I possess a strong foundation in designing robust data solutions that empower organizations to make informed decisions. Proficient in SQL and Python programming languages, I excel at leveraging cloud warehousing technologies, including Snowflake, Redshift, BigQuery, and AWS and GCP data solutions.Equipped with a postgraduate degree in Data Science and Business Analytics, I am passionate about harnessing the power of data to drive impactful decisions. With a keen focus on strategy, I am actively involved in shaping growth strategies for new products and optimizing live operations, ensuring a data-driven approach and implementing best practices.Throughout my career, I have successfully led and managed teams of up to 9 data champions, employing Agile practices to align personal achievements with organizational goals. Serving as a key liaison between product managers, data science teams, data engineering teams, and end-users, I effectively facilitate communication and collaboration.Key Highlights:Proven expertise in designing and implementing robust data warehousing solutions 🔨Proficient in SQL and Python programming for data manipulation and analysis 🧑💻In-depth understanding of cloud warehousing technologies, including Snowflake, Redshift, and AWS data solutions 🌪️Expert in visualization tools like Tableau, Looker, Quicksight, and PowerBI 📈Postgraduate degree in Data Science and Business Analytics 🎓Dedicated to driving data-driven decision-making and strategic growth 📊Adept at leading and managing teams with a focus on Agile practices 💯Strong communication and collaboration skills 👍Let's connect to discuss how I can contribute to your organization's data-driven success.
Toptal
View- Website:
- toptal.com
- Employees:
- 3758
-
Data Development ArchitectToptal May 2021 - Present
-
Lead Data And Analytics PlatformMondia Group Oct 2022 - Mar 2023Dubai, United Arab Emirates -
Senior Data Warehouse ArchitectSolarisbank Ag Jun 2021 - Mar 2022Berlin, GermanyHave 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. -
Bi Development LeadAlef Education Sep 2019 - May 2021United 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” -
Bi DeveloperAlef Education Jul 2018 - May 2021Abu 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"
-
Senior Business Intelligence AnalystIpg Mediabrands Feb 2018 - Jun 2018Malaysia- 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. -
Senior Software Engineer(Data And Analytics)Nous Infosystems Aug 2016 - Feb 2018Bangalore, IndiaSoftware 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". -
Sr. Database Designer And ProgrammerAltima Technologies Feb 2016 - Jul 2016Kolkata 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. -
Development Team LeadAcronym Solutions Private Limited Aug 2014 - Jan 2016Kolkata 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. -
Crm ConsultantCognizant Technology Solutions Oct 2011 - Jul 2014Responsibilities• 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
Ayan Chakraborty Education Details
-
Data Science & Business Analytics -
Rcc Institute Of Information TechnologyElectronics And Communication -
Ramakrishna Mission VidyabhawanScience
Frequently Asked Questions about Ayan Chakraborty
What company does Ayan Chakraborty work for?
Ayan Chakraborty works for Toptal
What is Ayan Chakraborty's role at the current company?
Ayan Chakraborty's current role is Data Warehouse Architect | 14 Years of Expertise in BI and Data Consulting | Top 3% Data Developers | Driving Strategic Decision-Making through Data Insights.
What schools did Ayan Chakraborty attend?
Ayan Chakraborty attended The University Of Texas At Austin - Red Mccombs School Of Business, Rcc Institute Of Information Technology, Ramakrishna Mission Vidyabhawan.
Who are Ayan Chakraborty's colleagues?
Ayan Chakraborty's colleagues are Ph Nyarangø, Peter Weston, Ádám Czibere, Shahnawaz Khan, Anton Bondarenko, Samir Zubic, Shuaib Aminat.
Not the Ayan Chakraborty you were looking for?
-
1gmail.com -
Ayan Chakraborty
India -
Ayan Chakraborty
Telangana, India -
Ayan Chakraborty
Mumbai
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial