Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Adnan Salim

Karachi

Summary

With over 17 years of experience as a Business Intelligence and Analytics Specialist, I have honed expertise in data analysis, visualization, and strategic development of BI road maps. My skills encompass OLAP models, data cubes, ETL processes, and stakeholder management, with a keen focus on driving business growth through data-driven strategies. As a professional adept at BI support and team leadership, I continuously deliver insightful business commentaries and dashboard solutions.

Overview

21
21
years of professional experience
1
1
Certification

Work History

Business Intelligence Consultant

Various Assignments (The Good Climate, Inseyab, Pixelpk, Tkxel, Team Hawks)
05.2021 - Current
  • Consulting on business intelligence projects in Pakistan and the Gulf Cooperation Council countries.
  • Crafted intricate data models using DAX scripting and SQL for comprehensive analysis and data manipulation.
  • Developed and optimized interactive dashboards and reports in Power BI.
  • Integrated Azure Maps for geospatial data analysis.
  • Handled data quality issues, utilizing ETL architectures.
  • Drafted strategic business intelligence road maps and created data analysis tools.

Business Analyst

IBEX Global
05.2020 - 04.2021
  • Focused on BI projects, ensuring data quality and enhancing strategic decision-making tools.
  • Managed BI next generation project for sales analytics.
  • Streamlined development of BI architecture using Tableau.
  • Conducted data quality checks and ensured consistency of data.
  • Participated in dashboard design and performance tuning.
  • Validated sales data using advanced Excel functions.

Oracle Technical Consultant

Integration Xperts
08.2018 - 06.2021
  • Provided technical consultancy, focusing on Oracle ERP Cloud.
  • Delivered technical solutions, integrations, and data migrations on Oracle ERP Cloud.
  • Developed queries and stored procedures to support BI visualizations.
  • Handled migration of ERP data and HCM integrations.

Techno Functional Consultant

Various Assignments (Reportbrain, Itim Systems, Tech Exons)
07.2014 - 07.2014
  • Consulted on MIS reporting and client management projects.
  • Managed client relationships and translated requirements for software teams.
  • Developed MIS reporting integrated with ERP systems.
  • Implemented AI and NLP solutions for clients.

IT Consultant

Ammartech
01.2011 - 07.2014
  • Focused on database development and IT consultancy.
  • Supported in database development and QA.
  • Developed IT policies and conducted risk assessments.
  • Generated MIS reports and provided application support.

IT Support Engineer

Various Assignments
01.2007 - 01.2011

Provided IT support and development in various environments.

  • Diagnosed and resolved hardware and software issues for end-users across various platforms.
  • Implemented IT support ticketing system, enhancing tracking and resolution efficiency.
  • Conducted regular system audits to ensure compliance with security protocols and best practices.
  • Trained and mentored junior support staff, fostering knowledge sharing and skill development.
  • Resolved IT issues and supported staff via RDP and other tools.
  • Handled BAU support and development.
  • Performed regression tests and maintained test scripts for store systems.

Trainee and IT Auditor

Various Assignments
10.2004 - 09.2006

Involved in IT consulting and audit tasks.

  • Assisted in daily operational tasks to ensure smooth workflow and efficiency.
  • Supported team members by providing timely assistance and resource allocation during peak hours.
  • Adapted quickly to new tools and systems, enhancing overall team productivity.
  • Participated in training sessions to learn safety protocols and best practices for the role.
  • Upgraded hardware and software for BP Passport OS.
  • Provided technical support and data migration.
  • Worked on IT security and audit tasks.

Education

Master of Arts - Finance, Accounting & Management

University of Bradford - School of Management
03.2008

Bachelor of Science - Computer Science

Shaheed Zulfikar Ali Bhutto Institute of Science & Technology
08.2005

Skills

    Data & Cloud Engineering

  • AWS & Cloud - AWS (Amazon Web Services), Data Lake, S3 (Simple Storage Service), Redshift (Data Warehouse), AWS Glue (ETL), Amazon EMR (Elastic MapReduce), Amazon Athena (Querying), Kinesis (Real-time Streaming), Lambda (Serverless Computing), CloudWatch (Monitoring/Logs), Step Functions (Orchestration), Managed Airflow (MWAA), AWS DMS (Database Migration Service), IAM (Identity & Access Management), VPC (Virtual Private Cloud), Azure, Cloud Computing
  • Data Core - Data Engineering, Data Pipelines, ETL Development, Data Integration, Data Warehousing, Data Modeling (Star/Snowflake Schema, Conceptual/Logical/Physical), Metadata Management, Data Governance
  • Database & Code - SQL, PL/SQL, PostgreSQL, Exasol, Query Optimization, Database Management, Stored Procedures & Functions, Python, Java, SOQL, REST/SOAP (Web Services), CI/CD Pipelines
  • Quality & Ops - Data Cleansing, Data Quality, Data Integrity, Data Migration, Quality Assurance, Data Security, DataOps, DevOps
  • Business Intelligence & Analytics

  • BI Tools - Power BI (Reports & Dashboards), DAX, M-Language, Tableau (Desktop, Server, Cloud), Tableau Prep Builder, Qlik Sense, QlikView, Google Looker Studio, Sisense, Amazon QuickSight
  • Reporting - OBIEE, OTBI (Oracle Transactional BI), BI Publisher (BIP/XDO Reports), Report Builder/SSRS, Financial Reporting Studio (FRS), Technical Reporting, Alerting
  • Analytics - Business Intelligence (BI) Analysis, Data Visualization, Statistical Analysis, OLAP Models, KPI Tracking, Performance Metrics, MIS Reporting
  • AI/ML - AI Engineering, Machine Learning (ML), NLP (Natural Language Processing), Predictive Solutions, ChatGPT Integration

    Oracle & ERP Systems

  • Oracle Fusion - Oracle ERP Cloud, Oracle Fusion Technical Consultant, Oracle EBS, HCM Extract, HCM Dataloader, Spreadsheet Loaders, ADI Integration, Oracle Atom & Rest Feeds
  • Functional - Oracle Financials, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Oracle HCM, Oracle Order Management, Oracle Purchasing, Accounting Principles
  • Utilities - SmartView, Financials Reporting Centre, Salesforce (Sales Cloud), ERP Systems
  • Architecture, Consulting & Strategy

  • Architecture - Solution Architecture, BI Architecture, Cloud Architecture, Distributed Systems, System Design
  • Leadership - BI Practice Lead, Pre-sales, Strategic BI Roadmap, Team Leadership, Mentoring, Technical Training
  • Consulting - Business Analysis, Requirements Analysis, Technical/Functional Specifications, Customer/Stakeholder Management, Financial Data Analysis, Forecasting
  • Methodology - Project Management, Agile, Scrum/Kanban, Change Management, ITIL, COBIT, Lean Methodologies, Risk Assessment, Quality Control

Certification

  • Oracle BI 11g R1: Create Analyses and Dashboards
  • Oracle BI 11g R1: Build Repositories.

Timeline

Business Intelligence Consultant

Various Assignments (The Good Climate, Inseyab, Pixelpk, Tkxel, Team Hawks)
05.2021 - Current

Business Analyst

IBEX Global
05.2020 - 04.2021

Oracle Technical Consultant

Integration Xperts
08.2018 - 06.2021

Techno Functional Consultant

Various Assignments (Reportbrain, Itim Systems, Tech Exons)
07.2014 - 07.2014

IT Consultant

Ammartech
01.2011 - 07.2014

IT Support Engineer

Various Assignments
01.2007 - 01.2011

Trainee and IT Auditor

Various Assignments
10.2004 - 09.2006

Bachelor of Science - Computer Science

Shaheed Zulfikar Ali Bhutto Institute of Science & Technology

Master of Arts - Finance, Accounting & Management

University of Bradford - School of Management
Adnan Salim