Data Analyst 2

VIKRANT GAWDE

P: +1-615-***-****, E: *******.*******@*****.***, LinkedIn: www.linkedin.com/in/vikrant06 WORK EXPERIENCE:

Healthcare Analyst 2 - Predictive Modeling November 2018 -Present BlueCross & BlueShield of Alabama

● Develop experimental and analytic plans for data modeling processes, use strong baselines to accurately determine cause and effect relationship

● Use data mining, machine learning, and statistical techniques to drive new insights and share learnings with Senior leadership to make informed decisions

● Own end to end lifecycle of Data Science projects like Identifying High Dollar Claimants & Predicting Gaps in Care

(Data collection - Scrubbing - Exploration - Modeling - Interpretation - Ingestion into current clinical workflow)

● Architect and build an environment for the data science team to explore and access data, build, train and productionize data science models and easily share analysis

● Support creation of Data Mart Design and development which houses data specifically curated for the analytics team. Data Analyst January 2018 - November 2018

Hospital Corporation of America (HCA Healthcare)

● Train and fine-tune healthcare models that make use of electronic health records (EHR).

● Build models for specific use cases and deploy them to production. Example: Predicting number of falls in an ICU

● Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

● Identify, analyze, and interpret trends or patterns in complex data sets Data Architect Intern June 2017 - September 2017

Health Catalyst

● Fetch and manipulate healthcare and finance data using R and SQL to eventually perform Dimensional modeling and exhaustive analytics to make informed decision for healthcare departments

● Design, develop and deploy data marts for Health Catalyst where tasks involve providing comprehensive data warehousing solutions for healthcare systems.

EDUCATION:

Rochester Institute of Technology, Rochester, New York Master of Science (MSc) - Information Science and Technology, 2018 Narsee Monjee Institute of Management Studies, Mumbai, India Bachelor of Technology(B.Tech) Computer Science, 2016 PROJECTS:

CodeSnips.net full stack web development

https://codesnips.net

CodeSnips is a web application that aims to provide coders/developers (or really anyone looking for programming resources) an environment where they can find code snippets with their explanation. While we have several blogs and selected websites for this content, most of the developers spend a considerable amount of time hunting for the right resources to put two and two together. CodeSnips allows users to sign up, share their own snippets and view other snippets. It has some social networking features like comment on, share and like code snippets. Overtime, with a quality collection of explainable code snippets, we aim to reach a point where searching information with the right content takes dramatically less amount of time than what it takes today. This is undergoing some changes on the backend and production testing. Feel free to sign up and add some code snippets. Tech Stack - Django 3.0, Python 3.8, Elastic Search, Postgres 12, Git, Bootstrap, JQuery Crime Classification in San Francisco predictive modeling/analytics A classification model that would predict and provide hidden insights on the type of crime classification in San Francisco and the factors that govern its output. Various machine learning models like Gradient Boosting Trees, SVMs, and Logistic Regression are implemented and compared.

Predicting Post-Collegiate Earnings and Debts predictive modeling/analytics This project is an attempt to put together a system that will help prospective students escape the soaring cost of higher education accompanied by rise in student debt. Dataset comes from a college scorecard that involves information about degree-granting institutions, the demographics of college students and the status of the alumni of these institutions. Data Modeling using Apache Cassandra for a Music Streaming Startup data engineering Create ETL pipeline and tables for user queries using Apache Cassandra. In Apache Cassandra, the data model is modeled depending on the query needs for fast data retrieval. The use case linked to below shows how a music startup like Spotify can model data using NOSQL. The Jupyter notebook file can be viewed for a detailed walk through of the project starting from the need to create a data model and finally ending with populating all tables using Apache Cassandra. GithHub https://github.com/vxg7583/CassandraDataModeling ETL Pipeline and Data Modeling in Postgres for a Music Streaming Startup data engineering Set up a database pipeline that allows the users of Sparkify (music streaming startup)to be able to easily query data to achieve their analytic goals. As the data currently resides as a bundle of json files, it is not well organized for fetching information for analytical purposes. Hence organizing this data as star schema would make it a lot easier for querying purposes. This project involves designing a star schema, defining fact and dimension tables, building an ETL pipeline to automate the table loading process from source to target. This database is built using Postgres and uses python for ETL pipeline. GitHub https://github.com/vxg7583/PostgresDataModeling Design and implementation of Data warehouse data warehousing/data engineering Performed dimensional analysis and designed a star schema for a data warehouse model for a fictional product company using MySQL Workbench. Performed data integration using Pentaho and performed OLAP operations using SQL and built aggregated DataMart for accessibility of the end users.

Portfolio web application using Django 2.0 and Python3 web development / databases Developed a portfolio website which could provide the user to upload summary information, personal information, projects and jobs. This also allows for uploading blogs having different features. Separate page for uploading pictures. Among other things, this shows resumes, hyperlinks to professional websites. Technology: Django registration module, Outh2, payment integration, static files, model view template. GitHub: https://github.com/vxg7583/portfolio-project CERTIFICATIONS:

● Neural Networks and Deep Learning

https://coursera.org/share/86bf3abadba982566e2df2a2aeada69f

● Machine Learning

https://www.coursera.org/account/accomplishments/certificate/JLQ9NKMSAYZT

● Django 2.2 & Python3 Web Development

https://www.udemy.com/certificate/UC-0WF8TS0I/

● Google Cloud Platform Big Data and Machine Learning https://coursera.org/share/3155b8c704b5f21e78a4257b37ae69ad

Contact this candidate