$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Azure Data Engineer
Makarand Potdar
,
Aylesbury, United Kingdom
Experience
Other titles
Skills
I'm offering
In all 22+ years of experience in UK Banking, Finance, Investment and Retail Banking, Insurance and Energy sector domain.
Extensively worked on Microsoft Azure Services like Azure SQL Datawarehouse, Azure Data lake, Azure Data Factory V2, Azure Data Analytics, Databricks with PySpark, Azure Analysis Service (Tabular), Logic Apps and Power BI.
Modernized the product development process to use Agile (scrum) methods with Azure DevOps that improved efficiency and communications across functions which led to improved delivery of scheduled tasks against an extremely aggressive schedule.
Experience in developing complex calculated measures using Data Analysis Expression language (DAX).
Worked on Microsoft BI stack (SSRS, SSIS, SSAS – Tabular/Multidimensional Cubes), SQL Server and Multidimensional Data warehousing with Ralph Kimball techniques.
Strong experience in T-SQL, SSIS, SSRS, Data migration between different environments and Third Party Databases to single point of reporting database.
Extensively worked on Microsoft Azure Services like Azure SQL Datawarehouse, Azure Data lake, Azure Data Factory V2, Azure Data Analytics, Databricks with PySpark, Azure Analysis Service (Tabular), Logic Apps and Power BI.
Modernized the product development process to use Agile (scrum) methods with Azure DevOps that improved efficiency and communications across functions which led to improved delivery of scheduled tasks against an extremely aggressive schedule.
Experience in developing complex calculated measures using Data Analysis Expression language (DAX).
Worked on Microsoft BI stack (SSRS, SSIS, SSAS – Tabular/Multidimensional Cubes), SQL Server and Multidimensional Data warehousing with Ralph Kimball techniques.
Strong experience in T-SQL, SSIS, SSRS, Data migration between different environments and Third Party Databases to single point of reporting database.
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Available
My experience
2019 - 2020
job
Sr. Data Engineer
Heathrow Airport Ltd.
• Involved in Cyber Security and Baggage System Project
• Architect and design solutions to meet functional and non-functional requirements
• Providing overall technical architecture leadership and direction on project engagements.
• Technology /Tools - Azure: Azure SQL Database & Datawarehouse as a Service, Azure Data lake Storage Gen2, Azure Data Factory V2, Databricks with PySpark ,Azure Data Analytics, Logic Apps, Azure Analysis Service (Tabular) and Python.
• Project Management - Agile development with Azure DevOps and CI/CD
• Reporting Tools - Power BI
• Architect and design solutions to meet functional and non-functional requirements
• Providing overall technical architecture leadership and direction on project engagements.
• Technology /Tools - Azure: Azure SQL Database & Datawarehouse as a Service, Azure Data lake Storage Gen2, Azure Data Factory V2, Databricks with PySpark ,Azure Data Analytics, Logic Apps, Azure Analysis Service (Tabular) and Python.
• Project Management - Agile development with Azure DevOps and CI/CD
• Reporting Tools - Power BI
Technology, CI / CD, Pyspark, Logic, Direction, Power, BEE, Storage, Development, Apps, Azure SQL, Security, Architecture, Service, Design, Analytics, Management, Leadership, Database, Agile development, Agile, DevOps, Power BI, Azure, Project Management, Python, Sql
2018 - 2019
job
Sr. Analyst / Data Engineering
Shell UK.
• Involved in requirement gathering from higher stake holders to create prototypes for various business critical and decision-making applications in Retail Data and Analytics area using Azure for data engineering and Power BI/Embedded Power BI for visualization
• Technology /Tools - Azure: SQL Datawarehouse as a Service, Azure Data lake, Azure Data Factory V2, Azure Data Analytics, Databricks with PySpark, Azure Analysis Service (Tabular) and SQL Server, Alteryx, Python and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI/ Embedded Power BI
• Involved in migration of a legacy Data Warehouse from On-premise to Azure data lake using data factory, set up Azure VM and implement ETL on Azure VM.
• Actively involved in DevOps, by writing PowerShell scripts for the pipelines to auto build and deploy SSIS packages and SQL code changes from using CI/CD.
• Technology /Tools - Azure: SQL Datawarehouse as a Service, Azure Data lake, Azure Data Factory V2, Azure Data Analytics, Databricks with PySpark, Azure Analysis Service (Tabular) and SQL Server, Alteryx, Python and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI/ Embedded Power BI
• Involved in migration of a legacy Data Warehouse from On-premise to Azure data lake using data factory, set up Azure VM and implement ETL on Azure VM.
• Actively involved in DevOps, by writing PowerShell scripts for the pipelines to auto build and deploy SSIS packages and SQL code changes from using CI/CD.
Technology, CI / CD, UP, Pyspark, Power, Server, BEE, Visualization, Alteryx, Development, Analyst, Embedded, Ssis, Engineering, Data engineering, Service, Sql, Analytics, PowerShell, Management, Data Warehouse, ETL, Agile development, Agile, DevOps, Power BI, Azure, SQL Server, Retail, Writing, Project Management, Python
2018 - 2018
job
Sr. Data Analyst/Advisory
Maersk Line.
• Involved in requirement gathering for Cost Reduction Model for Maersk from higher stake holders
• Developed SQL Azure POC to migrate Maersk existing environments to Azure for cost reduction
• Involved in reconciliation of IBM Invoices against actual Maersk usage globally with the help of Power BI
• Technologies Used: SQL, SSIS, SSAS, Azure, Data Factory, Data warehouse, Power BI
• Developed SQL Azure POC to migrate Maersk existing environments to Azure for cost reduction
• Involved in reconciliation of IBM Invoices against actual Maersk usage globally with the help of Power BI
• Technologies Used: SQL, SSIS, SSAS, Azure, Data Factory, Data warehouse, Power BI
Sql, Azure, Power BI, Data Warehouse, Ssis, SSAS, Analyst, BEE, Power
2017 - 2018
job
Sr. Analyst (Data Engineering/Power BI)
British American Tobacco.
• Involved in delivering end to end solution for Manufacturing and Logistic performance across the Europe region.
• Technology used is SAP OER, Azure, Data Lake for BOLBS, Data Factory for Datawarehouse, Azure Analysis Services for developing CUBE and Power BI for various Dashboard reporting.
• Involved in migrating Qlikview/QlikSense reports to Power BI not only visualization but below architecture from SQL Azure
• Technology /Tools - Azure: SQL Datawarehouse as a Service, Azure Data lake, Azure Data Factory V2, Azure Data Analytics, Azure Analysis Service (Tabular) and SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI
• Troubleshooting on Azure components and performance tuning
• Technology used is SAP OER, Azure, Data Lake for BOLBS, Data Factory for Datawarehouse, Azure Analysis Services for developing CUBE and Power BI for various Dashboard reporting.
• Involved in migrating Qlikview/QlikSense reports to Power BI not only visualization but below architecture from SQL Azure
• Technology /Tools - Azure: SQL Datawarehouse as a Service, Azure Data lake, Azure Data Factory V2, Azure Data Analytics, Azure Analysis Service (Tabular) and SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI
• Troubleshooting on Azure components and performance tuning
Service, Tuning, Power, Server, BEE, Visualization, Development, Analyst, Engineering, Data engineering, Architecture, Sql, Technology, Analytics, Management, Agile development, Agile, Power BI, SAP, Azure, SQL Server, Project Management
2017 - 2017
job
Sr. BI Developer (Data Engineering/Power BI)
AON Insurance and Risk Management.
• Develop Power BI and Qlikview dashboards to deliver insight to colleagues in the Global Broking Centre and Aon Underwriting Managers divisions, as part of UK Business Insight Centre
• Provide Power BI and Qlik expertise and guidance to junior members of the team with SQL AZURE
• Work with the consumers across Management, Broking, Finance, Operations and Risk/Compliance to develop and deliver management information which is required to meet the business's strategic, operational, and financial and risk objectives. Deliver MI using Qlikview/Power BI/ SSRS within a reporting framework and set of delivery standards, which all UK MI must adhere to.
• Created complex SSIS Packages for Data Migration and Transformation.
• Technology /Tools - Azure: SQL Datawarehouse, Azure Data lake, Azure Data Factory V1, Azure Data Analytics, Azure Analysis Service (Tabular) and SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI/Qlikview
• Provide Power BI and Qlik expertise and guidance to junior members of the team with SQL AZURE
• Work with the consumers across Management, Broking, Finance, Operations and Risk/Compliance to develop and deliver management information which is required to meet the business's strategic, operational, and financial and risk objectives. Deliver MI using Qlikview/Power BI/ SSRS within a reporting framework and set of delivery standards, which all UK MI must adhere to.
• Created complex SSIS Packages for Data Migration and Transformation.
• Technology /Tools - Azure: SQL Datawarehouse, Azure Data lake, Azure Data Factory V1, Azure Data Analytics, Azure Analysis Service (Tabular) and SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI/Qlikview
Compliance, Framework, Power, Underwriting, Server, BEE, Development, Transformation, Developer, SSRS, Ssis, Engineering, Data engineering, Sql, Service, Technology, Analytics, Management, Finance, Agile development, Agile, Power BI, Azure, Operations, SQL Server, Project Management
2016 - 2017
job
Sr. Analyst (Data Engineering/Power BI)
CRF Health UK.
Working on developing Power BI dashboard reporting, so Investigator, study and Monitoring team can track compliance, eligibility, visit details, Inconsistencies in data, subject details information and any client specific report at cou ntry/site level.
• Creating Power BI dashboards and reports for Clinical Trial Studies
• Provided continued support and development of bug fixes for existing and new Power BI Reports.
• Supporting the functionality and confirmation of Power BI, including the publication of Power BI reports (security, navigation and Power BI desktop vs SharePoint publication) with SQL AZURE
• Extract data from various sources, cleansing, ETL/ELT On-premises and published data to SQL Azure for dashboard and reporting purpose
• Created complex SSIS Packages for Data Migration and Transformation.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Technology /Tools - Azure: SQL, Azure Data lake, Azure Data Factory V1, Azure Data Analytics, SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI
• Creating Power BI dashboards and reports for Clinical Trial Studies
• Provided continued support and development of bug fixes for existing and new Power BI Reports.
• Supporting the functionality and confirmation of Power BI, including the publication of Power BI reports (security, navigation and Power BI desktop vs SharePoint publication) with SQL AZURE
• Extract data from various sources, cleansing, ETL/ELT On-premises and published data to SQL Azure for dashboard and reporting purpose
• Created complex SSIS Packages for Data Migration and Transformation.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Technology /Tools - Azure: SQL, Azure Data lake, Azure Data Factory V1, Azure Data Analytics, SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI
Compliance, Power, Server, BEE, Development, Monitoring, Analyst, Support, Transformation, Ssis, Security, Engineering, Data engineering, Sql, Technology, Analytics, Management, ETL, Agile development, Agile, SharePoint, Power BI, Azure, SQL Server, Project Management, Data Analysis
2016 - 2016
job
Sr. BI Developer/ Analyst
XAAR PLC.
• Development & maintenance of existing Power BI application and SQL AZURE database
• Extract data from various sources, cleansing, ETL in-premises and published data to SQL Azure for dashboard and reporting purpose
• Developed and maintain Data warehouse MS SQL server solutions in SSIS, SSAS and SSRS and Power pivot and Power BI with SQL AZURE
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• SQL Server Analysis Services (SSAS) technologies (Cube Design, SQL/MDX).
• Experience in SSAS Tabular model including OLAP Cubes including aggregations, partitions, hierarchies, roles, row level security and DAX
• Lead in architecture, designing, modeling, developing, maintaining and deploying complex data models, and data integrations utilizing SSIS based ETL processes for new and existing systems
• Technology /Tools - Azure: SQL Datawarehouse, Azure Data lake, Azure Data Factory V1, Azure Data Analytics, Azure Analysis Service (Tabular) and SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI
• Extract data from various sources, cleansing, ETL in-premises and published data to SQL Azure for dashboard and reporting purpose
• Developed and maintain Data warehouse MS SQL server solutions in SSIS, SSAS and SSRS and Power pivot and Power BI with SQL AZURE
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• SQL Server Analysis Services (SSAS) technologies (Cube Design, SQL/MDX).
• Experience in SSAS Tabular model including OLAP Cubes including aggregations, partitions, hierarchies, roles, row level security and DAX
• Lead in architecture, designing, modeling, developing, maintaining and deploying complex data models, and data integrations utilizing SSIS based ETL processes for new and existing systems
• Technology /Tools - Azure: SQL Datawarehouse, Azure Data lake, Azure Data Factory V1, Azure Data Analytics, Azure Analysis Service (Tabular) and SQL Server and MS BI Stack.
• Project Management - Agile development.
• Reporting Tools - Power BI
Architecture, Power Pivot, Processes, MDX, OLAP, Power, Server, BEE, Development, Analyst, SSAS, Developer, SSRS, Ssis, Security, Design, Service, Technology, Analytics, Management, Data Warehouse, Database, ETL, Agile development, Agile, Power BI, Azure, SQL Server, Project Management, Sql
2015 - 2016
job
Sr. BI Developer/ Analyst
Voyanta Ltd.
• Maintaining existing Qlikview Dashboards and ETL processing in MS BI Stack
• Developed and maintain Data warehouse MS SQL server solutions in SSIS, SSAS and SSRS and Power pivot and Power BI
• Plan and facilitate Qlikview training session to users across the organization Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed and maintain Data warehouse MS SQL server solutions in SSIS, SSAS and SSRS and Power pivot and Power BI
• Plan and facilitate Qlikview training session to users across the organization Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
Sql, SQL Server, Power BI, Training, ETL, Data Warehouse, Ssis, SSRS, Developer, SSAS, Analyst, BEE, Server, Power, Processing, Power Pivot
2013 - 2015
job
Sr. BI Analyst/ Developer
Avantia Insurance Co.
• Designing Datawarehouse/Datamarts with SQL Server 2008R2/ 2012 , T-SQL,with MS BI Stack (SSIS,SSAS & SSRS) and QlikView for presentation layer.
• Power pivot Strong skills with extracting data from a Data Warehouse and be able to construct complex queries, views and stored procedures
• Development/Maintenance and migration of existing projects on MSBI Stack with Designing, creating Architecture, Data Modeling and Performance tuning with SQL Server 2012.
• Involved in integrating, optimizing & centralizing of data from the numerous databases across the business
• An understanding of London Market Insurance and its accounting practices.
• Working with Scrum team for developing solutions with User Stories, Velocity, Task Definition, Back Log, Burn Down, Sprints to the management as per defined in Agile Methodology.
• Working in Kanban Team to resolve High priority issues.
• Power pivot Strong skills with extracting data from a Data Warehouse and be able to construct complex queries, views and stored procedures
• Development/Maintenance and migration of existing projects on MSBI Stack with Designing, creating Architecture, Data Modeling and Performance tuning with SQL Server 2012.
• Involved in integrating, optimizing & centralizing of data from the numerous databases across the business
• An understanding of London Market Insurance and its accounting practices.
• Working with Scrum team for developing solutions with User Stories, Velocity, Task Definition, Back Log, Burn Down, Sprints to the management as per defined in Agile Methodology.
• Working in Kanban Team to resolve High priority issues.
Ssis, Power Pivot, Sql server 2012, Tuning, Power, Server, BEE, Development, Insurance, Analyst, SSAS, Developer, SSRS, Sql, Architecture, T-SQL, Kanban, Management, Stored procedures, User stories, Data Modeling, Data Warehouse, Agile, SQL Server, Scrum
2012 - 2013
job
Sr. BI Analyst
Annalect.
• Designing Datawarehouse/Datamarts with SQL Server 2008R2/ 2012 , T-SQL,with MS BI Stack (SSIS,SSAS & SSRS) including Power Pivot and Power View 2012 as Interactive Visualization reporting to Client Managers.
• Worked on User Stories, Task Definition, Back Log, Burn Down, Sprints to the management as per defined in Agile Methodology.
• Part of Kanban Team to resolve High priority issues.
• Worked on User Stories, Task Definition, Back Log, Burn Down, Sprints to the management as per defined in Agile Methodology.
• Part of Kanban Team to resolve High priority issues.
Sql, SQL Server, Agile, User stories, Management, Kanban, T-SQL, Ssis, SSRS, SSAS, Analyst, Visualization, BEE, Server, Power, Power Pivot
2012 - 2012
job
Sr. BI Developer
Investec Asset Management.
• Building reports and Universes with Business Objects and QlikView(Dashboard Design and scripting) for MIS and Investment and Risk department team
• Developed solutions in SSIS, SSAS, SSRS, BO, Power Pivot and Informatica (9.1)
• SAP BO Reporting V. XI R3.1,WEBi, Universe Designing, Data Services
• Working on User Stories, Task Definition, Back Log, Burn Down, Sprints as per defined in Agile Methodology. Used TFS for change control management
• Experience in developing Markit EDM (CADIS) batch to receive and process pricing and benchmark data from multiple sources, validate match and master it on the Markit EDM (CADIS). Publish the data to downstream systems. Liaising with business users and the testing team.
• Developed solutions in SSIS, SSAS, SSRS, BO, Power Pivot and Informatica (9.1)
• SAP BO Reporting V. XI R3.1,WEBi, Universe Designing, Data Services
• Working on User Stories, Task Definition, Back Log, Burn Down, Sprints as per defined in Agile Methodology. Used TFS for change control management
• Experience in developing Markit EDM (CADIS) batch to receive and process pricing and benchmark data from multiple sources, validate match and master it on the Markit EDM (CADIS). Publish the data to downstream systems. Liaising with business users and the testing team.
Design, SAP, Agile, Scripting, User stories, Management, Ssis, SSRS, It, TFS, Developer, SSAS, Testing, BEE, Power, Power Pivot
2010 - 2011
job
BI Application Analyst for Finance
Schroder's Asset Management.
Aug'10 - Dec'11
• Developed and maintain Data warehouse MS SQL server solutions in SSIS, SSAS and SSRS
Working as a BI Application Analyst for Finance, Investment and Market Credit Risk department with SAP Business Objects XI R 3.1 (Deski, Webi, Universe and Data Services), SSIS, and SQL Server 2005/2008R2 and Oracle 10g, Hyperion EssBase with various Finance and Trade related applications. Performance tuning of cubes.
• Experience to get order management data from Charles River through CADIS and transfer it in batch to load back in SQL Server.
• Developed and maintain Data warehouse MS SQL server solutions in SSIS, SSAS and SSRS
Working as a BI Application Analyst for Finance, Investment and Market Credit Risk department with SAP Business Objects XI R 3.1 (Deski, Webi, Universe and Data Services), SSIS, and SQL Server 2005/2008R2 and Oracle 10g, Hyperion EssBase with various Finance and Trade related applications. Performance tuning of cubes.
• Experience to get order management data from Charles River through CADIS and transfer it in batch to load back in SQL Server.
Ssis, SQL Server 2005, Tuning, Server, BEE, Analyst, SSAS, It, SSRS, Sql, Management, Finance, Data Warehouse, R, SAP, Oracle, SQL Server
2006 - 2010
freelance
Sr. BI Consultant\Analyst
Nationwide Building Society.
Analyst, BEE
2005 - 2006
job
Team Leader/ Analyst
Mastek Ltd.
Analyst
2000 - 2005
job
Project Leader, Analyst
Capita Group Plc.
Analyst
2000 - 2000
job
Senior Programmer
British Petroleum Plc.
1999 - 2000
job
Senior Programmer
Intelecorp Software Pvt. Ltd.
1996 - 1999
job
Senior Programmer/ Programmers
Computrade Services Pvt. Ltd.
Makarand's reviews
Makarand has not received any reviews on Worksome.
Contact Makarand Potdar
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Makarand directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark