We provide IT Staff Augmentation Services!

Sas Developer Resume Profile

4.00/5 (Submit Your Rating)

Charlotte, NC

OBJECTIVE

18 years of experience SAS Analyst, architect, data integrator, as well as SAS DBA experience. SAS Analytics using:Templates/ODS objects with ETL, development/applications programming. SAS Enterprise system design and upgrades.

Areas of Experience:

  • SAS 9.4 SAS Data Warehouse SAS DI
  • MS ACCESS CICS C
  • REXX/TSO SAS Analytics Websphere IBM
  • M204 PL/SQL
  • SAS/UNIX SAS Business Intelligence ORACLE Discoverer
  • Crystal Reports Endevor

Databases:

DB2 MS/SQL Server 2008 SAS Enterprise Guide

CA-IngresII ACCESS Oracle

IMS Teradata

Operating Systems:

  • MVS/ESA TSO/ISPF IBM MQ Series zOS MS SQL Server 2008
  • AS/400 Visual Studio 2008 Server HP-UNIX
  • IBM-AIX OS/390
  • Years experience with SAS 22 yrs
  • Years experience with SAS CI Customer Insight 2 yrs
  • Years experience with Data Warehouses 6 yrs
  • Years experience with SAS EG Enterprise Guide 10 yrs
  • Years experience with SAS EM Enterprise Miner 4 yrs
  • Years experience with Teradata 4 yrs
  • Years experience with SQL 20 yrs
  • Relevant Certifications see end of resume
  • Employer: Marshfield Clinic, Marshfield, WI Dates: 4/13 to 10/13

Skills Used:

SAS 9.4, SAS Data Integrator 4.7. Transformed medical data from data shop databases using SAS Data Integrator. Used SAS Enterprise Guide to transition from fee-for-service to value-based reimbursement models, Shared team duties and documentation in Sharepoint.

  • PROC REG/FREQ etc. to better predict costs of care and enhance the budgeting process. Gain broader insight that tran scends an individual episode by seeing clinically validated definitions of hierarchical rela tionships between episodes.

FTP BINARY command used to that are used at the source computer to put a foreign file or a transport file on the target compute

  • Procedures: PROC SQL views, the pass-through facility, and the

SAS/ACCESS LIBNAME statement used to access relational Ancillary Healthcare

DBMS data SAS/ACCESS views were used for this. Also, converted

existing SAS/ACCESS views to PROC SQL views by using the CV2VIEW.

Work SUmmary

SAS Developer

Confidential

Skills Used: SAS 9.2, SAS Data Integrator 4.2. SAS Customer Insight. Transformed data from Teradata database using SAS Data Integrator. Developed standards for Stored Processes within SAS Enterprise Guide involving data normalization and transformation. Shared team duties and documentation in Sharepoint.

  • Piping UNIX command line information into a SAS data step using the INFILE state-ment,
  • Using the FILENAME statement with the TERMINAL argument and PROC PRINTTO to route SAS out-put directly to the UNIX terminal
  • Have executing UNIX commands from within a SAS program using the X state-ment, the CALL SYSTEM routine and the SYSEXEC MACRO statements, 4 using UNIX environment variables within SAS programs. Have used SAS/Teradata in-database processing initiative

Confidential

SAS Developer

Skills Used: Crystal Reports 10, SAS P 9.2 Enterprise, DataVisual Studio Crystal Reporting in conjunction with On-Line Conversion of Operations. Integrated MS SQL Server 2005 using SSRS and SSAS, Integrated Server Models using Visual Studio 2005. Formulated Use Case studies with the corporate headquarter Live Office and MS OFFICE Excel. SAP/BO Xcelsius for Management and Security tier reporting. Used SAS Data Integrator for Financial Statistical reporting.

Confidential

Skills: Main Frame COBOL , C , Crystal Reports, Visual Basic, DB2/UDB Conversion project involving ETL work for JAVA based Data Warehouse.

Confidential

Skills: Crystal Reports XI R2 for Exposure Level, Foreign Exchange Rates, Portfolio Valuation, and Manager Transactions. Master Feeder to on-demand drill downs at multi-tier and international levels. Visual Studio 2005 in Hedge Fund Financial Sector. Used C and .NET ADO with OLE DB MS SQL Server Connectivity. Wrote stored procedures for non-related tables across platforms.

We'd love your feedback!