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
Skills
Data & Analytics
Development Tools
Others
Database
Programming Language
Web Development
Software Engineering
Positions
Portfolio Projects
Company
Implementation of Microsoft Power BI Report Server in Abu Dhabi – UAE (On-Site)
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
Skills
Power BITools
Sql server 2013Company
Corrective and Preventive Maintenance Report for Microstrategy - Kuala Lumpur, Malaysia (On-Site)
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.
Skills
MicroStrategyTools
MicrostrategyCompany
eARMS Business Intelligence (OBIEE 11g Implementation in Pak Army)
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 LessSkills
ObieeTools
OBIEECompany
Mobilink, Lahore Pakistan - Implementation of OBIA (BIApps)
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
Skills
BIAPPs-OBIATools
BIAPPs-OBIA