Sas Marketing Analyst Resume
3.00/5 (Submit Your Rating)
SUMMARY:
- 5 years of experience in Finance and Banking industries
- Expertise in data analysis, risk management, planning and strategies, and handling financial databases
- Technical expertise in SAS programming, DATA Step, Oracle, PL/SQL, UNICA, UNIX, SAS Enterprise Guide, SAS Enterprise Miner, SPSS
- Experience in working with large data sets (more than 1 million records)
- Possess strong organization skills, detail oriented, able to work alone and lead diverse teams, adaptable, and able to master new technologies
SKILLS:
- Microsoft Office
- PL/SQL
- SAS
- SQL
WORK EXPERIENCE:
Confidential
SAS Marketing Analyst
Responsibilities:
- Analyzed key insights of each customer segment including product and service usage, channel usage and other related banking behaviors
- Provided data analysis to explore marketing opportunities for each customer segment
- Compiled and analyzed customer data for further Customer Strategy Projects such as SCB Point, Payroll Analysis, New Generation Analysis, Lapsed Customer and Branch Selection
- Designed and generated Confidential tracking reports
- Provided customer data for cross selling, up selling or segment campaigning activities
- Coordinated with product teams to develop customer analysis
- Liaised with CRM Confidential rollout team to introduce Confidential and to provide requested information to relevant parties, such as hub and branches
- Monitored, analyzed, and suggested improvements based on Confidential responses
Confidential
Supervisor Risk MIS
Responsibilities:
- Managing MIS, Analysis and Reporting, Risk Management Unit
- Provided data analysis and generated reports for Acquisition, Portfolio Performance, Collection Performance, Recovery Vintage, Roll Rate, Capital Allocation and Global Reporting
- Developed ad - hoc reports on Performance of Specific Customer Group, Vintage 30-day delinquency, 90-day delinquency, Write-off, Utilization & Spending by Segmentation, Performance by Behavior-score, Rejection & Cancellation Factors, Write off Analysis, etc.
- Ran SAS query using Base SAS, PROC SQL to track Confidential performance, such as Credit Line Increase Program, Champion Challenger of X days Accounts, etc.
- Developed routine SAS Macros to assist Risk Mitigation Team in tracking debt restructuring performance
Confidential
CRM Analyst
Responsibilities:
- Program and Strategic Planning Unit
- Provided data analysis to generate list of prospective customers for all CRM campaigns based on relevant criteria
- Extensive use of SAS Data step, PROC SQL to extract data from the database for further analysis in developing CRM campaigns and evaluating Confidential performance.
- Coordinated with Risk, IT, and MIS team to ensure that the data is accurate and reliable
- Generated reports and implemented Cross Selling and Up Selling campaigns while coordinating between relevant departments (Personal Loan, Credit Card, Sale Finance, Hire Purchase)
- Analyzed data on customer behaviors: Repurchase Opportunity, Churn Customer, Inactive Customer, Delinquency History etc.
- Developed and monitored project schedules for all phases to ensure efficient and effective deliverables
- Generated customer list in order to develop Telesales Application and supported Telesales team for CRM campaigns
- Provided assistance to R&D department with data analysis
- A member of vendor selection team relating to Confidential Management Tool