Data Engineer

Isaiah T Bankole

Phoenix, AZ ***** 602-***-**** **************@*****.***

QUALIFICATIONS SUMMARY:

Business Intelligence Developer with experience in data modelling, SQL programming, data analysis and reporting

Over 6 years database development, Data warehouse, Business intelligence and data analytics experience

Knowledge and experience in building data and business intelligence solutions at an enterprise level

Multiple years of experience developing and maintaining ETL solutions using S.S.I.S

Experience with process modelling, business analysis and data analytics

Experience with business reporting and analytics using PowerBI and Excel (Advanced)

Years of experience building and maintaining SSAS (Tabular) cubes and querying using DAX

Knowledge and experience in provisioning and implementing Azure services

Good leadership, organizational, oral/written communication, interpersonal, analytical, and problem-solving skills

TECHNICAL SKILLS:

Products: MS Dynamic CRM, Microsoft Azure, Azure SQL, Storage (Data Lake), Synapse (DW), Data Factory, Stream Analytics, and Cosmos DB

Development Technologies: NET Frameworks (C#), Azure, Java, Python, PowerShell

Databases: SQL Server 2014-2019, MS Access, Azure

Reporting Technologies: MS Power BI, Excel, SSAS (Tabular Cube)

Data Integration: SSIS, Kingswaysoft for CRM

WORK HISTORY:

Valore Partners – Tempe, AZ Jan 2020 – Present

Consultant Engineer (Azure Data Engineer)

Client: Black Board/Transact Campus

Architected, developed and maintained an enterprise data migration from NetSuite to SalesForce

Implemented dynamic automation using Dynamic SQL Constructs to create thousands of tables and views

Developed script in PowerShell to move data and files from on-premises to Azure storage

Developed PowerShell script to restore and backup hundreds of databases from and to azure storage

Developed customized Extract-Transform-Load (ETL) processes using S.S.I.S to refresh Dynamic CRM, SalesForce and the Data Warehouse

Designed and implemented data warehouse architecture using dimensional modelling techniques

Participated in all phases of the development lifecycle for a new subject area; gathered requirements, analyzed data quality and business rules, dimensional modeling and database architecture, developed Extract-Transform-Load (ETL) processes, and data presentation to the end-user.

Created complex/dynamic SQL script for data separation on an enterprise data platform

Gathered data into a SQL Server staging area using Kingswaysoft component for CRM, SQL Server and Excel

Utilized SQL Server (T-SQL) to condition and map the data appropriately for import into SalesForce

Shamrock Food Company- Phoenix, AZ Sept 2019 – Dec 2019

Business Intelligence Developer – Contractor

Built complex Power BI reports and dashboards to report sales KPI, invoice, purchasing for the organization

Built Power BI audit report and dashboard for row count monitoring purposes

Met with the business and stakeholder for requirement gather to build an enterprise level data dictionary

Built and maintained Power BI dataset and data flows to consolidate disparate data from multiple sources to support self service report authoring and seamless data insights

Developed and maintained customized Extract-Transform-Load (ETL) processes using S.S.I.S to refresh organization’s data marts and data warehouse

Participated in development of SSIS packages and testing before deployment to Production

Re-orchestrate existing SSIS packages and Store Procedures to bring in additional fields in the warehouse

Wrote complex measures using DAX to support reporting and analytics

As part of a team, refactored parts of the enterprise data warehouse for scalability and performance purposes

Refactored multiple slowly running queries to improve performance during processing and querying

Designed and implemented appropriate indexes on dimensions and facts tables for performance purposes

Hookes Consulting- Chandler, AZ

Snr. Business Intelligence Developer Jul 2018- Sept 2019

As part of a team, architected, developed and maintained an enterprise SSAS tabular cube for self-service reporting and analytics

Implemented dynamic processing technique using Dynamic SQL and JSON Constructs to drastically reduce amount of time it takes to process the Tabular cube

Developed functionalities like Row / Role level security, Perspectives, Translations and display folders in the cube

Optimized cube processing and querying by adjusting encoding options, modifying server settings like Memory limits and vertipaq memory limits as well as removing high cardinality columns and creating efficient partitions

Wrote DAX formulas to create complex measures in SSAS tabular cube for reporting and analytics purposes

Developed customized Extract-Transform-Load (ETL) processes using S.S.I.S to refresh tabular cube and the DW

Designed and implemented data warehouse architecture using dimensional modelling techniques

Participated in all phases of the development lifecycle for a new subject area; gathered requirements, analyzed data quality and business rules, dimensional modeling and database architecture, developed Extract-Transform-Load (ETL) processes, and data presentation to the end-user.

Hookes Consulting- Chandler, AZ

Business Intelligence Developer Jul 2015- Jun 2018

Performed data mapping, data validation and migration of data from a legacy system to Microsoft SQL Server

Created numerous simple to complex queries involving joins, CTE, cross and outer apply Pivot, correlated sub-queries, cursors and XML to accomplish various business requirements.

Extracted, transformed and aggregated data from multiple data sources into data marts using SSIS

As part of a team, performed logical and physical data modelling of the company’s transactional systems

As part of a team, developed coding standards for the database team;

As part of a team, created SSIS package templates with customized logging and error handling options.

Participated in database code reviews and database architectural designs with members of the team

Refactored multiple manual report generation processes by automating data retrieval, transformation and delivery using SSIS and Excel

Developed stored procedures, triggers, user defined functions and views to implement business logic in transactional databases.

Built multiple transformation procedures and views using functionalities like merge, windows functions, PIVOT/UNPIVOT and output keywords.

Performed query optimization of slowly running queries using indexing strategies and code re writes.

Performed monthly maintenance strategy, T-SQL optimization, disaster recovery planning, testing and custom software database configuration support.

Participated in database development standards and helped establish development protocols, and easing the maintenance of database code and objects

Performed data reconciliation between source systems and data warehouse using SQL queries and SSIS

As part of a team, implemented change data capture on transactional databases to capture changes in source data

Provided technical documentation on data lineage and data mapping between source systems and the data warehouse

R and D Mitchell Inc.

Data Analyst Feb 2014- June 2015

Built excel models to provide self-service analytics and reporting on organizations data

Acted as the Liaison between the technical team and the development team; gathered business requirements and translated into technical requirements for the team

Created advanced Excel formulas to extract pertinent data from worksheets and transform data (Data Cleansing) for reporting purposes.

Generated daily, weekly, and monthly excel reports (Pivot tables and Charts) used by departments for operational and tactical decision making

Liaised with the Business, Software Development Team and customers on the continuous improvement and development of the data reporting and analytics.

Developed processes to extract, transform and aggregate data from multiple data sources into a centralized Excel model for reporting purposes.

Worked with varying business units to identify key performance indicators and metrics required for reporting and analysis.

EDUCATION:

Arizona State University- Tempe, AZ Jan 2019- Present

B.S Computer Information Systems

Glendale Community College- Glendale, AZ Dec 2018

A.S. Business and Art

CERTIFICATIONS:

Microsoft Azure Data Engineer Associate Certification #:H489-5557

Exam DP-200: Implementing an Azure Data Solution

Exam DP-201: Designing an Azure Data Solution

Contact this candidate