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 Costs, Risk Score Trends, and Quality Metrics,Developed advanced Azure SQL to transform the input datasets with a dynamic design leveraging dynamics data sources using Table-Valued UDFs. The end-results of this transformation process establishes a reporting data structure to show the episode outcomes of the patient care journey. Led a cross-functional team to develop a comprehensive CMS Certification system designed to optimize data integration with the Centers for Medicare & Medicaid Services. This innovative solution equipped the Tennessee Medicaid program (TennCare) with a custom star schema database, SSAS Cube, and Power BI Dashboard, seamlessly integrated with custom web pages for reviewing and approving metric KPI submissions to CMS. The system's design incorporated robust security measures, including configuration tables and role-based access controls, to protect sensitive data and ensure compliance with regulatory requirements. By providing a centralized platform with enhanced data management capabilities, real-time metrics, notifications, and data-driven insights, this system empowered TennCare to consolidate data from external vendors into a centralized database and effectively support its mission of delivering high-quality healthcare services offered to Tennessee residents. The system also automates data collection and notifications, reducing the risk of penalties or sanctions by ensuring accurate and timely data submission to CMS. The Power BI dashboard provides a visual representation of key metrics, enabling stakeholders to easily analyze trends & identify insights.

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 with Tableau.• 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.

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 Viewpoint).• 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.

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 action to operate more efficiently. • 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, estimates, database design, reporting, dashboard generation, and development/support of ETL processes for Finance, Sales, Marketing, and Demand Planning teams.• 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 architecture.• Developed ETL with SSIS and T-SQL to load Infor XA ERP information into the Data Warehouse.• Managed and maintained vendor relationships by serving as a single point of contact for contractual matters.• Delivered BI content in Cognos to establish insights to the business for Demand Planning, Finance, Marketing, and Sales teams.• Built Plant Health dashboard for production planning group and CFO Dashboard for Finance team using Power BI.• Migrated/supported SSRS reports from Visual Studio 2008 BIDS to Visual Studio 2014 SSDT, for EventTracker system.• Prepared funding requests, lead strategic planning along with managing and tracking capital and operating expenses related to BI

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, and SQL Server Management Studio.• 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 database was MS SQL Server 2005 and the system is delivered with Ultipro provided Cognos packages. • 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.

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 of the HR systems. Facilitated management of customer’s work request queue, and conducted system upgrades of both Ultipro and Kronos. Utilized MS SQL Server, ASP.NET,VB.NET, XML, stored procedures, user defined functions, SSIS, VBScript, VBA, Excel, Cognos 8 BI, Report Studio, Cognos Connection, Framework Manager, Kronos Connect, Taleo Connect Client, Ultipro SDK, and SharePoint. • 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.

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 services.• 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.

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, VB.NET, MS SQL Server and DotNetNuke framework for the development. • 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 sign on, providing for seamless integration from a core Windows Application called MiSys to view x-ray images rendered by a Sectra PACS web server. This solution called for the MiSys report sub-system to render output in HTML format. The design required development of HTML, Javascript, C# classes, and utilization of the .NET Com Interop feature to marshal calls from COM clients.

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, VB.NET, C#,Web Services, and Crystal Reports for developing the system. • 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, eliminating the need to store key documents manually and drastically reducing the costs for paper.

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 organizations. Developed core set of stored procedures to be used with data access components of the system.• 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: Innovated standardized and reliable methodology to develop web applications in the Enterprise Architecture Group. Development done with ASP using Visual InterDev, Visual Basic COM+ components, Stored Procedures, user defined functions, triggers, and DTS. New design principle used a template based framework approach utilizing the Microsoft DNA Architecture.• 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: Designed and developed a Supply Chain Visibility application to provide EDI interface to SAP system to track shipments using Visual Basic, SQL Server, and Crystal Reports.• 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