Tushar Kakaiya Email & Phone Number

Ahmedabad, Gj, In

Ahmedabad, Gujarat, India

I provide consulting services for modern cloud technology-driven projects and contribute to phData's recruiting efforts for Lead Data Engineer roles. I also write insightful blog posts on cutting-edge technologies and actively foster community building initiatives.In our projects at phData, achieved several milestones:- Leveraged AWS Event bridge and Kinesis Firehose for seamless migration of MongoDB data to Snowflake Warehouses, ensuring efficient and reliable data transfer. This integration empowers clients to harness Snowflake's powerful analytics capabilities effectively.- Developed customized flattening logic for JSON-based data across diverse Mitratech customer datasets, offering tailored dashboarding solutions that cater to unique data structures and client requirements.- Implemented Coalesce as a transformation tool alongside Fivetran for data ingestion from SQL Server to Snowflake, optimizing the data warehouse migration process.- Built an AWS event-driven asynchronous framework to orchestrate custom DBT, Matillion, and Glue jobs sequentially. This framework enhances project scalability by supporting diverse job engines and providing comprehensive logging capabilities.These initiatives have enabled our clients to access, analyze, and derive actionable insights from their data effectively, empowering informed decision-making and enhancing business outcomes.

Ahmedabad, Gujarat, India

As a Professor of Practice at NBS, an institution consistently ranked among the top3 in Gujarat and TOP 50 in India for B-Schools, I led the delivery of their Post Graduate Diploma in Management (PGDM) programs specializing in Data Science and Analytics, alongside Information Technology (IT). I also played a pivotal role in shaping the program's curriculum and fostering a thriving community of aspiring data professionals.I joined NBS with a vision to bridge the gap between Industry and Academia.In this role, I instructed students in a range of subjects crucial to their professional development, including: - Data Science Fundamentals- Fundamentals of Programming using Python - Relational Database Management Systems- Business Intelligence and Data Warehousing- Business Analytics with R Programming LanguageThrough engaging lectures, practical workshops, and hands-on projects, I equipped students with the knowledge and skills needed to excel in the dynamic fields of Data Science and Analytics, preparing them for successful careers in the industry. During my time at NBS, I helped lead their Data Science and Analytics program, teaching students important subjects like coding, databases, and business intelligence. I also created a club for students interested in data, where we did activities and shared knowledge.Some key highlights of my achievement:- Designed the course plan for the Data Science program.- Taught over 300 students how to code.- Started a club called the Data & Analytics DNA Club.- Guided students through different activities in the club.- Established a process for admitting students to the program, making sure they were ready for the challenges ahead.

India

Indian Institute of Technology, Gandhinagar - Conducted a short course of 15 hours titled "Big Data Analytics using Hadoop and Apache Spark". - Delivered theoretical and hands-on sessions on distributed computing technologies. - Course received positive feedback from diverse student participants.Amity University Online Division - Subject Matter Expert for MCA courses: 'AI for Everyone' and 'Introduction to Machine Learning'. - Conducted video-recorded sessions and live doubt-solving sessions to ensure comprehensive student support.Imarticus Jaipur Center - Delivered a 40+ hour live workshop on Big Data Analytics. - Covered Hadoop, HDFS, Hive, Sqoop, Spark, and ecosystem tools. - Led a real-world project on sales analysis using supermarket customer data.BKBI (Gujarat University) - Senior SME teaching Python for Business Analytics in the Business Intelligence department. - Covered Python basics, data structures, and key libraries (openpyxl, numpy, pandas, seaborn, matplotlib, plotly).PDEU - CSE Department - Adjunct Professor for the "Foundations of Data Science" course. - Topics included RDBMS normalization, ER diagrams, Big Data analytics frameworks, data science techniques, NoSQL databases, and real-world applications.

Ahmedabad, Gujarat, India

In the Novartis CCDH (China Commercial Data Hub) project, our team was involved in:- Building ETL data pipelines using AWS data engineering tools such as Glue, Redshift, EMR, and S3. These pipelines were crucial for extracting, transforming, and loading data efficiently.- Implementing real-time data storage and management from Salesforce to S3 using Streamsets pipeline technology. This enabled us to collect and process data in real-time, ensuring the availability of up-to-date information.- Establishing a data lake on Amazon S3 storage services, where all relevant data from different sources could be stored, organized, and analyzed efficiently. This centralized repository facilitated easier access to data for analytics and reporting purposes.Overall, our contributions in this project played a vital role in enabling Novartis China to effectively manage and analyze their commercial data, driving informed decision-making and enhancing operational efficiency.

Ahmedabad, Gujarat, India

In the Centrica UK CDL (Common Data Lake) Project, our team accomplished the following:- We constructed a Common Data Lake utilizing AWS Cloud Services such as S3, Athena, and Lake Formation. These services provided a robust foundation for storing, managing, and analyzing vast amounts of data in a scalable and cost-effective manner.- We leveraged the compute framework Spark on EMR (Elastic MapReduce) clusters to process and analyze data within the Common Data Lake. Spark's distributed processing capabilities allowed us to efficiently handle large-scale data transformations and analytics tasks.Overall, our efforts in this project enabled Centrica UK to establish a centralized data repository and analytical platform, empowering them to derive valuable insights and drive data-driven decision-making processes effectively.

Ahmedabad Area, India

Working with the Content System Development Department for the Ownership Data set. Skillset we use :- Apache Spark with Scala, Hive, Oozie, Gradle, Maven, Git Repository, Apache Airflow, Amazon S3

Ahmedabad Area, India

- Working for one of the core clients of S&P, for building Enterprise Data Warehouse on top of the Hadoop Distributed File System (HDFS).- Developing scripts to extract data from HDFS and load the same to Hive External Tables- ETL Operations using SSIS Tool to load data from Hive to SQL Tables- Building OLAP Cubes using the Hive Tables, Data from SQL Server and other data sources- Providing End to End Solution to client to get more insights from their data in terms of Dimensions and Measures- Scheduling and Monitoring Hadoop Jobs and Troubleshooting for the existing runs in case of failures

Pune, Maharashtra, India

Worked with one of the leading manufacturing clients to migrate the database from Oracle to Hadoop and support their Hadoop Based Warehouse and assisting in ETL process.Big Data Hadoop, Hive, Sqoop, HDFS, Flume and other Hadoop Eco system tools as the main skill set. Worked with Microsoft Client as a Partner Incentive Program.SSIS, SSAS, SSRS, MIS Reports, T-SQL as main skillset.

Pune, Maharashtra, India

Developing Data Warehouse for Major Telecom Providers in United Kingdom - BT, EE, Key Skills : Big data, Hadoop, SQL Server, SSIS, MSBI, ETL, Scripting Languages like: VB, C#

Rajkot, Gujarat, India

Master Of Technology - Mtech, Software Engineering, 10.0 Cgpa

Achieved a perfect 10 out of 10 CGPA and successfully completed my dissertation titled 'Web Mining using Click Streamed Data,'.

Bachelor Of Engineering (B.E.), Computer Engineering, A+

Proud recipient of the Gold Medal from Gujarat University, recognizing my achievement as the 1st position holder in the Computer.

12Th Science, Science, A+

Activities and Societies: Awarded winner in multiple categories including Quiz Competition, Essay Writing, and Radio Play Writing.