Now you can Instantly Chat with Vijay!
Having 7 + Year of Total IT Exp in Different ETL tools.
5 + Year of relevant exp in MSBI(SSIS/SSRS,SSAS)
2+ Year of exp in Azure Data Factory, ADLA,ADLS, Storage account,Logic App, AD Authentication
I am a Data Professional,...
Creating SSIS package to run the R models in ETL.
Embedded all the R models in SSIS package to execute and check the final table for scoring.
Creating reports in Power BI desktop version for POC.
Extracted data from various sources like Excel and Flat file from Client Servers and through FTPs.
Done POC in Azure Data Factory (Data Lake Ingestion) created report with Power BI.Show More Show Less
This is chain of hypermarket (Approx. 1500 Stores in US).
Creating SSIS Package for Retail Data ware house using oracle source and destination as well.
Designed approx. 10 Package for each Like StoreNo,Products,Items,category etc. .called all the ETL in Azure Data Factory and scheduled as well.
Loaded Data from SFTP/on Prim Data Through Azure Data factory to Azure SQl Database .
Created Pipelines and Load the data in Azure SQL Datawarehouse through Data Lake and ADF activities.
Monitored Full/Incremental Daily Loads and support all scheduled ETL jobs.Show More Show Less
§ This Project contains more than 50 reports and Dashboard, KPI’s. For the requirement we used SQL server 2012 with SSRS, SSIS, and SSAS.
Extract data from multiple sources like (SAP CRM), Excel, SQL, txt also.
I have created multiple dashboards for forecast revenue, sales Pipeline, Top 10 customer, leads, opportunity according to future ads and their value etc. where we can track customer recordsShow More Show Less