Sql Server Data
Resume:
Laban T Mutai
**********@*****.***
*** **** ****** ***** ****** Elm, TX
Summary:
Motivated BI developer with outstanding ability to organize and meet deadlines by prioritizing workload and maintaining levels of accuracy and quality to attain highest Quality Standards.
4+ years of IT experience ranging from SQL development, Data Integration in SSIS Data reporting in SSRS and Tableau, Requirements gathering, interpretation and presentation.
4 + years of experience in design, development, testing and documentation using SQL Server.
2 years of experience working with Tableau Desktop and Tableau Server.
Strong understanding of the principles of data warehousing, fact tables, dimension tables, star and snowflake schema modeling
Experienced in SQL Server Management Studio 2008/2012/2014/2016 and Visual Studio 2015.
Experienced with relational databases RDBMS.
Highly skilled and proficient in data manipulation with Microsoft Excel and Access.
Strong aptitude for learning and understanding business process and needs.
Sincere, Enthusiastic, hardworking with excellent communication skills.
Maintained positive communications and working relationships at all business levels.
Computer Skills:
Tableau Desktop, Tableau server.
MS SQL Server 2008/2012/2014/2016, Microsoft Visual Studio 2015 for SSIS, SSRS, SSAS.
Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, Outlook, SharePoint. Power BI
Databases RDBMS system.
Professional Experience
AmTrust Financial services Group. Dallas, TX February 2017- July 2017
Data analyst
Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
Created and revised Stored Procedure in Microsoft SQL server using T-SQL.
Tuned SQL Queries for maximum performance.
Extensively used Package Configurations and project level configurations while deploying the SSIS packages from DEV to Stage then Stage to Prod environments.
Extensively used C# in script component of SSIS.
Mainly loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
Experienced in creating Tablix Reports, Matrix Reports, Parameterized Reports, Cascaded Parameter reports and Sub Reports using SSRS.
Designed and Scheduled monthly and quarterly reports for Executives and Business analyst SSRS.
Created calculated fields, parameter and action filters for preparing dashboards and worksheets in Tableau.
Built and published customized interactive reports and dashboards using Tableau server.
Worked with business teams to understand dashboards to their business, analytical, and reporting needs.
Developed rich interactive visualizations integrating various reporting components from multiple data sources.
Colaberry Data Analytics Plano, TX November 2014- January 2017
BI Developer
Designed, developed and deployed Tableau dashboards on Tableau server.
Developed tableau workbooks and Dashboards from Multiple data sources using Data Blending
Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
Designed and implemented Parameterized, Cascading Parameterized and Drill through reports using SSRS.
Deployed and uploaded the SSRS reports to SharePoint Server for the end users.
Involved in OLAP Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SSAS
Implemented OLAP Cubes, Dimension and Facts for providing views of data and used MDX to query them using SSAS.
Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and.
Created database objects such as stored Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
Performed tuning of long running queries using Query execution plan
Partnered closely with cross-function peers and leaders to deliver reporting projects that solve business requirements.
BANK OF AMERICA. Plano, TX January 2013- October 2014
SQL Developer
Designed database, tables and view structure for application.
Developed complex T-SQL codes such as Stored procedures, functions, triggers and views.
Created triggers to keep track of changes to the fields of tables when changes are made.
Scheduled and maintain packages by daily, weekly and monthly using SQL server agent in SSMS.
Optimized Query performance and populated test data.
Chema Logistics LLC Euless, TX March 2011- May 2013
Dispatch Manager
Created monthly and quarterly business monitoring reports using Excel Pivot.
Scheduled drivers to pick up and deliver loads to customers or vendors.
Received, coordinated and processed orders of loads.
Communicate frequently with customers, carriers, drivers.
Tracked loads, drivers and their performances.
U of L hospital Louisville, KY May 2007- December 2010
Pharmacy technician
Helped pharmacist to prepare prescribed medication.
Received written prescriptions or requests for prescription refills from patients and process them.
Answered questions from patients
Education
Western Governors University. September 2016 – Current
-Bachelor of Science, Data Management/Data Analytics
University of Louisville, KY January 2008-December 2010
-Bachelor of Science in BioChem.
JCTC, Louisville, KY January 2006-December 2009
-Associate of Science in Information Technology
Training/Certification
-Microsoft Business Intelligence MCSE Certification
-Tableau Training and Certification - Tableau Desktop
-Tableau Server Training- Tableau Administration Training
-Data Warehousing Training with Erwin Tool
Contact this candidate