Richard Bryden Email & Phone Number

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.

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.
• 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

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.
• 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.

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.

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.

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.

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.

Bsbc

Mba, Mcs