Data Analyst Assistant

HIMADRI SEKHAR DEBNATH

* ****** **, *******, *******, NJ 07030 210-***-**** ***************@*******.*** PROFILE

Data analyst with 3+ years of experience in delivering end to end data product solutions. Analytical Platforms: SQL, R, Python, SAS(Certified), Scala, Hadoop, Hive, Apache Spark, Tableau, MS Excel Real world experience with: Exploratory Data Analysis, Cluster Analysis, Segmentation, Regression Analysis, Decision Trees, Multivariate Testing, Univariate Testing

PROFESSIONAL EXPERIENCE

Data Analyst, BDI Plus Inc. June 2017- Present

Greater New York City

• Initiate, develop and work data audits, by collecting and reviewing all requirements and ensuring the correct information and data are prepared for team lead.

• Advanced level knowledge of SQL – indexes, normalization, schemas, stored procedures, and triggers

• Sound understanding of Modeling concepts

• Developed Key Performance Indicators and scorecards to monitor product sales and operations of vendors and fulfillment centers.

• Build financial and travel data models corelating business objectives for a client pitch to generate business through partnerships. [MySQL, Python, Tableau]

• Designed test cases for product validation applying ML algorithms viz., Random Forest, K-Means, Logistic Regression

• Developed a dashboard for real time tracking of data feed generation to track anomalies. [Python Plotly]

• Increased efficiency by identifying multiple new opportunities to create self-service tools for the marketers, data aggregation in SQL, dashboard delivery in Python.

Business Research Assistant, Institute for Economic Development August 2016 – June 2017 San Antonio, TX

• Used statistical techniques for hypothesis testing to validate data and interpretations [R, MS Excel, SAS]

• Created a dashboard by analyzing trend from demographic and income data, identifying areas to aid the San Antonio City Council to effectively allocate funds for development [MySQL, Python, Tableau]

• Successfully performed data analysis and interpretation and drawn conclusions for managerial action and strategy [R, MS Excel, Tableau]

• Suggested ways to bring high vulnerable population into active economic activity leveraging San Antonio City Council's development efforts

• Conducted data analysis using logistical model, KNN, tree classification and random forest method to identify high readmission risk patient and improved the accuracy (C-scores) by 30%.

• Sound knowledge of using version control tools like Git and scripting using Bash

• Developed a GUI interface for an open source tool to monitor data quality. [Python] Assistant Manager, Corporate Business & Asset Management July 2011- June 2014 Corporation Bank, Regional Office, Kolkata, India

• Restructured the region’s overall asset investment strategy securing a growth of 68% from non-core business

• Minimized credit default risk and strengthened client relations by advising clients on monetizing low performing assets resulting in a credit growth of 54%

• Developed a model to predict average default time of customers to assist branches to reduce account slippage by 22% [Advanced MS Excel, SAS, Linear Regression]

• Prepared an Action Report to reduce irrelevant expenses, resulting in savings of at least 19% [MS Excel] EDUCATION

Master of Science (MS), Computer Engineering August 2014 – May 2016 Valero Research Scholarship

University of Texas, San Antonio

Contact this candidate