Data Analyst Resume
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.
