Ranjith Kumar Venkatachalam
Summary
Results-driven engineer with a focus on precision and high-quality solutions, consistently achieving minimal defect rates. Exceptional problem-solving abilities and adaptability in complex technical environments. Collaborates effectively across teams to translate business needs into scalable solutions. Proven success in reducing operational risk, enhancing efficiency, and accelerating delivery timelines.
Overview
3
3
years of professional experience
Work History
Senior Consultant
Eli Lilly and Company
01.2023 - Current
- Delivered a Power Apps-based solution for internal C2P teams to record and track conversations and settlement details of HCPs who do not have company AD accounts.
- Designed a secure integration where chatbot submissions are sent to a Power Automate HTTP-triggered flow, restricted via authentication policies ensuring that only authorized automated clients can invoke the flow.
- Coordinated with the Azure team to set up an Azure App Registration enabling OAuth-based authentication for the chatbot, ensuring secure and validated API calls into Power Automate.
- Built a Power Automate flow to process incoming data, validate mandatory fields, handle file attachments, and push all information into a structured SharePoint List repository.
- Developed an automation framework to support the Data Fabric initiative, enabling consistent data refresh for Power BI dashboards by automating report collection from multiple systems including Mercury, CPS, and Cvent.
- Implemented an RPA solution that downloads daily reports from each platform and uploads them into a centralized SharePoint Document Library, from which Data Fabric pipelines consume and refresh the datasets.
- Resolved large-file upload limitations for files exceeding 250MB by designing a custom Python-based streaming upload solution, splitting the file into 10MB chunks and uploading sequentially until completion-ensuring reliability and preventing upload failures.
- Delivered an automation solution where an RPA bot updates HCP consent details in the Salesforce system based on information received through system-generated emails sent to a shared mailbox.
- Implemented logic to extract consent information from free-text emails written in multiple European languages, addressing linguistic variability and inconsistent formatting.
- Applied Cortex LLM platform to interpret consent information from multi-language emails and drive RPA automation decisions. Built RPA workflows that construct prompts, call LLM APIs, parse structured outputs (Consent Given/Not Given/Unidentified), and update Salesforce records with audit attachments.
- Built a virtual agent chatbot POC using Cortex LLM platform to help RPA developers access technical documentation more efficiently. The chatbot uses RAG concepts: curated knowledge base (coding standards, API configs), embeddings-based retrieval to find relevant documents, and LLM to provide answers based on retrieved content. Demonstrated reduced time for developers to find technical guidance.
Education
Bachelor - Computer Science And Engineering
Karpagam College of Engineering
CoimbatoreSkills
- Automation Anywhere A360
- Python Programming
- Power Apps
- Power Automate
- SQL
- SharePoint REST APIs
- Azure App Registrations
- LLM Integration
- API-driven integrations
- Agile methodologies (Scrum and Kanban)
- AWS S3 APIs
Timeline
Senior Consultant
Eli Lilly and Company
01.2023 - Current
Bachelor - Computer Science And Engineering
Karpagam College of Engineering