Gaurav Garg

Product Manager

Gurgaon, Haryana, India14 yrs experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 10 years of experience in Business Intelligence and Data Analysis.
  • Expertise in Healthcare and Banking sectors.
  • Proficient in SQL and Data Warehousing technologies.
Stackforce AI infers this person is a Data Analyst specializing in Healthcare and Business Intelligence.

Contact

Skills

Core Skills

Business IntelligenceData AnalysisData VisualizationData WarehousingEtl

Other Skills

.NETAnalyticsBusiness AnalysisC#Core JavaDatabase DesignDatabasesExtract, Transform, Load (ETL)Healthcare IndustryHealthcare Real World Evidence (RWE)LinuxMedical CodingMicrosoft AzurePL/SQLPerformance Tuning

About

• Cumulative experience of 10 years as Business Intelligence Developer and Data Analyst in Banking and Healthcare sector - with a good understanding of Healthcare domain and a substantial knowledge of tools and techniques used in the industry to generate actionable insights. • Hands on experience of how various aspects (Physician, Payers, Patients, Pharmaceuticals) interact and impact each other within US Healthcare. • Responsible to perform the requested analysis on the client data which was high end life sciences data. The results of our analysis are then utilized for better drug preparation, clinical trials, paper publishes etc. • Experience working with Real World Evidence (RWE) and clinical operation data to establish and evaluate baseline performance measures and trends. • Have created documents are various stages of SDLC like Solution Design, Process Document, Data Dictionary and Offline file documents. • Involved in huge data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert. • Worked in building the T-SQL by understanding the logic based on the BRD document signed off by the client. • Have extensively worked in creating wrappers like Stored Procedures, Functions and Cursors to manipulate and retrieve data for reporting requirements. • Created Indexes and Partitions for better ease of querying performance and maintenance of data snapshots. • Created package templates using SSIS tool to help build the Data Warehouse and Data Mart for reporting needs. • Have created Error Handling, Logging and Auditing in SSIS packages for better handling erroneous records and to understand the point of failure and tasks that are taking more time to execute. • Strong analytical and problem solving skills that encompass identifying data anomalies, providing data analysis and presenting complex data in a clear, concise and executive level format.

Experience

Nthrive

Technical Team Lead

Apr 2018Present · 7 yrs 11 mos · Gurgaon, India

  • Patient copay/out of pocket analysis
  • Extract, Analyze the raw data (in forms of Excel/CSV/Text files) using SQL queries, produce analysis reports.
  • Physician referral analysis
  • Patient copay/out of pocket analysis
  • Hospitals/Clinics Segmentation and Targeting
  • Creating analytic datasets and implementing dashboard using PowerBI.
  • Developed various product based Dashboard for clients.
SQLPowerBIData AnalysisData VisualizationBusiness Intelligence

Decision resources group

Analyst

Jun 2015Apr 2018 · 2 yrs 10 mos · Bengaluru Area, India

  • Analyze claims data to understand Patient, Physician, Provider & Payer dynamics from medical & pharmacy transactions.
  • Perform Patient longitudinal analysis
  • Identify Switching patterns across competitor products
  • Experience with data visualization tool Tableau
  • Compute Persistence & Compliance
  • Creates optimized views and data marts to address specific business use cases
  • Write database queries to aggregate and structure data, and build online dashboards using Tableau
  • Query insurance claims and electronic health records databases to profile patients of a certain disease state, ensuring that the technical specifications of the query output is aligned with the business need
TableauSQLData AnalysisData Visualization

Equifax

Analyst

Apr 2012Jun 2015 · 3 yrs 2 mos · Bangalore

  • Create a Data Warehouse and implement Business-Eye, Daily load data to DataMarts and providing analytical KPI for BusinessEye reports. Divided over multiple module and phases like Credit Cards, Prepaid Cards, Picture Cards, Customer Acquisitions, IVRS, Finance, Portfolio, etc.
  • Worked on Error Handling, Logging and Auditing in SSIS packages for better handling erroneous records and to understand the point of failure and tasks that are taking more time to execute.
  • Provide an Integrate Inbound (Responses) and outbound communications by defining and setting a process/sequence based system of communication to customers of Bajaj Finserv.
  • Provide tracking and metrics on data at a Campaign, Channel and Customer Level to assist in Bajaj Finserv aim towards more effective and specific communication to customers.
SSISData WarehousingSQLETL

Education

vishveshwarya institute of engg. &technology

Bachelor of Technology (B.Tech.) — Computer Science

Stackforce found 100+ more professionals with Business Intelligence & Data Analysis

Explore similar profiles based on matching skills and experience