Data Sas

Summary:

Over * years of IT experience as Data Analyst including project planning and research and analysis, design, development, testing, and implementation.

Proficient with SAS v9.2/9.3, SAS/BASE, SAS Macros, PROC SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ASSIST, SAS ENTERPRISE GUIDE, Oracle

Extensively involved in Data Analysis starting from creation of SAS Datasets to generation of reports, tables, listings, summaries and graphs in accordance with the Standard Operating Procedures (SOPs) and business requirements

Used various SAS procedures such as Proc Tabulate, Proc Univariate, Proc SQL, Proc Freq, Proc Means, Proc Summary and ODS.

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.

Ability to understand and implement business processes based on requirements and specifications

Excellent technical, critical writing, presentation, interpersonal and communication skills

Technical Skills:

Statistical Software: SAS (Base SAS, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS Enterprise Guide)

Programming Languages: C,C++

Office Tools: MS Word, MS Excel, MS PowerPoint

Database: MS Access, Oracle, SQL Server, Teradata

Operating Systems: Windows

Reporting tool: Tableau

Professional Experience:

Abbott, San Jose-CA Dec’14-Jun’15

Responsibilities:

Generated statistical analysis files, tables, listings, and graphs for Phase I, II Clinical Drug Trial Studies

Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Formats, Sort, Update and Functions.

Provided outputs and appropriate documentation for clinical study reports and integrated summaries

Warner Bros, Burbank, CA Oct 2013-Nov 2014

Responsibilities:

Supported and enhanced direct marketing initiatives by providing statistically valid results

Evaluated data from partner websites for conversion metrics and revenue generation

Responded to ad-hoc requests and maintained monthly customer lists for periodic campaigns

JnJ, New Jersey, NJ Dec 2012-Sept 2013

Responsibilities:

Evaluated direct mail and email marketing campaigns based on key performance indicators

Studied the buying behavior patterns in particular product class and mix

Generated SAS and MS Excel based reports in response to ad-hoc requests.

Worked with SAS/ETL for single and multi-source data acquisition, transformation, cleansing and loading to create data warehouses

L&T Infotech, India April 2011-Nov 2012

Responsibilities:

Built reporting system for L&T home loan customers and tracking of financial metrics

Used SAS Enterprise Guide for data extraction and summarization

Manipulating, cleansing & processing data using Excel, Access and SQL

Responsible for loading, extracting and validation of client data.

Education

Bachelor of Engineering in Computer Science - Mumbai University

Contact this candidate