SUMMARY:

• Base SAS Programmer with over 5 years of experience working with SAS and SAS tools Emphasizing on Analysis, Development, Design, Testing and Implementation of various projects.
• Hands on Experience in SAS Programming for Extracting the Data from Flat Files, Excel Spreadsheets and External RDBMS (Oracle) tables using LIBNAME and SQL Pass - Through Facility.
• Expertise in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macro, SAS/EG, SAS/Share, SAS/Enterprise BI Server, SAS Management Console.
• Extensive Domain Knowledge and Experience in the diversified fields of Banking, Healthcare, Insurance, Airlines, Manufacturing and other Financial Service Sectors.
• Experience in Data Manipulation and Data Cleansing by using Procedures such as Proc Datasets, Proc Sort, Proc Transpose etc.
• Handled Client Key Enhancement Work Requests by following SDLC Process.
• Documenting the Data in Appropriate Way by following Quality Standards for Future Use and Reference.
• Experience in Developing SAS codes using SAS Enterprise Guide and SQL Queries in SAS for creating stored processes using the Dynamic Prompts containing both Packaging and Streaming Output, and Prepared Reports using ODS.
• Extensively used SAS Procedures such as Freq, Report, Tabulate, Sort, Print, Transpose, Summary and Means for producing Customized Reports and External Files.
• Involved in creating dashboards and reports in TABLEAU and Maintaining Server activities, User Activity and Customized Views on Server Analysis.
• Expertise on Optimization by writing SQL queries using SAS/SQL.
• Knowledge of Data Warehousing, Tables and Structure.
• Performed Bug Tracking, Issue Tracking and Project Management using the Operational Tracking tool JIRA.

PROFESSIONAL EXPERIENCE:

SAS PROGRAMMER ANALYST

Confidential

Responsibilities:

• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS / Base and SAS / Macro facility.
• Involved in the creation and conversion of SAS datasets from tables and flat files, analyzing the dataset and generating reports by employing complex data manipulation.
• Transformed the SAS datasets as per the business model requirements using various SAS data step techniques and procedures.
• Extracted data from warehouse using the LIBNAME statement and SQL pass through facility to create SAS data sets for reporting and analysis.
• Actively involved in reading text files into SAS, creating SAS datasets, analyzing large SAS datasets, generating delimited files and writing SQL load script to load the data into SQL Tables.
• Worked on SAS Enterprise Guide to perform data analysis and develop stored processes to distribute the reports in a secure manner.
• Used PROC Report and Various Procedures to build the Desired Reports.
• Carried Out Data Extraction and Data Manipulation using PROC SQL, PROC SORT, PROC REPORT to Create Reports as per the business requirements.
• Extensively used PROC SQL and SELECT Sub-Queries to generate various reports by connecting to the Oracle DB.
• SAS Enterprise Guide was used to convert the existing SAS Programs to SAS Stored Procedures using Dynamic Prompts and produced Packaging and Streaming outputs as required.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Cleaned existing data and converted them into useful SAS Datasets, Merged Datasets and created reports based on Ad-hoc requirements.
• Used SAS GRAPH for generating various graphs and charts for analyzing the data.
• Prepared/Review Unit and System Test Cases for the new development and Enhancement Requests.
• Worked in both Windows and UNIX Environment.
• Developed Statistical Reports with Charts, Bar Charts, Box Plots, Line Plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Created Dashboards in TABLEAU to assist Release Management to oversee progress of projects reducing 60% effort.

Environment:: SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/Macros, SAS/EG, SAS/ODS, SAS/ACCESS and SAS/CONNECT, SQL Studio, SQL Server Management Studio, TERADATA, TABLEAU, DB2, SQL SERVER 2008, WINDOWS XP, SAS Enterprise Guide, Information Delivery Portal, Information Map Studio, MS Excel.

DATA ANALYST

Confidential

Responsibilities:

• Developed programs in SAS for converting ORACLE data into SAS datasets using SQL pass through and LIBNAME Facility.
• Extracted data from SAS datasets and raw data files with SAS/INFILE.
• Performed Data Profiling with tools like PROC FREQ, PROC UNIVARIATE.
• Performed data look up by using MERGE and PROC SQL.
• Generated Reports using PROC PRINT, PROC CONTENTS, PROC FREQ, PROC MEANS, PROC TABULATE and PROC SUMMARY.
• Developed SAS macros to simplify SAS Code and efficiently reduce the coding time.
• Performed Sub setting and Manipulation of data with SUBSTR, SCAN, CATX functions etc.
• Created Views with PROC SQL to avoid storing Large data set copies and prevent other users from altering the query code.
• Imported Microsoft Excel and CSV Files into SAS.
• Performed Random Sampling of data using SAS.
• Restructured data to wide or narrow data sets by using PROC TRANSPOSE or Arrays.
• Generated Reports using ODS into formats such as RTF, PDF and HTML.
• Visualized Data using different types of charts in EXCEL.
• Performed Merging of Microsoft Excel File with SAS data set.

SQL DEVELOPER

Confidential

Responsibilities:

• Developed complex SQL code using complex Joins, Group By, Having Sub Queries, Correlated Sub Queries, Functions and User Defined Functions.
• Gathered Requirements to Identify and Create Database Objects such as Tables, Views, Triggers and Indexes.
• Involved in Creating the Constraints, Rules, Defaults and Triggers to maintain the Data and Referential Integrity.
• Created ER Diagrams using Visio.
• Created Database Objects - Tables, Indexes, Views, User Defined Functions, Cursors, Triggers, Constraints and Roles.
• Created Views to Enforce Security and Data Customization.
• Created Stored Procedures for commonly used Complex Queries involving JOIN and UNION of Multiple Tables.
• Developed Edit Check Programs to clean invalid data from database.
• Reviewed basic SQL queries and Edited Inner, Left and Right Joins in TABLEAU desktop by connecting live/dynamic and static datasets.