Sales Manager

Rachit Agarwal

Mobile – +91-962*******

Email – **********@*****.***

OBJECTIVE:

Software professional with 4 years of IT experience with Cegedim Software India Pvt Ltd, seeking a challenging position in Software development in a result-oriented company that offers a stimulating work environment and dynamic career opportunities and allows for personal and professional growth.

PROFESSIONAL SYNOPSIS:

A sincere and competent IT professional with an enriching experience of 4 years in Software Development.

Proficiency in Informatica, Oracle, SQL/PLSQL, Basic Unix commands.

Proficiency at various levels of application development - Requirement Analysis, Design, Build, System Testing, Implementation and Documentation.

Excellent communication, interpersonal, team building skills and an ability to interact with people from all levels of business.

Initiative in meeting project deadlines without compromising on the quality of

deliverables.

Subject Matter Expert (SME) for Pharmaceutical domain.

Technical Skills:

ETL Tool : Informatica 8.6

Database : Oracle 9i, 10g, SQL Server 2003 and 2005

Languages : SQL, PL/SQL, C#, ASP.Net

Scripting : VB Script, Basic Unix commands

Data Modeling tool - Erwin

CARRER SUMMARY:

Cegedim Software India Pvt. Ltd.

Senior Developer, August 2008 onwards

Company Profile:

Today, with a presence in 80 countries and strong capabilities in all of target markets Cegedim is a global technology and services company specializing in the healthcare field. Cegedim supplies services, technological tools, specialized software, data flow management services and databases. Its offerings are targeted notably at healthcare industries, pharmaceutical companies, healthcare professionals and insurance companies. The world leader in pharmaceutical CRM, Cegedim is also one of the leading suppliers of strategic healthcare industry data.

Project Information

(In the order from current to past)

Title: - Mobile Intelligence 5.1

Client: - Glenmark

Duration: - Ongoing from Nov 2011.

Team Size: - 4 (Team member)

Technology Used: - Informatica 8.6, Oracle 10G, Dendrite Framework 1.5, UNIX and Windows XP.

Details: - Glenmark is a leading player in the discovery of new molecules both NCEs (new chemical entity) and NBEs (new biological entity) with five molecules in various stages of clinical development. Glenmark employs nearly 9500 people in over 80 countries. It has thirteen manufacturing facilities in four countries and has five R&D centres.

Cegedim Dendrite's enterprise CRM solution, Mobile Intelligence provides sales forces with a robust set of customer relationship management capabilities that promotes team selling, multi-channel customer management, information sharing, field reporting, and analytics all within a life science-tailored mobile application that is easy to use. As the first-ever Sales Force Management product fully designed to mirror the way life science reps think and act in the field, Mobile Intelligence enables its users to be more prepared, effective and efficient.

Responsibilities: -

Design and Development of Informatica Code (enhancements) as per requirement.

Preparing Unit Test Plan and test the developed code

Adherence to ETL standards and quality procedures

Fixing of issues found during System Testing and UA testing.

Documentation and handover of migration checklist, including codes to be migrated and the order of migration.

Documentation of Technical Specification for Releases.

Title: - Mobile Intelligence 5.1

Client: - LeoPharma

Duration: - Jan 2011 – Oct 2011

Team Size: - 6 (Team member)

Technology Used: - Informatica 8.6, Oracle 10G, Dendrite Framework 1.5, UNIX and Windows XP.

Details: - LEO Pharma is an independent, research-based pharmaceutical company. LEO Pharma develops, manufactures and markets pharmaceutical drugs to dermatologic and thrombotic patients in more than 100 countries globally. It was Founded in 1908, has business in 61 countries supported by around 5000 employees.

Cegedim Dendrite's enterprise CRM solution, Mobile Intelligence provides sales forces with a robust set of customer relationship management capabilities that promotes team selling, multi-channel customer management, information sharing, field reporting, and analytics all within a life science-tailored mobile application that is easy to use. As the first-ever Sales Force Management product fully designed to mirror the way life science reps think and act in the field, Mobile Intelligence enables its users to be more prepared, effective and efficient.

Responsibilities: -

To study the existing Data Model thoroughly and understand the relationships and Hierarchies involved.

To understand the functional logic of the system.

To prepare the Technical design and Low Level design document.

To handle the QCs, Change Request raised by users.

Develop/Modify Informatica Mappings, Worklets, Workflows using parameter files.

Client/Onsite/Offshore coordination.

Review of Unit test cases, Integration test cases of all the assigned modules.

System Integration Testing.

Develop/Modify Informatica Mappings, Worklets, Workflows using parameter files using various transformations.

Title: - Organization Manager 5.0

Client: - Sanofi Aventis

Duration: - Jan 2010 – Dec 2010

Team Size: - 5 (Team member)

Technology Used: - Informatica 8.6, Oracle 10G, Dendrite Framework 1.5, UNIX, Shell Script and Windows XP

Details: - Sanofi S.A. is a multinational pharmaceutical company headquartered in Paris, France, the world's fourth-largest by prescription sales. Sanofi engages in the research and development, manufacturing and marketing of pharmaceutical products for sale principally in the prescription market, but the firm also develops over-the-counter medication. The company covers 7 major therapeutic areas: cardiovascular, central nervous system, diabetes, internal medicine, oncology, thrombosis and vaccines.

“Organization Manager” an enterprise CRM Solution for Pharmaceutical Companies that Provides Home Office users at executive level to maintain & analyze the data for all core Entity-Employee, Drugs, Geography, Employee Alignment and hence provide Analytic information & Report to the organization.

Responsibilities: -

Develop/Modify Informatica Mappings.

Client/Onsite/Offshore coordination.

Developing of Test Cases.

Analyzed the source, targets, and transformed data, mapped the data and loading the data into targets using Informatica.

Created various transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter & Joiner etc.

Review of Unit test cases, Integration test cases of all the assigned modules.

Unit/System Testing.

Title: Webforce

Clients: UCB Pharma

Duration: From Nov 2008 till Dec 2009

Team Size: 4 (Team member)

Technology Used: Informatica, Oracle 9i.

A global bio-pharma focused on severe diseases in two therapeutic areas of Central nervous system and Immunology. UCB has a selective presence in primary care with global revenue of €3.6 billion in 2008. It has Operations in over 40 countries, supported by more than 10,000 staff. Established in 1928, successful

transformation from a hybrid specialty chemical company into a next generation bio-pharma leader.

WebForce provides the pharmaceutical industry with the tools needed to effectively manage all aspects of promotional activities. Mobilizing the sales force allows the field representative to quickly access important data related to your customer and provide valuable input to increase customer understanding. Enhancing overall productivity by adding components such as analysis, administration, and configuration tools, WebForce can further improve the effectiveness of promotional activities. All tools in the suite are fully integrated to complement each other.

Responsibilities:

Develop/Modify Informatica Mappings.

Developing of Test Cases.

Analyzed the source, targets, and transformed data, mapped the data and loading the data into targets using Informatica.

Created various transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter & Joiner etc.

Review of Unit test cases, Integration test cases of all the assigned modules.

Unit/System Testing.

Education:

C-DAC Course completed from VSS Bangalore affiliated to C-DAC Pune. Year of Completion – 2008.

Bachelor of Technology in Computer Science from Noida Institute of Engg. And Tech, Gr.Noida. Year of completion – 2007.

XII Std. (UP Board) from Vishnu Inter College, Bareilly - UP. Year of completion – 2001.

X Std. (UP Board) from Vishnu Inter College, Bareilly - UP. Year of completion – 1999.

ACHIEVEMENTS:

Received the best employer for the month award for March – 2009.

Received Best Team of the year award for 2008.

PERSONAL DETAILS:

Date of Birth: - 17-July–1984

Languages Known: - English, Hindi

Passport No.:- G3002780 (Valid till 08-Jul-2017)

Nationality: - Indian

Marital Status: - Single

Present Location: - Bangalore

Permanent Address: - #507, A4, Yamuna Block, NGV, 6th Block,

Koramangala, Bangalore-47

Contact this candidate