Resume

Sign in

BI DEVELOPER

Location:
Addison, Texas, United States
Posted:
June 14, 2018

Contact this candidate

SHIKO KIMANI KHWALE

Carrollton, Texas *****

Cell Phone: 469-***-****.E-mail ac5vq7@r.postjobfree.com

PROFESSIONAL SUMMARY

Microsoft SQL Business Intelligence Developer with 5 years of work experience in Database Design, Development, ETL implementation and support of OLTP and OLAP Databases at various phases of SDLC.

Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

A multi-skilled highly motivated professional with organized driven results and exceptional experience in International markets, warm, responsive leader and negotiator. Proven abilities in implementing and establishing cross functional efforts in identifying and designing solutions to meet and exceed client’s needs.

I am also passionate about technology.

SSIS

Experience in designing and developing various packages using control flow tasks and containers such as: For Each Loop, Sequence Container, Execute SQL Task, Script Task, File System Task and Data Flow Task.

Expertise using various SSIS dataflow Transformations such as conditional split, derived column, lookup, multicast, merge join, data conversion etc.

Designed and developed SSIS Packages to download data from variety of sources like XML, Excel and OLEDB.

Implemented failure alerts using Send Mail Task in SSIS.

Provided logging, error handling by using custom logging for SSIS Packages.

Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.

Deployed with SSIS configurations and scheduling with SQL agent.

SSRS

Proven ability and extensive experience in creating dashboards and reports.

Extensive experience in developing reports with drill down reports, drill through reports, parameterized reports and sub reports.

Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.

Excellent experience in performance tuning and optimization of SSRS Reports.

Implementation of security in SSRS report at item level and group level with SSRS roles.

End-to-end development experience from gathering requirements to deployment of SSRS reports.

SQL

Extensive experience in using T-SQL creating tables, stored procedures, views, indexes, triggers, user defined functions, database models and data Integrity in SQL Server 2016/ 2014/ 2012/ 2008 platforms.

Development and performance tuning of complex stored procedures, user defined functions and views for data migration.

Designed and developed databases with the best practices of data modeling and data normalization.

Extensive experience in performance optimization of SQL queries and stored procedures using execution plan, tuning advisor and profiling.

Created Clustered indexes to improve query performance and query optimization.

SSAS

Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.

Designed and developed data warehouse and business intelligence using multi-dimensional models - star schema.

Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modeling, Snow flake modeling for fact and Dimension tables.

Experience in creating dimensions within SSAS and within SSMS.

PROFESSIONAL SKILLS

DBMS/RDBMS: MS-SQL 2016,2014,2012,2008

ETL: SQL Server Integration Services(SSIS),SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS)

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL

BI Tools: SQL Server Management Studio (SSMS), Data Tools (previously BIDS)

Office Tools: MS Word, PowerPoint, Excel

EDUCATION, HONORS & CERTIFICATIONS

Microsoft Certified Business Intelligence Developer SQL Server 2012/2014

SQL/BI Developer Certificate

Life Insurance & General Lines Certified In: Texas, Maryland, Pennsylvania, Virginia, Massachusetts, New Jersey

Nairobi Institute of Business Studies–Associates Degree in Business Management

College of Insurance–Diploma in Insurance

Member of a Toastmasters group in the capital city of Kenya- Nairobi

PROFESSIONAL EXPERIENCE

Dec 2015 to Present

SQL SERVER SSIS/SSRS/SSAS ETL Developer

Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy and dimensional modeling, backup and recovery.

Followed Agile Methodology to keep track of projects and maintaining schedule by conducting daily scrums and bi-weekly sprints.

Good working knowledge in maintaining T-SQL Stored Procedures, User Defined Functions, triggers and Data Models according to the business requirements.

Implemented complex SQL queries using joins and sub queries.

Created packages using Integration Services (SSIS) for extracting data from Flat Files, Excel files, OLEDB to SQL Server.

Responsible for loading the data using SSIS packages to fact and dimensional tables

Use SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, Data Mart databases.

Optimize Stored Procedures and long running queries using indexing strategies and query-optimization techniques.

Created SSIS packages to capture the incremental changes for the data warehouse.

Created dashboard reports with drill down reports, drill through reports, parameterized reports, table reports, chart reports, matrix and sub reports .

Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.

Deployed and configured the reports in the Report Server.

Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.

Designed and developed data warehouse and business intelligence using multi-dimensional models - star schema.

British American Insurance

Apr 2013-Aug 2015

SQL Server Business Intelligence Junior Developer

Actively participated in gathering of user requirement and system specification.

Collaborated with multiple teams under agile methodology for implementing application needs.

Established joins and created indexes whenever necessary based on requirements.

Created log files to troubleshoot package failure errors.

Responsible for maintaining and scheduling packages.

Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.

Created SSIS packages to load customer information from flat files.

Worked with a combination of multiple dataflow transformations to build packages in SSIS.

Troubleshooting of processes, issues and errors in SSIS packages to improve their performance.

Worked with other team members to document systems and process environments.



Contact this candidate