Data Analyst Sas

Gopi Das

Toronto, ON 647-***-**** *******@*********.** linkedin.com/in/gopidassasanalyst/

DATA ANALYST

A Data Analyst, experienced working with SAS, Oracle, Sybase & Teradata Server

Expertise in Marketing Campaigns from lead generation to deployment through targeted channel

Experience in Data analysis and Reporting in finance, health care and marketing sectors

Develops and deploys market research and analyzes data supporting the strategic business planning, product development, and operational streamlining objectives

Leads reporting, research and analysis projects from requirements audit and application design

Intermediate skills in SAS enterprise guide (EG)

Advanced skills in MS Excel using Macros, pivot tables and If statements

Experienced applying statistical technique

Familiar with IBM Campaign / Unica

Certified in SAS and Oracle

CORE COMPETENCIES

CRM - Database Marketing Quantitative & Qualitative Market Research Data Analysis Business Intelligence Data Mining Survey & Questionnaire Design Data Mapping Reporting Quality Control Data Integrity

TECHNICAL TOOLKIT

SAS SQL TERADATA PL/SQL VBA Alteryx SPSS TABLEAU Power BI

LINUX, UNIX, Windows Environments Microsoft Office Suite (Excel, Access, Word, PowerPoint)

Highlights of Career

Canadian Imperial Bank of Commerce – Toronto, ON 2018 – PRESENT

CUSTOMER DATA CONSULTANT

Complete requests from business partners ranging in size from medium to complex within schedule and budget

Translate business requirements of medium to high complexity into technical specs, using primarily SAS and/or make modifications to existing processes/jobs and reporting

Provide expertise in data/business analysis, investigation, and interpretation of client metrics using data analysis and reporting tools to answer ad hoc inquiries

Assist in the analysis and discovery of business opportunities and client insights to support business development goals

Maintain accurate and comprehensive documentation on processes/jobs

Liaise with business partner groups to obtain, verify and discuss requirements, exchange information and best practices

Apply knowledge of technology to automate manual and inefficient processes to minimize errors and optimize efficiency

Bank of Montreal – Toronto, ON 2017 – 2018

CAMPAIGN ANALYST

Reviewed and analyzed campaign business requirements and produced Technical Implementation Plans

Prepared customer lists with campaign management toolset meeting the documented technical requirements

Conducted campaign technical audits and reviewed data output to ensure accuracy

Provided in-depth analysis and reporting on business performance activities

Developed code to execute program data requirements and prepared appropriate input files for each of the Campaign Production and Development processes

Documented the technical details of a given Leads Management program in the appropriate format

Utilized SQL to load data from multiple sources including extraction, transformation, and load (ETL) packages for data warehousing, maintaining the data warehouse

Identified issues and made recommendations for campaign improvement

Ensured campaign requirements had documented business partner approval prior to file development and execution

Royal Bank of Canada – Toronto, ON 2016 – 2017

SENIOR ANALYST CAMPAIGN EXECUTION

Built and executed various marketing campaigns, generated the targeted leads and deployed into the targeted channels

Prepared various sizing for cross-functional team and helped them to take the business strategic decision

Ensured data quality in order to accurately interpret the business need

Conducted campaign analysis, cleaned the data and transformed into summative assessment and report. Analyzed the post campaign findings & escalations

Utilized SQL to load data from multiple sources including extraction, transformation, and load (ETL)

Ensured corporate reputation was maintained by strict adherence to privacy guidelines and ethics, data stewardship and governance policies and processes

Used SAS Enterprise Guide (EG) to pull customer records from Teradata server to create report

Responsible for development of complex campaigns and documentation, integrating and leveraging learnings from past and post campaign results

Gathered data, ran and analyzed reports in MS EXCEL and SQL to measure system performance and quality

Ipsos Reid – Toronto, ON 2005 – 2015

DATA ANALYST

Produced high-quality analytical reports to support a team of market research professionals in delivering meaningful customer insights to Ipsos clients. Manipulated and analyzed extensive arrays of statistical data from large computerized information systems to deploy comprehensive, precise, and relevant client reports. Performed cross tabulation, delivered summary statistics, program survey tables, verified and cleaned data to ensure its accuracy and integrity. Used demographic files to derive weighting factors for tracking studies. Collaborated with clients, and established data cleaning procedures.

Single-handedly led five concurrent BMO (Bank of Montreal) tracking studies, successfully delivering on set milestones despite the need to adjust programming approaches to match client requirements on each project

Optimized processes related to the execution of BMO studies by conceiving and introducing several new programming templates complete with supporting documentation that were adapted and reused, saving research project time and money

Succeeded in galvanizing a unified data framework for reporting purposes by developing and leveraging solutions for combining data sets in studies with mixed methodologies (mail, online, and phone), formats (card versus ASCII), and hierarchies (household, member and transactional levels)

Utilized SQL to gather data from different sources and translated into supporting report on business performance after deep analysis

Used SAS Enterprise Guide (EG) to pull panel lists from Teradata server to create reports

Education & Training

SAS Institute, SAS Certified Base Programmer/ Advanced Programmer for SAS 9

Oracle University, Oracle 9i Certified Professional Database Administrator (DBA)

Seneca College – Toronto, ON, Computer Programming & Analysis (Database Specialist)

Bangladesh University of Engineering and Technology – Dhaka, Bangladesh, Bachelor of Mechanical Engineering

Contact this candidate