Business Intelligence and Data Analytics Lead
Meydan Group
Total years of experience :17 years, 7 Months
Implemented a comprehensive analytics model which enabled the Procurement team to close unused/partially used Purchase Order to the tune of 2+ Billion AED, thus reducing the company’s liabilities.
Implemented a complex analytics model enabling the Commercial business to have an in-depth view of the entire business and allowed them to plan their sales and marketing strategies accordingly.
Currently working on using Python to source data from various Equine National Federations for analysis of Horses, Jockeys, Trainers and Owners performance in various races.
Working on migrating reports and dashboards from SAP business Objects to Power BI.
Implemented a comprehensive BI solution for the whole group, enabling management to see KPI’s in real time.
The self-service BI capabilities enabled individual departments to identify outliers instantaneously and rectify the issues in record times.
Led a team on building reports and dashboards on Web Intelligence, Lumira Designer, Discovery and Crystal Reports.
Currently handling all the administrative tasks on the Data and BI Infrastructure (User Management, Backup and Restore, Disaster Recovery, Version and Support Pack Upgrades, SAP support requests and tickets).
Leading a team in developing data models using SAP HANA Views in HANA Studio on FICO, REFX, SD, MM and PS modules.
Managing the timelines and deliverables of the team on requirement gathering, development and production issue.
Managed a very smooth and issue free rollout of the BI solution to end users and management.
Successfully managed end users and management to set up policies for data ownership.
-Developed Data Marts, Warehouse and a BI solution to replace an existing legacy data storage and reporting system which relied heavily on excel sheets.
-Integrated data into a single centralized data warehouse from various applications used throughout the firm (Treasury Systems, Trading Systems, Risk Management System, HR System, Booking Keeping System, File System, XML data sources and External data providers like Bloomberg, Reuters).
-Enhanced the strategic decision-making capabilities of the Executive Office by building a comprehensive data warehouse which is used for MIS reporting and dashboards.
-Designed and developed data marts for various departments such as Treasury, Operations, and finance.
-Developed a financial reporting suite for automating GL reporting, audit reporting, management reporting, P&L reporting, VAT invoicing.
-Developed an operational reporting suite for automating trade reconciliation, client confirmation reporting, Operational KPI’s and Rebate reporting.
-Led the design, development, testing and delivery of data warehouse and business intelligence solution containing 120+ reports.
-Comprehensive documentation of techniques and processes used in data warehousing and reporting.
-Engaged with the COO of the firm in setting the direction for reporting and analytics vision and roadmap.
-Acted as subject matter expert in data sources, data elements, and data analysis.
-Led a team of 5, on an internal development project in Business Objects 4.1.
-Requirement gathering, estimation and scheduling, functional and technical documentation.
-Developed complex dashboards using Dashboard Designer 4.1 (Xcelsius).
-Developed multi source universes using Information Designer Tool.
-Developed complex reports using Web Intelligence.
-Worked extensively on administrative tasks on Central Management Console (CMC) in Business Objects 4.1.
-Helped Java team in using Business Objects SDK.
-Worked on projects in Management Accounts.
-Successfully handed over projects to support teams with all the required knowledge transfer and documentation.
-Senior developer on Business Objects 3.1 with SAP integration.
-Senior developer on Crystal Reports 2008 with SAP integration.
-Prepared technical specifications from functional documents.
-Developed complex reports using Web Intelligence and Crystal Reports.
-Developed complex dashboards using Xcelsius.
-Created publications for dynamic users in Business Objects.
-Created unit test cases and peer review checklists that the whole team used.
-Worked on projects in retail industry.
-Developed Business Objects XI R2 reports and universes.
-Developed packages and reports on Cognos.
-Requirement gathering for report and universe enhancement.
-Developed Informatica mappings and sessions.
-Database development.
-Worked on projects in Banking and Financial domain.
-Database developer for an in house project.
-Developed Oracle 9i packages, procedures, functions and triggers
-Trained people in SQL and PL/SQL.
Bachelor's degree in Computer Science and Information Technology.