Sales Data

Objective:

Looking for analysis and programming opportunities that will use my experience with pharmaceutical sales and marketing data. Over ten years of programming experience with pharmaceutical sales and marketing data for call planning, targeting, segmenting, call & sampling analysis and prescriber performance. Experience working with pharmaceutical IMS NPA, Xponent, Plantrak & DDD and Wolters-Kluwer sales data for Trending, Segmentation, Promotional Response and Targeting. Experience working with pharmaceutical SFA systems like Dendrite and Veeva for Call activities and samples. Experience in running reports with SAS Enterprise Guide. Extensively worked on Base SAS v9, SAS ACCESS (ODBC, PC, SQL-Pass-through), SAS/Connect, SAS Macros and SAS procedures. Experience working with Clinical Trials drug discovery process. Familiar with CDISC SDTM and ADaM data submission standards.

Hardware:

HP-UNIX, Sun Solaris, Windows, IBM 3090 MVS/XA/ESA.

Software:

SAS, ORACLE, Unix Shell Scripting, TOAD, SAS Enterprise Guide, Business Objects, SQL SERVER, Awk, ERWIN, INFORMATICA, NT scripting, MKS Tool Kit, DB2, QMF, CICS, TSO/ISPF, VSAM, JCL, EZETRIEVE, SAS/ GRAPH, CLIST, DYL280, SYNCSORT, INTERTEST, LIBRARIAN, XPEDITER, COMPAREX, CSP, REXX, MS Excel, MS Word, MS Access.

Languages:

SAS, SQL, PL/SQL, Microsoft VBA, COBOL-II, PASCAL, JAVA (Training)

Certification:

SAS V9 Certified ( Base & Advanced ) Programmer.

Professional Experience:

09/2010 – 02/2012 Data Management Consultant, EISAI Pharmaceuticals, Wood Cliff Lake, New Jersey, USA

Accomplishments

Developed launch Dashboard and ad-hoc reports to support Business Analytics and Market Research departments.

* Supported the Data Management group’s multiple reporting requirements for various markets like Oncology & Alzheimer’s involving the use of secondary data from IMS (Xponent , Plantrak) using BASE/SAS, SAS/CONNECT, SAS Enterprise Guide, ORACLE TOAD & BI tool MicroStrategy.

* Developed Dashboard reports for oncology product HALAVEN, measuring product acceptance using SAS DDE, PROC REPORT, PROC SQL, DATA _NULL_, FREQ, MEANS, SORT, MERGE, SUMMARY, TRANSPOSE.

09/2009 – 09/2010 Senior Analyst, PDI Inc, Parsippany, New Jersey, USA

Accomplishments

Developed weekly and monthly ad-hoc and standard reports for the Executive Committee of the company for actionable insights.

* Responsible for weekly and monthly sales report generation for Executive Committee of the company for monitoring sales performance from IMS NPA data.

* Managed Informatics group’s analysis/reporting/extraction activities for various PDI client products for contractual obligations and call plan adherence using activity data using FTP, SFTP and SAS/BASE.

* Managed Informatics group’s analysis/reporting/extraction activities for various PDI client products for contractual obligations and call plan adherence using activity data using FTP, SFTP and SAS/BASE.

* Developed analytics datasets (Sales & Activity) used for targeting and promotional response.

* Developed the Retail and Payer sales data for aiding field sales force for efficient prescriber targeting, detailing and sampling using SAS Hash Object lookups.

* Generated client reports in Excel using SAS DDE and Excel.

* Cross-functionally worked with IT, Sales Ops and Marketing to support key stakeholders with crafting and analyzing their reporting needs and data structure for implementing the data Mart.

* Researched and reported physician-level data to build insights for external clients and internal partners.

02/2007 – 09/2008 Consultant, Roche Pharmaceuticals, Nutley, New Jersey, USA

Accomplishments

Developed analysis reports and ad-hoc reports for Sales & Marketing departments using IMS Xponent and in house calls & samples data using SAS on PC and SQL SERVER.

* Supported Marketing Science group’s analysis/reporting activities for various therapeutic disciplines like Flu & BoneHealth markets involving the use of secondary data from IMS (Xponent , Plantrak) and calls & samples data from Sales Force automation system using SAS tools BASE/SAS, SAS/CONNECT & Business Objects.

* Generated Web analysis reports using Web trends & Epiphany for the online Web data of the Online Web community visiting Roche sponsored web sites.

* Generated the performance data for deriving the scoring of FLU market product TAMIFLU through Segmentation.

* Developed the Churn Analysis report for Roche’s product PEGASYS, comparing all products in the Alfa-Interferon market.

* Developed promotional response analysis for Bone Health market product BONIVA.

10/2005 – 12/2006 Consultant, Sanofi-Aventis Pharmaceuticals, Bridgewater, New Jersey, USA

Accomplishments:

Developed ad hoc reports for Sales & Marketing departments using IMS (Xponent, Plantrak) and Dendrite Sales Force Automation system, QUEST (Calls & Samples) using SAS on HP-UNIX & PC.

* Supported Advanced Analytics group’s analysis/reporting activities for various therapeutic disciplines like Sedative & Select Insulin markets involving the use of secondary data from IMS (Xponent, Plantrak,) and Calls & Samples data from Sales Force Automation system, QUEST (Dendrite) using SAS tools BASE/SAS & SAS/CONNECT & VBA.

* Provided data extraction and reporting to outside vendors with data from SAS analytics data warehouse SPARK using SAS tools BASE/SAS & SAS/CONNECT.

08/2004 – 10/2005 Consultant, Bracco Diagnostic, Princeton, New Jersey, USA

Accomplishments:

Developed ad hoc reports for Sales department and maintained the Sales & Marketing database with Customer Invoice & IMS data. Developed clinical trials reports for phase I.

* Developed ad hoc programs for GPO sales of IMS sales data for market share calculation and targeting using Business Objects and SAS on UNIX & Windows utilizing ORACLE database and Excel VBA.

* Operated and maintained a very large relational database application that supports company’s financial system utilizing SAS, ORACLE and UNIX shell scripts. Implemented new processes for easy management of data. .

* Experience in preparing Tables, Listings and Graphs using Base SAS, SAS/Graph, Macros and SAS/ODS according to

Statistical Analysis Plan (SAP).

* Good working knowledge of clinical trials data like demographic data, adverse events (AE), serious adverse events

(SAE), laboratory data (lab data), and vital signs.

* Proficient in extracting data from Oracle database into SAS data files using SQL Pass-through facility and uploading

SAS data files into Oracle tables.

* Experience in using SAS statistical procedures like FREQ, UNIVARIATE, MEANS, CORR, SUMMARY, REG,

ANOVA & reporting procedures like REPORT, PRINT and TABULATE.

07/1998 – 06/2004 Consultant, Bristol-Myers Squibb Pharmaceuticals, New Jersey, USA

Accomplishments:

Participated in the development of ad hoc reporting and standard reporting requests for Sales & Marketing Department.

Developed application software for a new Samples Management and Sales Force Alignment systems of Sales & Marketing Department.

* Developed and maintained adhoc programs for Call analysis and product market share of Xponent pharmaceutical data of Prescriber’s and DDD’s for marketing department using SAS (v9.12 with ODS & ACCESS) on Unix and Windows NT utilizing ORACLE databases and Excel VBA.

* Developed programs for data extraction and interface feeds for the new Samples Management and

Sales Force Alignment systems using ERWIN, INFORMATICA, SAS, DB2 CONNECT and PL/SQL (ORACLE) on IBM MVS and HP-UNIX systems.

* Developed a system to web-enable the mainframe legacy application reports on HP-UNIX using SAS and free UNIX software ghostscript (Enscript & ps2pdf). Developed a system to report the indirect sales at the outlet level using ODBC, Microsoft VBA and SAS software.

* Developed adhoc programs for product acceptance and market share variations for marketing department using SAS on IBM Mainframe, UNIX and Windows NT platforms. The technology/software used is Microsoft Access, Excel, VBA and Syncsort.

Education:

BSEE with Honors in Electrical Engineering/Computing, Calicut University, India.

Contact this candidate