Recoit Basala

Recoit Basala

BI/Tableau Developer

Irving, Texas, United States.

About  

Hi, My name is RECOIT MBEMBO BASALA, I am graduated I am a certified BI/EDW/ETL. I graduated from ISIPA/Kinshasa with my bachelor’s degree in Information systems and database administration. Since I have been in this field, I have had the opportunity to work in multiple different industries such as Telecommunication, Customer Service, and Banking. I have utilized SQL Server (versions ranging between 2010 – 2016), Oracle SQL (version 20.4.1.1.407), and Tableau Desktop, and online (2021.2 recent), I have skills with Agile methodology too.

As a Tableau /ETL developer, I am able to start a project from scratch by creating a store procedure, joins, CTE, Temporary Tables, and so on. Also, Basically, I use a store procedure to provides an important layer of security between the user interface and the database. I use joins, to link tables and get the results that we need; most time I use CTEs and Temp tables to fight duplicated values in the table. Also, I can build from scratches an ETL solution to solve big problems by creating staging layers to collect all data coming from diverges sources, transform those data by creating an error handling process and apply some business rulers, avoid some duplicated values and load those into the ODS or Data warehouse by feeding dictionaries tables, facts and dimensions tables as well. In addition, I also have experience in SSRS.

When you hire me, I am going to do my best to give you more than what you ask me because I am more quality than quantity person.

Hours Available / Wk - 40 hrs

Portfolio 

0 Likes

Chase Bank Deposits Data Warehouse

This dataset represents and includes a record for every branch of Chase Bank in the United States, i... ... More

Employment History 

  • Senior BI Developer ( SQL and Oracle/ ETL and Tableau).

    CTDI
    December 2018 - Present

    • I built reports from scratch, modify, update, and publish the complex dashboard with SQL data sources to form the test layer to the production layer.
    • Used T-SQL for developing stored procedures, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing;
    • Performance tuning on existing ETL packages;
    • Used SSIS to create maintain and troubleshoot ETL packages to validate, extract, transform and load data to data warehouse databases;
    • Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, lookup, OLE DB Command, Multicasting);
    • Performance tuning of Queries and Stored Procedures;
    • Designed, updated, and maintained Tableau reports as requested by the ticket;
    • Created and developed Sub-Reports, Drilldown reports, Drill through reports, and Parameterized reports using Tableau or SSRS.