Project Sales

Sameer Yalgi

*** ******** *** ***** : ************@*******.***

Edison, NJ - 08820 Phone : 732-***-****

Brief Overview

. Over 13 years of experience in the Consulting industry with more than 10

years in the Pharmaceutical Industry.

. Experienced with all aspects of SDLC - scope, requirement gathering,

design, analysis, application development, testing and defect resolution.

. Proven track record to implement large scale projects.

. Strong domain knowledge of the Pharmaceutical Sales & Marketing area.

. Extensive knowledge of IMS data (XPonent, Plantrak, DDD, NPA, APLD

(Patient Level Data)) & SFA system data sources like details & Samples

information.

. Experience in various Pharmaceutical industry marketing initiatives such

as promotion response, test Vs control analysis, sample allocation,

incentive compensation etc.

. Have extensive experience of managing the projects with onsite-offshore

model.

. Demonstrated expertise in leading teams for accomplishing organizational

goals within given parameters.

. Expertise in using various SAS tools for data analysis & reporting.

Certification

< Certified Project Management Professional (PMP)

< Microsoft Certified Solution Developer (MCSD)

Managerial Skills

Project Management

< Spearheading project effort & cost estimation, scheduling, tracking and

reporting.

< Planning project and managing smooth transition of projects.

< Maintaining project artifacts from Inception to Transition and

Maintenance.

< Supervising adherence to quality processes over complete SDLC.

< Managing and providing technical and functional guidance/support to the

project team.

< Coordinating on multi-locational projects with multiple involved parties.

< Adhering to agreed Service Levels.

Technical Skills

Hardware IBM PC, IBM M/F

Language COBOL, SAS,

Tools BASE SAS, SAS/CONNECT, SAS/AF, SAS/STAT, Enterprise Miner, MS

Office, Business Objects

RDBMS Oracle, SQL Server 7.0, DB2

Career Sketch

Cognizant Tech Solutions Mar'08 - Present

On assignment to: AstraZeneca Pharmaceuticals Project: Quantitative

Commercial Analytics

< Manage team of onsite/offshore analysts (Team size 10 Analysts)

supporting various analytical projects undertaken by QCI (Quantitative

Commercial Insight) group of AstraZeneca.

< Actively involved in projects like market share analysis, measuring

promotion response, estimating effectiveness of sales force restructuring

& sample allocations.

< Help brand team to allocate their promotion spend across different

channels such as TV, Radio, Print media & online ads.

< Provide support to physician segmentation process.

< Analyze patient level data to gather insights into different metrics such

patient adherence, new patient starting on therapy & patient switch

pattern.

< Maintain QCI data mart & insure data availability & quality. Interact

with other Astrazeneca groups & vendors to procure the data required for

analytical projects.

< Provide innovative ideas to the QCI group & establish processes to

facilitate successful & timely execution of all the QCI projects.

< Overall responsibility meeting the service level agreements & project

delivery.

Capgemini Sep '07 - Feb '08

On assignment to: Jansen Pharmaceuticals Project: Sample Management

Portal

< Manage project to enhance the Jansen Pharmaceutical's sample management

portal.

< Interact with sample allocation team/district sales managers & regional

managers to understand the current sample allocation process & the

issues/limitations of the process.

< Gather all the specifications & translate them to the technical team for

actual development.

< The project involved implementing various new features to avoid sample

wastage, feedback gathering so that sample allocation team can factor in

the field feedback into their sample allocation process.

< Overall responsibility meeting the project deadline, stakeholder

management & project delivery.

Cognizant Tech Solutions Jul '06 - Aug '07

On assignment to: Novartis Pharmaceuticals Project: NGPS Data

Integration & ADM Factory

< Manage projects to integrate IMS NGPS & Medco Mail Order data into data

warehouse.

< Define methodology to establish sales targets for the field force &

unable the commercial DW to facilitate the goal setting activity.

< Understanding the current data warehouse design & suggest optimal way to

integrate NGPS data into the warehouse.

< Manage the expectations of various stakeholders such as brand teams,

Novartis IT & onsite/offshore project team.

< Enhance the existing processes to overcome data quality issues &

availability issues. Achieved significant performance improvement by

bringing down the processing time for plantrak data from 60 hours to 15

hours.

< Established ADM (Application development & maintenance) framework for

execution of projects by cognizant for Novartis. This model created a

dedicated pool of onsite/offshore resources for Novartis to leverage.

< Define & implement Service Level Agreements for the ADM factory & manage

the execution of the project as per the defined SLA.

HighPoint Solutions Feb '05 - Jun '06

On assignment to: Sanofi-Aventis Pharma Project: Business

Analytics & Operations

< Execute various data analysis/reporting initiatives for Sanofi's Business

Analytics & Operations group.

< Support marketing initiatives of CV & Thrombosis therapeutic areas.

< Work closely with various business functions such as Incentive

compensation, call planning & targeting to provide them necessary inputs

about the brand strategy.

< Work with joint venture partner to procure the data & report to higher

management about overall progress of the joint venture.

< Help to design the sample allocation policy to the brands CV & Thrombosis

therapeutic areas.

< Monthly & Weekly dashboards to monitor performance of the brands in the

market. The reports provide comprehensive information about the brand

using data components such as Xponent, DDD, NPA & details/samples.

Alpha Consulting Corporation Mar '03 - Feb '05

On assignment to: Bristol-Myers Squibb Pharmaceuticals Project: IKM Ad-

Hoc Reporting

< Work with Brand teams to provide them information to facilitate execution

of the brand strategy.

< As part of IKM (Information Knowledge Management) group responsible for

generating various dashboards & ad-hoc reports as per the requirement.

< Work closely with Managed Markets team & provide them the impact analysis

of the managed market changes on various BMS brands.

< Act as a liaison between BMS & joint venture partner to facilitate data

exchange & joint venture reporting.

< Provide support to product launch with pre launch market analysis &

develop tracking reports to monitor progress of the brand after the

launch.

Mastech/Mascot Systems Jan '99 - Feb '03

On assignment to: Pharmacia Project: Decision Science & SMIS

< Develop & maintain SAS datamart to fulfill data needs of the Decision

Science group of Pharmacia.

< Measure Promotion effectiveness by tracking behavior of prescribers

attending various product promotion/educational events arranged by

Pharmacia.

< Work with various data providers & vendors to procure the data & execute

the analytical projects.

< Identify & integrate new data sources in the Data Mart.

< Reformat & Integrate data from the external source after the acquisition

of Searle Pharmaceuticals.

< Generate reports to monitor the sales rep movement in the field & the

alignment changes.

< Generate monthly product dashboards & tracker reports.

Mastech/Mascot Systems Aug '98 - Dec '98

On assignment to: R L Polk Project: Consumer Loyalty System

< Develop various reports for clients such as Ford Motor Co., General

Motors & Toyota to give them snapshot of their market share within

various vehicle segments.

< Formalize the loyalty rules & generate brand loyalty reports to help

identify the most loyal customers.

< Manage & validate the vehicle registration data received from the state

motor vehicle agencies, which was utilized for all the reporting &

analytics.

Mastech/Mascot Systems Dec '97 - Jul '98

On assignment to: Case Corp Project: Business Entity System

< Analyze & design data load module for Business Entity System to

synchronize data between Sybase database & MainFrame.

< Testing & implementing the module into production & the initial support.

Datamatics Limited - Mumbai (India) Feb '97 - Dec '97

On assignment to: General Motors Project: IMDS

< Support the production planning group of General Motors by generating

various parts availability & vehicle demand reports.

< Manage the offshore team & offshore delivery of the project.

< Work closely with onsite team to gather the requirements & deliver the

project as per the specifications.

< Generate the monthly & weekly status reports to indicate status of

offshore team delivery.

Trilogy Software - Mumbai (India) Nov '95 - Jan '97

On assignment to: Citibank Project: Nostro Account System

< Design, develop & implement Nostro Account Reconciliation system for the

Citibank Mumbai's treasury department.

< Monitor the foreign currency transaction executed every day & generate

the exception reports.

< Support treasury department information needs by generating ad-hoc

reports.

Academic:

< Bachelor Of Science (University Of Mumbai)

< Post BSc Diploma in Computer Science (University Of Mumbai)

Contact this candidate