Vaibhav Indani

Project Name : HR Data Lake and Reporting
Role: Data Architect and BI Engineer
Objective : The project objective involves constructing a global cloud-based HR data lake by consolidating information from diverse HR systems such as Workday, Dayforce, etc. This data encompasses employee census details, job requests, and candidate applications. The primary focus is to create a comprehensive data lay

IKEA D2i project is designed to build the core cloud-based data lake ingesting data feeds from numerous on-premises and API based sources which will cater
all the needs of the reporting solution using qlik. This project will help business to take key business decisions and keep the track of key KPIs through various
dashboard like sales dashboard, service dashboard and Loyalty dashboard.
Key Resp

Role - Technical Lead
Key Responsibility
➢ Data model design development for database, cube creation and power bi report development.
➢ Data pipeline development using SQL, SSIS, Azure data factory, Databricks ETL tools.
➢ Work on the tabular cube development with measures creation using DAX functions.
➢ Report development in Power BI with advanced visuals.
➢ Effort estimation, requirement scoping

Role - Data warehouse Specialist and Automation/ MSBI Developer
Key Responsibility
➢ Understand the upstream data model; accordingly design and develop Datawarehouse model as per the customer requirement.
➢ Develop optimize and scalable ETL packages with, process and load the data into Staging, Data Mart and Reporting databases.
➢ Develop the tabular cube and create required measures to calculate

-Client Management
-SME PM being a technical and functional right hand for business understanding
-Resolve exceptions and queries quickly and efficiently
-Investigate and suggest remedial methods to circumvent data discrepancies
-Provide expertise and assistance to the execution team on issues
-Develop SSIS and SQL Automated Solution
-Educate the business on developments and updates
-Collaborate w

-SQL queries for fetching the data from the client server for Data Analysis and accordingly generate Reports
-Generates various reports on weekly, bi-weekly and regular basis
-Handling business escalations related to data discrepancy and data accuracy.
-Modifying existing SSIS packages and monitoring performance of it

-Finding new and reliable Vendors for Chemicals/Raw Material/Packaging Material/Accessories Material Purchase
-Negotiation/follow up with vendors for payment terms, timely delivery of goods purchase.
-Represent company's executive at various stationary exhibitions and etc
-Responsible for purchase order and timely payment of vendors with vendors

Bachelor's degree in Electrical, Electronics and Communications Engineering from Government College of Engineering, Amravati.