Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Praveen P

Praveen P

Senior Risk Analyst
Chennai

Summary

An enthusiastic and energy driven professional with 6+ years of experience, with specialization in Data Analysis/ Business Intelligence in the banking domain. Keen Analyst with excellence in gathering and understanding the requirements of clients and stakeholders Experienced in Analysing, Summarizing and Presenting using appropriate SAS Stack A good level of understanding in Banking domain Ability to understand complex data models, and perform necessary transformations in ETL Jobs Evaluate and choose the right technologies & tools to solve given problem Design, Develop and Maintain SAS modules and performing root cause analysis for any functional failures Expert in making Visualizations using SAS Visual Analytics Develop macros and automate complex reports with SAS Macro concepts. Optimize SAS Codes using programming best practices Proficient in handling any SAS function Optimally read & write data from SQL server using pass-through query, ODBC etc. Possess proactive attitude, capability to think in & out of the box; excellent communication, organizational skills with proven capabilities in team management and customer relationship management

Overview

7
7
years of professional experience
5
5
years of post-secondary education

Work History

CClyticx Services Pvt Ltd

Senior Risk Anlyst
Chennai
03.2022 - Current
  • Understanding the offer matrix and making the best offer to the customer.
  • We will finalize the offer for the second look consumers based on the Fico score and risk score and will offer cards such as the Fortiva credit card, Retail Credit, and Aspire Credit card.
  • Provide customer segmentation recommendations for testing and to improve performance based upon email reporting analysis
  • Perform A/B testing on all campaigns to continually improve performance
  • Partner with the Senior Manager, Email Marketing to develop a strategic roadmap for e-mail and retention on initiatives

Data Analyst

CITI Bank
Chennai
04.2021 - 02.2023
  • End-To-End Data Analytics and Business Insights Solution for, Identifies agent execution errors for high-risk processes in real time
  • Comprehensively checks across multiple touch points
  • 100% of the account population is evaluated
  • Currently supports 4 line of business’s – CARDS, AML, UCCB and RECOVERY
  • Tools Used – SAS Studio, AS EG,TECTIA,JIRA and Main frames
  • Share point used as the WFM Tool and Report Outputs
  • Daily Reporting periodicity supported by production runs 365 days a year

Risk Analyst

CClyticx Services Pvt Ltd
Chennai
06.2020 - 03.2021
  • Developed short-term goals and long-term strategic plans to improve risk control and mitigation.
  • Instituted contingency plans, promoting business continuity through cross-training, documentation and data backups.
  • Promoted enterprise-level risk management practices and helped instill strong culture focused on protective policies and procedures.
  • Advised senior managers on policy strategies for reducing liability and preventing losses.

Data Analyst

Indian Bank, OTSI
Chennai
08.2019 - 04.2020
  • Overall Bank Level Summary
  • Identification of Customer count for Un-Utilized amount as per sanctioned by the bank
  • Multiple filters for State and City Selection
  • Summarized values for Amount and % for Previous Date, MTD & YTD
  • First View of overall analysis of spend and Outstanding
  • Card Type Wise Growth % wrt to YOY and MOM
  • Current Month vs Previous month spend behavior
  • Current and Previous FY Spend Growth Representation

Software Engineer

Vara United Pvt Ltd
Hyderabad
11.2016 - 07.2019
  • ICICI Bank is using three different systems (DB-Tracker, I-Track, Omni flow) are using for liability account opening process in this project we have integrated all the three systems data and generated automated reports like RPC wise, Branch wise gross and net rejections, and
  • TAT reports on daily and monthly frequencies
  • Responsibilities:
  • Understanding requirement with taking help from Business analyst or BRS document
  • Extracting data from database thru SQL Pass through query
  • Extracted raw data files like .csv,.txt,.xls by user written code
  • Worked on different types of transformations like extraction, Sort, Transpose, Append
  • Creating user define formats using PROC FORMAT
  • Developed reports using Proc Report, Proc Tabulate, Proc Freq, and Proc Means
  • Enhanced existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results
  • Used Output delivery system extensively to generate reports in html, PDF and excel reports using Proc Report
  • Involving ad-hoc report development
  • Added techniques to capture detail and summary log, used exception handling techniques, Maintain Record of work and make proper documentation for deployment

Education

Btech
Jntu Hyderabad
01.2009 - 12.2013

Skills

Data validation

undefined

Accomplishments


  • Modified and improved existing databases to reduce processing time by 40 and improve accuracy by 90%.
  • Automated more than 40 Operations processes using SAS Stored process for ICICI Bank
  • Turn Around TAT analysis done for Finacle Customer Relationship Management and provided reports for improving service efficiency for ICICI Bank
  • End-to-End process analysis Covid cycle deliquency report FEMA & CCRP for Citi Bank
  • Generated Analytical Visual dashboards for Indian Navy
  • Key role played in implementing End-to-End Analytics for Indian Bank
  • Provide customer segmentation recommendations for testing and to improve performance based upon email reporting analysis
  • Perform A/B testing on all campaigns to continually improve performance
  • Improve the Offer Matrix for second-look customers based on their FICO score.

Timeline

CClyticx Services Pvt Ltd

Senior Risk Anlyst
03.2022 - Current

Data Analyst

CITI Bank
04.2021 - 02.2023

Risk Analyst

CClyticx Services Pvt Ltd
06.2020 - 03.2021

Data Analyst

Indian Bank, OTSI
08.2019 - 04.2020

Software Engineer

Vara United Pvt Ltd
11.2016 - 07.2019

Btech
01.2009 - 12.2013
Praveen PSenior Risk Analyst