Software Engineer- Business Intelligence
Ministry of Defense And Aviation Saudi Arabia
Total years of experience :16 years, 3 Months
• 11+ Years of experience in IT, expertise in Power BI, MSBI, , SSIS, SSRS, SSAS, DW, Business Intelligence, Data Modeling, Data validation, Data quality, data integration and ETL Development.
• Hands-on experience and outstanding knowledge in building and deploying the reports by using SQL Server Reporting Services-SSRS and Power BI.
• Experience in report designing and creating various types of reports like Table, Matrix, Drill Down, Parameterized, Cascaded and Sub-Reports using SSRS and Power BI.
• Expertise in creating database objects such as Tables, Views, Stored Procedures and User Defined Functions to facilitate efficient Data Manipulation and Consistency.
• To document the business process by identifying the requirements.
• Good in identifying the requirements and also in finding the system requirements.
• Good knowledge and understanding of DAX Functions in Power BI.
• Good understanding in using Power BI Service.
• Merge and append queries in Power BI.
• Row level security in Desktop and Power BI Service.
• Knowledge on Gateway operations.
• Using Bookmarks, Sync Slicers, edit interactions in power BI.
• Create chart visualizations and interactive charts, creating Power View Slicers in Power BI.
• Transforming and add columns in Query Editor Window.
• Using tiles, Power View filters, text boxes, duplicate columns, creating custom columns and
• Additional date columns in Power BI.
B2BI Data Mapping
Working on Axway Composer to design mapping and transformation
Working on Axway Integrator to integrate different B2Bi Components
Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
Used Query Analyzer to optimize SQL Queries.
Generated reports from the cubes by connecting to Analysis server from SSRS.
Created Dimensions with the cube wizard and also individually.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
Designed and created Report templates, bar graphs and pie charts based on the financial data.
Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
Involved in ETL/Business Intelligence Testing
Testing of DB objects Procedure, Function
Testing Mapping/ Data validation in target table
Prepared Business Scenarios, Traceability Matrix and Test data.
Involved in System Testing and Regression testing.
Executing Test cases
Tracking Defects using Quality Center and Mantis
ETL Testing
Database Testing
Design ETL process
Involved in full life cycle of BI/DW projects
Enhanced the ETL framework for SSIS
Implemented an automated ETL solution to load a data warehouse and process a cube
Provided functionality improvement, designing of new dimensions, along with cube creation and maintenance of ad-hoc/canned reports for business critical reporting
End to end implementation of ETL process
Extract data from different data sources
Load data in destination tables
Master in Computer Application