Nishant Joshi
Module Lead - BI

Top Skills
★ Business Intelligence
★ Data Warehousing
★ Data Engineering
★ Azure Data Factory &
Microsoft Azure Ecosystem

Industry Knowledge
❖ Data Analytics &
Visualization
❖ Architecture - Data
Engineering, Integration &
Data Modeling
❖ Statistical Data Analysis
❖ Database Design &
Performance tuning
❖ Data Science
❖ Agile - Scrum

Career Objective & Summary:
● Result-driven professional with experience of 12+ years with
Business Intelligence, Data Warehousing, Data visualizations, Data
Engineering & Analytics in various business domains like healthcare,
market research, retailer, travel, and finance.
● Experience in Qlik development, including QlikView and Qlik Sense.
● Experience in both on-prem and cloud solutions, Extensive
Experience with Microsoft azure ecosystem such as: Power BI, DAX
Service, ADFv2 (Azure data Factory) ETL, Azure SQL Server, Azure
SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob, AKV
Management.
● Expert in querying in QVD, SQL and DAX languages
● Expertise in planning, executing, and spearheading various BI
projects within set time & quality norms; adept in end-to-end
implementation projects from requirement analysis to system study,
testing, troubleshooting and post-implementation support.
● MCSE in Microsoft BI, MCSA – SQL Server, MCTS & MCP
● Worked on modern data platform architecture which includes
unstructured & structured data.
● Working as Module lead which includes responsibility of BI
Technical Architect, setting team goals, deadlines, delegation of tasks
and creating an inspiring team environment.


Member & Certification:
● Microsoft® Certified Azure Data Engineer Associate (DP-203)
● MCSE in Data Management and Analytics, MCSA – SQL Server,
MCTS
● Leading Power BI User Group based at Vadodara location
● Experts-Exchange: Active expert and overall, Guru Rank.
● Certified Scrum Master


Tools & Technology
❖ Microsoft Azure - SQLDB,
Data Factory, Blob Storage,
Synapse Analytics
❖ Tableau & PowerBI
❖ Microsoft BI - SSIS, SSRS &
SSAS
❖ MDX & DAX
❖ QlikSense & Qlikview
❖ SQL, C# & Python ( lib -
Seaborn, Pandas, ploty)

Experience:
Webority Technologies / Module Lead - Business Intelligence
July 2019 – Present
Responsibilities:
• Developed Qlikview Load Scripts for distribution across
multiple data sources.
• Worked on cloud migration project for Qlikview to
QlikSense
• Worked on all the azure data factory pipeline with
different cases – truncate load, incremental load, upsert
load and automate them as per the business requirements.
• PowerBI – Self service implementation and developed 55+
PowerBI Report/Dashboards
• Worked on handling/automating failure of data pipelines
by using logic app and configure SQL logics.
• Optimization of all the tables and creating data models
based on business logic.
• Leveraged azure cloud resources – Azure data lake storage
Gen2, Azure Data Factory, Azure SQL DB, Devops to build
and operate centralized cross-functional data analytics
platform.

Major Project:
DW on-prem migration to cloud – Azure
Technology used:
Azure Cloud – Data factory, SQL DB, Data Lake, Blob
storage, Qlik, SSIS, Tableau & PowerBI, C#
Duration: 3.5 Years
Team Size: 6 (Agile – Scrum)
Project Description:
Platform and data warehouse migrations aren’t something
you do every day or even every few years, but they’re becoming
much more frequent as organizations seek to modernize their data
infrastructure with the new capabilities. I worked on this project
for UK’s largest travel and coach provider. During this project – I
worked on migrating data as well as all the related ETL processes.
This project is for migration as well as improvement for the
implementation of self-service capabilities. This was a long project
but working with the Agile way to deliver DW in the cloud helped
the business.


Allscripts India LLC / Expert Systems Analyst
Dec 2014 - July 2019, Vadodara
Responsibilities:
• Worked closely with business users to congregate and
comprehend requirements.
• Prepared of documentation for all the requirements and
enhancements to reports.
• Designed and developed SSIS packages, Store Procedures,
configuration files, tables, views, functions and to
implement best practices to maintain optimal performance.
• Successfully migrated the data between the
heterogeneous sources like Flat File, Excel Source, Oracle
and SQL server using SSIS.
• Built automated reports for business users using SSRS and
SharePoint subscriptions.
Excellence Infocom Pvt. Ltd / Database Developer
Mar 2013 - Oct 2014, Ahmedabad

Numerators - Apima Consulting Pvt. Ltd / SQL Server Developer
June 2011 - Mar 2013, Vadodara

Strength
❖ Perfectness
❖ Creativity
❖ Quick learner
❖ Punctuality
❖ Stability


Languages
❖ English
❖ Hindi
❖ Gujarati

Education:
Faculty of Technology and Engineering, M. S. University
Bachelor of Engineering in Computer Science
Year - 2011 Percentage - 52.3%, Vadodara
Krishna Higher Secondary School / HSC (12th)
March - 2007 - Percentage - 81.80%, Rajkot
Vidhya Vihar High School / SSC (10th)
March - 2005 - Percentage - 83.57%, Dwarka





I hereby declare that the above-mentioned information is true to the
best of my knowledge.