I am now officially retired.

Assisted in the roll out to power users of Microsoft Power BI for the Building Efficiency DivisionCreated/revised several Reporting Services reports for end users. Created an Execution Log application for Reporting Services Reports. Deployed to SharePoint for the monitoring of SSRS Report usage.

As a member of the Admin Team, responsible for data extraction, transformation and process automation development of Consumer and Retail lending data used in Risk Management Reporting - Consumer and Retail Risk Portfolios, using Microsoft SQL Server 2012 Data Tools - SSIS. Additionally help with SQL Server Job monitoring ensuring the timely delivery of reporting to our internal and external customers.

As a contracter with KForce on site for BMO Harris I was responsible for redesigning ETL processes using SQL Server 2005 to adhere to mandatory regulatory auditing requirements and to create more efficient ETL job processes in preparation for Server Migration to SQL Server 2012.

Maintain existing OLAP cubes as needed by direction of Ireland ICT. Create, Update and maintain SQL Server Reporting Services Americas Region Reporting. Deploy reporting to regional SharePoint sites for end users. Migrate by re-writing existing DTS packages to SQL Server 2008 Integration Services as time permits. Support Americas Region ProClarity users as well as maintain Americas Region Sales Cube Security Role assignments.

As Business Intelligence Developer, create, manage and deploy ETL and OLAP solutions for client companies using the Microsoft SQL Server Business Intelligence Suite.

SQL Server database management of Consumer and Commercial Credit Card Portfolio Analysis for the purpose of monthly snapshot reporting of activity and trending experience using the SQL Server 2005/2008 Business Intelligence suite. Create SQL Server Integration Services (SSIS) project solutions to dynamically import and extract data to SQL Server databases. Introduced users to the power and functionality of OLAP report cubes being the first Report Analyst to successfully create OLAP cubes with Credit Card Portfolio data using Sql Server Analysis Services.

Responsibilities : SQL Server database warehouse management of health insurance carrier medical; dental and Pharmaceutical claims data files for the purpose of creating analytical reporting of claims experience serving our client companies in their employee benefit plan decisions. This process involves the Extraction, Transformation and Loading (ETL) of claims and eligibility data files for processing using SQL Server 2005/2008 Business Intelligence Development Suite, where I developed solutions to dynamically import and extract data to SQL Server databases using SSIS. Create, Process and maintain hierarchical dimension and fact tables of claims experience data using SSAS. Develop and maintain claims reporting data using SSRS.Prior to 2006 as a member of the IT department, In the position of IT Programmer/Analyst – Database:Responsibilities : Developed external Web and Client Server applications for the purpose of collecting employee benefit information using both MS Access and SQL Server 2000 along with the Microsoft Visual Studio .Net, Classic ASP and ASP.NET. In addition, I developed solid and robust internal accounts receivables database applications, Contract Analysis and Inventory Tracking applications using Microsoft front end and back end technologies. Eventually created other databases linked to these applications to track commission income against expected revenues. Database applications developed over 8 years ago are still in solid day to day use today.