Data Analyst

Dhruman Jayesh Shah

+1-217-***-**** adhozl@r.postjobfree.com LinkedIn: Dhruman Shah

EDUCATION

University of Illinois at Urbana Champaign, IL Aug 18 – May 20 Master of Science in Information Management GPA: 3.86/4.00 Relevant Courses: Data Warehousing & Business Intelligence; Applied Business Research; Health Data Analytics; Data, Statistical Models and Information; Sociotechnical Systems; Information Modeling; Competitive Intelligence & Knowledge Management University of Mumbai, India Aug 14 – Jun 18

Bachelor of Engineering in Information Technology GPA: 8.11/10.0 Relevant Courses: Data Structures & Algorithms, Data Mining & Business Intelligence, Advanced Database Management Systems SKILLSET

Languages : Python, R, SQL, JavaScript, JQuery, HTML, CSS, Cytoscape.js, JSON Tools : Tableau, PowerBI, MySQL, Oracle 11g, AWS (S3, EC2), Github, PostgreSQL PROFESSIONAL EXPERIENCE

CHIME in Illinois Jul 20 – Present

Data Analyst

• Generating actionable insights for effective decision making through data visualizations on a Tableau dashboard

• Defined key metrics to track the impact of COVID-19 on the healthcare infrastructure through requirements gathered by conducting informational interviews of stakeholders involved with Champaign-Urbana Public Health Departments

• Improved accessibility and reduced update time by 50% using Boto3 to fetch data from disparate sources into AWS S3

• Developed robust and reusable data pipelines working closely with data engineers, using Python libraries and SDKs Illinois Business Consulting

Senior Technology Consultant Jan 20 – May 20

• Devised a strategy for implementing data governance policy in a mid-sized bank while leading a cross-functional team of 7

• Identified pain points in the current database systems by interviewing stakeholders at different levels of the organization

• Improved data quality by 15% by defining key metrics for assessing completeness, accuracy, validity and inconsistency Senior Consultant Sep 19 – Dec 19

• Assessed the product-market fit for a startup client through primary and secondary research for entering a $15bn market

• Advocated a viable 3-year business plan focusing on business growth and securing venture capital funding Business Intelligence Group Aug 19 – Dec 19

Consultant

• Conducted market feasibility analysis for an insurance firm to assess potential entry in $81bn autonomous vehicle sector

• Recommended a market entry strategy including a viable business model, customer segmentation and ideal collaborators

• Predicted a 16% drop in premium rates using information collected from OEMs and autonomous vehicle manufacturers Corteva Agriscience Jun 19 - Dec 19

Data Visualization Intern

• Developed an interactive web-based visualization tool using front-end tools like JavaScript, HTML, CSS and Cytoscape.js

• Prioritized the interactive features to be incorporated in the visualization by analyzing data from user experience studies

• Reduced 10-man hours per week for the systems biology team by optimizing the performance of the dynamic reports

• Helped discover new product opportunities by identifying relations between graph nodes on the visualization tool ANALYTICS PROJECTS

Analytics tool for E-commerce data MySQL, Python, Tableau

• Built an ETL pipeline that preprocessed the data using data mining techniques on python and loaded it in MySQL database

• Created tables and joined multiple datasets using SQL queries to build a normalized dataset for building visualizations

• Loaded data from MySQL into Tableau to create reports for providing actionable insights about customer activity WHO Mortality Dataset Analysis Python, NumPy, Pandas, Matplotlib, Seaborn, statsmodel, Github, Jupyter Notebooks

• Transformed a large incomplete dataset (6 million rows) using data wrangling techniques to create a data frame consisting of demographics, geographical data and mortality rate pertaining to bronchitis and tuberculosis

• Built a time series VAR model to forecast the number of deaths with a mean absolute percentage error (MAPE) of 8.22%

• Performed feature engineering and hyperparameter tuning to optimize the performance of the model Social Development Trends of the World Tableau Prep, Tableau Desktop

• Refined and cleaned the data using Tableau Prep to create various workflows for data pre-processing

• Designed various interactive Tableau dashboards to show insights related to social development trends of the world

• Published the dashboard on Tableau Server showcasing the trends in developing countries pertaining to factors like unemployment, literacy rate, child labor, poverty rate and gender