Summary

• Thorough understanding and expertise in the various aspect of the core SAS Concepts including the following
• Self-motivated, multitasking and multi skilled experienced SAS programmer with a comprehensive skill set in SAS System, R Language, Statistics , SQL , Operating systems Linux/Windows and Business and Scientific Computing C/Fortran with 7 years of SAS experience.
• Areas of interest and substantial experience include predictive analytics, data modeling, technical and business forecasting, engineering in the presence of uncertainty, Statistical analysis
• Core skills include, among others, the following

Recent Clients :

• Wells Fargo Bank Analytics consultant
• Comerica Bank Current SAS BI Administrator

SAS Administration-

• SAS management Console,-User Administration, Server and Libraries Administration. Some of the tasks are listed below
• SAS Automation- Automating SAS Jobs- Linux/mainframe/ Windows
• Supporting SAS users- Program development SQL, Macros, Stored procedures
• Trouble shooting SAS programs, SAS EG
• Installation/Migration of SAS Software SAS 9.2/9.3/9.4
• Installing and configuring ODBC Drivers- odbc.ini. Oracle Client and Data Direct drivers
• Optimizing SAS IO
• Coordinating with SAS Tech supports
• Packaging of Virtual apps for SAS Clients
• Supported SAS Clients for Windows 7 migration
• Supporting SAS on Linux Red Hat Enterprise Linux / Suse Enterprise Linux and Windows Servers.
• Operating System Administration

SAS Programming, Development and Data Analysis

• ETL Extracting, loading and transformation - Data import Data integration, Data Validation, Data Cleansing and - interfacing with various databases such as MS EXCEL / ACCESS/ MS SQL/MySQL/ ORACLE- Handling large datasets
• SAS SQL - Using Implicit / Explicit pass through and ODBC Connections. Configuring ODBC Drivers
• Data manipulation Merging / partitioning and exporting of data
• SAS Stored processes- Supporting/troubleshooting/creating stored processes with prompts
• Programming / development / creation of user defined SAS macros, user defined functions, creating and linking DLL's to SAS functions. DLL creation using GCC Cygwin / Min GW
• Reporting, Data modeling and visualization- Creation of data models and predictive analysis, statistical analysis
• Regression Analysis and modeling of data-model testing / validation
• Data Analysis and reporting with MS SQL Server , MySQL

System Administration

• Linux / Unix system administration Installation, configuration, Troubleshooting/ Desktop / Server user /systems management and all aspects of system administration. Backups. Environment modules and clusters Red Hat / SuSE Cent OS / Ubuntu / Free BSD etc .Shell scripting Bash /Ksh / C shell.
• Writing Shell Scripts for Automating SAS Jobs

• Documentation Documenting process and development activities Latex Document Preparation System Windows /Unix / Linux Good Knowledge of Windows Operating system installation, configuration, Troubleshooting/ Desktop / Server Remote desktop , SSH/Putty /FTP Installing configuring upgrading applications / software SAS / MSSQL / ORACLE etc / Antivirus
• Office systems Microsoft, IBM Lotus SmartSuite, Open/Libre, MS SQL / Oracle /My SQL
• Experience in EXCEL, Excel Macros / VBA / Pivot Tables/ Power pivot

Professional Experience

Confidential

SAS Administrator

• SAS Support- Level 2 Technical support to SAS / JMP/AMO users
• SAS Automation- Automating SAS Jobs- Linux/ mainframe /SAS EG
• Supporting SAS users- trouble shooting SAS programs, SAS EG
• Installation/Migration of SAS Software
• Installing and configuring ODBC Drivers- odbc.ini. Oracle Client and Data Direct drivers
• Optimising SAS IO Optimised SAS IO on Windows servers
• Co-ordinating with SAS Tech supports
• Packaging of Virtual apps for SAS Clients

Confidential

SAS Analytics Consultant

• Supported Analytics for the Credit Risk/ Basel modeling group.
• Creating SAS Datasets from the Excel Files and vice versa
• Data Cleaning, Data manipulation as per client requirements.
• Performing Analytics and testing models.

Confidential

SR. SAS Developer

Responsibilities

• Supported ad-hoc, standard reporting and production projects.
• Designed and implemented a number of standard processes that are maintained and run on a scheduled basis.
• Compiled sales production for executive management. Data included employee activity, client coverage and territory alignment analysis.
• Designed, built and tested a series of SAS programs for the transfer and validation of reports.
• From SAS jobs, developed CSV files and reported progress to management with the use of Excel Templates, Excel macros, Pivot tables and functions..
• Created daily HTML reports using SAS ODS.

Environment: Base SAS 9.1.3,

Confidential

SR. SAS Developer

Responsibilities

• Develop, test, and debug SAS programs to model business rules into analysis programs.
• Analyze data/results to measure performance of the Needs Analysis model.
• Summarize data extensively to transform data to a common level across functional elements.
• Extensively used SAS Macros for programming,.
• Performed match merge/joins of data between functional elements.
• Documented all changes to programs.
• Provided ad-hoc programming support for analysis/changes.
• Used Proc SQL to query source data, and analyze/report data quality.

Environment: SAS 9.1.3,

Confidential

SAS Developer

Responsibilities

• Supported ad-hoc, standard reporting and production projects.
• Designed and implemented a number of standard processes that are maintained and run on a scheduled basis.
• Compiled sales production data for executive management. Data included employee activity, client coverage and territory alignment analysis.
• Designed, built and tested a series of SAS programs for the transfer and validation of reports.
• From SAS jobs, developed CSV files and reported offshore progress to management with the use of Excel Templates, Excel macros, Pivot tables and functions.
• Created daily HTML reports using SAS ODS.
• Programs updating / modification / migration and documentation.

Confidential

SAS Developer

Responsibilities

• Design select appropriate SAS procedures for each statistical analysis test-run SAS program on mock data to ensure smooth analysis implementation.
• Use PROC SQL/IMPORT to import data from mainframe oracle clinical databases and MS excel sheets.
• Standards with the techniques of Macro, SQL Join, and DATA Step Sort and Merge.
• Produce quality customized reports as per client requirement
• Work with statistician to analyze the results obtained from various statistical procedures like PROC REGRESSION
• Develop and debug routine SAS macros to create tables, graphs and listings.
• Contribute to the development of manuscripts, labels, scientific and commercial presentations, and regulatory response documents by generating statistical tables and graphs through SAS programming.