HEMANGI JANARDAN MHATRE

Peoria, IL - 309-***-**** - adc2vg@r.postjobfree.com - linkedin.com/in/hemangi-mhatre

SUMMARY

A recent computer science graduate with 3+ years of IT experience working as a Software Engineer in a fast-paced Healthcare IT industry. A fast learner with strong management and multitasking skills. Extensive troubleshooting and problem-solving skills with an analytical mindset. Strong knowledge of data analysis and RDBMS concepts and experience working with various relational databases like Oracle, SQL Server, and MySQL. Passionate about working with large amounts of data and to turn this data into information, information into insight and insight into business decisions.

EMPLOYMENT HISTORY

Western Illinois University Department of Economics & Decision Sciences 04/2020- Current

Data Science Intern

Skills used: Data Wrangling, R, Python, Data Cleansing, Data Mining, Microsoft Office, Data visualization, Data modeling

Assist the director in preparing information related to the research using different datasets.

Transforming data within large data sets using extractions, parsing, joining, standardizing, augmenting, cleansing, consolidating and filtering to create the desired wrangling outputs that can be leveraged downstream.

Dive in and work with the director to develop new data-centric products involving new and innovative algorithms using R and Python technologies.

Perform analysis and develop analytical models to improve a large amount of data into information, appropriate for further data analysis.

Provide data modeling, mining, pattern analysis, data visualization for the research data.

eClinicalworks (Mumbai, India) 04/2014-07/2017

Software Engineer

Skills used: SQL, MYSQL, SSIS, SSRS, ETL, JAVA, Healthcare data standards, Apache Tomcat, SAAS, VPN, Cloud computing, Data migration, Regression Testing

Develop and manage data and/or databases of patient’s health records.

Great contribution to the overall company profit by 8% by working on Interoperability project.

Write advanced SQL queries based on requests and requirements to validate patient data.

Develop and implement MSSQL/MYSQL Queries for inter-departmental ad-hoc data requests for optimal performance of HL7 interfaces (Lab, ADT).

Analyze CDA based message formats (CCD), HIE profiles (PIX/PDQ, XDS) and Consent strategies using SQL queries with stored procedures, views, and OLAP functions.

Work on the SDLC (Software Development Life Cycle) and execute projects in Waterfall and Agile methodologies.

Acquire data feed from multiple EMR systems: Epic, Cerner, Meditech, etc. and manage databases for the Interoperability system. Manage, and resolve errors in the HIE error queue as part of production control using SQL queries.

Lead role in designing test scripts and testing plan that was adopted across the team.

Locate and define new test scripts, verified the actual result with the expected result and report bugs in case of mismatch using JIRA.

RELEVANT SKILLS

Database system: SQL, Oracle, MYSQL, TSQL

Python-Matplotlib, Pandas, Numpy

Data analysis: SAS, Data Visualization: R, Tableau, Power BI, Microsoft Excel

Database management systems: Relational

ETL, Data design and Implementation, Data Modeling, Data mining and Data Cleaning

Machine Learning: Analysis, Linear and tree-based models, neural networks, Clustering

Microsoft Office

EDUCATION

Master of Science in Computer Science, Western Illinois University, Macomb, IL.

December 2019

Bachelor of Engineering in Information Technology, University of Mumbai, Mumbai, India.

May 2013

ACADEMIC PROJECTS

Data analysis of Chronic disease and health Promotion data, May 2019

An Interactive model to show the data analysis of the healthcare data provided by the Centers for Disease Control and Prevention (CDC), Division of Population Health, Epidemiology and Surveillance Branch. Used R programming for this analysis.

• Created Regression Models for 3 different data. Also, Designed model analysis, and residual plot for the same. Interpreted the coefficients of the best model out of those models.

• Using Shiny, created an interactive application that allows users to interact with the model.

• Modified this interactive model by including information about the data, the source of the data and an interpretation of the coefficients of the model created for the interactive visualization.

A database application for intergalactic military forces, May 2019

A JDBC application to hold the information about all the military forces scattered in different regions of the galaxy. Includes Include planets, military bases, troop units, history of troop movements, spacecraft of various categories, heavy weapons on spacecraft, as well as information about rebels and their movements. Also, I have developed a Graphical User Interface to get the information on one click.

• Designed an ER diagram and developed a relational database schema.

• Maintained SQL scripts, indexes and complex queries for analysis and extraction.

• JDBC code for the GUI to get the database information/records easily.

An ETL project for Chicago Crime Report, October 2019

Using Dataverse by Lavastorm created crime statistics reports to find out an exact number of robberies that took place in each district of Chicago and the latest 100 burglaries in the residential area of Chicago. These reports help in public safety and can help law enforcement with operational and resource allocation. The crime dataset was obtained from the city public records which were then used for data analysis and transformation to give meaningful crime statistics.

• Spearheaded the entire operation from data set collection to final report outputs.

• Created a step-by-step technical document on how to use tools provided by Lavastorm Dataverse for report creation.

Contact this candidate