Data Analyst / Data Engineer
Location : Ahemdabad, India
Experience : 15 Year
Rate: $21 / Hourly
Availability : Immediate
Work From : Offsite
Category : Information Technology & Services
HARANESH SOKHARAYA
Data Analyst / Data Engineer
PROFILE ME A driven and analytical professional with a passion for data and 15+ year of experience in the field.
Skilled in data visualization, data analysis, and statistical modelling, I have a proven track record of
delivering actionable insights and recommendations to improve business operations. Experienced in
using data tools such as SQL, Python, and Power BI to extract, process, and manipulate large
datasets. Committed to continuous learning and staying up-to-date with industry trends to provide
value to organizations
SKILLS - Power BI - AWS Quick Sight - Python
- DAX - Docker - AirByte & Airflow
- Azure Pipeline - ETL & ELT - Azure Synapse
- SQL - SSMS / SSIS / SSAS - My SQL - JSON
- Microsoft Dataflow - AWS Time Stream - Restful APIs
- Azure Logic Apps - PostgreSQL - SOAP - XML
- Azure Functions - MongoDB - Limelight - CRM
- Azure Batch Services - Power BI Web App - Google Sheet
- Share Point - Oracle - Java
- Excel / Power Pivot - Google Big Query - Linux and administration
- Power Query / MDX - Data Cleaning - Data Scraping
- Business Intelligence - API Integration - Selenium Automation
- IIS Server - SSL setup - QuickBooks integration
- Apache / Tomcat Server - Pandas & NumPy - Beautiful soup & Scrapy
- Azure Databricks - Azure Delta Lake - JDBC
- Data Ware Housing - Hadoop / Big Data / Spark - Node JS
- Azure Data Lake - OpenCV - Flask
- AWS Textract - BOW – ML Model - Sentiment Analysis - ML
CLIENT
COUNTRY
United States - 7 India - 5 China - 1
United Kingdom - 2 Israel - 1 Singapore - 1
Canada - 2 South Korea - 1
EMAIL SKYPE
EXPERIENCE
2017 / Present
Sr Software Developer - IBM India
2014 - 2017
Jr Software Developer – Other
2011 - 2014
Data Analyst / Data Engineer - Webority Technologies Pvt Ltd
HARANESH SOKHARAYA
Data Analyst / Data Engineer
PROJECTS
PROJECT - 1 ETL & Power BI Dashboard for US call centre [2017-2021]
Role:
Power BI Developer & Data Engineer
Project Goal:
End to end reporting solution using various data sources.
Solution:
- Setup centralize reporting using MS-SQL database on azure premise.
- Ingesting various data sources to MS-SQL using azure pipelines. (Data sources like Google
Sheet, MySQL, Limelight / Sticky CRM, Five9 calls details)
- Using SSAS-Tabular modelling created various reports
Result:
- Solved business challenges
- The set of 10+ reports offer comprehensive insights on various aspects such as dropped calls,
call duration, abandoned calls, execution times, and backend information related to call quality.
These reports provide valuable information that can help businesses make informed decisions
with precision
PROJECT - 2 Power BI Dashboard for Online Sales – Order Processing Team [2017-2021]
Role:
Power BI Developer & Data Engineer
Project Goal:
End to end reporting solution using various data sources.
Solution:
- Setup centralize reporting using MS-SQL database on azure premise.
- Ingesting various data sources to MS-SQL using azure pipelines. (Data sources like Google
Sheet, MySQL, Limelight / Sticky CRM)
- Using SSAS-Tabular modelling created various reports
Result:
- Solved business challenges
- The set of 5+ reports offer comprehensive insights on various aspects such as dropped calls,
call duration, abandoned calls, execution times, and backend information related to call quality.
These reports provide valuable information that can help businesses make informed decisions
with precision
PROJECT - 3 Web Scraping for real time crypto transaction records [2022-2022]
Role:
Utilized python programming skills in professional capacity
HARANESH SOKHARAYA
Data Analyst / Data Engineer
Project Goal:
Retrieve data for tracking cryptocurrency transactions
Solution:
- Set up email alerts for monitoring cryptocurrency transactions in real-time.
Result:
- Resolved the project's intended purpose
PROJECT - 4 ETL – Schedule daily refresh data from Google Sheets to Database [2020-2022]
Role:
Utilized Airbyte tool expertise to achieve goal
Project Goal:
The project's primary objective was to retrieve data from Google Sheets and insert it into
Google Big Query.
Solution:
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
