Summary
Overview
Work History
Education
Skills
Certification
Software
Work Availability
Quote
Timeline
Generic

Rahul Raphael

Data Analyst
Bangalore

Summary

Analytics & Business Intelligence professional with 9+ years of experience as a SAS Programmer and Reporting Analyst with Advance level certifications in SAS (Base, Macros, SQL) and Predictive Business Analytics with experience in data visualization. Extensive experience in ETL processing of Data and data life cycle, Process re-engineering and Automation in retail campaign management, retail banking, marketing campaign targeting and evaluation

Overview

9
9
years of professional experience
4
4
years of post-secondary education
5
5
Certifications

Work History

Senior Data Analyst

Citi Bank
Bangalore
01.2018 - Current
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden inferences within data.
  • Interpreted business questions and collaborated with engineering teams to identify data sources.
  • Leveraged text, charts and graphs to communicate findings in understandable format.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Created and automated data visualizations to present insights and tell compelling stories.
  • Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
  • Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
  • Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
  • Optimized system and platform performance capabilities in most efficient, practical way possible.
  • Researched and compiled tailored monthly analytics and reports for senior management

Data Analyst

HSBC
Bangalore
03.2017 - 01.2018
  • Restructuring codes and processes of legacy reporting structures
  • Automating process of data extraction and transformation through SAS for reporting purpose on Qlikview.
  • Supporting all team members (On-Shore and Off-Shore) for any SAS requirement.
  • Analyze credit lending portfolios for different regions and sectors based on RWA and Probability of default and design KPI reports
  • Alert business of riskiness of lending in particular region and sectors.

Consultant

Equifax
Bangalore
03.2016 - 03.2017
  • Process restructuring for improving efficiency and reducing manual effort.
  • Developed automated SAS projects to extract data from different data sources, dynamically according to type of campaign, which enabled team to evaluate 36 campaigns per month instead of 15 campaigns within 7 months’ time frame.
  • Implemented QA checks within program to identify deviations/data quality/errors.
  • Designed and implemented workflow for multiple SAS project which Reduces error rate
  • Developing inferences and insights around customer behavior and profitable growth scenarios.
  • Monitor customer portfolio/ product portfolio profitability & other key performance indicators in order to recommend strategies that align with business objectives for profitable growth.
  • In-depth analysis of campaign through different channels and different products offered by bank.

Senior Associate

WNS Global Services
Gurugram
02.2013 - 02.2016
  • Performance Evaluation of marketing campaigns through Data Analytics
  • Target customers based on their basket segmentation, customer segmentation, frequency analysis Impact analysis of any marketing campaign across various customer segments
  • Make recommendations to improve customer experience across the entire business.
  • Proposing solutions to the client for new client acquisition and customer retention strategies
  • Ensuring the quality of all other team member’s work is in line with the quality standards
  • Exploring innovations/restructuring in processes to reduce runtime and manual effort

Education

Bachelor of Commerce - Financial Accounting

Maharaja Sayajirao University
Vadodara
05.2008 - 03.2012

Skills

Data Mapping

undefined

Certification

Base SAS Certification for SAS9

Software

SAS Base 9

SAS Enterprise Guide 42

SAS Data Integration Studio 42

SAS Management Console 42

SAS Information Map Studio 42

SAS Web Report Studio 42

SAS BI Dashboard 42

SAS OLAP Cube Studio

SAS Viya

Tableau Prep

Tableau Desktop

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

The real test is not whether you avoid this failure, because you won’t. It’s whether you let it harden or shame you into inaction, or whether you learn from it; whether you choose to persevere.
Barack Obama

Timeline

Senior Data Analyst

Citi Bank
01.2018 - Current

Data Analyst

HSBC
03.2017 - 01.2018

Consultant

Equifax
03.2016 - 03.2017

Predictive Business Analytics

03-2015

Senior Associate

WNS Global Services
02.2013 - 02.2016

Base SAS Certification for SAS9

11-2012

Advance SAS Certification for SAS9

11-2012

Business Intelligence Content Developer for SAS9

11-2012

Business System Information Management

03-2011

Bachelor of Commerce - Financial Accounting

Maharaja Sayajirao University
05.2008 - 03.2012

Similar Profiles

CREATE PROFILE
Rahul RaphaelData Analyst