PROFESSIONAL SUMMARY:

• Accomplished, results - driven Data Architect with 15+ years experience supporting diverse high-volume industries such as banking, telecommunications, retail, government, high-tech, utilities and transportation.
• Extensive expertise spans data modeling, integration, application design, and system integration in multi-platform environments (Sun, IBM, HP, DEC, Data General, Windows, Linux and IBM Mainframe). Broad background spans roles as Oracle Technical Support Manager, Senior Data Architect at IBM, Data Architect at Accenture, and Bussines Data Architect at teh Ontario Securities Commission
• Innovative thinker, proficient at designing and implementing enterprise- wide data architect solutions dat substantially improve operating efficiency and performance.
• Respected team leader with a demonstrated ability to train and motivate others to exceed established goals.
• Consistently deliver complex IT deployment projects on-time and with minimal disruption to critical business processes.

TECHNICAL SKILLS:

Languages: C, C++, Unix and Windows scripting, SQL, Hive, Pig, Python

Databases: SQLServer2016,Oracle12c, Sybase, DB2, HSQL, HBASE, Cassandra, MongoDB

Platforms: UNIX (AIX, Solaris, HP, SCO, Linux), Windows, IBM Mainframe, VM (VM/VSE, VM/CMS), VMS

Software: Azure, AWS, GCP, Rational, MQ, Oracle Designer, Erwin, KDM, IDA, Pivotal, J2EE, Websphere, Weblogic, Oracle Application Server, OEM, Spotlight, DBArtisan, Performance Center, Toad, Tomcat Apache, XML, SSIS, CMM, CMMI, Six Sigma Framework, AQT, Jira, SVN, Eclipse, Citrix, NetBeans IDE, JDEdwards, Oracle Applications Testing Suite, HP LoadRunner, HP Application Lifecycle Management, Momentum, Globalscape EFT, TIBCO MFT and TIBCO Business Works, Hadoop, Hortonworks, Spark, Pig, Scala, Machine Learning, Deep Learning

BI Tools: Abinitio, Datastage, Oracle, SQLServer, Spotfire, Tableau

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential

Technology Stack: Windows, Linux, IBM Mainframe, SqlServer, DB2, VmWare, Python, DataStage, Tableau, Citrix, Erwin

Responsibilities:

• Design of OTC derivatives architecture to support analysys of raw data and aggregated layers to easy reporting and time-series analysis
• Planning enterprise and application architecture to support Big data
• Leading team for definition and implementation of Test strategy and Test plans for teh different OTC environments
• Leader of teh Hardware and Software requirement process for teh third generation of teh OTC data warehouse

Data Integration Architect

Confidential

Technology Stack: Windows, AIX, z/os, IBM Mainframe, CA7 scheduler, CA Service Desk Manager, SharePoint, TIBCO MFT, Spotfire and BW, Hadoop, Oracle, SqlServer, Citrix, DB2, IMS

Responsibilities:

• Key member in teh design and building of data conversion strategies between diverse legacy computing application systems, B2B environment, and teh new system as well as teh Hadoop ecosystem
• Team leader of teh file transfer design and implementation phases

Data Integration Architect

Confidential

Technology Stack: Windows, JDEdwards, IBM Mainframe, SqlServer 2008 R2, Oracle 11g, Oracle web portal, Weblogic, VMware 4.0/5.1, Netapp, Bloomberg Data Licence, SharePoint, Citrix, Oracle Applications Testing Suite and HP LoadRunner, HP Quality Center

Responsibilities:

• Comparative analysis of Oracle Applications Testing Suite and HP LoadRunner for JDE performance application load testing.
• Leading team during teh testing phases of Sqlserver and Weblogic environments using HP LoadRunner.
• Participated in teh design and building of data conversion strategies between diverse legacy computing application systems and teh new consolidated JDE platform.
• Developed automated data refresh interfaces between JDE databases

Data Architect

Confidential

Technology Stack: AIX, Linux, Windows, IBM Mainframe, Oracle 10g/11g RAC, TimesTen, SqlServer 2008, SqlServer 2012, DB2, HSQL, Websphere, XML, Eclipse, Netbeans IDE, J2EE, Erwin, TOAD, Jira, SVN, Windows Active Directoy

Responsibilities:

• Developed specifications,conversions and implementation plans for on-time implementation and deployment of organizational products.
• Leading team during teh design of database platform-independent strategies to support data model changes and data migration paths like import/export of insurance products using XML

Senior Data Architect

Confidential

Technology Stack: AIX, Windows, DB2, SOA, Rational Data Architect, Rational Software Architect, Infosphere Data Architect, XML, BODS, Oracle RAC

Responsibilities:

• Participated in aligment of business requirements to current Air Canada SOA production environment
• Defined and designed teh input and output of data for teh database as well as teh supporting backup and recovery database processes

Senior Consultant

Confidential

Technology Stack: AIX, Windows, IBM Mainframe, Oracle, DB2, AbInitio, DataStage, IBM IFW Banking and Financial Markets Data Warehouse (BFMDW), Information Analyzer, DataFlux, RDA, MQ, SAS, AQT, SQL, Erwin

Responsibilities:

• Defining new system blueprints, including Equities Trading system and Financial Crime Infrastructure, aligned with actual organization architectures
• Led cross-functional team of Data Architects (DA), ETL Developers, Quality Assurance (QA), and Database Administrators (DBA)
• Implementation of efficient monitoring, reporting and tracking systems including Statutory Reporting, Air Miles, Financial Crime Infrastructure and Mortgages
• Designed Data Inventories aligned to MDM policies

Data Integration Architect

Confidential

Technology Stack:UNIX, Oracle, Weblogic,Java, SAS, SQL, Erwin

Responsibilities:

• Succesful migration from Oracle to non-stop SQL database
• Designed automatic re-distribution of rows for list-partitioned tables
• Developed code to generate auditing tables and triggers for Oracle database based on existing schema

Data Integration Architect

Confidential

Technology Stack:Solaris, Oracle, Sybase, DB2, Weblogic, Websphere MQ, OAS,Java, XML, .NET, J2EE, PGP

Responsibilities:

• Leading team during optimization of upgrade API procedures
• Seamlessly replacement of old technology with current products by implementing Internet-based standards and business intelligence/data warehousing technologies
• Identified, integration of common data models between Sybase and Oracle wealth management applications
• Designed in-line upgrade/migration of database schemas without bulk export/import of data

Data Consultant

Confidential

Technology Stack:Solaris, Linux, Oracle 9iRS/9iAS/9i/8i, DB2 UDB, Veritas, RMAN, Citrix Metaframe, Powerbuilder

Responsibilities:

• Sigma Software: Led teams in designing data and schema migrations. Installed, tuned and administered development, testing and production Oracle 8i/9i databases and Oracle 9iAS on Solaris.
• IBM Canada: Performed a comparative study between Oracle 9i R2 and DB2 UDB V 8.1.2 for single and clustered databases on Linux

Data Architect / Database Administrator

Confidential

Technology Stack:Solaris, Windows 2000, Linux, SQL Server 2000, Oracle 9i/8i, Weblogic, UNIX Scripting, PL/SQL, Java, C++, XML, HTML

Responsibilities:

• Increased number of deployment platforms due to migration compliance practices
• Drove substantial process improvement, including:
• 556% improvement on core database performance and 900% improvement on production database performance
• Reduced database migration process from 70 hours to 4 hours
• Enhanced application response time from 15 minutes to 10 seconds

Data Architect

Confidential

Technology Stack:SQL Server 7.0/6.5, Oracle, JDEdwards’ One World, Sql Forms

Responsibilities:

• Building and evaluating system blueprints to optimize number of OS, DBs, and APIs.
• Led a team of 5 DBAs in establishing data migration from SQL Server 6.5 data model to SQL Server 7.0/Oracle.
• Integration of data models between SQL Server 2000, Pivotal, Oracle, JDEdwards' OneWorld, and EIC applications.
• Evaluation of performance monitoring tools for network, routers, servers and databases