Business Intelligence Manager
Okhtein Designs
Total years of experience :6 years, 6 Months
Monthly business performance reporting through Power BI integrated with Odoo.
Assisted migrating operational data from four different silos into Odoo to form a functional data warehouse.
Performed data cleansing on Odoo database to reconcile data to the true values while removing redundant entries reducing data quality issues by 80%.
Supervised and trained financial analysis team.
Monthly cash reconciliation with bank and treasury to track budget-actual performance.
Built powerful dashboards using Power BI to supervise sales activity, set targets, monitor profitability, and promote data literacy and integration into decision-making.
Analyzed product manufacturing, logistics & depreciation to establish optimum pricing strategies for new collections and calculate profitability, improving margins by more than 20% as a result of improved pricing.
Budgeted financial year 2020 for a consolidated group of four companies to determine liquidity needs and forecast performance.
BI & Data Analyst - MEA HQ
Designed 6 different Power BI reports serving the greater MEA region, covering Enterprise as well as Small & Medium Business.
Implemented Fuzzy Lookup Algorithm with parallel processing on a dataset of 3.7 million rows to deduplicate account names.
Hosted three training workshops attended by a combined 100 Microsoft MEA employees covering Power BI reports and analysis techniques.
Contributed to best practices sharing sessions with worldwide BI teams on report-building and data maintenance.
Extracted relevant data through complex SQL queries to more than 30 different data sources.
Developed extensive technical and business knowledge of the tech and cloud industries.
Notable Projects: Automated Week over Week Analysis with Power BI, Power Platform Integration with Azure Synapse
◼Analyzed economics for an Oil & Gas Concession in the Western Desert region valued at $25 Million.
◼ Modeled alternate scenarios for capital structure to identify optimal debt/equity financing for investments.
◼ Conducted financial due diligence on several acquisition targets.
◼ Designed management presentations and teasers to solicit external investors and debt financing sources.
◼Researched external company financial data as well as international economic data to explore potential investment opportunities.
◼ Carried out company valuation through discounted cash flow and free cash flow analysis.
◼ Forecasted financial results to determine expected risks and returns from investments.
◼ Created business models and go-to-market strategies for FMCG, Medical Insurance, and Fintech industries.
◼ Conducted field research on acquisition targets.
Mentored and trained colleagues on data analysis techniques in various software packages including Microsoft Excel, Power BI, KNIME, and R, to increase their research and analytics capability.
Used forecasting tool to prepare feasibility studies for new vegetable product lines.
Conducted research and analysis on international trade in Medicinal and Aromatic Plants (MAP) and the size of the potential market as part of the company’s expansion plan.