David Johnson
Data Architect Senior at PNC
- Role
- Data Architect Senior at PNC
- Location
- Cleveland, OH, US
- LinkedIn followers
- 500 followers
About David Johnson
Expertise as an Architect, Leader, and Data Engineer with full life cycle experience across Application Systems, Data Warehouse and Enterprise Analytics Environments. Visionary with practical problem-solving experience that can lead a company to become a more data driven business by using the right data with the right tools. Demonstrated competencies:• Data-Driven Solutions • Large Data Migrations • ETL• Solution Architecture • Establishing Best Practices • Cost Reduction• Database Design • System Migrations / Upgrade • Technical Expert• Reporting / Analytics • Database Change Control • Coaching | MentoringTECHNICAL SKILLSDatabase systems: Oracle, Teradata, SQL Server, My SQLProgramming: SQL, PL / SQL, Unix Shell Scripting, R, Autosys, Visual BasicDatabase Tools: Erwin Data Modeler, Toad, Datalab, Benthic, MySQL WorkbenchBig Data Technologies: Cloudera, HIVE, Impala, HUE, Sqoop, Map-Reduce, Spark, Cloudera Data Science Workbench (CDSW)Reporting Tools: QlikView, N-Printing, Google Analytics, Business ObjectsProject Tools: Atlassian JIRA, Confluence, Agile Methodology, CA ClarityApplication Administration: Informatica, Cloudera, Autosys, QlikView, Business Objects, Kana
Experience
Data Architect Senior
Jan 2020 — Present · Cleveland/Akron, OH, US
Leader in technology that focuses on delivering customer focused solutions while managing risk. Architect with a core competency in Solution and Data Architecture with experience in Business, Enterprise, and Software Architectures. Involved end to end in designing, creating, deploying, and managing an architecture.• Responsible for architecture of retail customer applications and the retail interface to PNC’s enterprise customer database. • Built dozens of architectures to support both customer and employee facing channels. The architectures included user interfaces, Microservice APIs, System of Record Services, Kafka streaming, Database Design, and integration to external vendors. • Lead Architect on modernizing four different complex small business capabilities with online banking. Working with as many as three to five crews at one time where each crew consists of Product Owner, Application System Manager, Business Analysts, Business System Analysts, and eight to ten Developers.• Increase productivity through influence with peers and by delegating tasks to junior or contractor architects through mentoring and knowledge transfer.• Ability to communicate to all audiences verbally, in writing, and through architecture diagrams that invites dialog and builds consensus. Persistent in working through different perspectives of various stakeholders to arrive at a solution design that is agreed by all parties.• Proficient analyzing data using methods that include ingesting production data into Teradata Datalab and building analytic models. Performing data profiling to understand and document current state. Analysis of findings have been critical in decision making for various initiatives and to business leadership.
Education
Cleveland State University
Master of Computer and Information Science, Database
The University of Akron
Bachelor of Science Computer Science (Minor Applied Mathematics), Mathematics and Computer Science
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.