Mehrdad (Mehr) Zonoozi

** ********* **** ? Richmond Hill ON ? L4C 5R9 ? 416-***-****

acox9t@r.postjobfree.com

Objective:

Data Architect/ Database Developer, hands-on with developing database

centric applications, interested in projects require creativity, analysis

and forward thinking, focusing on Semantic/Data Modelling, Data

Architecture, Business Analysis, and Custom Database/Application (Technical

Lead)

Highlight of Qualifications:

. More than 10 years' experience as Database architect & Database

application developer

. Custom web application development, Database-centric Applications

using Oracle/APEX or LAMP

. Data (Semantic) modeling, Process of mapping data requirement and

analysis using ERD/UML/RDF

. Database Design: Conceptual, logical and physical database design

(Oracle, SQL Server, MySQL)

. Data Warehousing, Process of creating MDM and repository of integrated

data

. Data Migration and ETL using advanced tools such as MS SSIS and

Informatica

. Bachelors in Computer Engineering & Post Diploma in Database

Application Developer

Functional Experience:

.

. Sales and Quote Management

. Order Processing and Billing

. Customer Relation Management

. Configuration Management database (CMDB) / Asset Management

. Network Operation and Project Management

. Telecom/Hydro/Energy (Production Plants, Operations, Engineering,

Maintenance)

. Government (NOC Operations) and Banking

Technical Skills:

. Databases (Oracle11g/10g, MySQL 5.1, MS SQL Server2005/8, DB2-UDB, MS

Access)

. Tools (ERWin, Oracle SQL Developer Data Modeler, Power Designer,

Informatica, Crystal Reports, SSIS, SSAS, Toad, BIRT, MicroOLAP,

Joomla, Visio)

. Languages (PL/SQL, T-SQL, XML, RDF, PHP/Perl/Python, Java, JS, HTML,

UML)

. Operating System (Red Hat Linux, Unix, Windows, MS-DOS)

. Methods (Agile/SCRUM, RUP, Case*Method, SSADM, IE, BSP)

. Techniques: DB Normalization, Object Relational Mapping (ORM), Master

Data Management (MDM), Business Process Analysis, Rapid Application

Development (RAD), SLDC, RUP, SCRUM

Work Experience:

WireIE, Toronto Jan 2013 - Present

Database Application Developer / Architect

Environments: Oracle 11g, Oracle APEX, Oracle Data Modeler

Designed, created, deployed and managed data architecture -- along with the

application (forms, reports, database, and programs) -- for an integrated

total solution (ERP type: including: Sales, PMO, Operations /NOC, Contracts

and Billing modules):

. Utilized Oracle APEX to develop a complex and integrated web-based

application using APEX

. Mapped business requirement and rules into the integrated data model

(ERD)

. Created database and components (tables, forms, queries, reports,

programs etc.)

. Performed regular data migrations using SQL/OS scripts

. Interacted with business users to collect requirements and facilitated

meetings

. Created the use cases and analysis models to clearly define the

requirements

. Administered database including backups/recovery and DBA works

. Developed User group /profile management for different functional

areas and policies

. Developed Ad-hoc reports using complex queries for the BI (Management

Reports)

. Contributed in planning the roadmap by attending and assisting

steering committee

ScotiaBank, Toronto Mar 2012 - Dec 2012

Database Developer

Environments: Microsoft SQL Server 2008, T-SQL, MS SSIS, Cognos

Developed Database platform for the bank's Technology Assets Management

office:

. Led the database design (logical and physical) for the Technology

Asset Management

. Created ETL packages using SSIS to extract, transform and load data to

SQL Server

. Responsible for backup/recovery, data movement, and database

administration tasks

. Designed high performance database architecture to satisfy the BI

reporting

. Co-developed data model for Cognos tool using Star /Snowflakes schema

GE Energy, Atlanta Jun 2011 - Dec 2011

Database Analyst / Data Modeler

Environments: MS SQL Server 2008 R2, ORACLE 10g, T-SQL, RDF, SSIS, XML

Provided Database Design and data integrity (normalization), performed data

analysis and migration from RDF to ORACLE:

. Analyzed IEC CIM XML and GE profile to convert them to relational

model

. Created logical and physical database model to store all xml data and

review results

. Enhanced existing Data model for a web-based solution for IEC

standards

. Assisted in designing and implementing required database for Dashboard

(BI)

. Practiced SCRUM and contributing and attending to Scrum Sprint

planning

National Home Services, Toronto Sep 2010 - May 2011

Database Developer/ Analyst

Environments: Informatica, SQL Server, SSIS, Data-Loader, MicroOLAP, MySQL,

Data Loader

Led the database migration, assisted in data architecture

. Developed target data model and logical/physical DB design

. Assisted in developing web applications using Perl/MySQL

. Created Custom Data Model for the CRM system, in a join effort with BA

team

. Attended to requirement gathering meeting with stakeholders and target

system users

. Migrated SQL Server database to MySQL using Informatica to transform

and load data

. Developed data models for related business areas using MySQL Workbench

WireIE, Richmond Hill Dec 2009 - Feb 2010

Database Developer

Environments: MySQL, PHP, Java, HTML, Visio, MAC, MS DTS (SSIS)

Assisted a major wireless carrier project, analyzed requirements for

amalgamated data, created the data model, performed data conversations and

created related reports:

. Mapped the physical model to DB and developed database tables

. Generated reports using MySQL SQL scripts and DTS for developing the

reports

Ministry of Government Services, Toronto Oct 2006 - Nov 2009

Database Application Developer / Analyst

Environments: Oracle 10g, PHP, DTS (SSIS), Joomla, Perl, Python, Crystal

Reports, Symantec, Linux, Visio

Responsible for developing a comprehensive ticket system and all the

related database and applications for the Information Protection Centre (ON

Gov), assisted in NOC operations:

. Developed an internal ticket system for NOC operations using LAMP

. Enhanced a data warehouse system using Oracle as DB and PHP/Perl

. Analyzed security related requirements, developed ERD and analyzed

workflow

. Assisted in analysis and designing the Web based CMS Portal using

Joomla/PHP

. Performed Database tuning, by modifying existing SQL queries

. Developed ad-hoc (complex) reports using Oracle PL/SQL

. Worked as Security analyst to monitor and communicate with other

parties in OPS

. Performed Technical Writing and composed User Manual and Technical

References

Royal Bank of Canada, Toronto Sept 2005

- Apr 2006

Technical System Analyst

Technologies: DB2 (UDB), Java, MS DTS, SQL Server

Provided database related assistance (DB Query tuning, and design) to

support team for a corporate (RBC) web-based cash management system (RBC-

Express):

. Worked on automated software testing tools, tuning and optimizing bad

SQL queries using DB2 Analyzer and Index Advisor

. Performed data analysis and data modeling using CA ErWin

. Utilized Emprix e-Test and Mercury for stress testing the application

. Developed and modified codes (HTML, Java and JSP), using eclipse (IDE)

Siemens Information Systems, Dubai 1998 - 2003

Application Developer

Technologies: Oracle 7.3, Designer /2000, Developer/200, Visual Basic,

Access

. Analyzed, designed, developed and implemented new applications.

Performed database maintenance and ensured databases were running

effectively

Education and Professional Development:

. Professional Engineers (Toronto): Licensed as Professional Software

Engineer

. Seneca College (Toronto): Postgraduate Diploma in Database Application

Developer

. MDS (Dubai): Oracle DBA, Oracle Designer/Oracle Developer

. Univ. of Science and Technology (Tehran, Iran): B.Sc. in Computer

Engineering - Software

Contact this candidate