Data Analyst for Digital Channels Group supporting analysis and reporting.

Perform Ad hoc data analysis for Small Business Deposits products, generate and maintain reporting using Teradata SQL, Oracle and Excel.

Managed development and support of the Online/ Mobile Customer Information Teradata Data Mart and Reporting tools, comprising Online Bill Pay, Activity Alerts, Mobile Deposit, etc. Empowered the 100+ Teradata analysts with consistent and efficient access to customer data in support of marketing related activities, product planning and decision support.

Managed Analytics and Reporting in support of business product managers for sales of banking products (deposits/ credit card/ mortgage) through the website. Analytics included diagnostic research on operations issues, measuring impact of customer application changes, profiling profitable customers, etc.Conceptualized and developed Online Product Sales Funnel Teradata Data Mart and MS SQL Server reporting cubes, for tracking customer interaction from website search through to completed application and product usage. Tool enables non technical product managers to independently develop sales performance analysis, customer profiles, operations optimization, prototype tests, etc.

•Performed various Analyses using SQL and SAS against Online/ Mobile customer activity data sources. Examples include: measuring lift from test and control of product features and sales initiatives, correlating web behavior to sales and to other online and offline activity, opportunity models for enrolling customers in online banking, etc. •Developed fully automated Forecast Model for Online Banking Subscriber base by organizing various data sources and stand alone processes into single data interconnected Excel tool, allowing non technical financial analysts to easily make changes and perform scenario testing.

•Performed Marketing Campaign Measurement using SAS statistical measures against test and control cells.•Evaluated CRM technology and made executive recommendations.•Managed Customer Profitability data mart to support Marketing and Finance.

Positions managing data warehouse projects, data marts, decision support, and ad hoc analysis, using Teradata SQL, SAS and MS SQL Server.