Data Design

Professional Profile

I am a highly experienced IT Specialist; worked in various capacities data Analysis, Logical Modeling, DB design and implementation An out of box thinker with an analytical mind

Guest Speaker: IDUG (Warsaw) in 2008, IDUG (Toronto) in 2001 and 1999.

http://www.idug.org/p/cm/ld/fid=144&tid=90&fileid=1562

Countries Worked in: Canada, Saudi Arabia, France, USA and Greece

Education: MSc Physics Carleton University, Ottawa, Canada

MBA University of Ottawa, Ottawa, Canada

Teaching Experience: 1980-1987 P/T faculty member at Humber College, Toronto, Canada

Summary of Skills:

Interview end users to analyze user process/data requirements

Identified opportunities to enhance/create IT processes

Experience in data governance/migration/cleansing/security

Develop logical models (ERD), 3rdN form, STAR and snowflake schemas.

Convert logical models to physical models and implement same in different DBMS

Excellent in data warehouse architecture, data mining, archival (data partition)

Made presentations to senior management

Design/enhance large transaction and reporting data systems

Participate in code reviews. develop components that are strategic to the solution

Design test cases for system/user testing

Publish database standards and naming conventions, best practices in programming

Study the existing system’s application design/ performance issues.

Work on proof of concepts, Capacity planning, data backup/ recovery HADR

Lead and mentor junior DBAs/developers in the team, proactively

Work closely with business and IT partners, vendors

Design process/knowledge of ETL/BI/OLAP Tools

Performance and tuning queries/load

Experience with db2 EE and DPF (EEE) on mid-tier, DB2/IMS on mainframe

Well versed in new security features of db2 (Audit, encryption, etc.) and SOX

Create/upgrade DB2 software (DBMS/DB) and db2 objects

Create DBD, PSB, ACB in IMS

Very good understanding of financial/investment/telecom sectors

Excellent verbal/presentation and negotiation skills

Project Management of complex projects including budgeting

Ability to speak technical issues in non-technical language

Stay current with emerging technologies

Summary of Hardware/Software

Languages SQL, PL/SQL, COBOL, PL/1, FORTRAN, DL/I. IMS DB/DC, CICS, JCL,TELON, QMF, DDL, CLIST, ACF2, RACF, OMEGAMAN, BMC tools, Visual explain db2connect

DBMS DB2 UDB EEE (DPF), DB2 UDB OS/390, IMS, IDS, SQL Server, MYSQL

Hardware IBM (MVS-OS/390), SERVER (RISK6000/p-series)

OS UNIX (AIX), z/390, TSO/ISPF, CLIST

Modeling Tool Erwin

BI Tools Business objects (BO), Microstrategy, BRIO, COGNOS

ETL Tools PRISM, Informatica, Ab-initio

Scripting KORN shell, awk, sed, grep, cron, PERL

Scheduler CA7,Autosys, Maestro

PC Skills MS Office Excel, Access, Power Point, Project

Assignment History

April 2016- to-date, Consultant. Ontario Lottery and Gaming (OLG), Toronto.

Worked on PIR OLTP and GDR databases. Resolve performance issues

Designed archival strategy using table partition.

Part of team to enable Native Db2 Data Encryption.

Aug 2006 – April 2014, Consultant, BNS, Toronto

Advise the senior management of new features of security in db2 v9 LUW like SECADMIN, AUDIT, LBAC, help with Audit and implement new features.

Worked on various projects – Scotia Connect Reporting, CDIC/ALRE, Paperless Statement for VISA /DDA accounts, Payment Centre, Financial Transaction Model systems

Heavy interaction with vendors to ensure they meet Bank’s standards

April 2006 – May 2006

Data Warehouse Consultant, IBM Financial Services Solution Centre, Dublin, Ireland.

Part of the team that designed data warehouse using IBM FSDM.

May 2005- March 2006 / Oct 2002 – July 2003 Senior Consultant, Scotiabank, Toronto.

Here worked on Anti Money Laundry (AML) and Term Loan Systems. Heavy interaction with vendors to meet tight deadlines and co-ordinate changes to meet Banks standards.

Create backup, recovery, reorg procedures

July 2004 – May 2005 Senior DW DBA Legg Mason, Baltimore, MD, USA

Was a senior and only db2 on a big - 6TB data warehouse (DW).The DW was about financial transactions done by LeggMason Clients. Data source was main frame.

Revisit the DW architecture. Though the company was using 2 P650, data was located only on one P650. Successfully partitioned the data on 8 partitions. Created a new star schemes for datamarts

Redesign the Load strategy. Help BI design. Did training on DB2 for developers.

Aug 2003 – Dec 2003 Software Consultant DW, Banque Populair, Nantes, France

Analyzed the current architecture – Improved performance by redoing indexes, improved load times.

Design and implement a datamart, redesign some scripts, upgrade db2 to a higher level.

Feb 2000 – July 2002 Advisory DW DBA/Architect, Scotia Bank, Toronto, Canada

Bank's DW was being managed by IBM. I was hired to bring the project in-house. It was 2TB DW.

Migrated the staging environment, improving performance by almost 50%, using AIX pipes.

Implement data marts for special marketing needs

Help BI teams in their schema design. Review code for performance, design temporary tables

Day to day support for db and development issues. On Call support.

Mar 97 – Feb 2000 Systems Specialist, Bank of Montreal, Toronto, Canada

Was a member of the team that designed the Architecture for the Bank’s Information Warehouse (BIW). The design was a three tier Data warehouse and data marts.

As a chair of BIW team, made presentations at BIW user forums. Explained the direction/architecture of BIW. User forum was made of senior Bank managers from different lines of Business.

Helped design Star Schema and aggregation strategy in a team environment.

Heavy intersection with vendors/BI tool providers. We had called for RFP from various vendors.

Created db2 standards/conventions for db2, as this was our first DWH in db2.

May 80- Feb 97 Specialist/DBA/Team Lead Bell Canada/Sygma, Toronto, Canada

I worked on various projects; some of them are highlighted here: Systems I worked on employed IMS or DB2 as DBMS.

I was in Saudi Arabia a couple of times (1980 and 1987). Part of a three member team that did ISP, data conceptual models and capacity planning for Saudi telecom.

FADS - Force Administration Data System. This system designs staffing requirements of directory (411) inquiry department. This was a COBOL system.

USODS - Universal Service Order Data System. This system was used by Bell and other local telephone companies in Canada to communicate network requirements of clients. This system was designed initially in IMS/COBOL ON Z.OS, but later on in IDS on Honeywell. Changed internal Business Procedures.

PAIRS - Plant assignment and Inventory Record System. This systems allocated resource needed to make a telephone loop. This was an IMS/COBOL system

LDR Local Dynamic Routing- This system uses dynamic allocation of a telephone route as opposed to fixed route.

NOAM Network Operations and Maintenance. This was an ISP Information System Planning exercise to look at current and future systems requirements of Bell's network.

MCCDS Mechanized Control Circuit Data system. This was an IMS system.

Contact this candidate