SAS / SQL DATA ANALYST

Description

Data Analyst of Transactional Data using SAS and SQL commands This is a very handson programming position to analyze and report data as meaningful information by delivering the following technical skills Campaign Analysis Warehouse SQL 2005 and 2018Heavy use of SQL to search and extract dataHeavy use of SAS to analyze and represent date in formats useful to the business usersKnowledge of the UNIX environmentExcel automation reportingMS Sales Financial Business Intelligence Reporting Analysis dimensional and relationalKnowledge of SSRS a plusAnalysis of Actuals, Budget and Forecast by creating normalized relational data structuresPower Pivot expert using DAX and data normalizationSQL Reporting Services data metric reporting utilizing SQL and some MDXDeveloped analysis toolCreate complex and aggregate SQL queries into ExcelVBA code automated dynamic Excel reporting sheetsHighly skilled at Ad Hoc request and reporting efficient at understanding the underlying dataSQL server queries publishing in various consumable end user apps like MS ExcelWorked with multiple stake holders to gather requirements and metrics & ROIManagement of data issues between multiple data sources and platformsData cleansing and extraction, report design and implementation of Marketing NumbersDetailed customer response reporting from hand raisers to full purchases, tracking