Sql Server Data Developer Clinical Research .Net

Adel Assad

*** ****** **** **., ** *****

Cell :615-***-****

E-Mail: adel_hydey @yahoo.com

[pic]

Career Profile:

To obtain a challenging position as SAS Programmer where I can put forth

the best of my knowledge and experiences for the growth of the

organization.

Summary:

. Possess extensive knowledge of developing, modifying and maintaining

SAS program suites

. Possess excellent communication and coding skills

. In-depth knowledge of SAS programming, data processing, data

collection, quantitative and qualitative data analysis.

. Excellent organizational and time management skills

. Possess good analytical and problem solving skills

. Excellent team player with high level of personal initiatives

. Ability to handle multiple tasks simultaneously

Technical skills:

. Extensive knowledge of Statistical Programming using SAS, SAS Macro,

Proc SQL, SAS ODS,SAS Graph.

. In-depth knowledge of VBA Excel,VBA

Access,ASP.NET,ADO.NET,VB.NET,C#,Crystal Report,Crsytal Xcelsuis.

. Proficient in operating tools like Windows XP/NT, Unix, and MVS

. Data Bases: DB2, Oracle7.1, MS Access.

Educational Qualification:

. Bachelor's degree in Computer Science, Faculty of Electronic

Engineering,Cairo, Egypt 1994

. Certificate in SAS Base Programming for SAS 9 programming July 2008.

. Training :

. 07/04/2012-07/11/2012 Voxco system training Montreal, Canada (for

clinical research data collection instrument system)

. 01/24/07-01/26/07 SAS Institute Data Management with SAS

system

. 09/2003-01/2004 New Horizon,Nashville,TN,USA

. Microsoft Developer

Software Enigineer,VB.NET platform

. 12/2001-02/2002 Solid Computer Decision

Nashville,TN,USA

. Microsoft windows 2000

Professional &Server Implementation

. Windows 2000 Network

Infrastructure.

. 05/1995-06/1995 Daltex_Unisys 1997,Cairo,Egypt

. Introduction to Oracle

ver7.1 (SQL forms and Report writer)

. Introduction to UNIX

Operating system.

. Introduction to UNIX

Administration.

Professional Experience:

Vanderbilt University, Nashville, TN

12/01/2010 to 07/01/2013

Analyst/Programmer:

. Designing projects for clinical research data collection tools using

Voxco system.

. Designing data transfer plan to transfer data between Vanderbilt and

IEI (international Epidemiology institute).

. Designing a data synchronization system between SQL Server and web

data base using SAS software and PHP.

. Designing overnight process to update data on SQL server across the

clinical projects using SAS and PHP.

. Create data delivery across projects to PI (project investigator).

. Designing a backup process and data loss prevention process to back up

and alert the staff of any data loss across all projects using SAS.

. Design email system using SAS and Microsoft outlook to automatically

notify PI team with projects data status.

. Providing technical support for SRSR Staff (Survey Research Shared

Resources).

TDOC, Nashville, TN

01/2010 to 11/30/2010

SAS Programmer: PC SAS and Mainframe

. Assigned the tasks of developing and implementing innovative SAS

strategies of the organization

. Automating the SAS program which runs in mainframes to PC SAS.

. Automating PC SAS programs For Data in multiple Excel sheets and

multiple Access tables.

TDMHDD, Nashville (IT Unit)

10/01/2009 to 12/30/ 2009

.NET Developer

. Responsible for the analyses of the requirements of the business,

designing database tables.

. Developed and maintained the applications by utilizing ASP.NET and

ADO.NET.

. Responsible for the developing the database with the team of 4

personnel and make codes for the website administration.

. Responsible for the reports with the help of crystal report and

presentations.

TDMHDD, Nashville (Research Unit)

07/01/2008 to 09/30/2009

Data Manger

. Responsible for manipulating, transferring and managing data in SAS

. Data Management and analysis of the state of Tennessee encounter

Health Data.

. Data Management and analysis of Data provided by vendors.

. Complete Ad Hoc Reports as needed to support the clinical services and

the compliance unit.

. Running GEO Access report using GEO Access software to monitor the

performance.

. Present report data to internal and external customers as needed.

. Provides technical assistance to other staff on data and statistical

analysis software

TDMHDD, Nashville

05/01/2003 to 06/30/2008

SAS programmer

. Develop SAS code and applications including Macro Language and SQL.

. Creating Microsoft Access application for clinical team that is used

to monitor the performance of the providers.

. Rater Reliability Analysis using SAS programs.

. Projects optimization and presentation using Xcelsius Software.

. Creating annual Block Grant Report for mental health using PC SAS and

transmit It to Federal agency

Egyptian Army, Cairo

1995 to 1997

Oracle Developer

. Developmental Oracle tools include: Forms, Procedures, Triggers

. Backup all Database and performing recovery operation.

. Controlling the access to the database using UNIX OS and Oracle 7.1

security features.

. Environment that run Oracle 7.1 on UNISYS minicomputers with UNIX O.S.

Areas of Interest:

. To develop more advanced SAS Programming

. To generate and implement SAS programming for various projects.

. To Work with Database and SQL Server.

References:

. Dr. Mary Karpos

. Professor at Vanderbilt University,Nashville,TN

. T: (615):741-1000 ext:8153

. E_mail:****.******@**.***

Contact this candidate