Data Analyst

Megha Singh

Senior Analyst

A proactive and fast learning individual, seeking an opportunity to work and grow as a data analyst; utilizing Statistical, Analytical, Visualization skills and relevant expertise to help the company achieve business goals.

adcid5@r.postjobfree.com 408-***-**** 3737 Casa Verde Street, San Jose, CA, 95134

Skills & Competencies

Data Management Data Quality Assessment, Data Analysis, Statistical Data analysis (t-test, chi-squared, ANOVA, Stated vs Derived analysis), Data Validation, Pattern Trend Identification, Data Visualization (SPSS, Tableau), KOL Identification & Profiling, Benchmark Analysis

Computer Science Tableau, SPSS, SQL, WinCross, E-Tabs, Advanced Microsoft Excel Functions, Power Point, Troubleshooting

Research Primary Market Research (PMR) & Secondary Market Research (SMR), PMR & SMR Data

Analysis & Reporting, Knowledge of Competitive Landscape

Work Experience

Senior Analyst

Decision Resource Group

09/2017-Present

I am involved in each step of the research process from survey design to report writing. My key responsibilities lie in primary market research report production (syndicated and custom reports) including data cleaning and analysis.

Provide data visualization through Tableau, SPSS, Power Point and excel to the repertoire of in-house primary research reports (Access and Reimbursement, Current Treatment, Emerging Therapy, Digital Market, Treatment Trends).

Analyse the survey dataset by performing various hypothesis testing (t-test, chi-squared, ANOVA, Stated vs Derived analysis) within each report through SPSS Custom Table.

Manipulating, cleansing, analysing, tabulating and processing data using Excel and SPSS.

Experience in SPSS for creating summary reports, Generating Tables through SPSS (C-tables).

Perform persistency, drug switch and drug compliance analysis on real world data, Truven, through Microsoft SQL server queries and created report output in excel format for further study.

Experience in writing SQL to interface with Tableau for Data visualization or conduct analyses.

Design and develop Tableau Server reports utilizing data from multiple sources.

Analyse digital reports through Wincross (a tool to convert SPSS dataset into XML language) and E-tabs (a cross-tabulation tool which uses XML language and automates research reports through programming).

Analyst

Decision Resource Group

02/2015-09/2017

Populate databases (e.g., drug information, company deals, pricing, launch dates, global market access statistics) with information provided from various sources including secondary data from information resources or research teams or data

Extract data as needed for delivery to analyst teams

Creation and population of PowerPoint templates (including leveraging technology Creation and population of PowerPoint templates (including leveraging technology such as e-tabs to produce), tables, figures, and graphics, in support of building final client deliverables

Interpreting data and bulleted text provided by Analysts and other staff and translating them into carefully crafted presentations and other professional deliverables.

Performing edits on reports, slide decks, consulting projects, and other company publications to ensure professionalism and quality and adherence to house style

Identifying discrepancies and spotting holes in logic between text and data tables

Market Research and Competitive intelligence for report for many healthcare and Pharmaceutical clients

Provided Sales and Marketing Analytics for a Fortune 500 pharmaceutical client

Pharma Business Analyst

D2L Pharma Research Solutions

11/2012-02/2015

KOL (Key Opinion Leader) Identification of Type-2 Diabetes, Schizophrenia, Hematological Tumor

Identifies the top 50 KOL among the 150 opinion leader across the globe and profile the detail activities of the KOL and rank them and track and update the database

Key Opinion Leader (KOL) identification, mapping and ranking, KOL tracking and continuous updates, Rising Star identification, KOL management and activity planning, physician influence mapping, and KOL database application/platform development (Hematological Tumor, Schizophrenia, Type -2 Diabetes, Sickle Cell Anemia, Tissue Scaring).

Strong logical reasoning & quantitative techniques of KOL Identification & Management Data Analytics

Research Trainee

Praxair India PVT. LTD

07/2011-07/2012

Microbial Control in Cooling Tower by Ozone: Working on research programs related to use of Ozone to control microbial contamination in cooling tower operations. It is intended to replace expensive chemicals/biocides, for cost reduction. Role was focused on finding & analyzing half lives of microbial species growing in cooling tower to optimize ozone dosage

Sugar and Textile bleaching by Ozone: Participated in research experimentations to replace Sulfur dioxide with Ozone during the Sugar refining process. Also worked on technology related to replacing Hydrogen Peroxide with Ozone in the textile industry. The objective for both experiments were focused on cost reduction and enhanced quality

Achievements

Got Next Generation Leader Award in company D2LPharma Research Solution.

Got “Impact Award” in Decision Resource Group.

Soft skills and Communication Skills Training under “HEWLETT PACKARD” at VMKV ENGG. College, Salem (Tamil Nadu)

Got 3rd prize in Phytoremediation Poster Presentation in National Seminar

Education

Education

School/College

Board/University

% of Marks

Year of Passing

Sec.School (Matric)

Mount Carmel, Digwadih

ICSE

67

2003

H Sec (I.Sc.)

St. John’s School, Varanasi

ICSE

65

2005

BE(Biotechnology)

VMKV Engg. College, Salem

Vinayaka Mission University

77

2007-11

Interest

Data Visualization, Data Analysis, Exploring Python and R

Contact this candidate