Senior Consultant Resume

Title
Senior Consultant

Primary Skills
Oracle and SQL Server 2005 Data Warehouse Architect, Database modeler, Database designer

Location
Canada-ON-Richmond Hill (will consider relocating)

Posted
Mar-08-09


Career Summary
I have over 15 years experience in information technology projects involving data warehouse design, database design, data modeling, project management, technical architecture and programming.

Expertise Summary
Databases : Oracle 8i, 9.2, 10g, SQL Server 2005, Postgresql 8, DBASE III, Foxpro
Languages : PL/SQL, SQL*plus, Pro*C, T-SQL, PL/PgSql, C, Java
Tools : Visio, ERWIN
Operating systems : Windows XP/Vista, Linux, AIX

Work Experience Summary

Verax Solutions Corporation Senior Consultant May 2004 -- Feb 2009
Verax is a consulting company based in Toronto. I have successfully completed assignments for the following clients of Verax:
Davis + Henderson (D+H), Toronto Senior Consultant Jun 2004 -- Nov 2008
Davis + Henderson is a reputed Canadian company involved in the businesses of cheque printing, e-commerce, bank and credit card electronic switching. I played multiple roles (Data Architect, Modeler, Team Lead and Developer) on various projects at D+H.
Summary of my successful projects and initiatives at D+H:
• Designed an Enterprise data warehouse in SQL Server 2005 which stored data from various production Oracle 8i and 9.2 databases thru ETL processes.
• Lead a team of programmers in development of ETL processes, scheduled jobs and data cubes in Cognos for the Enterprise data warehouse.
• Managed data models for over 10 production Oracle databases (Cheque Central Web CCDB, E-Switch, Central, NBS, NDC and four plants databases) using ERWIN and Visio.
• Team lead for developing database portion of their Interactive Voice Response (IVR) system.
• Created data model for American Express credit cards module for E-Switch database.
• Completed impact analysis, for various new initiatives and applications, to existing production databases.
• Migrated National Data Centre (NDC) database from Oracle 7 to Oracle 8i.
• Lead a team of DBAs and programmers in migrating their mission critical Commissions application from NDC database to National Billing System (NBS) database. This involved substantial audit of backend processes and data.

Tec-Xtr Inc., Toronto Consultant (contract) Oct 2003 -- Apr 2004
• Designed data models in Visio for various production databases implemented in Oracle 8i.
• Designed a data model and architecture process diagrams for implementing a search engine based on Google.

Orange Idea Corp, Toronto Technical Architect (contract) May 2000 -- Sep 2003
Orange Idea Corp. was software division of Concord Idea Corp., a leading manufacturer of computer memory modules and their testing equipment based in Markham, Ontario.
• Designed databases, in Oracle and Postgresql, for the variable data printing system (VDPS) which enabled corporate clients of printing houses to order business cards and stationery on the web.
• Worked with business partners to understand workings of a printing house and lead a team of programmers and graphics designers in developing web components of VDPS system.
• Designed database, in Postgresql, for various modules related to hosting corporate web sites. This included DNS, Sendmail and Web portal implementation in backend database.


DMC Inc., Toronto Consultant Sep 1997 -- Apr 2000
DMC was a leading software consulting company based in Toronto. I have successfully completed assignments for the following clients of DMC:
Manulife Financials, Toronto
• Developed Rational Rose models for e-commerce system under IBM Web Sphere framework.

• Developed Java packages to load data into their backend DB2 database and interface with mainframes thru IBM MQ messaging services.

Nesbitt Burns, Toronto
• User requirements analysis and review for Y2K compliance of software packages used by various business units.
Toronto Stock Exchange (TSX), Toronto
• Development of C modules for TALARIAN quotes system which provides real-time quotes for securities traded on TSX. I developed Pro*C interfaces for the backend Oracle database to capture and store real-time quotes data.

Canadian Tire Corporation, Toronto
• Developed models for proposed n-tier architecture implementation using Oracle database and existing legacy systems. I conducted a detailed study and analysis of their existing legacy system and our consulting team developed a proposal for migration to a n-tier architecture based system.

Fidelity Investments Canada, Toronto
• Developed and maintained their intranet web site including developing CGI scripts in C.

• Implemented java applet and web based charting solution for mutual funds data.

• Worked with business users to define requirements for various web pages and components, translating them into technical requirements and their actual development and implementation on Fidelity intranet web site.


Data-soft Computers, Bombay Software Engineer 1989 -- 1997
Developed business applications for financial accounting, accounts receivable and payable, manufacturing control, inventory management and investment portfolio analysis in DBASE III, Foxpro.

Datamatics Ltd., Bombay Software Engineer 1988
Developed library management system based on IIT's main library using Unify database.
J. B. Chemicals, Bombay Programmer 1986 - 1987
Programming in DBASE III and Foxpro for financial accounting, accounts receivable/payable and purchase management systems.
Permanent Magnets, Bombay Programmer 1985
Developed financial accounting and sales order processing system in DBASE III.

R. P. Trading Company, Bombay Programmer 1982 - 1984
Developed stores accounting, market monitoring and payroll systems in COBOL (VMS), Basic.


Education and Training Summary


Institution Course Year

York University, Toronto Developing Emotional Intelligence 2008
Schulich executive education centre

Learning Tree International, Toronto Project Management 2005

PMP certified professional, Toronto Project Management 2003

IBM education and training Visual age for Java 1998

Bluestone software, New Jersey, USA Advanced Sapphire/Web 1998

University of Bombay Bachelor of Commerce 1985

NIIT, Bombay Diploma in programming 1982

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Richmond Hill, ON | Resumes in Ontario

View other Senior Consultant resumes, Programmer / Developer resumes