Adidam Mohan Sai Venkata Phani Abhiram Raju Email and Phone Number

Project: Cohort Creation and Attrition Analysis ToolTech Stack: SQL, R, RShiny, HTML, CSS- Developed and deployed an RShiny web application to automate cohort creation and attrition analysis for immuno-oncology studies, reducing processing time by over 95%.- Engineered the tool to dynamically process and analyze large datasets (1M+ records) based on protocol-defined criteria, achieving a 92% accuracy in patient cohort generation.- Integrated R and SQL for backend processing, reducing the runtime of attrition analysis from 10 hours to 30 minutes and achieving a 97% success rate in query execution.- Automated data quality checks and anomaly detection using custom macros, reducing data cleaning and validation time by 70%.- Collaborated with a multidisciplinary team of 23 members using Domino Data Lab, facilitating efficient project management, version control, and collaboration.- Streamlined the user interface to improve usability and reduce the learning curve, resulting in a 25% increase in user satisfaction.- Created comprehensive documentation, including code comments and user manuals, to facilitate knowledge sharing and reduce onboarding time for new team members.- The tool supported 15+ clinical studies by delivering precise and customizable patient cohorts, streamlining research processes, and saving the organization $500K annually.

As a Classroom Assistant for Dr. Andrew Revell, I supported the effective delivery of lectures and ensured the smooth operation of classroom environments across various undergraduate courses. My responsibilities spanned both logistical support and classroom management, helping facilitate a seamless learning experience for students.- Classroom Setup and Operations: Assisted Dr. Revell with the physical setup of classroom spaces. This included navigating classrooms, ensuring clear pathways, and setting up equipment for an optimal teaching environment.- Early Arrival and Preparation: Arrived early to ensure classroom doors were open and accessible, pathways were clear, and everything was set up for the day’s lesson and helped with pulling down audio-visual screens and preparing technology equipment for use.- Tech Setup: Managed the technology equipment setup, including adjusting modes via wall/table switches, setting up camera units, and preparing projectors and lamp arms. I also connected and disconnected the cables to ensure the instructor’s equipment was ready.- Material Distribution: Assisted in distributing handouts, worksheets, and other instructional materials to students, ensuring everyone had the necessary resources for the class.- Setup and Removal of Accessories: Managed mobile accessories such as laptop carts and material kits, ensuring they were correctly set up before class and removed afterward to keep the classroom organized.- Proctoring Exams: Supported Dr. Revell in proctoring exams by moving about the room, ensuring academic integrity, and helping manage the physical layout of tables and chairs for optimal test-taking conditions.This role allowed me to enhance my organizational skills, improve my ability to manage classroom logistics and strengthen my communication skills while assisting in the smooth operation of multiple undergraduate courses.

As a Graduate Teaching Assistant for the Engineering Economics (EGR303) course, I supported the academic success of over 90 undergraduate students. This course introduced fundamental economic concepts within an engineering context, and I played a key role in reinforcing these concepts through various instructional and support activities.- Grading and Evaluation: Assisted in grading various academic deliverables, including homework, quizzes, exams, and student group activities. Maintained accuracy and consistency in grading, ensuring students received timely and constructive feedback, contributing to their learning outcomes.- Tutoring and Office Hours: Held regular tutoring sessions and office hours to address student queries and clarify complex topics. Provided one-on-one and group support to help students navigate challenging coursework, improve their problem-solving skills, and better understand the course material.- Student Assistance: Acted as a primary point of contact for students, handling queries related to coursework, assignments, and exams. Assisted students in developing strategies for tackling engineering economics problems, enhancing their analytical thinking and application skills.- Collaboration with Faculty: Worked closely with Dr. Hamed Samandari to align teaching assistance with the course curriculum and objectives. Contributed to course improvement through feedback and observations gained from direct student interactions.

Projects:COTA and PREAMBLE Data Quality AssessmentTech Stack: SQL, SAS, Excel- Led a team of 5 to assess oncology datasets (DLBCL and CLL cohorts) with 9M+ patient records, identifying data anomalies and enhancing data quality using SAS and SQL.- Automated 70% of validation processes through custom macros, doubling the project pace and reducing timelines by 50%.- Collaborated with cross-functional teams to ensure data quality standards, certifying datasets that impacted 10+ clinical studies.Clinical Outcomes ReportsTech Stack: SQL, SAS, Excel- Generated predictive reports by analyzing clinical characteristics, treatment patterns, and survival outcomes of cancer patients using advanced statistical methods in SAS and SQL.- Leveraged FlatIron Health EHR data and Amazon RedShift databases to analyze data from over 100,000 cancer patients, providing insights into survival rates, progression rates, and healthcare resource consumption.- Conducted survival analysis using Kaplan-Meier Estimates and Cox Proportional Hazards models, which led to a 20% improvement in study efficiency.- Collaborated with clinical researchers, statisticians, and data scientists to ensure alignment with study protocols and FDA regulatory standards.- Contributed to the progress of 12 ongoing clinical studies and the initiation of 23 new studies by generating accurate and relevant reports.Interactive Survival Analysis and EDA ToolTech Stack: Python- Developed an interactive Jupyter notebook for automated exploratory data analysis and survival analyses, reducing manual data preprocessing by 60%.- Integrated Kaplan-Meier and Cox models into the tool to analyze datasets of 500,000+ records, supporting decision-making for 5+ clinical studies.

Project: Sales Performance Analysis and Reporting- Analyzed and optimized sales performance by conducting data exploration, statistical testing, and automated reporting, improving sales efficiency and campaign effectiveness.- Performed Exploratory Data Analysis (EDA) on sales datasets comprising over 500,000 records, uncovering trends and patterns that informed strategic business decisions.- Utilized Python libraries, such as Pandas and Matplotlib, to generate descriptive statistics and visualizations, leading to actionable insights for sales optimization.- Implemented hypothesis testing (e.g., t-tests, ANOVA) to evaluate the impact of promotional campaigns on sales performance, leading to a 15% increase in targeted sales.- Conducted data cleaning and transformation using SQL and Python, addressing inconsistencies and missing values in over 200 tables, enhancing data quality and reliability.- Developed and automated weekly sales performance reports in Excel, using advanced functions and pivot tables to summarize critical metrics, reducing report generation time by 40%.- Collaborated with cross-functional teams, including marketing, finance, and sales, to ensure data alignment and accuracy.- Delivered actionable recommendations based on data analysis, contributing to a 10% increase in overall sales efficiency.