MUHAMMAD ZEESHAN

Mississauga, Ontario 647-***-**** aca8if@r.postjobfree.com

PROFESSIONAL CAPABILITIES

. 8 years extensive experience of full cycle analysis, design, development,

testing, deployment & support of large scale mission critical enterprise

applications.

. Technical expertise in database back-end programming; Proficient in

Oracle Databases 8i/9i/10g/11g, Forms 6i/9i/11g, Reports 6i/9i/11g, SQL,

PL/SQL, T-SQL, SQL *Loader, Erwin, Toad, SQL Navigator, All Fusion

Harvest, Windows/ UNIX/ Linux environment.

. Strong technical expertise in Production support of operationally

critical, real time and high availability in house and vendor

applications.

. Strong experience in conducting UAT & documentation of test cases, test

scripts and manuals.

. Excellent interpersonal, communication and report writing skills.

Excellent team player, Self-motivated, able to prioritize multiple task,

detail oriented and meticulous. Strong analytical & problem solving

skills. Excellent presentation, organization and time-management skills

developed through extensive experience working in multinational companies

around the globe.

EDUCATION

Masters in Information Technology Security (MITS) Sep'11 -

Aug'12

University of Ontario Institute of Technology - UOIT, Oshawa

Bachelor of Computer Science (BS) Jan'00 -

Jan'04

Shah Abdul Latif University (ORASOFT), Pakistan

INDUSTRY EXPERIENCE

Kenna Communications LP, Mississauga, ON Nov'12 -

Oct'13

Database Developer

. Successfully configured & implemented Molson Insider online survey in

English and French using Opinio.

. Responsible for Server side programming in Oracle and SQL Server for

writing complex code as per business and functional requirements using

(Database Triggers, Stored Procedures, Functions & Packages, Materialized

views, database triggers, synonyms, sequence, Records, Collections, and

dynamic SQL).

. Involved in production support - Level 2.

. Responsible for regular deployments, maintenance and support and

troubleshooting activities.

. Provided daily status report on technical issues to senior management.

. Maintained batch processes using Unix Shell Scripting.

. Implemented process for Extraction, Transformation and loading (ETL).

. Database migration using import/export, SQL loader and UTL_FILE.

. Provided complex Adhoc reports to Analytic and Account teams.

. Participated in the engineering and designing of development projects

involving table design, coding, debugging, and testing tasks.

. Performed data conversions from flat files into a normalized database

structure.

. Setting up data feeds and data migration scripts.

Technical Environment: Oracle DB 10/11g, MS SQL SERVER 2008, SQL, PL/SQL,

T-SQL, SQL Developer, SQL Loader, JIRA, SVN Tortoise, WINDOWS, UNIX, Unix

Shell Scripting, Opinio.

EMIRATES AIRLINE, Dubai-UAE Apr'07 - SEP'11

Senior Software Engineer/Consultant

. Involved in all phases of the Software Development Lifecycle (SDLC).

. Worked with offshore teams to resolve all the requirement of design,

support and maintenance and testing related issues.

. Provided satisfactory service to customers, both internal and external.

Based on customer needs provided the best possible solution in a

friendly, properly and timely manner.

. Worked with a variety of groups across multiple disciplines to improve,

streamline, integrate and communicate the build, test, result and

deployment/release cycles of the applications.

. Provided management with status on development, support and enhancement

area.

. Developed complex programs, ad hoc queries and customized reports based

on customer requirements.

. Extensive database level program units writing in Oracle PL/SQL

(Packages, Procedures, Functions, SQL and other Oracle database objects).

. Tuning Application & SQL using Explain Plan, SQL Trace utility & TKPROF.

. Created and enhanced Forms & Reports as per user requirements.

. Created UNIX shell script to automate several manual activities in the

production environment.

. Developed back-end process by using Oracle Collections, bulking

techniques to increase performance.

. Developed error free code and maintain high standards of accuracy and

quality.

. Conduct Nonfunctional requirements testing like Load, stress &

performance.

. Resolved bug fixes and technical issues and followed up till closure;

used HPSD tool for incident management.

. Created Job schedulers using DBMS job schedule for synchronization of

data between different modules at defined intervals.

. For enhancement, followed Quality Management System (QMS) process during

the change management procedure like raising an RFC, participating in CAB

review meeting, preparing documents like Unit Test Plan/Review (UTP/UTR)

and System Integration Testing Reviews (SITR), follow-up with client for

User Acceptance Testing (UAT) signoff, preparation of Function Inspection

(FI) and continuous monitor the situation with DBAs and clients till it

goes to promote.

. Wrote all testing-related documentation, including test plans, test

cases/scripts and reports.

. Technically ensured quality software, reliable information and stable

applications for critical enterprise functionality.

Technical Environment: Oracle DB 10g/9i, SQL, PL/SQL, SQL * PLUS, Pro *C,

TOAD, SQL Developer, WINDOWS, UNIX, Unix Shell Scripting, HPSD, Citrix,

iPlan.

Feditec Enterprise, Pakistan

Oct'04 - Feb'07

Software Developer

. Designed, developed, implemented and documented of software applications

. Developed backend database process (Package, Procedure, and Functions).

. Created Forms and Reports as per the customer requirements.

. Deployed and configured applications adhering to project plans and

specifications.

. End user training.

Technical Environment: Oracle DB 9i/8i, Forms 9i,6i, Reports 9i,6i, MS SQL

SERVER 2005, SQL, PL/SQL, T-SQL, SQL Developer, SQL Navigator, SQL Loader,

WINDOWS, UNIX, Unix Shell Scripting.

MAJOR PROJECT COMPLETED

Client: Emirates Airline

. PROFIT- ( Price based Revenue Optimisation and Forecasting for Inventory

Trade-ups)

The objective of this project is to have a new revenue class structure

that can be used for inventory management, Revenue optimization and gives

flexibility for filing fares with incremental trade-ups for Economy

class.

Role:

. Involved in analysis, design, development, testing and

implementation of PROFIT project.

. Develop error free code with-in a specify deadline as per project

standard.

. Setting up different environment for development, staging & UAT.

. Writing migration scripts to implement changes on the production

environment.

. Coordinate with DBA Team, System Admin team for the environment.

. Coordinate with QPA team for the final inspection before deployment in

production.

. Followed the standard document and QMS process during the

development, testing & implementation.

. PROMIS - BATCH JOB MIGRATION (BJM)

BJM application is combination of different process related to flight

Schedule, flight departure, Inventory reconstruction, Group update,

Inventory history update and PROS Update, which updates the latest Flight

Inventory with forecast passenger figures.

Role:

. Involved in design, development and support of above processes.

. Involved in testing of production database after outages.

. Providing technical support to the team throughout the project

lifecycle.

. Optimizing low performance Queries using their execution plans.

. OPS Console System

Developed an OPS console system - a tool to invoke and monitor the

execution of processes which are defined using the process definition

screen. Users of the system can schedule these processes with predefined

parameters, exclusion / inclusion rules and preprocesses. System is

intelligent enough to identify independent processes exists in the job

and these can be executed as independent sub processes, in order to

benefit from parallel execution methodology.

Role:

. To develop test and implement process on staging and production

environment.

. Assisting DBA Team for setup of new Production environment.

. Sending scripts to DBA's for creating objects, Users, Database Links,

and Granting Privileges.

. Involved in testing of PROMIS application on CYTRIX environment with

different network band widths.

Client: Royal Group

Projects: Purchase, Logistics & Fixed Asset Management System, HR -

PAYROLL

Role:

. I was part of developer team and successfully design, develop, test

and implement above projects.

. Developed customized Reports in Oracle reports developer 6i.

. Created many reports for Logistics Application such as Standard

Invoice, Proforma Invoice, Shipment Information, Loan monitoring,

Payment History, Freight, Rebate & Sales Tax Reports.

. Writing technical design document, user manual and tech ops guide

to handover application to the operators.

. Investigating various issues raised by client and providing them a

solution.

AREAS OF EXPERTISE

. Software Development - Software Support - Change

Management

. Transition & Transformation - Tuning & optimization

- Database Analysis & Design

TECHNICAL CAPABILITIES

. Operating System: Red Hat Linux 9, UNIX (Solaris) and

Windows

. RDBMS Databases: Oracle 11g/10g/9i/8i, SQL Server 2008, MY-SQL

. Front End Package: Oracle Developer Suite (Forms, Reports,

Procedure Builder, etc.), Citrix

. Languages: C, SQL, PLSQL, T-SQL, Pro C, Unix Shell

Scripting

. ETL : Informatica Power Centre 9.x

. Project Case Tools: Microsoft Project, IBM Rational Portfolio

Manager, iPlan Enterprise, JIRA.

. Design tools: Visio, Erwin

. Service Mgmt Tools: HP Open View Service Desk 4.5

. Source Control Tools: SVN Tortoise, Harvest, Visual Source Safe

. Miscellaneous: MS office, Oracle Enterprise Manager,

Oracle Stats Pack, Putty, Telnet, FTP

PROFESSIONAL TRAINING & CERTIFICATIONS

- Oracle 9i Master's Program (one year duration), Oracle University

Jun'03 - Apr'04

- Oracle 9i Certified Professional (DBA-Developer Track).

AWARD & ACHIEVEMENT

. Emirates Airline Well done Award for successful technical upgrade of

PROS, GYM and GRMS applications.

. Emirates Airline Well done Award for successful implementation of

PROFIT project.

References available upon request

Contact this candidate