We provide IT Staff Augmentation Services!

Data Analyst Resume

3.00/5 (Submit Your Rating)

Nyc, NY

SUMMARY

  • Result - oriented data scientist with 5+ years of IT experience along with outstanding ability of developing solutions along with communication and collaboration across teams
  • Experience in working in a fast-paced team to identify business problems, and determine the data source required to fulfill requirements from clients’ and different function teams
  • Hands o experience handling different types of data and data cleaning, data manipulation and data transformation
  • Expertise in multiple programming languages, and data analytics & visualization tools including R, Python, SQL
  • Experienced in designing and maintaining relational databases using MySQL, MSSQL Server and PostgreSQL
  • Experience of SQL queries on data manipulation using Window functions and sub-queries
  • Experienced in data warehouse and ETL technologies
  • Solid at applying Machine Learning, Deep Learning models and Hyperprameter Tuning
  • Adapt knowledge of big data tools like Hadoop (HDFS, Hive, MapReduce) and Spark (SparkSQL, Spark MLlib)
  • Working knowledge of object and bucket operations on Amazon Web Services S3 and instance operations on Amazon Web Services EC2
  • Strong analytical and creative problem-solving skills as well as the ability to make effective decisions
  • Experience in database schemas designed, data transformation from raw data to designed database schemas, and data cleansing procedures to extract data
  • Experienced in handling and manipulating NoSQL databases using MongoDB
  • Ability to communicate and maintain good working relations with technical team members, and technical and non-technical partners and stakeholders
  • Strong organizational skills along with the ability to handle multiple tasks simultaneously
  • Hands on experience on project management tools such as Jira
  • Experience with Web Scraping, Data Extraction, Cleansing, Visualization, Microsoft Excel PivotTable

TECHNICAL SKILLS

Statistical Modeling: Regression, Classification, Clustering, Predictive Modeling

Machine Learning: Advanced coursework in mathematics and statistics, scikit-learn, TensorFlow, PyTorch

Programming: proficient in Python (with pandas, NumPy, matplotlib), R, and Microsoft Excel; familiar with JAVA, HTML, SQL

Databases: MySQL, Oracle SQL, SQL Server, NoSQL, SAS, MongoDB

Data Visualization& BI: Tableau, PowerBI, Microsoft Excel

Platforms: prior experience with Hadoop, Azure, Pig, Hive, Spark; Airflow, AWS s3, sqs, ec2, Kubernetes, Docker, Databricks, Google Cloud

Operating Systems: MacOS, Windows, Unix/Linux

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, NYC, NY

Responsibilities:

  • Worked closely with engineers to deploy models in production and systematically track model performance, including creating and monitoring the dashboards
  • Performed data exploration and analysis to determine coverage of new data, to evaluate correlation to key business metrics, to determine the importance of various variables and provide recommendations on whether the data source provides incremental value to Sirius
  • Assisted in engagements with key business stakeholders in discussions on business strategies and opportunities
  • Prepared and presented executive summaries of findings and detailed working team communications, with responsive iterations on such presentations based on individual data visualization preferences
  • Preprocessed the review texts by Spark NLP Pipeline of Tokenizer, Lemmatizer and StopWordsCleaner
  • Analyzed the keywords for product reviews and personalized product recommender based on PySpark ALS Algorithm Developed a matrix factorization-based
  • Transformed and automated database with Kubernetes
  • Worked on Hadoop, Hive, Pig and Spark to manage data processing and storage big data applications running in clustered system
  • Applied Natural Language Processing models/tools to automatically analyze the underlying structures of multiple prouct review datasets, in order to better understand the customer feedback/concerms
  • Operated ETL (extract, transform and load) on NoSQL unstructured data
  • Conducted data visualization using Tableau in collaboration with marketing team and product team

Environment: Python, Spark, Kubernetes, Hadoop, Hive, Pig, Tableau

Data analyst

Confidential, NYC, NY

Responsibilities:

  • Explored the data of 9 million observations and performed data cleaning, filtering and merging using SAS and SQL, created potential customer lists under clients’ requirement
  • Recalibrated Decision Tree model with updated data in Python, improved 5% of accuracy comparing to the previous model
  • Worked closely with developers and database administrators to transform data models from logical to physical
  • Generated dashboards with story-telling quarterly business performance interactive dashboards for quarterly summary meeting with Tableau
  • Demonstrated results using charts in Microsoft Excel
  • Predicted the business outcomes such as order volumes by splitting data into training and testing datasets for regression model
  • Identified distinct groups of customers which informed content and marketing strategy

Environment: Annaconda, Jupyter Notebook, Python, SQL, SAS, Tableau, scikit-learn

Data Analytics

Confidential

Responsibilities:

  • Performed data cleansing and standardization using text mining techniques on data collected from Spectrum and VMware to mitigate discrepancies between two data sources during data merging
  • Identified high-risk servers by categorizing servers into groups and targeting those only exist in one of the data sources
  • Collaborated with a cross-functional team from diverse demographic backgrounds and won Innovation Award based on creativity and initiative

Environment: Python, VMware, Microsoft Excel

Data analyst

Confidential, Washington DC

Responsibilities:

  • Experimented with various Machine Learning techniques to predict stock price based on the influence of social media by investigating public sentiment, using Twitter API and text mining techniques, based on over 60,000 rows of data
  • Developed performance hypothesis tests to discover the influential factors and conducted clustering analysis with 3 different methods (Ward, K-means and DBSCAN) and evaluated each method, using Silhouette coefficient as a metric
  • Constructed prediction models including Support Vector Machine (SVN), Naïve Bayes (NB) and Random Forest (RF)
  • Compared the accuracy and selected SVM as the final approach to improve the accuracy from 53% to 67%

Environment: Python, NLP, Web Scraping, Machine Learning, Classification

Data Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Developed leader-follower algorithm to find the connections between nodes with R
  • Worked with stakeholders and technology teams to understand system requirements
  • Partnered with business and technology teams to document, identify and implement solutions to system, risks, defects and data deficiencies.

We'd love your feedback!