Richard Kroeger Email & Phone Number

Cocoa, FL, US

Pennsylvania, Harrisburg, US

Advisor on Episodes of Care initiative for TennCare. Solution provides a new process for tracking patient healthcare journeys across 48 episodes. Performed a comprehensive data analysis of SQL tables ingested from a data brick that was generated from a centralized MMIS database. Developed Tableau Dashboard pages to view visual summary of Care Category.

• Developed and enhanced Data Warehouse (DWH) to store OTB (Off Track Betting) and Epicor ERP data in support of migration from MS Access architecture with Excel reports and Access Dashboard, to new SQL Server platform.
• Worked with controller to gather data requirements and establish business rules.
• Developed complex VBScript jobs for ETL process to populate data warehouse structure.
• Developed Tableau content referencing the DWH to validate against the Excel reports pulling from MS Access.

Brewster, New York, US

• Developed, enhanced and deployed custom dashboards with Tableau, queries used by Customer Web Portal, and Crystal Reports that reference SQL Server in support of ERP Migration from Sage MAS 500 system to Vista (by.
• Made enhancements to Fuel History and Plant Production Dashboards to leverage datasets sourced from new and legacy systems.
• Developed/Enhanced/Supported SAP Crystal reports integrated with new ERP system.
• Developed/Enhanced/Supported business rules and process around data cleansing, consolidation and validation, etc.
• Developed/Enhanced/Supported new and existing data flows from multiple source systems.

Greenwich, CT, US

• Designed, developed, enhanced and deployed custom dashboards with Tableau that use custom queries written in Hive over Hadoop using SQL Workbench/J that reference the company’s client healthcare data.
• Developed Dashboards to provide analysis on Physician Engagement, Skilled Nursing Facilities, Facility Advisor and more.
• Developed HQL Scripts to transform data from Hadoop to create data analytics used to show trends and establish new insights to help Cedar Gate Clients see opportunities to reduce high costs and establish plans of.
• Developed R scripts to operationalize the quarterly process of generating views

• Primary liaison with key stakeholders and domain experts to establish business intelligence strategy and translating business requirements into technical specifications. Responsible for budgeting, project planning.
• Modernized and transformed legacy BI platform powered by GPS written by Exact Software to IBM Cognos BI
• Used Agile Development method with Scrum framework for collaboration on complex projects
• Establish project plans to direct technical resources I hired and managed
• Lead implementation of Enterprise Data Warehouse, coordinating efforts of business partners, IT peers and external technical resources to design, develop and implement a comprehensive data schema and technical.
• Developed ETL with SSIS and T-SQL to load Infor XA ERP information into the Data Warehouse.

Weston, FL, US

• Responsible for designing, developing and deploying custom HR solutions for corporate customers in SaaS environment using Cognos Connection, Report Studio, Event Studio, IBM Cognos Administration, Framework Manager.
• Developed Dashboards for System Usage Tracking, Payroll, and Benefits Open Enrollment.
• Conducted onsite Business Intelligence Workshops and remote knowledge transfer sessions.
• Developed reports for Payroll, Benefits, Recruitment, Talent Management, Time & Attendance, and Performance Management.

• Designed and developed custom reports using Cognos Report Studio for the Corporate HR Organization in preparation for migration to UltiPro, a Payroll/Benefits system distributed by Ultimate Software. The underlying.
• Developed reports to help validate interfaces with internal systems and third party vendors.
• Produced reports for data quality assurance.
• Developed numerous custom reports for support of Payroll, Benefits, Tax, Finance, General Ledger, and workforce operations.

Rio De Janeiro, RJ, BR

• Provided data analysis, consultations on business problems, and identified enabling technologies. Constructed requirements specifications, supervised consultants and developed custom interfaces and web pages in support.
• Developed various dashboards for HR with dynamic content with cascading prompts, complex filtering, charts, and drill throughs.
• Implemented ETL processes to pull data from HR database into a new OLAP database for reporting diversity trends.
• Standardized and streamlined process to capture commission’s data reducing time for the payroll cycle.
• Integrated new business-to-business workflow with relocation vendor to reduce complexity of managing this data for payroll.
• Developed Active Directory interface, enabling architecture to use Windows Integrated Security and introducing Single Sign On.

New York City, NY, US

• Conceptualized, designed and led development of key components of the Claims Management product that was used by enterprise class customers such as GE. The design utilized VB.NET, ASP.NET, MS SQL Server, XML, and web.
• Constructed add-on module for the Claims Management product to integrate the ISO ClaimSearch web service, which resulted in faster claims processing and virtually eliminated the potential for fraudulent claims.

Menlo Park, CA, US

• Aquarion Water Company – Monroe, CT Analyzed results of a Capgemini business study into the Quick Wins project. Delivered requirements specifications for the Quick Wins project; used Ingres Database server, ASP.NET.
• Designed and implemented the SQL Server database and method to access Ingres data.Hospital of Saint Raphael – New Haven, CT Designed and developed an authentication process using a hashing algorithm to enable single.

US

• Architected, designed, and developed a system called TITLEtrak.net to provide services as an internet Application Software Provider for the title and settlement industries. Used MS SQL Server, Cognos, XML, ASP,ASP.NET.
• Introduced database design supporting a service provider model to generate revenue from other title companies using TITLEtrak.
• Developed Reporting Subsystem using Cognos Impromptu that enabled all provider companies with a set of standard to manage their pipeline of work more efficiently.
• Constructed document management sub-system using LeadTools imaging components, that provided a user interface for scanning over the internet. Used an xml interface to upload/download documents to and from the database.

• Right Source Inc. – Wilton, CT Aug 2001 – Nov 2001Consultant/Software Developer Assessed the Lead Capture Notes Application to design and implement new DB2/UDB database to support new initiative for marketing.
• Delivered a J2EE prototype for the Lead Capture Web application that utilized JSP, custom tags, and Servlet components.Metropolitan Life Insurance Company – New York, NY Sep 2000 – Jun 2001Senior Software Developer.
• Rapidly developed a Licensing System for Compliance organization, eliminating continual fines exceeding $1 million per year. Guinness Bass Import Company – Stamford, CT Mar 2000 – Aug 2000Consultant/Software Developer.
• Facilitated reports about delays in delivery to allow for intervening with shipping companies to improve on-time service by 40%.Thirteen Contracts with IBM completed prior to March 2000 available upon request

Computer Science

Physics

Education record

Education record