Candidates About

PROFESSIONAL SUMMARY

Ø  11+ years of IT experience with SFDC & BI projects (involving Force.com, Veeva CRM, Sales Cloud, Service Cloud, ETL, Data warehousing, Reporting, Data Modeling) of different scales and complexities

Ø  Conversant with Healthcare and Manufacturing domain. Have played IT solution architect role implementing Force.com solutions

Ø  6+ years of experience as Solution/ Technical architect role. Have designed and implemented many systems from the scratch (from Requirement analysis à Solution Design à Development à Implementation). Excellent experience with end to end architecture of SFDC applications – starting from application development to its integration with other on-premise/on-cloud applications to reporting/data warehousing

Ø  Ample experience in working on various tools/technologies in CRM and BI domain. These include -  Veeva CRM (Salesforce), Force.com (Sales and Service Cloud), Veeva Vault,  Informatica Cloud, Informatica Power center, Netezza, Oracle PL/SQL, SQL Server, Roambi, SSRS, Cognos, Business Objects, Oracle Apex and UNIX/LINUX

Ø  Have been working directly with business users and partners – gathering business requirements, solution architecture and designing, participating in user experience workshops, proposing IT solutions to eliminate pain areas and do better data analytics, performing tools/technology evaluation, performing Impact Analyses, discussing industry trends & upcoming technologies, coordinating with different vendors and teams for various project activities, assisting with user trainings etc.

Ø  7+ years of experience as a Tech Lead. Have led teams of varying sizes for various projects

Ø  Close to 5 years of development experience on Force.com – Have developed a couple of applications from the scratch - (Meeting Management, Sales Cloud), (Call Center app, Service Cloud), (Customer Surveys, Service Cloud)

Ø  Close to 4 years of experience with customizing and configuring SFDC applications for various user requirements (Custom Objects, Custom Tabs, User Profiles, User Roles, Pick lists, Page layouts, Permission Sets, Field Level Security, Sharing Rules, Reports & Dashboards, Home Page Layout, Workflows & Approval processes,  Process Builder, Custom Links, Custom Settings etc.)

Ø  Have worked on mission control projects in Agile methodology. Have closely worked with business SMEs to articulate user stories and developed solutions.

Ø  Very good experience with configuring applications on Service Cloud – Setting up support processes, Solutions and Knowledge management, email to case and web to case functionalities

Ø  Well versed with platform capabilities and onboarding managed application from AppExchange like Drawloop, Five9 SMS integration to service cloud application

Ø  Have carried out global implementation various modules of Veeva CRM like Approved Email, CLM and Veeva Suggestions.

Ø  Have implemented SSO (Single Sign On) in Salesforce for end users

Ø  Ample experience with Sandbox management and code migration between various SFDC environments using change sets and Force.com IDE. Have worked a lot with data loader and Import wizard for data migration

Ø  Good experience with Salesforce Chatter

Ø  Excellent experience with integrating different SFDC applications using S2S (salesforce to salesforce) and Outbound messages. Have also integrated Salesforce with .Net application using REST API

Ø  Got ample experience with writing Apex Classes & methods, efficient SOQL queries, Triggers, Test Classes, Custom Controllers, Extensions, Batch Apex and Visual force pages. Well familiar with Apex best practices, governor limits and other platform constraints.

Ø  Have created several reports and dashboards in Salesforce for different categories of users

Ø  Close to 4 years of rich experience in administering, customizing & configuring Veeva CRM (Sales Cloud) - Have designed and configured custom screens, custom logic, custom objects, custom tabs, user profiles, user roles, pick lists, page layouts, permission sets, FLS, sharing rules, reports & dashboards, home page, workflows & approval processes,  process scheduler, custom links, custom settings, Veeva messages, configured VMOC etc. Also integrated with multiple other applications (on cloud and on premise)

Ø  Close to 5 years of experience in managing Salesforce and Veeva CRM quarterly releases and testing of new functionalities and bug fixes

Ø  Close to 5 years of experience in working on Cloud based data integration (Informatica Cloud and Salesforce). Have integrated Veeva CRM many on cloud and on premise applications (batch and real time both) using Informatica Cloud

Ø  Excellent experience in designing and setting up complex data integration between MDM systems (Customer, Material, Alignment, Activity ODS), data warehouses, reporting and CRM systems, performing data/dimensional modelling

Ø  Close to 7 years of experience with designing end to end data flows, ETL architecture, testing strategy, business rules & transformations, data modelling of ODS & data marts

Ø  Close to 10 years of experience with working on relation databases (Oracle, SQL Server). Excellent experience with data modeling, writing complex SQLs, triggers, procedures and functions

Ø  More than 3 years of reporting experience on SSRS, Oracle Apex and Roambi Analytics

Ø  Have set up many BI solutions from the scratch (from Requirement analysis à Dimensional Modeling à ETL designing/development à Reporting layer implementation). Got very good experience in implementation of Global BI/CRM solutions (with a balanced blend of standardization and localization)

Ø  Close to 7 years of data integration experience (batch and real time) using Informatica with various kinds of data sources across heterogeneous systems residing on premise and on cloud both

Ø  Well acquainted with data warehousing standards and best practices

Ø  Got excellent of data warehousing and ETL concepts and principles – Facts, Dimensions, schemas, Data Cleansing, Slicing/Dicing etc.

 

TECHNOLOGY STACK

CRM                                                       :               Force.com, Veeva CRM, Sales Cloud, Service Cloud, Veeva Vault

ETL                                                         :               Informatica Power Center, Informatica Cloud, Oracle PL/SQL

Business Intelligence                       :               Business Objects, SSRS, Roambi, Salesforce Analytics (Wave)

Database                                             :               Netezza, Oracle, SQL Server

Operating Systems                           :               Windows, Linux/Unix

 

EDUCATIONAL QUALIFICATIONS

Ø  Bachelors of Technology in Computer Science from Indraprastha University, Delhi, India in 2005

 

PROFESSIONAL CERTIFICATIONS

 

 

PROFESSIONAL EXPERIENCE

Genesys                                                                                                                                                                   May 2017 – Sept 2017

Sr. Salesforce Developer                    

 

CRM: Enhancement and Integration of current CRM solution. This includes configuration and customization of Contracting (CPQ) in Sales cloud and migration of data result of merger of Interactive Intelligence with Genesys.

 

Responsibilities

·         Development & Migration of contracts from INN salesforce system to Genesys

·         Worked in Agile team structure as solution architect and Sr. developer

·         Migration of data from ININ contracting system to Genesys

·         Configuration & Customization of Salesforce for various business requirements (Custom Objects, Custom Tabs, Customer screens, User Profiles, Field Level Security, User Roles, Pick lists, Page layouts, Record Types, Permission Sets, Sharing Rules, Custom Links and Settings etc.)

·         Integrating Google Analytics with the customer community portals

·         Developing custom functionalities (for different business requirements) using Apex Classes, Methods, Triggers, Visual Force pages and other Force.com platform components

·         Design and Development of APEX components for cloud billing contracts. Implemented functionality for Product Tier Sets / Contract tier set  / Recurring charges / Usage data Roll up / Invoicing

·         Performing proof of concepts for different requirements

·         Resolution of day to day operational issues of end users in different CRM applications (data, access, approval processes, functionality related issues)

·         Implemented new functionalities/features of Veeva CRM for different user groups

·         Project planning and coordination

 

Environment: Salesforce.com, SFDC, APEX, Batch jobs and Triggers, APEX data loader, Workbench

 

 

Regeneron Pharmaceuticals                                                                                                                             Jun 2017 – Till Date

Salesforce/Veeva/ Integration Architect                    

 

CRM: Implementation, Enhancement of Veeva implementation for new product launches. This includes configuration and customization of Veeva and development of new interfaces.

 

Responsibilities

·         Part of core solution team of the client – gathering business requirements, participating in user experience workshops, planning SFDC application enhancements, solution designing and execution planning, designing data integration, discussing industry trends & upcoming technologies, advising IT solutions to eliminate pain areas and do better data analytics, performing tools/technology evaluation,

·         Development, Design and Testing of Veeva CRM modules and integration with other vendor applications like Beghou, Dohemn & Knipper

·         Implementation of various support processes (Cases, Console, email-to-case, web-to-case, warm call transfer, live agent etc.)

·         Configuration & Customization of Veeva for various business requirements (Custom Objects, Custom Tabs, Customer screens, User Profiles, Field Level Security, User Roles, Pick lists, Page layouts, Record Types, Permission Sets, Sharing Rules, Custom Links and Settings etc.)

·         Developing custom functionalities (for different business requirements) using Apex Classes, Methods, Triggers, Visual Force pages and other Force.com platform components

·         Design and Development of data interfaces between SFDC applications and other on premise/on cloud applications (batch and real time both). Designing ETL maps in Informatica Cloud for data transfer between Salesforce and other applications

·         Developing Reports and Dashboards in Veeva CRM for different categories of users

·         Performing proof of concepts for different requirements

·         Resolution of day to day operational issues of end users in different CRM applications (data, access, approval processes, functionality related issues)

·         Implemented new functionalities/features of Veeva CRM for different user groups

·         Project planning and coordination

 

Environment: Veeva CRM, Veeva Vault, Force.com, APEX, Visual Force, Salesforce, Veeva Vault, Informatica Cloud

 

 

 

Quintiles                                                                                                                                                                  Mar 2017 – Apr 2017

Salesforce/Veeva/ Integration Architect                    

 

CRM: Implementation of Integration between Veeva CRM for Abbvie HCV quintiles and Epsilon

 

Responsibilities

·         Part of core solutioning team of the client – gathering business requirements, participating in user experience workshops, planning SFDC application enhancements, solution designing and execution planning, designing data integration, discussing industry trends & upcoming technologies, advising IT solutions to eliminate pain areas and do better data analytics, performing tools/technology evaluation,

·         Development of Informatica Integration between Epsilon and Veeva CRM

·         Developing & design solution (for different business requirements) using Apex Classes, Methods, workflows

·         Design and Development of data interfaces between SFDC applications and other on premise/on cloud applications (batch and real time both). Designing ETL maps in Informatica on premise for data transfer between Salesforce and other applications

·         Resolution of day to day operational issues of end users in different CRM applications (data, access, approval processes, functionality related issues)

·         Project planning and coordination

Environment: Veeva CRM, Veeva Vault, Force.com, APEX, Visual Force, Salesforce, Veeva Vault, Informatica On Premise, Oracle

 

Eli Lilly and Company, Indianapolis, IN                                                                                                                          Jul 2011 – Feb 2017

(Delhi India and Basingstoke, UK)

Salesforce/EMC/Veeva/ Integration Architect                    

 

Global CRM: Implementation, Support and Enhancement of Force.com applications CRM applications (Veeva CRM, meeting management, Call Center, Patient Connect, and Customer Surveys) and their data integration with other on cloud/on premise applications. All 4 applications are hosted on Force.com platform and deployed in 85 countries across 5 Orgs with a base of 20,000+ users

Responsibilities

·         Part of core solutioning team of the client – gathering business requirements, participating in user experience workshops, planning SFDC application enhancements, solution designing and execution planning, designing data integration, discussing industry trends & upcoming technologies, advising IT solutions to eliminate pain areas and do better data analytics, performing tools/technology evaluation, coordinating with different vendors and teams for various project activities, assisting with end  user trainings etc.

·         Development, Design and Testing of Force.com CRM applications – Veeva CRM, Call Center, Meeting Management, Customer Surveys and Patient Connect

·         Service Cloud implementation for Global Customer Connect. Implementation of Live Agent, Service management console, CLI integration.

·         Implementation of various support processes (Cases, Console, email-to-case, web-to-case, warm call transfer, live agent etc.)

·         Configuration and Implementation of Salesforce Email marketing cloud

·         Built Journeys and Triggers for EMC. Configuration of list and Customer master data integration.

·         Configuration & Customization of SFDC applications for various business requirements (Custom Objects, Custom Tabs, Customer screens, User Profiles, Field Level Security, User Roles, Pick lists, Page layouts, Record Types, Permission Sets, Sharing Rules, Custom Links and Settings etc.)

·         Developing custom functionalities (for different business requirements) using Apex Classes, Methods, Triggers, Visual Force pages and other Force.com platform components

·         Design and Development of data interfaces between SFDC applications and other on premise/on cloud applications (batch and real time both). Designing ETL maps in Informatica Power Center and Informatica Cloud for data transfer between Salesforce and other applications

·         Developing Reports and Dashboards in Veeva CRM for different categories of users

·         Performing proof of concepts for different requirements

·         Resolution of day to day operational issues of end users in different CRM applications (data, access, approval processes, functionality related issues)

·         Implemented new functionalities/features of Veeva CRM for different countries

·         Project planning and coordination with offshore team for various project deliveries

Environment: Force.com, Salesforce, Exacttarget, Veeva Vault, Informatica Power Center, Informatica Cloud, Oracle, APEX, Visualforce pages, SOQL, SQL, JSON

 

 

Eli Lilly and Company, Indianapolis, IN                                                                                                                        Jul 2010 – Jul 2011

BI/Integration Architect/Consultant                    

 

Profit Loss Operation Tool: Develop a US analytics solution to meet reporting needs for OPEX and Sales analysis

 

Responsibilities:

·         Conducting workshops with client’s business & IT partners, data stewards and affiliate partners to gather reporting requirements

·         Analyzing the reporting requirements and translating them into formal requirements. Documenting high level and detailed design

·         Analyzing data and translating the reporting requirements into ETL requirements

·         Design of dimensional model per the reporting requirements  

·         Working with the client’s IT and Business SMEs for various project activities – solution designing, testing strategy, project planning, status reporting etc.

·         Design and architecture of ETL process and data flow from the source systems to global data warehouse per the reporting needs – Data Extraction, Staging, Cleansing and Integrating

·         Design, development and testing of ETL maps in Informatica Power Center

·         Create SSAS Cube

·         Design, development and testing of report layouts in Tableau

·         Design of database schema and setting up data structures in Netezza

·         Performance optimization of Informatica maps to enable faster data load

·         Creation of stored procedures/triggers in Oracle and Netezza for ETL needs

·         Assisting client with User Acceptance Testing

·         Coordinating with offshore team for delivery of project tasks

·         Project Quality management and review of the code, design and test results

·         Preparation of user training material

Environment: Informatica Power Center 9.1, Netezza, Microsoft SSAS, Tableau

 

Eli Lilly and Company, IN                                                                                                                                                Mar 2008 – Jun 2010

Sales CoE

 

Responsibilities

·         Business Analysis - Understanding of existing sales applications ecosystem and preparation of an end to end architecture document. Working with the client to understand their needs and expectations

·         Identifying the pain areas of business users and correlating the same with the existing bottlenecks in the various sales applications and Reporting

·         Proposing IT solutions and crafting a roadmap to implement the same

·         Propose the new design of the complete ETL layer in order to align with the current and future business needs

·         Development of a long term support framework using a third party tool to be used for monitoring and tracking daily ETL job runs.

·         Transitioning the knowledge to offshore team and helping them create/implement the ETL jobs

·         Gathering, understanding and analyzing Business Requirements, preparation of SRS, Functional Specifications, Technical Specifications

·         Design, Construction, Testing, Implementation and support of application.

·         Designing of the ETL maps using Informatica and creation of reports layer of the system in Oracle Apex

·         Status reporting to the customer

·         Establishing, Monitoring & Improving project processes, including Issue Management, Change Management and Quality Manage