Sanjay S Tarkar

Client – Unilever

• Project Delivery & Planning: Managing multiple data engineering projects on Azure Databricks and Power BI, ensuring on-time delivery through effective progress tracking and alignment with client expectations and internal milestones.
• Effort & Cost Estimation: Preparing detailed estimates across various data lake layers and the Power BI reporting layer.
• Team Coordination: Driving smooth collaboration between onsite, offshore, and cross-functional teams to ensure seamless execution.
• Risk Management: Proactively identifying potential risks and implementing mitigation strategies to minimize disruptions.
• Technical Leadership: Providing hands-on technical guidance to developers, resolving challenges, and ensuring high-quality delivery.

Client – Eli Lilly

• Developing AWS Lambda functions in Python for a metadata project, integrating backend functionality with UI.
• Utilizing Amazon API Gateway to trigger Lambda functions, ensuring efficient handling of metadata operations.
• Implementing backend data storage solutions using DynamoDB tables, optimizing data retrieval and storage.
• Employing Elasticsearch for advanced search functionality within the metadata system, enhancing user experience and query performance.

Client – Biocon

• Spearheaded a team of 12 data engineers and Power BI developers, diligently orchestrating the on-time delivery of project deliverables.
• Designed and executed data pipelines to extract data from IQVIA, Veeva CRM, and other sources, integrating them into Data Lake v2 utilizing Azure services such as Data Factory and Databricks.
• Conducted data transformation processes using PySpark within Databricks, facilitating the seamless loading of data into multiple layers of the Medallion architecture, including bronze, silver, and gold.
• Developed several DLT (Delta Lake Tables) pipelines, incorporating SCD2 (Slowly Changing Dimension 2) changes, and implemented rigorous data quality checks.
• Developed multiple POCs on Delta Live Table.

Client – Kone

• Designed and executed data pipelines to seamlessly extract data from SAP and Salesforce, directing it into an AWS Redshift data lake. Leveraged a suite of AWS services, including EFS, S3, Glue Jobs, SNS, and Lambda Functions to orchestrate the data flow.
• Orchestrated AWS Lambda functions and AWS Glue jobs to automate the execution of crawler jobs, ensuring timely processing of new flat files added to the S3 bucket.
• Conducted proficient data transformations utilizing AWS Glue and PySpark, converting source files into a structured format within the Redshift data lake.
• Produced comprehensive QlikSense reports by harmonizing data from diverse data sources, including SAP, AWS Redshift, Salesforce, and more.
• Assumed the pivotal role of Service Manager, demonstrating exceptional leadership in overseeing the AMS track. Ensured the expeditious resolution of tickets in strict adherence to Service Level Agreements (SLAs).
• Client – Chep
• Proficiently managed the end-to-end process of designing, developing, and supporting SAP Lumira Designer-based dashboards.
• Crafted custom CSS and JavaScript solutions to optimize layout and facilitate precise data mapping within the dashboards.