Kumar Gauraw Email & Phone Number

Leverkusen, Nrw, De

Basel, Switzerland

Designed and implemented cloud-based business intelligence solution on azure cloud. Product recommendations dashboard have been provided to Sales Reps for each pharmacy based on the opportunities evaluated with Pharmacy Insights ML Model.Insights and recommendations from pharmacy insights model has been used by the sales rep to prepare selling story of high potential products based on similar pharmacies and sell out performance.

Cologne, North Rhine-Westphalia, Germany

• Played pivotal role in establishing “R Community “for the Customer and TCS to drive projects based on R Programming and related framework• Played key role in design and development of Field Trial Planning Application based on GIS Programming and Geo Spatial Analytics which has been currently used across Europe and South America to execute field trials. Also, Customer has filed couple of patents in European Union on the innovation achieved in Field Trials.• Played significant role in design and development of Crop Yield Model to predict yield estimation for a given field based on weather scenario, growth stage, soil texture, biomass for the farmers in Germany• Effectively lead team to design and develop multiple solutions for the end customer around Agritech analytics and digital space and thus converted successful POCs to robust solutions designed to serve long term perspective• Contributed to TCS lateral hiring processes on selection of right candidates in R Programming, Python and Data Science

Noida Area, India

• Design and development of structured and sophisticated process for Business Intelligence which starts from extracting and transforming different gradient of source data to Data warehouse and Datamart using AWS Database services and enabling descriptive and inquisitive analytics using cloud-based business intelligence Tool - QuickSight.• Design and develop an Agronomic R Shiny web-based solution for Brazilian farmers provisioning herbicidal remedies for weed management in Soy fields based out of weather, next crop, resistance, growth stage and timing criteria derived through statistical procedures.• Successful Proof of Concept design implementation of Amazon Connect App to facilitate streaming of user information based on phone number dialed and thus provide user and farm summary.• Successful implementation of R based data analysis platform and package which facilitates CRUD operations related to metadata associated with iRODS database. The platform enhances the data analysis by directly integrating R with iRODS making it easy to apply different statistical technique.• Worked on IMS data analytics for one of the leading pharmaceutical clients for the Dermatology Market which helps the stakeholders to understand the distribution of sales across dermatology indication. In this project, R has been used has been used as technology framework to provide estimate of factored sales across indications and perform market analysis to derive useful insights• Developed and designed R Shiny User Interface Dashboard to track key performance indicators for 10 countries and 41 dermatology indications which gave one stop solution to the end client for better understanding of Global Dermatology Market

Bengaluru Area, India

Lead 9 member team of analysts which is responsible for providing analytical and logical solutions to Marketing Analytics Business Insights team of a leading pharma client of United States.Solves critical business problems across Sales and Marketing Analytics, such as:• Measure the effectiveness of Speaker Program using cluster analysis• Measure the effectiveness of DSA Program using BDI-CDI analysis• Evaluate impact of negative publicity on writing behavior of Physicians using ARIMA Technique• Analyze the Market Dynamics and Sources of competitor growth• Identification of physician segments based on physician response to negative publicity• Predict the Impact of Generic Intrusion using time series regression

Bengaluru Area, India

• Involved in driving a project from delivery team for a leading Pharma client to understand the Business essence and fundamentals of Advanced Parkinson Drug during the Business Discovery Phase• Identified key performance metrics to derive insights and recommendations for Marketing analytics and business insights team of client• Experience of working in SAS 9.2 with a comprehensive understanding & application of its procedure & contents like SAS/BASE,SAS/ODS,SAS/MACRO,SAS/SQL, SAS/GRAPH, SAS REPORT • Experience of designing Sales and Marketing Schema in Teradata for Sales and Marketing Launch Tracker• Having experience on working with SAS/Access interface to Teradata to perform all the ETL process and then create Analytical data sets for generating reports and insights

Bengaluru Area, India

• Developed a dashboard in QlikView which tracks the retail and non-retail data of a HIV Drug in comparison to other HIV Drugs in the market and helped Regional Sales Analytics groups to monitor the sales and effectiveness of the drug• Worked on multiple platforms like QlikView, SQL, and SAS to carry out BI and ETL operations and perform statistical analysis to generate actionable insights