Prepare a gap analysis of the Marketing Analytics capabilities against enterprise Marketing Analytics capabilities for a big bank. Develop data requirements for the prioritized use cases. Prepare a high level architecture and propose delivery roadmap.

Conduct quantitative assessment to determine the compatibility of current SAS 9.4 system with SAS Viya to plan for migration to Viya in Azure environment. Create Power BI dashboards summarizing the current SAS landscape, this included assessing - SAS programs’ compatibility with Viya, platform inventory, portfolio breakdown and SAS 9 characteristics and features used.

Perform risk-based evaluation of the design and operative effectiveness of Transaction Monitoring and Sanctions Screening systems. Develop and execute SAS scripts to extract and transform data from various file formats (NACHA, flat files, text, or sequential files). Assess data integrity, accuracy and completeness when data is transmitted through bank systems. Perform post implementation data lineage validation for SAS AML platform involving various payment message formats.

Create SSIS packages to extract, transform and load the Call Centre data daily files to the database.Develop stored procs to pull data from Enterprise Data Hub, load data into the retail app Velocify to facilitate solicitation process for Mortgage Call Centre.Create reporting for Sales & Marketing and Finance using PowerBI and SQL

Develop and implement automatized Marketing Campaigns for soliciting new and existing pre-approved customers for Capital One Auto Finance (Email, Direct mail and In Statement Letter Campaign).Conduct Data Mining for various statistical modelling projects including data cleaning, descriptive analysis, missing data analysis, data validations, data triangulations and preliminary data reporting.Perform ETL tasks in extracting the solicitation data from databases using SAS procedures like SAS/SQL, SAS/Access and creation of datasets.Developed ad-hoc reports using SAS EG, SAS/Macros to conduct data analysis and validation.