Dec 2024 – Dec 2025 · 1 yr · Bloomington, Indiana, United States · On-site

• Developed a GPT-4o–powered AI agent for SBOM security analysis that scans software bill of materials (SBOMs) for dependencies, detects vulnerabilities, and recommends remediations using Google’s OSV database.
• Integrated Retrieval-Augmented Generation (RAG) and custom API tools for real-time, explainable vulnerability reports across SPDX, CycloneDX, and JSON SBOM formats. The API is deployed as a serverless API on Vercel along with the frontend.
• Engineered a scalable backend with Vercel serverless, and supabase, enabling real-time SBOM analysis.
• Built a robust parser for SPDX documents, extracting critical package metadata (e.g., PURLs, CPEs) to query open vulnerability databases.
• Enhanced security workflows by automating the detection of high-risk packages, improving auditability and reducing manual review.
• Currently working on fine-tuning and hosting Llama 3.2 1B Instruct model on Jetsteam2 (internal server) to enable on-prem SBOM analysis with reduced latency, cost, and dependency on OpenAI’s closed source models and API.

Dec 2023 – Nov 2024 · 11 mos · Bloomington, Indiana, United States · On-site

• Collaborate closely with the Senior Data Analyst to migrate existing IDEA scripts into Alteryx workflows, ensuring compliance with project requirements and specifications
• Testing of migrated analytics within Alteryx to ensure the accuracy and reliability of data processing
• Create clear and well-organized documentation of the migration process, including comprehensive records of parameter and filter modifications, facilitating easy reference for future audits and continuous monitoring programs
• Enhanced audit efficiency by 20% by optimizing data analysis workflows using SQL, Alteryx, and Excel for continuous monitoring.
• Automated semi-annual and annual data processing with Alteryx, increasing workflow efficiency by 60%, enabling real-time audit insights.
• Presented at the Indianapolis Alteryx Q4 User Group Meeting, delivering a tool deep dive and use case session on the Find Replace Tool in Alteryx. Demonstrated its versatility for data transformation, substring matching, and masking sensitive information, contributing to community knowledge sharing and engagement.

Feb 2023 – Jul 2023 · 5 mos

• Design, develop, and analyze simulation models utilizing WITNESS, Simio, SIMUL8, Flexsim, Anylogic, Plant Simulation, and AutoMod
• Collect and analyze data to create an Excel interface with dynamic and static simulation models
• Verify and validate simulation models using static analysis in Excel
• Analyze results from static and dynamic simulations to identify optimal inventory levels, aisle congestion, space requirements, resource utilization, overall throughput, material routes and improve production
• Determine adequate material handling equipment requirements
• Develop process improvements and AutoCAD layout design to support engineering development
• Design line side delivery and route planning
• Dock and warehouse analysis
• Create Excel VBA programs to automatically update simulations, production schedules, and external data queries
• Led the Taco Bell project for North American stores, integrating online orders into the existing store simulation model using Simio. Successfully determined optimal staffing and inventory levels, reducing wait times by 16% overall.
• Partnered with Swisslog to build a simulation model for HelloFresh from scratch, analyzing the impact of staffing and conveyor speed variations. Identified an optimized configuration that increased production throughput by 22% while reducing operational costs.
• Developed a simulation model for Sartorius, identifying overstaffing issues and operational inefficiencies in their planned facility. Recommended optimal staffing adjustments for the target production, leading to a substantial reduction in staffing costs.
• Mentored and trained interns and new hires in simulation software, principles of simulation, data analysis, and coding, enhancing team efficiency and knowledge retention. Organized knowledge sharing sessions to discuss interesting projects.
• Conducted client training sessions on Simio and simulation best practices.

May 2021 – Feb 2023 · 1 yr 9 mos

• Designed, developed, and analyzed simulation models utilizing Simio, SIMUL8, and AutoMod
• Collected and analyzed data to create an Excel interface with dynamic and static simulation models
• Verify and validate simulation models using static analysis in Excel
• Analyze results from static and dynamic simulations to identify optimal inventory levels, aisle congestion, space requirements, resource utilization, overall throughput, material routes and improve production
• Determine adequate material handling equipment requirements
• Dock and warehouse analysis
• Create Excel VBA programs to automatically update simulations, production schedules, and external data queries

Mar 2020 – Jul 2020 · 4 mos · Nagpur, Maharashtra, India

• Conducted data analysis on active projects using MS Excel, Python, & Simul8, contributing to project success and decision-making.
• Automated work content calculations and simulation input processing, using MS Excel and Simio, reducing manual effort by 20%.
• Built warehousing simulation models using Simul8, Python, and Excel, to automate the calculations of required manpower.
• Developed foundational simulation models in Simul8, AutoMod, and Plant Simulation, directly contributing to live projects.