Michael Kennedy

• Created SSIS packages to migrate data from various data sources to data warehouse

• Successfully extracted transformed and loaded data into data warehouse

• Created, Scheduled Generated and optimized ETL jobs

• Created Updated Stored Procedures, Triggers and Functions, Views and Indexes with extensive use of T-SQL.

• Created and deployed customized reports in SSRS to numerous customers (Finance, Project Controls, Procurement)

• Utilized SSMA to migrate data from Oracle to SQL Server databases

• Creating standards and designing patterns on data movement, data access, data integration, and other areas in the data warehouse

• Desigen SQL SSIS Packages in Business Intelligence Development (BIDS) to extract data from various data sources for further Data Analysis and Reporting by using multiple transformation provided by SSIS (Data conversion, Conditional Split, Bulk insert merge, and Union all)

• Expert in cleansing data for data consistency, single system or multiple systems

• Debugged unexpected SQL results, deadlock issues

• Heavy experience in Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration and Business Intelligence.

• Previously developed Java services to capture data from medical instruments output to insert into Oracle tables

• Also, worked with medical systems, creating tables, writing triggers, performing database design

• Was responsible for implementing and the creation and tuning of data aggregation mechanisms

• Supported medical staff by calibrating medical equipment and ensuring all instruments are collecting data at all times

• Also maintaining Java applications while converting some applications to .Net.

• Responsible for designing, developing, and testing of the ETL strategy to populate the data from various source systems (SQL Server & Oracle) feeds using ODI and Change Data Capture.

• Was part of a systems engineering team maintaining healthcare systems and workflow document systems

• Served as SharePoint administrator and developer, wrote several web services and windows services in C# in accordance with customers requirements

• Improved operations by conducting systems analysis

• Prepared and installed solutions by determining and designing system specifications, standards, and programming

• Provided object-oriented design, analysis, programming, and implementation for web applications with the .NET Framework (2.0 - 4.0) using both Web Forms and MVC2

• Also converted 40 Crystal Reports to SSRS using SQL Server Report builder.

• Served as a Team Lead of a large engineering group

• Was also tasked with writing code in VB .Net to interface with lab instruments to replace older applications utilizing Visual Studio 2010 and IIS 6

• The new application minimizes the number of operations that the technician has to perform to upload data from the instrument to LIMS(COTS product)

• Also, enhanced the BEIDMS report in LIMS to satisfy the customers needs, which included making calculation conversions in several PL/SQL packages/triggers while converting Oracle Reports and Forms in an Oracle environment