Marwan Samara Email & Phone Number

• Write/Create new or modify existing SQL code, Stored Procedures, Views, Indexes, and Tables.• Setup Snapshot Database Replication from the LIMS MS SQL Database to another MS SQL Database for data reporting and retrievals.• Learned and used MS Dynamics 365 Finance and Operations. Used it for data verification and reporting.• Developed simple Power Bi Reports, backed by complicated T-SQL Queries, for the Finance and Supply chain teams.• Set-up PowerAutomate/Flow Jobs to Automate data refresh.

• In the Global Data Warehouse Wrote Stored procedure using Dynamic SQL to identify invalid data in 18 systems/databases, data errors are emailed automatically using the "sp_send_dbmail" utility, the process is scheduled to run every morning and send the emails to the systems admins around the world.• Develop several new SSRS Reports using complex SQL statements to access the Global Data Warehouse data for the Finance department, to help and predict sales worldwide.• Automated several SSRS Reports which used to be done in Excel, and saved many hours of creating those reports manually, reports are exported to Excel and emailed directly to Xerium Sales Managers and directors around the world. • Develop, maintain and support DTS/SQL Scripts which extracts and load/(ETL) data from different sources such as Excel, Flat Files, BI, Oracle, and MS SQL Server tables with SQL Server Integration Services.• Create new tables, views columns, SQL Query debugging, and indexes.

Durham, North Carolina, Us

• Installed MS SQL Server 2008, 2012, and 2016 on the Development Server.• Installation of DSST (SQL Server Data Tools in Visual Studio 2015), which includes SSIS, and SSRS on the Development Server.• Installation of TOAD 6.6 Freeware, and connected to the Development Server.• Setup Backup & Recovery, tested the Simple and Full Backup, and Restore on the Development Server.• Create new or modify existing SQL code, Stored Procedures, Functions, Triggers, Views, Indexes, Tables.• Troubleshoot and resolve problems, designs and develops MS SQL complex SQL queries, Maintains and troubleshoots an SQL Server production environment.• For each Assessment: Complete a database Request form for initial setup of database, create new tables, Indexes, Stored Procedures, Triggers, Roles, and User Access. Tables are populated with data from several sources such as (Excel, Access, SQL Server Tables) using DTS, SSIS, and SSMS Database Tasks Import/Export from and to Database and none database objects.• Automated the process of creating the tables that the customer requests using the list of columns the customer provides in an Excel Spread Sheet by using Dynamic SQL Code.• Working on several projects for the Canadian Agency Education Quality and Accountability Office (EQAO) to measure student’s achievements in all subjects.• Import Answer Documents data such as Multiple Choice Questions answers, Student Questionnaires, and Teachers questionnaires from the Scanning Database into the project database, during the process we validate data is correct, and make sure the counts are also correct.• Create a Frequency Distribution Report for the questions answered and have data vs. the total number of questions, this report will help us identify any missing data, or invalid data.

Raleigh, North Carolina, Us

• Designs and develops MS SQL complex SQL queries, Maintains and troubleshoots an SQL Server production environment, creating tables, and other database objects.• Develop Applications to interface with SQL Server to implement process enhancements, automated report distribution and client reporting solutions.• Converted several processes that use Excel Sheets, complicated manual process, and data entry to an automated process that requires very minimal user intervention.• Gathers requirements from internal stakeholders to develop systems to improve efficiencies and disseminate data effectively.• Writes new reports.

Lewis Center, Ohio, Us

Bethesda, Md, Us

Overland Park, Kansas, Us

Bethesda, Md, Us

Global, Us