SUMMARY:

• Confidential is an expert in data architecture, ETL, and artificial intelligence.
• He is recognized by Intel as a Software Innovator.
• 5+ years of data modeling (including relational/normalized and dimensional)
• 5+ years of database and data warehouse architecture, including Oracle, IBM DB2, Netezza & dashDB, Pivotal Greenplum, SAP HANA, and Amazon Redshift, Redbrick Warehouse
• 3+ years of big data architecture, including Hadoop (IBM BigInsights, Cloudera, Hortonworks, MapR, Pivotal HD), Hive, and MPP databases (Pivotal Greenplum, IBM Netezza & dashDB, SAP HANA, Oracle Exadata, Amazon Redshift)
• 5+ years of ETL architecture experience, including IBM InfoSphere DataStage, DataWorks, Talend Open Studio, and Informatica
• 5+ years of ETL development experience, including IBM InfoSphere DataStage, DataWorks, and Talend Open Studio
• 3+ years of data governance, data quality & profiling, and metadata (including Informatica and IBM tools)
• 2+ years of Artificial Intelligence experience, including machine learning, deep learning, machine vision, NLP, and ASR, leveraging open source and proprietary technologies and frameworks including IBM Watson, OpenCV, and Intel OpenVINO
• 2+ years of Cloud BI and data strategy and roadmap development
• 2+ years of BI tools, including IBM Watson Analytics, Cognos, SAP Business Objects, MicroStrategy, and Oracle
• 3+ years of Agile project experience, including Scrum Master and Product Owner
• 10+ years of IT leadership, including Program and Project Management, architecture and technical team leadership, and staff management
• 1 year of MDM architecture & implementation experience
• Significant experience at formal training (including content development and delivery) as well as mentoring of more junior team members

TECHNICAL SKILLS:

Unix Based Systems: Linux (Red Hat, SUSE)

VMWare: DEC Vax/VMS

Windows Server: SAN (EMC, Hitachi, IBM)

Tools: Oracle Warehouse Builder, Designer, Discoverer, Express; Siperian MRM; Deft; Erwin; IBM InfoSphere Data Architect, InfoSphere Information Server (DataStage, QualityStage, Information Analyzer, Metadata Workbench, Business Glossary), DataWorks, Watson Analytics, Cognos; Informatica PowerCenter; Talend Open Studio 4; Brio; Business Objects XI, Data Integrator; MicroStrategy; MS Project

Languages/App’s: Java, ‘C’, SQL, Visual Basic, Ingres 4GL; SAP, Oracle Financials, IBM InfoSphere MDM Server; Splunk

DBMS’s: Pivotal Greenplum; Oracle, Express, Exadata; IBM DB2 UDB, Red Brick Warehouse, Netezza, dashDB, BigInsights; SAP HANA; HortonWorks HDP; Cloudera CDH; CA Ingres; Microsoft SQL Server

PROFESSIONAL EXPERIENCE:

Confidential

Founder & CEO

Responsibilities:

• He also oversees all work on the company’s technology stack.
• This includes the integration of artificial intelligence technologies including IBM Watson Speech To Text, Assistant, and Conversations, OpenCV with Intel OpenVINO, and machine learning models running as microservices in IBM Cloud OpenWhisk.
• It also encompasses integrations with 3rd party solutions such as Volumio, the open source music player, for which development is done mostly in Javascript with node.js.

Confidential

Senior Data Architect

Responsibilities:

• Confidential launched this company to revolutionize the Agile delivery of BI and big data projects by leveraging development lifecycle and automation tools, including emerging and open - source offerings. In this role he defined worked on client assignments such as:
• Working as a Solution Architect in the Global Retail and Security and Fraud Risk Software Delivery team at HSBC, the second largest international bank, Confidential provided technical leadership on a project to transform the Retail Risk global BI platform by implementing a new Collections BI solution leveraging Hadoop and Spark in the cloud. More recently, he worked on a project to implement Splunk for staff fraud monitoring.
• Working as part of a small consulting team, Confidential mentored key staff members at Vermont Information Processing to help them get up to speed with the latest features of the IBM InfoSphere Information Server suite.
• Confidential led a consulting engagement to demonstrate the data profiling and quality capabilities of IBM InfoSphere Information Server for Aon Hewitt.
• He guided the new Governance team at People's United Bank in how to build effective data governance and quality measurement processes using IBM's Infosphere Information Server suite, especially Information Analyzer and Information Governance Catalog.
• Working as Project Manager at Loblaw, Confidential led two infrastructure projects to successful completion. Both included outsourced project teams working in an onshore/offshore model. One project required upgrading the company's Enterprise Service Bus to use the latest version of IBM Websphere Message Broker, the other moved the company's ETL infrastructure to the current version of SAP Business Objects Data Services. Total combined project budget was more than $3 million.
• Working as part of a team from Cognilytics Inc., Confidential was assigned as Lead Architect on a Big Data Architecture project at Fannie Mae in Herndon, VA. At that time, the project was in distress and it failed an internal project quality audit. Confidential assumed management of an underperforming and dysfunctional project team of subcontractors that had missed key deliverable deadlines. Under his leadership, the team successfully produced several critical deliverables and he was able to negotiate a project Change Order to extend the project. By the conclusion of the project, the team produced a recommendation for a solution architecture for building a Finance Data Repository including SAP HANA for online data storage and Hadoop for near-line data storage. This system is expected to process and load over 300 TB of data including residential mortgage loans and securities information.
• Working in partnership with the client, Pernod Ricard North America, a global leader in the wine and spirits industry, he worked as a Data Architect to create a Big Data Strategy. This included meeting with business and I.T. stakeholders to investigate potential use cases, such as in support of a Consumer Engagement initiative. It also included meeting with new and incumbent systems vendors in the "Big Data" space such as Oracle, Pivotal, MapR, and Tableau.
• Confidential served as ETL Lead for an IBM InfoSphere MDM Server v10 implementation project for ICBC in Vancouver, B.C. In this role he worked with the client to define and document data migration requirements, and designed and developed integration processes using IBM InfoSphere Information Server DataStage and QualityStage v8.5. This included installing and configuring the supplied QualityStage standardization routines as Web Services for use by MDM Server.

Confidential

Senior Technical Architect

Responsibilities:

• As a Senior Technical Architect in the Information Quality Management practice, Confidential increased his experience with Data Profiling and Data Governance tools and technologies, with a focus on the IBM InfoSphere Information Server suite, especially Information Analyzer, QualityStage, Metadata Workbench, and Business Glossary. He created the company's Agile implementation methodology, StreamLine. He also completed several successful client assignments such as the ones listed below:
• Ontario Ministry of Health and Long Term Care: Working as part of an IBM consulting team, Confidential was the Solution Architect responsible for delivering a data migration strategy that covered migrating data from a legacy distributed application into the Panorama application, which represents the strategic direction for centralized health surveillance within Ontario.
• Broadcast Music, Incorporated
• Confidential was assigned as Project Manager for an Agile Data Governance and Data Modeling/Replication project for this client in the music rights management business. In this challenging role, he joined an existing six person consulting team that had missed a critical development milestone and was not performing to client expectations.
• He worked with the client to regain their confidence and lead the team back on track, positioning the project for its successful completion. He also worked with the client to define key metrics for implementation as part of their Data Quality Management initiative, which leveraged Stream Quality Manager as the foundation for a custom data quality dashboard.
• In addition to this role, Confidential worked with the Head of RUSSB to define a Data Warehouse Strategy, Roadmap, and Business Case and provide guidance to BI/DW projects within the Branch. This included the evaluation of leading and emerging database appliance technology.

Confidential

Principal Consultant

Responsibilities:

• Confidential refactored the data model for the Pharmacy Data Mart using CA ERwin. He installed and configured a proof of concept (PoC) Greenplum database environment and created and loaded schemata for two key historical data sources. For this project, the entire platform was built using open source software including Fedora Linux, Greenplum database, and the Talend Open Studio ETL development environment. Confidential created the Transformation routines using Talend Open Studio.
• Confidential defined the application and database architecture for a reporting system for the Bank’s securities accounting outsourcing business. He also participated in the ETL and BI tool selection process and advised the client’s senior IT management on Data Warehouse strategies.
• Confidential first worked on a team to build the RRIF data mart using IBM DataStage, then led a team to successfully tune and enhance it. Then he played a key role in significantly enhancing and extending it for use as a new RRSP Data Warehouse. Confidential was largely responsible for the enhancement of the data model and redesign of the ETL processes. One of his design optimizations resulted in significant performance improvements, ensuring the load process met the SLA and reducing storage by half.
• As a Technical Architect, Confidential was responsible for completing several parts of a proof of concept to show the potential for the IBM InfoSphere Foundation Tools. He also worked with the project team, including external consultants and internal resources, to help define a vision and process for the swifter development of BI and DW solutions in support of key CN Rail stakeholder groups.
• Confidential served as Data Modeler and consulting team project manager for this Agile data warehouse implementation. He led a team of five consultants and more than four staff resources to implement the first phase of the project on time and on budget. Using IBM InfoSphere Data Architect (IDA), he created the data model for the database and assisted with physical database design and tuning as well as with ETL design. IBM InfoSphere DataStage was used for ETL.
• Working as a subcontractor of The BI Builders, Confidential worked as lead BI Architect/Strategist on a BI Assessment and roadmap project for Points International. On this project, Confidential conducted discovery interviews with Points’ executive and management team, including the CEO, CFO, CMO, and CIO. Based on the findings, he created a conceptual architecture and multi-year roadmap for the company’s strategic BI initiative.
• As Solution Architect and Project Manager, Confidential was responsible for initiating a project to implement a data governance dashboard and scorecard within the client’s BI/DW group. The heart of this solution included automated semantic matching of semi-structured and unstructured data using public domain Natural Language Processing algorithms. Informatica Metadata Manager was used as a central metadata repository and collector, and matching was developed in Java.
• Confidential helped clarify the expectations for this project to improve the client’s data integration development capabilities. He led a workshop introducing BI to the client's IT staff and assisted in setting up a PoC environment for IBM InfoSphere Information Server.
• In this capacity he led the data architecture effort as well as assisting with the solution and application architectural directions. His architectural approach was based on Business Driven Development, a variant of the Rational Unified Process (RUP).
• Confidential restored the company's business critical BI application to full operational capabilities following a significant outage and period of instability. He then initiated a four million dollar project to migrate to a new hardware platform and new software versions. The migration provided at least a tenfold performance boost, with one marketing campaign that would have previously taken over 40 hours to execute completing in less than 4 hours.