About Me
James is an Enterprise Senior Solution Architect/Data Engineer with over 20 years of experience in the design, development and management of large enterprise-wide data solutions. Though his background is deeply technical, James is very effe...
Show MoreSkills
Data & Analytics
Others
Development Tools
Programming Language
Database
Web Development
Portfolio Projects
Company
Toyota
Description
Leadership: Defined and implemented large enterprise operational data store and big data.
Major Technologies: Oracle Big Data Appliance, GoldenGate, Informatica, Apache Hadoop, HortonWorks
Project Contributions: Scaffolded large data federation and virtualized data warehousing system including:
portal, security, active data models, Exalytics, Exadata, Hadoop, and mobile business intelligence/analytics. Developed mobile and cloud-based BI systems. Set DW, DM, DG, MDM, DQ, Informatica and data integration standards.
Skills
Oracle 12cTools
hadoopCompany
SAP application
Description
- Project Contributions: Assisted with User Stories & Acceptance Criteria; Data Profiling & Analysis, Conceptual & Logical Data Modeling, Taxonomy, Rule Specs, Ref Data Specs, Mapping Specs, Scorecards, UAT for large SAP project. Source-to-Target Mapping Design and Development. Additional contributions: Map the source data to the logical data model (i.e., presentation layer); Map the logical data model (i.e., presentation layer) to the canonical data model; Map the canonical data model back to the logical data model (i.e., presentation layer); Map the logical data model (i.e., presentation layer) to the SAP data model; Identify critical data elements (CDEs); Identify data anomalies in the source data; Reuse and/or develop data quality validation rules and apply them to the required source data via profiles; Determine the MDM rules for the data (match & merge, trust & survivorship)
- Major Technologies: SAP, Oracle, Informatica MDM, Apache, Hadoop, Cloudera, Oracle Fusion, Kafka, Flume, Tibco, Teradata
Skills
SAP Oracle Informatica IBM MDM Apache Active Hadoop Cloudera Oracle 10g Fusion Charts Apache-Kafka Flume Tibco AMXBPM TeradataTools
Visual Studio (Win)Company
Spark for processing
Description
Project Contributions: Lead standards and development of Big Data, data warehousing, management, integration, governance, MDM, Service Oriented architectures (Kakfka, Flume, Oracle Fusion, Tibco) and quality. Designer of data models and repository structures
- Major Technologies: Oracle, Informatica, Apache, Hadoop, Cloudera, Oracle Fusion, Teradata
Tools
Visual Studio OnlineCompany
EQT
Description
- Leadership: Lead architect on a large multi data integration/reporting project engagement.
- Project Contributions: Defined the architectural approach and process for implementing multiple agile projects simultaneously.
- Communications: Led explanatory meetings with senior executives and middle managers. Led requirements, design and strategy meetings with senior executives and middle managers. Mapped requirements to tactical and strategic technical solutions.
- Major Technologies: Oracle, Informatica, Tableau, Tibco Spotfire.
Skills
Oracle Informatica Tableau TIBCO SDK SpotfireTools
Visual Studio (Win)