Kaustubh More

About Kaustubh More

Performing Data Pre-processing using Python/SAS based on the nature of the source system. • Performing statistical analysis, data mining and retrieval processes on a large amount of data to identify trends related to Defaulting prediction model, figures and other relevant information using SAS and python. • Analysed Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions. • Performed due-diligence with the existing data in data warehouse, Generated ad-hoc SQL queries using joins, database connections and transformation rules to compare and evaluate the prediction models. • Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges. • Extracted data from the databases (Oracle and SQL Server, FLAT FILES) using Informatica to load it into a single data warehouse repository. • Scraped and collected data by using python package processed and cleaned raw data from a wide variety of financial websites, transformed and converted unstructured data set into structured data products using multiple functions in pandas. • Automated the process of web login and extraction of financial data using selenium web driver and associated libraries in Jupyter notebook as well as PyCharm.

Experience

1. Data Analyst

   UnitedHealth Group

   Jan 2019 — Present · Houston, TX, US

Education

• Binghamton University

  Master's degree

  2017 — 2018