Visheshta Mertiya Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

• Customer 360 - One stop customer insights solution for field and marketing teams to understand physician prescribing preferences and engagement journey to better target customers across segments.• Brand Reporting - Helped clients with deep brand and marketing performance insights across pre/mid/post launch phases through enterprise scale brand performance reporting solutions, enabling rapid decision making and brand strategy across product portfolios.• Field Reporting - Enabled holistic Field effectiveness and Healthcare Provider (HCP)/ Healthcare Organization (HCO) performance reporting solutions to orchestrate meaningful and contextual engagement with target customers.• Value & Access Reporting - Driving key pricing, contracting, and Patient Support Program (PSP) design decisions across product portfolios through intuitive market access reporting solutions.

Bengaluru, Karnataka, India

Gurugram, Haryana, India

• Tableau Reporting - Analyzing user requirements and validating the available data to propose usable designs. Interacting with multiple stakeholders to gather business needs & develop technical specs. Conceptualizing and developing novel reports & dashboards on Tableau. Converting pre-existing Excel based reports to Tableau dashboards.• Data Blending & Transformation - Accessing and transforming massive datasets through filtering, grouping, aggregation and statistical calculation. Connecting different data sources to extract uniform data & create views that deliver important insights.• Data Visualization & BI - Deploying rich graphical visualizations in dashboards to create effective views of data such as: Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Tree Maps, Heat Maps, Area Charts, Gantt Charts and Bullet Graphs in Tableau Desktop. Implementing advanced Tableau features such as parameters, table calculations, sets, groups, user filters to deliver highly usable dashboards. Highlighting views by using Annotations (Points, Marks, Area, etc.) wherever required. Creating Tableau Dashboards with interactive views, trends and drill downs.

Gurugram, Haryana, India

FINANCIAL: Finding Potential Credit Card CustomersKeyword: Data Cleaning, Model Development, Model Validation, Model ComparisonSAS: PROC Means, PROC sort, PROC Freq, PROC Logistic, PROC Reg, SAS/Macro, PROC SQL• Predict prospective buyers.• Differentiate the key characteristics between buyers and non-buyers, focus on predicting prospective buyers from existing customers.• Initial exploratory data analysis using PROC Freq and PROC Means, missing value imputation using PROC Stdize.• Outlier treatment, Rank ordering (Scoring), KS Statistics and variable reduction technique on the basis of IV value.• Built Logistic Regression model and studied the ROC curve and other generated parameters, such as concordant/discordant, betas etc.RETAIL: Resource Optimization by finding out Potential customers for an upgrade campaign of a co-branded cardKeyword: Data Insight, Merge Data, Segmentation, Clustering, Grouping, Summation, Comparison, Dunnett, Tukey, Statistical Significance SAS: PROC Stdize, PROC rank, PROC t-test, PROC GLM• Identified the best in class card types through ANOVA and Post-Hoc analysis• Compared the Pre-spend and Post-spend of the customers who had migrated from private card to co-branded card through t-test• According to availability client budget, identified best customer segment for migration

Bangalore

• Learned the work-flow of departments in R&D – FD (Formulation Development), Analytical Department, Quality Assurance Department, PDC (Packaging & Development Cell), Microbiology Department, Marketing Department.• PDC – Types of packaging system, Ideal requirements of pharmaceutical packaging material, Selection of packaging material, Containers of pharmaceutical packaging.• Software used in PDC – Online Artwork Management System, TrackWise, SAP (System Applications & Products in Data Processing), LIMS (Laboratory Information Management System).