Eliud Njubi

adhzek@r.postjobfree.com

817-***-****

**** ******* **** *****

Fort Worth Texas 76179

PROFESSIONAL SUMMARY

Experienced ETL Developer with deep technical and functional knowledge of MS SQL 2017, SSAS, SSRS, SSIS, DW, MS Office.

Experience in IT as SQL Server Developer and strong work experience in Business Intelligence tools which include SQL, SSAS, SSRS, SSIS, and DW.

Demonstrate professionalism, attention to details, collaborative nature, and a quick learner. Strong communicator exhibited by working closely with users to identify and resolve problems. In addition to working well individually, an effective team player.

A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills. Additionally, I have Ability to work deadlines, Results oriented, Flexible, and Adaptable.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions. Experience in Normalization and De-normalization, Performance Tuning and Optimization of queries and stored procedures. Proficient in using SQL Profiler, Execution Plan and Performance Monitor. Data migration between homogenous and heterogeneous systems.

Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS 2019/2015) in SSIS 2019/2015. Experience in migration of Data from various Data Sources such as Excel, Flat file, XML and SQL to MS SQL Server by using SQL Server Integration Services (SSIS) using various transformations.

Experience in providing Logging, Error Handling, and using Event Handler for SSIS Packages, creating, and maintaining Data Warehouses and implementing Slowly Changing Dimensions, building Cubes.

Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports in SSRS 2019/2015. Proficiency in creating appealing SSRS Dashboards. Developing Custom Reports and different types of Tabular Reports, Matrix Reports, Drilldown / Drill through Reports, and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). EDUCATION & CERTIFICATION

Associates Dodge City Community Collage

Bachelor of Science at Texas Christian University

Data Analytics

Certificate in SQL BI/EDW - Colaberry School of Data Analytics (TX, United States) TECHNICAL SKILLS

Operating Systems Windows Server 2016/2012/2008, Windows 7/8/10 Database Tools SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer BI Tools SQL Server, Visual Studio 2019/2017/2015

Languages T-SQL, XML, HTML, JSON, C#

OLAP Tools SSAS, SSRS

ETL Tools SQL Server Integration Services (SSIS), SQL Server Import/Export Wizard, Azure Report Tools SQL Server Reporting Services (SSRS)

Data Modeling SQL Server Analysis Services (SSAS)

Job Scheduler SQL Server Agent

Office Tools MS Word, PowerPoint, MS Excel

Methodologies Inmon, Agile

PROFESSIONAL EXPERIENCE

Colaberry Inc. (Texas)

November 2019-Present

SQL Server SSIS ETL Developer

Instrumental in gathering, analyzing, and designing business requirements and tools. Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications

Developed complex SSIS packages to bring data from existing sources such as OLTP databases, XML, Flat File, CSV and JSON sources and used various transformations and tasks like Sequence Containers, Script Task, For loop and For Each Loop Container, Execute SQL/Package, Send Mail, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, OLE DB source and destination, etc. to Staging, ODS and Data Warehouse databases using SQL merge and Slowly Changing Dimension (SCD).

Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema. Developed OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SSAS.

Created new database objects like stored procedures, functions, triggers, indexes, and views using T-SQL in development and Production, Altered and Updated the objects.

Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts, Data optimization, query optimization and job scheduling. ACCURATE HEALTHCARE (Fort Worth, TX)

August 2015 - November 2019

SQL Server ETL Developer

Created and modified stored procedures, user defined functions, scripts, and SSIS packages to extract, transform and load

(ETL) the data from several data sources to MS-SQL Server Data Warehouse. Responsible for enhancements, maintenance, and monitoring of the Data Warehouse on SQL Server and the daily ETL Process.

Analyzed source system data to determine the data model and ETL solution that will meet business requirements. Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations e.g. Conditional Split, Look Up, For Each Loop, Multi Cast, Data Conversion, Derived Column, Script Components, Aggregations, and Expressions.

Created complex scripts to massage, scrub, and cleanse legacy data in staging area. Created Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse. Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.

Created technical specifications, test plans and test data to support ETL processes. Extracted Data from various Heterogeneous Databases such as Access database, flat files to SQL server 2016 using SSIS. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible. Schedule the packages to keep extracting the data from OLTP at specific time intervals. Create/monitor scheduled data warehouse jobs using SQL Server Agent jobs. OTHER EXPERIENCE

Track and Field Professional athlete June 2003 - November 2008 College Athletics August 1998 – March 2003

12 Time National Champion in NJCAA and 4 Time All American in NCAA D I.

Head Track and Field Coach at All Saints Episcopal School Fort Worth.

Coach and Mentor to aspiring student athletes-one represented the US in the World Cross Country

Helped secure college scholarships to over 15 student athletes through Train Like A Kenyan running Club

Contact this candidate