概要

Experienced Professional having more than 05years of experience in IT Industry with 4 year extensive experience in DBMS/Data warehousing and Business Intelligence. I have worked on different Oracle Tools like OBIEE 11g (BI Admin Tool for data modeling, BI Answer's for analysis and designing the dashboards),Developed the data warehouse using star schema,Experience in ETL development using ODI.

项目

Design and Development of Data Warehouse
eARMS Business Intelligence - Confidential

工作经历

公司标识
Assistant Manager | Business Intelligence
Sapphire Finishing Mills Limited
Jun 2017 - 代表 | Lahore, Pakistan

Catering all data/report/analysis/information needs of internal and external stakeholders
• Supporting Commercial Decisions with data and facts on Daily/Weekly/Monthly basis to devise efficient and effective strategies
• Development of Dashboards for senior management which support them in tracking company performance and taking corrective actions
• Analyze services for identification of revenue loop holes to stop revenue leakages and enhance revenues
• Ensuring coherence in the monthly revenue reports submitted by the different business units and consolidation of the same to compare against KPIs and projections
• Identifications of high revenue potential customers for cross selling of services
• Ensuring monthly revenue reports delivery to all business partners as per contractual terms
• Working with various internal teams involved in projects and ensuring successful completion and delivery
• Bridging the gap between technical and commercial teams by communicating the requirements
• Post development service business logic testing to ensure compliance with the set quality standards
• Formal escalation of any bugs found in service business logic and ensuring the resolution in a timely manner
• Automation of regularly required reports and analysis to ensure timely and smooth delivery
• Providing trainings to new hires for business domain and content reporting

公司标识
Technical Consultant BI/DW/ETL
Inbox Business Technologies (Pvt) Ltd.
Sep 2014 - 代表 | Karachi, Pakistan

• Working on Business Intelligence Applications Oracle Business Intelligence (OBIEE) and
ETL (ODI)
• Building Executive Dashboards using OBIEE.
• Data Modeling design, analyze and implement - conceptual, logical and physical
data model, Data conversion, Data integration specialization in the area of Data Warehouse
and Business Intelligence.
• ETL using Oracle Data Integrator facilitate Extraction Transformation and data
Load from OLTP systems to OLAP systems.
• Involved in Creation of dimensional relational data models with Dr. Ralph
Kimball Methodology i.e., Star schema and Snowflake schema.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production
Problems by reviewing design changes made to production systems and made corresponding
changes to OBIEE Repository.
• Dashboard, Analysis security
• Multi user development environment(MUD) configuration
• System management tools like Weblogic ,Enterprise management and Catalog Manager.

Tools:
• Oracle Business Intelligence Enterprise Edition 10g/11g
• BI Admin Tool
• BI Answers
• Oracle 10/11g Database
• Oracle Data Inegrator

公司标识
IT Exective
Fauji oil Terminal& Distribution company
Sep 2013 - Sep 2014 | Karachi, Pakistan

学历

Quaid-i-Azam University
硕士, 科学硕士学位, Information Technology‎
Computer Software
所占比重 69%
2013

技能

熟练 Business Intelligence
熟练 Data Migration
熟练 Data Warehouse Architecture
熟练 Database Design
熟练 Database Modeling
初学者 LTN
初学者 MSQL
熟练 Oracle
中级 Oracle SQL Developer
熟练 PL and SQL
初学者 Visio
初学者 Windows

语言

熟练 旁遮普语
熟练 英语
熟练 乌尔都语