Kratika Gupta

Experience

• 

  Wipro

  Jul 2014 - Jun 2016

  Project Engineer

  -Interfaced with vendor partners and designed platforms in Salesforce.com to cater to the business requirements. Platform designing involved creating and maintaining workflows, approval processes, and validation rules based on the stakeholder’s requirements and familiarity with Salesforce.com Integration components for SFDC ( for example, SFDC APIs, Apex controllers, Apex Web Services, Apex callout, outbound messaging, and SFDC data loaders). -Continuously maintaining and performing processes to monitor data quality and integrity in platform applications.-Worked with functional leads and evaluated the information gathered to transform and implement requirements in Salesforce.com while also breaking it down from high-level information to detailed one. Show less

• 

  Fractal Analytics

  Jul 2016 - May 2018

  Senior Analyst
• 

  University of Cincinnati Carl H. Lindner College of Business

  Aug 2018 - Sept 2019

  Graduate Assistant

  ● Predict the presence and amount of radioactivity - Predicted the presence and calculated the amount of radioactive wastegenerated from well characteristics data using generalized linear regression and gradient boosting algorithm● Understanding the dependence of WinRate on Email data - Built a model to understand the relationship between emailresponses of sales representatives and WinRate

• 

  Amazon Web Services (AWS)

  Sept 2019 - Oct 2024

  Business Intelligence Engineer

  Sales Opportunity Funnel Forecasting● The business goal was to develop sales funnel metrics optimization strategies using ML and dataanalytics, enabling product leads to drive successful MBRs and provide sales teams with actionable insights.● Developed ETL pipelines to streamline data integration from various platforms. Built a forecasting platform with dedicated models for different markets toaccurately predict sales pipeline health. Developed KPIs that tracked the sales opportunity conversions and funnel health.● Designed an executive Tableau dashboard capturing metrics, leveragingpredictive analytics for sales funnel health tracking.Executive Summary Dashboard● Led the development of a unified platform to track and consolidate ~150 organization-wide metrics for businessperformance evaluations, serving as a one-stop solution for VP level reviews.● Achieved a significant reduction in manual work, cutting multiple man-hours per week into a 10-minute process at zero information loss.● Collaborated with cross-functional teams to define comprehensive consolidated metrics and team-specific metrics criticalmetrics for each department from a pool of 150 KPIs to ensure alignment across business units.● Built ETL pipelines for seamless data integration and developed a Tableau dashboard to present executive-level summarymetrics in a single view with capabilities for in-depth analysis for underperforming metrics.29M Free Individuals Trained Dashboard● Drove the backend data design and dashboard development for tracking AWS's high-visibility goal of training 29 millionindividuals for free by 2025.● Developed a high-visibility Tableau dashboard with strict latency requirements, ensuring the accurate and immediatedisplay of data for PR and executive reporting.● Implemented performance-tuning strategies to ensure fast dashboard load times, meeting the critical need for seamless access to the most up-to-date metrics without delays. Show less