SQL Devloper/DBA/Data Analyst Resume Example Market Footwear, Fred Lurie Associate Inc.

SQL DEVLOPER/DBA/DATA ANALYST

Profile

Has a Master's of Science Degree in Management Information Systems with Business Intelligence Concentration.
Has 5+ years of experience working as a SQL server Developer, SQL DBA, and Data Analyst with excellent analytical and problem-solving skills to work with minimal supervision.
Strong knowledge and experience of RDBMS like MS SQL Server 2008 R2/2012, MS Access, MySQL and T-SQL (queries, stored procedures).
Strong knowledge and experience in Business Intelligence –SSIS, SSRS, SSAS, Power BI ( Power Pivot, Power Query, Power View, Power Map and Pivot Table,).
Experience in Windows server 2008/2012 Active Directory Administration(Users and Computers, DNS, DHCP)
Experience with data analysis and visualization tools like Excel and Tableau

Core Qualifications

Technical Skills

Professional Experience

SQL Devloper/DBA/Data Analyst10/2012 to 04/2015Market Footwear, Fred Lurie Associate Inc.Miami, FL

Responsibilities:

Created ETL packages involving various data sources (SQL Server, Flat Files, Excel source files, etc) using MS SSIS
Developed data quality solution using SQL Server data services (DQS) as part of ETL
Analyzed data using using SSAS, Excel, Tableau and Power BI tools for decision making process
Built Self Service Business Intelligence dashboards using Power BI tools in Excel.
Wrote T-SQL queries for data Analysis and Reporting
Developed reports using MS SQL Server Reporting Services (SSRS) and Excel
Helped decision makers to understand data on reports and dashboards and gain insights.
Installed, administered and maintained MS SQL Server 2008/2012, including upgrades, security, configuration and service packs
Designed, implemented, and maintained SQL Server databases.
Designed and implemented tables, views, functions, stored procedures and triggers in SQL Server.
Planned and implemented SQL Server Security and database permissions
Performed Database Performance Analysis and Tuning using Database Engine Tuning Advisor, SQL Server Profiler and SQL Server Extended Events
Setup High-Availability as part Disaster Recovery Strategy for the SQL server 2012 databases (Failover Clustering, Database Mirroring, Log Shipping and Replication).

SQL Server developer/DBA08/2009 to 09/2012Cifra SystemsMiami, FL

Responsibilities:

As a mid-level DBA, Installed, configured, administered and secured SQL servers 2008/2008 R2.
Created and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions and Triggers.
Scheduled and automated maintenance plans using SQL Server Job Agent.
Scheduled and automated full/differential/transactional backups and implemented recovery strategies.
Configured and monitored database Mirroring, Replication and Log Shipping as HADR strategy.
Planned and implemented SQL Server Security and database permissions
Extensively used Joins and sub-queries for complex queries involving multiple tables.
Created indexes (clustered and non-clustered) to speed up query performance.
Designed Excel dashboard for tabular and chart reports with drill down functionality.

Web Designer/SQL DBA/Developer/Media Specialist03/2005 to 05/2009Miami Christians FellowshipMiami, FL

Designed desktop database application in MS Access using VBA
Developed financial report using MS Access and Excel
Created website for the organization utilizing HTML, WORDPRESS, CSS, PHP, MSSSQL and MYSQL
Performed regular website maintenance and update while also designing graphics for banners, flyers, and posters
Recorded and edited videos to be distributed in DVD , CD format and upload them to organization's website
Trained staff members how to utilize computers, use software to maintain website and other media support services

Web Developer and Database Support08/2003 to 01/2005Hotsilhouette, Inc.Miami, FL

Responsibilities:

Developed and maintained company's websites using Dreamweaver, HTML, CSS, ASP.NET, JavaScript.
Designed and managed back-end SQL Server databases for web applications.
Wrote complex T-SQL queries to manipulate data
Designed and edited graphics and photos for websites using Photoshop.
Installed, Configured and managed SQL Server and Access databases.
Analyzed sales data from different sources and created dashboards using MS Excel.
Provided technical computer support to end users.

Education

Master of Science: Management Information Systems2015Nova Southeastern UniversityFort Lauderdale, FL, USAConcentration: Business Intelligence

Associate of Science: Computer Programming and Analysis2003Miami Dade CollegeMiami, FL, USA

Bachelor of Science: Agriculture (Plant Science)1988Haremaya University Of AgricultureHaremaya, Harer, Ethiopia

Resume Overview

Companies Worked For:

School Attended

Job Titles Held:

Degrees

Master of Science : Management Information Systems 2015
Associate of Science : Computer Programming and Analysis 2003
Bachelor of Science : Agriculture (Plant Science) 1988