Umar Jammad Email & Phone Number

Abu Dhabi, United Arab Emirates

Karachi, Pakistan

Implementation of Oracle Utilities Analytics Customer Care & Billing for USAID Power Distribution Program at Peshawar Electric Supply Company (PESCO) • Working with the Oracle Utilities Analytics (OUA 2.5.1) Team for Installation, Configuration, Data Integration, develop Dashboards/Analysis based on the below mentioned products - Oracle Business Intelligence (OBIEE)- Oracle Data Integrator (ODI), Oracle Golden Gate (OGG)- Oracle Utilities Customer Care & Billing-… Show more Implementation of Oracle Utilities Analytics Customer Care & Billing for USAID Power Distribution Program at Peshawar Electric Supply Company (PESCO) • Working with the Oracle Utilities Analytics (OUA 2.5.1) Team for Installation, Configuration, Data Integration, develop Dashboards/Analysis based on the below mentioned products - Oracle Business Intelligence (OBIEE)- Oracle Data Integrator (ODI), Oracle Golden Gate (OGG)- Oracle Utilities Customer Care & Billing- Involved in Full project life cycle (from requirements gathering to implementation phase).- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlined the proposed solution. - Designed and developed Metadata Repository (.rpd) that consist of physical layer, business model / layers with aggregates, dimensions and dimensional hierarchies, presentation layer with catalogs & folders using Oracle BI Administration tool.- Created various BI Publisher reports on top of BI Answers and aligned them on various dashboards as per the requirement.- Responsible for implementing Data-level security and Object-level (Dashboards/Reports) security among users, groups and web-groups.- Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views and managing Cache etc. Show less

Karachi, Pakistan

- Effectively communicate with Business Users and Stakeholders and Understanding the new functional and technical Specifications.- Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.- Have written complex "ETL Routines" & performed "Performance Tuning" of complex SQL/PLSQL Queries, Procedures & Processes.- Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.- Created different… Show more - Effectively communicate with Business Users and Stakeholders and Understanding the new functional and technical Specifications.- Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.- Have written complex "ETL Routines" & performed "Performance Tuning" of complex SQL/PLSQL Queries, Procedures & Processes.- Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.- Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.- Created numerous executive level reports. 'Dashboards' were generated to provide insight into the data.- Added users and configured security in web logic console of OBIEE 11g.- Managed security privileges for each subject area and dashboards according to user requirements- Customize OBIEE. Show less

Developed Forms and reports to support the implementation Oracle E-Business Suite R12 SCM (Supply Chain Management).* Involve in AS-IS process for gathering Client requirements as functional consultant.

Karachi, Pakistan

• To develop and manage the Software using Oracle 6i / 10g Database, Oracle 6i / 10g Form Developer, Oracle 6i / 10g Report Developer, Toad etc• Develops modifications or enhancements to existing application systems programs to meet user needs or system design changes.