OnBenchMark Logo

Oushnik (RID : qzycljplfxwc)

designation   Data Analyst

location   Location : Banglore

experience   Experience : 4 Year

rate   Rate: $11 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 2
Total Views : 104
Key Skills
Data Analyst Power BI SQL Python.
Discription

 

 


Oushnik Sarkar






Synopsis



 B.Tech (IT) with 10 years of industrial experience along with 4+ years of work experience as Data Analyst
in Python with ML/AI, SQL, Power BI. Completed several projects using AI & ML.
 Hands-on-experience in Python with ML & AI using Regression, Classification model, Deep Learning,
Recommendation system, Microsoft Power BI Desktop, SQL Query.
 Also having knowledge on C, Advanced Excel.
 Company Details : 1. Ascendion Engineering Pvt Ltd as Executive Data Analyst
2. Proziod Analytical Pvt Ltd as Data Analyst
3. RotoPacking Materials Ind Co LLC, Dubai, UAE as Executive Customer Service
4. St Mary’s Technical Campus, Kolkata as Technical Assistant


Professional Experience


1. Executive Data Analyst in Ascendion Engineering Pvt Ltd (10
th
October 2022 to 31
st
March 2023)

Domain : Procurement
Key skill: Python, Power BI, Advanced Excel, SQL Query
Responsibility :
 Reviewing/adjusting budgets, actuals, and forecasts.
 Determine operational objectives by studying business functions, finding Key insights and trend for all expenses.
 Extracting data from various source, transforming data by cleaning and handling missing values properly. Creating
view by joining with few tables in SQL server to make proper readability of the data.
 Providing plan to control the expenses by reviewing the high expensive products.
 As required by project use Python Pandas, Numpy, Microsoft Excel, Power BI tools to create custom reports to
identify and highlight project issues and achievements.

2. Data Analyst in Proziod Analytical Pvt Ltd. (3
rd
Dec 2018 to 30
th
Sep 2022)

Domain : Energy
Key Skill: Python, Machine Learning Models, Power BI, Advanced Excel, SQL Query.
Responsibility:
 Perform data collection from US market providers. Transformation and ingestion of data into MS SQL Server.
 Using Python to preprocess data and attempt to find insights.
 After merging, extracting those data as csv, perform data analysis using Python with Machine Learning algorithms
i.e. Classification, Regression. Experience in python, Scientific computing stack (Numpy, Pandas, Matplotlib)
using Jupyter Notebook.
 After collecting, merging daily data from market providers, apply various quantitative ML algorithms (linear
regression, polynomial regression, naive Bayes, Random Forests, & KNN) for making prediction about the future
business revenue from customers for next 6 months.
 Built an internal visualization report for the clients to view historic data using Python packages like Pandas,
Matplotlib, Seaborn library.
 Participated in features engineering such as feature creating, feature scaling and One-Hot encoding.
 Used Scikit-learn in Python for developing various Machine Learning algorithms and utilized machine learning
algorithms such as linear regression, polynomial regression, Naive Bayes, Random Forests, & KNN for data
analysis.
 Built models using techniques like Regression, Tree based ensemble methods, Time Series forecasting, KNN, and
Isolation Forest methods.
 Proficient with Power BI reporting, familiar with writing DAX functions, creating dashboards, Bookmarks, slicers
for interactive visualizations drawing meaningful data insights.



PROJECTS
Predicting The Future Cost :
Algorithm: PCA, Random Forest, Decision Tree, Linear Regression, KNN.
Building the Machine Learning model with predicting the business revenue for next 6 months by applying various
quantitative ML algorithm with R-squared value 0.95 to enable the company for making investment.

Predicting The Customer Churn :
Algorithm: PCA, Random Forest, Decision Tree, Logistic Regression, KNN classifier, XGBoost.
Developed the Machine Learning model for predicting the customer churn using Classification algorithm. This enables
the client to target current customers and reduce the churn significantly.

Energy Dashboard using Power BI:
Monitoring and Creating energy metrics/KPI dashboards for Electricity, Gas and Oil commodities. Create reports on
weekly basis for the same using Power BI.
Identifying missing data, Cost-savings for customers and create reports on weekly basis for the same.

3. Executive Customer Service in Rotopacking Materials Ind Co LLC. (15
th
Jan 2015 to 19
th
Sep 2018)

Key Skills: SQL Query, Advanced Excel, Logistics, Documentation and IT Coordination.
Responsibility:
 Managing d

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!