Victoria Arequipa

Data Analyst

Location: AZ Mobile: 219-***-**** Email: adogwa@r.postjobfree.com Professional Summary

Experienced Data Analyst with over 3+ year experience in Statistical Modeling, Data Mining and Data Visualization.

Expertise in transforming business resources and requirements into manageable data formats and analytical models, designing algorithms, building models, developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data.

Proficient in managing entire data science project life cycle and actively involved in all the phases of project life cycle including data acquisition, data cleaning, data engineering, features scaling, features engineering, statistical modeling, testing and validation and data visualization.

Proficient in Statistical Methodologies including Hypothetical Testing, ANOVA, Time Series, Principal Component Analysis, Factor Analysis, Cluster Analysis, Discriminant Analysis.

Strong experience with Python(2.x,3.x) to develop analytic models and solutions.

Proficient in data visualization tools such as Tableau, Python to create visually powerful and actionable interactive reports and dashboards.

Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.

Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies

Excellent Tableauskills, expertise in building, publishing customized interactive reports and dashboards with customized parameters and user - filters using Tableau(9.x/10.x).

Experience in creating technical metadata for the underlying physical data model of the Source systems as well as Data warehouse.

Experienced in Agile methodology and SCRUM process.

Strong business sense and abilities to communicate data insights to both technical and nontechnical clients. Skills

Languages: Python, R, SQL

Databases: MySQL, SQL Server, PostgreSQL

Tools: Tableau, Microsoft Excel, SQL

Statistical Tools: Time Series, Regression models, principal component analysis, Hypothesis Testing, A/B Testing, Confidence Intervals, T-test, ANOVA, NLP Python packages: NumPy, SciPy, pandas, PyTables, PyTorch Operating Systems: Windows, Linux

Education

Master of Science, Computer & Electrical Engineering Purdue University, IN Dec 2020 Bachelor of Science, Computer & Electrical Engineering Purdue University, IN Dec 2018 Page 2

Experience

Dell Technologies, AZ Jan 2021–Present

Role: Data Analyst(Intern)

Responsibilities:

Experienced working in Agile Methodologies.

Understand the data visualization requirements from the Business Users.

Analyze Sales data mart model to identify the tables and their relations in order to extract required data.

Writing SQL queries to extract data from the Sales data marts as per the requirements.

Create Source to Target Data mappings for the individual reports.

Create Pivot tables in Excel to analyse data across several dimensions.

Creating mock-ups of Dashboards and individual data visualizations in MS Excel.

Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Prepared test cases for the validation of data and look feel of the reports.

Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.

Pre-process data to identify the features with missing data by writing Python scripts.

Writing scripts to implement Predictive Modelling algorithms.

Interpret the results of the Predictive Models and document in project report.

Writing scripts in Python to perform data exploratory analysis. Epsilon, AZ May 2018 – Dec 2020

Role: Data Analyst (Intern)

Responsibilities:

Understand the data visualization requirements from the Business Users.

Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.

Developing containment scripts for data reconciliation using SQL and Python.

Performed data analysis and data profiling using complex SQL on various sources systems including MongoDB

Performed Data Cleaning, features scaling, features engineering using pandas and numpy packages in python.

Analyzed different types of data to derive insights about relationships between locations, statistical measurements and qualitatively assess the data

Responsible for defining the key identifiers for each mapping/interface.

Worked on Performance Tuning and understanding Joins and Data distribution.

Conducting mapping walkthroughs sessions with the Business and other project stakeholders.

Created User Interface reports for validating the Data through Reporting Services.

Extracting and Loading data into SQL Server Database using SSIS.

Create and maintain clearly written technical, user, and system documentation.

Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers.

Creating resuable backup and restore jobs in SQL server.

Deployed SSIS Packages from Dev/Staging/Production using Package Deployment method in SQL Server 2016.

Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.

Creating Unit Test cases for the validation of data in the Target database Involved in data modelling meetings with the Business stakeholders and technical team.

Contact this candidate