Summary
• Currently undertaking postgraduate research degree (PhD) in banking and finance Enterprise architecture.
• Presently working on Wenso Technologies (Part time)
• Over 2 years of business intelligence development experience in different sectors (Education, Hotels …etc.)
• Development and extension of MS SQL server analysis services 2005 (SSAS) cubes, deployment and processing of SSAS objects.
• Concreate practical hand on experience on Massive DATA BASES with SQL and MS BI services (SSIS, SSRS & SSAS)
• Excel Pivot-table/ VLOOKUP (Charts, formulas, sorting, filters etc) / charts and table data and schemas (Star flux and Snow flux)
• Experience in loading multiple comma delimited files, Text, Raw, Files to SQL Server Table in SSIS Package
• Redirected rows from flat file source for data conversion error and truncation error
• Proficient with data transformation services like SSIS, DTS, and BCP techniques.
• Created block report, stepped drill-down report, tabular Report by using page and details in group option by using report wizard to split single column into multiple columns in SSIS Package
• Delivered reporting solutions such as standardized reporting using Qlikview11 (SET ANALYSIS, INLINE, RESIDENT, PRECEDING)
• Gathered & loaded data into Qlikview from various data sources (SQL SERVER 2005, CSV and excel files).
• Microsoft Business Intelligence Stack, QlikView, Power BI, Excel PowerPivot.
• ETL (Structure, cleansing and Mapping) & Report Building Tools: SSRS, S