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.

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.

§ 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 records

· This project Contains 9 KPIS and 20 Dashboards this is supply chain management project which defines cost of newsprint, Consumption and material cost.