Experience Summary

• Over 7 years of experience in healthcare, and 3 years of experience in pharmaceutical, technology and financial industries.
• Over 10 years of extensive experience in Data Modeling, Data integration, Data Management and ETL, Dimensional and UML Modeling.
• Over 5 years of experience in software development – Erwin, Visio, ERStudio, Data Architect, Toad, Oracle, DB/2, Postgress, SQL Server, Ingress, SQL, PL/SQL, JAVA, JSP,JSTL,J2EE, Struts, Spring framework, Apache Tomcat, Eclipse, MyEclipse, Unix, Windows, PERL, Microsoft Access.

Work Experience

Confidential Durham, NC, USA (Dec 2004 to Present)

DEDUCE: Represented Department of Anesthesiology in the requirements analysis discussions for the Duke Enterprise Data Warehouse Web Portal - DEDUCE [Duke Enterprise Data Unified Content Explorer], which uses Oracle, Java and Cognos technologies. Operational data is integrated into the Data Warehouse from Duke Hospitals and Clinics using HL7 interface. The data warehouse produces reports about various subject areas – Diagnosis, Procedures [CPT, ICD9 codes], Labs, Orders and Medications, Patient Demographics etc. Collaborated with database analysts and statisticians to analyze large datasets obtained from data warehouse – Decision Support Repository DSR, perioperative systems – SIS Surgical Information System [Oracle] and Innovian Anesthesia System [SQL Server]. The information includes the peri-operative continuum from pre-op, intra-op, post-op and PACU.

NORG:Enhanced the data model of a legacy application consisting of over 200 tables for transforming it into web application, by establishing additional relationships for improving performance and features. Exposed it as a web application, using Java Spring and Struts based framework that I developed for an earlier project, Charge Voucher.

CRF: Created conceptual, logical and physical data model from scratch for a paper based Case Report Form – CRF, [~200 pages, 3000 fields] and collaborated with operations manager and clinical coordinators for developing PeRiGren [Perioperative Genomics Research], a web application. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. Led the JAVA developers to build the web application using MVC design, spring framework, JSP/JSTL libraries, struts, Hibernate Data Access Objects in the JDBC connectivity layer, JAVA servlets, Eclipse, Tomcat and Oracle database. 

Charge Voucher: Created conceptual, logical and physical data model from scratch, based on the requirements from physicians, operation managers and business staff for a billing application – Charge Voucher accessible in the Operating Rooms of the Duke Hospitals. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. The end users of this system are physicians, residents, nursing assistants and financial analysts. Built the web application using MVC design, spring framework, JSP/JSTL libraries, struts, Hibernate Data Access Objects in the JDBC connectivity layer, JAVA servlets, Eclipse, Tomcat and Oracle database. The application allows physicians, residents, CRNAs to submit vouchers and financial analysts to access vouchers for billing.

DUNCL: Created conceptual, logical and physical data model by analyzing the Duke University Neuro Cognitive Laboratory [DUNCL] tests, a paper document and collaborating with neuro testers and medical director for developing DUNCL, a web application. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. The application allows neuro testers to score battery of tests that patients participated in. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Publications Database: Created conceptual, logical and physical data model from the requirements specification by collaborating with investigators and business staff for the PublicationDatabase. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. The application allows users to upload publication details from pubmed [NIH database] and enable the management to track publications and award bonuses to the researchers on their scientific contributions. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

CARE: SIF: Created conceptual, logical and physical data model from the requirements specification by collaborating with investigators, coordinators, operations managers and medical director for an electronic approval system, Cardiac Anesthesiology Research Endeavors– CARE: SIF. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. Theapplication allows users to submit protocols for IRB approvals, thereby sending emails to operations manager and medical directors for final approvals. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

PiReports: Created conceptual, logical and physical data model from the requirements specification by collaborating with investigators, coordinators, operations managers and medical director for an enrollment/finance reporting system - PiReports. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. The application allows users to enroll patients for clinical trials, investigators to view the enrollments and funding information, medical director, operations managers and business staff to generate reports regarding investigator’s financial and enrollment data. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Ticket Track: Created conceptual, logical and physical data model from the requirements specification by collaborating with data miners for a data ticket tracking system – Ticket Track. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. The application allows statisticians and researchers to submit data tickets and data miners for accessing the ticket requests for mining data for research. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Freezerworks: Analyzed the data model of the Freezerworks, a sample tracking and freezer inventory program which is a 3rd party tool. Mapped the fields of the source and destination tables and assisted the DBA in creation of scripts for analyzing the source data, and ETL scripts in Oracle PL/SQL for the data migration of a million studies. 

Genomic and Natural Diversity Data: Participated in discussions with Working Groups, Sabbatical and Postdoctoral fellows at National Evolutionary Synthesis Center to create Ontology Models for evolutionary biologists to use. Implemented the databases in Postgresql and Oracle environments. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Notebook Finder: Created conceptual, logical and physical data model in Data Architect from the requirements specification by collaborating with senior managers for a web application - Notebook Finder. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design in DB/2. The application allows users to retrieve configurations, prices of the products and related information available on the ibm.com website. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

URL Inventory: Created conceptual, logical and physical data model in Data Architect from the requirements specification by collaborating with senior managers for a web application - URL Inventory Project. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Clinical Planning and Management Data Migration: Created conceptual, logical and physical data model in ERwin from the migration specification by collaborating with senior managers for a Clinical Planning and Management System (CP&M). Analyzed the data models of the legacy clinical and finance systems, spreadsheets and destination Siebel e-Clinical tables. Assisted DBAs in creating scripts for ETL, error handling, logging and audit functions, PL/SQL packages, stored procedures, functions, triggers, PL/SQL collections, views, synonyms, sequences in Oracle 8i, indexes to optimize the performance of the queries, export and import utilities. It is a data migration project migrating clinical trials data from legacy systems (Visual Basic/Oracle 8.0, Power builder/Oracle 7.3) to Siebel e-clinical application (Oracle 9.2) and 1 million studies were migrated.

Global Chemical Sample Archiving System: Created conceptual, logical and physical data model in Erwin from the requirements specification by collaborating with senior managers for Global Chemical Sample Archive Technologies Submission and Request Automation system. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Ingress to Oracle Data Migration: Created conceptual, logical and physical data model in ERwin from the migration specification by collaborating with senior managers for Ingress to Oracle Data Migration project. Analyzed the data models in Ingress [source] and Oracle [destination]. Assisted DBAs in creating scripts for ETL functions in perl.

Account Management System: Created conceptual, logical and physical data models from the requirements specification by collaborating with senior managers for First Union National Bank. Mapped the logical data model in ERwin to a physical data model and assisted the DBAs in the creation of scripts for a physical design. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.
Hospital Management System: Performed Due-Diligence for the Upgrade of the Hospital Management System by collaborating with 50 users (nurses and HR personnel) and identified 200 entities, relationships and constraints to build a logical data model in Erwin using the normalization techniques. Mapped the logical data model to a physical data model and assisted the DBAs in the creation of scripts for a physical design in Oracle. It is a web application that consists of clinical, financial and administrative modules such as ADT (Patient -Admission, Discharge, Transfer), Medical Records, Clinical Pathways, Order Entry, Pharmacy, Patient Billing and HIS Common (admin functions) . Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

Designed various departmental databases such as Employee Database system and Timesheet Database in DB/2. Communicated with managers to identify entities, relationships and constraints to build a logical data model using the normalization techniques. Mapped the logical data model to a physical data model in ER Studio and assisted the DBAs in the creation of scripts for a physical design. Mapped entity relationship diagrams [ERD] to class diagrams and Data Access Objects – DAO in the JDBC connectivity layer during the development of the web application.

• June 2000: Oracle Certified Internet Developer
• June 1999: Oracle Certified Application Developer
• Dec 1999: Sun Certified JAVA Developer