Project Oracle

Title:DB*/Oracle Consultant

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

Document

Source below

Name: Shahid Rashid

Phone: 905-***-****

E_mail ********@*******.***

Training: SAP R3 BW and SAP R3 BASIS

Completed 6 month training at a MLC Solution Consulting Inc.

Companys Name: Canadian Imperial Bank of Commerce

From: April 10, 2005

Environment: DB2 V7.2.4 and DB2 V8.22, Data Warehouse,

Oracle 9i and 10g, RAC, RMAN, OEM on AIX 5.1 &AIX 5.2

Title:

DB2/Oracle Consultant

Working in the production support role for the CIBC Mortgage Division to support and

enhance the production Oracle OLTP system and DB2 Data warehouse systems.

* Planned DB2/Oracle installations and upgrades.

* Analyzed existing ETL processes for the data warehouse and suggested improvements for

the ETL processes.

* Designed and developed scenarios to perform the full QA in the UAT environment.

* Developed the checklist to perform the tests in the production environment as part of

the production server software or application upgrades.

* Wrote UNIX shell scripts to automate or improve DW ETL load processes.

* Worked on the performance tuning issues.

Companys Name: IBM

Canada

From: January 10, 2005

to April 8 25, 2005

Environment: DB2 V7.2.4 and DB2 V8.22, Data Warehouse

Title:

DB2 Consultant

Quality Assurance

Duties:

* Planed and managed a project to migrate DB2 V7.2.4 FP6 environment to DB2 V8.22 FP8

environment.

* Converted Type 1 Indexes to Type 2 Indexes.

* Developed complete test scenarios to perform QA for the upgrade process.

1. The testing included full application testing.

2. Testing all other software components installed on the server i.e. Websphere, DB2

client software etc.

* Performed full QA on the UAT server, before migration was performed on the production

server.

* Created a checklist to be used by QA personnel in future testing.

* Setup test server.

* Wrote UNIX shell scripts to automate existing processes.

* Documented conversion process and the test results.

Companys Name: Manulife Financials

From: June1, 2004

Dec. 21, 2004

Environment: Oracle 8.1.7/9.20, AIX 5.0, Siebel Systems

Title:

Oracle Consultant

-

Duties:

* Setup and maintain Siebel Oracle Databases.

* Define, design and implement new and existing database structures and environments.

* Design and implement conversion strategies.

* Designed and implemented QA test scenarios to implement applications and software

upgrades.

* Wrote UNIX scripts to automate and improve processes.

* Control and coordinate changes to the database, including deletion of records, addition

to the database and compliancy.

* Develop and implement procedures that will ensure the accuracy, integrity,

completeness, and timeliness of data stored in the database.

* Develop and implement security procedures for the database, including access and user

account management.

* Advise programmer, analysts and user about the efficient use of data.

* Perform and coordinate updates to the logical and physical database design.

* Participate in the modeling activities and provide input into the development of the

logical and physical diagrams.

* Develop and coordinate backup, disaster recovery procedures.

* Provide solutions to complex database problems or to specific design constraints.

* Conduct database performance and tuning review.

* Determine database disk requirements.

* Load and unload data.

.

Companys Name: McDonalds Canada

From: January 27,2004 End Date: May 15 2004

Environment: DB2 7.2, AIX 5.0, Data Warehouse, C programming and shell scripting

Title:

DB2 Consultant

Worked on the Information Warehouse improvement project to improve existing Information

ware processes and create new processes if required.

* Wrote C programs with embedded SQL.

* Design and implemented conversion programs.

* Designed and implement new ETL process.

* Designed and implemented QA process to implement application changes and software

upgrades.

* Developed UNIX scripts to automate and improve processes.

* Created the new development and the test environments.

* Lead the project to design and implement new security procedures to secure the DB2

database environment.

* Advised the development team about the efficient use of data.

* Participated in logical design activities.

* Provided solutions to complex database problems.

* Conducted performance and tune up reviews.

Companys Name: IBM

Canada

From: October 1, 2003 End Date: January 26,2004

Environment: ERWIN, EXCEL

* Participated in the modeling activity to develop a logical and the physical data model

for a project for the TD /Canada Trust bank. For this IBM Canada project provided input

during the design process and then used ERWIN to create the data models.

Companys Name: Ministry of Consumer and Business Affairs; ONVIP (Ontario Vital

Statistics Improvement Project

)

From:

September 16, 2002

September 30, 2003

Position: Lead Application DBA

/Data Modeler and ETL (Extraction Transformation and Load)

Developer

Environment: Oracle 8.1.7/9.0.2, PL/SQL, J2EE, Web Sphere, ERWIN

Lead the ETL project to convert the Government of Ontarios Registration Applications

data from the IBM-390 IMS/ADF based system to the WEB/Oracle 8.1.7/9.0.2 Sun Solaris 2.8

based system.

* Defined and created the new database structures.

* Identified requirements to create the new ETL processes.

* Defined and implemented conversion strategies to convert the old legacy mainframe IMS

databases to the new Oracle tables.

* Developed and implemented the security procedures.

* Wrote PL/SQL procedures to convert data.

* Advised the development team about the efficient SQL code and efficient use of data.

* Wrote shell scripts to automate conversion process.

* Created and maintained many different development environments.

* Upgraded Oracle 8.1.7 to Oracle 9.0.2.

* Developed and coordinated backup and recovery procedures.

* Provided solutions to complex database problems.

* Reviewed and made recommendations on physical database design.

* Loaded and unloaded data.

* Planed and implemented conversion strategy.

Companys Name: Manulife Financials; Integrated Financial System Project.

From:

October 2000

-October 31 2002

Position: Senior Database Administrator

Environment: Lawson Financials, UDB 7.2, Oracle 8.1.7, PL/SQL, Data Warehouse, Web

Sphere, ERWIN, AIX 4.3, Hp Unix 10.20.

* As the key member of the development team, participated in the project to implement the

integrated financial system, using state of the art technologies.

* The financial systems were converted from the IBM mainframe based GEAC system to the

state of the art client/server based technologies using LAWSON application on AIX version

4.3, UDB/DB2 version 7.2 fix pack 5.

* Total storage used for the database is 1.2 terabytes. Suspense application was

converted from the mainframe to the TRECS system using AIX 4.3, and ORACLE 8.1.7.

* Accounts Payable was converted from Lawson A/P on Oracle 7.3 to UDB 7.2.

Company

s Name: Lucent Technologies

From: October 1999

To: June 2000

Position: Senior Consultant

IMS and Oracle based billing systems was converted to a 7*24 system.

Company

s Name: Bombardier Inc

.

From: November 1987

- September 1999

Last Position Held: Senior Database Administrator

Environment: Oracle 8.0.5, Informix 7.3, IMS 5.0

* Oracle, Informix, DB2, IMS production DBA 7*24 support.

* Responsible for backup, recovery and reorganization of the IMS databases.

* Install and upgrade Oracle and Informix software and apply patches if required.

* Create, maintain, monitor and support and tune IMS, Oracle and Informix instances.

* Create and maintain data models and data glossaries.

* Provide security at the database level.

* Plan and implement software upgrades.

* Documentation

Companys Name: Dorothea Knitting Mills.

Don Mills Ontario

.

Position: Programmer Analyst

Date Employed: March 1977

- November 1987

Writing and maintain COBOL programs for GL, AP and AR and Shipping applications.

Education:

* Bachelor of Science Degree

with the Mathematics as the major subject.

* Post Graduate Diploma

in Computer Systems and Programming.

Contact this candidate