Bilal Hussain

Client: Various clients from Healthcare Industry. Project: Healthcare Insurance System. Good hands on Azure Data Factory. Expert in T-SQL development to write complex queries by joining multiple tables, great ability to develop and maintain stored procedures, user defined functions. Experience in Performance Tuning and Query Optimization. Created ADF (Azure Data Factory) pipelines to load data on daily basis. Designed dynamic SSIS Packages by passing project/Package parameters to transfer data crossing different platforms, validate data during transferring, and archived data files. Deliverables: Designed dynamic SSIS packages so that same package can be used for more than one client just by passing the project parameters. Tuned and Optimized hundreds of existing SSIS packages in order to enhance their performance. Developed PowerBI Dashboard for Load monitoring team so that they can Monitor loads efficiently.

Client: One of the leading consulting Company in INDIA. Project: Travel System. Deliverables: Automated daily deliverables by using SSIS reducing the daily effort by 50%. Single handedly developed two main Dashboards with huge amount of data using Power BI, SSIS, SSAS and delivered it to the client on time and with high level of accuracy, who is using it to track its employees data on daily basis. Developed Online and Offline Reports using SAP BO, UDT, SSIS. Created ETL processes in Azure Data Factory to load data on Daily Basis.

Worked with a team of five members to identify the Business requirements and develop a Dashboard for them using SSIS, SSAS and Power BI so that they can keep track on their data on daily basis.