Sales Data

Pavani Motamarri

Email: ********@*****.*** Phone: 856-***-****

Summary

. Marketing Analyst with more than three years of experience in

Pharmaceutical industry.

. Worked with various data sources to design and create launch track

reports, sales force performance, sub-national / regional reports, and

patient metrics.

. Delivered complex AD-HOC Reports on daily basis addressing client

requirements.

. Excellent analytical, decision making, problem solving, communication

and interpersonal skills, and self-motivated to implement next-

generation paradigms

. Thorough Knowledge and experience of Microsoft Office tools like MS

Access, MS word, MS PowerPoint, MS Excel.

. Programming experience in heterogeneous data environment involving

Oracle, MS Access, MS Excel and Flat files.

. Experienced in Parallel Programming and effectively meeting stringent

timelines by working on multi-projects simultaneously.

. Using SAS Enterprise Miner 6.1 in developing the streams of predictive

modeling and segmentation.

. Base SAS Certified.

Work Experience

AstraZeneca, Wilmington, DE (Seroquel)

Title: Senior Associate

Feb'09-Current

. Perform test/control ROI analysis using PROC GLM to identify the

impact of speaker programs and created PowerPoint presentations to

present the results.

. Using IMS APLD (Patient Level Data), categorized the data to create

Source of Business metrics. Created algorithm to identify different

therapy patterns, and use clustering techniques to create segmentation

of prescribing patterns.

. Using SAS Enterprise Miner, created territory level reports to

identify under and over performing geographies using Regression Models

and Decision trees.

. Developed monthly report to track sample allocation, utilization and

new scripts.

. Collaborate with marketing and commercial insight teams to design

launch dashboards for a 2009 launch product with relevant brand and

competitive metrics.

. Update the dashboard every week; distribute to all the involved teams

and make sure that all the outstanding questions from the marketing

teams are answered in a timely manner.

. Analyze prescription and sample utilization data, and leverage

physician group practice data to make sure that customer's sample to

new prescription ratio is within the marketing teams' objective.

. Update customer scoring on a monthly basis using IMS Xponent data and

as well refreshed targeting reports.

ImpactRx, Mount Laurel, NJ

May'07 - Jan'09

Title: Analyst

. Generated monthly dashboards with descriptive statistics using SAS

Macros, data steps and statistical procedures for product sales and

promotional activities to study the performance of various brands in the

market.

. Prepared periodic Sales Force Effectiveness Metrics reports using

longitudinal panel data to study and track the selling efforts of

pharmaceutical sales forces, enabling continuous improvement of selling

organizations.

. Design and execution of Cohort Analysis with descriptive statistics to

study the differences in various customer groups across multiple time

periods, customer types, physician specialty, various demographic

indicators, sub-national geographies, behavioral segments etc to help

marketing initiatives and decision making process for a multitude of

pharmaceutical giants.

. Study of 'Written vs. Dispensed' prescription data to understand the

'loss' of prescriptions across time, demographic and geographic

segments.

. Extensive use of PROC SQL to extract data from Oracle database for

complex report creation and data analysis.

. Automate programs for monthly reports and generate project documentation

using SAS ODS.

. Processed and prepared master data sets in SAS Data format from multiple

different data sources including Oracle, and DB2, using Proc SQL, DATA

STEPS and Macro Programming in SAS to facilitate statistical data

analysis.

INC Research, NC Oct'06 - May'07

Title: Clinical SAS Analyst

. Performed SAS programming using SAS Base, SAS Macros, Data manipulation

and statistical procedures to generate TLG's (Table, Listings and

Graphs).

. Collaborated with Statisticians on Data Integration for efficacy and

safety tables.

. Involved in the process of generating Tables/Listings for Integrated

Summaries of Efficacy (ISE) and Safety (ISS) for FDA Submission.

. Performed Data Validation and Data Cleaning.

. Involved in generating various e-submission deliverables for the FDA.

. Process Flat Files and MS- Excel tables into SAS data sets.

. Experience working in both Windows and Unix environment.

. Perform verification of SAS-generated outputs (table, listings and

graphs) via independent programming

Computer Skills

SAS Tools: SAS 6/8/9, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH,

SAS/ACCESS, SAS/REPORT, SAS/SQL, SAS/CONNECT, SAS/ODS

Database: Oracle Clinical, Clin-Trial, and MS Access

Operating Systems: WINDOWS 98/NT/2000/XP, UNIX, MS DOS, Unix-SunOS

/SOLARIS

Languages: SQL, PL/SQL, HTML

Other Utilities: FTP Tool, WinZip, Microsoft Office (Excel, Word, Power

Point)

Professional Certifications

Base SAS Certified Programmer

Education

Bachelor of Technology, Computer Science

Aug'99-May'03

Jawaharlal Nehru Technology University, Hyderabad, India

Contact this candidate