Data Analyst

* ***** ** ********** ** data analysis and statistical modelling including data extraction, manipulation, visualization and validation techniques, reporting on various projects.

Good experience of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile.

Experience in developing different Statistical, Text Analytics, Data Mining solutions to various business. generating and problems data visualizations using Python and Tableau Design and development of Data warehouse for Business Intelligence data marts and reporting.

Experience in Business Intelligence (BI) Technologies like Microsoft Business Intelligence (SSIS, SSAS, and SSRS), Business Objects.

Business experiments and A/B Testing

Worked on several python packages like NumPy, pandas, PyTables, Seaborn, Matplotlib and Scikit-learn.

Experience in creating visualizations, interactive dashboards, reports and data stories using Tableau.

Data Analysis, Data collection, data transformation and data loading the data.

Good Knowledge of working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau

Working knowledge of creating filters, quick filters, data source filters global filters, context filters, user filters, actions and creating Dashboards for key performance indicators (KPI).

Utilize Microsoft Excel and access to manipulate, cleanse and process large data set.

Hands on experience in Stored Procedures, Functions, Triggers and strong experience in writing complex queries, using SQL Server and MySQL.

Knowledge of designing Test Scenarios, and Test cases for the validation of data in the data warehouse.

Good knowledge of SQL Query tuning and instance tuning as the part of performance tuning.

Good knowledge of tracking system and version control tools such as GitHub.

Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.

Methodologies:

Agile

Reporting Tools:

Tableau, Tableau Server

ETL Tools:

SSIS, SSAS

Databases:

MS-SQL Server, Ms Access, SQL Server

Tools:

MS Project, GitHub

Languages:

SQL

Packages:

NumPy, Pandas, PyTables, Seaborn, Matplotlib, Scikit-learn

Operating System:

Windows

Documentation Tools:

MS Office, Microsoft Visio

Bachelor of Arts in Business Administration, Management and Finance

UNIVERSITY OF WASHINGTON, WA

JPMorgan Chase & Co., WA Jan 2019 - Current

Data/Business Analyst

Roles & Responsibilities

Implemented and followed Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.

Optimization of data sources for route distribution analytics dashboard in Tableau reducing report runtime.

Utilized Tableau server to publish and share the reports with the business users.

Extracted the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.

Designed and implemented multiple dashboards using Power BI - PowerPivot tools

Designing and Analyzing A/B Tests

Working with Pandas, NumPy, Seaborn, Matplotlib and Scikit-learn for developing various algorithms.

Worked extensively with MS Visio and Rational tools to document requirements.

Wrote several Teradata SQL Queries using SQL Assistant for Ad Hoc Data Pull request.

Used GitHub for version control in the project management.

Defined project milestones, schedules, monitoring progress and updating plans using MS Project.

Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.

AmerisourceBergen, WA Aug 2017 – Dec 2018

Data Analyst

Roles & Responsibilities

Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company.

Created data model with required fact and dimensions.

Importing and Exporting Data from Access Database and building SQL Queries for data manipulation Reporting in Access and VLOOKUP in Excel.

Managed worksheets using manual and automated process on Tableau development server.

Designed and created analytical dashboards using Power BI

Presenting and rolling out A/B tests.

Utilized Tableau and custom SQL feature to create dashboards and identify correlation.

Involved in Data Mapping activities for the data warehouse.

Generating various capacity planning reports (graphical) using Python packages like NumPy, matplotlib.

Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.

Hands on Experience on Pivot tables, Graphs in MS Excel, MS Access.

BUSINESS DATA ANALYST

Kerven Saryyev

Location: Seattle, WA Mobile: 312-***-**** Email: *********@*****.***

Summary

Skills

Education

Experience

Contact this candidate