Kenneth Kirkpatrick Email & Phone Number

Birmingham, Al, Us

Birmingham, Al, Us

Chicago , Il , Us

Montreal, Quebec, Ca

Data integration, data warehouse and BI reporting projects with new and existing client agile teams to complete large scale projects within time and budget constraints. Clients include: Fortune 500 bank, regional utility corporation, nuclear power company, multi-national bank and state board of education. Procurement report development using Cognos Analytics v11.1. FDIC regulatory reporting data mart using Hadoop, Hive & Impala sources. Wealth Management data warehouse project - Microsoft VS 2015 - SSIS & SSRS for data integration, aggregation and reporting. Developed comprehensive performance sales reports. Data warehouse project for inventory tracking and financial reporting. Microsoft VS 2015 - SSIS & SSAS - Tabular model. Target data used with Power BI.Customer Intelligence Analysis mart - Oracle PL/SQL for custom data process, extract and analysis.

Birmingham, Alabama, Us

- Lead developer for financial and accounting objects in the enterprise data warehouse using Microsoft Visual Studio- Utilized SQL Server Integration Services to migrate, land, transform and aggregate data from multiple internal systems.- Report and presentation development using SQL Server Reporting Services - Corporate scheduling and automation solution – Control M- Applied Agile framework tools in project management and delivery- Used ServiceNow software to track projects, tasks, incident resolution and problem management - Responsibilities for IBM Cognos reporting and ETL framework maintained and monitored by a third party vendor- Research using other BI data tools – SSIS, SSRS, SSAS, Power BI, Pyramid

Birmingham, Alabama, Us

Lead a team of eight FTEs in the project delivery of financial and accounting ERP solutions for a financial service holding company selling insurance and annuity products. Managed and expanded the team to be responsible for the reliable, secure operation of critical financial systems. Interfaces included GAAP and STAT financial reporting, expense management, budget, multiple account reconciliation systems, unclaimed property, tax reporting, OFAC, supplies, purchasing, reinsurance, and various bank interfaces. - Provided data integration solutions for financial software including - Infor SmartStream ERP, Infor T&E Expense Mgmt, Infor Performance Mgmt Budget, TrinTech AssureNet balance sheet recon system. - Developed and supported diverse platforms - MSSQL, Sybase, and Cobol CICS mainframe.

Birmingham, Alabama, Us

Provided primary support for the Infor SmartStream ERP system and decentralized accounts payable installations across the company and country. Served as liaison between programming and lines of business to help develop specifications for system corrections and enhancements.- Responsible for System Development Life Cycle (SDLC), including defining requirements, design, coding, testing, validation, implementation, and support.- Used SDLC in the implementation of the Chesapeake Systems TRecs Total Reconciliation system. Designed custom, bilateral interfaces to existing GL, AP, commissions systems, bank interfaces, and enhanced matching techniques

Bachelor Of Science (B.S.), Corporate Finance

Master Of Business Administration (M.B.A.)