As a professional with expertise in both the pharmaceutical industry and information technology, I have worked on a range of projects that demonstrate my ability to bridge the gap between these two fields. In today’s fast-paced healthcare environment, where technology plays a vital role, it is crucial to have the skills to develop innovative solutions that can make a real difference. In this portfolio, I present a selection of my most notable projects that showcase how I have contributed to the intersection of pharmaceuticals and technology, delivering solutions that support critical functions in the healthcare landscape.
Assessed the manual reporting process and identified the necessary documentation requirements to ensure data integrity when transferring information into external systems. By implementing custom fields and reports in Waters Empower software and following best practices, I was able to develop and validate a more efficient and accurate process. This approach significantly reduced the time required for reporting and made it less prone to errors. Additionally, the new process is easily traceable and user-friendly, leading to improved operational efficiency.
As Technical Project Leader for a major pharmaceutical company, I was tasked with assessing uncontrolled MS Access database’s and developing a compliant and secure solution. The project involved multiple databases with repetitive tasks and lacked connectivity. After assessing the common features, I combined them according to relational database guidelines, designed and performed user acceptance testing, and performed a risk assessment and qualification for use in the lab.
To improve compliance in the quality control laboratory, I used the Split Database Architecture, which involved dividing the database into a front-end and a back-end. The front-end contained forms, queries, and reports, while the back-end contained tables. I distributed the front-end to each user, while the back-end was stored on a network share. This prevented users from modifying tables directly and reduced the risk of data corruption.
To prevent data breaches and unauthorized access, I created unique user accounts with passwords and configured user groups based on the level of access needed. This simplified management of access rights and administration. I also encrypted the database to prevent unauthorized access and automated the backup process to prevent data loss.
Finally, I developed usage and administration procedures to ensure that the new database was used in compliance with regulatory requirements.
During my work in the Quality Control lab, I evaluated approximately 150 spreadsheets, identified redundant calculations, and consolidated similar spreadsheets. Following the evaluation, 30 spreadsheets required further development and validation. To improve the process, I standardized the calculations, formatted input cells and formula cells separately for easier identification, and implemented locks for security. To ensure version control and prevent unauthorized access or editing, I also established storage security requirements.
In addition to these measures, I created a usage and management procedure, a user acceptance document, and a validation procedure aligned with the Good Manufacturing Practice (GMP), Good Clinical Practice (GCP), and/or Good Laboratory Practice (GLP) guidelines. By implementing these actions, the quality control lab’s spreadsheet accuracy and reliability were enhanced, enabling compliance with internal standards and regulatory requirements.
As Technical Project Leader for a major pharmaceutical company, I was tasked with assessing uncontrolled MS Access database’s and developing a compliant and secure solution. The project involved multiple databases with repetitive tasks and lacked connectivity. After assessing the common features, I combined them according to relational database guidelines, designed and performed user acceptance testing, and performed a risk assessment and qualification for use in the lab.
To improve compliance in the quality control laboratory, I used the Split Database Architecture, which involved dividing the database into a front-end and a back-end. The front-end contained forms, queries, and reports, while the back-end contained tables. I distributed the front-end to each user, while the back-end was stored on a network share. This prevented users from modifying tables directly and reduced the risk of data corruption.
To prevent data breaches and unauthorized access, I created unique user accounts with passwords and configured user groups based on the level of access needed. This simplified management of access rights and administration. I also encrypted the database to prevent unauthorized access and automated the backup process to prevent data loss.
Finally, I developed usage and administration procedures to ensure that the new database was used in compliance with regulatory requirements.
During my work in the Quality Control lab, I evaluated approximately 150 spreadsheets, identified redundant calculations, and consolidated similar spreadsheets. Following the evaluation, 30 spreadsheets required further development and validation. To improve the process, I standardized the calculations, formatted input cells and formula cells separately for easier identification, and implemented locks for security. To ensure version control and prevent unauthorized access or editing, I also established storage security requirements.
In addition to these measures, I created a usage and management procedure, a user acceptance document, and a validation procedure aligned with the Good Manufacturing Practice (GMP), Good Clinical Practice (GCP), and/or Good Laboratory Practice (GLP) guidelines. By implementing these actions, the quality control lab’s spreadsheet accuracy and reliability were enhanced, enabling compliance with internal standards and regulatory requirements.
As Technical Project Leader for a major pharmaceutical company, I was tasked with assessing uncontrolled MS Access database’s and developing a compliant and secure solution. The project involved multiple databases with repetitive tasks and lacked connectivity. After assessing the common features, I combined them according to relational database guidelines, designed and performed user acceptance testing, and performed a risk assessment and qualification for use in the lab.
To improve compliance in the quality control laboratory, I used the Split Database Architecture, which involved dividing the database into a front-end and a back-end. The front-end contained forms, queries, and reports, while the back-end contained tables. I distributed the front-end to each user, while the back-end was stored on a network share. This prevented users from modifying tables directly and reduced the risk of data corruption.
To prevent data breaches and unauthorized access, I created unique user accounts with passwords and configured user groups based on the level of access needed. This simplified management of access rights and administration. I also encrypted the database to prevent unauthorized access and automated the backup process to prevent data loss.
Finally, I developed usage and administration procedures to ensure that the new database was used in compliance with regulatory requirements.
Let's Work Together
With the ongoing technological revolution changing our lives, society, and learning methods, my versatile technical expertise in pharmaceutical sciences, software design, and web development can help you accomplish complex projects efficiently.
.
.
© www.webrajiv.ca