Business Intelligence Engineer
Emirates NBD Bank
Total des années d'expérience :16 years, 9 Mois
Working on dashboards in Power BI and using SAP Hana and Hadoop as data sources. Informatica tool is being used for data integration between different source systems and data warehouse.
- Power BI based dashboards developed using live connection with SAP Hana
- ETL development using Informatica tool
- SSRS reports development
- Migration of Cognos reports into SSRS reports
ENOC - Basket Analysis & Cognos Analytics
Organization Systems Ltd Client ENOC
Duration 6 Months Team Size 4
Designation/Role Senior Advisory Software Engineer Work Location Pakistan
Business Domain Data warehousing using business intelligence
Tools & Technologies SSAS, SSRS, SQL Server 2012, Oracle, Dynamics AX 2012, SQL Server 2012 Integration Services, Power BI
Description
Aim 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 Solution
Organization Systems Ltd Client NMFG
Duration 40 Months Team Size 5
Designation/Role Senior Advisory Software Engineer Work Location Pakistan
Business Domain Data warehousing using business intelligence
Tools & Technologies Dell Boomi Integration, SSAS, SSRS, Power BI, Net framework 4.0, C#, SQL Server 2012, SQL Server 2012 Integration Services, Visual Studio 2010, VBA
Description
Aim 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.
Solix LIDA Files Processing
Organization Systems Ltd Client Solix
Duration 3 Months Team Size 4
Designation/Role Advisory Software Engineer Work Location Pakistan
Business Domain Data warehousing using business intelligence
Tools & Technologies SQL Server 2012, SQL Server 2012 Integration Services, Visual Studio 2012, SSRS
Description
Solix 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.
UNFI BI Solution
Organization Systems Ltd Client UNFI
Duration 5 Months Team Size 4
Designation/Role Advisory Software Engineer Work Location Pakistan
Business Domain Data warehousing using business intelligence
Tools & Technologies BISM/Tabular Model, SHAREPOINT 2013, Teradata, C#, SQL Server 2012, SSIS, Visual Studio 2013, SSRS, PowerPivot Reports, Power View Reports
VisiView BI Solution
Organization Systems Ltd Client Visionet Systems
Duration 3 Months Team Size 4
Designation/Role Advisory Software Engineer Work Location Pakistan
Business Domain Data warehousing using business intelligence
Tools & Technologies BISM/Tabular Model, SHAREPOINT 2013, SQL Server 2012, Visual Studio 2013, SSIS, SSRS, PowerPivot Reports, Power View Reports
Phase One
Organization Ciklum Pakistan (Pvt.) Ltd. Client Phase One A/S
Duration 5 Months Team Size 5
Designation/Role Principal Software Engineer Work Location Pakistan
Business Domain Site mainly offering sale of imaging software
Tools & Technologies Site-Core CMS 6.2, 6.3, 4.3, XSLT, ASP.Net 3.5 (VS2008), VB.Net, C#, AJAX 1.0, SQL Server 2000, SQL Reporting Server 2005, SSRS, ASPOSE PDF
BEKEY (Electronic key system)
Organization Ciklum Pakistan (Pvt.) Ltd. Client BEKEY A/S
Duration 9 Months Team Size 5
Designation/Role Principal Software Engineer Work Location Pakistan
Business Domain Allocate and control authorizations to system users
Tools & Technologies .Net framework 4.0, C#, SQL2008, SiteCore CMS 6.5, Visual Studio 2010, WCF RESTFUL services, LINQ
Sitecore Ecommerce Services integration
Organization Ciklum Pakistan (Pvt.) Ltd. Client Kevin Steffer
Duration 4 Months Team Size 4
Designation/Role Associate Software Architect Work Location Pakistan
Business Domain Import products from xml to CMS
Tools & Technologies .Net framework 3.5, C#, SQL2008, SiteCore CMS 6.5, Visual Studio 2010
Project:
BEKEY (Electronic key system)
Tools & Technologies:
.Net framework 4.0, C#, SQL2008, SiteCore CMS 6.5, Visual Studio 2010, RESTFUL services
The BEKEY's key free system features a mobile phone with BEKEY software. The postman, the home career or the food deliverer opens the door with their mobile phone. It’s an electronic key system that makes actual keys superfluous. It sends an electronic key to cell phone. When you approach a door, the key on your cell phone lets you in.
Project:
Sitecore Ecommerce Services integration
Tools & Technologies:
.Net framework 3.5, C#, SQL2008, SiteCore CMS 6.5, Visual Sudio 2010
Project:
Re5 Electronic Business Diagnose Compliant System (EBDC)
Tools & Technologies:
Asp .Net 2.0, Ajax Extensions 1.0, C# 3.5, SQL2005, Enterprise Library for Framework 3.0, FxCop, VB6, Visual Studio 2008
Project:
Deloitte Wealth Management System
Tools & Technologies:
VB.NET, Microsoft Excel 2007, XML, Janus WinForms Controls Suite, Dundas Charts controls
Project:
Travel Engine - Holiday Autos importer
Tools & Technologies:
C#, HTML, MS SQL Server
Project:
Resource Central - Translation Utility
Tools & Technologies:
C#, HTML, MS SQL Server
Project:
AkzoNobel Extranet
Tools & Technology:
PHP, MySQL, Apache, Zend studio, Drupal
Project:
Ciklum Sale Corporate site (http://www.ciklum.com)
Tools & Technologies:
PHP, Java Script, HTML, MYSQL, Zend Studio, BITRIX CMS
Project:
Voices Heard
Tools & Technologies:
PHP, java scripting, HTML, MYSQL, Drupal, IIS, Zend Studio
Project:
System Standex (http://www.system-standex.com)
Tools & Technologies:
PHP, java scripting, HTML, MYSQL, Joomla, IIS, Zend Studio
Project:
IOTTA
Tools & Technologies:
PHP, java scripting, ajax, HTML, MYSQL, Zend Studio, Web services
Project:
DermTotal
Tools & Technologies:
PHP, java scripting, ajax, HTML, MYSQL
Secured 2nd position with 3.87 CGPA in M.Sc Computer Science by securing following GPA’s: 1st Semester 3.84 GPA 2nd Semester 3.78 GPA 3rd Semester 4.00 GPA 4th Semester 3.84 GPA
80% marks