Sales Data

Therthappa Beeranahalli Siddappa

Phone: +1-609-***-****

E-mail: **********@*****.***

SUMMARY:

•Over 9 years of multi-faceted work experience in Pharma Data Analytics

•Experienced in the areas of Sales & Marketing Analytics

•Expertise in managing and analyzing large data sets to drive analytics-based decision making

•Generation of standard periodic reports using client in-house and IMS data

•Assisted in design and analysis of Primary and Secondary Market Research, Sales force effectiveness, Statistical analysis of IMS and Pharmaceutical data

•Proficient in Base SAS, SAS/SQL, Tableau and advanced MS Excel

•Good knowledge of IMS datasets especially NPA, Xponent, DDD and promotional audits

•Developed customized Excel based reports to track promotional and sales activities for newly launched products

•Working experience with offshore teams to manage and deliver projects

PROFESSIONAL EXPERIENCE:

Jan 2015 – Oct 2016: Consultant at QuintilesIMS, Managed Services, Parsippany, NJ

Roles & Responsibilities:

•Supported sales force operations team at a client place in designing and building excel based dashboards for brand performance and tracking activities

•Supported targeting and alignments team at a client place in their day-today activities. Reports included weekly, monthly and adhoc reports, tenure based analysis, target reach and frequency reports

•Analyzed national and sub national level prescription data to evaluate segmentation and promotional effectiveness for a brand

•Experienced in analyzing rep level performance reports based on activity and sales data(physician or account level)

•Worked on detailed Documentation and specifications, including business process documentation and SOPs

•Coordinated the project delivery across different external vendors and off-shore team to meet the quality and project timelines

•Helped internal IMS team in building proposals and in developing sales leads

•Mentored and trained new team members

Sept 2006 – Dec 2014: Consultant at IMS health, GTS, Bangalore

Roles & Responsibilities:

•The Sales & Promotional Data analysis using SAS & MS Excel, created presentation

•Supported Incentive Compensation team on quality check for IC payouts

•Multi-Channel Analysis, physician and patient level primary data analysis including rep surveys

•Generating monthly reports for the various brands by considering certain Key Performance Indicators like Share of Voice, Market Share and Send monthly reports in the form of an Excel tool

•Providing an in-depth understanding of the market structure in terms of given therapeutic class and competitive landscape of identified high potential countries and the objective was to support the client with long term strategic decisions to launch and expand Company X’s portfolio in a particular therapeutic class

•Periodic data updates in the Excel based tools with data cleaning and quality checks

•Extracted and prepared data for statistical analysis based on business requirements

•Designed front end view for Excel based tools based on business needs and assisted programmers to create dashboards and QC the outputs

SKILL SETS AND STRENGTHS

Strong Knowledge of IMS datasets (Sales, Rx & Promotional data) and SMART MVP tool

Sales Analytics: Reporting, Ad-hoc Analyses, custom dashboards for tracking Sales and activities

•Sound technical knowledge of MS-Office (MS excel, MS Access, MS Word and MS PowerPoint), SAS (DATA step, various PROCs and SAS SQL) and Tableau

•Statistical Analysis: Descriptive statistics, Hypothesis Testing, ANOVA, Correlation and Regression analysis

•Good with communication skills and leadership qualities

•Reliable and good team player

Education

• M.Sc. in Agril. Statistics Dharwad, India 2004- 2006 - 8.39 GPA

• B.Sc. (Agri.) Bangalore, India 1998-2002 - 7.58 GPA

Personal Info

• Employment Authorization: H1B Visa (valid through Sept 2017 and then it can be renewed for next 3 years)

• Currently located in New Jersey and open for relocation

Contact this candidate