Ava Ghorbani

Data Analyst

Data Analyst with more than 3 years of solid professional experience in different kinds of data source, such as SQL Server, Oracle and etc.

ad1nd3@r.postjobfree.com

424-***-****

Irvine, CA, United States

TECHNICAL

SKILLS

Programing languages

SQL,Python,ETL

Databases

SSRS,SSIS, MSSQL,experienced in

database design,big data

management.

Other tools

Tableau, advance Microsoft Office

Suite tools.

Others

Project Management, Access, Pivot

table.

SOFT SKILLS

Active team player, proven record

of being a fast learner, decision

maker and details oriented.

Customer focus with strong

written and oral communication

skills

Strong analytical, organizational

and time management skills.

LANGUAGES

English

Full Professional Proficiency

Persian

Full Professional Proficiency

CERTIFICATES

Data Analysis with SQL and Tableau

Udemy

The Python Bootcamp: Data

Science, Analytics & Visualisation

udemy

WORK EXPERIENCE

Data Analyst

Wescom Credit Union

02/2022 - Present,

Involved in extracting data from multiple sources such as SQL and Python to meet business requirements.

Held the meeting with BA and test designer for troubleshooting, such as fix data error, understand business logics and find error root cause.

Used T-SQL script and dynamic query to create monthly, annually and other regularly reports. Created materialized stored procedures, views, temporary tables, CTE and correlated subqueries, nested queries and various forms of control structures. Created management dashboards/metrics in order to track and evaluate operational performance. Provide data reporting functions to the business and technical community using SQL querying to enable the team to gain insights into various parts of the company. Collaborated with team members to identify recommendation for process improvement. Data Analyst

Kaveh Industrial City

03/2015 - 03/2019,

Retrieve specific data from large databases like MSSQL. Extract information property listings, sales data, construction costs, or demographics of specific locations. Clean and transform data such as removing duplicates, correcting errors, or merging datasets from different sources.

Utilize join and sub queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in production.

Aggregate and summarize data to gain insights. Calculate average property prices, total construction costs or rental occupancy rates by SQL queries.

Prepared reports, charts with Tableau.

EDUCATION

Bachelor's Degree of Information Technology

Iran University of Science and Technology

TEHRAN

ACHIEVEMENTS

Enhanced data validation procedures, resulting in a 20% reduction in errors and 15% increase in overall data processing efficiency.

Achievements/Tasks

Achievements/Tasks

Contact this candidate