•Retrieve medical data from Epic Clarity and Epic Caboodle databases using complex and highly-optimized SQL queries, fulfilling requests from principal investigators and providing data to researchers, clinicians, and study coordinators while maintaining HIPAA compliance•Utilize Amazon Web Services (AWS) tools such as Athena, RedShift, RDS, and QuickSight to query and visualize healthcare-related data, including survey results, wearable device information, and other clinical outcomes•Handle various database administrative tasks, such as creating tables and views, maintaining data dictionaries, setting up user accounts, overseeing permissions, and assisting with some ETL processes•Engage in auditing medical imaging processes and developed standard operating procedures (SOPs) to ensure compliance and quality standards•Plan and organize sprint retrospectives and participate in Agile scrum and sprint meetings with the product owner and other team members while using tools such as Slack, Jira, and Confluence•Periodically use Python for data cleansing and analysis, leveraging tools such as Jupyter Notebook and Anaconda to generate descriptive statistics and prepare datasets for further analysis

•Extracted and analyzed writer and publisher data from various sources via SQL, including DB2, Oracle, Netezza, and Access databases•Utilized business intelligence visualization tools such as PowerBI and Cognos to design and develop interactive dashboards, enhancing data accessibility and understanding for stakeholders•Assisted in the creation of automated IT jobs, ETL processes, and UAT procedures while ensuring the integrity of data from both internal and external sources

•Prepared annual budgets, audits, A/B tests for subscriber gains/losses; determined potential advertising revenue from local and national businesses•Collected, analyzed, and disseminated website traffic and circulation data using Google Analytics, Adobe Omniture, and the company’s Facebook page•Planned and organized market research studies and distributed online surveys to panels to determine effectiveness using Research and Analysis of Media (RAM)

•Contributed to the development of marketing and pricing strategies for a new metal recycling machine based on research findings

•Conducted data analysis from government sources to offer insights on economic trends

•Assisted professor in grading assignments and maintained student grade files