IT Manager / Microsoft Dynamics AX Functional Consultant / BI Specialist
Meshaal Al Shatti & Partner
Total years of experience :15 years, 6 Months
Dynamics AX R3
Meshaal Al Shatti & Partner, Kuwait (Feb 2019 - Present) ERP Functional Consultant
● Configuring and customizing the Microsoft Dynamics application to achieve the customers’ business requirements.
● System Administration for creating & assigning Users Roles, Privileges and Duties.
● Basic setups of Financial Accounts, Dimensions and Posting Profiles.
● Working with business and other parties to document business process, workflow, requirements, and other technical artifacts that required for project planning activities.
● Implementation of Gift Cards and Loyalty programs (Tier level loyalty cards).
● Configure various methods of retail promotions, influencer discounts etc.
● Provide end-user training and operational support to the back-office users/store’s users on the product as per need.
● Supports 20 stores + Warehouses in Kuwait region for their retail business.
● Configure database backups from store database and central database and keep copies in external drives and cloud storages.
Business Intelligence Reports & SSRS Reports
● Install, configure and administration of Power BI tools.
● Designing the current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.
● Developed Power BI Dashboards and Reports from multiple data sources for Sales, Inventory, Financial &
Marketing modules.
● Developed standalone operational reports for end users for monitoring the transactions from all the modules in AX and day to day activities, through SSRS Reporting Tool.
E-Commerce Websites
● Successfully implemented two e-commerce websites with multi language for Retail business using Shopify
Ecommerce Platform.
References: https://www.bait-hanayen.com & https://www.shadow.com.kw
Dynamics AX Functional Specialist R2 & R3
● Provided in-depth knowledge of Microsoft Dynamics AX 2012 R2 & R3 application and evaluated the
customer’s business processes against the standard Microsoft Dynamics functionality.
● Providing in acceptance testing by creating, reviewing test plans and test cases, executing testing scenarios, and evaluating test results.
● Responsible for documenting the business requirements which express what actions a solution must
take and what outcome is expected.
● Configuring and customizing the Microsoft Dynamics application to achieve the customer’s business
requirements.
● Involved in all part of data migration activities.
● Prepare functional requirement document, functional design document, process test scenarios and user manuals in line with the company standards.
● Provide end-user training and operational support to the employees/stores users on the product as per need.
● Batch jobs creation and Master Planning setups for replenishments.
● Retail Store Configurations & POS Setups
● Configure various Promotions definition.
● Store Database Re-Indexing, Backups & Restore.
● Create SQL queries & Views for reporting purposes from AX tables.
● Generate batch scripts for updating dll’s in store levels.
● Support 300+ retail stores in the regions Kuwait, Dubai, KSA, Qatar, Lebanon, Bahrain & Iraq.
● Drive best practices and guidance that integrate and improve methodologies and user experience.
Business Intelligence Specialist - SAP BI 3.1 and 4.1 & IBM Cognos (Jul 2011 - Sep 2017)
● Handle the tasks of developing design concepts of data warehouses and data base to meet BI solutions.
● Responsible for evaluating and selecting database/data warehouse components like ETL software, relational database management systems, and database design solutions.
● Perform the tasks of planning, designing and creating reports and cubes for business users.
● Installation, configuration of Business Objects and assigning user roles and privileges.
● Creation of ERP operational reports using IDT / UDT tools and derived tables using sql queries, improvement and documentation of ERP operational reports and related universe, including standardization and applying best practices.
● Gathering requirements from end user and making Universe as per business requirement.
● Created complex WEBi Reports (Used Multiple Queries, Union, Intersection, Cross tab, Charts).
● Experience in setting up environment for BOXI, setup for the project that involves creating the groups in
CMC, adding users, mapping the row level and object level securities, migrating objects and universes.
● Creation of Web Intelligence reporting, Desktop Intelligence reporting and Migration in Business Objects.
● Universe creation with contexts, joins, solving Fan Traps, Alias, Derived Tables, Hierarchies and
Cardinalities.
● Used Central Management Console (CCM) to enable/disable various BO services, cloning the Servers and
Run Parallel to Improve the Performance.
● Expertise in Universe designing, developing and generating complex, Ad-hoc, dashboard Reports, List of values along with User Acceptance Test and data accuracy test.
● Track user logged statistics, number of reports accessed by the users, check the most used reports, and track the scheduled/non T scheduled reports and many kinds of analysis through Query Builders.
● Backup and restore Application and BI databases.
● Proficient in writing complex queries and improve query performance by defining indexes.
● Handle the tasks of developing design concepts of data warehouses and data base to meet BI solutions.
Assistant Project Manager
Software Administrator
Software engineer and developer
Master of Computer Applications