Data Analyst/Power BI Developer/ Data and Information Visualization (Power BI/Tableau)

• A review of customer requirements along the entire value chain and consulting with all departments in the evaluation, selection, implementation and further development of their BI strategy.
• Business requirements are translated into reporting solutions based on Business Warehouse and Business Objects BI for use by customers in a variety of industries.
• Develop data modelling and data transformation for business intelligence tools.
• Collaborate with business engagement teams to define dashboards and reporting solutions to meet diverse, complex business needs.
• Architect future dashboards including the design of the data warehouse tables, Source to Target ETL logic and dashboard development.
• Build data structures and data blending technologies to provide data to BI tools.
• Design reports as per business requirements from various source systems like Excel and, Microsoft SQL Server.
• Create data models in the Hadoop platform to enable visualization through BI tools. Provide feedback/reports on system usage and potential bottlenecks. Develop creative solutions for complex enhancements
• Preparation of documentation and training of employees of the specialist departments as well as external partners.

Project:- Business Expert Gulf: Data Analyst and Power BI Developer

Development of a company-wide reporting and analysis system for the board, management, regional/area and facility management, and specialised departments such as HR, operations, and marketing using Microsoft PowerBI (desktop and online service).

➔ Currently approx. 20 standard reports for all relevant user groups and special topics such as Balanced Scorecards and forecasting models ➔ Operating Model for the causation-based allocation of centrally posted costs.
 

• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Design, develop, test, and deploy reporting and analytics solutions, based on the Power BI Platform.
• Data connection with Power BI Dataflows results in the creation of a central data pool in the Power BI Online Service (data sources including MS OneDrive, company network, Salesforce, internal data (planning, revenues), MySQL database).
• Financial and non-financial data from multiple source systems are structured and mapped, including the specification and generation of main and foreign keys.
• Data set modelling is based on data flows, including automatic updates.
• Daily, weekly, and monthly reports on all vital corporate themes (Finance, HR task planning, recruitment, marketing and sales), including automatic updates, are created for each target group.
• Design, implement, and optimise dashboards, reports, and mobile apps in a Microsoft environment, as well as ETL processes and data models.
• DAX is used to construct the needed measurements and derived columns, including time intelligence, extrapolations, and rolling predictions.
• Daily reports for the Commercial Operations (Finance, Sales and Marketing) teams, including executive summaries and thorough assessments, are created for each target group.

---

Project:-  Pharmaethics, and Omnia Food Trading: Data Analyst and Power BI Developer
 

• Completed Power BI POC for Pharmaethics, and Omnia Food Trading.
• Design, develop, test, and deploy reporting and analytics solutions, based on the Power BI Platform.
• Develop interactive visual reports and dashboards.
• Responsible for the development and implementation of the Power BI projects too.
• Facilitated with providing functional training and live support to client’s users for effectively using Power BI.
• Developed all the finance and operation reports, like accounts payable, account receivables, inventory ageing, profitability, procurement report, cash flow reports and sales report.
• Outperformed to help and support to Navision implementation team and users.

• Raise VAT compliance invoices to customers on a monthly and quarterly basis based on their signed SLA contracts
• Monitor customer account details for non-payments delayed payments and other irregularities
• Prepare receipt for cash and check in MS 365 and allocate the invoices accordingly as per payment instructions provided by customers.
• Carry out billing, collection, and reporting activities according to a specific deadline
• Monitor customer account details for non-payments delayed payments and other irregularities
• Review AR aging to ensure compliance
• Maintain accounts receivable customer files and records follow established procedures for processing receipts , cash, etc.
• Record all the petty cash vouchers and post them timely.
• Record Inter-group companies' invoices reconciliations monthly basis to ensure transactions are processed and balances are reconciled.
• Reconciliation of bank accounts & Intercompany, Accounting.
• Handling payrolls of the employees & resolving final settlements & HR related issues using payroll software Business Center