Summary
Overview
Work History
Education
Skills
Accomplishments
References
Hobbies and Interests
Timeline
Generic

Mohammed Abdullatif

Auckland,Otahuhu

Summary

Versatile BI Analyst/SQL Developer with 14+ years of experience in different SQL versions (T-SQL, PL-SQL, PostgreSQL…) and almost 5 years in BI combined with comprehensive background in leveraging data analytics and SQL development to drive business intelligence initiatives. Proficient in designing and optimizing databases, writing complex SQL queries, and developing ETL processes to extract, transform, and load data from disparate sources. Skilled in creating interactive dashboards and reports using BI tools such as Power BI, Tableau, and Looker to provide actionable insights to stakeholders. Experienced in collaborating with business users to understand requirements, define metrics, and deliver analytical solutions that address key business challenges. Strong analytical skills combined with a deep understanding of database structures and data modelling principles to uncover trends, patterns, and opportunities within datasets. Proactive problem-solver with a passion for continuous learning and staying updated on emerging technologies in the BI and SQL development space. Seeking to leverage combined expertise in BI analysis and SQL development to drive innovation and drive business growth in a dynamic organization.

Overview

15
15
years of professional experience

Work History

SQL Developer

Ashnet
03.2019 - 11.2019
  • Developed 50+ Stored procedures consumed by POS, Stock inventory management, and job tracker systems.
  • Enhanced database performance by optimizing SQL queries and indexing strategies.
  • Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
  • Collaborated with cross-functional teams to design and implement effective data solutions, ensuring seamless integration with existing systems.

Lead BI Analyst

Nahdi Medical Company (Large Pharmacy Chain)
12.2016 - 10.2018
  • Maintenance and enhancement of 3 Data warehouses
  • Led project of merging commercial and CRM Data warehouses
  • Enhanced data-driven decision-making by developing and implementing BI solutions for various business departments.
  • Streamlined reporting processes by creating automated dashboards, resulting in improved efficiency and accuracy.
  • Supported strategic planning initiatives by providing insightful analysis of key performance indicators and trends.
  • Collaborated with cross-functional teams to identify opportunities for process improvements, driving increased operational effectiveness.
  • Evaluated success of implemented BI strategies through rigorous post-implementation analysis, ensuring alignment with business objectives.
  • Provided crucial input during system migration projects, ensuring seamless integration of new BI tools into existing infrastructure without compromising data integrity or functionality.
  • Delivered customized training sessions to end-users on BI tool usage, enhancing adoption rates across organization.
  • Facilitated better understanding of critical business drivers by designing user-friendly visualizations that communicated complex data insights effectively.
  • Reduced report turnaround times by automating manual procedures through implementation of efficient ETL workflows.

Senior SQL Developer / BI Analyst

Nahdi medical company (Regional largest pharmacy chain)
07.2011 - 11.2016
  • (MS-SQL Server/Oracle) Database Development (User defined functions / Stored procedures, Triggers, etc ...) for System customization of 3 cutting edges ERP's ( Accpac, Oracle E-business suite, Oracle Retek, Oracle fusion) along with Reporting and Inter-database ETL operations
  • Developed many customized ETL applications for bulk data Upload like promotions data.
  • Built and maintained 4 data warehouses:
  • Finance data warehouse,and high management DW using OBIEE
  • Commercial and marketing campaign DW using MSBI (SSIS, SSRS, SSAS), PowerBI
  • CRM and loyalty program DW using MSBI (SSIS, SSRS, SSAS), PowerBI
  • Optimized database performance by analyzing and fine-tuning complex SQL queries.
  • Developed efficient stored procedures and functions for streamlined data processing, resulting in improved system performance.
  • Collaborated with cross-functional teams to gather business requirements and design robust database solutions.
  • Designed and developed ETL processes for seamless data integration across multiple platforms.
  • Enhanced data-driven decision-making by developing and implementing BI solutions for various business departments.
  • Streamlined reporting processes by creating automated dashboards, resulting in improved efficiency and accuracy.
  • Supported strategic planning initiatives by providing insightful analysis of key performance indicators and trends.
  • Evaluated success of implemented BI strategies through rigorous post-implementation analysis, ensuring alignment with business objectives.
  • Provided crucial input during system migration projects, ensuring seamless integration of new BI tools into existing infrastructure without compromising data integrity or functionality.
  • Reduced report turnaround times by automating manual procedures through implementation of efficient ETL workflows.
  • Managed complex BI projects from inception to completion, consistently delivering high-quality results within budgetary constraints and strict timelines.

Intermediate Developer

Nahdi medical company (Regional largest pharmacy chain)
10.2008 - 06.2011
  • Development and support of third party applications and integrate them with 3 cutting edges ERP's ( Accpac, Oracle E-business suite, Oracle Retek, Oracle fusion)
  • Analysed and developed store's inventory tracking system
  • Developed POS, Warehouse management system, employees' time attendance, and payroll systems.
  • Analyzed and developed data collector Application for stores
  • Developed some quick modules using Excel and VBA.
  • Enhanced user experience by developing and implementing responsive web designs.
  • Streamlined code for faster load times and improved website performance.
  • Collaborated with cross-functional teams to ensure seamless integration of new features.
  • Reduced development time by creating reusable code libraries for future projects.
  • Optimized database structures for efficient data storage and retrieval.

Senior Developer

Attar Trading Est (IT solution provider)
10.2004 - 09.2008
  • Provided development support/Debugging to old customers for General ledger, Point of sale, stock control, and payroll systems
  • Analysed business needs, processes, and legacy systems (including VBA pre-written code and spreadsheets) of new candidate customers and converted them into well-defined project briefs
  • Presented solutions proposal .
  • Developed database type independent solutions
  • Analysed and developed time attendance system that supports cards, fingerprints, punches and face ID devices
  • Analysed and developed of automotive showrooms management system
  • Planned training of customers and preparation of user manuals
  • Arranged complete tests for complete solutions
  • Ensured balance of performance, data integrity, security of systems
  • Helped new customers in choosing appropriate hardware
  • Ensured commitments to business deadlines of customers
  • Produced of project feasibility reports
  • Reviewed and approved all systems charts and solutions before their implementation
  • Issued tracking and resolutions
  • Kept up to date with technologies in field.
  • Prepared technical documentation for systems which helps in knowledge transfer and handover.
  • Improved software performance by identifying and resolving bottlenecks in development process.
  • Reduced production time by streamlining coding processes and implementing efficient algorithms.
  • Collaborated with cross-functional teams to develop innovative solutions for complex technical challenges.
  • Led design and implementation of scalable software architectures, ensuring long-term maintainability and flexibility.
  • Optimized database structures, resulting in faster query processing times and improved data integrity.
  • Incorporated industry best practices to ensure high-quality code, minimizing defects and reducing maintenance efforts.

Education

Post Graduate Diploma - Data Analytics

MIT
Manukau, NZ
08.2024

Bachelor of Science - Computer Science & Pure Mathematics

Ain Shams University
Cairo, Egypt
01.2001

Skills

  • Microsoft SQL Server (T-SQL), Oracle (PL-SQL), MS-Access, PostgreSQL
  • All SQL variants (DDL, DML, SQL), Database Scripting programming (Stored procedures, Packages, Triggers, ), and SQL Tuning
  • SQL analytics, Data Migration, ETL, and transaction Management
  • Excel, and VBA on Excel development
  • Oracle Bi publisher, and Crystal report
  • Data modeling, MSBI, SQL Server Integration Services (SSIS), SQL Server reporting Services (SSRS), SQL Server Analysis Services (SSAS)', Power BI
  • Microstrategies, OBIEE
  • JIRA, and Confluence, Agile Application Development, team playing and leadership, and Communication skills
  • Analytical skills, Problem Solving, Incident analysis, and root cause investigation

Accomplishments

  • KAIZEN Endorsement, 2018
  • Internal Award
  • ITIL foundations certified, 2014
  • PMP Course / Training, 2014
  • Oracle University certificates, 2009
  • RETEK Retail Sales Audit (ReSA) 12 Fundamentals Ed 1 PRV. Oracle RETEK Allocation 12 Fundamentals Ed 1 PRV

References

  • Nezar Swaileh, Network Engineer - St John Ambulance services, eng.nezar@gmail.com, 022-023-0041
  • Deiaa Mohammed, Retail Application manager - Nahdi medical company, mohamed.de@nahdi.sa, +966 50 892 0023
  • Adel Alarabi, Development Manager - Attar trading Est., aalarabi@attarse.com, +966506683720

Hobbies and Interests

  • Swimming
  • Diving
  • Reading
  • Keeping pet birds

Timeline

SQL Developer

Ashnet
03.2019 - 11.2019

Lead BI Analyst

Nahdi Medical Company (Large Pharmacy Chain)
12.2016 - 10.2018

Senior SQL Developer / BI Analyst

Nahdi medical company (Regional largest pharmacy chain)
07.2011 - 11.2016

Intermediate Developer

Nahdi medical company (Regional largest pharmacy chain)
10.2008 - 06.2011

Senior Developer

Attar Trading Est (IT solution provider)
10.2004 - 09.2008

Post Graduate Diploma - Data Analytics

MIT

Bachelor of Science - Computer Science & Pure Mathematics

Ain Shams University

Similar Profiles

CREATE PROFILE
Mohammed Abdullatif