• Profiled migrated customers for customer retention with over index based on the analysis of RFM, demographic and geographic information• Collaborated with the list manager to understand and clarify the customer definition, and ensured the quality of the list manager’s work by checking the data quantity of the feedback

• Modified existing programs and created new code to accommodate requirements and maximize efficiency, maintained and adapted code as necessary• Automated routine reports to drive operational efficiency by utilizing advanced SAS programming skills such as SAS/ODS, automatic macro, x statement etc.• CRM Program Support Create code for extract transform and load tables('ETL') Perform Maintenance on ETL Programs Review and tune ETL code for efficient collect of past and present CRM records Code programs according to specifications from technical documents Prepare written technical documentation of programming for the project • Standardize code utilizing current CE practices Program Automated processes to eliminate manual interventions Translate and convert ad hoc programs to scheduled production tactics Test and validate programs and output files with end users • Manage the creation, loading and migration to production of tables and messaging grids • Migrate project programs, macros and data from the development environment to the production environment • Design and coordinate automated schedule creation and implementation • Perform go live services for project tactics • Perform Hyper-care for the Project Tactics Maintain and update Production code as needed

• Developed ad-hoc reports as required, and ensured the consistent quality of outputs including relevant business objectives, accurate metrics, data visualization, and lucid layouts• Provided valuable insights by interpreting business needs into data and analytic requirements. • Pulled customer list for campaign execution based on fully understanding of the business objective and familiarity of the contact policy• Provided recommendations in the product post campaign based on analysis of the historical data, short and long term impacts, and possible halo effect in test and control groups• Developed reusable code for the team in routine process with standardize code, exception handle, quantity control• Extracted, cleansed, manipulated, aggregated and summarized large data sets from multiple data source

• Optimized the target customers in the product campaign to improve the ROI performance by testing combinations of criteria effectively with nested macros, Proc Format and SAS/SQL • Automated routine ETL process by utilizing advanced SAS/MACRO, SAS/ODS, and project scheduler in SAS/EG

• Extracted, cleansed, manipulated, aggregated and summarized large data sets from multiple internal and external databases • Assisted in the CRM campaign offer design to reduce the offer cost through analysing the RFM information and favourite products of the target customers