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

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

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

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

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

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

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