KASHIF ZAFAR

** ***** ****,

Whitehorse, Y*A*L*, Yukon, Canada.

Mobile: +1-867-***-****

Email: ac7xa7@r.postjobfree.com

OBJECTIVE

Computer Science is ever changing field that required adequate knowledge and dedication. I intend to further explore the new horizons of information technology and develop my skills in the field of computer sciences. To be a most valuable IT Professional for a progressive organization, therefore I can prove my worth through smart works, in order to accomplish company’s business objectives.

PROFILE

Database Administrator, BI Developer and Oracle Certified Professional with more than 10 years’ experience, enjoys demanding projects and strives in implementing the best in class technical solutions. I Have experience to

Database Administration

Database Designing

Data Integration and Migration Processes

Data Warehouse

Business analytical solutions, Testing and implementing of Business Intelligence (ETL, Reporting, Analytics)

Dynamic & Interactive Dashboards

Database Maintenance tools, Tuning & Optimization

Data Backup, Recovery and High Availability

Server Management, Upgrade and Patching

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i & 8i, MS Sql Server 2008 – 2016, MYSQL

ETL Tools: Oracle Warehouse Builder 11g, 10g, Informatica 6.1

BI Tools: Oracle BIEE 11G/10G, Oracle BI Standard Edition One

Operating System: Windows(2000,2016\64bit), Linux

Middleware: Oracle Application Server 10G, Oracle Enterprise Grid Control 12c

Language: SQL, PL/SQL

Web portals: Oracle Portal 10g

Tools: Toad for oracle, PL/SQL developer, Data junction 8.0

PROFESSIONAL EXPERIENCE

Northwestel Inc. (Bell Subsidiary)

Whitehorse, Yukon

Primary Job Reasonability: Database Administrator

Job Type: Full Time Employee

Job Duration: Form Jun 2013 to date

Job Location: Whitehorse, Yukon

Major Responsibility

Maintaining Oracle, Sql server and firebird databases

Plan, implement, support and maintaining the enterprise production, test & development database management system environments

Controlling the migration of database structures from the test environment into the production environment.

Providing database administration services & participate in an On Call (24x7) rotation

Monitoring and tuning production processes

Doing maintenance of data dictionaries, overall monitoring of standards and procedures and integration of systems through database design.

Developing and maintaining standards, procedures and methodologies for effective operation, access, control backup recovery of all databases.

Designing, implementing and modifying physical database structures; evaluate, test and implement database management systems, utilities and tools.

Coordinate database security requirements including basic education, user guidelines and access authorizations.

Developing, maintaining, and monitoring documentation and procedural standards relating to all database projects.

Conducting and review tests of database systems to verify performance objectives and quality standards.

Refresh development and QA databases as necessary

Creating storage groups, databases, tables and views, review and tune PLSQL, monitor database/code performance, develop and enforce database standards.

Communicates availability requirements for database accessibility.

Preparing time estimates for assigned projects.

Possess general understanding of the system deployment process and correlation with database administration responsibilities.

Assisting in disaster recovery planning, testing and execution as needed.

Evaluating project objectives and scope for feasibility.

The Crescent Textile Mills Ltd.

Mills: Sargodha Road, Faisalabad, Pakistan.

Primary Job Reasonability: Sr Database & BI Developer

Job Type: Full Time Employee

Job Duration: Form Apr 2008 to Apr 2013

Job Location: Faisalabad, Pakistan

Major Responsibility

Gathering the technical requirements, design and develop business analytical solutions, testing and implementing of Business Intelligence/ (ETL, Reporting, Analytics) requirements.

Design and develop ETL (Extract Transform and Load) maps using industry standard tools like Oracle Warehouse Builder 11g.

Design and develop ER diagrams and map the source data into data warehouse objects.

Data model design and documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).

Design and develop objects in Oracle database.

Develop Oracle Business Intelligence meta-data layer. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).

Develop BI Dashboards & Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.

Creates, modifies, administers and tunes test and production Oracle EBS R12 databases

DB and APPS Server Management

Database Deployments and Patching

Prepare and Test Disaster Recovery Procedures and plans by using RMAN & Oracle Data Guard

Provide developers and technical staff with the understanding of design and implementation regarding database.

Major Project Involvement

Implementation of OBIEE 10G with Oracle EBS R12(Design and develop Financial, HR and Supply Chain Dashboards with different analytical views)

DWH Designing (HR and Inventory Cubes implemented by using Oracle Ware house builder 10g)

Implementation of Oracle Data Guard

Oracle Portal Development and Implementation along with Oracle BI EE10G

Sequel Systems, Inc.

Lahore, Pakistan.

Job Title: Database/OBIEE Developer - Team Lead

Primary Job Responsibility: Database Developer / BI Consultant

Job Type: Full Time Employee

Job Duration: From Sep 2006 to Apr 2008

Job Location: Lahore, Pakistan

Major Responsibility

Team lead of DB Projects area, handling more than 80 clients in USA on both UNIX/Windows OS

Creates, modifies, administers and tunes test and production databases of clients

Develops and enforces practices and procedures for accessing and securing databases.

Worked on data ware housing tools such as Oracle BI SE One, Oracle DWH and Oracle Discoverer.

Converted and migrated Medical Manager Application Database to Oracle Database for SequelMed Application.

Data transferring and updating from third party data providers like FDB, SNOMED, and LOINC etc.

Involved in the design of EMR (Clinical system) and new modules of EDI and HL7 in current product EPM (Financial system)

Provide suggestions for database and process improvement

Provide developers and technical staff with the understanding of design and implementation of their applications to support growing informational needs.

Performs all database maintenance and administrative duties in order to support the clients' production environments;

Create and maintain Database scripts.

Major Projects Involvement

SequelMed BI (Mar 2007 – Apr 2008)

SequelMed EMR (Oct 2006 – Apr 2008)

SequelMed HL7 (Nov 2006 – Apr 2008)

SequelMed EPM-EMR Interface (May 2007 –Dec 2007)

Involved in database administration and providing technical support to more than 80 clients in production environment in USA (for Oracle and MS SQL Server databases).

Provide on call and routine database and systems support to clients.

Lead and manage team of 3 database resources by planning, assigning and monitoring different database administration and development tasks.

Perform all database administration and maintenance tasks in clients' production environments by creating new databases and performing up-grades, Back Up & Recovery, Security/user administration, Performance Tuning, Performance Monitoring, Data loading and Data migration on current production databases.

Provide both onsite and remote administration support to clients.

Perform installation and patch updates on Oracle 8i, 9i, 10g in UNIX/Windows based OS environment.

The Crescent Textile Mills Ltd.

Mills: Sargodha Road, Faisalabad, Pakistan.

Job Title: Senior Assistant Manager

Primary Job Responsibility: Database administration

Job Type: Full Time Employee

Job Duration: Form Feb 2003 to Aug 2006

Job Location: Faisalabad, Pakistan

Major Responsibility

Creates, modifies, administers and tunes test and production ERP databases

Administration of Oracle Applications (OF)

Cloning and Patching Oracle Database and Oracle Applications 11.5.7

DB and APPS Server Management

Provide developers and technical staff with the understanding of design and implementation regarding database.

Performs all database maintenance and administrative duties in order to support the production environments;

oDB Security

oBack Up & Recovery

oPerformance Tuning

oPerformance Monitoring

oData loading and Data migration

oUpkeep of Indexes and Database Statistics etc.

Database Deployments regarding ERP

Maintain and Manage DWH and BI Tools (EIS System )

Portal development and Administration

Web Development

Major Projects Involvement

CGC ERP - Oracle Financial (OF)

CGC ERP – Executive information System

Crestex Portal

Involved in CGC ERP database administration

Involved in OF Application Administration

Perform installation and patch updating for Oracle Applications

Worked on data ware housing and manage EIS.

Perform data migration using SQL Loader and Import/Export utilities.

Develops and enforces practices and procedures for reducing time by implementing fault tolerant solutions of RMAN.

Configure, design & implement Xoops portal on Linux environment.

Masood Textile Mills Ltd.

Apparel Division: Sargodha Road, Faisalabad, Pakistan.

Job Title: Assistant Programmer

Primary Job Responsibility: Assist DBA

Job Type: Full Time Employee

Job Duration: Form 15 May 2002 to 31 Jan 2003

Job Location: Faisalabad, Pakistan

Job Description

Assist DBA

Website development

Projects/Achievements:

Manage Oracle Databases

Design Job bank at www.masoodtextile.com by using ASP

Successfully Deployed Oracle Application Server 9i

EDUCATION/CERTIFICATION

MSC (Master of Science) in Computer Science (2005)

University of Agricultural, Faisalabad.

CPGA (3.06/4.0)

Oracle Certified Professional in Database administration

BCS (Bachelor of Computer Sciences) (2001)

Allama Iqbal Open University, Islamabad.

High School (Pre-Engineering) (1997)

Board of Intermediate & Secondary Education Faisalabad.

Contact this candidate