We provide IT Staff Augmentation Services!

Sr Sas Consultant Resume Profile

VA

Business Experience:

Expert-level ability in the design and development of SAS /Netezza SQL programs. Accomplished indesign and construction of both analytic and transactional data repositories.Developed computer systems and reports for research/statistical analysis, customer marketing analysis, extraction, transformationand data warehousing/reporting systems for Clinical Research, Sales, Marketing, Banking and Financial Services, Call Centers,among other businesses.

Personal Qualities: Strong organizational and interpersonal skills Highly Motivated - Self Starter - Team Player - Tutor and Mentor

SAS PLATFORMS: Microsoft Windows Server 2008 R2, 2000 XP, NT 4.0 PC SAS and SAS Server 9.3 IBM MVS S/390 SAS 8.2 , IBM zOS 1.4 UNIX System Services HP UNIX 11.11 on HP-9000 SAS 8.2 , Sun OS 5.8 SAS 9.1.3

SAS/BASE:

Datastep: Reading non-SAS data: Input, : / Data sorting merging and manipulation BY Processing: FIRST. and LAST. Indexing for very large datasets Program Control: IF-THEN-ELSE, Iterative DOs, DO WHILE, SELECT SAS Functions Data NULL ODS.

PROCS: SQL, APPEND, CONTENTS, CORR, DATASETS, FORMAT, FREQ, MEANS, GRAPH, GMAP, UNIVARIATE, OPTIONS, PLOT, PRINT, PRINTTO, RAND, REPORT, SORT, SUMMARY, TABULATE, TRANSPOSE, IMPORT, EXPORT, UPLOAD, DOWNLOAD.

MACROS: To automate and add flexibility to SAS code for repetitive use and allow a more modular approach.

Other SAS Products

SAS Enterprise Guide 5.1:, Development platform for SAS Intelligence Platform.

SAS/Information Delivery Portal- SAS/IntrNet: SAS Web platform for user interaction and data/report presentation.

SAS Management Console SMC : Manage Metadata for the Intelligence Platform and User management

Cross-Environment Data Access CEDA : Access data on multiple platforms including Unix System Services Mainframe OS/390 and Z/OS.

SAS/ACCESS: Pass-Through SQL to execute SQL in the native DB environment, Create ACCESS and VIEW descriptors for accessing data in Netezza, ORACLE, MS SQL Server, plus ODBC connections.

SAS/CONNECT: Read Microsoft Access and Excel data.

SAS/FSP: PROC FSEDIT to create data entry and viewing screens.

SAS/GRAPH: GPLOT, GBAR, GPLOT.

SAS/Add-In for Microsoft Office.

Databases:

  • Netezza
  • SQL Server 2010
  • Oracle 11i on Linux / Unix
  • DB/2 on MVS
  • Model 204 on MVS
  • Interbase for Linux
  • NCR Teradata
  • Microsoft Access 2010
  • MySQL on Linux

EXPERIENCE:

Manager

Confidential

Modify and enhance business system that identified cost savings for health insurance business. Converted Oracle SQL to NetezzaSQL programs. Added SAS macros to automate, customize and increase functionality to existing programs. Analyzed programs to determine resolutions for business team issues. Optimize Netezza SQL loads. Test and QA all work.HHS/CMS/Health Care data. Assisted employees in the use and optimization of SAS Enterprise Guide SAS EG SAS Business Intelligence BI platform to automate and optimize data extraction and reporting.

Sr SAS Consultant

Confidential

Modify and enhance an extremely complex enterprise business system tailor made for this particular insurance business. Customized SAS programs to interface with the PeopleSoft General Ledger system. Added SAS macros to replace hard coded passwords allow a smooth secure interface between environments. Analyzed programs to determine resolutions for business team issues. Optimized SQL downloads, refractor COGNOS push for cube data. Test and QA all work.

Confidential

Sr SAS Consultant

Responsible for reporting and analyzing Outreach outcomes in support of Medicare outreach strategies and Contact Center activities. Prepare reports provide relevant information and key insights for leadership's business intelligence and analytics. Maintain and manage relationships with key business stakeholders and IT. Handle multiple tasks simultaneously, work independently or with a project team. Create workflows, conduct research and develop solutions, as well as specify requirements. Utilize SAS Enterprise Guide 4.3 and the SAS Intelligence Platform to design solutions and metrics for the Executive Decision makers. SAS Administrator, utilize SAS Management Console to update metadata and create security groups for reports, web and data. SAS BI utilize SAS EG to automate and optimize BI applications to report on Call Center activities and ROI of products.

Confidential

IT Specialist

Upgrade and enhance a SAS/IntrNet web based disease surveillance system from Windows Server 2000 - SAS 9.1.3 to Windows Server 2003 SAS 9.2. Design and develop original programs to perform complex processing on normalized SQL databases. Modified SAS programs to utilize SQL tables. Developed and trouble shoot SAS programs for statistical analysis. Advise senior management and consult with peers to automate a UAT process for an OLTP database. Build tools for comparing data and develop reports delivered on the web. Modify SAS programs and data structures to transition ICD-9 disease codes.

Confidential

Upgrade and enhance a SAS program to add parent/child hierarchies to the reporting schemes. Design and develop original programs to perform complex processing on transactional SQL databases. Modified SAS programs to utilize SQL tables. Developed and trouble shoot SAS programs for statistical analysis. Advise senior management and consult with peers to automate a UAT process for an OLTP database. Build tools for comparing data and develop reports delivered on the web.

Confidential

Upgrade and enhance a SAS/IntrNet web based system that enables non-technical users to perform disease surveillance analysis. Developed web programs in html, xml/JavaScript, CSS forms that interact with a SAS-SQL backend upgraded SAS programs for annual processing. Design and develop original programs to perform complex processing on normalized SQL databases. Modified SAS programs to utilize SQL tables. Developed and trouble shoot SAS programs for statistical analysis. Advise senior management and consult with peers to automate a UAT process for an OLTP database. Build tools for comparing data and develop reports delivered on the web.

Confidential

Consultant

Upgrade and enhance a SAS/Excel financial risk analysis system on credit card/revolving debt. Upgraded SAS programs to accommodate a new line of business.

Independent Consultant

Confidential

Produce statistical analysis of clinical study data to ensure integrity of information. Developed SAS programs that produce Patient Profiles, FDA listings and summary tables of clinical data. Assist statisticians in developing meaningful analysis of clinical data. Developed SAS Macros to provide adhoc statistical analysis to statisticians and medical staff and help data management to identify data issues based on the review of tables and listings.

Confidential

Consultant

SAS support of a CRM function for a marketing group within a major credit card company, gathering, cleansing and grouping data. Produce statistical analysis of data to ensure integrity. Perform independent analysis of data, make recommendations and assist in group decisions and conferences with entire group.

Hire Now