Swapnil Deo

Company Overview: Merck is one of the Largest BioPharma company in US and other parts of the world.

• I have worked on a project known as DRACOE Tracker for 2 years as an Azure Data Engineer and Power BI Developer which includes Data Extraction, Transformation and Loading it in Azure SQL DB.
• I have successfully delivered the project and was moved to a new project in Merck known as BlueSky Reporting.
• In BlueSky Reporting, I am currently working as a Technical Lead for Power BI developing Reports using data from AWS Athena and other SharePoint or Static Sources to combine them in a Data Model and Visually represent the data in reports.

• Project Overview: Zoetis INC. is the world's largest producer of medicine and vaccinations for pets and livestock. Working in Life Sciences vertical of the company.
• Hands on experience in Informatica/SQL, Stored Procedures/Functions.
• Work in the development of company products, tools, platforms, services and critical business applications which caters services to US/Europe market.
• Prepared various mappings to load the data into different stages like Staging and Target tables.
• Good exposure on Data ware housing concepts/ETL.
• Experience in Azure Data Factory, using Azure BLOB Storage, Azure Storage Explorer.
• Experience in Developing Pipelines in Azure Data Factory for Data processing.
• Working on Change Requests in developed code and redesigning the architecture as per business requirements.
• Responsible for development of External tables on Azure and Stored Procedures for applying business rules and logics in SQL Server.
• Responsible for Coding/Unit Testing/Development/System Integration testing/User Acceptance Testing/ support Data warehousing applications/Change Request Implementation/Job Monitoring/Query-issue resolutions, incident management.
• I worked on Field Force Effectiveness module, where we show the data for the Sales representative, the Sales and Performance of the employees, Customer details on Power BI tool.
• We use various reports to show the business trends graphically and easy to understand UI for users in Power BI.