Nishil Jain

 I am a experienced Microsoft Azure BI developer and Data Warehouse consultant with 21 years of experience in integration and development of data warehouse and BI solutions. I have worked with both real-time and batch-oriented data using Microsoft's technology in both cloud and on-premises data warehouse solutions. I am a MCT (Microsoft Certified Trainer) for both BI and BizTalk. I am well-versed in Microsoft's cloud-based data warehousing and have implemented data warehouses in Azure cloud using Azure Synapse Analytics, Azure Data Factory, Logic Apps, Azure SSAS, to create reporting solutions in form of cubes that provide fast response times for queries. I also have experience with advanced DAX for calculating KPIs, metrics, and advanced access control. I am someone who always delivers what is expected and is highly regarded by our clients. Relevant work experience: Sept 2021 – now Knish Technologies AS, Senior BI Software Consultant Primarily working on Azure cloud-based Microsoft BI data warehouse projects, involving tI development of Azure Synapse Analytics, Azure Data Factory, Azure Logic Apps, SSIS, SSAS, Power BI data warehouses, and Tabular Cubes for clients. Apr 2016 – Aug 2021 Veidekke AS, Senior BI Software Consultant Mainly involved in Microsoft BI projects, including development of SSIS, SSAS, Power BI data warehouses, and Tabular Cubes for internal departments serving as clients. Jun 2011 – Mar 2016 EVRY AS, Senior BI Software Consultant Primarily worked on Microsoft BI and BizTalk projects for various clients. Mar 2009 - May 2011 Crayon AS, Senior BizTalk Consultant Worked on BizTalk/SharePoint projects for clients. May 2008 - Feb 2009 Hands AS, Senior BizTalk Consultant Worked on BizTalk/Dynamics AX projects for clients. Apr 2007 - Apr 2008 CapGemini India, Senior BizTalk Consultant Worked on BizTalk projects for clients. Aug 2006 - Apr 2007 Wirpo Technologies(India), Senior BizTalk Consultant Worked on BizTalk projects for clients. Aug 2005 - Aug 2006 Byzan System(India), Junior BizTalk Consultant Worked on BizTalk projects for clients. Jun 2004 - Jul 2005 Rajguru Enterprises, Junior Developer Worked on VB/SQL projects as a junior support developer. Languages Norwegian Level: Fluent English Level: Fluent Projects ISS Facility Services AS Project Digital BI Information Platform with Azure Fabric Employer Role Knish Technologies AS Senior Microsoft BI Developer Period Aug 2023 – Now Technology Microsoft Azure Fabric/Python/SSIS/SSAS Tabular /PowerBI Description As a Senior BI developer, I am working on a completely new implementation of a data warehouse solution in Azure Fabric using Data Factory, Spark Pools, and PowerBI datasets to host tabular model cubes and Python notebooks (Pyspark/SparkSQL). I have implemented Data Factory pipelines to read data from various sources such as FTP/SQL DB/Synapse link/Dataverse connection. Architecture: I am also involved in architecture design of entire digital data warehouse solution, considering technology choices for different layers required in terms of GDPR requirements and usability for developers. I used Fabric notebooks with Python to retrieve data from different systems and moved data between different layers such as Bronze, Silver, Gold with facts and dimensions to be loaded as datasets in Power BI premium dashboards. My role in this project has been to design, develop, and test BI solution. My role as a BI developer is to design integrations and ensure quality of implemented solution. OBOS Project Digital BI Informaon Platform with Azure Synapse/Databricks Employer Role Knish Technologies AS Senior Microsoft BI Developer Period Sept 2021 – July 2023 Technology Microsoft Azure Synapse/Python/SSIS/SSAS Tabular /PowerBI Description As a Senior BI developer worked on a completely new implementation of a data warehouse solution in Azure Synapse Analytics using Data Factory, Dedicated SQL Pools, serverless Pools, Spark Pools, and Azure Analysis Services to host tabular model cubes and Python notebooks (Pyspark/SparkSQL). I implemented Data Factory pipelines to read data from various sources such as FTP/SQL DB/Synapse link/Dataverse connection. Architecture: I was also involved in architecture design of entire digital data warehouse solution, considering technology choices for different layers required in terms of GDPR requirements and usability for developers. I ensured that architecture is compatible with SQL (SSIS) developer profile so that existing developers can be productive and contribute to development. I used Synapse notebooks with Python to retrieve data from different systems and moved data between different layers such as Bronze, Silver, Gold with facts and dimensions to be loaded as datasets in Power BI premium dashboards. I was involved in cost analysis of Spark pools' uptime and how to minimize costs by implementing cost-effective architecture with minimal data movement. I was in close dialogue with Microsoft to ensure delivered solution aligns with architecture that Microsoft believes is suitable for OBOS's requirements. I was also working with Dataverse Synapse link to extract data from Dynamics CRM into Synapse data warehouse. Additionally, I was working on integrating IoT sensor data into Azure Synapse data warehouse for OBOS's new concept, which includes sensors for measuring temperature, emissions, etc. Development: I implemented CRM Dataverse and Outbound Marketing and Real-me Marketing (Managed Data Lake) exports for CRM entities using Azure Synapse link and used Data Factory to read m using CDM to Azure Data Warehouse as facts/dimensions. I worked on configuring and retrieving data from Dynamics AX (FO) using Data Lake export plugin instead of old BYOD approach. I worked with Stream Analytics job to read data from Event Hub queue and write it to Parquet database and SQL DB. I worked on reading data from APIs into Azure Synapse data warehouse. This also involves future development of current solution with need to read data from new sources such as CosmosDB, CRM, MDS, Blob store. Python: I worked on Pyspark libraries to retrieve data from Service Bus queues. I also worked on moving data from CSV to Parquet formats and loading m into serverless Bronze database layer. In Silver layer, Python was used for SCD versioning using delta tables. Gold layer involved all surrogate lookups. BI On-premises Reporting Centre: on-premises data warehouse uses SSIS as an ETL tool, SQL Server as a database, and SSAS Tabular as a Cube server. source systems for current on-premises solution are Dynamics AX, Dataverse, DTP, Fenistra, Corporator, Cognos, As400, Alusta. This involves gathering requirements from business units and implementing solution in Microsoft BI data warehouse using Microsoft SSIS and SSAS as development tools. I worked as a Senior BI developer responsible for future development of current on-premise data warehouse solution based on Microsoft BI platform. This involves development using SSIS as an ETL tool and 3rd-party SSIS SF components used for delta load, lookup, and loading data into data warehouse. Data is transformed and loaded into EDW layer using stored procedures before being loaded into Tabular SSAS cube. Power BI am used as a dashboard tool that reads data from Tabular Cubes as a source and from Power BI datasets (Cubes published as Power BI dataset-feature of Power BI Premium). My role in this project have been to design, develop, and test BI solution. My role as a BI developer is to design integrations and ensure quality of implemented solution. Veidekke AS Project InsightFactory datawarehouse solution Employer Veidekke AS Role Senior Microsoft BI Developer Period Apr 2016 – Aug 2021 Technology Microsoft SSIS/SSAS Tabular/Azure Description As a Senior BI developer, I have been responsible for developing a BI data warehouse solution based on Microsoft BI platform. This involves development using Talend/SSIS as an ETL tool to load data into data warehouse, n transform and load it into EDW layer before processing it into Tabular SSAS cube. I have developed multiple Power BI dashboards that read data from Tabular Cubes as a source, including Power BI datasets (Cubes published as Power BI dataset feature of Power BI Premium). I have worked on Azure BI projects involving migration of SSIS packages to Data Factory/Logic Apps, building cubes in Azure Analysis Services, and creating reports in Power BI. I have also worked on migrating databases with Dynamics 365 ERP as one of source systems. I have been involved in implementing next integrations in Azure Services and building data warehouse using Azure products. In this project, My role has been to design, develop, and test BI solution. As a BI developer, I designed integrations and ensures quality of implemented solution. Evry Corporate Reporting Project ECR module Role Senior SSAS Developer Period April 2013 – Mar 2016 Technology Microsoft SQL Analysis Services 2014. Microsoft SQL Integration Services 2014. Description EVRY, as Norway's largest IT company, delivers extensive services to Norwegian and Nordic businesses, financial sector, and public organizations, including government, municipalities, and healthcare sector. EVRY's office is in Fornebu, outside Oslo. company have been behind numerous innovations that have transformed and simplified way people use services in society. One of EVRY's internal projects is Evry Financial Reporting, which provides various types of reports to managers. This includes financial reports, billing reports, and sick leave reports. In this project, My role have been to design, develop, and test an access solution with users, based on permissions, receive customized reports in Microsoft. I utilized PerformancePoint, Excel Reports, and roles in solution. I was also involved in setting up solution on a new server. Thus, entire process, from ETL solution for reading data into data warehouse to building cubes and dimensions, have been developed. Storebrand Project Invoicing module Employer Evry AS Role Senior SSAS/SSIS Developer Period Jan 2015 - Jan 2016 Technology Microsoft SSAS/SSIS Description Storebrand is a Nordic financial conglomerate with its origin and Headquarters in Norway. group offers life insurance, non-life insurance, asset management, and banking services. With over 2,000 employees, Storebrand is a major operational client of EVRY. To accurately charge Storebrand for operational services, a highly complex process is in place that considers factors such as hardware, services, agreement levels, and SLA fulfilment. A data warehouse solution have been developed to gar data from various sources and perform advanced calculations to determine pricing based on agreements and deliveries made to customer. I am part of development team for this data warehouse solution. His role involves contributing to design of solution, building ETL jobs in SSIS, modelling and constructing data warehouse model with associated cubes, and developing reports using PerformancePoint Services, Reporting Services, and Excel Services. Molde Kommune Project Balanced KPI module Role Senior BI Consultant Period Nov 2013 - Dec 2014 Technology Microsoft SSIS/SSAS, Performance Point Services/MS SQL Server Description This was a project to develop BI solutions for finance and HR. data source for data warehouse was primarily Visma. Direktoratet for økonomistyring (DFØ) Project Receiving module Employer Evry AS Role Senior BizTalk developer Period May 2015 – Mar 2016 May 2013 - Dec 2013 Jun 2012 – Nov 2012 Technology BizTalk Server Description Directorate for Financial Management (DFØ) is an agency under Ministry of Finance. DFØ have 370 employees with a central unit in Oslo and regional offices in Hamar, Drammen, Kristiansand, Stavanger, Trondheim, and Tromsø. DFØ advises central authorities on government financial management and carries out administrative tasks for all government agencies. customer receives reports from government agencies in 6 different formats through a web portal. Using solution developed by I in BizTalk, Reporting is converted into a common format and validated against a set of business rules. If report fails validation, an error message is notified through web portal. Otherwise, report is uploaded into Agresso. My role in this project have been to design, develop, and test BizTalk Integration with Agresso. I, as BizTalk architect, is responsible for designing integrations and ensuring quality of implementation by team. I was also involved in designing and making changes to existing ASP.net application. team consisted of 3 developers, including I, where I handled most of technical solution design. Aggregator Integration pattern was used to gar data in different formats into a common format, and Content-Based Roung pattern was used to route error messages. Ilse Verkal (EVRY) Project IHR Communicaon module Role Senior BizTalk developer Period Jun 2014 - Dec 2014 Technology BizTalk Server 2010 Description As Norway's largest IT company, EVRY delivers extensive services to Norwegian and Nordic businesses, financial sector, and public organizations, including state, municipalities, and Healthcare sector. EVRY's office is in Fornebu, just outside Oslo. EVRY is behind several innovations that have changed and simplified people's way of using services in society. Healthcare Vertical department at Evry have implemented a solution for receiving blood sample orders and forwarding it to laboratories. My role in this project have been to install and configure a new BizTalk 2010 environment (Development/Test/QA), migrate old code to new server, and test various aspects, including compatibility between environments. I was involved in making new changes to solution for sending orders to email address. Norges Bank Project Edit2014(EPI Server Portal) Integration Employer Evry AS Role Senior BizTalk Developer Period May 2014 - Jun 2014 Technology BizTalk Server 2013 Description Norges Bank is central bank of Norway. Its main objective is to promote economic stability in country. It has executive and advisory tasks in monetary policy and aims to contribute to robust and efficient payment systems and financial markets. Norges Bank manages country’s foreign exchange reserves and Government Pension Fund Global. Norges Bank project involved integrating an internal system with EPIServer Portal, which displays exchange rates to end users for converting money to and from foreign currency. My role in this project have been to install and configure a new BizTalk 2013 environment (Development/Test/QA). I integrated EpiServer with a file share where new files with exchange rates were copied daily. re were approximately 40-50 "send ports" and around 30-40 "receive ports". It was crucial to avoid bottlenecks and ensure sufficient resources (memory/CPU) for all file transfer processes. I assisted in troubleshooting code failures when needed. Sør-Trøndelag Fylkeskommune Project VIGO-P360 Integrasjon Role Senior BizTalk Developer Period jan 2012 - feb 2012 Technology BizTalk/.Net, MS SQL Server Description Customer wants to archive applications from students that are submitted from a system called Vigo to an archiving system (P360). My role in this project have been to develop solution in BizTalk using Orchestration, Maps, Pipelines, and Schemas. Additionally, I have created an installation package to deploy solution to or servers. Statkraft AS Project BizLive Integration:BizTalk Role Software Developer Period feb 2011 - okt 2011 Technology BizTalk, MS SQL Server Description Statkraft is a leading international company in hydropower and Europe's largest supplier of renewable energy. company generates hydropower, wind power, gas power, and district Iang and is a global market player in energy trading. Statkraft have 4,200 employees in more than 20 countries. My role in this project have been to create design specifications based on requirements specifications and discuss with system owners how to integrate systems using BizTalk as Integration platform. I have developed several integrations involving Excel, flat files, and or systems such as Pomax, Pixos, Proxos, ICC, Weld, and Dachs. Kongsberg Marime Project SharePoint 2010 Portal development and BizTalk Integration. Role Software Developer Period May 2010 - Oct 2011 Technology BizTalk, SharePoint, MS SQL Server Description Kongsberg Marime (KM) is a Norwegian technology conglomerate within Kongsberg Group (KOG). Kongsberg Marime provides positioning, mapping, navigation, and automation systems for commercial ships and offshore installations. ir most well-known products exist in areas of dynamic positioning systems, marine automation and monitoring systems, process automation, satellite navigation. SharePoint: customer wanted a SharePoint portal with CRM accounts, leads. BizTalk: customer wanted to integrate Dynamics AX with Microsoft CRM entities (Accounts/Kunde/Contacts). BizTalk: I was also involved in a project to integrate Dynamics AX with Microsoft CRM using BizTalk Server. I used debatching to split incoming XMLs and processed each record independently in BizTalk. I implemented 2 integrations involving Integration of a data warehouse and CRM. Elopak AS Project BizTalk Integration with Jeeves/DB2/Windchill/Portolan/ProcessShipper Role Senior Software Developer Period Jun 2009 - Apr 2010 Technology BizTalk, MS SQL Description Worked on a Integration project integrating above named systems. systems vary with each or in terms of architecture and infrastructure. DB2 system is based on As400 environment while Windchill is a Java based Portal. Process Shipper is SAP module specializing in Transport domain. Integration involved many pipelines to maintain Schema standards and DB2 lookups for update scenarios. It involved 15 different Integration Scenarios with varied requirement. customer is market leader in packaging industry with manufacturing units spread across world. My role on this project varied from Requirement gathering, Architecture designing to Development and Production movement. I did mentor a team of 3 resources from Client end who are beginners in Integration domain. These projects helped me evolve in global arena of handling Customers at individual level with team members located in different geographic locations. Santander Bank Project BizTalk 2006 Integration with JATO,Java Applications Role Senior Software Developer Period Jun 2007 - Apr 2008 Technology BizTalk, MS SQL Description I worked on a BizTalk Server 2006 Integration project carried out on client side. client was a Spanish bank ranked as 8th best among all banks worldwide. I worked alone, integrating systems with BizTalk and monitoring live servers for errors and issues. systems involved in Integration were Bea Weblogic, JATO, Itella, D&B,Statoil. I installed BizTalk Production, development, and staging servers for interface development. Additionally, I created a reverse proxy website in Asp.net to serve as middleware for one of client’s websites for security reasons. Thomson Corporation Project BizTalk Server 2006 Integration with Ecommerce Application Role Senior Software Developer Period Apr 2006 - Apr 2007 Technology BizTalk, MS SQL Description I worked on a project to integrate Comergent e-commerce application with BizTalk Server 2006 for a client [Thomson Corporation] based in USA. I worked on mapping through XSLT in maps, BRE, and SSODB Config. I was only offshore resource working on project. I directly interacted with client to understand the needs and integrate various systems accordingly. I created an MMC 3.0 Snapin for administrators to add key/value pairs to SSODB database. I developed a tool for orchestrations to query SSODB database and retrieve value based on a key name. Additionally, a tracing tool was created to troubleshoot any orchestrations in case of errors during project. I also integrated JD Edwards with BizTalk. Patni Computers Project BizTalk Server 2004 Integration with People soft Role Software Developer Period Sep 2005 - Aug 2006 Technology BizTalk, MS SQL Description I worked on-site at Patni Computers (SEEPZ, MUMBAI) for a BizTalk project. I served as Lead BizTalk Developer for this project. My responsibilities included integrating BizTalk with Metastorm Ework, PeopleSoft HR, and PeopleSoft Finance. I developed a pipeline component specifically for Cdata, as PeopleSoft system expects data in Cdata format. I created numerous custom functions and performed several proof-of-concept (POC) exercises for debatching scenarios. I was involved in POCs for all four types of debatching, as well as scenarios requiring correlation. I developed scripts for automatic deployment and distribution of orchestrations and port bindings. Additionally, I created an adapter to integrate Active Directory with BizTalk, successfully integrating Active Directory with BizTalk in Patni Systems. After project went live, I was involved in maintenance work and led a team of two individuals. It's worth noting that this project was implemented in collaboration with Microsoft Consulting Services, who served as an active partner. Patni Computers is fifth-best IT company in India. Rajguru Enterprises Software Developer June 2004 - June 2005 VB, MS SQL I worked on-site at Rajguru as a junior software developer working with support roles in SQL Server and VB programming language. After project went live, I was involved in maintenance work. Relevant Competence Technology competence Skillset/ Product Version Experience Role Azure Fabric 3 year Senior BI Datawarehouse developer/Architect. Azure Azure Synapse 3 years Senior BI Datawarehouse Developer/Architect: Azure Cloud Services. Specification, Development, Maintenance of Business Intelligence projects. Azure Databricks 3 years Senior Datawarehouse developer. Specification, Development, Maintenance of Business Intelligence projects. Azure Data Factory/Logic Apps/Azure Services/Functions 7 years Senior Azure Developer Specification, Development, Maintenance of Business Intelligence projects. Microsoft SSIS/SSAS/SSRS Microsoft SQL Server 2012 R2/2014/ 2016 12 years Specification, Development, Maintenance of Microsoft Business Intelligence projects. PowerBI Microsoft 2 years Worked with Business Analyst to create PowerBI Reports based on Specifications from business. Microsoft BizTalk Server 2004/2006/2006R2/2009/- years Pre-project offers, Specification, Planning and Design, Development, Delivery, Maintenance. C# coding Language .Net Framework 1,1.1,2,3,3.5,4 14 years Development, Delivery, Maintenance. Microsoft SharePoint 2007/2010/2013 2 years Development, Maintenance. Dynamics AX 4.0,4.0 SP2,2009 1 år Development, Maintenance. VB 6,.net 1.5 years Development, Maintenance. Talend 7.2 2 years Used ETL tool to get data into datawarehouse. Certifications June 2024 DP-600 : Microsoft Certified: Fabric Analytics Engineer Associate from Microsoft July 2023 DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI. July 2022 DP-203: Azure Data Engineer Associate Certification. May 2010 MCTS: SQL Server 2008, Business Intelligence Development and Maintenance. May 2010 MCTS: Microsoft Office SharePoint Server 2010 - Application Development. Aug 2008 MCTS: Microsoft Dynamics AX Technology Specialist certification. Dec 2006 MCTS: BizTalk Server 2006. Link to MCP website of certification: https://learn.microsoft.com/en-us/users/nishiljain-1690/transcript/vmqpt3038emwzx7 Education: 2000 - 2004 Bachelor of Computer Engineering Mumbai University, India. 1998 - 2000 Pre-University College with Majors in Computers. Computers, Goklibai College, Mumbai, India 1986 - 1998 Schooling: Infant Jesus School, Mumbai, India