Soundarrajan S.

Soundarrajan S.

Associate Manager

Chennai , India

Experience: 7 Years

Soundarrajan

Chennai , India

Associate Manager

16285.7 USD / Year

  • Immediate: Available

7 Years

Now you can Instantly Chat with Soundarrajan!

About Me

SAS programmer over 7.7 years of experience in analysis, development in Retail Banking, Manufacturing and Retail domain. Overall 8.7 years of experience. SAS Certified Advanced Programmer for SAS9. Solid Experience in SAS/BASE, SAS/SQL, SAS/MACRO SAS...

Show More

Portfolio Projects

Description

Associate Manager SAS programmer and also a individual contributor in retail risk services for retail banking .This project deals with uniqueness of data, previously within the country for retail credit risk the data extraction was based on requirement of each department and they used different file as source data .In order to avoid discrepancy we have prepared a raw data layer to extract the data from a single data source and this will reconcile with all units within a country and which will improve consistency in reporting metrics on credit cards , personal installment loan, mortgage and wealth management portfolio.

Show More Show Less

Description

Role : SAS programmer

Description:

This Project deals with enhancing the end to end BI application developed in SAS. It comprises

of ETL process and reporting. This project helps the bank by processing the transaction data and loading into data warehouse and preparing reports for operational purpose.

Show More Show Less

Description

Role : SAS programmer

Description: This project is to develop a Global Common Labor Code Set for warranty metric management. This will reduce labor code proliferation resulting in more efficient and effective warranty claim analysis for quality improvement. This will also improve management of global labor codes, warranty administration and field action execution. Currently, the labor codes are maintained by different regions with their own labor codes. This resulted in more number of labor codes and repetition. It’s decided to generate and maintain a uniform set of labor codes which will improve consistency in reporting for warranty metric management.

Environment: SAS 9.2, SAS/EG, Windows XP, UNIX.

Show More Show Less

Description

Review Members buying patterns and behaviors to determine changes to the Behavior based marketing campaigns. Single buyer remains single or change to multi buyers over years and Multi buyers remains Multi buyers or change to single buyer. Single buyer buys which kind of product category and multi buyer buys which kind of product category.

Show More Show Less

Description

The objective of this report is to assess the effectiveness of the Direct mail Marketing Program. It compares key measures of the Direct mail group and the Holdout group and covers all direct mail campaigns

Show More Show Less

Description

CCA (Customer characteristic analysis) Look insight of customer demographic details over sales to identify analysis of various category like customer Ethnicity, Education, Occupation, Age, Gender, Household Income, Dwelling Type, Home Value Range, Length of Residence, Marital status, Number of Adults in Household, Children in the Household, Computer owner.

Show More Show Less

Description

Profile existing Member data (appending outside data to create a profile) Who is our top member, who is our new member, what attributes are common in lapsed member and Customer reactivation.

Show More Show Less

Description

The COCA divides customers into segments based on their purchase history. The segment of a customer is assigned to depend on how long its been since their most recent purchase and how many purchases they have made. Transactional metrics are available for each customer segment. Category of customer analysis (COCA) is an in-depth look at the health of your customer database. It provides insights about your customers and identifies trends at a segment level. This set of analytics will help you measure retention, reactivation, and acquisition rates. These metrics represent the building blocks for tracking customer churn and benchmarking acquisition efforts.

Show More Show Less