Sql Server Data

Fikirte Saketa

SeaTac, WA *****

206-***-**** *************@*****.***

Summary

•2+ years of experience in T-SQL and relational database design and implementation in MS SQL Server.

•Working experience handling very large database from sourcing, modeling and transformations.

•Reporting Services ability to design and develop SSRS reports using MS Reporting Services.

•Experience in design, develop and deploy analysis model using SSAS and SSRS for data analysis and reports.

•Excellent exposure in creating database T-SQL scripts, stored procedures, triggers, views, tables, indexes, and constraints, user defined functions, security using SQL SERVER 2008/2012/2014.

•2+ years of experience in developing BI applications (reports, dashboards) using SSRS, MS Excel Power Pivot and Power BI, Power pivot and Tableau.

•Strong communication and organizational skills; proactive, good ability to work positively and effectively in a team and adapt new environments with great potential to learn effectively in a team environment.

Technical Background

Data Platforms

SQL Server

Reporting Tools

SSRS, Tableau, Power BI

Languages

SQL, C#

Analytics and Others

Data Modeling (ERwin), SSAS, PowerPivot, MS Office

Professional Experience

HAHU CONSULTING (09/2016-Present)

SQL report writer

Responsibilities:

•Write stored procedures, views and query script as part of data acquisitions and reports developments.

•Develop customers, resources and regional centric daily/weekly/Monthly reports.

•Develop data visualization dashboards trend analysis using Tableau and Power BI.

Developed various operational Drill-through and Drill-down reports using SSRS.

Configuring, tuning, and optimizing SQL Server 2014.

•Publish and monitored various reports - Excel, Power BI, SSRS, Tableau.

•Work on source data quality issues.

Environment: SSRS, Excel Power Pivot, Power BI, Windows Server 2012, Visual studio 2015, SQL Server 2014, Tableau

FIREFLY CAR RENTAL (09/2015 – 09/2016)

SQL report writer

Create and maintain daily and monthly report and present it to the manager

Identify and examine the data from the reports

Incorporate data from several databases into one report

Design and implement SSRS reports including static and prompted drillable reports.

Design and implement SSRS reports, including static and drillable reports for customers and partners.

Tune SQL queries as required to improve performance.

Analyze data and create views and composite indexes to return data quicker.

Technical documentation and reports generation for the application.

Environment: SQL server data tools, visual studio, SSRS, and SQL Server

UW MEDICINE, CARDIOLOGY (01/2014- 09/2015)

Laboratory Assistance

•Conducting statistical analyses on collected data and writing reports.

•Maintained the day to day functioning of the lab, including collecting and organizing samples, maintaining cultures and lab supplies as well as inventory and data entry.

•Attending seminars, presenting lab reports and define short and long term goals.

•Perform Cloning, PCR, Western Blotting, qPCR, qrPCR, Cell Culture.

•Isolating DNA/RNA from bacteria and different cells.

•Preparing growth media and petri dish with appropriate antibiotics to grow bacteria.

Education and Training

•Bellevue College, Bellevue, WA, June 2017, Certificate in Business Intelligence Analyst

•Microsoft Technology Associate 98-364: Database Fundamentals, Certificate

•University of Washington, Bothell, WA, March 2014, B.S in Biology

Contact this candidate