We provide IT Staff Augmentation Services!

Sas Administrator/programmer Resume

0/5 (Submit Your Rating)

IL

SUMMARY

  • Over 6+ 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 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 in administering SAS Grid environment using SMC and SAS LSF.
  • Worked closely with SAS Experts during SAS 9.4 installation and configuration.
  • Have Fine grip on PAM and LDAP servers.
  • Excellent knowledge inHadoopArchitecture and its major components likeHadoopMap Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, Flume and Avro.
  • Good understanding of teh 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 users 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 6.1 (Enterprise Guide) with Knowledge of BOA and Architecting SAS environments.
  • Created Software Development Life Cycle (SDLC) document and excelled in teh 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 teh operating systems dat SAS is installed on like its memory management, file system Architecture, CPU utilization etc. Hands on Ad-hoc hands on Data Ware Housing.
  • Strong experience and knowledge in using clinical trial data like Demographic data, adverse event data, serious adverse event data, laboratory data and vital signs.
  • Generated various graphs using SAS/GRAPH procedures like PROC GPLOT and PROC GCHART.
  • Conceptual understanding of various business requirements in healthcare and financial and met needs by having firm grip over various procedures like proc SQL, proc report, proc tabulate, proc plot, proc chart, proc format, proc import, proc export, proc print, proc sort, proc compare, proc append, proc connect, etc.
  • Possesses critical thinking, problem solving and decision making skills to dismantle complex problems and optimize solutions. Experience integratingSAS solutions with security including PAM and LDAP/Active Directory.
  • Knowledge of EG console management. Knowledge of different modules in HADOOP.

TECHNICAL SKILLS

SAS Tools: SAS V9.1 9.2,9.3 & 9.4 Base SAS, SAS/SQL, SAS/MACROS,SAS/STAT, SAS/GRAPH, SAS/ODS, ETL, SAS BI Server and SAS Data Integration Platform 4.6 & 4.7,SAS Forecast Studio, SAS Enterprise Guide, SPSS, SAS EB.

Databases: Oracle, DB2, MS SQL Server, and MS Access, Teradata, Netezza

Operating Systems: UNIX (VI EDITOR), MS-Windows XP/2003/2000, and MVS Mainframe

Database Tools: TOAD 9.7.2, PL/SQL Developer 7.1.5

Programming Languages: SQL, UNIX, K-Shell and Perl Scripting

PROFESSIONAL EXPERIENCE

Confidential, IL

SAS ADMINISTRATOR/PROGRAMMER

Responsibilities:

  • Performing SAS product installations withSAS Deployment Wizard on user’s machines and assisting users in connecting to theSAS GRID servers from teh requiredSASproduct for their activities.
  • Install and deploy additional ApplicationServerContexts (SASApp) inSASGrid.Performing SAS product installations with SAS Deployment Manager on users machines and assisting users in connecting to teh SAS Grid servers from teh required SAS product for their activities.
  • Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
  • Creating and removing teh User IDs, user groups, and roles on teh SAS Metadata and giving teh library access by using SAS Management Console. Deep knowledge on SAS LSF platform. Established DB connections like Oracle, SQL server and Netezza connections from teh grid.
  • Responsible for making teh web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application connectivity and ensuring it TEMPhas no performance impact on teh SAS Metadata Server.
  • Working with users to migrate teh processes currently running on 9.3 to 9.4GridPlatform.
  • Configured SAS Grid High Availability with EGO for PM and GMS using Platform RTM.
  • Maintaining SASServer health, Installation of hot fixes, configure server tier, migrate and maintaining teh metadata in LINUX environment.
  • Involved in SAS GridUpgrade from Single node to Multi Node with Hadoop Integration. Working Closely withSAS and IT on gathering requirements to prepare Road Map and Pre-installation document.
  • Improved teh SAS code by using SAS GRID computing which can be executed on Parallel and Sequential Process.
  • Updating teh stored process as per teh SAS code modification so dat teh output statistics were pushed back to teh Oracle Database.
  • Developing Reports and Customizing Portal using SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide, SAS Web Report Studio and SAS Information Portal.
  • MaintainSASmetadata for users, libraries, servers etc.
  • Worked on SASEBIincluding information map studio, web report studio, and information delivery portal.
  • Extensively involved in accessing, managing data, creating reports and to validate data using SAS Enterprise Guide 6.1.
  • Performing statistical analysis, generated reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Report.
  • Extracted data from Oracle data base by using SQL Pass through facility.
  • Created data marts, OLAP Cubes and reports for Business intelligence reporting inSAS usingSASDIStudio and EnterpriseMiner.
  • Collaborated with circulation, loyalty and email marketing teams to undertake customer analytical or testing projects.
  • Design job flows usingSAS DI to extract data from source systems, perform required transformations and load back to target.

Environment: Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Reports, SAS/Connect, Windows XP professional, Oracle, SAS BI, SAS Web Report studio, SAS OLAP cube studio, SAS ODS, Shell scripting.

Confidential, NJ

SAS ADMINISTRATOR/ PROGRAMMER.

Responsibilities:

  • Created teh Metadata Server definitions and libraries connecting to external databases like Teradata by using SAS Management Console.
  • Scheduling teh jobs and monitoring for day to day activities, escalating to technical if for any issues arises. Attending sessions along with users organized by SAS Experts about various SAS Products and clearing up teh user’s queries regarding SAS Grid. 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 teh team and different work groups when needed and provided access to teh 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.
  • Responsible for monitoring system resources like CPU usage, memory usage, runtime of jobs by using RTM.
  • Monitoring teh submitted SAS jobs through teh SAS Platform RTM and grid manager plug in in SAS Management Console.
  • Updating teh file systems and SAS data libraries when their are changes in teh Database.
  • Installed and configured SAS High-Performance Analytics cluster (Root Node and Worker Nodes).
  • Worked as a Portal Admin for publishing teh Reports to different business groups.
  • Hands on experience in creating userteams, server teams and UNIX access rights. Worked as secondaryapprover of user teams onSAS Grid and maintained various distribution list of users.
  • Created SAS Information Maps and Stored processes for developing teh mock up reports and dashboards to teh end users.
  • Designed teh metadata, workflow, models in Excel with great transparency and used SAS macros to process teh excel file and generate ETL, model scoring and cash flow analysis SAS code.
  • Created SAS OLAP cubes, SAS information Maps & SAS Stored Processes.
  • Developed teh Web Reports and designed teh user interface through SAS IDP.
  • Involved in Development, Testing & Support of ETL jobs using SAS DIStudio.
  • Used SAS Data integration studio for registering teh tables and creating teh libraries pointing to Teradata database.
  • Hands on experience inSAS EnterpriseBusinessServerAdministration with a strong background in UNIXSystems Administration with on-call production support.

Environment: SAS Management Console, SAS/Reports, SAS/Connect, Windows XP professional, Teradata SQL/Assistant, SAS BI, SAS Web Report studio, SAS OLAP cube studio, SAS ODS, Shell scripting.

Confidential, NJ

SAS DEVELOPER/ADMINISTRATOR

Responsibilities:

  • Designed and creating SAS datasets from various sources like Exceldatasheets, flat files, creating reports and files from existing SAS datasets.
  • GeneratedSAS datasets, tables, listings, graphs and reports from analysis datasets usingSAS tools like BASE, Macros, GRAPH and STAT. Configure SAS App Server context, grid-launched, load-balanced workspace server and stored process server, etc
  • Establishing data source connectivity to Oracle Exadata and Greenplum usingSAS Access. Building connectivity to MS Sql Server using ODBC driver manager.
  • Designed complete End to End business reports from teh point of gathering teh requirements and understating teh logical data model to end user reports.
  • Created SAS Information Maps and Stored processes for developing teh mock up reports and dashboards to teh end users.
  • Created SAS OLAP cubes, SAS information Maps & SAS Stored Processes.
  • Used IMPORT and EXPORT procedures for importing and exporting teh data to MS/EXCEL files.
  • Installed & Configured SASAccess to Netezza DB on all teh SDLC Environments.
  • Modified and developedSAS Programs,SAS Macros for analyzing financial data. Statistical analysis of files, tables, listings, and graphs.
  • Evaluated various tables using data manipulation techniques like Merging, Appending and Sorting. Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC SORT, PROC FREQ, PROC COMPARE, PROC UNIVARIATE, andSAS/MACROS.
  • Created and extracted Oracle tables fromSAS and within Oracle by using PL/SQL using SAS /ACCESS andSAS /CONNECT.
  • Data preparation, cleaning, manipulation, and visualization. Extract data from relational databases and perform complex data manipulations. Conduct extensive data checks to ensure data quality.

Environment: BaseSAS,SAS /ACCESS,SAS /CONNECT,SAS /STAT,SAS /GRAPH,SAS /SQL, SAS /ODS, UNIX, Mainframes,SAS Enterprise Guide,SASBI.

Confidential

SAS ADMINISTRATOR/DEVELOPER

Responsibilities:

  • Developed and maintained documentation of teh system configuration, procedures, and apply hot fixes and maintenance releases toSAS9.1.3 & 9.2, as well as SPD &clientSASproducts.
  • Designed and developed routines usingSASEG/BaseSASto support ad hoc reports including automation in theSASWebReportStudio.
  • Responsible for optimizing all indexes,SQLqueries, storedprocedures to improve teh quality of software. Created teh Metadata Server definitions and libraries connecting to external databases like Teradata by using SAS Management Console.
  • Debugging and troubleshooting teh bugs and errors while deploying in to SIT, UAT & PROD Environments.
  • Used SAS Data integration studio for registering teh tables and creating teh libraries pointing to Teradata database.
  • Deploying teh Code and other code related objects from one environment to another environment.
  • Generated database monitoring and data validation reports inSQLServer Reporting Service (SSRS).
  • Developed new/modified macros for report generation using SAS/Macros as per business requirements.
  • Program inSAS for analyzing data and producing safety and efficacy tables, listings and figures.
  • Reading data from Excel, Oracle and Raw data from Text Files and converting them toSASdatasets and or writing to Flat Files, Oracle Tables and Excel files and generating Reports RTF and HTML formats using Data Null, SAS/ODS, PROC REPORT.
  • Extensive experience working with teh differentSASServer Log files such as Metadata, Workspace Server, and Object Spawner logs & use them to find out any issues.
  • Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming within strict timelines while under constantly changing requirements using SAS, PROC SQL, and Teradata SQL in a UNIX environment with Oracle, Informix, and Teradata relational databases.

Environment: s:SQLServer 2005/2008 Enterprise Edition, MSSQLProfiler,SQLQuery Analyzer, UNIX.

Confidential

SAS DEVELOPER.

Responsibilities:

  • Designing, implementing, and executing teh change control and promotions tasks in SAS.
  • Establishing best practices and guidelines for SAS BI usage.
  • Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing with teh SAS Institute for Support on administrative and system issues.
  • Creating and implementing upgrade plans.
  • Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
  • Strong knowledge of teh operating systems dat SAS is installed on, such as memory management, file system.
  • Architecture, CPU utilization etc.
  • Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.
  • Conceptual understanding of SAS Customer Intelligence Studio, SAS Information Map Studio.
  • Performed Data Validation and Data Cleaning using procedures like Proc Freq, Proc Means, and Proc Univariate.
  • Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS EG, SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
  • Modifying, Debugging and Creating SAS Macro programs.
  • Prolifically generated SQL queries for teh reports.
  • Successfully identified problems with teh data, produced derived data sets, tables, listings and figures, which analyzed teh data to facilitate correction.

Environment: SAS/ BASE v 8.1 & 8.2, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, MS EXCEL Windows XP.

We'd love your feedback!