Ranjan Pandey Email and Phone Number

• Strategized Product roadmap for implementation of generative Artificial intelligence at the organizational level • Identified 6+ use cases of Gen AI in multiple data modules of production stages of investigation process. • Developed a GPT 4 based model that performs “Batch failure investigation” with inputs in human language • Ideated an innovative approach by utilizing the combination of SQL , Python & LLM to achieve 99.9% accuracy • Performed Prompt engineering on AI… Show more • Strategized Product roadmap for implementation of generative Artificial intelligence at the organizational level • Identified 6+ use cases of Gen AI in multiple data modules of production stages of investigation process. • Developed a GPT 4 based model that performs “Batch failure investigation” with inputs in human language • Ideated an innovative approach by utilizing the combination of SQL , Python & LLM to achieve 99.9% accuracy • Performed Prompt engineering on AI model for providing recommendations across database with 50k+datapoints • Presented a POC of AI model to cross functional teams of Product managers and data scientists as well as to CIOAchievements: • Reduced production down time by trimming the batch investigation process turnaround time from 30 to 2 days • Awarded Pre-Placement offer (1/6) for taking full ownership of project & coming up with an innovative solution Show less

1. Conducted comprehensive market research to identify emerging trends and competitive landscape within the industry, providing actionable insights to support strategic decision-making processes. 2. Assisted in the development and implementation of marketing strategies, including social media campaigns, product launches, and promotional activities, contributing to increased brand visibility and customer engagement.3. Supported the analysis of key performance indicators (KPIs)… Show more 1. Conducted comprehensive market research to identify emerging trends and competitive landscape within the industry, providing actionable insights to support strategic decision-making processes. 2. Assisted in the development and implementation of marketing strategies, including social media campaigns, product launches, and promotional activities, contributing to increased brand visibility and customer engagement.3. Supported the analysis of key performance indicators (KPIs) to evaluate the effectiveness of marketing initiatives, helping to optimize marketing budgets and enhance overall campaign performance. Show less

• Responsible for handling Spot Instances of Amazon Web Services and reducing operational costs of company • Developed Lambda Functions to gracefully shutdown the AWS spot instances by Configuring AWS event bridge • Generated multiple optimized PostgreSQL functions that contain business logic for database operations by the user • Handled Amazon Web Service lambda for synchronizing HubSpot customer’s CRM data with Postgres databaseAchievements: • Received an appreciation… Show more • Responsible for handling Spot Instances of Amazon Web Services and reducing operational costs of company • Developed Lambda Functions to gracefully shutdown the AWS spot instances by Configuring AWS event bridge • Generated multiple optimized PostgreSQL functions that contain business logic for database operations by the user • Handled Amazon Web Service lambda for synchronizing HubSpot customer’s CRM data with Postgres databaseAchievements: • Received an appreciation from Technical Lead for saving the company’s server charges by 70% approximately Show less

• Managed a Group of 25+ People to organize “SPECTRA” event, which spanned over a period of 3 days [2019] • Led a 12 members team to arrange the live concert of Coke Studio, India on the university campus, at LPU [2018] • Arranged the sponsorship worth 1.6 lakhs from burger king, Phoenix and Zomato for “SPECTRA” event [2018]