Ngagne LO

• Lead a team of 5 data analysts
• Manage analytics applications for the HQ CRM team and worldwide in the areas of clienteling, loyalty program, e-business, client profile, sell-in & sell-out
• Lead the design, implementation, maintenance, and support of enterprise reporting solutions related to Customer Acquisition and Profiling, Marketing campaigns and clienteling, fidelity programs etc...
• Collaborate with the data engineering team to build accurate and flexible data models
• Ensure accuracy of datasets by performing regular quality assurance checks for both technical and business aspects of projects.
• Define security and data updates procedures
• Prepare comprehensive documentation outlining technical specifications of all analyses conducted.
• Identify opportunities for improvement in existing business processes through advanced analytics techniques.
• Provide innovative proof of concept to help stakeholders better define their demands.
• Train product owners on best practices in data visualization
• Maintain open communication with team members, stakeholders and product owners resulting in successful project outcomes.

• Developed dashboards in Power BI to provide real-time business intelligence insights.
• Solved challenging data integration problems, utilizing optimal extraction transformation load patterns to improve datasets refresh time
• Oversaw daily operations related to data management, including ETL processes and data cleansing activities.
• Evaluated current BI solutions against other available options in order to determine cost effectiveness.

• Collaborated with functional teams to define requirements
• Implemented analysis modules to facilitate self-BI
• Used business objects and intelligence to extract data from software-based solutions and information warehouses.
• Prepared comprehensive documentation outlining technical specifications of all analyses conducted.
• Automated daily reporting processes with Python scripting and Data Factory.
• Created ad hoc reports in Excel to present findings to stakeholders.
• Developed dashboards in Power BI to provide real-time business intelligence insights.
• Set up business intelligence platform and processes

• Lead a team of 7 BI engineers
• Assigned work and monitored progression of different team members.
• Managed relationship with stakeholders and ensuring timely delivery of reports.
• Coached, mentored and trained junior consultants in order to improve their job performance and the relationship with their customers
• Interviewed prospective employees and provided input to HR on hiring decisions.
• Planned and delivered Power BI training sessions to improve reports users knowledge of the tool.
• Conducted regular meetings with staff to discuss progress and identify areas of improvement.
• Analyzed customer requirements and identified solutions that best fit their business objectives.
• Developed and wrote technical presentation for potential customers to showcase features
• Gathered and analyzed user needs and reporting requirements to determine design feasibility.
• Provided technical support to end users in resolving their queries related to the usage of BI tools and dashboards developed by us.
• Developed reports using SSRS or Power BI with drill-down capabilities to analyze trends over time.
• Developed and maintained ETL processes for data extraction, transformation, and loading from multiple sources into the data warehouse.
• Provided guidance on best practices for report development based on user requirements.
• Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.

As a database engineer,

• Designed, implemented, and maintained relational databases for data storage and retrieval.
• Planned and installed database management system software upgrades to enhance systemic performance, apply security patches etc.
• Implemented best practices for database architecture design and development processes.
• Developed scripts to automate routine tasks such as backups, indexing, and query optimization.
• Monitored system performance and identified areas of improvement or potential issues.
• Developed automated alerts based on predetermined thresholds set by business stakeholders.

As a Business Intelligence Developer,

• Developed flows for data transformation
• Maintained documentation on all aspects of the BI environment including data models, ETL processes.
• Created complex SQL queries and database objects to pull and manage data.

• Installed, configured and maintained Sql Server 2012 databases
• Migrated existing databases from one platform to another with minimal downtime.
• Performed regular health checks on all databases to ensure optimal performance levels are maintained.
• Analyzed system logs regularly to identify any potential problems or suspicious activities.
• Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
• Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.

Inside the Project and Expoitation department of the IT department, part of the team in charge of progressive and corrective maintenance on MSBI applications

• Created and optimized automated testing tools for repetitive tasks.
• Performed functional testing on web-based applications using tools like Selenium WebDriver.
• Completed unit and regression tests on software and individual modules.
• Conducted compatibility tests with different browsers, OS platforms and devices
• Executed regression tests to validate bug fixes and new features in existing products.
• Used bug tracking systems like JIRA for managing defects throughout the SDLC.
• Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.