PROFESSIONAL SYNOPSIS & PROJECTS UNDERTAKEN
• Generate reports either in EXCEL, PDF, RTF and CSV format using SAS/ODS according to client
requirements.
• Extensive use of PROC SQL, PROC PRINT, PROC SORT to perform analysis of the datasets using
queries, joining and altering tables using Merging, Keep and Drop.
• Implementation of ad hoc requests and coding enhancements using various functions like SUBSTR,
SCAN, DAY, MONTH, YEAR, SUM, INTNX, CAT, TRANWRD, etc.
• Convert unstructured business requirements into structured analytical plans, Work across multiple
products and effectively use various data platforms and analysis tools
• Possess good knowledge of SAS with a comprehensive understanding and application of its Procedures
and contents like SAS/BASE, SAS/SQL, SAS/Macros.
• Experience in data management, cleaning, reporting and integration using SAS Programming skills.
• Accountability for quality, timeliness and efficiency for the work assigned to me.
• Configuration for complex and urgent deliverables.
• Strong leadership, problem-solving, planning, team-building and project management skills
Projects Undertaken
Lead Management Analysis in Henry Harvin where I am partnering with the Business intelligence and Development unit to deliver valuable data driven
analytical projects for the Daily, Monthly, Quarterly and Yearly Lead Operation, Analysis paid, overdue, new customers, customer Retention Rate (CRR) etc. Country-wise, Segment wise and Date wise presenting the data.
Credit Card NTB Customer Analysis: - I would like to discuss Credit card NTB customer Analysis. In this project we review new to bank credit card customers. First 20 days card usage patterns and review the card utilisation curve. Then we segment the customers who haven’t done any transaction, have done transactions with more than 70% of credit limit or not then we push non activated customers data into activation campaigns dialler with the CRM team. Perform activation calling and raise dispositions basis conversation.
Afterword we analyse the disposition and transactions of customers after 10 days and get an end-to-end result to review flow. Many customers are activated after being called.
Credit Card Customer Analysis: - In this project we review the transactions of credit card and noncredit card customers in order to review their spend product and behaviours. In order to segment them, they base different campaigns to focus on co-branded cards.
Behavioural Scoring of Credits: - In this project we analyse the credit card customers ETB + NTB card utilisation. In which we review their transaction patterns and credit to balance ratio. In order review the customer behaviour whether comes under transactor, revolver or defaulter categories basis
different category and customer spend segmentation.
We raise the flags and also push the customer data into the dialler for different campaigns which lead to benefits for banks to understand the probability of default customers and good customers.