Data Analyst Assistant

Neha Kansal 424-***-**** adgzko@r.postjobfree.com

Data Analyst

Linkedin

Objective

I am a Data Analyst / Business Analyst with a valid work permit in the US. I’m looking for a role that involves working with data and applying statistical tools and techniques to create a positive impact on the company’s business.

Skills

Statistical / ML : Hypothesis Testing, A/B Testing, Predictive Modeling, Linear Regression, Logistic regression, Decision Tree, Random Forest, Clustering Tools / Libraries : SQL, Tableau, NumPy, Pandas, scikit-learn,seaborn, Python, R, SAS, Matlab, MS Excel

Experience

UC Davis Tableau Specialization (Jul 2020 - Sep 2020) Covid19 : Published a report demonstrating the relationship between the mask usage in every county of US with Covid19 reported cases in Tableau. I collected the data, cleaned it and performed exploratory analysis to finally present it in interactive stories on tableau. Created maps to show reported cases and deaths with colour intensity and size to present more cases. Created colour contrast to differentiate top and bottom counties.

(Link : Covid19 : Wearing Mask Save Lives)

Accenture Digital Consulting- Data Analyst (Aug 2017 - Nov 2018) Worked with multiple clients based out of the USA on predictive modeling,machine learning algorithms and time series forecasting.

DTE : Worked on a successfully converted Proof of Concept for multi million valued ID fraud detection. Conceptualized and collected data for red flag alerts of fraud within the system basis an exploratory analysis performed using 40+ variables. Model was based on the Random Forest technique and had a fraud prediction accuracy of 74%and non fraud detection accuracy of 98%

AT&T : Associated with Bayesian Belief Network R&D and design of code for the model. Developed deeper understanding of market mixed modelling

Ross Dress for Less : Long term sales forecasting using exponential smoothing for inventory planning. Focus areas involve the history creation of new products and stores, store relation optimization and revamp of service level agreement. 2

Axis Bank HQ (Mumbai, India) - Data Analyst,Modelling team,Risk (Jun 2015 - Jul 2017) Worked on projects on Data cleansing, data analysis, machine learning model and model validation to reduce the credit risk for the bank.

Early Warning Signal : EWS Model rebuild and monthly run for LCMC,SME and channel finance companies.Automation of EWS model in SAS and MS Excel hence reducing run time by 90%.Integrated conduct parameters of EWS model with Quick rating tool (QRT) to improve performance by 9%. Model validation using Gini and IV analysis

EWS end-to-end analysis and Red Flag Accounts(RFA): Improved model efficiency by 10% for current EWS model by applying overlays.Analyzed model prediction to actual default duration of NPA & restructured accounts.Analysis of RFA accounts triggered by financial, external & account related factors

SME Portfolio analysis : Analysed delinquency trend of all SME customers at Pan-India Level. Analyzed the slippage of better rated customers into EWS category from FY15 - CFY. Overall rating mix trend over the last 2 successive years. Shiv Nadar University, India - Research Assistant, Development Economics (Aug 2014

-Dec 2014)

(Course Instructor : Dr. Gitanjali Sen,Ph.D,University of Columbia) Shiv Nadar University, India - Teaching Assistant, Principle of Macroeconomics (Jan 2014

-Jun 2014)

(Course Instructor : Dr. Suchismita Tarafdar,Ph.D,Arizona State University) Education

2013 -2015

Shiv Nadar University, Greater Noida - MS Economics(7.6 cgpa) 2010 -2013

Delhi University, Delhi- BA(H) Economics(59%)

Certificate Courses

Specialization in Data Visualization with Tableau (UC Davis) Base SAS certificate course from SAS Institute (India) Matlab Onramp from Mathworks

Contact this candidate