Software Consultant at Pharma IT
Role: Software Consultant specialized in digital transformation and AI-driven data management solutions within the Pharma Industry.
Focus Areas: Development of pharma-compliant web applications🌐, cloud DevOps☁️, and AI-driven data management🤖.
Key Responsibilities:
- Development of Pharma-Compliant Web Applications💊
- Designed and developed IDMP Gap Analysis Tool, a progressive web application for the pharmaceutical industry, built with Vue.js and leveraging Vite.js for an enhanced user experience.
- Integrated backend AI-driven systems into the application, utilizing Large Language Models (LLMs) for advanced data processing, analysis, and decision-making support, ensuring seamless data flow and regulatory compliance.
- Cloud DevOps🚀
- Developed, deployed, and maintained scalable cloud infrastructure across AWS and Azure, optimizing resource utilization and minimizing operational costs while adhering to pharmaceutical industry standards.
- Implemented CI/CD pipelines and automated workflows, significantly improving the efficiency and reliability of the application lifecycle.
- Data Workflow Management with AI Integration🔄
- Architected a multi-stage data extraction and processing pipeline that includes AWS Lambda functions, DynamoDB🗄️ for data storage, S3☁️ for file handling, and AWS Bedrock to interact with Claude 3.5 Sonnet🧠 for intelligent data parsing.
- Automated study creation, data extraction, and data matching workflows within the app:
- Create Study Feature: Enables study initiation via file uploads or public health authority searches, triggering a sequence of Lambda functions to handle file uploads and process study metadata.
- Data Extraction and Validation: Preprocessed files are parsed for required data fields, converted to JSON, and stored in DynamoDB. The app monitors data readiness through timed checks to ensure availability for further actions.
- Data Matching Feature: Extracted data fields are compared against EMA SPOR regulatory data, with discrepancies flagged to guide users on data validation.
- Research and Development🔬
- Conducted research on applying machine learning techniques to medical data extraction, aiming to improve the accuracy and utility of pharmaceutical tools.
- Employed data science methodologies for large dataset management, data parsing, statistical analysis, and the visual presentation of insights.
- Collaborative Development and Innovation🤝
- Worked closely with cross-functional teams to ensure solutions meet regulatory and operational standards, collaborating in the design and validation of user-facing tools.
- Led co-design activities and iterative prototyping to refine features based on stakeholder feedback, creating incremental, validated solutions for the IDMP Gap Analysis Tool.
Impact:
- Strengthened regulatory compliance by integrating AI-driven systems for precise and efficient data handling.
- Reduced operational costs through optimized cloud infrastructure and automated workflows.
- Enhanced decision-making processes by streamlining data validation and improving data integrity across workflows.
Technologies Used:
- Programming Languages: JavaScript, Python, C++
- Frontend: Vue.js, Vite.js
- Backend and Cloud: AWS Lambda, DynamoDB, Amazon S3, AWS Bedrock, Azure DevOps.
- Database Systems: AWS DynamoDB, PostgreSQL (Amazon RDS).
- AI and Data Processing: Large Language Models (LLMs) and data integration.