Summary

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.

Projects

Design and Development of Data Warehouse
eARMS Business Intelligence - Confidential

Experience

Company Logo
Assistant Manager | Business Intelligence
Sapphire Finishing Mills Limited
Jun 2017 - Present | 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

Company Logo
Technical Consultant BI/DW/ETL
Inbox Business Technologies (Pvt) Ltd.
Sep 2014 - Present | 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

Company Logo
IT Exective
Fauji oil Terminal& Distribution company
Sep 2013 - Sep 2014 | Karachi, Pakistan

Education

Quaid-i-Azam University
Masters, Masters in Science, Information Technology‎
Computer Software
Percentage 69%
2013

Skills

Expert Business Intelligence
Expert Data Migration
Expert Data Warehouse Architecture
Expert Database Desigining Skills
Expert Database Modeling
Beginner LTN
Beginner MSQL
Expert Oracle
Intermediate Oracle SQL Developer
Expert PL and SQL
Beginner Visio
Beginner Windows

Languages

Expert Punjabi
Expert English
Expert Urdu