Data Analyst
Resume:
Li Bai
Greenbelt, Maryland 20770
*********@*****.***
OBJECTIVE:
To obtain a position in the field of Data Analysis utilizing my acquired skills.
PROFESSIONAL SUMMARY:
Around 3 Years work experience in business intelligence analyst and database management.
Analysis the requirement from end user. Handle data mapping, know what information the end user need, created tables with various constraints.
Experience in data query, data analysis and data report using Oracle and MySQL database.
Experienced in programming tasks-stored procedures, triggers, cursors using Oracle with SQL developer or SQL Plus.
Data modelling and in 3NF and dimensional modelling.
Data cleaning using python or R.
Experienced in data visualization using tableau (visual analytics, storytelling).
Experienced in data analyst and data mining using R language (visualization: boxplot, etc.).
Good knowledge of Linux server maintenance and write shell script.
Excellent in data analysis and data present using MS Excel (Pivot table, VBA, Advanced Formatting).
Hands on experiences in data analyst using Python (Module: csv, re, NumPy, pandas)
Python website spider experiences.
Hands on experience in working in cloud Linux environment like AWS EC2.
Excellent Verbal & Written Communication Skills.
Highly detail-oriented with exceptional analytical skills.
EDUCATION:
Bachelor of Business Administration 2010-2014
Kent State University Kent, Ohio
Major: Accounting
Master of Science 2015 - 2016
Stevens Institute of Technology Hoboken, New Jersey
Major: Information Systems - Business Intelligence Analysis
GPA: 3.91 (Top Student)
RELATED EXPERIENCE:
Stevens Institute of Technology Feb 2016 – Nov 2016
Data Analyst Hoboken, New Jersey
Engage user to gather software requirements rules, and ensure alignment with development teams.
Assisted to build analytic tools to manage data and streamline data analyses using Python and SQL.
Complex incoming data cleaning and formatting using Python.
Ensured data accuracy through the creation and implementation of data integrity queries.
Prepared scripts to ensure proper data access, manipulation, and reporting functions with R programming languages.
Using tableau 10.x tool to achieve data report, analysis result visualization etc.
Provided technical assistance for development and execution of test plans and cases as per client requirements.
Assisted to build analytic tools to manage data and streamline data analyses using python and SQL.
Supported technical team members in development of automated processes for data extraction and analysis.
Participated in learning of techniques for statistical analysis projects, algorithms, and new methods.
Working in AWS EC2 to maintain database and cronjob.
Rent at Kent Dec 2012 – Jan 2014
Database Administrator Assistant Kent, Ohio
Extensively worked on writing SQL queries Audit support.
Responsible for gathering business requirements, writing technical specifications such as scope, process, and alternatives.
Designing, developing, amending, optimizing and certifying database designs to satisfy client needs.
Executed quality control checks in the form of SQL queries to ensure data integrity and enforce business rules.
Performed data validation by developing and executing test plans and supporting user acceptance testing.
Created visualization dashboards for more than a dozen online reports helping company identify opportunities to make benefit.
Designed implemented and maintained the company's Oracle 11g database.
Developing modules in python and performing CRUD operations in MySQL.
Managed research-on-demand and data support for domestic and international clients.
Economic Development Data Services Jan 2012 – Sep 2012
Data Entry Kent, Ohio
Integral part of team throughout data gathering, data analysis framework involving data cleaning, processing, analysis, and visualization.
Conducted a range of statistical analyses to provide valuable data-driven insights for business decision making.
Worked use Excel technology of accounting information system.
CERTIFICATE:
Oracle Certified Associate, Java SE 7 Programmer
Contact this candidate