PROTIK GHOSH
Kolkata
Summary
An enthusiastic and energetic professional, targeting challenging positions in the field of Data Engineering and Warehousing, open to opportunities in IT Service and Productbased companies, preferably in Kolkata, Bangalore or Pune.
Offering over 4 years of experience in Data Engineering, specializing in design, development and implementation of Business Intelligence and Data Warehousing Projects. Comprehensive experience in business analysis & development; skilled in managing clients & delivering knowledge solutions for client's business problems processes. Assisted in various Project Management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters. Exposure in Data Warehouse concepts such as Star Schema, Snowflake Schema and Dimensional Data Models for query and analysis requirements. Proficient with data quality, cleansing, migration and warehousing activities with an exposure in ETL process design. Excellent knowledge in mapping business requirements and designing customized solutions; expert in understanding business needs and identifying initiatives of clients to meet their strategic goals. Possess a detail-oriented attitude and the capability to analyze business practices and define optimal procedures. Twice felicitated with the "Employee of the Quarter" Award at ThirdEye Data Analytics, Q2, Q4, 2021.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Technical Consultant
PwC
Kolkata
08.2022 - Current
- Managing comprehensive data pipelines within a Fortune 100 company
- Executing a seamless transition of a Data Warehouse from Teradata to Snowflake in an Azure cloud-based environment
- Leveraging PySpark and Databricks to translate legacy Informatica Pipelines
- Unifying disparate data systems, optimizing efficiency and accuracy
- Implementing innovative strategies to streamline data migration processes
- Facilitating collaboration among cross-functional teams to ensure project success
- Ensuring adherence to industry best practices and compliance standards throughout the transition process
- Collaborating with stakeholders to understand requirements and deliver tailored solutions
Data Engineer
ThirdEye Data Analytics
Kolkata
02.2020 - 07.2022
- Led the seamless flow of information from 4 distinct origins
- Developed a robust data lake and an intuitive executive dashboard laden with crucial KPIs and tailored business insights
- Wove together the components through the mastery of S3, Lambda, Glue, and Python
- Managed the development of cutting-edge data infrastructure solutions
- Implemented innovative techniques to optimize data processing and visualization
- Ensured the reliability, scalability, and security of the data infrastructure
- Managed a data warehouse with 10 distinct sources
- Led data analytics efforts and spearheaded the creation of numerous business intelligence reports and dashboards
- Spearheaded end-to-end data processing and visualization work flow
Education
B.Tech. - CSE
Techno Engineering College Banipur
01.2020
Skills
- Data Engineering
- Data Analytics
- Data Warehousing
- ETL
- Business Intelligence
- Database Management
- Data Profiling
- Data Cleansing
- Requirement Gathering
- Requirement Analysis
- Project Management
- Stakeholder Management
- Reporting
- Documentation
- Python
- Pandas
- PySpark
- Informatica PC
- Informatica IICS
- Databricks
- Snowflake
- NodeJS
- Teradata
- Boto3
- Puppeteer
- Flask
- BitBucket
- Django
- Github
- Azure ADB
- Azure ADF
- Azure Synapse
- Azure ADLS
- AWS S3
- AWS Lambda
- AWS Glue
- SQL MySQL
- SQL Redshift
- SQL BigQuery
Certification
- DP:900, Azure Data Fundamentals, 2024
- Google Cloud Data Engineering, GCP, Udemy, 2023
Languages
- English
- Hindi
- Bengali
Personal Information
- Title: DATA ENGINEER
- Date of Birth: 08/13/98
Timeline
Technical Consultant
PwC
08.2022 - Current
Data Engineer
ThirdEye Data Analytics
02.2020 - 07.2022
B.Tech. - CSE
Techno Engineering College Banipur