IT Projects

ITC Solutions | IT Projects

Projects Implementation

Leveraging our vast domain knowledge and in-depth technology expertise, ITC Solutions offers solutions designed to meet the specific needs of customers. ITS specializes in developing strategic software solutions for diverse industries and businesses, to enable them to gain a competitive edge and maximize their Return on Investments (ROI). We architect enterprise-wide technology solutions that are high performing, robust, reliable and meet the emerging challenges of both large and small organizations.

Our project implementation expertise is the following technology areas.

  • Cloud Migration: OnPrem to Cloud Migration (Azure and AZW)
  • Data Warehousing, Business Analytics and Data Visualization.
  • Mobile Development using Android and IOS.

Our Industry Domain Expertise in the following Areas.

  • Pharmaceuticals Industry
  • Healthcare and Hospitals
  • Telecom Industry

Our Core Expertise in Pharmaceutical Project Implementation Include.

  • Specialty Areas: Full Suite of Brand Scorecard Development and Support (Weekly, Monthly & Quarterly)
  • Data Mining Service
  • Comprehensive Data Warehouse & Business Insights Services
  • Extensive knowledge with IMS, NDC-Health, and Wolters Kluwer data
  • Custom Data Analysis & Reporting
  • Patient Level Data Analysis
  • Physician Level Data Analysis
  • Payer Level Data Analysis

ITC Advantage

  • In-depth understanding of the broach spectrum of Managed care influence on pharmaceutical.
  • Offering End-to-End Data Warehousing, Business Intelligence and Enterprise Performance Management solution.
  • Expertise in business analysis, data modeling, ETL Architecture Design, OLAP Solutions and Data mining while using IMS, Plantrak, Verispan, A.C.Neilson, Walter Kohlers sources of data.
  • Set of management processes and methodologies designed for client site execution or onsite-offshore execution
  • Cost Effective and on-time solutions.
ITC Solutions | IT Projects | ITC Advantage

Few of our Project Accomplishments

Client Name Project Details

Monthly/Weekly Scorecard Reporting

Technology: SAS, SQL Server, Excel (VBA) and PowerPoint.

Detail: Monthly scorecard will provide in-depth understanding of various tracking metrics linkage with overall Performance in terms of Rx Volume, Share and Growth (TRx and NRx) in various channels. he performance reports are based on secondary sales data from IMS health, Source of Business and Length of Therapy from Longitudinal Patient Level Data from any audit such as IMS, NDC or Verispan, Patient Flow metrics and any uptake from Hospital Data.


HealthCare Channel Management Portal

Technology: Business Objects, Oracle, Tomcat

Detail: This is a "read the business" Managed Health Care Tool that empowers the users to retrieve key plan level information by channel by geography. It will also allow users to create interactive queries on important facts and measures such as volume, share, volume change and share change. The Tool will finally enable the market research community to drill down to lower levels of granularity and generate reports on demand.

Sanofi, NJ

Medical Affairs Scorecard

Technology: .Net/Business Objects/Oracle

Detail: The salient feature of the USMA Scorecard project will be to provide a core framework that enables the Chief Medical Officer (CMO) to track key performance indicators and derive insightful information through reports driven off a readily available data repository.

Sanofi, NJ

User Access Management

Technology: Java, EJB, Weblogic & Oracle

Detail: Development of Network Security application for users.

Sanofi, NJ

Formulary Access Portal

Technology: ASP .NET (for user interface) and Cognos ReportNet 8 (for reporting).

Detail: Enhancements to the existing Formulary Portal application including the creation of a third-party data repository and host new data sources with the primary intention of improving data quality, and reporting.

Sanofi, NJ

Contract Development and Analytics Accrual System

Technology: ASP .NET (for user interface) and Cognos ReportNet 8 (for reporting).

Detail: Enhancement to the existing CAPS Application to provide end-users the ability to see and analyze contract accrual information. Some algorithms were developed that helped analyze variance from defined parameters (gross sales, market share, price, and total rebate dollars by contract entity, book of business and brand).

Sanofi, NJ

Fleet Data Mart

Technology: Data Interface and Administration Platform - ASP .NET, Reporting Tool - Crystal Reports XI,

Detail: Consolidated pertinent and identified data from three leasing vendors (PHH, ARI and GE) into a data mart for downstream reporting.