Dhrubajyoti Adhikari
Lisbon, Portugal
Summary
Solutions-oriented Business Analyst possessing unique combination of business analysis, quality assurance testing and process development experience in top-tier organizations. Solid SQL query writing skills paired with familiarity of visualization tools and techniques. Successful provider of data analytics services for almost 9 years of comprehensive experience in healthcare domain.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Associate Business Analyst
Amgen
Lisbon
08.2022 - Current
- Analyzed business requirements in line with Agile methodology and SAFe framework to develop effective business strategies and processes.
- Ensured the accuracy of information by reviewing testing and validation results for product and functionality before release into production environment.
- Guided and supported 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 Data, Activity, PSP and Anaplan.
- 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.
- Played a key role in providing technical assistance for project tools (Databricks, Informatica PowerCenter) and optimizing database usage (Amazon Redshift, PostgreSQL).
- Developed 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.
- Developed optimization strategies based on analysis of user requirements, procedures, and processes.
Information Technology Analyst
Tata Consultancy Services
Kolkata
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 the knowledge and skills to utilize multiple technologies efficiently.
- Evaluated support cases to ensure technical and troubleshooting accuracy, identifying opportunities for process enhancement.
- Ensured the successful implementation of new processes through rigorous testing and validation.
- 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.
- Streamlined responsiveness by assessing and prioritizing customer bug reports and enhancement requests for development.
- Implemented automation and process optimization techniques, resulting in a significant cost reduction of approximately 20% in sales and activity processes.
- Resolved issues and escalated problems effectively with informed support and high-quality service.
Education
Bachelor of Technology - Computer Science and Engineering
Kalyani Government Engineering College
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
- Version Control Tools: GitLab
- Scheduling Tools: Airflow
Certification
SAFe for Teams Course (5.1), Scaled Agile. Inc, 11/30/22
Accomplishments
Amgen:
· 1 Years of service award
· Appreciations from business stakeholders
Tata Consultancy Services:
· Star of the month award twice
· On the spot award twice
· Service and commitment award twice
· Learning achievement award
Languages
English
Professional
Bengali
Native/ Bilingual
Hindi
Elementary
LEARNING INTEREST
- Generative AI & prompt engineering
- Machine learning engineering
- R Programming
Timeline
Senior Associate Business Analyst
Amgen
08.2022 - Current
Information Technology Analyst
Tata Consultancy Services
08.2015 - 04.2022
Bachelor of Technology - Computer Science and Engineering
Kalyani Government Engineering College
Similar Profiles
Eraya MoralesEraya Morales
Senior Specialty Representative/Dermatology at AMGENSenior Specialty Representative/Dermatology at AMGEN
Dane FlandersDane Flanders
Manufacturing Associate at AmgenManufacturing Associate at Amgen
Micah HefnerMicah Hefner
Senior Manufacturing Processing Tech/Training Assistant at AmgenSenior Manufacturing Processing Tech/Training Assistant at Amgen