SUMMARY:

• 10 + years of SAS & 7 years of experience in clinical research industry .
• Having experience in most of clinical SAS aspects like creating Datasets (ADaM, SDTM’s), TLF’s, creating and validating specifications, creating define XML, edit check programming, testing and validating CDMS.
• Having good domain knowledge on datasets like adverse event, exposure, lab, vitals, medical history, physical examination etc.
• Having experience in handling huge data by involving in ISS and ISE studies.
• Creating study specific macro’s for creation of datasets and TLF’s.
• Working knowledge of HL7 & CDISC/CDASH standards.
• Experience with CTMS clinical system.
• Experience in advanced programming in SAS including SAS/Macros.
• Mentoring and guiding the novice programmers and make them project ready.
• Good Knowledge in SAS Base procedures for detail and summary report like Report, Freq., Means etc. and hands on experience in data processing/manipulation techniques like Format, Transpose, Arrays, Macros.
• Knowledge of using ODS to generate dynamic reports in formats like PDF, RTF
• Expertise as a Senior Data Manager within a Data Management organization
• Knowledge in clinical research Process - Phases I to IV and flow of data from investigator site to data analysis.

TECHNICAL SKILLS:

SAS Skills: BASE SAS (SAS/BASE), SAS MACRO language (SAS/MACROS), SAS /SQL, SAS/STAT, SAS/GRAPH, SAS/EG, SAS/BI, SAS/ETL, SAS/OLAP, SAS/ACCESS, SAS/ODS, SAS/EG, SAS/BI, SAS/ETL, SAS/OLAP, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/Connect, SAS/Share, SAS/EIS, SAS/Stat, SAS/QC, SAS/STAT, SAS/AF, SAS/PC PROCs like OLS, LOGISTIC, NLIN, GLM, ETS toolkit, UNIVARIATE, FREQ, PROBIT, SURVEYSELECT.

SAS family of tools: Business Intelligence, Enterprise guide, Data Integration Studio, OLAP Studio, Information Map studio, Web Report Studio, Enterprise Miner, Data Flux), Data Flux dfPower Studio, SAS Appdev Studio and MS-Visio.

Languages: -SAS, Java, J2EE, C, PERL, CGI, RMI, SQL, PL/SQL, DHTML, XML, ASP, JSP, UML, JNDI, JSP, IDCAMS,CA-7,VMS, COBOL, CICS, VSAM, JCL,CA-7, IDCAMS and Pro*C. .NET, ASP.NET, VBA.NET, C#.

Software: -SAS BI and DI Tools ( Metadata Server, BI and DI Studio and Server, Stored Process Server, Data Flux Server, Management Console, OLAP Server, UML, SAS ETL, Web Tools, LSF Scheduler), Informatica, SPSS, Oracle Developer 2000, Crystal Reports, JMP and Visual Basic.

Modeling Techniques: Forecasting, Univariate and Multivariate Regression, Logistic Regression, Correlation Techniques, ARIMA/Box Jenkins Techniques, Decision Trees, Clustering, Discriminant Function Analysis, Factor/Principle Component Analysis, Scoring data and model utilization

RDBMS: Oracle 11i/9i/8i/8.x/7.x, Teradata, Informix, Sybase, SQL Server, IMS and IBM DB2, Hadoop and Netezza.

Platforms: Unix (Solaris/HP-UX), WindowsNT 4.0/95/98/2000/ XP, IBM Mainframe, Red Hat Linux, Netscape Enterprise Server, Java Web server, Apache Server, IBMWebSphere5.0, BEA Weblogic8.1, Tomcat, Sun ONE, Oracle 9iAS, WLPI, IBM MQ-Series, AIX, RHEL, ITIL

PROFESSIONAL EXPERIENCE:

Confidential

Senior SAS programmer

• Mentoring and guiding the junior programmers. Creating their trainings and make them project ready.

• Involving in the recruitment process by conducting interviews on behalf of organization.
• Validating metadata/specification’s to check whether aligning with the guidelines or not.
• Creating ADaM, SDTM datasets from source data as per client specifications.
• Creating and validating the Tables and Listings, as per the SAP/ISAP and to cross check with the shells in order to maintain consistency.
• As a dedicated resource should be able to handle a complete project/study and responsible for its quality and should be able to meet the timelines agreed.
• Documenting the project related tracker sheet, issues and communicate with the client.

Confidential, Pleasanton, CA

SAS Consultant/ SAS 9.3/9.4 /Platform Administrator

Responsibilities:

• Assess, plan, install and configure SAS solutions including the SAS Financial Crime Suite, SAS Strategy Management, SAS Visual Analytics, SAS Enterprise BI Server, SAS Enterprise Data Integration Server.

• Design and implement robust security framework to support a large and complex user base
• Installs new software, and applies software patches, updates, and new releases.
• Introducing new and emerging technologies for increased performance, improved reliability, and reduced costs.
• Introduced and integrated new technologies into the environment.
• Experience in SAS Migration and up gradation to the Grid environment.
• Worked with the user community (1500 SAS Users) to troubleshoot and resolve technical problems.
• Coordination with internal and external teams to stay abreast of technical and business requirements and ensure that systems meet those requirements.
• Employed 'best practices' to reduce risk and improve efficiency

Confidential, New York

SAS clinical Senior Programmer

Responsibilities:

• Extract data from raw SAS datasets and convert them into project standards.

• Analytical support by structuring problems into solutions while getting the clinical data
• Expertise in CDISC SDTM and Designing reports.
• Hands-on experience in developing and presenting trail protocols and designing data collection forms. Well versed in liaising with healthcare professionals and setting up clinical trials.
• Profound knowhow of handling filing and collating duties to manage appropriate documentation.

Confidential, San Jose, CA

SAS Clinical Data Manager

Responsibilities:

• Creating and validation datasets from raw data as per SDTM and ADaM IG.

• Creating tables, listings as per the SAP/ISAP by using ODS techniques and using various procedure like Transpose, Means, Freq., sql etc., and various data manipulation techniques like arrays, macros etc,.
• Communicating with the client regarding the study updates and involving in the study meeting.
• Should be able to work in team and contributing for maintain quality and timelines.
• Addressing validation comments and documenting programming activities.

Confidential, San Jose, CA

SAS Clinical Senior Programmer

Responsibilities:

• Creation of new datasets in a Linear and parallel method from raw data as per CDISC - SDTM, ADaM Standards.

• Creation of new datasets from raw data files using Import Techniques and modified existing data.
• Program routine data displays, such as data listings, in accordance with approved statistical analysis plan and shell displays for clinical research studies
• Supported UK / US statistical programming team by developing SAS programs for analysis data sets, listings, and safety summary tables.
• Knowledge on Data Management Process.
• Experience in edit check listing programming
• Creating test data for SAS listings and loading into database and running listings against the test data for validating the quality and consistency of the sas programs.
• Done unit testing for various CDMS (RAVE, OC)

Confidential, San Jose, CA

Data Manager

Responsibilities:

• Designed data warehouses, detailed data stores (DDS), and reporting data marts

• Utilized slowly changing dimensions to track changes over time
• Developed star schemas for effective reporting on high volumes of data
• Developed a method to centrally manage Change, Data, Capture (CDC) processing
• Designed and developed Extract, Transform, Load (ETL) processes using Base SAS
• DI Studio, and DataFlux Data Management Studio to populate Data Warehouses and Reporting Data Marts
• Doing Code documentation, .log and .lst diagnosis, and internal/external validity checks.
• Installation of SAS9 thin-clients for business unit users based on role based groups.
• Created server contexts for the SAS 9.1.3 to SAS 9.2 Migration.
• Imported and exported libraries from SAS 9.1.3 to SAS 9.2 using BI Manager.
• Handled user support during the SAS 9.1.3 Migration

Confidential, San Jose, CA

Team Lead

Responsibilities:

• Created new connections for different data sources including the SQL server and the Oracle database.

• Supported applications in an on call rotation basis and Managed Reports.
• Involved in cleaning up metadata users for two business units based on the user requirements.
• Supporting SAS data sourcing and reporting deliveries.
• Troubleshooting in the transmission of SAS on Solaris Platform to the Grid.
• Have worked with SAS Server Backup, Restore techniques and worked with daily maintenance issues
• Monitoring Server Usage and fine tuning of SAS applications.
• Provided SAS technical support to onsite team of 5 team members and offshore team of 20 by defining work streams, assigning them to team members and coordinating execution and delivery
• Licensing, Library Maintenance and Understanding the impact of net new processes / data points