Sas Developer Resume Profile
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.