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