We provide IT Staff Augmentation Services!

Sas Programmer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Certified SAS Programmer with 7 Years of IT industry experience in financial, wealth and healthcare domain.
  • Hands on experience in various SAS TOOLS such as SAS/Base, SAS/Macro, SAS/SQL, SAS Enterprise Guide on both PC SAS and UNIX platform.
  • SAS Administration experience using SAS Management Console
  • Extracted and manipulated data from various databases like Oracle, DB2 - UDB and SYBASE using LIBNAME and SQL Pass through facility.
  • Extensive experience in importing and exporting raw data files present in different file formats (excel, comma, tab, free format etc.). Validation, transformation & modification of datasets using various SAS functions and procedures.
  • Experience in generation of Tables, Listings and Summaries custom reports on adhoc basis using various SAS report generating procedures.
  • Good knowledge of MS Office ( Word, Excel and PowerPoint)
  • Interpret and convert business requirements into IT functional specs Technical requirement docs. Involved in creation of various documentation during the life cycle of a project.
  • Strong Technical, Communication, Interpersonal, Analytical, Reasoning and problem solving skills.
  • Ability to learn new technologies faster and to work both individually as well as in a collaborative manner across project teams.

TECHNICAL SKILLS:

Application/Functional areas/Packages worked on: Application development in SAS, Full cycle SDLC, Production Support

DBMS: Sybase IQ, Oracle 11g, DB2: UDB

Operating Systems: Windows, Citrix, Unix AIX, Unix: Solaris

Language / Tools: SAS 9.1.3/9.2/9.3 , SAS/Base, SAS/Macro, SAS/SQL, SAS Enterprise Guide, PC SAS, SAS Management Console, KSH

Other Tools: IBM Rational Clearcase, Quality Center, Serena Dimension, Informatica, Putty, Toad, WinSql, MS Office, SharePoint

EXPERIENCE:

Confidential

SAS Programmer

Responsibilities:

  • Analysis of existing refresh processes.
  • Designed and developed new Confidential using SAS Macros.
  • Develop Quality Check process at two stages.
  • Applied Quality Testing PROC SQL Queries on SAS Datasets to validate the data.
  • Transform SAS Datasets as per business requirement.
  • Automated E-mail Notification during refresh process.
  • Administered SAS Platform, applied hotfixes, license renewal
  • Add/Remove users, Setup and grant access to data libraries
  • Supported OS patching, resolved incidents and user issues.

Tools: Unix AIX, Citrix, DB2, SAS EG, Base SAS, SAS Macros, PROC SQL, MS-Office, SharePoint

Confidential

SAS Programmer

Responsibilities:

  • Developed list generation process to create merchant list eligible for various offers based on value drivers
  • Set up account portfolio data and maintain list history
  • Performed various analytics including Analytical top of chain (ATOC) analysis, ROE, Speed of Pay, Opt-Blue, Seasonality, Triage etc.
  • Designed and developed automated macros to fetch merchant hierarchy data
  • Maintain various data processes including DNC, Attempt History, Merchant Account Profile data etc.
  • Adhoc reporting on various input source data like FFR, Small Business etc.
  • Plug & Play analysis to compare merchants with industry average
  • Prepare Pivot reports in excel for client managers
  • Provide insights on list size and list data
  • Generate alert text and upload list data in merchant force with appropriate list type segment
  • Provide daily and weekly status reports to stakeholders

Tools: AIX, Citrix, SAS EG, Base SAS, SAS Macros, PROC SQL, Merchant Force, MS Office

Confidential

SAS Programmer

Responsibilities:

  • Involved in extensive impact Analysis on existing eligibility processes.
  • Enhanced and modified existing eligibility processes.
  • Created new SAS programs for eligibility, biometrics, incentives processes.
  • Extracted data from SYBASE IQ databases to identify the eligible member.
  • Created new data mart with dimension and fact tables for eligibility, redemption, reward action, digital health assistance etc.
  • Develop Audit and Balance check programs for validations.
  • Designed and developed KSH programs for automatic execution of eligibility processes.

Tools: UNIX - Solaris, Citrix, Sybase IQ, Base SAS, SAS Macros, PROC SQL, KSH, Serena Dimension, Informatica, Ultra Edit, Vi editor

Confidential

SAS Programmer

Responsibilities:

  • Played vital role during impact analysis on existing data captures processes.
  • Enhanced existing daily data capture process to add/update dataset structures for Fee based products and payments.
  • Enhanced existing processes that refreshes SAS data mart and SAS reports and decommissioned obsolete reports.
  • Develop one time adhoc off-load process to retain history data.
  • Design and Develop SAS Macros to calculate new KPIs based on Fees as per business requirement.
  • Responsible for creation of various documents like data mapping, detail design document, Playbook, test cases, status report etc.

Tools: Windows, Citrix, Oracle, PC SAS, Base SAS, SAS Macros, PROC SQL, Toad, Quality Center, Clearcase

Confidential

SAS Programmer

Responsibilities:

  • Involved in analysis of business need for data extraction tool.
  • Design, Build and Test new Stored Processes for data extraction in SAS EGuide.
  • Prepared User Guide for Stored Process GUI
  • Conversion of adhoc flat files into SAS Datasets
  • Merge adhoc datasets with extracted datasets as per business need.
  • Performed admin activities on SAS platform.
  • Used SAS Management Console to create libraries and provide controlled access to the Users.
  • Generate various ad-hoc summary or frequency reports
  • Warranty support and resolve user queries

Tools: Windows, Citrix, SAS EG, Base SAS, SAS Macros, PROC SQL, SAS Stored Process, SAS MC

Confidential

SAS Programmer

Responsibilities:

  • Developed script to automatically download daily feeds.
  • Designed, developed and tested daily and monthly jobs.
  • Developed program to maintain 2 year history and purge old datasets and files.
  • Integrated automated alert e-mails for missing, duplicate files and QC failure.
  • Design and Developed annual card member Industry Spend Summary.

Tools: SAS EG, Base SAS, SAS Macros, PROC SQL, AIX, MS Office

We'd love your feedback!