Candidates About

 

Maneesh Gupta

PROFESSIONAL SUMMARY

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

Ø  Conversant with Healthcare, Banking, Insurance and Manufacturing domain

Ø  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 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.)

Ø  Close to 4 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). Have configured Live Chat functionality of SFDC and integrated with multiple customer facing websites

Ø  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

Ø  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

Ø  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 used AJAX and JavaScript with Visual force

Ø  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)

Ø  Very good experience on Veeva Vault (PromoMats and MedComms). Have created document types, workflows, roles, stages. Have integrated Veeva Vault with Veeva CRM for various business requirements

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

Ø  Good Migration experience. Have migrated applications from Seibel to SFDC, Zoho to SFDC, SFDC to Veeva CRM

Ø  Close to 4 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 10 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 5 years of reporting experience on SSRS, BO, Cognos, Oracle Apex and Roambi Analytics

Ø  Performed proof of concept for the client on Salesforce analytics (Wave) reporting platform

Ø  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 10 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.

Ø  Very Good experience in iPAD reporting using Roambi Analytics

 

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, Cognos, Roambi, Salesforce Analytics (Wave)

Database                                             :               Netezza, Oracle, SQL Server

Operating Systems                           :               Windows, Linux/Unix

 

EDUCATIONAL QUALIFICATIONS

Ø  Executive Program for Young Professionals (EPYP, Specialization - Finance) from Indian Institute of Management (IIM), Calcutta, India

Ø  Bachelors in Engineering in Information Technology from Institute of Engineering & Technology, Rajasthan University, India in 2005

 

PROFESSIONAL CERTIFICATIONS

 

 

PROFESSIONAL EXPERIENCE

 

Eli Lilly and Company, Indianapolis, IN                                                                                                                          Jan 2012 - Present

Salesforce/Veeva/Integration Architect/Consultant                    

 

Global CRM: Implementation, Support and Enhancement of CRM applications (Veeva CRM, GCC, Mercury, Pulse) and their data integration with other applications of Veeva suite (Veeva Vault and Veeva Network) along with other on premise and on cloud 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

·         Configuration & Customization of Veeva CRM application 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, Veeva Messages and Custom Links and Settings etc.)

·         Development, support and enhancement of other Force.com CRM applications - Mercury, GCC and Pulse

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

·         Design, Development and Support of data integration between Veeva CRM, GCC and Mercury

·         Part of core solutioning team of the client – gathering business requirements, participating in user experience workshops, planning Veeva CRM application enhancements, solution designing and execution planning, designing data integration, discussing CRM 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.

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

·         Monthly sandbox refreshes, management of Salesforce & Veeva CRM quarterly releases, testing of new functionalities and bug fixes of Veeva CRM releases

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

·         Managing data security and visibility within Veeva CRM application using sharing rules, roles, field level visibility and other security settings

·         Implemented new functionalities/features of Veeva CRM product for different affiliates

·         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

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

Environment: Force.com, Salesforce, Veeva Vault, Informatica Power Center, Informatica Cloud, Oracle

 

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

BI/Integration Architect/Consultant                    

 

Global Business Reporting: Develop a globally standardized business reporting platform for performing analytics on sales reps activities and their call objectives. Developed for Desktop and iPad

 

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

·         Creation of report strawmans in SSRS and Roambi to help client decide the final layout

·         Design, development and testing of reports and dashboards in SSRS. Advising on different reporting metrics to enable better analytics and decision making

·         Design, development and testing of report layouts in SSRS to be consumed by Roambi

·         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 SSRS, Roambi Analytics

 

Zimmer Inc., Warsaw, IN                                                                                                                                                May 2010 – Jun 2011

BI/Integration Architect/ Oracle Apex Designer

 

1. BI – APGD: Streamline the existing Business Intelligence framework to have all the source systems across all geographies brought into the ambit of a centralized data warehouse in order to enable accurate analytics based on single version of truth

2.       DMO (Development and Manufacturing Organization): Develop a web based application in Oracle Apex to automate the existing manual operations for creation/maintenance/tracking/monitoring of work orders. Also helps in registering the Time Sheet entries for all groups of people working on different activities on different Work Orders. The application also generates different business reports for the business users and owners to analyze the DMO data and take informed decisions.

 

3.       World Cup Business Reporting: World Cup refers to the major implant instruments having cup shaped structure (Hips, Knees and Extremities). The application was developed to perform the weekly forecasting about potential sales/deployment of these cups/instruments. Once forecasting is done, the actual sales value is compared with forecast values and various other metrics are derived. Forecasting is performed by several countries across the globe for all the concerned cups. Then their sales figures are extracted for comparison and analysis. This analysis is achieved through reports and dashboards developed in the application.

 

1. PROTOS BI Reporting: To develop a web based Inventory Optimization application to track, manage and optimize the inventory of manufactured instruments and cups across the globe. Other functionalities of the application include weekly forecasting, business reports and dashboards to analyze the inventory levels at Territory, Region and Corporate level.

Responsibilities

·         Business Analysis - Understanding of existing BI 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 ETL, Reporting and DWH design

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

·         Propose the new design of the complete ETL layer in order to remove all the existing bottlenecks and 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 Management.

·         Creation of stored procedures and triggers in PL/SQL

·         Interacting/Coordinating with the client for various project activities

·         Technically leading the project team for various project activities

·         Design, Development and Testing of the ETL components and reports & dashboards

·         Technically leading the project team for various project activities

·         Documenting and sharing the business knowledge with the team members

·         Identifying areas for improvements in the design/Coding, and implementing the same

Environment: Informatica Power Center 8.1, Oracle, SQL Server, Cognos, Oracle Apex

 

Medtronic Inc., Minneapolis, MN                                                                                                                                               Jun 2009 – April 2010

ETL Lead/ Data Specialist

 

EDW Support and Enhancement: Maintenance and Enhancement of existing Enterprise Data warehouse and Integration Support data warehouse of the client.

 

Responsibilities

·         Understanding of existing Data Warehouse and preparing System Understanding Document for the team.

·         Maintenance, Enhancement and Support of the Data Warehouse using Informatica, Cognos, Business Objects and PL/SQL

·         Preparation of High Level Architecture and Data Flow Diagram of the existing Data Warehouse.

·         Creating and enhancements of Business reports in Cognos.

·         Weekly Status Reporting to Project Manager and Client’s Business Owner.

·         Monitoring of Scheduled Jobs, Fixing of failures, communicating to business users about any potential delay/outage in the system.

·         Resolving the Work Tickets and Incidents through Global Resolution System application.

·         Preparing weekly Service Level Agreement reports/sheets to be shared with the client.

·         Estimation of various enhancement requests from client.

·         Quality improvement, Causal Analysis, defect prevention and preparing checklists

·         Imparting Project training to new team members

Environment: Informatica Power Center 7.1, Oracle PL/SQL

 

Hitachi Data Systems, Santa Clara CA                                                                                                                        May 2007 – May 2009

Tech Lead

 

1.       VSOE (Vendor Specific Objective Evidence) Compliance Reporting

VSOE is the fair value of software. It governs how any company that licenses, sells, leases or otherwise markets software must recognize the revenue.  In particular, it governs how companies must recognize revenue from so-called “multiple-element arrangements” – bundles of software products and related services sold as a unit, at a single price.  The project aims at making the ensuring compliance with VSOE norms and to ensure price consistency towards the end customers.

2.       Global Trade Compliance Reporting

The project involved automation of all the manual processing in place for assimilation and reporting of client’s exports/shipments. To avoid manual interventions for the preparation of Global Trade Compliance reports, a centralized-single point data warehouse was created to keep all the export related data. Scheduled Jobs were created to extract the data daily from different source systems across the geographies.  All the Compliance reports are then generated out of it and sent to the US government.

3.       PRA (Pricing and Revenue Analytics):

To automate the process of analyzing, performing what if scenarios, compare their pricing with competitors, and share information in a secure environment that will allow complicated analysis to take place. The objective was to provide an environment to place external competitive data, client data, and 3rd party information in an environment that can be accessed, analyzed researched, sliced and diced, and provide the capability to establish the optimal pricing strategy for the client going forward.

Responsibilities

·         Leading the project from offshore

·         Gathering Business Requirements

·         Creating System Requirement Specifications, High Level and Low Level Design Documents

·         Data Modeling, Designing Database, Designing Application Architecture, Constructing/Development, testing, debugging, Implementation and Warranty Support

·         Creation of ETL maps in Informatica and performance tuning of the maps

·         Addressing the technical doubts/queries of the team

·         Creation of stored procedures and triggers in using PL/SQL

·         Develop of Universe, reports and dashboards in Business Objects XI R2

·<span style="font:7pt