Designed and implemented data models and database structures using dbt and Snowflake to optimize data storage and retrievalDeveloped and maintained data pipelines and ETL (Extract, Transform, Load) processes to ensure data accuracy and consistencyCollaborated with data analysts to understand data requirements and transformed data so they have what they needed for reporting purposes

Wrote Python and SQL scripts to identify data quality issues in the Snowflake database and got them fixedUpdated SQL data quality rules on the Github repositoryCreated data dictionary for relational database tables and relational database diagram

550+ hours of hands-on curriculum, with 1:1 industry expert mentor oversight, and completion of 2 in-depth capstone projects. Mastering skills in Python, SQL, data analysis, data visualization, hypothesis testing, and machine learning.Project: Book Recommendation Engine– Built a book recommendation engine using Goodreads dataset that contains six million reader’s ratings for ten thousand books.– Techniques used: user-based collaborative filtering, cosine similarity and matrix factorization. – Statistical methods used: weighted mean, precision and recall.– Python tools used: numpy, pandas, matplotlib, sklearn, cosine similarity and random.Project: Housing Price Predictor– Built a housing price predictor using USA’s King County's house sales dataset that contains over twenty-one thousand home transactions.– Techniques used: data binning, feature selection, r-squared, mean squared error.– Statistical methods used: linear regression, logistic regression.– Python tools used: linear model, numpy, matplotlib, sklearn, seaborn.

Wrote Excel VBA codes to automate some of the data migration and data cleansing tasks.Generated a project plan for a data migration project and kept track of its key performance indicators.Performed data cleaning tasks on records that did not meet with business requirements.

Generated campaign dashboards and reports for field marketing managers.Performed data cleaning on lead's information and scored them based on various criteria to identify potential customers.

Extracted years of historical loan data using SQL queries and performed data quality assessment ensuring them meeting business requirements.Utilized Python to loop through historical loan data and create time-series visualizations.Investigated the relationship among various fields, tables and came up with remediation plans for invalid, inconsistent, or missing data.

Created operational team user guide and trained newcomers on business procedures.Communicated with sales representatives and operational team to resolve any issues regarding merchant’s applications.Reviewed and processed merchant’s applications for funding.Brainstormed and discussed various ways to improve business operational processes.

Used sorting, filtering and data manipulation functions of excel to perform extensive data cleansing.Normalized and optimized the existing database and created SQL queries to extract data.Applied ITIL, Business Analysis, Project management knowledge on various projects.

Generated risk control report using Vlookup, pivot table, and other data manipulation functions.Communicated with different vendors regarding UBS staff relocation dates, status, and kept track of any changes.Monitored incident problem management report and escalated level 2 and level 3 incidents to each action owners.

Worked on various projects to raise funds, to build partnerships and to gain popularity for VisCorps.Taught public speaking workshops and 21 Irrefutable Laws of Leadership.Supervised students throughout the 14 days of leadership training program.

Worked with Program Directors to enhance specific features and elements of Course Hero.Participated in the Course Hero Professional Development Program for weekly lessons on communication, time management, and resume building.Brainstormed ideas with the Knowledge Drive team to develop ways to effectively reach the community.

Researched real estate developers in USA and Canada, created company databases using PowerPoint presentations and Salesforce software for future partnership purposes.Investigated Chinese trademark application process, contacted trademark agents about new corporate logos and advised the company on how to proceed on this issue.Researched and analyzed real estate transaction cases.Developed proprietary research indexes using Excel for international real estate data.Wrote and produced online educational videos for firm marketing and customer attraction.

Promoted public awareness on environmental issues.Taught elementary children about environmental issues such as global warming.Held public lectures advocating people to spend time on Boston Harbor islands.Collaborated with a filmmaker and peers to produce a YouTube film on global warming.