Project Engineer

Postal Address:

Amir Riaz ***/B Jinnah Park Tehsil Road

Gujranwala, Pakistan

Phone: +92-55-427****

Mobile: +92-302-*******

Email: ****.****.***@*****.***

********@*******.***

Father’s name Riaz Ahmed

Summary

Skills

• Database: Oracle 11g , Oracle Exadata V2

• Clusters: Oracle Rac cluster and Sun cluster 3.1 with HA configuration

• Tuning Skills: Performance tuning skills of huge warehouse database size +25TB.

• Programming Skills: Oracle PL/SQL, Oracle SQL analytics and java Programming

• BI reporting tools: Oracle Business intelligence enterprise edition (OBIEE)

• Operating System: Sun Solaris 10, Linux

• ETL Tools: Oracle Warehouse Builder 11g, Oracle data integrator 11g

• Architectural Skills: Design, cube, dimension, Fact and ETL procedures and data

• Base system Architectures,

• Business Domain: Telecommunication, OSS/BSS processes with

• Speciality in telecommunication data warehouse. I know

• Mediation, Provisioning, activation, billing, rating in

• telecommunication domain

Projects Summary

Project name: Atheer BI, Company: MTC Telecom, this was a huge project and was under development from last 4 years. The project was architected with oracle 10g RAC cluster with Oracle Discoverer as reporting tool. I worked on this project as Senior Software Engineer and my duties were to create its architecture, Write modules to convert MSC‘s CDRs (call detail records) to normalized form and validate them before loading them into data warehouse. I also worked on its reporting system developed in OBIEE 10.1.3.3

Worked with Zain Group Bharin Project Named Matrix using state of art technologies like Oracle 11g, OWB and OBIEE. I Designed the project architecture and database design. The project collects data from 22 Telecom Operation Areas and loads it into a central data warehouse. Since data comes in different formats, therefore, it’s a big challenge to convert it into one format for its proper loading. My duties in this project were to design the architecture for data integration, suggest solution for data integration, suggest hardware and software specifications, direct development teams in write ETL jobs, suggest performance matrixes for DBAs. I designed it reporting architecture using SOA and OBIEE 10.1.3.4.1 and with weblogic server. The report system has HA architecture with a load balancer

Worked with Zain Africa(Nigeria) With Oracle Corporation on projects named OMKS (oracle mobile knowledge solution) using state of art technologies like OWB, OBIEE ,oracle RAC cluster and oracle application server. The project was developed by Oracle corporation and i participated in its performance tuning and UAT. I also trained Zain Africa team in data warehouse management and OSS/BSS business procedures.

Worked with Net Pace Karachi on project named Touch Stone investigation Portal, It was a very complex ERP project. I designed its database according to the business process. I also designed its architecture. My designation in this project was Senior Oracle database designer.

I also, Worked with our clients as an outsourced consultant on Oracle Exadata v2 and help them in telecom data management and performance tuning procedures. I participate in POC and POV and provided clients consultancy with Oracle Exadata and Netezza technology selection.

I have a band score of 6.5 in British Council IELTS. With 6.0 or above in all four modules

Qualifications

M.sc In Software Engineering (2001-2003)

CGPA: 3.47/4.0

Institute name: Punjab University Lahore, Pakistan

Description: The course contains Software Project Management (SPM), Component Based Design (CBD), Distributed Database

M.sc in Applied Mathematics (1994-1996)

Percentage: 54%

Institute name: Punjab University

Oracle Certified Professional DBA Track

Institute name: Punjab institute of technology board.

Year: : 1999 to 2000

Profession Experience • Organization Digital Processing System, Islamabad

• Organization Type Software House

• Designation Senior Software Engineer

• Location Islamabad, Pakistan

• Tenure August 2008 To July 2010

• Organization Board of Land and Revenue, Punjab Lahore

• Organization Type Government ( collaboration with NCR)

• Designation Computer programmer

• Tenure January 2006 to August 2008

• Organization Netpace Private limited, Karachi

• Organization Type Software House

• Designation Senior database Designer

• Location Karachi, Pakistan

• Tenure February 2005 to August 2005.

• Organization Softmatics Private Limited, Lahore

• Organization Type Software House

• Designation Java/Oracle Developer

• Location Islamabad

• Tenure Dec 2000 To Jan-2004

Professional

Projects

Details

Project Title Matrix

Company Digital Processing System

Designation Senior Software Engineer

Responsibilities

Project was developed in Oracle warehouse builder 11g and OBIEE 10.1.3.4.1 using Oracle 11g. It is a two node RAC cluster in oracle and two node Failover cluster (Sun cluster 3.2) with network load balancer. My responsibilities in this project includes

• Designed and develop the whole project architect. I not only designed the above architecture but also deployed it. The project deployment has to be certified by Sun Microsystems before its been declared fit for production

• Develop the data integration module in Java inside the Oracle 11g database to translate data from 22 OPCOs in a single format to facilitate data loading procedure.

• Deploy OBIEE with Oracle application server using HA cluster configuration

• Write shell scripts to perform different data cleansing tasks and for pulling data from FTP server

• Performing complex tasks of Oracle parallel processing tuning (Parallel SQL tuning) when required

• Perform OWB administration, like creating OWB users, create TCL scripts to automate release management from development to product and assist OWB developers in training and development.

• Develop plans to coordinate activities between offshore teams and in house team

Project Title Oracle Mobile Knowledge Solutions (OMKS)

Company: Digital Processing System

Designation Senior Software Engineer

Location Nigeria (Africa)

Responsibilities

OMKS is being developed and implement by Oracle corporation. I worked with Oracle Team as a outsourced resource and worked on Oracle warehouse builder, Oracle 11g Performance Tuning and OBIEE administration and performance tuning

Analytical Duties

Analyze from Start to end Data-Warehouse Development procedure using OWB (Complete Lifecycle) and device a policy to assist better coordination between development and DBA teams. Assisted in Enterprise Data-Warehouse Maintenance & Change Management.

Performance Tuning of ETL

Performed mappings and jobs optimization, in order to reduce the execution time of the Data warehouse batch. The batch, before optimization took 20-22 hours to complete, after optimization the batch execution time has been reduced to 6-8 hours.

Reports optimization

The Business Intelligence Reports were taking 40-60 minute/report on average to execute. Each of the Business Intelligence Reports was analyzed and was optimized accordingly. After optimization, the execution time was reduced to 2-3 minutes for a report to show up.

Project Title: Cendant Car Rental system

Company: Digital processing System

Designation: Oracle Performance Tuning Engineer

Responsibilities.

• Rewrite the SQL with Analytics to enhance database performance.

Perform performance tuning of C++ code module to run SQL with optimum performance

Project: MTC Atheer Billing System

Company: Digital Processing System

Designation: Team Lead

Responsibilities

• Develop Java application program to convert Raw Binary CDR ( call detail records) to normalize form to enable them to be loaded into warehouse

• Write custom code to automate the processing of remote file pulling and pushing procedures

• Write shell scripts to automate the task of file filtering and distribution between different warehouse node

• Coordinate data validation activates with ITS ( international turkey system)

• Oracle Database SQL and Hardware optimization •

Project: Touch Stone investigation Portal

Company: Netpace Private Limited Karachi

Designation: Senior database designer.

Responsibilities

• Design ERP database according to business process

• Perform change management activity in design and database

• Deploy oracle 9i database and application server.

• Take database backup on daily basis

• Write PL/SQL trigger for auditing database.

• Write Complex SQL(SQL analytics) to facilitate developers

• Perform Linux Administration

Tool Skills

• Software Engineering Tools:

• IBM Rational Rose 7.0,

• Erwin,

• Toad.

• Languages and Database Tools

• Java

• Oracle PL/SQL 11g

• Oracle 10g/11g,

• Oracle warehouse Builder 10g and 11g

• Unix Shell Scripting (bash, ksh),

• Oracle Business Intelligence Enterprise Edition 3.1.4.1

• Oracle application server(web logic)

• Cluster warehouse Technologies

• Oracle cluster ware 11g

• Sun cluster 3.2

•

• Operating Systems

• Windows 2000 server, Red Hat Linux , Solaris 10, Solaris Volume Manager

Languages English

Scored a band of 6.5 in British Council IELTs.

Speaking: 6.5

Listening: 8.0

Writing : 6.0

Reading : 6.0 Urdu

Urdu is my national Language, I can speak, listen, read and write in it with excellence

Contact this candidate