Data Analyst Resume

SUMMARY

A motivated and versatile graduate student with innovative mindset having around 2.5 years of technical experience in Data analysis and Data Modelling and 1.5 years of masters experience in Information Technology.
Query optimization and performance tuning of queries for better performance in SQL.
Built MySQL database, and developed stored procedures, tables, views, etc for processing data.
Utilized ETL to perform data extraction, manipulation and procession and load the data into database with Python Pandas, NumPy, and MySQL.
Developed Tableau visualizations and dashboards with multiple panels and parameters using Tableau desktop
Solid skills knowledge in statistical methods, including regressions, predictive models, cross validation, hypothesis test, and probability .
Processed Big Data with Apache Hadoop (HDFS, Yarn, MapReduce), and Spark.

TECHNICAL SKILLS

Languages: R, Python, SQL, JavaScript, HTML5, CSS3, MATLAB, D3.js, Java, C, C++.

Libraries: Pandas, Numpy, Scikit - learn, Tensor Flow, Matplotlib and SciPy.

Tools: Tableau, Talend,R Studio, Jupyter notebook, AWS, Eclipse and Advanced Excel (VLOOKUP, ANOVA)

Data Analytics: Hadoop, Spark (MLib), Clustering, Regression, Classification, MapReduce, Text mining

Additional: SSIS, ETL, GIT, UML, AngularJS, JUnit, Apache Tomcat, Agile, Cloudera, Mockito, LinuX, Bash

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

Exported/Imported data between different data sources using SQL.
Used Python NumPy, SciPy, Pandas packages to perform dataset manipulation.
Data cleansing, Exploratory analysis, Explanatory Analysis and Data Visualization using Python to extract relevant by using Data Modelling, Data Warehousing, and ETL concepts.
Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, analysing BI needs for user community.
Utilized SQL, Advanced Excel function and Python to collect and perform statistical analysis of the business data
Analyzed and extracted relevant information from large amounts of both structured and unstructured data
Collaborated with data engineering teams to improve data assets, quality, metrics and insights.
Increased annual revenue by recommending improvements KPI Sales by product category and Inventory to sales ratio.
Developed Tableau visualizations and dashboards with multiple panels and parameters using Tableau desktop to show histograms, scatterplots, boxplots, correlation tables, etc.

Data Analyst

Confidential

Responsibilities:

Worked with Security and Database team to understand the business requirement and what data they have.
Collected data from Oracle and Mainframe database to analyse it.
Used SQL to extract and integrate data from various source, cleansed, transformed it to gain insights.
Data for modelling was collected using SQL by querying several tables. The extracted tables were further appended or merged to create tables for modelling.
Analysed data (metric and attributes) in fact tables and dimension table to resolve data quality issue.
Tracked and inspected key performance indicators like cost of goods sold sales by region, number of customers.
Write concise documents communicating results to stakeholders and visualize data to drive decision making.
Cleaned, pre-processed and reviewed the sales data and created interactive dashboards using Tableau for analysis and predicted business insights, which increased sales by 6%.