Business Intelligence Data Analyst
Resume:
Roosvelt NICAISSE
: Plantation, Florida *****
: ********.********@*****.***
Language: English – French - Creole
Visa status: GC-EAD
Solution-oriented business intelligence analyst with 12+ years of experience in data analysis, data modeling, dashboard building and ETL development for various industries including banks, pharmaceutical or retails. With advanced analytical skills, eager to help the business sector to be competitive and to enhance decision making strategies. In recent roles I built a BI incident management system to decrease complaints processing time by 80% by designing reliable key performance indicators. Expertise
- Data visualization (Report/Dashboard) - Technical Troubleshooting - Data collection and analysis
- Data pipeline (ETL, ELT development) - Release Management - Requirements gathering
- Data modeling (Star, Snowflakes) - Customer Solutions - Problem-solving and critical thinking
- ER Diagrams - Leadership skills
Key achievements
Power BI migration: Migrated 15 OBIEE marketing and sales reports/dashboards to Power BI Sales growth: Identified leads with low conversion rate and built dashboards to successfully increase by 60% conversion to sales opportunity
Incidents management: Designed a model to reduce by 80% the time taken to support and resolve major incidents ETL mappings performance: Conducted a project to increase ODI load plan by identifying and improving slow mappings Skills
Development software: SQL Developer (Advanced), TOAD for Oracle (Advanced), SSMS (SQL Server Management Studio) ETL: ODI 11g, 12g (Advanced), Microsoft SSIS (Intermediate), Power Query (Intermediate) Reporting: Power BI (Intermediate), OBIEE 11g/12c (Advanced), Microsoft SSRS (Advanced), BO (Beginner) Coding: SQL (Advanced), DAX (Intermediate), MDX (Intermediate) CRM: Siebel
Microsoft: Excel, PowerPoint, Word
Data modeling: Star schema, snowflake schema
Communication skills. Problem solving-skills. Critical thinking Work environment: Scrum, Agility
EXPERIENCE
Sept.2016 – Oct.2024: Lead - Senior Business Intelligence Analyst at Desjardins Bank in Montreal
- Led a cross-functional team of 6 developers and analysts
- Managed workflow in JIRA
- Analyzed CRM Siebel transaction data
- Developed ETL connections between CRM and ODI BIAPPS
- Implemented complex ODI mappings to inject data in BI DataMart
- RPD administration (built dimensional and relational data models)
- Delivered and maintained sales and marketing dashboards
- Managed roles, groups and security levels in enterprise manager console
- Coached stakeholders in better understanding of relational versus transactional data model
- Designed and recommended business processes to improve business activities
- Animated design workshops with product owners and business intelligence team
- Produced functional and technical specifications documents
- Migrated ODI mappings into Power BI Desktop
- Troubleshooted data discrepancies
Technical environment: Siebel, ODI BIAPPS 11g, OBIEE 11g/12c, TOAD SQL, SQL Developer, Power BI, JIRA, Excel, PowerPoint
Key achievements:
- Coordinated 50+ dashboards and reports conversion from Cognos to OBIEE for hundreds account managers
- Increased support for new customers by 10%
BI Data Analyst
- Recommended process improvements that help the team increased by 20% work velocity Aug.2013 – Sept.2016: Business Intelligence Analyst at Pfizer and Zoetis animal health in Montreal
- Developed prototype dashboards to present to end users
- Produced datasets and new reports and enhanced existing reports
- Documented business requirements and functional requirements
- Supported finance daily reports in production environment
- Performed unit testing to make sure the reports respect quality standards
- Developed ETL connections between Oracle ERP and SSIS
- Built complex mappings with SSIS
- Troubleshooted data discrepancies in dev and production environment Technical environment: Microsoft (2008-2012 versions) SSIS, SSAS, SSRS, MS Project, Microsoft studio, Excel, Word, PowerPoint
Key achievement:
- Cleaned product hierarchy model that helps stabilize reports in production
- Being proactive
- Recommended process improvements
July.2012 – july.2013: Business Intelligence ETL and reports developer at MGT Consulting in Paris
- Developed ETL connections between Oracle ERP and ODI
- Built complex mappings with ODI 10g
- Debugged existing ETL mappings and proposed best development practices
- Administrated RPD data models
- Developed prototype dashboards to present to end users
- Built quality KPIs with OBIEE
- Managed application roles, groups and security levels in enterprise manager console
- Supported and updated reports in production environment
- Documented business requirements and functional requirements
- Installed quality unit testing based on the company minimum standards
- Troubleshooted bugs and errors in production
Technical environment: TOAD 9.6.1, ODI 10g, OBIEE 10g, Excel, Word Key achievement:
- Deployed reports physically to a foreign country (adaptation to a new working culture)
- Trained executive managers how to use OBIEE reports and how to use the data for better decision making
- Reduced existing ETL bugs by 60%
- Improve ODI mapping’s extraction time by 50%
Feb. – May 2012: Business Intelligence Internship at Equippe in France (Lille)
- Data entry
- ETL development
Education
2023 : Professional Scrum Master I Certificate
2011 – 2013: University of Science and Technology of Lille, France: Master’s degree in information systems 2008 – 2010: University of Science and Technology of Lille, France: Master’s degree in commerce and business administration Hobby
Pickleball, Soccer, Travel
Contact this candidate