Pratik Kale
Data Analyst & Cloud Computing
Pune
Summary
Accomplished Data Analyst with expertise in Excel, Power BI, and Python, previously at XYZ Corp. Known for enhancing data-driven decision-making, I improved reporting efficiency by 30%. Adept at SQL and Tableau, I excel in problem-solving and communication, driving impactful insights and fostering collaboration. Seeking to leverage analytical skills in a dynamic environment.
Education
Bachelor of Science - Computer Science
04.2001 -
Skills
Data Analyst
Professional Summery
- Experience in working on Data analyst and GCP services - Sql, Power Bi, Python, Big Query, GCS, Dataproc and Dataflow using Python.
- Involved in Data cleaning and transformations using Apache Spark operations.
- Experience with Power Bi, Tableau for interactive visualization.
- Work with data frame operations and used different functions aggregate functions, window functions, analytical functions.
- Experienced in implementing Spark RDD transformations, actions to implement business analysis.
- Worked on importing and exporting data from different databases like Oracle, MySQL into GCP.
- Experience in writing complex SQL queries using joins, functions, sub queries and correlated sub queries.
- Experience with RDD, Spark Data frames, Spark SQL
- Dealing with various file formats like CSV, Parquet, ORC, Avro, JSON.
- Experienced on Cloud Platform Services SaaS, IaaS and PaaS.
- creating data pipelines with Cloud Dataflow.
- Running analytics queries.
- Good Experience of python and advance Python concepts like List Comprehensions, Regular Expressions, decorators, generators, OOPs, Functions.
- Coordinate and smooth communication with the team to meet the Business requirements.
- Good documentation skills and technical Skills.
- Team player with interpersonal and good communication skills.
Operating Systems
- Windows
- Linux
Big Data ( GCP Tool and Services )
- BigQuery
- Dataproc
- Google Cloud Storage
- SQL
- Google Cloud Scheduler
- PYSPARK
- Data Flow
- Data Fusion
Experience Summery
Project_1
Role : Software Engineer
Project Overview : Design an ETL pipeline on Google Cloud Platform that ingests, transforms, analyzes, and visualizes “Taxi Trip Data” . The data will flow from raw storage, through transformation and analysis layers, to SQL-based storage, and finally to Power BI dashboards for insight generation.
- Performing pre-processing and cleaning on data using BigQuery or Google Cloud Sql
- Involved in GCP architecture implementation for a complete cloud based big data solution using Bigquery, GCS, Dataproc and Airflow.
- Debugging and fixing the issues by sampling the data.
- Involvement in analysis of the project requirement.
- Shows integration from cloud native data storage to enterprise BI visualization.
- Teaches orchestration, scaling, pipeline design, and modern ETL.
Programming Languages
- SQL
- Python
Version Control Sys.
- GIT
Developer Tool
- Jupiter Notebook
- Pycharm
ORGANIZATION
Brillquest Technologies Pvt Ltd
Bengaluru,
RDBMS
- Oracle
WORK EXPERIENCE
June-2023 To till now
Timeline
Rmd Sinhagad School of Enginerring - Bachelor of Science, Computer Science
04.2001 -