Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Vikrant Patel

Princeton,NJ

Summary

Director of Software Development Engineering at IQVIA specializing in transforming legacy systems into cutting-edge cloud solutions. Expertise in data architecture and modeling, with a proven track record of leading teams to execute effective data integration strategies. Strong project management skills, consistently achieving compliance approvals and enhancing operational efficiency in high-pressure settings. Knowledgeable professional with several years of experience bringing planning and problem-solving abilities. Focused on maximizing resource utilization to support scalable operations and increase bottom-line profitability. Organized and systematic with natural relationship-building and leadership talents. Results-oriented professional bringing expertise in accounting, supply chain management, and marketing. Successful at overseeing all areas of daily operations and making effective policy decisions to positively impact business direction and bottom line profits.

Overview

25
25
years of professional experience
1
1
Certification

Work History

Director, Software Development Engineering

IQVIA
King Of Prussia, USA
09.2023 - Current
  • Transform client CRM system for patient support services from legacy Salesforce, SQL Server technology to latest technology Microsoft PRM system, Public cloud cluster (Azure)
  • Download all data from Sales Forces system to data lake developed in Azure cloud cluster
  • Build automated routine using latest Spark version and schedule in Airflow
  • Architect Data Lake (Bronze, Silver, Gold)
  • Present to IQVIA compliance team and address all questions related to security and receive compliance approval so that PHI information data can be stored and managed
  • Work with legacy development team, identify all entities/attributes used in legacy system and load into data lake
  • Download and keep old historical data
  • Work with business team, identify the entities/attributes needed to be transferred from old legacy system to new system
  • Directing and Leading technical team for lift and shift history data from legacy system to PRM
  • Developed the interfaces needed for transferring data from PRM system to reporting systems which used other data sets like Claims data, copay data and provide linkable report
  • Developed the customized operational reports requested by client
  • Understand measures, metrics, download data from PRM and schedule job (Hourly, Daily, etc) and generated the report with the help of Power BI team
  • Troubleshooting production problems in crisis and demanding situations
  • Environment: Apache Iceberg, Microsoft Azure, Data Bricks, Scala/Spark, Airflow, UNIX Shell scripting, PowerBI, MS Excel, Smartsheet, MS Visio

Associate Director, Enterprise Warehousing

IQVIA
King Of Prussia, USA
06.2014 - 08.2023
  • For Sanofi/Regeneron, Build (Architect, Design and develop) enterprise data warehouse for Atopic Dermatitis, ASTHMA, Nasal Polyps, EOE, COPD markets
  • Build Amgen AI Platform and Novartis Custom IV Platform
  • Worked with business stake holders who collect information from multiple client teams and generalize requirement for building enterprise data warehouse
  • Understand requirements, design data model, define rule-based input files/tables, defined input parameter tables; confirmed same with business units and implement on timely manner
  • Directing and Leading Enterprise Warehouse and Data Integration (EWDI) Development Team for developing new standards and processes as required to increase the efficiency of requirements, design, and development activities
  • Involved in decision making for defining data sets (For eg: NPA, XPO, DDD, LAAD, DX, Patient Companion) needed for building National and Subnational reports and defining methodology
  • Architect, design, developed and implements Sanofi Dupixent Platform for multiple markets which used as source for various national and subnational analytical reports for Sanofi and for Regeneron
  • Re-Architect, design and developed Amgen AI Platform, Novartis Cosentyx IV Platform, Immunology RA enterprise platform which used as source for multiple client specific custom data marts and for adhoc request
  • Design logical and physical data models, defining subject areas, architect fact tables, dimensions, aggregate tables, and educate the team
  • Understand data driven business rules, automate using rule-based input files/tables
  • For eg: Methodologist should able to define co-coding rules for identify correct procedure drug administered, indication assignment for new products using Excel template and pass the data-driven rules to system
  • Work as Subject Matter Experts (SME) and answered the day-to-day business questions for enterprise platform
  • Perform impact analysis prior/after implementing new methodology and business rules
  • Supported data investigations for existing enterprise data warehouse and resolved issues in timely manner
  • Established and maintained inter-department communication so that roles, requirements, dependencies, decisions work processes and time estimated are clearly articulated and understood
  • Provided guidance and mentoring to less-experienced staff members participated in code reviews as well as in the development of coding standards to ensure high levels of performance, data quality and maintainability
  • Troubleshooting production problems in crisis and demanding situations
  • Environment: Hadoop Eco System, Scala/Spark, Cloudera Work Bench (AIML Modeling), UNIX Shell scripting, ERwin, MS Visio, TOAD, UltraEdit, Airflow

Sr. Manager

IQVIA
06.2008 - 05.2014
  • Architect, Design and develop analytical patient centric custom data marts for large pharmaceutical and healthcare companies
  • Supported day-to-day client business questions for existing data marts and perform ad hoc studies in very short notice
  • Understand business needs/questions, define metrics and measures, confirmed same with business units and deliver on timely manner
  • Lead a data mart/data warehouse development team through the ETL Architect, design, development, test, automation, and maintenance aspects of new data mart implementations
  • Design logical and physical data models, defining subject areas, architect fact tables, dimensions, aggregate tables, and educated to the team
  • Managed the day-to-day operations of existing data marts, including production support and development activities for enhancements
  • Ensured timely completion and delivery of data marts to the client
  • Participated as integral member of the Data Mart Solutions Architecture Team, developing new standards and processes as required to increase the efficiency of requirements, design, development, testing, deployment and documentation activities
  • Established and maintained inter-department communication so that roles, requirements, dependencies, decisions work processes and time estimated are clearly articulated and understood
  • Managed day-to-day
  • People
  • Issues such as task assignment, performance reviews, planning vacations, work schedules, training, and process compliance
  • Provided guidance and mentoring to less-experienced staff members participated in code reviews as well as in the development of coding standards to ensure high levels of performance, data quality and maintainability
  • Troubleshooting production problems in crisis and demanding situations
  • Environment: Oracle11g, SQL, PL/SQL, UNIX Shell scripting, ERwin, Micro strategy, MS Visio, TOAD, UltraEdit

Senior Data Mart Architecture

Universal Software Corporation
09.2006 - 05.2008
  • Participated in designing and developing analytical data marts for large pharmaceutical companies
  • Loaded and transformed projected and/or non-projected pharmaceutical data and medical data from enterprise data warehouse to the client specific custom data marts
  • Applied custom client specific business rules; calculated TPM (True Patient Measures), Line of Therapy, Regimen calculations, and generated metrics for BI systems
  • Worked with multi-terabyte data that crosses several platforms and includes multiple types of healthcare data
  • Created data models and process flows to extract, transform and load data for complex custom projects and then works on their implementations
  • Created database objects, program triggers, stored procedures, packages and ensures optimal performance of the system
  • Provided comprehensive documentation upon completion of every project
  • Work with large data volume imploring various query optimizations and tuning techniques
  • Mentored junior members of the development team and provides consulting on data usage standards to database developers and business consultants
  • Created database and process flow design and coordinated implementation of two on-demand reporting engines
  • Managed working on multiple projects simultaneously
  • Performed ad-hoc requests and creates reports on very short notice
  • Interacted with business units and project managers to determine reporting needs, reviewed requirements and provide updates on project status
  • Environment: Oracle9i/10g/11g SQL, PL/SQL, UNIX Shell scripting, ERwin, Micro strategy, MS Visio, TOAD, UltraEdit, TIDAL

Senior Data Warehouse Architect

Corporation Service Company (CSC)
Wilmington, USA
04.2006 - 09.2006
  • Generated AR financial trend reports and aggregated invoice details for financial project managers.
    Developed ETL processes with Oracle Warehouse Builder to load data into data warehouse.
    Designed star schema for data marts, defining business objects for analytics.
    Constructed business universe supporting OLAP reporting across customer, branch, and product dimensions.

Specialist Java Developer

EllisDon
Toronto, CANADA
04.2005 - 03.2006
  • Designed and developed a graphical reporting application system with diverse chart types.
  • Accessed data requirements for JFREE Chart to ensure accurate representation.
  • Defined datasets for bubble, 3D, bar, pie, and combined axis charts.
  • Created generic hooks for data retrieval from Lotus Notes (Domino) database.

Java J2EE Consultant

PEPSI-CO Europe
06.2000 - 01.2005
  • Implemented Master Files (MF), Master Files Interfaces (MFI), Local Management (LM) System, Hand-Held Computer (HHC) System, Host Validation System (HVL), Organized Trade Sales (OM), Inventory Management System (IM), and Global Sales System (GSP).
  • Designed and developed object-oriented modules using Java/J2EE for Customer Master, Route, Product Master, etc.
  • Consolidated sales documents generated by the HHC system and OM systems.
  • Developed a Host Validation System for validating sales documents and released a settlement document for the reporting system.

Education

Masters -

Computer Science
04.2000

Skills

  • Data architecture and modeling
  • Cloud computing solutions
  • Data integration and ETL
  • Project management

Certification

  • IQVIA CEO Award
  • Oracle Certified Professional – Advanced PL/SQL Developer
  • Java Sun Certified Programmer

Timeline

Director, Software Development Engineering

IQVIA
09.2023 - Current

Associate Director, Enterprise Warehousing

IQVIA
06.2014 - 08.2023

Sr. Manager

IQVIA
06.2008 - 05.2014

Senior Data Mart Architecture

Universal Software Corporation
09.2006 - 05.2008

Senior Data Warehouse Architect

Corporation Service Company (CSC)
04.2006 - 09.2006

Specialist Java Developer

EllisDon
04.2005 - 03.2006

Java J2EE Consultant

PEPSI-CO Europe
06.2000 - 01.2005

Masters -

Computer Science

Similar Profiles

CREATE PROFILE
Vikrant Patel