DHARMIL SHAH

Baltimore, MD 667-***-**** adlkag@r.postjobfree.com https://www.linkedin.com/in/dharmilshah95 SUMMARY

Data Enthusiastic with experience working with large datasets, generating, and analyzing data reports for management, developing database procedures for enterprise environment. I am aiming to build analytical solutions around diverse datasets and leverage data tools and technologies which drive data powered costs savings and generate revenue opportunities within organization. EDUCATION

University Of Maryland Baltimore County Baltimore, MD Master of Science in Information Systems (CGPA:3.67) Expected May:2021 University of Mumbai Mumbai, India

Bachelor of Engineering in Computer Engineering (CGPA:3.53) June:2019 TECHNICAL SKILLS

• Languages & Libraries: Python (NumPy, Pandas, seaborn, Scikit-learn, TensorFlow, Keras), SQL, R (Ggplot2, Dplyr, Caret), SAS.

• Databases & Cloud: Oracle 11g/12c, PL/SQL, MySQL, AWS (EC2, S3, Snowflake, Redshift, RDS).

• Tools & Framework: Jupyter Notebook, RStudio, Zeppelin, Tableau, Power BI, Weka, Git, Putty, MS Office (Word, Excel (Pivot Tables / VLOOKUP / Macros / Formulas), PowerPoint, Outlook), Pentaho, Jira, Basecamp, .Net, Visual Studio, Lucid chart

• Coursework: Data Mining, Advance Database Project, Decision Support System, Project Management, NLP, Information Systems. PROFESSIONAL EXPERIENCE

Business Data Analyst Co-Op American College of Nurse-Midwives Silver Spring, MD Aug 2020 - Oct 2020

• Worked on ACNM Session projects to analyze public health data using Power BI, R and produces summary report for monitoring.

• Extracted demographics data through CRM software to create visualizations and developed insights based on different regions to target more people for ACNM events registrations resulted 22% more registrations.

• Lowered the implementation cost to $17k by providing technical solutions with help of Sr Analyst in different phases of Project.

• Functioned in a Scrum Team and gathered Business and Functional requirements by having regular sessions with stakeholders.

• Served as a liaison with other ACNM departments to provide support to their work and program activities. Business Intelligence Analyst TalentHome Solutions LLP Mumbai, India July 2018 - June 2019

• Developed powerful solution-driven centralized BI dashboards for executives by using Tableau, MS Excel to showcase KPI’s and applied advanced data filters that help automate manual work, reduced process time and enhance the reporting efficiency.

• Performed Data Quality Assessment to identify technical & business issues to plan cleansing strategies for multiple databases.

• Conducted product, market, and operational related research to support strategic and business planning across departments by preparing high-level management KPI reports for CEO and other departmental executives.

• Created multiple reports using SAS and MS Excel based on the requirements of the department. Data Engineer Intern Venus Manufacturing Company Mumbai, India Nov 2017 - Feb 2018

• Worked closely with client services and ETL team to understand business needs and developed custom and standard SQL scripts using AWS redshift to respond to reporting requests for JIRA tickets.

• Automated PL/SQL scripts to generate client reports for consumers and delivered them using AWS S3, reducing human efforts by 2 hours per day. Used Pyspark framework for data streaming and preprocessing to automate the real – time client’s data. ACADEMIC PROJECTS

Modeling Predicting Policing Racial Discrimination on Baltimore Crime Data Python Expected May 2021

• Plotting crime incidents on the Baltimore map, generating heat maps and applying Kernel Density Estimation on the density of crime and incident coordinates. Predicting the future possible events and understanding the race and gender distribution among the neighborhoods to possibly establish the fairness in the algorithm. Depression Detection R Oct 2020

• Designed R model in RStudio and analysed important factors, their impact to depression in the human. Used Logistic Regression

& Naïve Bayes Classification, based on statistical analysis identified the best fit line, methods to reduce bias and overfit in model. Maryland Food Chain Opening Power BI May 2020

• Analyzed the best county and food chain to open in Maryland for maximum profits on basis of age, property rates in Power BI . Covid-19 Dashboard Tableau SQL Pentaho April 2020

• Designed Tableau dashboard that shows live death rate, new and recovered rate by fetching data fromPentahousingSQLqueries.

• Automated SQL scripts to report live data using Pentaho to the Tableau for the real time analysis. University Course Registration System Oracle SQL PL - SQL Nov 2019

• Modelled University Course Scheduling relational database architecture for the students, professors for class enrollment, wrote PL/SQL procedures, functions, triggers in Oracle SQL developer to enroll for class, check wait list & prerequisite class. Heart Disease Prediction Python Oct 2019

• Determined the risk and analyzed major factors responsible for heart disease in human by different Machine Learning algorithms.