Richard Powell Email & Phone Number

Rtp, Nc

Distinguished Engineer and high level consultant to LSA’s Fortune 500 customers.• Established DataLake for Hadoop by architecting data pipelines for North America field trialresearch data and geospatial research data captured by unmanned aircraft system (drones) into MapR Hadoop on AWS. Partnered with scientists and field operations management to understand workflow and requirements to build search and analysis capability on top of field trial research data using MapR Hadoop, SOLR, Apache Drill, and Python Web Services. • Improved Genotype Quality and Selection by implementing a data intake pipeline into Cloudera Hadoop and data services for global predictive breeding data. Reduced weeks of time required for Scientists to receive validated genotypes. Processed 100+ million genotypes per hour.

Rtp, Nc

Led and implemented secured multi-tenant enterprise Hadoop platform using MapR.• Collaborated with Infrastructure and Security teams on platform security, data center design, and capacity planning to provide a stable, secure, enterprise class data platform for analytics.• Improved Hadoop Platform Security by driving implementation of MapR Ticket Authentication, defining solution architecture for Cisco Application Centric Infrastructure, and eliminating vulnerabilities discovered by 3rd party assessment.• Partnered with clients to understand business requirements and incorporated enhancements into technology roadmaps and technology POCs.• Established a service model for Hadoop by defining service offerings and key processes and procedures for client engagement, cost model, provisioning, security, and platform support.• Heightened awareness of Hadoop and Ecosystem Architecture through internal webinars, executive briefing center events with Cisco customers, and internal website.• Designed and implemented automation of Usage Trend Reporting through Tableau dashboards and regression test suite to validate and measure Hadoop and ecosystem tools after major upgrades and patches.Led and implemented secured multi-tenant enterprise Data Virtualization platform using Composite.• Defined strategy, capability roadmap, RACI, logical and physical platform architecture, access controls, service model, and global platform support model.• Mobilized virtual team across DV Business Unit, Enterprise Architecture, Infrastructure, and Global IT Support.• In charge of hardware design, software installs and patching, platform adoption, and escalations.• Created key processes and procedures to standardize on-boarding, access, and support.• Entrusted to participate in due diligence process for Composite Software acquisition.• Conducted webinars, training sessions, and user community site.

Rtp, Nc

Implemented Data Integration Architecture for Enterprise Data Warehouse (EDW) on Oracle and Teradata.• Defined EDW policies and standards for architecture, data, reporting, ETL, and audits.• Implemented ETL templates and central job control framework to simplify batch, near real-time, and dual load data movement patterns.• Supported multiple EDW initiatives by scaling Informatica horizontally to handle parallel development and QA efforts.• Integrated Informatica with internal Change Management and Job Scheduling systems.• Engaged EDW project teams and downstream subscribers to conduct architecture reviews and training on EDW policies and standards.• Evaluated and implemented Appfluent to track data usage trends and optimize SQL query performance.Established data integration strategy and roadmap for deploying Informatica across the enterprise.• Partnered with clients understand business requirements, reviewed application architecture, conducted POCs on Oracle, Teradata, and XML data.• Implemented Informatica across 6 organizations, established processes and procedures to standardize each deployment, and ensured best practices were adopted. • Defined as-is and to-be architecture,• Handled all interactions with Vendor Management and Purchasing. Assisted with vendor negotiating and acquisition process.Architected and implemented design-time and run-time metadata search capability on top of Informatica, Teradata, and internal job scheduling system. Resulted in significant time savings for answering data lineage and impact analysis questions.• Evaluated Rochade for addressing Data Lineage and Impact Analysis and other Data Integration use cases.Collaborated with Architecture Standards Forum and developed the Enterprise Architecture Review Process deployed across nearly all IT organizations.

Rtp, Nc

Program Managed EDW Alliance (incident reporting system) data subject area and application. Engaged client teams to understand business requirements for reporting metrics, managed cutover activities for all releases on EDW, and provided onsite / offshore production support model for ETLs and Business Objects reporting.Headed database design, data provisioning and management, production support, and managed SLAs for multiple data subject areas within the Enterprise Data Warehouse (EDW). Improved database design to align with EDW standards, increased data load performance, and developed automation for month-end processing. Collaborated with Corporate Planning to deliver a consolidated forecast accuracy metric, AAPE. Conducted technology evaluation of Oracle Warehouse Builder to optimize PL/SQL development. Implemented web based portal to provide visibility into EDW operational data.

Rtp, Nc

Developed ETLs for Customer Order ODS, BAAN, and i2 using Perl and embed SQL.Led team of 5 developers, successfully engineered and simplified multiple data load methodologies for Oracle and SAS into a common data load framework for the data warehouse.Created and implemented database designs, logical and physical data models, complex query and view construction, and snapshots for Product Definition System.

Rtp, Nc

Developed client server applications for NT Request For Feature System using 4th Dimension.