BLAISE NGANTCHA

SUMMARY:

BI Developer

In-depth knowledge in various RDBMS concepts like database, schemas, tables, data type constraints, views, indexes, stored procedures, variables, user defined functions, triggers, CTE (common table expression) etc.

Database design and complex query building for data extraction using Microsoft SQL Server 2012 and 2016.

Descriptive statistics and visualization (dashboards) with, Power Pivot, Power BI Desktop and Tableau (ad hoc reporting tools).

Complex report development and dashboard creation with stored procedures in SSRS using SSDT and Microsoft Visual Studio 2010 - 2017.

Data migration from diverse sources to diverse destinations using SSIS (ETL processing).

Extensive experience in Information Technology with special emphasis on design and development of Database, Data Warehousing applications and Software Development Lifecycle (SDLC).

Data analysis/modeling, data management and data cleansing with R, SAS, SQL and SPSS. EDUCATION & CERTIFICATION:

UNIVERSITY OF HASSELT, Belgium

M.Sc. in Statistics, 2012 – 2015

Microsoft DAT201x: Querying with Transact-SQL Certificate EXPERIENCE:

04/2018 to BITLEGENCE, Garland, TX

Present BI/Tableau Report and Analytics Developer

Prepare, test, deliver, maintain and troubleshoot reports, analytics and interactive intelligence in systems across the client’s organization.

Designed data visualizations and determine the best way to present data to end users using drilldowns, drillthroughs, tables, matrix, list, parameters, sub reports, gauges, graphs, charts and other intuitive graphical add-ons.

Design and deploy reports and data visualizations using Tableau.

Developed multiple dashboards, analytical reports, KPIs and interactive reports based on business requirements using SSRS to support executive business needs.

Developed workbooks, storyboards and interactive dashboards using multiple Data Sources in Tableau Desktop.

Published various types of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.

Created Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs, and charts.

Worked extensively with relational database concepts with a solid knowledge of T- SQL.

Designed and developed complex stored procedures, queries and views necessary to support SSRS reports.

Extracted data from internal data warehouse system to SSRS, Tableau and Power BI

Generated various weekly, monthly and quarterly sales reports for different business needs using SSRS, Tableau and Power BI.

11/2017 to CICIS SUPPORT CENTER & CORPORATE OFFICE, Irving, TX 03/2018 BI Developer Consultant

Data pull from cloud based point of sales (NCR Silver Pro) to company database server via API calls.

Wrote complex stored procedures for advanced reporting.

Developed views, sub-queries and joins for complex queries involving multiple tables.

Designed custom report templates for Sales and HR departments using SSRS.

Created parametrized daily and weekly sales analysis reports using SSRS.

Created parametrized labor cost reports using SSRS.

Deployed SSRS reports on native report server.

Scheduled reports for daily and weekly delivery. 11/2015 to I-PING SOLUTIONS, Garland, TX

11/2017 BI Developer and Data Analyst

Responsible for creating complex stored procedures, triggers, tables, views, temp tables, joins, user defined functions.

Involved in designing the physical databases model on SQL Server 2012 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL).

Performed SQL Scripting, using Microsoft SQL Server Management Studio 2012 and 2016, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses.

Modified stored procedures and formulated basic coding and scripting to be utilized for reports within the organization.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Created dashboards in Power BI desktop with trends and forecasting features.

Generated parameterized, cascading, linked reports, Sub-Reports, Drill down reports, Drill through reports and graphical reports with stored procedures in MS SQL environment as well as dashboards using SSRS 2012 and 2016 and Visual Studio 2010 to 2017.

Build complex conditional expressions for formatting in SSRS reports using the iif, switch and choose functions.

Worked in collaboration with company representatives, end users and other developers in the design of custom report templates for clients.

Deployed SSRS reports on native Report server.

Created linked reports in report manager.

Created SSIS packages to export and import data from CSV files, text files and Excel spreadsheet. Involved in installation, configuration and development of SSIS packages using Visual Studio 2012 and 2016.

Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.

Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks. 04/2013 to RADISSON BLU, Hasselt, Belgium

09/2015 Tableau/SSRS Report Developer

Defined best practices for Tableau report development.

Design Dashboards using filters, parameters and action filters in Tableau.

Created scatter plots, line charts, tables, histogram, bubble charts, Gantt charts, maps, highlight tables, box and whisker plots, pie charts and treemaps in accordance with business requirements.

Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Work on generating various worksheets, dashboards and stories in Tableau Desktop using various data sources.

Hands-on development and assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.

Designed, published and customized interactive reports and dashboards, report scheduling using Tableau server.

Developed views, sub-queries and joins for complex queries involving multiple tables.

Created and updated Transact-SQL stored procedures for report development.

Worked extensively with Transact-SQL DDL and DML.

Maintained SQL scripts, indexes and complex queries for analysis and extraction.

Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports based on business requirements.

Deployed and subscribed reports using SSRS to generate daily, weekly, monthly business reports.

Created dashboards in Tableau and Power BI.

Experience in scheduling and deploying reports on report manger. REFERENCES: Available upon request.

Contact this candidate