PROFESSIONAL SUMMARY:

• SAS Programmer having around 8 years of experience in analysis, design, development, testing and implementation of Applications in Financial, Retail and Healthcare Industry using SAS Software.
• Technical expertise in Base SAS, SAS/MACROS SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/IntrNet, SAS/CONNECT and SAS/ODS etc in Windows, Mainframe & Unix environment.
• Extensively used ETL to transform and load data from Oracle database, XML files, flat files to Oracle.
• Possess expertise in utilizing SAS Functions, SAS Procedures, Macros, and other SAS application for data updates, data cleansing, and reporting.
• Technical expertise in developing programs to generate derived datasets from raw data imported from various sources.
• Possess expertise in Data management, data extraction, manipulation, validation, and analyzing huge volume of data.
• Experience in transforming data imported from different data sources into analysis data structures, using SAS functions, options, ODS, macro facility and other SAS procedures.
• Experience in extracting data from relational databases like Oracle, Teradata, SQL Server and MS Access etc.
• Experience in Developing and designing SAS Programs / Macros to access and analyze financial data. submissions.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Experience in working with large technical teams to understand requirements and to develop code based on SDLC procedures.
• Experience in transferring data across different environments using FTP and SFTP.
• Experience in writing UNIX shell scripts
• Detail oriented, organize and enthusiastic to work in a fast paced and team oriented environment
• Possess strong communication skills and problem solving skills.

TECHNICAL SKILLS:

ETL & Reporting Tools: Base SAS, SAS/MACROS SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/IntrNet, SAS/CONNECT, SAS/ODS, Ab- Initio (GDE 3.12.5.2, Co>Operating system 3.12.3)

RDBMS: Teradata V2R6.2, Oracle 8i/9i/10g, SQL Server, DB2, MS Access.

DB Tool: SQL*Loader, TOAD, Teradata SQL Assistant

Languages: SQL, XML, Korn Shell Scripting.

Platforms: Sun Solaris 7.0, HP-UX UNIX, Windows NT/XP/2000/98/95, MS- DOS.

Modeling Tools: Erwin, MS Visio

WORK EXPERIENCE:

Confidential, New York

SAS Reporting Analyst

Responsibilities:

• Requirements gathering for the Reporting.
• Extracted data from Teradata using the Sql Pass Through facility.
• Coded the SAS Macros to extract the data, cleanse and analyze the data.
• Involved in extensive SAS Reporting to detect the fraud and to identify the credit risk customers.
• Managing and reviewingSAS Log Files and performance tuning.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only the concerned end users can view it.
• Embedded Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for credit risk customers with forecast and lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Designing Test Plans, Test Cases and performed System Testing.

Environment: SAS/BASE,SAS/MACRO,SAS/SQL,SAS Enterprise Guide, Tableau 8.1, U E Studio, Sybase, Teradata, UNIX.

Confidential, New York

SAS Reporting Analyst

Responsibilities:

• Understanding the current environment and requirements for the Code conversion.
• Converted the existing SAS macros with Sybase queries to SAS macros Teradata Queries.
• Understood the Sybase queries and translated them to the Teradata equivalent.
• Identified the limitations of Teradata with respect to performance and functions and accordingly optimized the queries.
• Tested the Teradata queries in SQL Assistant before embedding them in the SAS macros.
• Modified the existing SAS macros to include the SAS SQL wherever applicable to create SAS Datasets.
• Created CSV files out of the SAS Datasets and exported the files to Hadoop environment for further processing.
• The final data is dumped into SQL Server which again is used to populate the front end of the VISE (Visual Search Engine) platform.
• Explored and performed fine tuning and optimization of SAS codes and Teradata queries to bring the runtime of code from couple of hours to few minutes.

Environment: SAS/MACRO,SAS/SQL,SAS Enterprise Guide, U E Studio, Sybase, Teradata SQL Assistant, SQL Server, Hive, UNIX.

Confidential, New York

ETL Developer

Responsibilities:

• Extracting the data from the source system (Unix Server) to the staging area.
• Transforming the data using Ab initio Graphs. An Ab initio graph would be designed for this purpose.
• The transformed data would be converted into the load ready file using the load ready graph.
• The load ready file would then be loaded into the Teradata table.
• Any new customer or existing customers are identified by their customer id and account number as the keys in the Teradata table while loading or accessing data from the tables.
• Earlier SAS ETL was used in extracting, transforming and loading the data.
• The SAS coding had to be converted into Ab initio graphs to perform the ETL Tasks according to the customer request.

Environment: SAS 9.1.3, Ab Initio (GDE 3.12.5.2, Co>Op 3.12.3), Teradata V2R6, TOAD, UNIX.

Confidential

SAS Developer

Responsibilities:

• Tasks in Data Segmentation & Building a predictive Model (Score Card) using Data Integration Studio,
• Designing a Process in the repositories.
• Creating Metadata that defines Source, Target and Transformation.
• Report generation
• Deploy jobs for scheduling.
• Managing Resources throughout the Intelligence Value Chain
• Managing Job scheduler, Server and User manager.
• Application Monitoring & Management.

Environment: SAS 9.1.3, SAS Macros, SQL, Ab Initio (GDE 3.12.5.2, Co>Op 3.12.3), UNIX, Toad, Teradata, Remedy.

Confidential

SAS Developer

Responsibilities:

• Requirement Analysis, Design and Building of Reports through SAS Enterprise Guide.
• Scheduling of Reports to run every quarter.
• Setting up of Automatic Email reminders to the concerned individuals.

Environment: SAS 9.1.2, SAS Enterprise Guide 4, Windows 2000.

Confidential

SAS Developer

Responsibilities:

• Requirement Analysis, Design and building of various interfaces like Max Interface, EtrainInterface.
• People Information reporting Online Interface.
• Develop and maintain Business reports for People Capital Analysts and line Managers.

Environment: SAS 9.1.3, SAS AF, SAS Macros, Windows 2000

Confidential

SAS Developer

Responsibilities:

• Responsible for creation for designing and development.
• Used SAS and ASP to bring the features of SAS on to the web.
• Extensively used Base SAS and SAS AF for the ETL process.
• Implemented role level security features for the online reports.

Environment: Base SAS 9.12, SAS AF, SAS macros

Confidential

SAS Programmer

Responsibilities:

• Production Support for the Auto analyst Application.
• Enhancement Work like adding some code to include some functionality in the existing process.
• Maintenance Work that includes fixing the bugs.
• Unit testing and Module testing of the code before promoting it to SQA.

Environment: MAINFRAMES, BASE SAS, SAS MACROS, SAS SQL

Confidential

Statistical Programmer

Responsibilities:

• Importing data from Oracle database for Phase I clinical study data and employing PROC IMPORT to analyze data.
• Providing statistical SAS programming support, by producing analysis datasets, QC programs for pharmacokinetic (PK) studies
• Performing data validation on the Phase I clinical study and creating ad hoc reports.
• Using SAS/MACRO with DATA step, SET statements and PROC SQL to bring data into processing programs, and drawing statistical information for reporting through PROC FREQ, PROC UNIVARIATE, and PROC REGRESSION.
• Using PROC FORMATS and PROC INFORMATS to change data types in accordance with protocol.
• Generating tables and listings for Patient Demography and Adverse Events data for Phase I and Phase II studies.
• Creating SAS datasets of clinical data from clinical databases
• Developing status and efficacy datasets, project specific macros and formats.
• Loading client data from other platforms and other software packages;.
• Preparing documentation describing all datasets and variables including derived variables.
• Performing data checks as needed, to ensure integrity and correctness of data displays.
• Programming customized data displays, (including data listings, summary tables and routine graphics) in accordance with approved statistical analysis plan and shell displays for clinical research studies.
• Coding using Base SAS programs, SAS procedures, or standardized macros.
• Performing data checks as needed to understand structure and content of data.

Environment: SAS 9.1.2, Oracle, SAS SQL, SAS Macros, MS Excel