Muhammad Yaseen Email and Phone Number

Customers: DP World DubaiMS Dynamics CRM cloud, SQL Server, Microsoft Power automate, Microsoft Power Apps, Azure data bricks, Python, SSIS

Customer: Road & Transport Authority DubaiProject: Master Data ManagementTools & Technologies: Informatica BDM/PowerCenter, SQL Server, Oracle, Microsoft parallel data warehouse, Informatica data quality profiler

Tools & TechnologiesDescriptionPower BI, Informatica BDM/PowerCenter, SAP Hana FSDM, SSRS, SQL Server, Hadoop, Hive, Sybase, Oracle, Python, Ambari, Oozie, Hive, Informatica data quality profiler Responsibilities- ETL development using Informatica BDM and Informatica PowerCenter tools.- Data modelling- Power BI, SSRS used for dashboards development using live connection with SAP Hana and Sybase, HDFS Data Lake.

Project: IkeaTools & Technologies Azure data factory, Azure SSAS, Power BIAim of this project to develop Microsoft BI stack BI solution. Azure data factory pipelines developed to process and push data for analysis into Azure SSASProject: JumeirahTools & Technologies Qlik, SQL Server 2016 Integration ServicesAim of this project to develop analytics using Qlik using 2016 database. SSIS ETL jobs developed to process and push data for analysis into SQL Server.

ENOC – Basket Analysis & Cognos AnalyticsTools & Technologies: SSAS, SSRS, SQL Server 2012, Oracle, Dynamics AX 2012, SQL Server 2012 Integration Services, Power BIAim of this project to develop cube for basket analysis from Dynamics AX 2012 database. SSIS ETL jobs developed to process and push data for analysis into SQL Server. MS multi-dimensional cube developed to facilitate self-service BI.SSIS jobs developed to push data into Oracle for Cognos Analytics.

NMFG - DW and BI SolutionTools & TechnologiesDell Boomi Integration, SSAS, SSRS, Power BI, Net framework 4.0, C# , SQL Server 2012, SQL Server 2012 Integration Services, Visual Studio 2010, VBAAim of this project to develop data warehouse from several departmental store and restaurant chains. Different utilities developed in .Net to get data from different sources. SSIS ETL jobs developed to process and store data in data warehouse.Responsibilities- Extensively worked on development for SSIS jobs for data warehousing for Natural Market Fool Group- Developed dot net utilities to fetch data from different systems and convert into CSV file- Worked on Development of SSRS reports- Communication with onshore coordinator about requirement gathering, analyzing and implementing- Maintain and develop process in Dell Boomi for integration with several sources (NetSuite, Revel etc.)

Solix LIDA Files ProcessingTools & TechnologiesSQL Server 2012, SQL Server 2012 Integration Services, Visual Studio 2012, SSRSSolix SSIS LIDA files processing packages is solution based on MS SSIS packages. This system consist of various packages to process the provider’s LIDA files which they placed at FTP Location to process further.- Designed and developed SSIS jobs for data warehousing - Worked on Development of SSRS reports- Communication with onshore coordinator about requirement gathering, analyzing and implementing- Communication with onshore coordinator and client about requirement gathering, analyzing and implementing

Project: UNFI BI SolutionTools and technologies:BISM/Tabular Model, SHAREPOINT 2013, Teradata, C# , SQL Server 2012, SSIS, Visual Studio 2013, SSRS, PowerPivot Reports, Power View ReportsAim of this project to develop data warehouse based on BISM/Tabular model from Teradata. Custom timer job in SharePoint 2013 developed to send email to all recipients about stores, region, categories, brands and product performance. Reports developed using BISM model in SSRS, PowerPivot, and Power View and Performance Point dashboard in SharePoint 2013.

Project: VisiView BI SolutionTools and technologies:BISM/Tabular Model, SHAREPOINT 2013, SQL Server 2012, Visual Studio 2013, SSIS, SSRS, PowerPivot Reports, Power View ReportsAim of this project to develop data warehouse based on BISM/Tabular model for VisiView Product which is mainly serving banking sector. Reports developed using BISM model in SSRS, PowerPivot, and Power View and Performance Point dashboard in SharePoint 2013.BEKEY (Electronic key system)Tools & Technologies - .Net framework 4.0, C# , SQL2008, SiteCore CMS 6.5, Visual Studio 2010, WCF RESTFUL services, LINQSitecore Ecommerce Services integrationTools & Technologies - .Net framework 3.5, C# , SQL2008, SiteCore CMS 6.5, Visual Studio 2010- Helped in creating the architecture of this project- Communication with client about requirements gathering- Created item templates in Sitecore that will holds the structure of web shop, product categories, products- User third party tool to generate c# classes using XSD files to hold the date of xml elements as objects- Development agent to import web shops, categories and products etc. data in SiteCore CMS- Developed module of exceptions logging- Developed a scheduler that imports full/partial data through XML files into SiteCore CMS- Requirement gathering and documentationRe5 Electronic Business Diagnose Compliant System (EBDC)Tools & TechnologiesAsp .Net 2.0, Ajax Extension, C# 3.5 , SQL2005, Enterprise Library for Framework 3.0, FxCop, VB6, Visual Studio 2008A project (Electronic Business Diagnose Compliant System) for Doctors/Therapists who have invented a new way of treatment using PEMF Technology. Treatment is provided via a device set called applicator/stimulator that can read smart card having treatment details written on it. There was a version already in place but was almost of no use to the client. We gathered all the requirements, designed and developed the application from scratch.

Developed several projects in this organization as a team member and few as a team lead. Following are projects summary as below.Project: BEKEY (Electronic key system)Tools and technologies: .Net framework 4.0, C# , SQL2008, SiteCore CMS 6.5, Visual Studio 2010, RESTFUL servicesProject: Sitecore Ecommerce Services integrationThe engine/module is developed for Sitecore CMS that can import the data defined in the sent XML files into Sitecore. These xml files consists of data like sitecore roles, customers, product groups, product, shipping, shops, stock etc.Tools and technologies: .Net framework 3.5, C# , SQL2008, SiteCore CMS 6.5, Visual StudioProject: Ciklum Sale Corporate siteThis Project is developed in licensed CMS named BITRIX.Tools and technologies: PHP, Java Script, HTML, MYSQL, Zend Studio, BITRIXProject: Re5 Electronic Business Diagnose Compliant System (EBDC)A project (Electronic Business Diagnose Compliant System) for Doctors/Therapists who have invented a new way of treatment using PEMF Technology. Treatment is provided via a device set called applicator/stimulator that can read smart card having treatment details written on it.Tools and technologies: Asp .Net 2.0, Ajax Extensions 1.0, C# 3.5 , SQL2005, Enterprise Library for Framework 3.0, Resharper 4.0, FxCop, VB6, Visual Studio 2008Project: Deloitte Wealth Management SystemDeloitte is the world’s second largest auditing and professional services company.Tools and technologies: VB.NET, Microsoft Excel 2007, XML, Janus WinForms Controls Suite, Dundas Charts controlsProject: Resource Central - Translation UtilityResource Central is one of the products of Add-On Products for resource management, Partnering with Microsoft Outlook and the Exchange Server, Resource Central offers the opportunity to order all associated services for meetings schedulingTools and technologies: C#, HTML, MS SQL Server

I developed project having name "IOTTA". The aim of IOTTA is to be the foremost place for online teachers and tutors to gain worldwide accreditation in their respective areas of expertise, and in doing so, facilitate these tutors in becoming part of a global family of recognized education professionals. IOTTA is a pioneer in its field. As an independent association, it provides an international platform for all comers in the market, something previously unavailable. IOTTA aims to be the facilitating force behind hundreds and thousands of capable tutors becoming able to reap the fruit of their skills, experience and expertise by way of making their talents known to the world.

Project: DermTotalDermTotal software is a revolutionary way of automating practice management. Our primary goal is to develop a software solution for a dermatologist’s medical practice that would significantly increase efficiencies of the patient-doctor visit process. This solution, that encompasses ease-of-use, provides real-time accurate billing, will optimize doctor’s time spent with a patient during a regular diagnostic visit. Our solution further optimizes the entire patient visit process from the moment of consultation appointment is set till the end of visit with the doctor. Our research has discovered that most of the existing software solutions end up burdening a doctor with data entry chores. Our goal is to not only minimize data entry process for a doctor, to also enhance efficiencies at both, the front, and the back office. Hence we call our solution DermTotal.Tools and technologies: PHP, java script, HTML, MYSQL