● Developed and designed Snowflake databases for non-clinical/clinical pharmacokinetics and pharmacodynamics data, implementing efficient ETL workflows, resulting in significant improvement in data accessibility and enabling real-time analytics for the department.● Implemented a user-friendly GUI using Streamlit integrated into Snowflake using Python, SQL, and Bitbucket, enabling seamless data manipulation, retrieval, and interactive visualizations, which increased data visualization/modeling efficiency by 25%.● Automated data cleaning and reformatting processes with Python scripts, reducing manual data preparation time by 40%.● Documented ETL processes and created user guides, improving data pipeline transparency and enabling seamless onboarding for new team members in order to reduce onboarding/training time.● Applied machine learning algorithms such as linear regression, polynomial regression, and K means clustering to generate dynamic visualizations in Streamlit, enhancing data-driven decision-making and user interaction.● Delivered new Snowflake database initiatives aimed at improving data accessibility and integrity to 200+ stakeholders across various departments, leading to a 60% data retrieval time and improved reporting capabilities

● Accomplished the migration of the company’s critical data from a SQL server to Snowflake as the new database management system by creating/executing SQL scripts to optimize data accessibility/scalability and enhance data security.● Performed 10+ quality assurance (QA) testing, reviewed/documented defects, and facilitated an effective resolution to ensure adherence to company guidelines and deliver high quality, error-free results to clients.● Implemented 100+ Cloud Data & Governance Catalog scans in Informatica that ensured compliance with data governance standards, resulting in a resilient data ecosystem and providing business users with data quality insights.● Developed data visualization dashboards and statistical reports in Snowflake, providing the team with actionable insights to drive strategic initiatives.● Collaborated with 3 team members to create reference data sets and define mapping tasks, roles, and workflows within Informatica Reference360 to streamline data access and management, and received an award from my supervisor in recognition of my impact towards the team’s success.● Utilized Python scripting to automate database migration processes, which optimized data accessibility and analysis capabilities

● Supervised 100+ participants within the research lab and facilitated their participation in behavioral studies created by professors.● Analyzed the quality of questions regarding the behavior of the students to improve the accuracy and reliability of research results,ultimately contributing to the integrity of the study.● Organized 100+ surveys from participants in the SONA research database for accurate data and streamlining the research process.