Hello, my name is

Neel Gehlot

Business Analyst | Data Analyst | Business Intelligence

ABOUT
ME
I am an experienced professional with avid leadership and communication skills. Possess technical and real-world business experience working on projects related to Data Analysis, Business Intelligence, Database development and Business Analytics in Insurance, Healthcare and Manufacturing domain. Strong problem-solving skills and dedicated towards providing high-quality results by learning new processes and taking ownership of diverse projects to benefit the team and the company. On a personal level, I am a creative, organized, and precise in my work. I also love sketching, rowing and traveling to new places.

Management & Leadership

Analytic Tools

System Analysis and Design

RESUME

Aon

Data Analyst (August 2018 - Present)

Providing strategic and data analytics support on the casualty insurance claims and working directly with a team of senior consultants and executives. Actively managing, improving, and monitoring reporting tool of the Casualty Analytics report. Gathering client requirements to understand requests, design metrics and dashboards using Tableau and MS Excel. Creating Ad hoc and standard reports to summaries financial and geographical data of clients for review by stakeholders. Responsible for data gathering from a variety of data sources using SQL and web-based portals. Utilizing large sets of data to determine relevant indicators that can be leveraged into trends and insightful information to mitigate risk and total cost of risk. Designed data transformation processes on Alteryx and Python to scale and automate data manipulation.

Legrand North America

IT Analyst Intern (June 2017 - January 2018)

Supported creation and deployment of a variety of information systems for Supply Chain, Purchasing and Sales to streamline business processes. Gathered business requirements and developed project scope by collaborating with key stakeholders. Responsible for planning and prioritizing several projects to deliver them on time in compliance with the quality. Developed operations’ database to improve the reporting process and material transactions of the manufacturing floor. Improved procurement database and resolved technical issues using SQL and Access, making processes more efficient.

Robert A. Foisie Business School

Graduate Research Assistant (March 2017 - May 2018)

Extracted data from the CMS database to design a Healthcare Relational database of cost and quality data points. Leveraged expertise of data mining, data cleaning, and data modeling to support the Healthcare research hypothesis. Constructed multiple views of data and performed market research to fully evaluate trend breaks and find insights. Created and compared different models: Linear Regression, Multilinear Regression, Hypothesis testing using defined independent and dependent variables to identify the relationship between various healthcare metrics. Created data visualization on Matplotlib and Pandas in Python to present and communicate research findings.

Walker Magnetics Inc.

Project Consultant (September 2016 – February 2017)

Worked in a cross-functional team on a mobile app project and acted as a liaison to translate business requirements to the technical team using user stories, use cases, UML and workflow diagrams. Conducted JAD sessions with the stakeholders and collected data to create effective BRD/FRD for smooth functioning of project entities. Worked on designing the app database (ER diagram, Normalization, Data validation, etc.) and writing SQL queries for the app. Prepared functional/ non-functional requirements’ documentation, test plans and project implementation strategies.

Worcester Polytechnic Institute

MS in Information Technology (August 2016 - May 2018)

FORCE Motors ltd

Quality Control Analyst Intern (June 2015- August 2015)

Force Motors Ltd. is one of India's leading commercial automobile manufacturing firm. As an intern, I was involved in a quantitative analysis of quality and reliability failure data of the final products. Assessment and improvement of process capability index to drive performance and adoption of Kaizen. Worked on methodology and procedures of managing an end-to-end process.

Rajiv Gandhi Technical University

BE in Mechanical Engineering (August 2012 - June 2016)

MY
WORK
  • All
I like to work on interesting projects, If you have any project or job opportunity to offer, any questions regarding my work or just want to say hi, feel free to contact me.