Home

JOHN NGETUNY - Business Intelligence Developer

[email protected]

Location: Arlington, Texas, USA

Relocation:

Visa:

JOHN NGETUNY Business Intelligence Developer (+1)4696322790 [email protected] Arlington Tx linkedin.com/in/john-ngetuny-5a823b156 Professional Profile A highly qualified Business Intelligence Developer/Data Engineer combining a passionate commitment to delivering service excellence with over five years experience in Information Technology. Possess extensive knowledge of implementing business intelligence applications, utilizing the most contemporary data analysis tools within multiple industries, including financial, insurance, and healthcare. Leverages outstanding communication, interpersonal, and negotiation skills to assist in the achievement of business goals and objectives. Meticulous and detail-oriented with proven ability to accomplish tasks under minimal supervision and quickly grasp new technologies and best practices. Core Competencies SQL | SSRS | SSIS | Alteryx Designer | Tableau | Power BI | Python |Azure |AWS |Tibco TDV|SNOWFLAKES Education Western Governors University,Data Analytics and Data Management Richland college, Data Engineering in Cloud Computing Professional Development/Qualifications Azure Fundamentals AZ-900 Certification by Microsoft Cloud Support Engineer-AWS Educate Cloud Support Associate- AWS Educate Cloud Computing 101- AWS Educate Microsoft SQL Server 2012 Certification Training Exam - UDEMY Microsoft SQL Server Reporting Services (SSRS) - UDEMY Power BI Dashboard in A Day -Adam Saxton Automation with Python North Lake College Agile Software Development - LinkedIn Introduction to Spark SQL and Data Frames - LinkedIn Microsoft Azure: Architecting Azure Infrastructure- LinkedIn Power BI Data Modeling with DAX- LinkedIn Using Python with Excel- LinkedIn Career Summary Data Engineer II Nov 2016 Present AmTrust Financial Services Dallas TX RESPONSIBILITIES Instrumental in gathering, analyzing, and designing business requirements and needs Creating new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production Creating various ad-hoc SQL queries for customer reports Designing and developing ETL workflows and datasets in Alteryx to be used in-reporting. Proficiency in creating various types of Parameterized Reports such as Crosstab, Drill-down, Drill-Through, Summary, Graph, Chart, and formatting those using SSRS Designed SSIS ETL packages to load data into the target database after performing data validation and error handling using execute SQL task, derived column, data conversion and conditional split transformations. Knowledge in creating Power BI Dashboards using maps, line charts, cards, ribbon charts, scatter plots and different reporting layouts from the Power BI Marketplace Using Dax and calculated columns for Power BI reports Implementing row level security on data and understand application security layer models in Power BI Business Intelligence Developer Jan 2014 Sept 2016 Electronic Commerce Inc RESPONSIBILITIES Created complex stored procedures used for generating reports in SQL Server Reporting Services (SSRS) Developed interactive dashboards using Tableau and SQL tools to provide on-demand reporting, powerful visualizations, and insights to business users Experienced in designing and developing Tableau Reports, Documents, and Dashboards as per specified requirements and timelines and presenting them in a variety of formats to users Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production Defined constraints, indexes, views, and triggers to enforce data and referential integrity based on architect requirements. Used Execution Plan, SQL Profiler, and database engine tuning advisor to optimize queries and enhance the performance of databases Strong experience in gathering and analysis of requirements Good knowledge in Performance tuning, SQL Tuning, Data optimization, query optimization, job scheduling Created/Updated database objects like tables, views, stored procedures, function References Available upon Request Keywords: business intelligence active directory Arizona Texas