SUMMARY

• Over 5+ years of experience in administration, developing programs, statistical analysis and reporting in clinical and research, IT and healthcare environments using SAS Software.
• Experience and knowledge in using Base SAS, SAS Via 3.5, SAS Enterprise Guide, SAS Enterprise Miner, SAS stored process, SAS/MACROS, SAS/SQL SAS/ODS, SAS/GRAPH, SAS/STAT, SAS/ORACLE, SAS/CONNECT, SAS/ACCESS and SAS/SHARE. Deep knowledge in Data Warehousing concepts.
• Experience working, Installing & Configuring SAS EBI platforms, SAS via 3.5 with SAS 9.3 & 9.4.
• Experience and worked on SAS via Model studio, Visual text analytics and Forecast analysis.
• Experience in administering SAS Grid environment using SAS Management Console and SAS LSF
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Have Fine grip on PAM and LDAP servers.
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Excellent knowledge inHadoopArchitecture and its major components likeHadoopMap Reduce, HDFS Frame work, HIVE, PIG, Base, Zookeeper, Swoop, Oozy, Flume and Avro.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment with excellent troubleshooting skills. Have Health Care Domain Knowledge.
• Hands on experience in performing client installations of various SAS products like SAS Enterprise Guide, SAS Enterprise Miner, SAS Add - in and SAS Model Manager on user’s machines.
• Experience in setting up connections to different Databases like oracle, SQL, DB2, HADOOP and NETEZZA according to users requirement. SPDS implementation. Retail ecommerce experience
• SAS EG 8.1 (Enterprise Guide) with Knowledge of BO And Architecting SAS environments
• Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes.
• Strong knowledge on LINUX and SHELL SCRIPTING, Worked as BASE SAS programmer.
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations Management. strong knowledge on SAS HPA architecture
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong knowledge of the operating systems that SAS is installed on like its memory management, file system Architecture, CPU utilization etc. Hands on Ad Hoc. Hands on Data Ware Housing.
• Converting existing reports programs to stored procedures And Converting existing BO reports to enterprise guide

TECHNICAL SKILLS

Statistical Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS, JMP PRO

Database: Teradata, Oracle, DB2, MS-SQL Server 2005, MS Access.

Operating systems: Unix, Linux & Windows

Scripting Languages: Shell scripting, python, Perl.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis-MN

SAS Developer/BI Content Administrator

Responsibilities:

• Hands on experience in SAS Enterprise Business Server Administration with a strong background in UNIX Systems Administration with on-call production support.
• Performing SAS product installations with SAS Deployment Manager on users machines and assisting users in connecting to the SAS Grid servers from the required SAS product for their activities.
• Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
• Creating and removing the User IDs, user groups, and roles on the SAS Metadata and giving the library access by using SAS Management Console. deep knowledge on SAS LSF platform
• Creating directory for every individual users in a particular file system to store their datasets and directing them to the path in the assigned server. worked on Ad Hoc programming.
• Good understanding of MPP databases such as Teradata, Greenplum and Netezza.Worked close with admin teams in monitoringHadoopcluster.Working onTeradataManager to monitor and manage resource utilization.
• Working with utilities Like BTEQ, MLOAD, FLOAD, TPump etc
• Performing User Migration and Data migration (datasets and tables) from DSAP 9.3 servers to SAS Grid 9.4 servers and assisting users to fetch migrated data in the grid. worked in teradata environment and prepared datasets and libraries along with tables in it.
• Worked on LINUX and SHELL SCIPTING. strong knowledge in Data Warehousing Concepts.
• Established DB connections like Oracle, SQL server and Netezza connections from the grid.
• Responsible for making the web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application connectivity and ensuring it has no performance impact on the SAS Metadata Server.
• Experience in trouble shooting issues like file system unmounts, space outage issues, MEMSIZE issues, performance issues, service packs, checkouts after releases, hot fixes, monitor services regularly and perform service start, stop and status check when required and PAM and LDAP
• Creating EG projects from multiple SAS programs Building queries using EG Building Graphical reports using existing SAS programs Knowledge of EG console management Create reports using point and click
• Responsible for monitoring CPU usage, Disk usage, and system resources.
• Interacting with different Support teams like UNIX Administration, Database Administration, Production Job Scheduling Team, Middleware Team and others to meet SAS Developer’s access and connectivity requirements.
• Experience in interacting with SAS Technical support and opening tickets about issues when required.

Environment: BASE SAS 9.4, SAS Enterprise Guide 6.1, SAS Management Console 9.4, SAS Enterprise Miner 13, SAS Model Manager 12.3, SAS Add - in Microsoft office and SAS DI Studio in WINDOWS 7, XP AND RHEL 6.4.

Confidential, Newark, NJ

SAS Developer/GRID Administrator

Responsibilities:

• Experience in installing, configuring and administering any issues related to SAS Enterprise guide, SAS Enterprise miner, SAS DI studio and SAS Stored process.
• Experience working in the SAS GRID Environment. ability to configure Queues/Policies in SAS GRID environment. have hands on experience in SAS EBI like information map studio, web report studio, information delivery portal.
• Scheduled servers for the implementations and maintained servers with the client requirements.
• Performed tasks for software installations, windows security patch installations and license renewal on LINUX SERVERS. Worked on Data warehousing. Worked on Analysis, Development, Design, Testing and Reporting of ETL tools
• Troubleshooting SAS server issues such as system access and password problems, file system filled issues, enterprise guide or miner throwing errors to users, changing IP address of virtual machines etc.
• Experience in providing access to users to SAS and various SAS products for daily activities. Also provided access to the team and different work groups when needed and provided access to the agents for various roles and sub roles for performing their activity in marketing operations management.
• Perform stop, start and status check of services asp.net and user feed services after installations.
• Strong understanding about how SAS interacts with third party software such as databases (DB2, SQL SERVER, ORACLE), web application servers, etc. strong knowledge on SAS HPA architecture
• Understanding of how to apply hot patches, service packs and do version upgrades.
• Worked as Server Type Owner (STO) for Linux and windows and driven process of ESR implementations by accessing ESMT and coordinating with TAEs and project team and fixing the dates.
• Monitoring and troubleshooting SAS servers and processes, including error messages by using system logs or server logs or setting logging options as well as options within SAS Management Console (SMC)
• Worked on security issues. Aware of checking logs and resolving issues.
• Dealt with storage issues in windows web server in production. Has capacity to preplan and be prepared with available space before any reports or backup is to be performed.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• Conceptual understanding of designing and executing marketing campaigns with SAS CI Studio.

Environment: BASE SAS v 9.2 & 9.3, SAS Enterprise Guide, SAS DI Studio, SAS Management Console, SAS Enterprise Miner, SAS Web Report Studio, SAS Stored Process, SAS MA, MO & MOM in WINDOWS AND LINUX.

Confidential

SAS BI CONSULTANT

Responsibilities:

• Experience working in the SAS GRID Environment,ability to configure Queues/Policies in SAS GRID environment. have hands on experience in SAS EBI like information map studio, web report studio, information delivery portal.
• Performed tasks for software installations, windows security patch installations and license renewal on LINUX SERVERS. Worked on Data warehousing. Worked on Analysis, Development, Design, Testing and Reporting of ETL tools
• Troubleshooting SAS server issues such as system access and password problems, file system filled issues, enterprise guide or miner throwing errors to users, changing IP address of virtual machines etc
• Experience in providing access to users to SAS and various SAS products for daily activities. Also provided access to the team and different work groups when needed and provided access to the agents for various roles and sub roles for performing their activity in marketing operations management.
• Extensively worked with JMP PRO for performing various modeling techniques like Logistic Regression Analysis, Multiple Regression Analysis, cluster analysis, Decision Tree Analysis, Correlation Analysis.
• Created Heat maps, Bubble plots, pareto distribution charts and other various business requirements-oriented charts.
• Created SAS datasets in local SAS directory using SAS DI (Data Integration) through different transformations.
• Ensured the validity and accuracy of the analyzed data.
• Created Information Maps to feed Web Report Studio which generated reports.
• Strong understanding about how SAS interacts with third party software such as databases (DB2, SQL SERVER, ORACLE), web application servers, etc. strong knowledge on SAS HPA architecture
• Worked as a lead to the offshore team.

Environment: BASE SAS v 9.2 & 9.3, SAS Enterprise Guide, SAS DI Studio, SAS Management Console, SAS Enterprise Miner, SAS Web Report Studio, SAS Stored Process.