Senior Data Engineer | Tech Lead
2017 - 2021Airliquide- Migrated on-premise traditional data warehouse solution to Azure cloud.
- Tracked and fixed issues using ServiceNow and managed the project activities integrated into Trello cards for easy follow-ups.
- Used Azure DevOps to deploy Azure Data Factory, Azure SQL database, Azure SQL Data Warehouse, and Azure functions.
Technologies: Azure, Azure Analysis Services, Azure Data Factory, Azure Data Lake, Azure Functions, Azure Blobs, Azure SQL, Azure Logic Apps, Business Intelligence (BI), Azure Cloud Services, Data Warehouse Design, Data WarehousingData Engineer
2019 - 2019Decentral Park Advisors LLC (via Toptal)- Gathered requirements for developing a dashboard for different categories of data.
- Understood the existing conventional Excel report and identified the areas to generate the datasets to develop the Power BI report.
- Worked on Azure SQL database to capture the data and store in tables.
- Created a data model along with required calculated columns and measures using DAX in Power BI to generate the mock-up report pages aligning to excel report.
- Worked on a set of Power BI report pages by using the generated data model.
Technologies: Azure SQL Databases, REST APIs, Azure SQL, Microsoft Power BIData Warehouse Architecture for a Marking Platform
2019 - 2019Gerse Jongens Communicatie BV (via Toptal)- Supported an in-house application database design.
- Developed a data warehouse for reporting purpose in an Azure cloud environment.
- Wrote Power BI reports and supported the embedding of them in a web application.
- Helped to set up an Azure environment for databases and a data factory.
- Created Azure Data Factory pipelines to load data from different source systems.
Technologies: Business Intelligence (BI), Azure SQL Databases, Azure SQL, ETL, Microsoft SQL Server, Azure Data Factory, Microsoft Power BI, Data Warehousing, Data Warehouse Design, AzureFreelance Power BI Database Developer
2017 - 2017Brightfield Group (via Toptal)- Converted R script business rules corresponding SQL rules.
- Built Azure Data Factory pipelines to process those rules without manual interaction.
- Designed reporting tables to pivot and unpivot data.
Technologies: Business Intelligence (BI), Azure SQL Databases, T-SQL, Azure SQL, Microsoft Power BI, Azure Data FactorySenior MSBI Consultant
2015 - 2017InfoMagnus Technolgies Pvt Limited- Developed a data warehouse solution to one of the largest healthcare organizations in the U.S.
- Created a database solution for loading web data and developing reports.
- Developed an ETL tool to load quarterly data from community banks.
- Built a couple of Power BI dashboards for a transportation organization.
Technologies: ETL, Data Warehouse Design, Data Warehousing, Business Intelligence (BI), Azure, Azure SQL Databases, SSAS, SSRS, SQL Server Integration Services (SSIS), Microsoft SQL Server, Azure Data Factory, Microsoft Power BI, Azure SQLSenior Developer
2014 - 2015Pramati Technologies Pvt Limited- Developed multiple reporting dashboards.
- Created stored procedures and functions.
- Developed ETL solutions.
Technologies: ETL, Business Intelligence (BI), SQL Server Integration Services (SSIS), SSRS, SQL Server 2012, T-SQLSoftware Engineer
2011 - 2014MAQ Software- Developed a data warehouse solution.
- Created a reusable deployment tool for databases and cubes.
- Built a SharePoint website.
Technologies: ETL, Business Intelligence (BI), Azure SQL, SharePoint, Microsoft Power BI, SSAS, SSRS, SQL Server Integration Services (SSIS), SQL Server 2012, T-SQL