Senior Analyst
Stratum Analytics LLP
Total des années d'expérience :11 years, 5 Mois
Regression Analysis
ARIMA Modeling, Logistic Regression Modeling
Statistics application
Data Analysis, Data validation, Data management, Data cleaning
Base SAS
Writing Paper on manufacturing industries (India & China).
Project:-
Building approve and decline strategy on the Credit card portfolio and involves MIS to take such as finding statistics (Full information) and Manipulating and extracting data from the data base using SAS codes and processing them based on client requirement.
Develop Logistic Regression Model which will estimate predictive power of it such as
1) Identify the highly correlated variables
2) Execute univariate analysis on variables used in regression
3) Impute missing variables with the either mean / median
4) Cap outlier variables at different confidence interval as per client suggestion
5) Create dummy variables on FICO score
6) Identify the significant variables influencing the bad behavior of the account
Independently developed ARIMA Model for forecasting future sales volume for various products based on history data for the coca cola client.
Responsibilities:
Responsible and accountable for the Analytics business development, project delivery and enhancement of analytics product for all clients in India.
Responsibility for data management, data validation, data uploading (exporting into several formats) and performing the statistical analysis using statistical tools.
Extensively used SAS(Base), SQL (Basic) and MS EXCEL for Data Extraction from Data base, Data Cleaning, Data Validation, Data manipulation, Data Analysis and performing Statistical Analysis on the same based on client requirement.
Provide statistical programming support for data analysis with an emphasis on data step programming and SQL on post marketing studies.
Developed ARIMA Model using SAS for forecasting the sales volume for various products as ad hoc client requests.
Gone through extensive training on Regression Model in theory and SAS as per client requirement.
Active participant in group meetings and efficient communicator of statistical findings with concise analytical reports in a timely and constructive manner that clearly impact direction and progress of the project by providing statistical input and ideas.
Build credibility, establish rapport and maintained communications with colleagues at multiple level.
Maintaining quality and productivity standards for all the projects assigned
Project Name: Model Validation of Oil Co Brand Vantage tri- bureau Acquisition score.
Description: Vantage is one of the best generic score developed by the all 3 US bureau (Experian, Equifax and Transunion). Some segments of the same portfolio has been liquidated or either sold out by the Citibank. The task involved to validate the portfolio with rest of the segment.
Responsibilities:
Prepared the SAS code for extracting the data from the data warehouse and generated the requisite coding structure needed for the tracking the performance of the model.
The present validation result has been compared with the previous validation result and the recommendation has been provided on model performance.
Worked on the automation part of this particular score, prepared the reference dataset which acts as the benchmark for all future validation.
Project Name: Working on the Roll rate and Collection efficiency of the major US PLCC clients (JCP Penny, WALMART, SAMS, GAP INC, LOWES and BELK etc.) in the credit card analytics.
Description: The objective is to show the trends and performance of collection efficiency and roll rate for the period Jan’11-Jul’11 to Jan’12 - July, 12.
Responsibilities:
Extract the data with help of SAS from CDCIp3 dictionary table statement fact using different variable like nbr_mths_due, external_status, special_condition_5, balance_amt, and run the code credit_grade with 2 to 7 due stages
