Scribd Logo
Upload

Welcome to Scribd!

    • 24 views

    Tariq - Ali - Business Analyst

    Uploaded by

    Tariq Ali
    Tariq Ali has over 6 years of experience in business intelligence, data warehousing, and analytics. He has designed and developed data warehouse solutions using Oracle and Microsoft technologies. Currently he works as a Business Intelligence Analyst at Sapphire Finishing Mills Limited where he maintains their BI systems and creates dashboards, reports, and analyses.

    Copyright:

    © All Rights Reserved
    Download as RTF, PDF, TXT or read online from Scribd

    Tariq - Ali - Business Analyst

    Uploaded by

    Tariq Ali
    24 views4 pages
    Tariq Ali has over 6 years of experience in business intelligence, data warehousing, and analytics. He has designed and developed data warehouse solutions using Oracle and Microsoft technologies. Currently he works as a Business Intelligence Analyst at Sapphire Finishing Mills Limited where he maintains their BI systems and creates dashboards, reports, and analyses.

    Original Title

    Tariq_Ali_Business Analyst

    Copyright

    © © All Rights Reserved

    Available Formats

    RTF, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Tariq Ali has over 6 years of experience in business intelligence, data warehousing, and analytics. He has designed and developed data warehouse solutions using Oracle and Microsoft technologies. Currently he works as a Business Intelligence Analyst at Sapphire Finishing Mills Limited where he maintains their BI systems and creates dashboards, reports, and analyses.

    Copyright:

    © All Rights Reserved
    Download as RTF, PDF, TXT or read online from Scribd
    Download as rtf, pdf, or txt
    24 views4 pages

    Tariq - Ali - Business Analyst

    Uploaded by

    Tariq Ali
    Tariq Ali has over 6 years of experience in business intelligence, data warehousing, and analytics. He has designed and developed data warehouse solutions using Oracle and Microsoft technologies. Currently he works as a Business Intelligence Analyst at Sapphire Finishing Mills Limited where he maintains their BI systems and creates dashboards, reports, and analyses.

    Copyright:

    © All Rights Reserved
    Download as RTF, PDF, TXT or read online from Scribd
    Download as rtf, pdf, or txt
    of 4

    Tariq Ali Contact Info

     +923037122746
    Business Intelligence Analyst at Sapphire Finishing
    ✉ [email protected]
    Mills Limited
     Eden Lane Villas-2
    An Innovative Professional with analytical mind having more than 6 years of extensive
    Lahore, Pakistan
    experience in Data warehousing and Business Intelligence, Designed and Developed
    different data warehouse solutions using Oracle and Microsoft Technology stacks.
     Awards
     Strengths & Skills Certificate in Computer Application | 20
    Other Business Intelligence 08
    ✔ KPI ✔ Data Warehousing
    ✔ OBIEE
    ✔ ODI
    ✔ Requirement Analysis
    ✔ ETL
     Industries
    Mining/Oil & Gas/Petroleum
    ✔ Oracle ✔ SQL
    Consultants
    ✔ Performance Tuning ✔ Data Modeling Information Technology
    ✔ PL sql ✔ Reporting Warehousing
    ✔ POWER BI
    ✔ Business Intelligence
    ✔ Dashboards * Functional Areas
    ✔ DAX Accounts, Finance & Financial Services
    ✔ SCORECARDS Manufacturing
    Sales & Business Development
    Supply Chain Management

     Academics
     Languages
    MIT / Quaid-i-Azam University 2013
    Urdu - Native
    Punjabi - Native
    B.COM (IT) / University of the Punjab 2011
    English - Medium

     Certifications  Hobbies
    Watching Movies
    Certified Vulnerability Assessor Starting Oct 2019 Internet Surfing
    MILE2

    Microsoft Certified Professional Starting Aug 2014


    Microsoft

     Experience 6 years
    Sapphire Finishing Mills Limited 3.3 years Jun 2017 - Present
    Business Intelligence Analyst

    Inbox Consulting (Pvt) Ltd. 2.8 years Sep 2014 - Jun 2017
    Technical Consultant

    FOTCO (Fauji Foundation) 1 year Sep 2013 - Sep 2014


    IT Supervisor

     Projects
    Sapphire Business Intelligence (Sapphire Finishing Mills Limited)
    OBIEE, Oracle, BI Administration Tool, POWER BI

    Business Intelligence System (Inbox Business Technologies (Pvt) Ltd.)


    Oracle Data Integrator, OBIEE 11G

    Database and ERP Installation and Configuration (FOTCO (Fauji Foundation))


    SQL Server 2005
     Work History
    Sapphire Finishing Mills Limited Jun 2017 - Present ( 3.3 years)

    Business Intelligence Analyst Lahore, Pakistan

    Installation of OBIEE and ODI on Windows and Linux Environment.


    Installation and Configuration of Power BI
    Working with Power Pivot, Power Query, and Power
    View Working with Power BI Desktop, Service and
    Mobile. Measures calculations using DAX.
    Workspace Management.
    Dimensional modeling using Star and snow flake schemas.
    Extract Data from different sources and Load it into Data warehouse.
    Creation of Cubes and Ad hoc queries.
    Automation of regularly required reports and analysis to ensure timely and smooth
    delivery
    Designing and developing various Interactive Dashboards, KPI Analysis and reports with drilldowns, guided navigation, filters and
    prompts
    Creation of Users and Groups and management of Dashboards and Data Level Security.
    Creation of Hierarchy and Drill down reports.
    Handling day to day operational issues related to OBIEE, POWER BI &ODI
    Monitoring and troubleshooting ETL load Plans.
    Performance tuning of SQL Queries and analysis.
    Creation of Views, Procedures, Functions and other Objects.
    Deployment of Catalog, RPD and Users security from Development to Production Environments.

    Inbox Consulting (Pvt) Ltd. Sep 2014 - Jun 2017 ( 2.8 years)

    Technical Consultant Karachi, Pakistan

    Works closely with the business and IT application owners to understand, document and design ETL processes and needs.
    Participates in the defining, development and implementation of data warehouse and data mart databases and their content.
    Develops and maintains mapping logic to move data content from varied sources systems to the data warehouse and data marts.
    ETL and data conversion design / implementation for other data integration scenarios.
    Design, Develop, Test, Optimize and Deploy ODI packages and Oracle stored procedures / packages to perform all ETL related functions.
    Plan and coordinate ETL and database roll-outs with project team members, development and database engineers.
    Provide support, maintenance and issue investigation and resolution for ETL processes.
    Creating Analysis, KPIs and Dashboards using Oracle BI Answers and OTBI
    Created Oracle Tables, Views, Constrains, Procedures
    Data warehousing Development and Implementation
    Segregate data in form of Facts & Dimensions
    Data Modelling and Stars Schema
    MUD Administration

    FOTCO (Fauji Foundation) Sep 2013 - Sep 2014 (1 year)

    IT Supervisor Karachi, Pakistan

    Maintain, update and monitor the existing database on daily basis


    Troubleshoot all kinds of software/database related issues
    Create Tables, Databases, Views and Users
    Install, configure and maintain MS SQL Server 2000 and 2005.
    Assisting with database design and data model decisions
    Maintain and debug the existing ERP & HR Payroll System
    Reports according to User requirement
    ERD Models using rational rose and MS Visio
    Extract Data on demand
    DATA Management and backup planning

     Projects
    Sapphire Business Intelligence Jun 2017 - Present (3.3 years)

    Company: Sapphire Finishing Mills Limited / Sapphire


    Tools: OBIEE, Oracle, BI Administration Tool, POWER BI
    Reconciliation and correction of the existing Business Intelligence System
    Creation of the New Dashboards and reports
    Redesigned Database Modeling and Architecture of the System

    Business Intelligence System Sep 2014 - Jun 2017 (2.8 years)

    Company: Inbox Business Technologies (Pvt) Ltd. / Confidential

    Tools: Oracle Data Integrator, OBIEE 11G

    Database design and ETL strategies for the enterprise data warehouse
    Data modelling on OBIEE, physical, logical and presentation layers
    Implementation of data, dashboards and KPIs security w.r.t user, user groups and roles
    Creation of multifaceted and dynamic data analysis hierarchies for the entire army
    Writing of complex SQL queries for data transformation and ETL
    Source data profiling to devise appropriate ETL design and transformations
    Devised a development methodology to generate warehouse schema based on business views

    Database and ERP Installation and Configuration Nov 2013 - Dec 2013 (1 month)

    Company: FOTCO (Fauji Foundation)

    Tools: SQL Server 2005

    Installation and Configuration of ERP and Database System


    Database Users Creation and Configuration

    You might also like