3 final destinations

1.
Design, implement, and communicate between cancer center databases for the clinical research program. Train physicians, nurses and other clinical staff on new and existing modules of the databases and supervise data quality from the various departments contributing to the databases. Monitor overall quality and security. Independently solve complex problems related to data flow. Development and implementation of additional data modules are required as the systems grow. Continuous monitoring and evaluation of ongoing data elements for utility and quality through analysis and interpretation of analyses.


Minimum of two years experience strongly preferred in the following: senior programmer analyst or equivalent, or have demonstrated skills in program management and training personnel in the use of relational databases, and prior experience in the design and development of databases. Less experience may be acceptable if the ability to perform at the desired level has otherwise been demonstrated.

Good knowledge of effective project management techniques and system development methods. Excellent skills in MS Access, SQL Server, and Oracle. Effective verbal and written communication skills are essential as this position interacts with department heads and database managers. Ability to be creative, logical, and handle conceptual as well as detailed tasks. The analyst will be responsible for the final design details and implementation of new features/applications as well as ongoing maintenance of the database.

BS and training in data management including programming, systems development, and project management is preferred. Demonstrated experience in the management and development of large data systems (micro array data) used in the commercial sphere for data mining, use and development of relational databases, and management of projects that involved the development of relational databases may substitute for a BS with a minimum of four years' experience but may also substitute at the rate of one year of college for two years' experience.

Describe your experience with training database users.

I have had training session with database users who often have few previous knowledge on computer software. I prepared my own slides and handouts. Also
often some training exercises also helped users to better master the database software. I enjoy the interaction with users and getting their feedbacks. I have also learned to be patient and develop software that satisfies their need.

Describe your experience with IT project management.

As a senior developer, sometimes I have the responsibility of breaking down projects into different phases and schedule task to other developers.

On several projects I also act as the point of contact for users. For example often I give demo to users and get their feedback. I interact with developers to explain to them changes needed to the software.


Logical and Physical Data modeling of Oracle database for Clinical data subjects management (ERWIN)

Development of Oracle PL/SQL packages to automate genetic data processing (Oracle PL/SQL)

Creation of Informatica ETL process for loading clinical trial subjects data (Informatica PowerCenter 7.0)

Coded various scripts for customized data quality verification and file processing (Talend data integrator, PERL)

Designed web application for program management (ASP.net 2.0)


Developed DTS and SSIS package transferring time entries data from database to file and ASP.net web reporting tool (DTS, SSIS, ASP.net, T-SQL)

Development of data warehouse ETL process for Law firm time billing BI reporting for various multinational law firms such as Linklaters LLC and Orrick LLC (Informatica, Korn Shell Scripts, Oracle)

Configuration and support of the database replication environment of time management web application for various multinational law firms (SQL Server)

Data modeled and designed MS Access and SQL server databases for the HR department of various clients (SQL Server, T-SQL)

Development and support of web portal for mobile user registration and web services allowing upload of time data entries following object-oriented paradigm(C#, ASP.net)

Developed customized reports in MS Access and SQL Server Reporting Service



Development of DTS package, Oracle and SQL Server script for software deployment and data migration (DTS, T-SQL, Oracle PL/SQL)

Designed and programmed phonebook web application by following a strict coding standard (ASP.net, C#, HTML, JavaScript)

Designed OLAP reports using crystal report 10, SQL report service, mdx query language

Customization, configuration and deployment of OrgChart web application for multinationals such as InBev, Airbus, etc

Developed web user controls to manage user web search (ASP.net)