As an Engineering Lead, I bring over 6 years of experience in designing and implementing advanced data solutions for pharmaceutical clients while managing and mentoring a team of 5+ Data Engineers. My role involves strategic planning, project management, architecture design, technical design reviews and oversight of the team to ensure the delivery of high-quality data solutions. Key achievements include:Azure Data Lake Platform: Spearheaded the setup of an in-house Azure data lake platform, developing 10+ data products for Real-World Evidence (RWE) and Clinical domains. This involved designing Technical Architecture, data architecture, and ETL pipelines. Built a mesh-based architecture using Databricks, streamlining data ingestion, aggregation, and analytics, resulting in a 30% increase in data processing efficiency. Enabled over 100+ business users to independently access and analyze data products through self-serve analytics on Databricks, resulting in accelerated FDA drug approvals for their planned drug launchLegacy System Transformation: Leading the migration of a Japan-based Fortune 500 pharmaceutical company’s legacy Oracle-based systems to a modern cloud-based infrastructure. This included a comprehensive discovery phase of their existing systems, creating a detailed roadmap for their future goals, and executing the implementation plan. This project improved system performance and achieved operational and infrastructure cost savings annually.