Software Engineer Oracle

Postal Address: Mobile: +614********

Unit ** causeway gardens, 45 Adelaide Email:

Terrace East Perth WA 6004 ****.****.***@*****.***

Father's Riaz Ahmed

name

Skills Over 12 Years of extensive experience in IT industry with over 8

years of experience with OBIEE, 4 Years of experience with

Informatica, DAC server and BI Apps. 2 year of exposure with

Oracle Data Integrator (ODI), 10 years' experience in performance

Tuning under ERP and Data warehouse Environments. Experienced in

Oracle Exadata X3-2 under banking domain with Oracle BI apps and

Financial Banking systems like Murex

Business Intelligence Tools Skills

OBIEE 10g/11g complete understanding and expertise.

Expert in Developing OBIEE Answers and Dash Boards and catalogue.

Knowledge of Oracle BI apps modules Financial and Viziya (EAM)

Expert in designing OBIEE security, authorization and

authentication

Expert in working obiee repository development.

Possesses the knowledge of Oracle Fusion Middle Ware with

clustering and Administration

ETL Skills.

Expert in Oracle PL/SQL Programmer

ETL tools: Infomatica / Oracle Data Integrator

Informatica optimization and performance tuning.

Detailed knowledge Of Oracle DAC server for Oracle BI apps.

Develop Data Quality and verification procedures.

Develop Package and Interfaces for Oracle Data Integrator(ODI)

Use ODI to write ETL Jobs for Heterogeneous and federated system

Database Skills

Oracle Exadata X2-2, architecture and complete internal working

knowledge

Teradata, SQL programming, Architecture and administration

Possess Knowledge of Exadata HCC, Push Down optimization,

Parallel processing

Experience working with Huge Oracle data warehouses, from Size

25TB to 40TB.

Expert in Oracle performance tuning using Autotrace, Explain

plan, Hints, Dynamic sampling, TKPROF

Expert in Oracle PL/SQL code reviews for Oracle Exadata with ODI

and Informatica.

Operating Systems.

Linux, Solaris 10, Windows

Shell scripting

Profession Organization I&A consultancy (Barrick Gold Australia)

al Designation Senior Oracle BI Apps Consultant.

Experience Tenure 1st March 2013 To May 2013

Oracle BI Apps Financial

Enterprize Asset Management (EAM)

Description:

Barrick Gold is one of the biggest Oracle apps implementation in

Australia. I worked with I&A as consultant to customized these

applications. The Apps contains following modules Financial,

cost management and Viziya (EAM). My duties contain, gather

requirements and develop and maintain solutions using

informatica, DAC and OBIEE.

Organization DBS Bank Singapore.

Designation Senior Software Engineer

Tenure December 2011 To 1st March 2013.

Projects

Financial Data Mart.

Project Description

Designed the Financial Data Mart for DBS bank taking data from

Murex and PSGL banking system and using it in OBIEE 11g and

Oracle 11G. I participated in complete design from database

design to repository design. Integration of EBS with Oracle BI

apps Financials. Tools Used Tools like OBIEE 11g, Informatica,

ODI, PL/SQL, DAC server and Oracle Exadata x3-2.

Organization Softmatics, Lahore Pakistan

Designation Senior Software Engineer

Tenure August 2010 To 30th Sep 2011

Professional Projects

[pic]

MTC Atheer

Zain Telecom Kuwait

Project Description

MTC ATheer is an OSS/BSS project used for fraud detection and

finance management and forecast. The warehouse takes CDR and

loads data it into database each night in batch mode as well as

in real time.

Responsibilities

Design and develop Data warehouse Schema, Facts and Dimension.

Develop ETL and perform performance tuning

Create OWB mappings and work Flow and Implement Change Data

Capture.

Design OBIEE 11g reports, dash boards and architecture

Organization Digital Processing System, Islamabad

Designation Senior Software Engineer

Tenure August 2008 To July 2010

Professional Projects

Zain Matrix

Zain Telecom Bahrain

Project Description

Zain Matrix was a Financial forecasting System for Zain Telecom,

Zain Matrix collects data from 8 different Data Marts situated in

Bahrain and Africa and run predictive analytic on them.

Responsibilities

Design and develop OBIEE 10G/11G Repository, Dash board and

Reports.

Write data integration module using Oracle Data integrator.

Create ODI mappings and work Flow and Implement Change Data

Capture.

Monitor Over all System performance and give suggestions.

Oracle Mobile Knowledge Solution (OMKS)

Zain Telecom Nigeria

Project Description

OMKS was a joint venture of Oracle India, Zain Telecom and

Digital Processing System, OMKS was a fraud detection and

Finance management system for Zain Nigeria, OMKS has a real time

reporting system, which was considered to be extremely

challenging

Responsibilities

Formulate requirements and translate them into data models for

reporting.

Set up back end and data structures for OBIEE 10G Logical

Layer.

Optimization of OBIEE - Answers, Delivers, BI Publisher

Performed ETL programming using Informatica 8.

Organization Board of Revenue, Punjab, Pakistan

Designation Computer Programmer

Tenure July 2005 to August 2008

Professional Projects

Land Record Management Information System

Board of Revenue, Government of Pakistan

Project Description

Government of the Punjab computerized the Land Records of Punjab

Province to improve service delivery and to enhance the perceived

level of tenure security. This Project was financed by World Bank

and the scope of this project was the whole Punjab Province.

Responsibilities

Instruct staff in "best practices"

Analyzed and extracted data from the PeopleSoft, perform

transforms and prepare for loading.

Implemented data warehouse using OBIEE 10g with Informatica 7.

Lead the team in performance Tuning and optimization

Organization Netpace, Karachi Pakistan

Designation: Senior Database Designer

Tenure February 2005 To July 2005

Professional Projects

Touch Stone investigation Portal

Cisco System, USA.

Project Description

Touch Stone Investigation Portal was a highly complex crime

investigation portal Cisco System uses to regulate crimes

internally inside their offices.

Responsibilities Integrate Touch Stone Portal with People Soft

CRM and HRMS modules to get required data. Design Touch Stone

Database according to Business requirements, Write PL/SQL

triggers for data auditing

Organization Softmatics, Lahore Pakistan

Designation Software Engineer/DBA

Tenure Dec 2000 To Jan-2004

Professional Projects

Finance Management System

ICI Pakistan, Agro Chemical

Project Description

ICI uses Finance management system for their yearly auditing and

for daily operations. The system acts as a centralized hub for

all the applications running in ICI.

Responsibilities

Deployed Oracle 8i database, wrote stored procedures in PL/SQL

and performance day to day database administration tasks,

Developed JSP pages using, Struts, Hibernate and Spring

Qualificat [pic]

ion M.sc Software Engineering (2001-2003)

CGPA: 3.47/4.0

Punjab University Lahore, Pakistan

Description

During the course, I studied Software Project Management,

Component Based Design (CBD), Distributed Database and Data

Warehousing Designing

.

[pic]

M.sc Applied Mathematics (1998-2000)

Percentage: 54%

Punjab University Lahore, Pakistan

Description

Topic of interest during study were, operation research,

computational mathematics, mechanics Final thesis was on

relational Algebra

[pic]

Oracle Certified Profession (DBA Track)

Oracle 9i, 10g Certified Professional

Languages

British Council English

Scored a band of 6.5 in British Council IELTs. Have scored 8.0 in

Listening and 6.5 to 7.5 in speaking.

Score Detail

Speaking: 6.5 Listening: 8.0 Writing : 6.0 Reading : 6.0

Other Languages

I also speak URDU, PUNJABI

[pic]

Amir Riaz

Expert Level (12+ year experience)

Oracle BI/Data Warehouse Consultant

Contact this candidate