Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ninad Mehta

Tampa,Florida

Summary

Experienced analyst optimizing operations, workflow, and production by managing and analyzing large volumes of information. Identifies trends impacting business success. Demonstrated industry expertise. Strategic professional versed in distilling and analyzing large data sets. Develops and delivers presentations detailing data findings. Articulate and collaborative with expertise in algorithm design and data collection.

Overview

7
7
years of professional experience

Work History

Data Scientist - Assistant Vice President

Citibank N.A
Tampa, FL
06.2021 - Current
  • Developed an algorithm in Python for matching web-scraped data of 300+ firms (LFG, PSG, AMG verticals) with Citibank's client data, resulting in the categorization of matches as definite, high/low probability, and no match; implemented and fine-tuned Fuzzy Wuzzy logic for effective string matching while prioritizing efficiency. Currently designing a Tableau Dashboard to minimize dependency on QlikView for the same project.
  • Leading the Tax Recertification Project, preserving valid Tax Status with respect to Data Governance for clients through data pre-processing, collaboration with cross-functional tax and mailing teams.
  • Utilized multiple market intelligence platforms like CapIQ, BoardEx, Wealth-X, Nexis Diligence, Dun & Bradstreet, LexisNexis, Pacer, CSC, and PitchBook to produce polished reports free from errors for Bankers and ABs. Reports were essential for KYC/CIP purposes, as well as EDD/IPO Due Diligence, and Negative Media analysis.
  • Created an offline ticketing system in MS Excel, eliminating the SharePoint site dependency for the internal team.
  • Collaborated with the cross-functional Salesforce team to execute the Summer Splash Campaign, overseeing logistics, organization, analysis, and publication of accurate and efficient data reports.
  • Enhanced prospecting possibilities in marketing and onboarding by providing extensive data through the use of PitchBook/Nexis Dossier.
  • Designed MS Excel Macros to accelerate data preprocessing.
  • Implemented a Power Query within MS Excel, leveraging Microsoft Bing API to geocode client addresses and generate an enhanced street-level dashboard on QlikView. Enables significant insights for clients/prospects.
  • Handled 100K+ data entries to create Client Onboarding Metrics for each region and the Business Manager's team review.
  • Identified salient metrics in terms of benchmarking for Law Firms, created Peer Benchmarks for a comprehensive understanding of peers, and developed a Tableau Dashboard for user accessibility.

Data Science Intern

Fintech
Tampa, FL
01.2021 - 04.2021
  • Developed an algorithm to create a local search engine for suggesting top 10 dashboards based on a user inquiry.
  • Reduced the inflectional form of words into a common base using stemming and lemmatization techniques in Python. Increased the efficiency of an algorithm by 14% using one metric associated with each dashboard.
  • Designed a key metric to improve recommendations using fuzzy-wuzzy scorer methods such as ratio, partial ratio, token sort, and token set ratio. Derived accuracy measures to check the correctness of an algorithm and got 80% accuracy.
  • Developed other methods related to string-matching like DoctoVec, word embedding, RegEx and elastic search.

Data Analyst

Global Technology
, Gujarat, India
09.2017 - 09.2018
  • Developed a Database Management System of insurance claims to find out the KPI’s for its strategic objectives.
  • Designed a logical Entity-Relationship diagram for a better understanding, defined constraints, and relationship using join operations while populating data tables. Performed and conducted complex reporting analytics.
  • Designed optimized queries, interactive dashboards to have insightful reports using MySQL Workbench and Tableau.

Education

Master of Science - Business Analytics & Information System

University of South Florida
Tampa, FL
05-2021

Bachelor of Technology - Computer Engineering

Charotar University of Science Technology
Changa, Gujarat, India.
05-2017

Skills

  • Languages & Database Management: R, Python, C#, C, C, MS Access, SSRS, MySQL Workbench
  • Data Visualization & Business Intelligence Tools: Power BI, Tableau, Microsoft Excel, Qlik, Agile Development
  • Data Mining and Machine Learning: Regression, Classification, Clustering, Deep Learning, A/B Testing, SAS Miner
  • IDEs & Application Server: Anaconda, Jupyter Notebook, Google Colab, Microsoft Visual Studio, Eclipse

Timeline

Data Scientist - Assistant Vice President

Citibank N.A
06.2021 - Current

Data Science Intern

Fintech
01.2021 - 04.2021

Data Analyst

Global Technology
09.2017 - 09.2018

Master of Science - Business Analytics & Information System

University of South Florida

Bachelor of Technology - Computer Engineering

Charotar University of Science Technology
Ninad Mehta