Brian Keane Email & Phone Number

Middlebury, Ct, Us

Middlebury, Ct, Us

New Haven, Ct

Lead Business Intelligence Developer for all COVID related data and reportingSpearhead the design and development of business intelligence solutions, creating data visualizations and dashboards to facilitate data-driven decision-making for executive teams.Collaborate closely with business stakeholders to gather requirements, understand key performance indicators (KPIs), and translate business needs into technical specificationsDevelop and optimize Extract, Transform, Load (ETL) processes to ensure seamless data integration from various sources into the data warehouse, resulting in a more efficient data retrieval system.Actively monitor and maintain the integrity of the data warehouse, identifying and resolving data quality issues, and implementing automated data validation procedures.Stay up-to-date with industry trends and emerging technologies, conducting regular assessments to recommend and implement improvements to existing BI systems and architecture.

New Haven, Connecticut, United States

Lead analysts on various process improvement projectsResponsible for data analytics, ETL (extract, transform, load) process, SQL for reporting, Tableau DashboardsThese projects were instrumental in improving healthcare as well as cost saving measuresOne project around the Capacity Coordination Center was featured in this articles below

Created ETL (Extracts, Transform, & Load) for internal and external data sourcesAt the peak there were more than 150 ETL jobs in productionFacilitated Promotion Process for each ETL JobManaged scheduling and production error processing

Data Architect - Designed a dimensional data model using Kimball design methods - Flexible design to allow for mixing of many banking products - At current time there are 31 dimensions and 5 fact tables - Created naming conventions and standards - Responsible for metadata creation and upkeep - Developed Source to target mapping documents - Implemented internal wiki to house documentation - Instituted formal model review process before DDL was handed off to developers ETL Developer - Created new ETL streams using SSIS, T-SQL, and DTS - Created ETL using SSIS to load type 1, 2, 3, and 6 dimensions - Maintained legacy ETL typicaly T-SQL based - Developed SQL Server Analysis Services (OLAP) cubes - Delivered deployment scripts for moving code, objects, and data from development to production - Production support for ETL, Cubes/OLAP, SQL Server, and SAS - Piloted version control system for ETL code base - Gathered requirements and authored detailed requirements documentsReport Developer - Produced static reports using SQL, SAS and SSRS - Developed SAS macros for local program use as well as global team usage - Point person for portfolio pricing reports that grossed over two million dollars annually - Member of peer code review team - Gathered data and review existing processes for external government audits - Routinely translated one-line requests into valid spec documents

Financial Advice Technical Team Leader - Main contact for all client teams within Hewitt - Coordinate projects with third party vendors - Create operational level processes and documentation for client teams to follow - Completed in house project management courseLead Programmer Analyst/ Technology Project Manager - Supervise and mentor team of 2- - 4 programmers on client specific projects - Write specification and analysis documents - Produce SAS solutions relating to defined contribution, pension and healthcare administration - Utilize SQL queries to gather, organize and maintain data from DB2 database for use in data mining - Author programs in SAS language designed to interface with third party feeds - Develop SAS macros, producing flexible code for use within various programs - Program various statistical and analytical reports at client and internal requests - Conduct internal courses concerning the SAS and SQL programming languages - Designed and implemented in house coding standards for SAS programming - Member of code migration team that reviews code for standards and efficiencies

M.S., Software Engineering

Bs, Computer Science