Adeel  S.

Adeel S.

Expert Business Intelligence with ETL & DWH (Oracle, Microsoft Power BI, MicroStrategy)

Karachi , Pakistan

Experience: 7 Years

Adeel

Karachi , Pakistan

Expert Business Intelligence with ETL & DWH (Oracle, Microsoft Power BI, MicroStrategy)

15360 USD / Year

  • Immediate: Available

7 Years

Now you can Instantly Chat with Adeel !

About Me

A Business Intelligence/ DWH/ ETL consultant with over 7+ years experience in business analysis, architecture, design, development, deployment & Management using Oracle, Microstrategy & Microsoft technologies.

Specialities:...

ETL Tools:


1) ODI 11g (Oracle Data Integrator)

2) SSIS,

3) SSAS

Databases: Oracle 10g / Oracle 11g, MS SQL Server, MYSQL

Languages: SQL, PL/SQL 

Show More

Positions

Portfolio Projects

Description

This project is for Department of Urban Planning and Municipalities in which there is an implementation of "Power BI Report Server" in Abu Dhabi – UAE (On-Site)

Responsibilities:
• Creating Data Models in Power BI Desktop for Data Modeling
• To develop reports, dashboards & provide end-to-end solution for OLTP.
• Developed reports & Dashboards for 4 modules:


1) Capital Projects, 2) Onwani, 3) Tawtheeq, 4) Real Estate on Power BI Report Server
• Alignment of the reports/dashboards on IPAD.
• Configured Power BI Maps
• Create Roles & implemented Security in Power BI Report Server

Show More Show Less

Description

It was a small project for a week for the "Ministry of Housing & Local Government Kementerian Perumahan dan Kerajaan Tempatan (KPKT)"

Responsibilities:
• Gathering Business requirements.
• Listed down all the issues and provide them solution how to resolve them
• Detailed documentation provided to client for Corrective and Preventive Maintenance Report for Microstrategy.

Show More Show Less

Description

Worked on Oracle Tools OBIEE 11g (BI Admin Tool for data modeling ,Users creation, Users security, BI Answer's for analysis and designing the dashboards), Oracle Data Integrator for data warehousing to implement the E-ARMS project (Logistic Management System integrated with E-Business Suite R-12)

Show More Show Less

Description

• Setup of ODI Environment.
• Creation of ODI objects like Interfaces,Variables,Procedures,Functions,Packages and other ODI objects.
• Working with ODI Scenarios,Load Plans and Scheduling.
• Creation of validation test scripts for BIApps.
• Customization on Oracle BIApps.
• Installing and Configuring the BIApps on single node.
• Working with BIACM.
• Data modeling and RPD designing using OBIEE & OBIA administration tool.
• Deployments of OBIA dashboards and analytic for SIEBEL CRM.
• Analyzed and ensured data integrity of reports from heterogeneous data sources.
• Integration of BIApps with SIEBEL CRM.
• Monitoring & Error resolution of ETL

Show More Show Less