Data analyst / Business Intelligence developer

Jairaj Bhatt

+1-510-***-****; ***************@*****.***; https://www.linkedin.com/in/jairaj-bhatt

EDUCATION

The University of Texas at Dallas May 2021

M.S. Information Technology and Management GPA 3.9/4.0 Shri Vaishnav Institute of Technology and Science June 2017 B.E. Electronics and Communication GPA 7.87/10

TECHNICAL SKILLS

Programming: Python (NumPy, Pandas, Matplotlib), Java, C, HTML Analytics Tools: SAS Enterprise miner, Tableau, Power BI, MS Excel Machine learning: Decision tree, Clustering, Neural Networks, Recommendation systems Statistical Analysis: Hypothesis testing, Probability distributions, Regression Analysis Databases: Oracle SQL, MySQL

BUSINESS EXPERIENCE

Tata Consultancy Services, Pune, India November 2017 – June 2019 Systems Engineer

• Developed a java-based tool to automatically synthesize SQL queries based upon MS excel reports for data migration purposes which resulted in elimination of redundant tasks and increased team efficiency by 50%.

• Generated reports for server utilization statistics pertaining to 4 product lifecycle management applications deployed at 10 global locations which were further used in decision making for resource allocation purposes

• Maintained 97% service level agreement compliance for technical support and administration of 4 software applications responsible for data processing

ACADEMIC PROJECTS

Interactive Dashboard for cost variation analysis:

• Utilized Tableau to design an Interactive dashboard for analyzing the price variation of various food products over 8 different countries around the world

• Explored and visualized crowd-sourced price data-set created by world bank and created numerous story points, graphs and trends for dashboard design

Energy Industry threat analysis:

• Determined top 4 natural disasters impacting five refineries located in four different states in US using tableau maps visualization while using Python to clean the data-set Sales Data Analytics using SAS enterprise miner:

• Analyzed association rules related to online retail sales dataset using SAS data mining features

• Developed insights for product bundling strategies based upon confidence and lift parameters Database Modelling and Report generation:

• Designed a database management system by cleaning and normalizing raw and unstructured data using Oracle SQL developer for Dallas county animal shelter

• Generated several reports using SQL queries to observe various trends such as breed survival rate, animal intake rate etc.

COMPETITIONS, LEADERSHIP EXPERIENCE & ORGANIZATIONS Information and Analytics Society, UTD – Member August 2019 – Present Biz Emendo, Tata Consultancy services – Organizer November 2017 – February 2018

Contact this candidate