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.