Sas Administrator Resume
TX
Professional Summary
- SAS Administrator and Programmer with over 4Years of industry experience in using SAS Administration, programming and reporting in Pharmaceutical industry.
- Adding users, registering tables, etc. using Management Console;
- Installation of client applications and Troubleshooting technical problems.
- Strong experience working with Oracle on Unix using command line and GUI SQL tools.
- Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications
- Monitoring SAS Server resources and reporting usage(s)
- Identifying performance and recommending/implementing tuning of active SAS environment(s) providing projected capacity shortfalls.
- Designing, implementing, and maintaining security on SAS Metadata and Linux for users
- Designing, implementing, and executing the 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 the 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.
- Monitor and log SAS servers and optimize memory usage or tune servers for optimal performance.
- Focus on areas of capability, interoperability, scalability and enterprise class issues (i.e. like failover).
- Act as a liaison to SAS Technical Support for SAS users at the clients site
- Reviewed, validated, documented and mentored SAS Admin and team regarding SAS environment.
- Documented best practices for the SAS Application server from a scalability need.
- Strong experience in Base SAS, SAS/MACROS, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/DI and SAS/SQL in Windows and UNIX environments.
Education:
Certified SAS Administrator
Certified BASE SAS Programmer
Technical Skills:
SAS Skills : SAS Management Console, SAS Enterprise Guide,
BASE SAS, SAS/MACRO, SAS/CONNECT, SAS-SQL,
SAS/STAT, SAS/GRAPH, SAS - ODS, SAS/ACCESS, SAS/DI.
SAS Procedures : PRINT, TRANSPOSE, CONTENTS, MEANS, CHART, PLOT,
TABULATE, UNIVARIATE, SUMMARY, SORT, SQL, FORMAT, FREQ AND DATASETS
Languages : COBOL, JCL, C
Operating Systems : MS WINDOWS, UNIX
Databases : DB2, IMS/DB, ORACLE
Professional Experience:
Confidential,
Austin TX May\'08– Feb’12
Role: SAS Administrator
OncoCare pharmaceuticals is a clinical research organization dedicated to research in oncology, with primary goal of developing new treatments and supportive care for cancer patients. The project focuses on analyzing the data from a comparative study of investigational adjuvant therapy with an established adjuvant therapy in preventing the recurrence of cancer in surgically treated stage II colon cancer patients.
Responsibilities:
- Holding a certification of "SAS Platform Admin for SAS 9"
- Responsible the SAS EBI 9.1 & 9.2 platforms that run on Development, QA, and Prod environments including BI security and managing Read/Write privileges of users and supports 24/7, Responsible for production of Risk Model outputs as well as related reports during and after the production cycle.
- Developed and implemented real-time error-capturing code in SAS for production environment,
Displaying various reports and model results on SAS Web Report Studio via SAS stored process for diverse bank departments. - Supported a total of 4 departments with 25 people for their needs in terms of data and/or reports.
- Develop and maintain documentation of the system configuration, procedures, and apply hotfixes and maintenance releases to SAS 9.1.3 & 9.2 as well as SPD Server & client SAS products,
Design and develop routines, tools and using SAS EG/Base SAS to support ad hoc reports including automation in the SAS Web Report Studio. - Make the full implementation of Risk models into DEV, QA, & Prod environments and version them by using Version Control software, Configure and conduct performance-tuning of general SAS programs in SAS BI platform 9.1 & 9.2.
- Communicate and jointly work with IT departments, database administrators and business lines,
Create data schemas and data models to extract data from various databases across the organization, and Compare the SAS model logics for the business units and support them via Ad Hoc reporting based on their needs. - Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
- Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
- Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate.
- Generated Tables, Listings and Graphs using various procedures like Proc Freq, Proc Report, Proc Tabulate, Proc Univariate , Data _null_, and Proc Gplot for final FDA study reports.
- Created SAS Macros and modified the existing ones relating to multiple studies.
- Knowledge of advanced SAS procedures like ANOVA, GLM.
- Produced tables, listings, graphs for Integrated Summaries of Efficacy (ISE) and Safety (ISS).
- Generated derived data sets for the statistical analysis as per SAP.
- Experienced in validating programs and in writing competing codes to re-check the statistical values of tables.
- Proficient in indicating the input data sets, setting, sorting and merging techniques to get the required report.
- Generated Ad-hoc reports and browser viewable reports using SAS\\ODS
- Worked on CDISC standards.
Environment: SAS Management Console, SAS Enterprise Guide, SASBASE 9.2, SAS/STAT, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, UNIX.