Kapil Bhadre | SAS Programmer & Data Analyst

About Me

Professional SAS Programmer & Data Analyst

I am a highly skilled SAS programmer and data analyst with extensive experience in clinical and banking domains. My expertise includes advanced SAS programming, data modeling, and creating insightful business intelligence reports.

Name:

Kapil Ramrao Bhadre

Email:

kapil.sas9@gmail.com

Phone:

+91 8149717453

Location:

Nanded, Maharashtra, India

Technical Skills

SAS Programming 95%

SAS Macro 90%

SQL 85%

Advanced Excel 80%

Python 70%

My Experience

Team Member - Business Intelligence Unit

Aditya Birla Capital Ltd (ABFL)

Aug 2019 - Present

Identify patterns and gaps in customer information and report to business verticals for effective tagging and retrieval to maintain data quality.
Analyze data profiling and impact assessment from various sources, and maintain data marts for future enhancements.
Created innovative dashboards that are user friendly and enable the achievement of business objectives.
Developed Retail Risk Dashboard: A single, comprehensive report that tracks retail business growth and provides valuable insights for senior management and investors.
Responsible for generating and retaining CIBIL trigger leads daily, identifying potential customers and converting enquiries into sales.
Delivered reports in line with regulatory requirements, identifies ways to improve report creation efficiency using SAS/SQL/Adv Excel.
Prepares RBI Sectoral classification Report to ensure NBFC investment in a diversified portfolio, minimizing delinquency risk.
Developing skills in SAS Viya, Power BI and Python.

Assistant Manager

Citi Bank (CSIPL Chennai)

Sep 2017 - Aug 2019

Used advanced data analytics to create personalized offers for customers at the right time and channel.
Ensured high-quality, error-free, and timely execution of campaigns.
Collaborated with technology, business, and marketing teams to understand requirements and build programs for new campaigns.
Developed SAS codes and campaign segmentation using database joins and selections.
Executed marketing campaigns using SAS and tracked performance with the campaign tracking team.
Managed Data Quality including Data profiling, impact assessment from varied data sources.
Worked closely with Big Data Platform team, the Modeling team, Campaign Design Team and Delivery team.

Senior Analyst

Scope International India Ltd.

Jun 2016 - Sep 2017

Developed, tested and implemented reports and supplemental processes to support reports for Consumer Risk Management.
Utilized SAS, SAS-SQL, Microsoft Excel and VBA Macro for reporting needs.
Managed monthly scorecard & incentive calculation report for employees in the Collections department.
Compiled, maintained, and distributed Collection's reporting including Daily, Weekly and Monthly reports.
Responsible for overall efficiency of the Retail Risk Shared Services and forecasting process.

Senior Process Associate (Business Analyst)

Tata Consultancy Services

Apr 2015 - Jun 2016

Developed SAS programs for tasks assigned by lead Statistical Programmer.
Performed development and validation of datasets, tables, listings and figures.
Prepared data derivation specifications as per the defined standards guidelines.
Maintained full understanding of study documentation and complied with ICH-GCP guidelines.
Developed Study level macros as directed by Lead Statistical Programmer.

My Projects

Retail Risk Dashboard

A comprehensive dashboard tracking retail business growth with valuable insights for senior management and investors.

SAS SQL Advanced Excel

CIBIL Trigger Leads System

Automated system for generating and retaining CIBIL trigger leads daily to identify potential customers.

SAS SQL Data Analysis

RBI Sectoral Classification Report

Report ensuring NBFC investment in a diversified portfolio to minimize delinquency risk.

SAS Regulatory Reporting Risk Analysis

Comparative Study of Ajanta Brands Company

Statistical analysis of seasonal variations of distinct phenyl products using Time Series Analysis to forecast future values.

R MS Excel Time Series Analysis

My Education

M.Sc. in Statistics

School of Mathematical Sciences, S.R.T.M. University, Nanded

2014 | 60.04%

Specialized in statistical analysis, data modeling, and advanced statistical techniques.

B.Sc. in Mathematics, Statistics and Computer Science

Netaji Subhash Chandra Bose College, S.R.T.M. University, Nanded

2010 | 61.3%

Triple major program covering advanced mathematics, statistical methods, and computer programming.

Intermediate (H.S.C) Science

V.N College Nanded, Latur Board

2007 | 61.17%

Physics, Chemistry, Mathematics, and Biology stream with strong foundation in scientific principles.

S.S.C

S.A.S High school, Mukhed-Nanded, Latur Board

2005 | 66.80%

Secondary school education with focus on core subjects and foundational knowledge.

Hi, I'm Kapil Bhadre