Experience Data Project .Net Analyst Oracle Development

Vandana Kapoor

***** ** ******** ****

Tel No.: 971-***-****

Beaverton, OR-97006

Email: abhi4i@r.postjobfree.com

Objective: To apply the knowledge acquired during internship and research

work in challenging real world scenarios in the field of application

development and data analysis.

SUMMARY

2 years of experience in C# .Net and database development (MS SQL, Oracle,

T-SQL, XML)

Well experienced in GUI development, Microsoft Visual Studio, Object

oriented programming approach (OOP/OOD), Relational Database Management

Systems

Knowledge of business intelligence products, including SSIS, SSAS and SSRS

Well Experienced with scripting languages like Python and Perl.

1+ year of experience with large scale heterogeneous data source

integration problems and solutions

Knowledge of software development life-cycle and developing automated

monitoring and unit testing of software

Experience with data validation and application testing along with source

code review.

Experience in writing brief design specifications

Experience working with various data clustering algorithms for large

dataset.

Worked with huge personally identifiable datasets in the past at

Department of Health Services, Oregon.

Team player, self-motivated, possess excellent communication and problem

solving skills.

Written multiple technical papers and conference papers.

EDUCATION

Masters of Science Biomedical Informatics, School of Medicine, OHSU.

Portland, OR. December 2010

BDS, BJSD School and Research Institute, Ludhiana, Punjab, INDIA. June

2006.

TECHNICAL SKILLS

Languages C# .Net, Python, Perl, Java, XML

Database SQL server (2005, 2008), Oracle, MySQL, MS Access

Operating Systems Windows Vista, Windows 2003, Windows XP, Windows 7

Tools Eclipse, Microsoft Visual studio, Crystal Reports,

XMLSpy, Microsoft office tools, MS Business

intelligence tools

`

PROFESSIONAL WORK EXPERIENCE

1 Project Validation of third party data de-duplication

algorithm (Department of Health Services (DHS),

Oregon) May 2010 - November 2010

Environment C#.NET, Python, MSSQL, Crystal Reports

Responsibilities Created an algorithm for large scale validation of

(Program the third party algorithm.

Analyst-I) Implemented this validation algorithm using Python

Created unit test cases using MSSQL for validating

the de-duped data in the new immunization

information system.

Created and present a report showing the bugs in

the third party algorithms with recommendations for

improvement.

2 Project Design and develop tools and scripts for enabling

clinical trial data integration from multiple

heterogeneous data sources, ( Department of

Biomedical Informatics, OHSU) Oct 2009 - December

2010

Environment C# .NET, Perl, ASP.Net, MSSQL, Visual Studio,

XMLSpy

Responsibilities Designed and developed GUI frontend application in

(Program Analyst) .Net to be used by clinical data analysts.

Developed the application by utilizing ASP.NET.

Responsible for the creation of the user defined

applications, database classes, procedures and user

controls.

Responsible for the testing, fixing the bugs and

troubleshooting the technical problems.

Implemented scripts using Perl for bulk converting

intermediate data tables from one dataset to

internal XML format (gTree) for assisting in data

integration.

Integrated various studies using this newly created

tool and conducted user acceptance testing

sessions.

Modified GUI application according to the users

(clinical analysts) requirements.

ACADEMIC WORK EXPERIENCE

1 Project Use of Normalization and database modeling to

design and implemented a database system -"Tracking

of Dental material orders in a dental facility". (

Department of Biomedical Informatics,, OHSU) Jan

2009 - June 2009

Environment Oracle SQL, ERD,UML

Responsibilities Designed various Use cases of the database.

(Program Analyst) Built data model using ERD and UML data structures.

Normalized the data structure to BCNF (Boyce-Codd

normal form).

Created DDL/DMLs for all the tables.

Analyzed and mined the data in oracle to determine

the efficiency of data structure.

2 Project Feature Selection based on Clustering - Acute

Leukemia Classification- on Golub Leukemia

Datasets. ( Department of Biomedical Informatics,

OHSU) Jan 2010 - Mar 2010

Environment Perl, R, Bio-conductor

Responsibilities Classified leukemia dataset using bio-conductor

(Program Analyst) open source software.

Classification of samples between two types was

performed using k-nearest neighbor (KNN) algorithm

and implemented in Perl.

Use ANOVA Statistical Method to remove cases with

small spread.

Analyze and summarize the results.

3 Project Image Suitability Analysis: Hierarchical Clustering

and Statistical analysis for variability in region

of interest delineation for rectal cancer images,

( Department of Biomedical Informatics, OHSU) Oct

2009 - June 2010

Environment Python,R,Stata,c3d,ITK-SNAP

Responsibilities Analyzed sample sets of cancer images using

c3d/ITK-SNAP

Conduct various statistical tests to measure the

variability of performance.

Cluster analysis of various groups of

radiotherapists depending on the level of the

experience(Experts versus Non experts)

Built an application using Python to calculate

overlapping measures between the images and

evaluative matrices to score radiotherapists

performance by multiple comparisons.

PUBLICATIONS

1. Providing Domain Analysts with Natural Schemas to Enable Clinical

Research, 2011 AMIA Summit on Clinical Research Informatics

2. Representing Multi-Database Study Schemas for Reusability, 2010 AMIA

Summit on Clinical Research Informatics March 12-13, 2010

3. Term Paper: "Health Care in Digital Era". June 2009

4. Term Paper: "Which is better? Usernames/Passwords OR Biometric

Authentication". June 2009.

5. Term Paper: "Data loss prevention (DLP) measures of electronic

information in health records". December 2008.

*References available on request.

Contact this candidate