Asha Gopal

Sr. Consultant - CRM

817-***-****

Technical Expertise

• 5.5 years of extensive experience in leading and executing projects in Life Sciences and BFS domain covering all stages of Software Development Life Cycle including analysis, design, development, testing, implementation.

• Expertise in Sales and Marketing implementation and Complaint Handling process for Pharma and Medical Devices companies.

• Knowledge in Business Process Definitions in the areas of eMedical /eClinical/Marketing modules of CRM.

• Experience in Siebel Configuration including Scripting, Workflows, EAI to customize Siebel application based on Business requirements.

• Experience in Data loads in Siebel EIM using ETL Tools like Informatica and DTS

• Exposure to sales cloud of SFDC in the areas of Application administration, security and access

• SFDC application development using Force.com Apex code at a practitioner level.

• Migration of Siebel Application to PEGA as a Siebel Technical Consultant

• System Specification Requirement Analysis and proposal of calibrated solutions.

Potential Roles and Responsibilities

• Onsite Lead/Co-Ordinator

• Siebel Developer

• SFDC Application Administrator

• Data Migration Specialist

• Architect/Data Analyst

• Technical Lead

• SFDC application developer

TECHNICAL SKILLS

Area Skills

Siebel Modules Siebel sales 7.7, 7.8 , Siebel Marketing, Siebel eMedical 7.8,8.1.1.1, Siebel eClinical 8.0

CRM Skills Siebel:- Configuration, EIM, Scripting (eScript), Workflows, EAI, Actuate reports, Informatica, DTS, SSIS

SFDC: - Administration and Application development

Operating Systems Windows 2000, Windows XP

Programming Languages Siebel e-Script, Apex code

Databases & Tools SQL Server 2005 , Oracle

PROJECT EXPERIENCE

Client 1 : Medco

Client Medco

Duration From January 2011 – March 2011

Location Franklin Lakes, NJ

Primary Role Technical Consultant

Environment 7.5

Client Description:

Medco is a leading pharmacy benefit manager (PBM), with the nation's largest mail order pharmacy operations. Through advanced pharmacy, Medco improves the health and lowers the total cost of care for clients and their members.

Project Description

Project Name: CRM2.0 Replatform

Description: The objective of the CRM 2.0 Replatform project is to sunset a Siebel Sales platform used by Medco and rebuild the same using Pega Rules Process Commander(PRPC) BPM suite, to leverage on the Business Process Management features offered by PRPC. The existing application acts a CRM suite which is used for Service Request Processing and Account (Client) information maintenance. The Sales application interacts with the backend systems for retrieving/updating the Benefits Plans for the Clients through Service Calls. The exercise is carried out as a combined deep dive by PRPC and Siebel architects on the Siebel Sales Application features to come up with a technical approach for redesign and data migration.

The design objective includes remolding the Service Request and Account data structures and related entities into a data model compatible with PRPC .It also includes identification of design constructs in PRPC to substitute Siebel features like Outlook Integration ,User preferences setting, Predefined Quires(PDQ) etc. The data migration analysis consists of an analysis of relevant Siebel tables and the attachment storage and attachment handling.

Roles and Responsibilities:

- As a technical consultant, provide an assessment for Siebel Replatform by capturing various Data Model choices, complexity and alternatives to Data Migration, options for go-live - big bang vs phases

- Provide gap analysis of Siebel Out of the box functionalities between Siebel and PRPC

- Participate in architectural decisions for the choice of PRPC framework

- Evaluation of SFDC as an alternate CRM solution for Medco business

o Evaluate Service Cloud for call center application

o Configuration of workflows for handling escalations

o Dashboards for call center analytics

Client 2 : Animas Corporation

Client Animas Corporation

Duration From April 2010 – January 2011

Location West Chester, PA

Primary Role Onsite Lead for Data Migration

Environment 7.7

Client Description:

Animas Corporation is an American company that specializes in making insulin pumps, used by people with diabetes. The company was acquired by Johnson & Johnson on February 18, 2006. It is headquartered in West Chester, Pennsylvania and forms part of the Johnson & Johnson Diabetes Franchise along with Lifescan and several other companies serving the needs of people with diabetes.

Project Description

Project Name: eSynchronicity

Description: The objective of this project is to establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level. Project eSynchronicity is made up of a cross functional team from LifeScan, Animas, and SymCare looking to establish this objective. Animas Corporation currently has an in-house application developed and maintained for their customer support, Order handling and processing (with JDE) and marketing operations. An external vendor application (SmartSolve) is used for Product Analysis and vigilance reporting. A Siebel eMedical implementation has been proposed as a solution to meet business objectives.

Following the implementation, SmartSolve application will retire and real time integration shall be integrated between the Siebel system and in-house application.

Roles and Responsibilities:

- Data Analyst and Architect- Responsible to analyze high level data to assist in business as well as technical discussions and help in creation of documentation throughout the computerized system life cycle.

- Architect- Responsible to define data migration strategy, Migration approach and deployment activities for data migration.

- Designer – Responsible for completing the design documentation of data mapping activities.

- Technical Lead – Responsible to lead the technical design team (across applications) for design of Siebel implementation as defined in compliance plan. Owner and Responsible for Data Migration. Consulted and Informed for Configuration and Integration requirements.

- Developer – Responsible and owner to design and develop ETL and EIM jobs for data migration

- Onsite Co-Ordinator – Responsible for on-site offshore communication, knowledge sharing, interaction and discussions with business.

Client 3 : Alcon Laboratories Inc

Client Alcon Laboratories, Fort Worth, Texas

Duration From October 2008 – April 2010

Location Onsite :Texas Offshore : Bangalore, India

Primary Role Lead Developer for Siebel Configuration,

Project Lead for Data Migration

Environment Siebel 6.0, Siebel 7.8.x, Siebel 8.1.1.1, Siebel 8.0

Client Description:

Alcon Laboratories, Inc. is one of the biggest Eye Care Pharmacy Companies in the Globe Founded in 1945. Alcon Laboratories, Inc. traces its roots back to two pharmacists, Robert Alexander and William Conner, who opened a small pharmacy in Fort Worth, Texas. The majority owned by Nestle S.A. and incorporated in Hunenberg, Switzerland with U.S. operations based in Fort Worth, Texas. A team of nearly 15,000 dedicated employees worldwide develops, manufactures, and distributes hundreds of eye care products in more than 180 countries. It is recognized by Fortune as one of the 100 Best Companies to work for in the U.S. for the past eleven years. Alcon’s core business is centered on three key divisions Surgical, Pharmaceutical and Consumer Vision Care. As of 2008, sales reached US$6.3 billion. Alcon conducts business from Alcon offices located in seventy-five countries around the world in regions including Canada and the Far East; Europe, Middle East and Africa; Latin America and the Caribbean; and the United States.

Project Description

Project Name: Siebel Implementation (SALSA 3.0)

Description: Alcon Laboratories has a CRM (eMedical) application implementation to manage their Sales and Marketing, Technical Services, Customer Services Activities in their American and European Data Centers. Siebel is integrated with external applications like JDEdwards, CTI. The purpose of this project is to migrate data from the older implementation (SALSA2.5 implemented in Siebel 6.0) to SALSA 3.0 implemented in Siebel 7.8.x, maintenance and support of existing application while implementing minor enhancements/change requests.

Responsibilities:

• Responsible for SALSA data migration for 10 countries by interacting with respective country managers to gather country specific requirements, development, system testing and deployment

• Onsite Lead and co ordinator for Data Migration for SALSA 3.0. with an offshore team of 4 members. Lead the team to successfully convert data from Siebel 6.0 to Siebel 7.8 for 10 countries.

• Load/Resource planning for Data migration

• Develop kits to validate incoming data

• Production Support for Data issues

• Define Processes for data Migration task

• Prepare and review technical design documents

• Prepare, Review and Execute Test Scripts

• Work on Proof of concepts to achieve the sales business functionalities and Processes using SFDC

a. Organization hierarchy set up

b. Employee role setup

c. Visibility restrictions based on role

d. Dashboards and analytics

e. UI customizations – addition of new fields, field mapping UI layout editing

f. Set up of call activities

Project Name: Siebel Upgrade Project (SALSA3.0, SALSA 4.0)

Description: The purpose of this project is to Upgrade Siebel users from Siebel 6.0 to the standard global model of Siebel 8.1.1.1 (SALSA 4.0), and then extend functionality of SALSA 4.0 to provide additional SALSA features for mature markets like US.

Responsibilities:

• Lead Developer for Configuration for change requests

• Fix/Address Siebel upgrade issues

• Understand the Business processes involved and propose solutions to Business for SALSA 4.0

• Create Proof of Concepts for feasibility study of business requirements

• Prepare and review technical design documents

• Siebel Configuration including scripting and workflows

• Maintenance and work on Production Change Requests for SALSA 3.0.

• Manage offshore-onsite communication.

• Code Migrations to QA for system testing and User Acceptance Testing

Project Name: CTMS

Description: This project targets the Alcon’s Research and Development programs. The goal of Clinical Trial Management System implementation in Siebel is to provide an integrated set of tools for tracking and provide a single source for timely and accurate information regarding Alcon's clinical trials.

Responsibilities:

• Developer

• Understand the Business processes involved and propose solutions to Business

• Develop Stored Procedures for Crystal Reports used in the system for Analytics

• Performance tuning of Stored Procedures

• Integration of Siebel application with external system

• Create Proof of Concepts for feasibility study of business requirements

• Prepare and review technical design documents

• Siebel Configuration including scripting and workflows

• Code Migrations to QA for system testing and User Acceptance Testing

Client 4 : Sallie Mae

Client Sallie Mae, Indiana

Duration From November 2005 to September 2008

Location Onsite :Indiana Offshore : Bangalore, India

Primary Role Project Lead

Environment Siebel 7.7

Description:

Sallie Mae is the leading provider of education funding and has helped millions of Americans achieve their dream of a higher education. The goal of this project is to build an Enterprise Customer Repository (ECR) of school information including corresponding lender and guarantor relationships to be used across Sallie Mae and USA Funds (the corporations).

The client intends to build an Enterprise Customer Database (ECDB) of information to provide a strategic advantage to Sallie Mae’s student/school loan servicing and other related activities. The Siebel application needs to be integrated with this enterprise wide database along with several other applications to get the business edge. The client wanted us to do the Siebel implementation and its integration with ECDB.

Responsibilities:

• Lead a team of three at Offshore

• Siebel Configuration including scripting and workflows

• Maintain existing Integration with external system

• Siebel Integration with external web application using Web Services

• Data transformation and loading to EIM using Informatica

• Debugging and resolving issues related to EIM loads

• Understand the Business processes involved and propose solutions to Business

• Create Proof of Concepts for feasibility study of business requirements

• Prepare and review technical design documents

• Prepare reports using Actuate

• Maintenance and work on Production Change Requests

• Design the Test Cases, write Test Scripts and perform testing

• Manage offshore-onsite communication and suggest configuration techniques

• Production support for Oracle Sales, e-Mail marketing, and ECDB applications

• Code Migrations to QA for system testing and User Acceptance Testing

Major Functionalities Implemented:

Siebel Forecasting:

Forecasting was done using excel sheet. The business wanted to forecast based on opportunities. The challenge was to fit in the existing business process into Siebel Forecasting Module. This involved customizations to the Opportunity, Revenue and Forecasting entities. I was also involved in building an Informatica job that creates Opportunities based on Business Rules.

Siebel Multi-Org Functionalities:

Since the Sales Application is used by organizations other than SallieMae, Visibility security based on Organizations was implemented. Apart from the OOB functionality, I was extensively involved in building Siebel Workflows to implement business requirements.

Customizations for e-marketing Application:

Organizations wanted to automate the process of Marketing for new Products, Product related information, upcoming events etc. Siebel e-marketing application was rolled out for this Purpose. Siebel Sales, Siebel Analytics and Siebel e-marketing Application have been closely integrated for this purpose. I was involved in configurations for integrating Siebel Sales Application with Siebel marketing Application. As a part of this exercise, I have a good knowledge on the e-marketing Module of Siebel. I was also involved in customizations for the marketing Application.

Educational Background

Bachelor of Engineering from National Institute of Technology Karnataka, Surathkal. Year of passing May 2005.

Contact this candidate