We provide IT Staff Augmentation Services!

Sas Data Analyst Resume

4.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • SAS Programmer/Developer with over six years of experience in Analysis, Design, Testing, Development and Validating the applications.
  • Strong Knowledge in SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/BI, SAS/EG, SAS/GRAPH, AND SAS/STAT in PC and Unix environment.
  • Created RTF, PDF, and HTML listings, tables and Reports usingSAS/ODS. .
  • Excellent programming skills in joining, merging and extracting data from various databases using SAS/SQL and PROC SQL.
  • Strong knowledge in dynamic programming and list processing using SAS/MACRO.
  • Wrote lots of common macros that are used across multiple applications and saved the macros in permanent SAS catalog for reuse.
  • Strong knowledge of Data steps, Proc steps like Proc Means, Proc Freq, Proc Report, Proc Tabulate, Proc Format etc.
  • Strong knowledge on SAS BI like SAS Enterprise Guide, SAS Stored Process etc.
  • Extensively used SAS Enterprise Guide to create and execute stored processes for the future use.
  • Proficient on using SAS Enterprise Guide for accessing and manipulating different databases like Oracle,DB2, Teradata, Sybase etc.
  • Extensively used SAS/SQL pass through facility to connect with relational databases like Oracle, DB2, Sybase and Teradata.
  • Data validation and data cleaning usingSASprocedures with relational databases..
  • Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and Managing data.
  • Basic Knowledge on SAS/STAT for data modeling and predictions.
  • Expert in using report generating procedures like PROC CONTENTS,PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, and PROC TRANSPOSE.
  • Experience in using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
  • Expert in using Data Null to create macros, customized reports, reports on external files and debugging SAS codes.
  • Expert in using import wizard, export wizard, proc import and proc export to import and export data from excel spreadsheets and to excel spreadsheets.

TECHNICAL SKILLS

SAS: SAS V8, SAS V9, SAS/BI, SAS/EG 4.0 5.0, SAS DI studio

ETL Tools: Data Stage 8.1(Information Server)/7.5.2(Enterprise Edition) /7.1

Database: Oracle 10g/9i/8i, DB2, SQL Server, TeradataOffice ToolsMS Office, MS Access

Operating System: MS - DOS, Windows 98/2000/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SAS Data Analyst

RESPONSIBILITIES:

  • Worked on a project named Online Banking with different kinds of offers like home page, sign in and sign off and other so many channels.
  • Worked particularly on Audits and Quality control reports generating.
  • Generated lots of Fancy quality control reports on colored excel to distribute for different teams for verification purposes.
  • Wrote lots of Data Steps to access and manipulate data from different sources like Teradata, oracle and excel sheets.
  • Used SAS/SQL to extract data from different databases and joining tables.
  • Used SAS/ACCESS to access and manipulate different databases like teradata, Oracle etc.
  • Extensively used SAS Enterprise Guide to connect to PC SAS and Unix SAS.
  • Worked on a transformation project from SASDome to SAS Grid.
  • Extensively used data step to access and manipulate data from different databases like Teradaat, SQL server, Oracle, DB2 etc.
  • Wrote lots of common macros that are used across multiple applications.
  • Generated reports in HTML, PDF or RTF formats according to business specifications.
  • Used lots of report generating procedures like PROC CONTENTS,PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, and PROC TRANSPOSE.
  • Created ad-hoc reports and tables for information delivery and data management departments.
  • Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes.

ENVIRONMENT: SAS V9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/EG, MS Office Applications, Windows 2000, Windows NT, UNIX,TERADATA

Confidential, Plano, Texas

SAS Data Analyst

RESPONSIBILITIES:

  • Created batch and interactive applications utilizing SAS/BASE, SAS/SQL and SAS/MACRO
  • Worked on a Project named Confidential Auto Finance to select valuable customers for the Auto loans.
  • Wrote lots of Data Steps to access and manipulate data from different sources..
  • Used SAS/SQL to extract data from different databases and joining tables.
  • Worked with huge data around millions records received from third party named Acxiom every week.
  • Used SAS/ACCESS to access and manipulate different databases like Teradata, Oracle etc.
  • Generated lots for HTML and Other types of quality control reports for the verification of our customer selection process.
  • Extensively used data step to access and manipulate data from different databases like Teradaat, Oracle etc.
  • Wrote lots of common macros that are used across multiple applications.
  • Generated reports in HTML, PDF or RTF formats according to business specifications.
  • Used lots of report generating procedures like PROC CONTENTS,PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ etc.
  • Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes.
  • Wrote lots of Common reusable macros and automated the BAU process.

ENVIRONMENT: SAS V9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/EG, MS Office Applications, Windows 2000, Windows NT, UNIX,TERADATA

Confidential, Philadelphia, PA

SAS Programmer/ Data Modeler

Responsibilities:

  • Migration of data from text files, Excel spreadsheet, Oracle and DB2 to SAS data sets using import wizard and SAS/SQL pass through facility.
  • Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
  • Experience in dynamic programming and list processing using SAS/MACRO.
  • Actively involved in the analysis of Marketing and Sales data. Performed Retrospective Analysis on sales representative data to analyze and summarize the differences in amount of commission paid.
  • Extensively used Proc Report, Proc Tabulate and ODS output to generate report as per the desire format.
  • Read datasets with a lot of missing values using MISSOVER and TRUNCOVER options.
  • Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update and conditional statements. .
  • Extensive use of SAS/BASE and SAS/STAT for producing tables, listings, figures, and generating statistical reports
  • Developed reports using Proc Reports, Proc Tabulate, and Data Null of clinical trials using base SAS procedures such as PROC SUMMARY, PROC TABULATE and SAS GRAPH.
  • Used SAS/EG to access and manipulate different databases like teradata, Oracle etc.
  • Extensively used SAS/CONNECT software to connect different operating systems with the networked computer.
  • Extensively used Proc Report, Proc Tabulate and ODS output to generate report as per the desire format.

Environment: BASE SAS 9, SAS/GRAPH, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/Connect, MS Excel, Windows, Oracle, MS SQL, TERADATA,DB2

Confidential, Dayton OH

Research Assistant

RESPONSIBILITIES:

  • Performed statistical analysis like PROC REG, PROC ANOVA, PROC TTEST, PROC GLM, PROC CORR etc.
  • Developed reports using PROC REPORTS, PROC TABULATE and DATA NULL .
  • Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility.
  • Wrote lots of macros using SAS macro facility and using Data Null .
  • Accessed various database to gather data, performed a table lookup and translated data values for meaning and readability using SAS/SQL.
  • Downloaded data from Oracle, DB2 and Teradata using SAS/SQL pass through facility in to SAS to be analyzed and then exported to Excel for further analysis.
  • Used SAS/EG to access and manipulate different databases like teradata, Oracle etc.
  • Extensively used SAS/CONNECT software to connect different operating systems with the networked computer.
  • Produced customized reports by using PROC TABULATE, PROC REPORT, and PROC SUMMARY and also provided descriptive statistics using PROC Means, PROC Freq etc.

ENVIRONMENT: SASV9,SAS/MACROS,SAS/GRAPH,SAS/STAT,SAS/SQL,SAS/BASE,SAS/EG, ORACLE, TERADATA,WINDOWS XP

Confidential, Erie, PA

SAS Programmer

RESPONSIBILITIES:

  • Wrote lots of data steps to access and manipulate data from different sources.
  • Used lots of proc steps for analyze and to produce customized reports.
  • Developed reports using proc report, proc tabulate, and Data Null ..
  • Wrote common macros that are useful across multiple tables.
  • Performed statistical analysis like PROC REG, PROC ANOVA, PROC TTEST, PROC GLM etc.
  • Developed efficient, well documented, comprehensible and modifiable SAS codes using SAS/BASE and SAS/MACROS.
  • Used SAS/SQL to perform queries, join tables and to connect to different databases like Oracle, DB2 and Teradata.
  • Worked on multiple projects simultaneously and meet the deadline as required. generated HTML, PDF, and RTF pages to publications to the internet using SAS/ ODS.
  • Imported lots of data into SAS data warehouse using proc import and import wizard.
  • Exported SAS data sets to different databases and external files using proc export and export wizard.
  • Used lots of SAS/GRAPH to produce nice charts and plots.

ENVIRONMENT: SAS V8, V9, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/BASE, SAS/ODS, SAS/EG,ORACLE, WINDOWS XP, TERADATA

We'd love your feedback!