Ayan Chakraborty
Summary
I am a highly accomplished Technical leader and a data enthusiast. I have hands on experience on working each life cycle of data engineering and analytics of last 8 years. I understand the priorities of the business, and how I can effectively contribute to achieving them.
Business Intelligence Development Lead
Alef Education
- Design and architect data warehouse from scratch to accommodate existing 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 effort for 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 stakeholders including 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 and least response time Educating the whole organization by choosing team wise volunteer to build a “Data Driven Company”
- Managing a team of 6 BI engineers and Data Analysts
Skills
Data Warehousing
Data Modeling Data Warehouse
Complex SQL Optimization
Languages
Python PL/SQL SQL R
BI Tools
Tableau Qlik PowerBI Yellowfin Splunk
Analytical Methods
A/B Test Classification Predictive Modelling Statistical Analysis
Workflow/ETL
Airflow SSIS Talend
DBs and Technologies
Redshift Sql Server S3 AWS Glue Athena Aws Spectrum MySQL Azure Datalake Oracle
Education
BUSINESS ANALYTICS & BUSINESS INTELLIGENCE (PGP-BABI) The University of Texas at Austin - Red McCombs School of Business
B.Tech, Electronics and Communication Engineering
Senior Business Intelligence Analyst
IPG Mediabrands
- Co-lead Marketing Data Mining projects and pushed data to data warehouse in Redshift from multiple sources like Facebook, Google
- DoubleClick, Google AdWords and Datapoint.
- Develop new data pipelines and workflows using Python and Apache
- Airflow 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
- Lead 4 projects on 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 made a growth of the team from 2 person to 6 for analysis education data for USA university applicants from all over the world.
- Awarded as “Star Performer” for making new revenue impact by 12% on two projects and client satisfaction.
- Performance tuned SQL procedures for multiple clients such as “Deloitte”, “Everest-Reinsurance”.
Sr. Database Designer and Programmer
Altima Technologies
- 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.
Development Team Lead
Acronym Solutions
- Develop DW projects regarding analysis sales and marketing data to restructure 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 Consultant(Siebel Data)
Cognizant Technology Solutions
- 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.
I have worked for
Subscribe to My Thoughts Here
Click On Subscribe To Get Regular Updates
My blog is free and will be free. Please subscribe my blog and share it. It will boost my motivation to come up with new blogs. Also, please add questions and discussion topic if you think you have any. I will make sure I come back with an answer within a week.