Sr SAS Developer & Analyst

PROFESSIONAL SUMMARY

Experience in using SAS software for clinical trial analysis and reporting. Generated tables, listings and graphs as per protocol. Developed and maintained the infrastructure for project files of SAS datasets and SAS codes. Provided SAS programming, data management and quality control for research project. Extracted, manipulated and merge large databases to create analytical datasets.

Extensive knowledge of SAS functions to read, write, import and export to another data file formats, including delimited files and spreadsheets. Proficiency in using SAS/ODS to create output files in a variety of formats including RTF, HTML and PDF.

Extensive knowledge of statistical procedures in SAS to perform statistical analysis, including PROC GLM, PROC ANOVA, PROC MIXED, PROC TTEST, PROC GENMOD, PROC PHREG, PROC LIFEREG, etc

Experience in SAS/SQL, SAS/INFILE, and SAS/IMPORT for converting and importing various formats of external data files into SAS datasets and creating libraries.

Extensive knowledge in producing the customized tables in reports by applying PROC REP ORT, PROC TABULATE, and DATA ¬_NULL.

Experience in using ArcMap application in ESRI ArcGIS to map and edit task as well as for map-based query and analysis. Used ArcGIS to create maps using various themes to present data for presentation and for research purposes. Monitored mapping work and updated maps to ensure accuracy by including new and changed information.

Experience in using Maple software for quick calculations, developing design sheets and for producing simulation models. Knowledge in computer simulation and modeling techniques for analyzing medical and health care problems using maple software.

Experience in using Matlab software for developing algorithm, data visualization, data analysis, and numeric computation. Also used in wide range of applications this includes signal and image processing, communications, control design, test and measurement, and computational biology.

Knowledge of Controlled Medical Vocabularies.

Over 3 years of Development Experience MS SQL Server 2005/2000 in the areas of Database Architecture, Design, Coding, Implementation and Production support.

Experience in supporting Huge Databases, troubleshooting the problems and documenting root cause analysis.

In-depth knowledge of T-SQL (DDL, DML, and DCL).

Extensive experience in writing SQL queries, Stored Procedure, Views, and Triggers. Experience in writing and debugging stored procedures and triggers.

Extensive knowledge and experience in dealing with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export.

Experience in logical and physical data modeling using Erwin.

Developed and implemented ETL packages such as DTS and SSIS for production.

Involved in data migration from Sql server 2000 to 2005 and performed testing after migration.

Extensive knowledge in Backup and Recovery strategies.

Knowledge of using different testing tools for web application and for database.

Experience in supporting Huge Databases, troubleshooting the problems and documenting root cause analysis.

Over 2 years of Experience in analysis, design, development and implementation of Client/Server, 3-Tier web applications.

Strong hands on experience in VB.NET, ASP.NET, ADO.NET, Visual Basic 6.0, JavaScript, HTML, XML, ActiveX, ADO, MS-IIS, VS2005.

Queried online databasess, such as PubMed for historical and current developments in the literature. Extracted main points and communicate review of the literature back to team members.

EDUCATION

UNIVERSITY OF MEDICINE & DENTISTRY OF NEW JERSEY, Newark, NJ Degree Expected: May 2011

Candidate for a Master of Science in Biomedical Informatics [GPA 3.9/4.0]

Related Coursework: Introduction to Biomedical Informatics, Introduction to Biomedical Imaging systems, Biomedical Modeling & decision making system (Usage of Maple software), Biomedical Informatics in Clinical Trials Management, Controlled Medical Terminology, SAS Applications in Biomedical and Clinical Research, Clinical Problem Solving and Decision Making ,Visualization in Biomedical Sciences (Usage of MATLAB software), GIS (Geographic Information System)

CHIMANBHAI INSTITUTE OF COMPUTER APPLICATIONS, India Jun 2006

Masters in Computer Applications [GPA 3.8/4.0]

R.A.BHAVANS, India Jul 2003

Bachelor of Science in Chemistry [GPA 3.7/4.0]

PROFESSIONAL EXPERIENCE

University of Medicine and Dentistry of New jersey, USA June 10 – Aug 10

Position: Student Intern

Completed CITI training.

Directed patients to kiosk from waiting area from any of three medical clinics (University Hospital, Jersey City, and Irvington) and explained the project, and assisted patients in taking audio survey.

Participated in the expansion of the project which include obtaining attitudes of participates toward volunteering for a clinical trial, and evaluating the use of the HSK on increasing subject enrollment into clinical trials which involves some data analysis, writing scripts for the kiosk, designing some patient friendly materials on clinical trials, assisting in writing a grant and/or IRB proposal.

Assisted in computer programming - programming the screens on clinical trials into the kiosk.

Teleperformance Interactive, Plymouth Meeting, PA,USA Mar 08 – April 09

Position: Sql Server Developer

Analyzed, and gathered data for creating database structure.

Used ERWIN to create and maintain database.

Extensive knowledge and experience in dealing with Relational database management systems, including E/R diagrams, Normalization, Contraints, Querying, Joins, Keys, Indexes, Data import/ Export.

Migrated DTS package to SSIS package by using Business Intelligence Studio.

Created Dynamic package to migrate data from SQL Server 2000 to SQL Server 2005. Unit Testing the SSIS packages with respect to its flow and performance issues. Automated SSIS package for large size database migration.

Involved in Query Optimizations and performance tuning for the stored procedures. Involved in development and debugging of complex Transact SQL Procedures and Triggers.

Planned and Implemented table partition scheme on large database with appropriate indexes. Also Implemented and Tested Partition Switching and Automatic Sliding window partition on database.

Tested web based application and reported and solved issues related to web based application.

Solved problems related to development of stored procedures, Triggers and problems related to the privileges.

IBSD, India Apr 06 – Oct 07

Position: Software Engineer

Supported and customized the existing .Net 2.0 and Visual Basic 6.0 applications.

Involved in installing, configuration, and maintenance of web-based system.

Created and maintained documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.

Designed and developed user-friendly navigation system using ASP.NET and JavaScript.

Developed Web forms using ASP. Net.

Configured ASP.NET Web.Config file for the entire web application.

Involved in debugging legacy ASP and ASP .Net code in a complex environment.

PROJECTS Jan 06 – Apr 06

Project 1

Position: Software Engineer Intern (IBSD India Ltd.)

Developed Web forms using ASP. Net.

Designed and developed a calendar and the mailing system for the website “BIZWORLD”.

The calendar helps in creating events with and without recurrence pattern.

Mailing System keeps the track of messages between the clients.

The project was developed with Vb.NET as the front end and Sql Server 2000 as the back end.

Project 2

Position: Software Engineer Intern (Nutan Travels) Jan 05 – May 05

Designed a “Online Air Ticket Booking" website for the travel company

It helps the customers to view the avalilability of flights, booking with the travel company, etc.

The project was developed with JSP as the front end and Sql Server 2000 as the back end.

TECHNICAL KNOWLEDGE

Languages: VB .Net, ASP.Net, ASP, Visual Basic 6.0/5.0, C++, C

Software Tools: MATLAB, MAPLE, SSIS, DTS, Erwin 3.5.2, MS Visio 2003, MS Office 2003,

ArcGIS 9.0.

SAS Products: SAS/BASE, SAS/STAT, SAS/SQL, SAS/ACCESS,

SAS/ODS, SAS/GRAPH, SAS/ANALYST, and SAS Enterprise Miner.

Databases: MS SQL Server 2000/2005, Microsoft Access, SAS

Web Technologies: HTML, VB Script, JavaScript, XML, DHTML, IIS, Web services

Operating System: Win NT 4.0, Win 2000, Win 2003, Win XP

Version Management Tools: Visual Source Safe

AWARDS AND ACHEIVEMENTS

Class representative 2000-01, R.A.BHAVANS, India

Ladies representative 2001-2002, R.A.BHAVANS, India

References

1) Professor: Dinesh Mital PhD

Tel: 973-***-****

*******@*****.***

2) Professor: Shankar Srinivasan PhD

Tel: 973-***-****

********@*****.***

Contact this candidate