Atish Saurav

Automation of Numerous Report Generation for Post Tensioned Bridges Using AI and LangChain

• Successfully automated the report generation process using Retrieval Augmented Generation (RAG) with LangChain, significantly reducing the time required to produce detailed reports
• Implemented a robust data ingestion and indexing system using Document Loaders, Text Splitters, and VectorStore, enhancing data retrieval efficiency
• Developed a seamless orchestration workflow with LangGraph, ensuring smooth integration of data retrieval and content generation

Technical Skills:

• Proficient in using LangChain for building RAG applications, including components like Document Loaders, Text Splitters, VectorStore, and Retrievers
• Experienced in setting up development environments and managing dependencies for AI and data analytics projects
• Skilled in integrating AI-powered tools for data analysis, trend prediction, and report generation

Technical Integration and User Experience Enhancement:

• Successfully integrated Excel with Python, simplifying the user experience for utilizing the PyMCT tool
• Led product development efforts using Python and SQL to automate bridge design, resulting in a 50% increase in efficiency for bridge engineers

Database Management and Optimization:

• Responsible for creating, updating, and maintaining database using SQL and Python, streamlining data manipulation and presentation for the team
• Collaborated closely with an explanatory data analyst to facilitate data visualization, ensuring effective communication of insights

• Utilized Pandas to gather and integrate data from various sources, ensuring seamless data flow and accessibility
• For instance, integrated design data from MIDAS Civil and Staad Pro software used in projects like Mumbai Metro Line 9 and Mumbai Metro Line 6
• Employed Pandas and NumPy for data cleaning and preprocessing, standardizing data formats, and removing inconsistencies to maintain data quality
• This was crucial in handling complex utility problems in projects such as Delhi Metro Phase 4 and Mumbai Metro Line 4
• Conducted comprehensive data analysis using Pandas and created insightful visualizations with Matplotlib to support data-driven decision-making
• Visualizations were used to present detailed design and detailing of structures like pile foundations, pile caps, and piers in projects like Mumbai Metro Line 9 and Mumbai Metro Line 4
• Developed automation scripts using Selenium and Airflow to streamline repetitive tasks, enhancing efficiency and reducing manual effort