Richard Bryden

Richard Bryden Email and Phone Number

Etl Developer at Teksystems @ TEKsystems
hanover, maryland, united states
Richard Bryden's Location
Cheshire, Connecticut, United States, United States
Richard Bryden's Contact Details

Richard Bryden personal email

n/a
About Richard Bryden

I am a Business Intelligence professional who deliver’s high quality data warehouse applications. My specialty is ETL design and development. I am driven to understand the data involved in the applications I build and to help my clients understand the data as it impacts the metrics produced in the applications. I also help them understand data quality issues discovered during the application development so informed design decisions can be made.I have over 15 years experience in developing data warehouse applications. I’ve played different roles on projects of various sizes, from data warehouse team lead, to subject matter expert on primarily outsourced solutions, to Informatica Administrator, to key contributor in establishing an ETL architecture. I also have experience in star schema design and development.I enjoy collaborating with my teammates, sharing knowledge and best practices, growing team strengths and capabilities.

Richard Bryden's Current Company Details
TEKsystems

Teksystems

View
Etl Developer at Teksystems
hanover, maryland, united states
Website:
teksystems.com
Employees:
24374
Richard Bryden Work Experience Details
  • Teksystems
    Etl Developer
    Teksystems Jun 2014 - Present
    New Haven Ct
    Knights of Columbus July 2014 - presentSupporting BI projects as and ETL developer. Working with SAP Business Objects Data Services. Completed several projects involving maintenance of existing code. ETL developer for a new system which was integrated with an external company to support ongoing training of KofC members. Worked with information management on system design and the web service team to implement communication with the external company. Supported testing and system implementation.
    View
  • Northeast Utilities
    Bi Developer
    Northeast Utilities Oct 2012 - May 2014
    Berlin, Ct
    BI TeamWorked with the Credit and Collections business team to support and grow the Customer Behavior BI application which provides metrics and reports that describe the business processes supporting Customer engagement and support. Performed new development and ongoing maintenance work for the application. Responsibilities included: • requirement and specification development and documentation • star schema database design • design and code ETL processes including creation of Autosys schedule• testing support with the client team, provide client team with a set of queries providing metrics data• work with the OBIEE administrator to support RDP work for subject area creation• develop OBIEE Answers to validate RPD working as expectedDeveloped a coding technique to decrease load time on ETL processes performing large volume inserts to Oracle tables by disabling primary key and indexes during load. Built an Oracle package of stored procedures to provide a single consistent set of code. Developed a method of tracking Oracle Temp space use during load cycles to identify high use ETL processes. This enables the capability to recode the high use processes to reduce overall use of Temp space and eliminate issues in the load cycle related to Temp space.Informatica Administration - support code migrationsSupported Supply Chain Data Consolidation and CL&P Rate Case projects. Responsibilities included:• Supply Chain Data Consolidation project - Prototyped Informatica code for the project. The prototypes were used by a consultant to code the application. Built CA WCC (Autosys) schedule using jil script, approx. 450 jobs.• CL&P Rate Case - Debugged Oracle stored procedure used in the rate case special rates calculation
    View
  • Northeast Utilities
    Bi Developer
    Northeast Utilities Jan 2009 - Sep 2012
    Berlin, Ct
    Customer Support Team Customer Behavior Reporting Project - Subject Matter ExpertLead an internal and off-shore development team developing the Customer Behavior Reporting application. Provided the team with information on the source systems involved in the application and acted as the primary resource in researching system questions as the project proceeded. • Prepared ETL specifications, reviewed test documentation, performed testing and analysis of data issues. Monitored work and provided project manager with overall status updates for the ETL work. • Coded complex ETL routines to support loading of historical data to customer account dimension table.• Worked with Informatica administrators to configure Informatica following the upgrade to version 9. Performed troubleshooting to identify configuration issues with the ODBC environment when run using operating system profiles.Bad Debt Analysis ProjectPrimary developer resource supporting stabilization of the SQL Server based reporting package developed by the Oliver Wyman group. Reporting package enables reporting and analysis of metrics related to business processes for Customer support and Credit and Collections.Designed and developed an alternative table design to address rapidly growing database.Designed and implemented ETL process to support the new table design.Predictive Analytics Project – Acquisition and Implementation of Predictive Analytics SoftwareProvided technical support for project to evaluate and procure predictive analytics software. Provided technical support for installation of SAS tools. Designed and developed a common script based interface between SAS Unix program code and Autosys to support implementation of production applications.Rate Case SupportDesign and development of Hyperion IR reports on inventory and usage for unmetered electric services. Reports to be used by personnel supporting current and future rate cases.Informatica Administration - support code migrations
  • Northeast Utilities
    Business Application Developer
    Northeast Utilities Jan 2007 - Dec 2008
    Berlin, Ct
    Customer Service Implementation Project Developer for reporting on Streetlight and Unmetered inventory and usage on customer service system replacement project. Worked with client team to design and implement a BI application for reporting including Oracle database tables, ETL code written in Informatica and reports written in Hyperion Interactive Reporting software. Worked with DB2 DBA to develop a method of supporting connections to subsystems containing multiple versions(development, test, training) of the customer service database. Utilized specific DB2 security groups combined with Informatica environment sql to configure Informatica database connections to specific databases. Resolved issue involving the use of Informatica to load tables from DB2 table unload files. Informatica was not correctly reading and writing null values in field in source file. Wrote code specification for a REXX script to read and update the source files prior to Informatica use. Informatica Administration - support code migrations
  • Northeast Utilities
    Business Application Developer
    Northeast Utilities Jul 2005 - Dec 2006
    Berlin, Ct
    Supply Chain Team Primary technical support for GXS EDI application. Maintained system software and provided application administration support for the UNIX based system. Developed an automated process to identify issues in the GXS profile database Implemented maintenance routines coded in Unix script to control space usage, delete old files etc.Designed, developed and implemented an interface between the GXS application and Cleo Lexicon to provide AS2 services to trading partners. Implemented utility to evaluate GXS proprietary trading partner database and identify incomplete trading partner configurations. This supported AS2 communication with electric suppliers involving multi-million dollar transactions.Lead upgrade project for GXS Enterprise application software.
  • Northeast Utilities
    Data Warehouse Developer
    Northeast Utilities Jan 2003 - Jun 2005
    Berlin, Ct
    Supply Chain Team Implemented upgrade of INDUS Knowledge Warehouse(IKW) application to version 9 for Northeast Utilities. Design and development of a common UNIX script based interface between Informatica and Autosys that replaced the use of individual session specific scripts to call Informtica pmcmd and run workflows. Interface has been in use from 2005 to date.IKW implementation included working with the client team to identify portions of IKW required to meet reporting needs and working with the DB2 support team. Implemented first use of Informatica ODBC software at NU to support read/write access to SQL Server databases. Developed Unix script based ftp process to support implementation of ETL with the IBM mainframe. Native Informatica code did not support ftp of files from the mainframe into an Informatica ETL process.
  • Northeast Utilities
    Data Warehouse Team Lead
    Northeast Utilities Jan 1997 - Dec 2002
    Berlin, Ct
    Supervisor for data warehouse team. Performed employee performance evaluations, represented team in the overall IT organization and specific application efforts.Primary technical lead on project to evaluate, procure and implement ETL software package. Worked with team resources on implementation and configuration of Informatica software and the development of process standards.

Richard Bryden Skills

Business Intelligence Data Warehousing Etl Business Analysis Data Modeling Microsoft Sql Server Databases Oracle Sql Visio Obiee Informatica Autosys Unix Shell Scripting Database Design Unix Shell Scripting

Richard Bryden Education Details

Frequently Asked Questions about Richard Bryden

What company does Richard Bryden work for?

Richard Bryden works for Teksystems

What is Richard Bryden's role at the current company?

Richard Bryden's current role is Etl Developer at Teksystems.

What is Richard Bryden's email address?

Richard Bryden's email address is bryderw@nu.com

What is Richard Bryden's direct phone number?

Richard Bryden's direct phone number is +120234*****

What schools did Richard Bryden attend?

Richard Bryden attended Georgia Institute Of Technology, University Of New Haven.

What skills is Richard Bryden known for?

Richard Bryden has skills like Business Intelligence, Data Warehousing, Etl, Business Analysis, Data Modeling, Microsoft Sql Server, Databases, Oracle, Sql, Visio, Obiee, Informatica.

Who are Richard Bryden's colleagues?

Richard Bryden's colleagues are Stan Sagan, Zachary Sollecito, Steffany Cordero, Gregg Lostumbo, Michael Mykris, Alexis Merino, Shashidhar Bagi.

Not the Richard Bryden you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.