Arun

Arun

Data Analyst
United States of America

About Me

3+ years of experience as a Data Analyst with an understanding of Data Modeling, Evaluating Data Sources, and understanding of Data Warehouse/Data Mart Design, and Client/Server applications. Good Knowledge of the Softwa…

Experience

Data Analyst

BlackRock
Jan 2023 - Present · 3 years 6 months

Involving requirements gathering, analysis, design, development, and testing production of an application using the Agile
model.
Using packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify the
relationship between different variables.
Develop a manager dashboard of call center metrics and KPIs to analyze the team performance using Tableau.
Utilizing technology such as Excel PowerPivot to query test data and customize end-user requests.
Outstanding data analysis skills including data extraction from MS SQL database, data mapping from source to target schemas,
and data cleansing and preparation.
Understanding of Data Modelling, Data Collection, Data Cleansing, Data Warehouse, and Client/Server applications.

Data Analyst

BlackRock, TX
Jan 2023 - Present · 3 years 6 months

Involving requirements gathering, analysis, design, development, and testing production of an application using the Agile model.
Using packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify the relationship between different variables.
Develop a manager dashboard of call center metrics and KPIs to analyze the team performance using Tableau.
Utilizing technology such as Excel PowerPivot to query test data and customize end-user requests.
Outstanding data analysis skills including data extraction from MS SQL database, data mapping from source to target schemas, and data cleansing and preparation.
Understanding of Data Modelling, Data Collection, Data Cleansing, Data Warehouse, and Client/Server applications.

Data Analyst

Dixon Technology, India (Remote Work)
Dec 2019 - Nov 2021 · 1 year 11 months

Implemented the project using the Waterfall Methodology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC).
Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.
Executed data validation, data profiling, data defects cleanup, data improvement initiatives, and data quality monitoring reports.
Involved in Data Analysis, Profiling, and Assessment to evaluate data for accuracy and quality using Python and libraries SciPy, NumPy, and Pandas.
Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data.
Worked with the Data Warehouse team in developing Dimensional Model and analyzing the ER-Diagrams.
Performed data analysis and data profiling using complex SQL queries on various source systems including SQL Server.
Worked with Data Cleaning, Wrangling, Data Analytics, Integration, Critical Thinking, Problem-Solving, Communication, and Presentation Skills.

Skills

Analytics Data Analysis Professional Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) R Programming Language (R) Tableau SDLC Agile Critical thinking Problem solving Python NumPy Pandas Scikit-Learn dplyr Tidyverse JavaScript Visual Studio Code Jupyter Notebook Matplotlib SciPy ggplot2 Looker Qlik Sense Google Data Studio Excel Power BI plotly R Shiny Snowflake MongoDB Databricks Oracle SQL Server MySQL NoSQL Azure GitHub RStudio Django Flask Spark Hadoop RedShift
Report this Profile?