Preeti Prajapati

------------------------------------------------------------------------------------- Tools and skills: Python,Golang, Google Cloud Platform (GCP), Big Query, SQL, Gerrit, Jenkins

• Created pipeline to upload and manage visual assets to ApertureDB. ApertureDb is a unique, specialized database for visual assets. It stores and manages images, videos, feature vectors, and associated metadata. All of the data is stored as a knowledge graph to capture internal relationships which allow for complex visual searches. ------------------------------------------------------------------------------------- Tools and skills: Python, SQL, Google Cloud Platform (GCP), Big Query, Airflow, Google Cloud Composer, Data Pipeline, Graph Database, Knowledge graph

Quality Information Systems team at HP Inc diligently works to make quality a strategic advantage for HP personal systems. It collaborates with other internal teams to help HP deliver a better customer experience at a lower cost. • Utilizing natural language processing (NLP) and Machine Learning to analyze reviews arriving from disparate sources. • Developed several analytics dashboards in Tableau to perform root cause analysis and early detection of issues. ------------------------------------------------------------------------------------- Tools and skills: Machine Learning, Natural Language Processing (NLP), Sentiment Analysis, Multi-class classification, Data Visualization, Tableau, SQL, Python (pandas, numpy, scikit-learn, seaborn, matplotlib, nltk, sklearn pipeline), SAS Base Programming, SAS Enterprise Miner, SAS Enterprise Guide

Through its unique and advanced programs, research, and services College of Education (TTU) equips future educators to adapt to the rapidly evolving unique demands of 21st century. • As part of the IT team, I worked closely with professors and other stakeholders to understand their unique requirements, brainstorm solutions, build prototypes, designed and developed web applications. • Maintained databases and performed data analysis on academic data. ------------------------------------------------------------------------------------- Tools and skills: ASP.net, SAS Base Programming, SAS Enterprise Miner, SAS Enterprise Guide, SQL Server Management Studio

Infosys provides technology and consulting services to its clientele spread worldwide. • Designed & developed custom applications using Java, PERL, CGI, Oracle, HTML, JavaScript, CSS, etc. • Performed automation and manual testing on investment accounting projects for replacing legacy systems with Eagle automation systems for processing, servicing, and maintaining accounting details of the Customers’ Portfolios. ------------------------------------------------------------------------------------- Tools and skills: Java, SQL, PL/SQL, Oracle, TOAD, Perl, CGI, UNIX, HTML, JavaScript, CSS, VB Script, Manual, and automation testing.

Data Science Certification that covers data mining, visualization, wrangling, and analysis in Python, statistical modeling, and machine learning techniques. Capstone 1: Richter's Predictor: Modeling Earthquake Damage https://www.drivendata.org/competitions/57/nepal-earthquake/page/134/ Capstone 2: YouTube Comment Analyzer (NLP) Tools: NLTK, Pandas, Spacy, Streamlit, YouTube API There are almost no text-analytics is available in the YouTube studio about the comments section yet. Also, the YouTube studio can only be accessed by the channel owners. With this project, I aimed to fill this analytics gap. • Built a machine learning pipeline to collect YouTube comments by calling YouTube API and classify them into positive/negative and Spam/non-spam categories. • Along with that, it extracts top key phrases, by performing Noun Phrase chunking, to provide the context of comments without having to read the full text. • Created an interactive app to perform the analysis in real-time.