DAVY LUEMBA

• Wrote complex SQL queries using T-Sql to interact with Pentagon2000 ERP database.
• Developed models based on physical, logical and data-driven models.
• Developed online sales dashboards,financial dashboard,inventory dashboard,shipment tracking dashboard with beautiful visuals and reporting templates in power bi desktop, with power query for data transformation and dax for measures and calculated columns.
• Developed excel reports with native sql queries, transformed and load with power query.
• Published and maintained reports and Dashboard on power bi service.
• Installed and configured an office 365 on-premise data gateway for data transfer,dataset refresh between the local on-premises Sql database and Power bi/power automate Microsoft cloud services.
• Integrated power bi with Screencloud software for TV screen visualization in the office hall.
• Embedded power bi report on sharepoint sites
• Generated reports and obtained data to develop analytics on key performance and operational metrics.
• Secured dataset with access granted by users group.
• Develop Excel with SQL reports as helper tools to facilitate and improve the work of different users at all level
• Developed inventory apps with Microsoft power apps
• Developed and secured internal sharepoint site, with all reports imported and managed membership access
• Developed Power Automate flows :-for automatically sending a specific email alert to teams group when a sales amount is reached.

- for power bi dataset refresh

- for automatically open,navigate ,refresh and close a specific excel report

• Supported QC and accounting with sql queries to find discrepancies in internal audit,to solve system bugs, to improve business process and performance.
• Provided technical support for existing reports, dashboards or other tools.
• Maintained or updated business intelligence tools, databases or dashboards,follow up failed dataset refreshes.
• Implemented and followed up company data backup schedule with Shadowprotect and Ibackup software,with Synology nas for external storage,

• Met with users, vendors and technicians to determine computing requirements.
• Assigned and reviewed work of IT project managers, systems analysts and developers.
• Performed on-site installation, routine maintenance and minor repairs to systems.
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
• Generated standard or custom reports summarizing business, financial or economic data.
• Created and designed business intelligence databases, spreadsheets or outputs.
• Managed diverse projects for data capture, storage and forecast analysis.

• Handled user account access management, assigning credentials, distributing permissions and terminating defunct users.
• Trained healthcare staff to use and operate epic system.
• Answered software and clinical application questions with detailed explanations and examples.
• Assisted with development of dashboards and reports using spreadsheet and visualization software.
• Extracted data to build metrics or create dashboards, tracking success toward KPIs.
• Tracked hardware assets, ordering equipment to maintain accessible inventory.
• Performed daily maintenance of computer systems to keep network processes fluid.

• Handled user account access management, assigning credentials, distributing permissions and terminating defunct users.
• Escalated technical issues to development or technical operations team following prescribed support guidelines.
• Debugged and repaired application issues.
• Collaborated with internal teams to resolve customer issues and support customer service goals.
• Logged status of jobs in work tickets using servicenow tracking system.
• Performed troubleshooting and resolution for company-wide technical issues.
• Increased efficiency through task automation.
• Delivered remote assistance for technical issues using screen sharing, mouse and keyboard control and other tools.
• Wrote SQL queries using programs such as T-SQL.
• Generated daily, monthly and annual reports to address short- or long-term business intelligence questions.
• Worked with sales teams to build self-service reports and establish automated processes for large-scale data analyses.
• Set up user accounts, permissions and passwords and defined network policies and procedures.
• Maintained cloud-hosted and on-site servers by applying appropriate patches and monitoring hardware health.

• Procured IT resources for strategic and operational computing requirements.
• Managed backup, user account and helpdesk systems.
• Analyzed workflows and established priorities for daily operations.
• Provided company users with tech support for IT problems and account maintenance.
• Maintained knowledge of advances in information technology systems and applications.
• Reviewed and approved project plans prior to implementation.
• Recruited, trained and supervised IT department staff.
• Determined and alleviated hardware, software and network issues.
• Managed email routing and internal message protocols to support reliable delivery of communications.
• Designed endpoint management strategy for operation of various systems and devices.