OnBenchMark Logo

Abhishek (RID : 12a29llwk5uan)

designation   Data Analyst

location   Location : Indore, India

experience   Experience : 3 Year

rate   Rate: $8 / Hourly

Availability   Availability : 2 Week

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 109
Key Skills
Power BI Tableau SQL Python R Programming

Results-oriented data science professional with 3 years of experience in big data and business data analysis. Skilled in data extraction, optimizing pipelines, leading data migration projects, reporting, and visualization using Power BI and Tableau.Proficient in Python, SQL, R, and ML/DL algorithms and its libraries.

ML Algorithms: Linear and Logistic Regression, SGD, Decision Tree, Random Forest Regressor, KNN
Software: Ms Office (Word, Excel, Power Point, Access), MATLAB, Flask, Beautiful Soup, Git
Libraries: Scikit-learn, NumPy, Pandas, Matplotlib, Seaborn, TensorFlow, Keras, ANN, NLP
IDE: Visual Studio, Jupyter Notebook, PyCharm, IDLE, GitHub


Project Details
Title : Business Data Analyst
Duration : 24 (Month)
role and responsibileties :

1) Programming Language:

SQL, Python, R, Machine Learning (ML), Deep Learning (DL)

2) Relational Databases:

MS SQL, PostgreSQL, MySQL, MS Access, MongoDB, Google Big Query

3) Tools:

Power Bi (Desktop and Service), TABLEAU, SSMS, SSIS, SSAS, SSRS, AGILE, SDLC

Description :

• Developed Python-based ETL processes using pandas and SSIS to export Excel reports to SQL Server for daily POWER BI reporting, including data transformation and manipulation.
• Consulted clients on optimal SQL Server reporting architecture, implementing custom calculations using SQL Server Views and utilizing Python for advanced data analysis and statistical modeling.
• Created Power BI reports for daily and historical inventory analysis, incorporated Python for data preprocessing, feature engineering, and machine learning algorithms.
• Implemented user access management, row-level security, KT to stake holders and scheduled report subscriptions, ensuring efficient operations and enhanced data security.
• Conducted Power BI admin tasks for managing the users, its data gateways and stakeholders.
• Performed in-depth data analysis using advanced SQL queries; employed Python for data processing, cleansing, and
feature engineering and managed visual reporting using tableau.
• Power BI reports with interactive visualizations and dashboard, scheduled refreshes and updates using SSIS and
MSSQL server. Also worked on Python libraries Pandas, NumPy for data manipulation, analysis, and visualization.

• Developed a Python-based predictive model for a client, to predict diseases of customers based on their symptoms.
• Utilized Python to create a predictive model that accurately estimates house prices by leveraging real estate data.
• Implemented a Python script using Beautiful Soup and Selenium to construct a data extraction model. This model
efficiently retrieves job data from various websites such as LinkedIn and Indeed.

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

stuff goes in here!