Customer Insight Analyst Resume

SUMMARY

Base SAS Certified Programmer.
Proficient in data analytics using SAS/SQL and data visualization using Tableau.
Experienced in accessing and manipulating large and complex datasets; dealing with inconsistent, missing, incorrectly coded data.
Experienced in Excel functions like pivot tables, v - lookup in large database settings.

TECHNICAL SKILLS

Statistical Software: SAS (BASE, STAT, SQL, ACCESS, GRAPH), SAS EG, SAS Studio

Databases: SQL, MS SQL Server, Oracle 9i, Teradata, MS Access

Business Intelligence: Tableau

MS Office: Excel, Word, Power Point, Outlook

Operating Systems: MS Windows, LINUX

PROFESSIONAL EXPERIENCE

Customer Insight Analyst

Confidential

Responsibilities:

Developed programs and reports using SAS, SQL according to specification as required by the Marketing and Analytics team.
Used SAS/Access to read, extract large datasets from various sources including Databases, flat files, and other PC File formats.
Extracted large datasets from Databases using SAS, SQL, performed data manipulation, transformation, and created final datasets in a required formats using SAS data steps.
Undertook descriptive data analysis of sales and marketing data using SAS and created reports to inform the management.
Extensively used SAS procedures such as PROC MEANS, PROC SUMMARY, PROC TRANSPOSE, PROC REPORT, PROC TABULATE, PROC PRINT, PROC SORT, and PROC CHART for producing ad-hoc and customized reports.
Created reports and dashboards using Tableau and Excel.
Developed SAS macros to simplify SAS code and improve performance.
Developed and maintained SQL queries.