Rendering support in identifying business intelligence and reporting to management. Conducting need analysis and data analysis of Dubai Roads & Transport Authority and its franchises while designing and implementing BI software and systems, including integration with databases and data warehouses while ensuring high levels of BI availabilityCoordinating and working with RTA senior management and their internal IT team for turning data into strategic information and knowledge which can be… Show more Rendering support in identifying business intelligence and reporting to management. Conducting need analysis and data analysis of Dubai Roads & Transport Authority and its franchises while designing and implementing BI software and systems, including integration with databases and data warehouses while ensuring high levels of BI availabilityCoordinating and working with RTA senior management and their internal IT team for turning data into strategic information and knowledge which can be used in sound business and operational decisions Maintaining relations with stakeholders for determining business requirements, priorities and defining key performance indicators for developing BI and data warehouse strategy. Handling warehouse data while implementing data warehouse solutions by using available latest database and business intelligence tools. Collecting, analyzing and producing traffic statistics based on taxi movements in Dubai for RTA DubaiFormulating reports and dashboards solutions using cutting edge technologies. Fulfilling ad-hoc data requests, preparing data stories and actionable insights for various RTA, Dubai departmentsCollected requirements, designed, developed, and implemented business intelligence solution with separate dashboard apps and streams for various RTA Dubai departments such as operations, planning, booking dispatch, meter unit, technical services department and senior managementImplemented BI solutions for taxi franchisee companies. Designed & developed dashboard apps for taxi franchisee companies based on custom requirementsSuccessfully implemented Microsoft SQL Server Reporting solution and collected requirements, designing and developing reporting solution for Dubai Roads & Transport Authority. With over 150 customized reports for Finance, Operations, Planning, Dispatch and Meter Unit departmentsImplemented SQL data replication to transfer real-time data from main RTA Dubai Taxi Solution taxi franchisee companies in Dubai. Show less

Directed team during various phases of software development life cycle (SDLC). Suggested strategies for developing team and business units for producing latest changes for existing MIS applications while coordinating effectively with team Accurately analyzed, researched and evaluated system program requirement while rendering support in testing, debugging and diagnosing faults in application. Ensured successful user acceptance by testing application Productively installed, updated… Show more Directed team during various phases of software development life cycle (SDLC). Suggested strategies for developing team and business units for producing latest changes for existing MIS applications while coordinating effectively with team Accurately analyzed, researched and evaluated system program requirement while rendering support in testing, debugging and diagnosing faults in application. Ensured successful user acceptance by testing application Productively installed, updated, administrated, maintained and repaired existing Management Information System and database while executing improvement techniques for enhancing operationsAnalyzed current programs including performance, diagnosis and troubleshooting of defective programs and formulated solutions for MIS systems including KPI’s, human resource, finance, inventory, administration and transport managementCoordinated with various departments of eight regions such as IT, HR, finance, inventory and admin department. Maintained and drafted program code for meeting system requirements, designs and technical specificationsMonitored database systems for assuring secure services with minimum downtime. Implemented structural changes in databases during implementation of design changes in database Developed SQL scripts for maintaining routine checks on databases. Rendered support in development and maintenance activities of SQL Server Reporting Services (SSRS) environment while generating reports using SQL Server Show less