Data Lead
Open To Work
Ashish Kumar
MERCK
Bengaluru,KA
Work Preference
Job Search Status:
Open to workDesired Job Title
Lead Data EngineerWork Type
Full TimeLocation Preference
On-SiteLocation:
Bengaluru, KAOpen to relocation:
YesImportant To Me
Career advancementPersonal development programsWork-life balanceCompany CultureHealthcare benefitsSummary
Having Around 5 years of IT experience in developing various reports and data visualization capabilities on large volumes of data in order to support consulting projects in Snowflake, IICS cloud, Databricks, Matillion, Redshift, Airflow, DBT, AWS S3, JIRA, Snow SQL, Dbeaver, Stream lit and GitHub.
5
years of professional experience
1
Certification
Work History
Data Engineer
1 Year 9 Months- I am taking ownership and doing the deliverable action items to drive the project in the right direction during the meetings with client data foundation teams.
- I contributed myself while creating complex relations between data models like LUCI, MDF, and Finance foundations with the help of SQL Logic and SQL DBM tool.
- I contributed to developing the MMX data reverse engineering strategy.
- I used to create a list of tickets in a sprint session with proper description and action items.
- I contributed to preparing the weekly status reports for the MMX project.
- I contributed to upgrading the code (tables and views DDLs) in the GitLab repository.
- Understanding the data in different foundation databases like LUCI, MDF, FINANCE, A&P for Countries which are in scope like Germany, France, China etc.
- I am developing the mappings and mapping tasks for the pipeline of the MMX project regarding German and France countries data.
- The company's origins can be traced to the monthly sales and interactions data for the growth of various brands at different channel levels across the markets by fetching the data from different data foundation databases. They will integrate the required data in one database to makes easier analysis and for improving the sales of brands across globally.
Data Engineer & Data Lead
2 Years 1 Month- I have worked as data engineer & data lead from backend in Sanofi Dive project from NOV 2023 to till date.
- I adjusted my working hours flexibly to facilitate data ingestion into the database, supporting clients during their governance meetings.
- I collaborated effectively with clients to resolve complex problems and achieve common goals.
- I have received appreciation emails from clients for delivering my work and resolving issues on time in various projects such as Sanofi DIVE. Attached are the documents for reference.
- I have nominated for Bravo award on December 2023 for delivering Prompt solution and quality of work to clients and resolving issues on time in Sanofi DIVE.
- To improve business intelligence reporting on calculating custom measures within the Snowflake database environment.
- We created some custom measures tailored to our specific business needs.
- - YTD, MAT, RQTR Calculations: Implemented Year-to-Date (YTD), Month-to-Date (MAT), and Quarter-to-Date (RQTR) measures to provide dynamic insights over time.
- Integration with various data sources was streamlined, ensuring a centralized repository for all Market Analytics data.
- Advanced SQL knowledge for querying, optimizing, and manipulating data within cloud platforms.
- Ensuring that data processing jobs and pipelines are optimized for performance and scalability.
- Ensure in managing data retention for large datasets using advanced cloud features.
- Experience within scheduling, monitoring, and reviewing logs for workflows in a specific sequence.
- The company's origins can be traced back to the analysis of monthly market analytics sales data, tracking the growth of various brands across different channels and markets. By retrieving real-time data from diverse databases, they integrate the necessary information into a single database to facilitate analysis and enhance brand sales on a global scale and supporting Power BI dashboards.
Data Engineer & Backend Data Lead
1 Year 8 Months- Served as a Data Engineer and Backend Data Lead for the Merck Data Genie project, leading data engineering initiatives and backend development activities.
- Successfully migrated enterprise data from legacy systems to a cloud-based architecture using the Data Genie Framework.
- Designed and implemented solutions aligned with the Sales Domain Medallion Data Architecture in Databricks.
- Managed feature and release branches, delivering enhancements and new functionalities in accordance with client requirements.
- Automated deployments to UAT environments through GitHub Actions, ensuring efficient and reliable release management.
- Investigated and resolved GitHub workflow issues and Matillion DPC pipeline failures to maintain operational stability.
- Acquired strong business and technical expertise in pharmaceutical sales data and analytics.
- Led project deliverables, coordinated with client Data Foundation teams, and drove discussions to ensure timely project execution.
- Implemented data quality frameworks and validation checks using Collibra to improve data reliability and governance.
- Orchestrated and monitored Matillion DPC pipelines using Apache Airflow across Development, QA, UAT, and Production environments.
- The Sales Domain is built on the Data Genie Framework and was designed to provide a unified global sales data platform across products, geographies, channels, and contracts. It enables analytics teams and business users to leverage a single source of truth, ensuring consistent, accurate, and reliable insights for decision-making.
Education
SSC
GPA: 8.8
Intermediate
GPA: 89.6%
Bachelor of Technology
GPA: 8.17
Skills
Windows Family
SQL
Snowflake
Databricks
SQL Server
IICS
Matillion
IICS migration server
Power BI
AWS
Certification
Snowflake data engineer
Awards
Bravo Award, For excellent performance and impact on the team.
Timeline
Data Engineer & Backend Data Lead
MERCK
01.2025 - Current
Data Engineer & Data Lead
Sanofi
11.2023 - 12.2025
Data Engineer
Sanofi
01.2022 - 10.2023
Sri Balaji High School
SSC
Sri Chaitanya Junior College
Intermediate
Karunya University
Bachelor of Technology