Venkata Sai Raviteja Adabala

Hydrant Object Detection using Computer Vision:

• Collaborated with Fairfax County Fire and Rescue Department to develop a Fire Hydrant Detection System using computer vision techniques
• Goal: Accurately detect fire hydrants in images
• Utilized tools: TensorFlow, OpenCV, Object Detection API, and Jupyter Notebook
• Worked with a large dataset of around 250GB containing annotated images with hydrant locations
• Trained and evaluated two object detection models: COCO Pre-trained EfficientDet and Faster R-CNN
• Models are known for proficiency in detecting objects like fire hydrants
• Successful implementation offers potential benefits for firefighters
• Swift and accurate hydrant detection enhances emergency response times
• Enables prompt access to water sources, improving fire combat efficiency
• Potential to save lives and minimize damage during fire emergencies.
• Utilized various professional statistical techniques and maintained large databases to collect and analyze data from partners and customers.

• Played a pivotal role in enhancing the efficiency of financial report generation by harnessing my Python programming skills
• Collaborated within a dedicated team to design and implement Python scripts tailored for data quality checks, ensuring the consistency, integrity, and precision of financial data
• Employed Python to develop automated processes that not only expedited report generation but also reduced the risk of errors in financial data
• Designed and maintained data models within OFSAA (Oracle Financial Services Analytical Applications) to represent financial instruments, accounts, and other relevant entities
• Analyzed large datasets using AWS data analysis tools like Amazon Redshift, Athena, EMR, etc
• Transformed data using AWS Glue to prepare it for analysis
• Integrated AWS data services like S3, Glue, and Lambda into data workflows
• Created compelling data visualizations and dashboards using tools like Amazon QuickSight to communicate findings effectively
• Utilized advanced features within the OFSAA application to perform intricate data analysis, contributing to data-driven decision-making across the organization
• Demonstrated proficiency in SQL Developer and Oracle Data Integrator (ODI) to create a cohesive and integrated data environment
• Experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL
• Integrated financial data from various sources into OFSAA, ensuring data accuracy and consistency
• Developed and maintained Extract, Transform, Load (ETL) processes
• Enabled seamless data integration, transformation, and analysis, which, in turn, paved the way for faster and more informed decision-making
• With an in-depth understanding of various database management systems, including SQL Developer, PostgreSQL and MYSQL, I possess a well-rounded skill set that is essential for enhancing data-related processes
• Expert in data preparation with experience in blending multiple data sources, and creating multiple joins within the same data source
• Designed, developed, and tested various PowerBI as well as Tableau visualizations for dashboard and ad-hoc reporting solutions
• Developed interactive dashboards and reports using Looker
• Created compelling data visualizations to communicate insights effectively with the help of Tableau
• Designed interactive dashboards with drill-down capability, roll-back capability, customizations by using both live and extract data connections
• Worked with various team including Business Analysts, ETL, Data Warehousing, and testing for smooth flow/transition of development life cycle
• Utilized Python for data quality checks, ensuring that data inconsistencies and inaccuracies are minimized, leading to more reliable insights
• Proficient in extracting meaningful patterns and trends from complex datasets, thus aiding strategic planning and resource allocation
• My combined expertise in data analysis, scripting, and data management positions me to make informed contributions to improving organizational processes and fostering effective decision-making
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.