Marie E. Jean Gilles

Project and Data Management

• Provide project, technical, and operational support for a multi-site HIV research program and other clinical research projects as needed.
• Perform various data management related activities (database design, data collection, opening and resolving queries, reviewing datasets, and reporting)
• Participate in User Acceptance Testing (UAT), assists with the development of UAT plans, and reviews UAT findings
• Responsible for updating site query lists used for data analysis and reports

Standard Operating Procedures (SOPs) and Compliance

• Drafted approved Data Management Plans, CRF completion instructions, site-initiation visit slides, and other related study support documents

Data Management and Administration

• Managed over 30 REDCap databases containing retrospective and prospective psychiatric research data of over 31,000 study participants
• Collaborated with researchers and project managers across 5 sites to define data requirements and ensure databases meet project objectives
• Created documentation outlining best practices, guidelines, and recommendations for database architecture and optimization
• Provided regular updates and reports on the status of research databases and project milestones
• Built, managed, and developed a data team comprised of 3 paid and unpaid undergraduate personnel, provide coaching and mentorship, conduct performance evaluations, and establish inclusive work cultures

Database Architecture and Engineering

• Analyzed existing database architecture and identify areas for workflow optimization
• Developed efficient database schemas that accurately represent the structure and relationships of research data, considering entities, attributes, and relationships relevant to the projects
• Investigated and pinpointed specific performance issues in the database
• Designed and implemented queries and search features for data retrieval

Data Transformation and Quality Assurance

• Developed protocols and procedures for data entry
• Implement quality control measures to identify and rectify errors promptly
• Perform routine data cleaning tasks to handle missing values, outliers, or inconsistencies in the research data
• Clean and format data as required for analysis

Data Management

• Managed sensitive PHI of over 11,000 research study participants
• Developed and maintained data dashboards and reports to monitor and analyze data trends
• Coded data from incoming medical history questionnaires for statistical analysis purposes.
• Trained and supervised data volunteers in performing data quality tasks and accurate data entry.
• Generated weekly recruitment reports using SAS

Data Quality Assurance

• Assisted in developing data quality control metrics and reporting to evaluate data quality
• Created and maintained documentation related to data management and quality control processes
• Analyzed data to identify any inaccuracies or inconsistencies, then taking necessary steps to rectify them

Community Outreach and Involvement

• Participated in outreach efforts to recruit underrepresented community members into health research studies
• Administered health needs assessments, Alzheimer's questionnaires, and MOCAs to HealthStreet members and referring them to low-cost community resources