Sign in

SSRS report Developer

Plano, Texas, United States
November 28, 2018

Contact this candidate


Mayra Safouani

Preferred Method Contact

Phone Number: 469-***-****



Data Analyst/BI developer with 4 years of work experience in consulting and direct hire working under Scrum and Agile methodologies

Have good knowledge of data warehouse structure

Ability to import data from multiple file types and create quick insight on Power BI

Ability to create drilldown, drill through, slicers, bookmarks, images on Power BI Dashboard report

Responsible for the design and development of Dashboards and Cards using Power BI and SQL queries that pull data from multiple SQL Server database tables

Experience in using the Microsoft BI Stack (Management Studio, Integration Services, Reporting Services)

Generated reports in various formats like Table format and Matrix format using Reporting Services (SSRS) to display in a customized format as per business requirements

Experience in transforming unstructured data from various sources using SSIS transformations like Conditional Split, Merge Join, Sort, and Derived Column for cleaning bad data and validating data

Experience in migration of Data from various Data Sources such as Excel, Flat file, XML, to MS SQL Server by using SQL Server Integration Services.

Knowledge of creating Indexes to achieve better query performance and experienced in implementation of strong referential integrity.

Good knowledge on creating tabular reports, matrix reports and sub reports using local variables, expressions, and functions, sorting the data, defining data sources and subtotals for the reports using SSRS 2012. Use of business intelligence platforms for reporting such as SQL and SSRS.

Experienced in designing, developing and maintaining business intelligence solutions. Crafting and executing queries upon request for data and presenting information through reports and visualizations.

Experienced working in Agile Methodology and a great team player.


University of Texas at Arlington B.S. Management Information Systems, 2014

Mountain View College Associate in Science, Liberal Sciences, 2012


DBMS/RDBMS: MS-SQL Server 2016/2012

Reporting Tools: Power BI, SQL Server Reporting Services (SSRS)

ETL: SQL Server Integration Services (SSIS), T-SQL Stored Procedures

Languages: T-SQL, basic knowledge of HTML5

Data Modeling: Microsoft Visual Studio 2015, 2013, SSAS

Office Tools: MS Word, PowerPoint, OneNote, Office 365 System

Domain Expertise: Hospitality, Mortgage, Auto Repair


Micropac, Richardson, TX (consultant). March 2017-Current

Business Intelligence Developer


Worked with users and business analysts to design and develop all reporting layouts, report interactions and report features

Responsible for defining, designing, and leading implementation of Power BI interactive report visualizations, dashboards using drill down, drill through, filters and charts, quick insights, slicers, Bookmarks and images

Import data and reports from Excel, CSV, and Power BI files

Create, view, and share interactive dashboards and reports with other Power BI users

Create technical design documents that capture data modeling, report data mapping, calculations, and filters

Involved in planning, defining, and designing database based on the business requirements document

Troubleshoot and create multiple calculations using DAX

Create SSIS packages to extract the data from multiple sources like Excel, XML and OLTP and consolidate them into staging tables.

Created a start schema design in data warehouse creation, which outlined measurable financial data in the fact table, along with detailed data in surrounding dimension tables

Maintain SSIS packages for production and test environment for incoming source application files

Used multiple SSIS transformations such as: Data Conversion, Derived Column, Conditional Split to cleanse and validate data

Worked on SSIS performance tuning using: Row Counters, Error Handling, and re-running of failed SSIS packages using checkpoints

Responsible for developing and maintaining performance tuning and validation scripts in SQL

Validate, extract, transform and load data to data mart databases, and process SSAS cubes to store data to OLAP databases

Prospect Mortgage, Irving, TX August 2014 to Dec 2016

Data Analyst/ BI Developer


Interact with users extensively in gathering the requirements and analyzing the needs of end users

Design, developer, and deploy reports in MS SQL Server environment using SSRS

Understanding the various complex reporting requirements of the company and creating reports using Reporting Services

Develop dashboard reports using Reporting Services and Ad-hoc reporting using Report Builder

Create parameterized reports through the knowledge of reporting services architecture

Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, csv, flat file, text format data

Created Package Configurations, Event Handlers for On Error/Warning/Task Events.

Used various data flow transformations like Lookup, Derived Column, Row Count, Data Conversion, Conditional Split, Merge join, Sort, OLEDB command, Union all etc. to map the data from different data sources and to perform transformations according to the business requirements

Created packages using Script Task, Sequence Containers, ForEach Loop Containers to logically execute the SSIS package to improve performance and execution time.

Worked in debugging complex packages using Error handling methods like Break Point and Check points.

Extracted data using SSIS packages (ETL) from different server locations and data sources

Handled package migration from development server to production server using package configuration.

Contact this candidate