SUMMARY

• Certified SAS Professional in Base SAS, SAS Platform Administration, SAS BI Content Developer and SAS Visual Analytics 7.3 Reporting and Design with 7 years of experience in various industries like Financial, Healthcare & clinical domains.
• Possessed sound knowledge in SAS Servers and Workstation’s Installations & Configurations of various SAS Products (SAS 9.1.3, 9.2, 9.3 and 9.4) in SAS EBI, EDI, Forecast, Enterprise Miner (EM) & Model Manager (MM), TM, Customer Intelligence (CI) in Single and Multi - Machine and Visual Analytics (VA 6.1 to 7.3) Distributed and Non-Distributed Architecture on Windows, UNIX and LINUX environments.
• Possessed sound knowledge on migration of data to grid environment using Copying, Promoting, Importing, Exporting, and Analyzing of Metadata.
• Experienced in administering the SAS platform in single, multi-servers and in a multi-node grid environment.
• 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 SAS Management Console and SAS LSF
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Familiar with FDA regulations, GMP, ICH, GCP and GLP, Knowledge of CDISC models like SDTM mapping and ADAM experience and managed SAS CDI. Hands on DAP
• Have Fine grip on PAM and LDAP servers.
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradata database environment.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment with excellent troubleshooting skills. Have Health Care Domain Knowledge.
• Experienced in Clinical Trials Data (phase I to IV) like Demographic data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Physical and Vital Signs etc.
• Knowledge of CRT Dataset Creation from clinical trial data, CDISC and MedDRA for regulatory submissions.
• Experience in utilizing SASProcedures, Macros, and other SASapplication for data updates, data cleansing, reporting and knowledge in Claims Data Analysis.
• Expert level skills in SAS/BASE and advanced SAS, Experience in SAS/STAT procedures such as REG, GLM, ANOVA, MIXED, FREQ, MEANS, UNIVARIATE, LIFETEST etc.
• 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.
• SAS EG 6.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.
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong experience and knowledge in using clinical trial data like Demographic data, adverse event data, serious adverse event data, laboratory data and vital signs.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Data Analyst / Solutions Design Engineer

Responsibilities:

• Setting up SAS 9.4 (SAS Visual Analytics 7.3) Server in Windows environments.
• Taking care of regular maintenance of SAS Admin related activities and supporting to the team of 16 developers and 5 power users and 200+ business users.
• Troubleshooting the server and application issues and fixing it.
• Version upgrade from SAS Visual Analytics 6.4 to 7.3.
• Meetings with business users to understand the business requirements, disparate data sources (SQL Server and raw data files)
• Participation in business review meetings to gather requirements to design\generate reports and graphs.
• Creation of Hourly, Daily Weekly, Monthly, Bi-Monthly, Quarterly and Yearly reports to find out the issues generated by system from Logs, Alerts, Mails etc.
• Implemented Row-Level Permissions\Security for 200+ Users.
• Build and publish dashboards to analyze different service and products lines of the client.
• Working closely with the project development team and End-User community in coordinating with the bug fixes.
• Responsible for resolving all technical issues related to the SAS upgrade Migration.
• Responsible to perform migrating of metadata from SAS 9.2 to a SAS 9.4 GRID environment.
• Involved in promoting SAS/Access Interfaces to Oracle and SQL Servers
• Responsible for all the SAS End-User community on daily basis and serve their day- to-day functional and technical needs on SAS Enterprise Server platform
• Meet with the Business/Technical/SAS Developers- Users and Business Analysts and understand their data sources and establish/build connectivity layers using SAS Management Console and grant appropriate permissions at group level for Users to be able to connect both external and internal connections to SAS.
• Responsible for all the End-User community on daily basis and serve their day-to-day functional and technical needs on SAS Enterprise Server platform
• 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.
• Coordinating with the security team very often and providing servers for the MS patches and rebooting for the, scheduled time. worked on SPDS implementation/ support sidd lambda
• Experience in documenting data mapping from source to target.
• Worked during weekend maintenance activities orTeradatapatch update
• Responsible for monitoring CPU usage, Disk usage, and system resources.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• 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.
• Closely worked with SAS Experts at the time of SAS Installation and configuration performed on the SAS Grid Servers. Worked on Data Warehousing for developing dash boards for BA

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

SAS 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.
• Used SAS DI studio for data transformation and has ability to schedule and deploy code from SAS DI.
• Experience in developing service level agreements (SLAS) between the users to address the level of support.
• Improve performance metrics and availability of MOM tool by continuously checking splunk for any errors and resolving and logging and performance issue.
• Worked as Incident and Problem coordinator for short time in service team for incidents, requests and problem tickets raised by business partners and end users related to the marketing work bench, digital asset library, changes in the UI Frame work, process designer and schema designer in marketing operations management system.
• Hands on experience in using HPSM for working on incidents and opening problem records and known errors. Performed root cause analysis to provide solutions to the problems.
• Performed full functional checkout, business checkout and regression testing after releases, implementations and installations.
• Generated weekly and monthly status reports to the project and business team for existing problem records in HPSM and maintained documentation for all processes implemented.
• Extensively used SAS SQL to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables.
• 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.
• Understanding of working of web applications (web report studio, information delivery portal, SAS BI dashboard) on the middle tier.
• Experience in working with client server (Windows and Linux) environments to perform activities after implementations like start, stop and checking status for metadata, object spawner, analytics platform, grid monitor service and process manager for SAS applications like SAS MA, MO &MOM.
• Experience in working with developers encountering issues while coding and testing existing programs using BASE SAS, SAS/MACRO, SAS/SQL SAS ENTERPRISE GUIDE.
• Assisted in configuring web report studio and defining and creating SAS information maps for authorized users.
• Have a working knowledge of relational databases that are being utilized

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

Clinical Statistical Programmer

Responsibilities:

• Created and maintained SAS Datasets extracted from Database.
• Worked with different clinical trials data, Demographic, Adverse Event (AE), Serious Adverse Event (SAE), Laboratory, and Physical examination.
• Produced analysis datasets for generating Reports.
• Created Tables, Listings, Graphs and customized reports using various procedures PROC Report, PROC Tabulate, Data null and PROCGPLOT.
• Involved in creation of CRT datasets transport files and associating documentation as a part of FDA submissions
• Involved in writing the SAS code to help in the process of Quality control by implementing various statistical procedures PROCFREQ, PROCMEANS, PROCUNIVARIATE and PROCSUMMARY, PROC Transpose, PROC SQL and PROCPRINT.
• Wrote SQL Queries to debug duplicate values and missing values.
• Used the SAS Macro facility to modify existing departmental macros and to replace repetitive codes.
• Extensively used SET, UPDATEstatements and PROC SQL for adding new variables or observations, creating subsets or modifying datasets.
• Produced quality customized and ad hoc reports by using PROC TABULATE, REPORT and SUMMARY and also provided descriptive statistics using PROC MEANS, FREQ.
• Produced RTF, PDF and HTML formatted files using SAS/ODS.
• Documented data sets using specifications worked out in conjunction with senior manager.
• As a clinical data associate performed UAT on EDC Software and reported the edit checks.
• Performed Quality Control, Data Validation and Edit Checks using various Procedures and Macro facility.
• Wrote SAS Programs for the edit checks that were detected manually.
• Participated in team meetings to discuss best programming practices. Established and maintained sound working relationship and effective communications within Biostatistics, Statistical Reporting, and the Data Management group.

Environment: SAS v9.1, SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/ACCESS.