WORK EXPERIENCE

Data Analyst Intern

AI Variant

**/**** – 03/2023, Bangalore, India

Tasks

Actively involved in data extraction, data cleaning & data analysis. Converted data into actionable insights by performing inferential & descriptive statistics on data to get insights & develop prediction models.

Utilized MY SQL, Tableau, Excel & other dashboard/visualization toolsets for data intelligence & analysis.

Utilized Python & its various libraries like Seaborn, Matplotlib, NumPy, and Pandas for EDA, data modeling & visualization. Mechanical design & data population engineer.

Expert Global Solutions Pune, India

02/2018 – 02/2019

Tasks

Design and detailing of paper machine dry end section on cad software. Preparation of bill of material on Excel Preparation of bill material using MS Excel.

Technical Data cleaning, quality check, and visualizing data using Excel.

Design Engineer

Damco Engineering pvt ltd.

09/2015 - 12/2017, Pune, India

Tasks

Design and detailing of welding fixture on Catia and AutoCAD. Preparation of bill of material on Excel

Used Advance Excel functions Macro while making BOMs. EDUCATION

M.E. – Mechanical Design Engineering

University of Pune - India

07/2017 - 07/2013,

SGPA 7.5

B.E. – Mechanical Engineering

University of Pune - India

07/2009 - 07/2013,

SGPA 6.7

SKILLS

INTERNSHIP PROJECTS

Medicare & Medicaid Healthcare Analytics [Domain:

Healthcare]

• Analyzed and Cleaned data with customer order

details of 10,48,576 rows using Excel.

• Used MySQL to extract data from the database and performed advanced queries for data analysis and

calculations.

• Used Tableau and Power Bi to create visualizations and dashboards to showcase findings and insights.

• Provided Insights on Age Wise Medicare

Beneficiaries, Part wise beneficiaries, top providers, cities, provider type, beneficiary cities, Services and Total charge amount, drug submitted charge amount, total services, total beneficiary uses the drug and Medicare services.

Salesforce Data analysis [Domain: CRM]

• To Create lead and opportunity analysis Dashboards.

• Using Excel, cleaned customer data consisting of five tables over 98, 3052, 10000, 1443, and 10000 rows

accordingly for user Account, Lead, Opportunity,

Opportunity Product Table.

• Used MySQL to extract data from the database and performed advanced queries for data analysis and

calculations.

• Used power bi and Tableau to display visualization and dashboard to showcase findings and insights.

• Provided insights for Lead dashboard as total leads, conversion leads, conversion rate, win rate, lost rate, total expected amount from leads, Top 5 lead

accounts, lead sources, and lead industries.

• Provided insights for opportunity dashboard as total opportunities, active opportunities, and expected

amount from opportunities. Top 5 industries and trend analysis for opportunity.

Advanced MS Excel

SQL Tableau PowerBI EDA

adz53i@r.postjobfree.com +1-832-***-**** Houston, Tx Bhagyashri Dumbre

Data Analyst

Data Analyst with about 4+ years of experience in mechanical design with 1+ yrs. of relative experience in data. I have diversified experience in mechanical design and data domain. A Data Analyst intern with 08 months of experience interpreting and analyzing data using SQL, Power Bi, Tableau, Python and Advance Excel to drive successful business solutions. Seeking a challenging role in the analytics domain will enable using my technical and analytical skills to design, develop, test and maintain business intelligence solutions. CERTIFICATES

Data Science using Machine Learning with Python –

ExcelR in collaboration with IBM (06/2022 - 06/2023) Python-Data Visualization • String manipulation and regular expressions •EDA using Pandas for handling data, NumPy for numerical calculations, and Matplotlib and Seaborn for visualization. Data mining Supervised and unsupervised ML. Decision Tree and Random Forest, Naïve Bayes, KNN, K-means, DBSCAN • PCA, tSNE

• Bagging, XGBM, LGBM, and Random Forest.

Data Analyst – ExcelR in collaboration with IBM (06/2021

- 06/2022)

Excel for data cleaning and calculations done by advanced Excel formulas • extracting data from databases using SQL queries •Power Bi and Tableau for data visualizations • Python basics for visualization and data cleaning • statistics Masterclass in Python – Core Code Academy, Pune

(09/2021 - 03-2022)

• Basic and advanced Python.

Intermediate SQL Queries – W3 schools

Complex joins, unions, sub-queries, window functions, regular expressions in SQL.

Contact this candidate