Charles Clifford, M.S. Email & Phone Number

After 40 years architecting distributed IT solutions, my only remaining IT related interest is domain-driven data governance as practiced in the AWS cloud and hybrid environments. If you want to engage in the practice of that security discipline, and you have been allocated the funds needed to accomplish that objective for the benefit of the enterprise or line of business, and you desire the help of an experienced and knowledgeable consultant and guide along your journey, then introduce yourself by sending me a message via LinkedIn. Of course that invitation is never extended to recruiters. I blacklist all recruiters.If you are not familiar with the discipline of domain-driven data governance you are advised to read my introductory series of 18 articles which I have published on LinkedIn and which explain the key aspects of that security discipline. That series covers the methodology, its techniques, technologies and tools at a high level. To go deeper - to access the secret sauce - you have to enter into a contract for my services.I look forward to your message. It is always enjoyable to connect with others with whom I share a common interest in data governance.

Mumbai, Maharashtra, In

AWS Enterprise Architect (C5) in the AWS Data Analytics Product and Innovation. The duties of this role include: creation and peer reviews of AWS architectures for RFPs and RFIs, interviewing candidates, authoring white papers, designing 'solution accelerators' (inventor of TCS Data Governance Toolkit for AWS) for the AWS cloud which provide TCS with strategic advantages in the marketplace, enhancing AWS competencies in TCS, internal mentoring & teaching of AWS, evangelist of all things AWS Data Analytics Products and Innovations.After encountering all of my colleagues on the global leadership team, after analyzing what they considered to be solutions, after observing up-close how they conduct business it became obvious to me that my only option was to resign, which is exactly what I did.

AWS Architect - given the rampant proliferation of double-speak in the USA the meaning of the word architect is profoundly perverted and twisted by legions of illiterate imbeciles running cons and scams. Based on the use cases, the role of the AWS Architect focuses on DESIGNING available, cost-efficient, fault-tolerant, and scale-able distributed systems on AWS. The AWS architect may supervise the construction of their design. The AWS architect might diagnose system problems as well. Only in cons and scams is, the 'architect' a hands-on role!Enterprise Data Architect - cloud hybrid; an OTC traded multinational corporation. In that role, for its 12 digital content platforms/divisions, Responsible for big data architecture, Master Data Management (MDM), Systems of Record (SOR), and General Data Protection Regulation (GDPR) remediation. Big Data Architect - on AWS, designed and implemented near real-time NiFi based Change Data Capture (CDC). Data from clusters of on-premise PostgreSQL, MySQL, Oracle & MS SQL instances, into AWS S3.Big Data Architect - on AWS deployed Hadoop, Kafka & Spark cluster on AWS for ML POC. Passive fraud detection algorithm implemented in Java. Data sources are unstructured text. ETLs implemented in Python. Big Data Architect - on GCP, diagnosed, designed & delivered solution that loads 10s of TBs from ORACLE into GCS & on into Google Big Query. Programmatically manages multi-year table partitions & views, handling the updating of records managed by Big Query, per MDM & Data Governance policies. Big Query data set used to support risk analytics for large financial institution.Big Data Engineer & Architect – on AWS, designed and implemented domain model composed ofmultiple nested hierarchies & time-series data set for multi-tenant SaaS solution. Enforces MDM and Data Governance while supporting OLTP,ad-hoc & predictive analytics, & machine learning. Introduced Domain Driven Design (DDD), Behavior DD, Test DD, Hadoop 2.x.

Redmond, Washington, Us

SDE 2 - At MSFT Center of Excellence. Secure License Key (SLK) Everyone on planet earth who gets a license to MSFT software does so from this utility. If you have not engineered at this planetary scale do not presume that I'd report to you. Lead team in MS COE. Upgrade of SLK. SQL Server 2000 database schemas to SQL Server 2008 compliant. Developed new database objects to support for new system features. Designed, developed and deployed Business Continuance and Disaster Recovery (BCDR) service for globally distributed system. Stewarded project execution. Extended system to interoperate with globally distributed key request counterparty systems.Recipient of ‘Deliver IT’ award.SDE 2 - At MSFT Center of Excellence. Codesign 1.2: Everyone on planet earth who gets any software from MSFT only does so through for this utility. If you have not engineered at this planetary scale do not presume that I'd report to you. Lead engineering in MS COE. Added multiple new services. New database objects to support new system features. Designed & implemented DLL that collects web service performance metrics. Designed & implemented directed graph repository with SOAP API used to administer end user accessibility to globally distributed system. SDE 2 - At MSFT Center of Excellence. Codesign LW08: Everyone on planet earth who gets any software from MSFT only does so through for this utility. If you have not engineered at this planetary scale do not presume that I'd report to you. Lead team in MS COE. Upgraded 3 SQL Server 2000 database schemas to SQL Server 2008 compliant. Re-factored database API (replaced ORMs with Façade pattern), enhancing SOA services throughput by 20%-30%. Extensively re-indexed databases, & re-factored CRUD query joins. Developed new database objects to support for new system features. Extended replication, KPI datamart, & data warehouse archiving. Recipient of ‘Deliver IT’ award

Seattle, Wa, Us

Enterprise Data Architect - Reviewed data models produced by staff, and trained them in the craft and science of data modeling. Established data modeling best practices. Oversaw design of Enterprise Canonical Data Model for use by ETLs. Designed and implemented web-based metadata tool that manages data objects and their relationship to published and subscribed data messages. Established guidelines for using ERStudio 7.0 in the construction of their Enterprise Data Model.

SDE - Established Disaster and Recovery processes for ORACLE 8i and SQL Server 7.0 systems. Established MS SQL Server 6.5 & 7.0 Best Practices guidelines. Conducted audit of MS SQL production environments. Developed, and initiated, MS SQL production environments remediation project plan to bring them in line with Guidelines. Trained Data Services staff in best practices guidelines. Provided production Support to a variety of production systems. Designed and implemented an ORACLE 8i and JAVA application that supports ORACLE and SQL Server operations management. Implemented project plan to migrate two applications off of Sybase System 11 to ORACLE 8i on HP-UX platform. SDE - Designed and implemented parsers, and data model to handle medical claims records, designed & implemented OLAP constructs. Conducted data mining to identify fraudulent medical claims. Created reports identifying of medical claim fraud. Implement ETL components to load data warehouse.SDE - Responsible for Business Analysis, Project Planning & Management; Team Mngmnt. Designed, implemented, tested & deployed .Net eCommerce solution. Database Modeling, as well as integration with AS400. Designed, implemented, tested and deployed ETLs.SDE – Designed and implemented data warehouse for Patient Assessment, and Case management for catastrophic, maternity, cardiac and extended cardiac patients. Implemented ETLs that loaded DW from external data sources. Implemented OLAP solution that analyzed diagnostic, procedures and pharmaceutical data.

Developed Data Architecture of Private Banking System. Managed team which mplemented 120+ ETL components that loaded data from external and internal source systems. Designed Canonical Data Model. Established policies and procedures for administration of development, testing and production environments. Designed physical data models for same. Prepared Project Plan for DBA portion of project. Conducted Capacity Plan. Designed and implemented Business Continuance Disaster Recovery solution (that withstood 9/11 attack). Designed & implemented OLAP constructs. Established Strategy for migrating version 4.9.2 and 10 SQL Servers to System XI. Replication Server and System XI product specialist for Capital Markets

Developed logical and physical data models for globally distributed mortgage back security system.

Initiated and completed enterprise-wide system architecture engagements in a variety of market segments: investment banking, medical services, public utilities, and real estate. Each architecture included the following set of architectures: data, application, technology and support. Participated as member of five person team that developed and established the Sybase methodology for conducting architectural engagements. Received the Professional Services Excellence Award and the Worldwide Corporate Innovation Award 1st QTR ’94.

Completed logical and physical design of the distributed Corporate Banking database (integrates data from five backend systems). Completed the logical and physical design of the Swaps and Options database (this database is derived from an Object Model). Designed and built a tool that derived relational models from Derivatives object model. Administered Sybase 4.9.2 SQL Server and System 10 Replication Server(s) and managed team of DBAs. Implemented SYBASE Replication as warm backup solution. Designed and administered Disaster Recovery solution for derivatives group. Designed and built a replication server (using INGRES 6.4) to manage data distribution between US and UK. Designed and implemented distributed relational database for Investment Banking. Conducted performance analysis and tuning of distributed UNIX/R-DBMS Client/Server production system. Defined Security at operating system, database server and application levels for a distributed suite of corporate banking applications. Designed and implemented distributed data dictionary browser for INGRES 6.4. Administered distributed INGRES 6.3 & 6.4 databases, as well as distributed Client/Server application.

Conducted applied research in objected-oriented languages (C++) inter-operating with relational databases (INGRES). Established development tool standards for UNIX development groups throughout 14 state region. Designed and developed UNIX/INGRES based operational data reporting system for Small Business Services division. Lead initiative that trained software engineers in the best practices for developing UNIX-based business systems. Initially recruited into End User Architecture group while completing thesis project which wrapped BSD UNIX with an adaptive end user interface.

M.S., Information Systems/Management Science

B.A., Geology