Mayra Safouani

Preferred Method Contact

Phone Number: 443-***-****

E-mail: ac7tn3@r.postjobfree.com

PROFESSIONAL SUMMARY

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

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

Ability to import data from multiple database tables and create quick insights in SSRS

Ability to create drill through, drilldown, and sub reports for dashboard reports

Responsible for the design and development of SQL queries that pull data from multiple SQL Server database tables

Generate 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.

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.

EDUCATION

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

Mountain View College Associate in Science, Liberal Sciences, 2012

TECHNICAL SKILLS

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

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

Domain Expertise: Hospitality, Mortgage, Auto Repair

PROFESSIONAL EXPERIENCE

Service King Auto Repair Services, Richardson, TX (consultant). March 2017-Current

Business Intelligence Developer

Responsibilities

Worked closely with all levels of business with varying levels of technical knowledge to gather accurate and actionable business and technical requirements

Created mock-ups showing the intended functionality and visual aspects of the dashboards to be developed.

Involved in designing, developing, testing, and publishing reports

Responsible for defining, designing, and leading implementation of interactive report visualizations using report-level filtering, visualization-level filtering, and drill-through functionalities

Created Matrix reports to make the data easily accessible to the users while using sub-reports

Responsible for troubleshooting and creating multiple calculations using T-SQL functions

Made trend lines, charts, and tables visually exciting, and aesthetically pleasing to maintain the accuracy of the core information content that is being communicated

Configured sharing interactive dashboards and reports with end users using scheduled report subscriptions

Prospect Mortgage, Irving, TX August 2014 to Dec 2016

Data Analyst/ BI Developer

Responsibilities

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

Designed, developed, and deployed reports in MS SQL Server environment using SSRS

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 configurations.

Contact this candidate