Overview
Work History
Education
Skills
Languages
Timeline
Generic

Divine Okole

Richardson,TX

Overview

2026
2026
years of professional experience

Work History

BI DEVELOPER

CBRE Richardson
03.2021 - Current
  • MS SQL SERVER 2012/2014/2016./2017/2019, MY SQL, ORACLE, IBM COGNOS
  • VISUAL STUDIO 2015/2017/2019 (SSAS,SSIS,SSRS)
  • MICROSOFT POWER BI, EMBEDED ANALYTICS, PAGINATED REPORT, DATA FLOWS AND DATAMARTS
  • DATA MODELING
  • MICROSOFT AZURE SQL SERVER, AZURE DATA FACTORY/AZURE SYNAPSE ANALYTICS
  • Build pipe lines and data analysis in Palantir Foundry
  • ADVANCE EXCEL and MICROSOFT DYNAMICS 365
  • POWER APP, POWER AUTOMATE, POWER BI REPORT BUILDER
  • DEVOPS, SERVICENOW, HIVE, LIQUID PLANNER, JIRA, FOR DAILY SCRUM
  • Check in code using TFS, GITHUP (Source Control)
  • Use Tabular Editor and DAX Studio and analyzing and optimizing DAX queries
  • Expertise in SDLC (Software Development Life Cycle), Requirements Gathering, System Analysis, Coding (Design)
  • Testing, Go-Live (Implementation) and Post Go-live Support (Maintenance)
  • PROFICIENT IN OUTLOOK, TEAMS & SHARE POINTFOR PROJECT MANAGEMENT
  • Have ability to translate and transform business requirements in to deliverable and technical specifications
  • Hands on experience in Data Modeling
  • Good understanding of Agile Framework(SCRUM)
  • Create ETL (SSIS) packages from source to target, Consolidate data from JIRA, SharePoint and SQL SERVER, to the staging environment, transform the data following business rules and use the ETL Process and the SSIS TOOL to push the data to the Data Warehouse as Destination
  • Use SQL Commands (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes
  • Complex stored procedures, functions (UDF), and triggers, common table expressions (CTEs)
  • Update existing queries in JIRA and SSSMS, using DDL, Create Store Procedures, and Functions
  • Create views in SSMS and pull/Load the views in Power BI desktop transform the data in power query
  • Create a star schema Model, establish relationships, create calculated columns and complex advance DAX (Measures)
  • Calculations, and build Notification report using custom visuals and existing visuals, create book Marks and Page
  • Navigations
  • Create parameters and
  • Created role level security, create workspace
  • Configure Gateway, publish the report to Power BI Service, and give access to various stakeholders based on the company’s access rights and policy
  • Create pipeline to in power BI Workspace for DEV, Test and Prod
  • Enhance and improve performance of existing Power BI report using performance analyzer, Dax Studio and Tabular editor
  • Create vulnerability report using Power BI and set Dashboard alert to notify stakeholders on certain KRI’s
  • Implement Reverse Engineering strategies and process in data optimization, improving performance of existing reports and SQL scripts
  • Participate in Building Power Apps used for sales, Products and Employees etc
  • Highly experienced working with Azure DevOps for project management and CI/CD
  • ETL ON ADF (AZURE SYNAPSE)
  • Involve in building pipelines and migrate the data from different sources to destination in ADF (Azure Data Factory)
  • Migrate data from multiple sources to and consolidate the data in ADF, leveraging pipe lines and data flows and cloud
  • Data Warehouse in Azure Synapse
  • Create multiple data sets, Stored Procedures, CTE, dependencies of activities in Azure Data factory and I also created services on the source and the target servers in Azure synapse
  • Implement data transformation process in Azure Data Factory as per business requirement rules
  • Created automated work flows with triggers and develop unit testing documents
  • Scheduled Jobs in Flows and ADF Pipelines
  • Creating Pipelines with GUI in Azure Data Factory
  • Schedule Pipelines automated job and flows and monitor the pipeline
  • Debug the scripts and trouble shoot errors which occur at run time
  • Utilize Performance tuning of SQL queries and stored procedures using SQL Profiler and Indexing.

BI DEVELOPER

I-Ping Solutions
03.2019 - 01.2021
  • (SQL, SSIS, SSAS

Sr. POWER BI DEVELOPER

I-Ping Solutions
01.2018 - 02.2019
  • Created Power BI Reports and Executive Dashboards, Deployment of Power BI to Spotlight for end user access
  • Designed Charts with Lines, Bar Graphs and Columns to generate reports with Cumulative Totals
  • Utilized POWER BI DESKTOP to build/design dynamic reports and correlative dashboards and stories using data from
  • SQL server, Excel and CSV data sources, connecting to CUBES (SSAS)
  • Create relationship using Cardinality, and maintaining data integrity
  • Using Query Editor, Power Query for ETL process, Extract data, Transform the data implement Data types, remove columns, remove rows, remove duplicates, make first row header etc
  • Replace values, filter, fill down, use pivot and unpivot, split column, add column, group by Naming conventions etc
  • Using DAX to create Calculated columns and Measures
  • Used Aggregators and Iterators in calculations
  • Creating a measures table
  • Implement EVALUATION CONTEXT in Power BI, filter and row contexts
  • Using CALCULATE FUNCTION which is the most important Function in DAX to navigate Evaluation Context
  • Use TABLE FUNCTIONS such as FILTER, ALL and VALUES to create complex DAX Calculations
  • Create theme and custom visuals
  • Use Time intelligence to create calendar table, PY, same period last year, quarter, Month etc
  • Create visualizations showing Forecasting data per the business time period, Create Calendar table to envisage and leverage Time Intelligence, Create Custom Visuals like KPI to project business operations, behavior, present and future performance
  • Implemented DAX measures to effect dynamic calculations, worked on different types of icon on the ribbon that are available in Power bi query editor
  • Developed complex calculated measures using Advance DAX in power bi desktop to show good data analysis techniques
  • Designed Charts with Lines, Bar Graphs and Columns to generate reports with Cumulative Totals
  • Use ToolTip and bookmark to give vivid picture of data structure
  • Create Role level Security to limit access to user to view only to the data they are authorized to work with
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Published Power BI Reports in the required originations and made Power BI Dashboards available in test and production environments
  • Web clients and mobile apps
  • Explore data in a Variety of ways and across multiple visualizations using Power BI
  • Used Power BI Gateways to keep the dashboards and reports up to date
  • I’m engaged in POWER BI COMMUNITIES where development ideologies are shared, brainstormed and solutions arrived at
  • I also build ad-hoc Reports Analysis in Power BI, by replicating reports from Tableau, SSRS, Quick View and Excel
  • Use Tabular editor to create measures, table, create perspectives, bulk editing or modification of existing measures, and improve visual and query performance
  • Use DAX Studio to create, execute and analyze DAX queries, Query editing and execution, formula and measure editing, syntax formatting and tracing execution breakdown, improve visual and query performance.

ETL

- 01.2019
  • (SSIS)
  • Fully involved in the SDLC (Software Development life Cycle) Technical and Business decisions for Business requirement
  • Interaction with Business Analysts, Client team, and Development team, transform business requirements to deliverables
  • Gathered business requirements, definition and design of the data sources and data flows
  • Responsible for Data Modeling
  • Written Confidential SQL statements for retrieval of data and Involved in performance tuning of T-SQL
  • Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different
  • DBMS using SQL enterprise manager/SSMS on SQL server
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval
  • Create TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups
  • Recovery and SQL Server Agent profiler using SQL SERVER 2016/2017
  • Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data
  • Import/Export
  • Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS
  • ETL Concepts like Lookup Caches, Package Configurations and Variables
  • Hands on experience in Creating Stored Procedures, Functions, Indexes, Views and CTE
  • Experience in Extraction, Transformation, and Loading of data directly from different heterogeneous source systems like Flat File, CSV, XLS and Relational Database
  • Have good problem solving and analytical skills
  • Highly motivated professional
  • Creating Azure Data factories for loading the data to Azure SQL database from Cosmos platform
  • Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s
  • Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk
  • Loading Data(BCP), Indexed Views & Schema Binding, Clustered/Non-Clustered Indexes
  • Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS
  • Experience in working Confidential Azure cloud platform in components of ADF, ADL and Azure SQL & Data warehouse
  • SSAS Tabular Model
  • Collected business requirements from users and translated them as technical specs and design docs for development
  • Involve in the Software Development Life Cycle (SDC)
  • Extensively used T-SQL in constructing User Defined Functions (UDF), Views, Indexes, user profiles, relational database models, data dictionaries, and data integrity
  • Functions and Triggers for optimum performance
  • Create complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications using T-SQL in Development, QA and Production environment for SQL Server 2019
  • Involved in development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues
  • Designed Dimensional Modeling using SSAS
  • Created shared dimension tables, measures, hierarchies in Dimensional Modeling, Role Levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS)
  • Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, Roles, Created Hierarchies in SSAS
  • Create views (SQL Script) in SSMS (SQL Server Management Studio)
  • Import Data (View) through direct query in to the Analysis service tabular Model
  • Designed aggregations and pre-calculations, create Measures using DAX & M-Language
  • Create Perspectives, Relationships, KPI, Forecasting
  • Analyze the data in Excel to measure accuracy and concurrency of data (To provide a quick and easy way to test the efficacy of the model design prior to deployment.)
  • Build, Process and deploy the cube to the respective server (database)
  • POWER BI
  • Using Power BI desktop and get data through Live Connect from the Cube
  • Create report in relation to business requirements
  • Created Calculated Columns and Complex Measures in Power BI and Excel depending on the requirement using DAX queries
  • Applying Sync Slicers and control the visibility across multiple pages, equally create Bookmarks and Tooltip on visualizations, pages and reports
  • Developed custom visual reports, dashboards and KPI scorecards using Power BI desktop
  • Implementing and applying KPI, forecast in reports to reflect the business trend in the subsequent period
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests
  • Responsible for building reports in Power BI from the Scratch
  • Implementing Role Level Security on data, Reports and Dash Boards and give access to Decision making team and end users as instructed by the business or organization
  • Used Power shell commands to download PBIX files which were created online in service
  • Expertise in using advanced level calculations on the data set and have a good understanding of application security layer models in Power BI
  • Create, execute, and analyze DAX queries, in DAX Studio formatting, integrated tracing and query execution breakdowns and increase performance in the visual level and SQL
  • Resolved data gateway issues like reconfiguration, create new data sources in existing gateway cluster by providing windows credentials, file path or server name by going to manage gateway then add these data sources to the gateway in schedule refresh window
  • Published Power BI Reports in the required originations and made Power BI Dashboards available in Development, QA and Production environments
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements, additionally
  • I create Ad-Hoc reports from EXCEL, TABLEAU, and SSRS in to POWER BI., Working knowledge of Data Modelling, Data Mapping, Table Normalization, Optimization and Performance Tuning
  • Advance knowledge in writing T-SQL queries with DDL and DML commands, Variables, complex stored procedures
  • Functions, indexes, triggers and views
  • Create CTE’s, Sub queries, and Derived Tables, by converting business requirements to deliverables
  • Hands on experience in Creating Stored Procedures, Functions, Indexes, Views and CTE
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data
  • Resolved issues with redundant and duplicated values
  • SSAS/ ROLE:
  • Using Microsoft Analysis Service (SSAS)
  • I created a views using data from multiple objects in the Database as per the business requirements
  • Pulled the view in SSAS Tabular Model, created relationships, (DAX) calculated columns, measures KPI (Key Performance
  • Indicator), for forecasting purposes
  • I equally created Hierarchies
  • Created Perspectives, and Partitions and Roles Level security
  • Built and Process the cube then deploy the cube the company server
  • Converted complex Microsoft Excel Reports to SSRS Reports.

BI DEVELOPER

I-Ping Solutions
07.2017 - 12.2017
  • POWER BI:
  • Work closely with financial management team, Business Intelligence Group to improve the efficiency, analysis and enhance their Power Bi existing report
  • Assist the Data Services Team in building Analysis Services reporting models
  • Created Database objects – tables, views, indexes and developed procedures for implementing application functionality at the database side for performance improvement
  • Create Views and building matrixes and reports in power BI
  • Involve in ETL development life cycle process in getting data from SQL Server Databases, Oracle data bases and Excel
  • Uses SQL Server Analysis Services to enhance existing, or develop new, OLAP cubes used in the EDW system
  • Optimized and developed interactive analysis reports and dashboards for pre-sales analytics
  • Building ad-hoc report from excel, SSRS & TABLEAU to Power BI
  • Imported data from SQL Server DB using Direct Query to Power BI to generate reports
  • Use various types of visualizations such as bar charts, pie chart maps, matrixes, tables, gauges, ribbon charts, donuts, treemaps etc
  • Implemented DAX measures to effect dynamic calculations
  • Worked on different types of transformations that are available in Power bi query editor
  • Developed complex calculated measures using DAX in power bi desktop to show good data analysis techniques
  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop
  • Schedule Power BI automate system
  • Implement row level security on various departments as required by the business
  • Integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
  • TSQL/Design, Development:
  • Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views
  • Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2008 R2012/2014/2016/2017

POWER BI DEVELOPER, BI

I-Ping Solutions
11.2016 - 05.2017
  • Translate system requirements into the design and development of Customized systems in an angle environment
  • Ability to integrate Power BI reports in to other applications using embedded analytics Power BI Service or API automation and expertise in creating Custom visuals in Power BI
  • Provide expertise in analysing requirement gathering, design, coordination customization, testing, and enhance existing and new Power BI reports in client’s environment
  • Implement Reverse engineering abilities and concepts in tracing the root course of business analysis bottleneck issues and solving difficult problems faced by company
  • Created temp tables and views and User Defined Functions(UDF) from different severs, Extensive experience connecting to various/ data sources, import and transform the data thus I perform ETL process in power Query editor in Power BI desktop
  • Build relationships by maintaining Primary key and foreign Key relationships, create fact and dimension tables in the model view in POWER BI
  • Create Calculated Columns, Measures (Advance DAX Calculations) and matrices using DAX language and KPI, guided by business requirements
  • Set best practices in implementing row level security for each departments as per business requirements
  • Create reports and dash boards evolutionary maintenance of the Power BI
  • Create Power BI reports and correlated Dashboards utilized by top company executive members and front end users
  • Configure and implement enterprise Gateway for Power BI automation
  • Publish Power BI report to enable end users access, by enabling role level security
  • Utilize TFS (DevOps) for source control and agile boards.

BI CONSULTANT

I-Ping Solutions
04.2015 - 10.2016
  • ETL Development (SSIS):
  • Experienced in developing, deploying and monitoring ETL tasks using SQL Server Integration Services (SSIS) packages
  • Followed the Microsoft recommended best strategies in the design, development, and implementation and testing of the ETL using SSIS
  • Migrated organization orders, adjustments, objectives and data in various formats like csv, excel, txt, xml and JSON
  • BI & Reporting (SSAS, SSRS, POWER BI, SQL)
  • Create T-SQL queries with DDL and DML commands, complex stored procedures, indexes, triggers and views
  • Designed clients Reporting framework and Work streams
  • Designed views and stored procedures to be used by the reports
  • Designed views and user defined functions to be used by the reports
  • Built and modified SSAS cubes (Tabular Model)
  • Created Power BI Reports and Executive Dashboards used end users
  • Enterprise Gateway implementation for Power BI automation
  • Deployment of Power BI to Spotlight for end user access
  • Converted complex Microsoft Excel Reports to SSRS Reports
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drill through, Ad-hoc and
  • Sub-Reports using Report Designer and Report Builder based on the business requirements.

SQL Developer/ETL Developer

ARNOLD OIL COMPANY
01.2013 - 02.2015
  • Arnold Oil Company is the leading supplier of automotive products, shop equipment, lubricants, fuels, and outdoor power equipment
  • Since 1939, our goal has been to create and cultivate customer relationships for years to come
  • Arnold Oil Company was built on the foundation of family
  • We continuously strive to build our relationships with vendors, customers, and employees on that premise
  • We differentiate ourselves from the competition by the ongoing training of our staff, our dedication and commitment to customers, advancements in technology, and service to our community
  • Responsibilities
  • Use FTP task to pull company Data/Files from different Locations, Pull data from multiple sources such as Flat Files(CSV, or Text Files), EXCEL files, Various Databases, XML files, etc
  • Worked with different Control flow such as , For Each Loop containers, sequence container, File System Task, Execute
  • SQL task and Script Tasks using C# language, VB.NET to CHECK if file exists in a particular location before running the entire package to minimize system resource etc
  • Worked with various Dataflow transformations tools like Derived Column, Conditional Split, File System Task, Look-up transformation, Fuzzy lookup, Multi Cast, Merge Join, Audit, Lookup, Union All, Merge, Aggregate, Union All, OLEDB
  • Command, data conversion and Conditional Split by eliminate redundant and inconsistent data by using SSIS while designing SSIS Parallel Packages
  • Use different transformation tools in the Data flow to cleanse data, to remove unnecessary columns, and transformations ()
  • Simulate a fake destination or trouble shooting if file exists and it’s pulling from the source using Multi Cast and can be viewed using a Data Viewer
  • Create complex stored procedures (reflecting business logic) in SQL server Management studio 2014/2016/2017 and call the stored Procedures in SSIS Using Execute SQL Task at run time, as per business scenario/ requirement
  • Involved in maintaining Data consistency and referential Integrity with various constraints like unique key Constraints
  • Check Constraints, Primary Key Constraints, Alternate Keys, Foreign Key Constraints, Candidate Keys, Surrogate Keys
  • Composite and Default in Data Warehouse
  • Developed custom scripts, views and stored procedures for data import and manipulation in TSQL
  • Troubleshoots failed packages and provide immediate solution involved in database architecture designing to store historical data used for reporting
  • Automate SSIS Packages using SQL Job agent and configured notifications and alert in the event of package failure
  • Implement Type 1(SCD1) ,Type 2 (SCD2) and Type 3(SCD3) dimensions in Data Warehouse making sure referential integrity is maintained
  • Create Star Schemas and Snow Flake Schemas use reverse engineering Strategy to implement Normalization (1ST, 2ND
  • AND 3RD Normal Forms) and Denormalization process to enhance and buttress Database Performance and Create
  • Source to Target Mapping Documents (Thus mapping the Source OLTP Data to Target OLAP (Data Warehouse) Data
  • Send email (Send Email Task) when a there is a failure or success, , use event handler to create Login on error, on Post
  • Execute and on Pre Execute, create jobs, Automate Systems to run as per the Business set up time
  • Deploy SSIS Packages and projects to appropriate server, across multiple development environments/ located on different servers in Dev, UAT and Production Environments
  • Worked concurrently on various environments such as DEV, UAT and PROC
  • Create Unit Testing Documents for referential purposes
  • Created and developed database objects such as tables, indexes, views, stored procedures, user defined Functions (UDFs), CTEs, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2014
  • Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management
  • Studio
  • Utilized Tableau to design dynamic dashboards and stories using data from SQL server, Excel and CSV data sources
  • Deployed SSIS Packages across multiple development environments located on different servers
  • Created new SSIS Packages using SSDT 2012
  • Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default
  • Developed custom scripts, views and stored procedures for data import and manipulation in TSQL
  • Troubleshoots failed packages and provide immediate solution involved in database architecture designing to store historical data used for reporting
  • Designed a variety of SSRS Reports such as Parameterized, Drilldown, Drill Through, Ad-hoc and Sub-reports using
  • Report Designer and Report Builder based on the business requirements
  • Environment: MS SQL Server2012/2014/2016, Tableau, Power BI, SSRS, SSAS, Microsoft Excel.

Education

Bachelor of Arts - ACCOUNTING

University of Buea
BUEA, SWR CAMEROON
12-2008

Skills

  • ETL development
  • Machine learning
  • Report design
  • SQL programming
  • Data quality management
  • Business intelligence tools
  • Data security
  • Data warehousing
  • Performance tuning
  • Data modeling
  • Data integration
  • BI strategy development
  • Dashboard creation
  • Problem-solving abilities
  • Multitasking Abilities
  • Effective communication
  • Adaptability and flexibility
  • Creative problem solving
  • Decision-making
  • Relationship building
  • Analytical thinking
  • Customer relationship management
  • Interpersonal communication
  • Written communication
  • Data analysis
  • JIRA
  • Agile methodologies
  • Testing and debugging
  • Source and version control: git, github
  • Python and C
  • Agile development methodologies
  • Database management
  • Technical analysis

Languages

English
Native or Bilingual
French
Native or Bilingual

Timeline

BI DEVELOPER

CBRE Richardson
03.2021 - Current

BI DEVELOPER

I-Ping Solutions
03.2019 - 01.2021

Sr. POWER BI DEVELOPER

I-Ping Solutions
01.2018 - 02.2019

BI DEVELOPER

I-Ping Solutions
07.2017 - 12.2017

POWER BI DEVELOPER, BI

I-Ping Solutions
11.2016 - 05.2017

BI CONSULTANT

I-Ping Solutions
04.2015 - 10.2016

SQL Developer/ETL Developer

ARNOLD OIL COMPANY
01.2013 - 02.2015

ETL

- 01.2019

Bachelor of Arts - ACCOUNTING

University of Buea

Similar Profiles

  • JEFF EASLEY

    JEFF EASLEYJEFF EASLEY

    Director of Marketing & Operations at Richardson Richardson Boudreaux Law FirmDirector of Marketing & Operations at Richardson Richardson Boudreaux Law Firm

  • Amber Otten

    Amber OttenAmber Otten

    Emergency Dispatcher/ Communications Specialist at City of Richardson, Sherman & City of Richardson, Sherman & Garland Police Dept DeptEmergency Dispatcher/ Communications Specialist at City of Richardson, Sherman & City of Richardson, Sherman & Garland Police Dept Dept

  • Daiana Varela

    Daiana VarelaDaiana Varela

    Real Estate Services /Commercial Property Administrator at CBRE - Brookfield Properties Operated by CBREReal Estate Services /Commercial Property Administrator at CBRE - Brookfield Properties Operated by CBRE

  • STEVE TRAN

    STEVE TRANSTEVE TRAN

    TEST TECHNICIAN at ZENTECH MANUFACTURING INCTEST TECHNICIAN at ZENTECH MANUFACTURING INC

  • Aiman Abuawad

    Aiman AbuawadAiman Abuawad

    Online Sales Manager at SupremeLiquidationOnline Sales Manager at SupremeLiquidation

CREATE PROFILE
Divine Okole