Jean Luc Olivier Kanga

**** ********** ** #*** ******, Texas

75287

adbfs0@r.postjobfree.com

469-***-****

SUMMARY:

Innovative Business Analyst skilled at enhancing and optimizing business processes to ensure growth and success. Experienced with analyzing internal workflow process to identify areas of enhancement, developing and implementing business development plans, and assessing business requirements.

TECHNICAL SKILLS

• Excellent in Creating SQL scripts

using SQL Server Management Studio

• Aptitude to use R and Python

programming languages

• Ability to Extract, Transform, Load

data using SSIS

• Capacity to use Hadoop, Sqoop,

Apache, Spark, HBase, NoSQL

• Capability to Analyze data, Add KPI

to a database cube using SSAS

• Excellent Analytical and Optimization

Modeling using Excel 2016

• Proficiency to use OBIEE 11G to

analyze data model, Integrate and

Report services

• Capability to work in tight deadlines,

independently as a self-starter and

within tam

• Capacity to create Dashboard reports

using SSRS and Tableau

• Excellent oral and written

communication in French and English

06/2017 – 05/2019 Business Data Analyst Trainee Texas A&M Commerce, Texas

• Extract and analyze data to provide solutions to the project’s lead using SQL

• Managed and updated database customers using SQL

• Extract, transform and load data to build facts and dimensions tables using SSIS

• Microsoft SQL Server Analysis Cubes and Create KPI’s to monitor customer and revenue retention rate

• Generate and automate reports on the daily basis using SSRS

• Build an end to end account monitoring dashboard using Tableau

• Designed and generated visual graphics and data insights using tableau

• Build scripts in R to perform regression analyses of historical marketing data for prospective customers

• Build scripts in Python to predict customers purchased

• Create performance Dashboard using Advanced Excel

• Enhancing tracking while reducing quality errors by 15% and increasing client profit by 30%

Environment: R, Python, Tableau, MS SQL Server, MS Data Tools, Advanced Excel

08/2016—06/2017 OBI Developer Trainee, Cider Tree Technology Dallas, Texas

• Use BI Administration to build physical layer, business model and mapping layer, presentation layer

• Use BI services Enterprise management for RPD deployment, to create analysis in answers and dashboard

Environment: OBIEE 11G

EDUCATION

06/2017-- 05/2019 Texas A&M Commerce

Graduated with a master’s in business Analytics

03/2019--Present Udemy Online Certificate

Master course in Tableau 10

05/2016-- Present Oracle Online Certificate

OBIEE Foundation 11G

Contact this candidate