▪ Develop Power BI Report to automate consolidation of financial data for 150+ companies in the group.▪ Configuration of dataflows on Power BI Services for data extraction from Dynamics 365 Business Central.▪ Coordinate with cross-functional teams during account consolidation exercise.▪ Provide advanced Power BI training to the IT Team on DAX Coding, Power Query, data analysis, report development.▪ Manage a team and ensure development of members through personalized training.▪ Provide support to Finance Team on the modules of Dynamics 365.▪ Develop BI Reports to provide information on debt collections, financing exposure (Commitments), account receivables, account payables, procurement, and finance (Income Statement and Balance Sheet) of the company.▪ Implementation of Datawarehouse on a private cloud server, with a SQL Server architecture and SSIS used for ETL.▪ Maintenance of Power BI workspaces and provide documentation for future reference.

Develop Power BI Reports using DAX coding and Power Query.▪ Configuration of dataflows on Power BI Services for data extraction from a Cloud ERP.▪ Configuration and troubleshooting of Power BI data gateways used for on-premises connections to SQL Server.▪ Carry out data modeling on Power BI desktop for business intelligence activities.▪ Engage in requirement gathering meetings with various stakeholders and provide viable solutions on limitations.▪ Create visually attractive BI Templates and demos to present to potential clients.▪ Create meaningful reports to provide clients with maximum information during decision making processes.▪ Using SSMS and SSIS to connect to data sources and extract ERP data as part of ETL process.▪ Prepare Power BI Reports for different industries, including Finance, Sales, Procurement, Inventory, Debtors.▪ Working with reputable clients and ensuring high quality deliverables on a consistent basis.▪ Provide training to users on the functionalities of Power BI and ease their transition from excel to Power BI.▪ Assign suitable permissions to users and establish Row Level Security based on access matrix provided by clients.

Backfilling of environments based on client requirements. ▪ Upgrade and maintenance of client environments.▪ Deployment of upgrades (Releases, Service Packs, Hotfixes) through Octopus Deploy. ▪ Provide technical support when bugs/issues are encountered by users. ▪ Creation of user profiles and assigning roles across client environments.▪ Pod creation and setup for new clients based on their contractual conditions.▪ Investigate locked databases through SQL server agents.

▪ Develop Power BI dashboards and reports based on user requirements and provide regular progress updates. ▪ Conduct retro-engineering through analysis of SQL scripts, views, stored procedures, and database schemas to create appropriate knowledge base documents for reference by users/clients.▪ Adopt agile methodologies during project life cycle phases, ensuring all requirements and delivery deadlines are met upon monthly scheduled deployments.▪ Conduct and document test cases. Provide testing reports to clients and supervisor for visibility on project progress. ▪ Provide technical support to clients in relation to on-going projects and associated operations. Engage appropriate escalation and/or resolution procedures.

▪ Adopted agile methodologies during project life cycle phases, ensuring all requirements and delivery deadlines are met upon monthly scheduled deployments.▪ Liaised daily with business analysts, to understand their needs and constraints, and represent the specifications back into technology, through development of better reporting excel files for respective data analysis.▪ Provided first level administrative and technical support to staff and clients in relation to on-going projects and associated operations. Engaged the appropriate escalation and/or resolution procedures.▪ Proposed automation of daily operational activities to enhance effectiveness and efficiency of processes.▪ Maintained continuous and courteous communication and delivery skills to provide best technical and administrative support experience to foreign clients and local staff.

Provided level 1/2 technical support for Oracle ERP E-Business Suite modules, to office staff and site workers. Took ownership of all phases of the case lifecycle, ensured status and resolution are communicated to the staff after resolution of any request, to maintain transparency. ▪ Daily communication of information through Microsoft Outlook, to the finance department about status updates of Purchase Orders, Purchase Requisitions, or Internal Requisitions by enquiring on Oracle Interface.▪ Performed monthly closures of all periods of Account Payables, Account Receivables, and Inventory. Co-ordinated monthly with the finance department to verify details in Payroll.▪ Investigated PL/SQL scripts using oracle forms/reports to resolve system errors encountered by users.▪ Prepared a knowledge base document for the system’s processes and procedures for further reference.

Daily checks for hardware defects and Windows Settings to avoid hardware compatibility during calls.▪ Prepared detailed excel reports of daily call statistics.▪ Weekly maintenance of computers, speakers, and headphones and/or equipment are sent for repair if required.▪ Communicated daily with end users of the system to enhance technical support experience.