Data Analyst Resume

OBJECTIVE

Technically strong, detail - oriented business professional with over extensive experience of business analysis and data processing. Results - oriented with demonstrated expertise in business planning and analysis of statistical data to determine inadequacies in business processes, to forecast future risks, and establish strategies for positive change.

TECHNICAL SKILLS

Database and ETL Tools: SQL Server Management Studio, MySQL, PostgreSQL, Microsoft Access, SSIS

Data Analysis and Reporting: Power BI, Tableau, Python (Numpy, Scikit-Learn, matplotlib, Pandas), R Studio, SSRS, SSAS

Language: Python, R, T-SQL, PL/SQL

Certifications: Google Analytics

Other: Excel, Word, PowerPoint, Visio, VBA

Operating Systems: Windows, Mac OS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

Querying data from a variety of data sources, joining tables to pull data together, verifying data and creating executive level dashboards and graphs.
Utilized SQL Server and Excel to analyze logistics data to understand where process improvements can be made and develop metrics to measure the effectiveness of the implemented solution. Reducing delivery time by 30% and maintaining an average on-time delivery rate of 90%.
Developed mass update system to avoid manual updates to the customer database and trained other users on the program. Ensured the accuracy of customer information records and reduce delivery error rates.
Created complex report/dashboard using Tableau, and performed data analysis on large dataset to solve business issues.
Responsible for forecasting demand, managing inventory and planning the replenishment cycles on a monthly basis to prevent product excess or shortfall/stock out situation.
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Data Analyst

Confidential

Responsibilities:

Cleaned and prepared a demographic dataset with more than 20 million records by using in R.
Developed a regression tree model to predict how much Facebook will charge from Confidential based on a certain time, certain website and certain demography.
Generated report and presented result to project sponsor that their advertising efficiency could increase by 50%.
Delivered actionable insights to drive marketing analytics and ad campaigns.

SQL Developer

Confidential, Boston, MA

Responsibilities:

Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.
Followed 2NF/3NF standards to create database for OLTP databases.
Multiple views were created to reduce the complexity of writing procedures and increase database performance.
Responsible for transforming data from OLTP to OLAP data sources using SSIS.