Sql Server Computer Science

Z A I N A B A L S U B A I

** ******* *** ***, *********, MASSACHUSETTS 02420

(617) 309- 6325 maskkah@gma i l . com

S U M M A R Y

Experienced DBA with strong analytical and reporting skills. Wide range of expertise in operating systems environments. Highly ethical professional with demonstrated strengths in diplomacy and communication. Build positive relationships with internal clients. Proven ability to multi-task while meeting challenging deadlines. T E C H N O L O G Y

Systems: Windows, Apple OSX, Ubunto Linux, and Fedora Linux Computer Languages: Java, Scheme, C#, CSS, SQL, HTML, JavaScript, JQuery, and Perl Applications: AWS, iPhoto, iMovie, MS Office (Access, Excel, Word, PowerPoint, Paint, Outlook, Visio 2010), SharePoint, Microsoft SQL Server (08-08R2-12-14), SSRS, Microsoft Visual Studio (2008-2010), Photoshop, Mysql WorkBench, OBIEE, SQL Compare, UML, Hyperion, SalesForce, Paint, and ArcGIS Repository: Subversion

E X P E R I E N C E

CIMPRESS, Lexington, MA 2014 – 2015

Database Administrator

• Extracted Transformed and loaded HR Headcount data from Access 2010 to SQL Server 2014

• Prepared, oversaw and coordinated database and application designs

• Built stored procedures to perform a variety of maintenance checks on SQL Server objects using T-SQL, including:

Tables compression

Triggers on special events

Tables with No PK

Duplicates objects across databases on the same server

Back-up and restore across servers

Transform columns from non-Unicode to Unicode data type

Search for deprecated data type

• Managed the database portion of the release process, including SQL code review from numerous teams.

• Researched and presented findings for the DBA team about Amazon RDS for Aurora.

• Created presentation for the DBA team about SQL Server Resource Governor.

• Administered user permissions across development, testing, loading, and pre-production environments.

• Installed Microsoft SQL Server 2012 and 2014 on virtual machines for teams within the company.

• Investigated a variety of SQL jobs failures and reported results to team.

• Developed documentation about ongoing projects and input to the DBA team’s Wiki page. AIR-WORLDWIDE, Boston MA 2012 – 2014

Database Analyst \ Database Administrator

• Programmed C# tool to collect global wildfire data from NASA website to local server every 21 days.

• Wrote and automated script to copy files between two servers.

• Designed several plans to perform database and file system back-ups on three servers.

• Developed web reports measuring database activities using Microsoft Reporting Services (SSRS).

• Monitored the quality of the daily data stream entering the warehouse from staging to production and reported issues to supervisor.

• Provided MS SQL Server advanced training sessions to new employees.

• Implemented QA analysis for various catastrophic data and shared the result with appropriate teams.

• Designed Wiki website for the Data Management Group using SharePoint. ZAINAB ALSUBAI Page 2

• Provided technical support to the researcher using Microsoft SQL Server Management Studio.

• Managed users’ access control for six servers dedicated to different services locally and internationally.

• Created numerous data analyses for clients’ data used by researchers to improve their data modeling process.

• Acted as contact person and project lead on several claims analysis projects. ENDURANCE INTERNATIONAL GROUP, Burlington, MA 2012 Business Intelligence Intern

• Analyzed database design and developed test plans and test cases for quality assurance.

• Created proposed database schema to migrate data from Relational Database Schema to Star Schema Database to enhance understanding for various departments.

• Developed eight filtered reports for the company’s different departments using OBIEE reporting tool from the current row data, including Daily Cash Reports and Monthly Revenue Reports provided to the senior management.

• Monitored the quality of the daily data stream entering the warehouse from the production database and reported issues to supervisor.

• Oversaw the ongoing maintenance of the production and staging databases. LUX RESEARCH, INC., Boston, MA 2009

Marketing Technology Intern

• Organized and updated company’s media press list using SalesForce.

• Created a database for potential future clients in the bioscience industry to be used for marketing and sales purposes.

• Provided analytical support regarding current clients and research trend for the marketing team. COMPUTER HISTORY MUSEUM, Mountain View, CA 2007

Marketing Technology Intern

• Created a database to track and analyze media activities to be used for forecasting future attendance.

• Developed auditing tool using Survey Monkey, to gather audience input about museum.

• Analyzed results and provided recommendations to the marketing team. SIMMONS COLLEGE, Boston, MA 2006 – 2007

Research Assistant, Computer Science Department

• Wrote and received a $3000 grant for a 14-month research project to build a natural language transcript retrieval program for undergraduate students.

• Created computer program using JavaScript and Perl Programming languages and co-wrote the final report.

• Designed and presented the research project in a poster presentation at the 2006 Simmons College Undergraduate Conference.

E D U C A T I O N

M.S., Computer Science, NORTHEASTERN UNIVERSITY, Boston, MA (2012) M.A., Integrated Marketing Communication, EMERSON COLLEGE, Boston, MA (2008) B.S., Computer Science, SIMMONS COLLEGE, Boston, MA (2006) A W A R D S

Graduate Departmental Award, Simmons College, Spring (2008) Saudi Arabian Higher Education Scholarship (2005 – 2008) L A N G U A G E S

English, classical and modern Arabic.

Contact this candidate