Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
learning Interest
Life Philosophy
Interests
Generic

Dhrubajyoti Adhikari

Lisbon

Summary

Results-driven Senior Data Engineer with over 10 years of experience in the healthcare domain, specializing in data engineering, business analysis, and process optimization. Expertise includes designing and building scalable data pipelines, optimizing ETL workflows, and delivering high-quality, reliable data solutions for analytics and reporting. Proficient in SQL, data modeling, and leveraging modern data platforms along with visualization tools to drive insights. Demonstrated ability to translate complex business requirements into scalable, efficient data solutions that enable strategic decision-making and enhance operational performance.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Amgen
12.2024 - Current
  • Built and maintained ETL/ELT pipelines using Databricks (PySpark, Delta Lake), ensuring efficient ingestion, transformation, and curation of large-scale healthcare datasets.
  • Implemented and orchestrated workflows with Apache Airflow, reducing processing time by 15%.
  • Wrote and optimized complex SQL queries and data models to support analytics, reporting, and downstream applications.
  • Collaborated with Business Analyst and Business teams in an Agile/Scrum environment, translating business requirements into robust data engineering solutions.
  • Leveraged GitLab CI/CD for version control, code reviews, and deployment automation, improving development efficiency and release quality.
  • Tuned pipeline performance, reducing processing time by 75% and optimizing compute costs on cloud infrastructure.
  • Proven ability to learn quickly and adapt to new situations.
  • Demonstrated strong organizational and time management skills while managing multiple projects.
  • Managed time efficiently in order to complete all tasks within deadlines.
  • Mentored junior engineers, conducted code reviews, and contributed to establishing best practices for data engineering standards and documentation.

Senior Associate Business Analyst

Amgen
08.2022 - 12.2024
  • Analyzed business requirements in line with Agile methodology and SAFe framework to develop effective business strategies and processes.
  • Ensured accuracy of information by reviewing testing and validation results for product and functionality before release into production environment.
  • Played key role to guide and coordinate with IT team in data analysis, model development and presentation creation.
  • Conducted analysis of competitor's marketing strategies by examining data in redshift and databricks (SparkSQL), resulting in the identification of emerging trends and the creation of new performance measures.
  • Efficiently tracked project progression by implementing JIRA, an industry-standard issue tracking tool.
  • Ensured successful implementation of new initiatives through collaboration with business stakeholders in Sales, Master, Activity, PSP and Anaplan data.
  • Conducted gap analysis to align current state processes and systems with future state processes and systems.
  • Developed flow diagrams to enhance understanding of various processes for the business team in confluence documentations.
  • Provided technical assistance for project tools, including Databricks and Informatica PowerCenter, while optimizing database usage with Amazon Redshift and PostgreSQL.
  • Developed optimized strategies for enhancing product and process based on input from business stakeholders and users.
  • Collaboratively established the specifications for features, integrations, and partnerships alongside stakeholders.

Information Technology Analyst

Tata Consultancy Services
08.2015 - 04.2022
  • Created efficient Informatica powercenter processes and stored procedures for transferring data into Oracle Database.
  • Enhanced operational efficiency by resolving issues with Informatica powercenter processes and database stored procedures.
  • Developed and enhanced Databricks notebooks for data processing from different files (csv, text, excel) and databases (Teradata, SQL server, PostgreSQL) into Amazon redshift database.
  • Utilized GitLab to implement version control for Databricks notebooks.
  • Enhanced Airflow DAGs and scheduled.
  • Fostered adherence to IT industry standards for optimal performance.
  • Empowered team members with knowledge and skills to utilize multiple technologies efficiently.
  • Ensured the successful implementation of new processes through rigorous testing and validation.
  • Evaluated support cases to ensure technical and troubleshooting accuracy, identifying opportunities for process enhancement.
  • Automated routine tasks by developing scripts.
  • Developed and fostered strong partnerships with clients, vendors, and teams.
  • Mentored technologists and support professionals to enhance their professional development and skills.
  • Delivered on-site technical support, actively advising on product changes and enhancements after successful project implementation in Netherlands for 2 years.
  • Implemented automation and process optimization techniques, resulting in a significant cost reduction of approximately 20% processes.

Education

Bachelor of Technology - Computer Science and Engineering

Kalyani Government Engineering College
India
07.2015

Skills

  • Agile/Scrum Methodology
  • SQL
  • PLSQL Programming
  • Confluence
  • JIRA
  • Informatica Powercenter
  • Informatica Data Quality
  • Amazon Services: S3, RDS, Redshift
  • Databricks (PySpark), SparkSQL
  • Databases: Oracle, Teradata, PostgreSQL
  • Scripting Languages: Unix Shell Scripting
  • Data Modeling & Design Tools: ER Studio, MIRO, Visio
  • Version Control Tools: GitLab
  • Scheduling Tools: Airflow

Accomplishments

    Amgen:

  • 3 years of service award
  • 1 Years of service award
  • Appreciations from business stakeholders

    • Tata Consultancy Services:

  • Star of the month awards
  • On spot awards
  • Service and commitment awards
  • Learning achievement award

Certification

SAFe for Teams Course (5.1), Scaled Agile. Inc, 11/30/22

Languages

English
Professional
Bengali
Native/ Bilingual
Hindi
Limited

Timeline

Senior Data Engineer

Amgen
12.2024 - Current

Senior Associate Business Analyst

Amgen
08.2022 - 12.2024

Information Technology Analyst

Tata Consultancy Services
08.2015 - 04.2022

Bachelor of Technology - Computer Science and Engineering

Kalyani Government Engineering College

learning Interest

  • Generative AI and prompt engineering
  • Machine learning engineering
  • R programming

Life Philosophy

Make things easier instead of complicating

Interests

Cooking, riding cycle, playing cricket

Similar Profiles

CREATE PROFILE
Dhrubajyoti Adhikari