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, FL05-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
Similar Profiles
ANABELLE BALOTROANABELLE BALOTRO
VP BRANCH MANAGER at Citibank N.AVP BRANCH MANAGER at Citibank N.A
MICHAEL HUMICHAEL HU
PERSONAL BANKER at Citibank N.APERSONAL BANKER at Citibank N.A
Sandra HackmanSandra Hackman
Head Universal Banker at Citibank N.AHead Universal Banker at Citibank N.A