Hello!
I'm Rohith Panjala
About
I am a Data Analytics Engineer with a Master's degree from George Mason University, specializing in machine learning, data visualization, and statistical modeling. With expertise in tools like Python, R, SQL, Excel, Tableau, and Power BI, I am passionate about transforming data into actionable insights. My professional experience is deeply rooted in SQL, where I have worked extensively on crafting complex queries, optimizing query performance, and building stored procedures to streamline repetitive tasks. I have designed and maintained relational database schemas, implemented indexing strategies to enhance database efficiency, and performed advanced joins, subqueries, and window functions to extract meaningful insights from large datasets. I have contributed to projects like SkinGPT, an AI-driven diagnostic tool utilizing machine learning for dermatological care, and a Generative AI RAG chatbot aimed at improving citizen engagement. My experience also includes creating statistical models for predictive analytics, conducting sentiment analysis on social media data, and designing interactive dashboards to communicate insights effectively. My strong technical foundation, combined with a detail-oriented approach to solving complex problems, drives my commitment to delivering impactful solutions that facilitate informed decision-making.
Skills
Cloud and Machine Learning Technologys
AWS Cognito, QnABot, RAG Systems, AWS Infrastructure Management, AWS Cost Optimization, AWS Solution Architecture, AWS Kendra, AWS SageMaker, TensorFlow, KNN, CNN, Logistic Regression, Linear Regression, Random Forest, Decision Tree, NumPy, Pandas, Matplotlib, XGBoost, Natural Language Processing (NLP), YOLOv5, LLaMA Model.
Data Analysis and Visualization tools
Tableau, Power BI, R Programming, Google Colaboratory, Anaconda, MySQL Workbench
Microsoft Office
Word, PowerPoint, Excel (Pivot Tables, Linear Optimization, Queueing Simulation, Decision Tree)
Programming Languages
C, Python, Java
Database
MySQL, MongoDB
Web Technologys
Sping boot framework, OOPS, HTML, CSS, java script
Background
Education
Master in Data Analytics Engineering
2023 - 2024
George Mason University, Fairfax, VA
Bachelor of Engineering in Electric and Electronics
2016 - 2020
Chaitanya Bharathi Institute of Technology and Science, Hyderabad, India
Professional Experience
Data Analyst
Jan 2022 - Dec 2023
Hyderabad, India
- Designed and implemented scalable data pipelines using SQL, Python, and PySpark, automating ETL processes and optimizing end-to-end data workflows, reducing processing time by 30% and enhancing data reliability.
- Developed and deployed predictive models on large insurance datasets to identify fraud patterns, assess customer risk factors, and optimize premium pricing using machine learning techniques such as regression, classification, and clustering.
- Performed actuarial analysis and statistical forecasting to support loss reserving, claims projection, and financial planning across diverse insurance portfolios.
- Conducted data wrangling and exploratory data analysis (EDA) using Python (Pandas, NumPy, Seaborn) and SQL to uncover key business drivers and performance insights.
- Created interactive dashboards and reporting solutions using Power BI and Tableau, offering executives real-time visibility into KPIs, customer churn, revenue trends, and risk indicators.
- Partnered with cross-functional teams including product, finance, and compliance to drive data- informed decision-making and ensure adherence to regulatory standards (IRDA, IFRS).
- Participated in A/B testing and impact analysis of business strategies to drive continuous process improvement and customer satisfaction.
- Managed version control and collaborative development environments using Git and Agile methodologies, ensuring efficient and transparent project delivery cycles.
Data Analyst Intern
Jan 2021 - Dec 2021
Hyderabad, India
- Conducted exploratory data analysis (EDA) on financial and customer datasets using Excel, SQL, and -Python to derive actionable business insights.
- Designed structured reports and dashboards using Excel and Power BI to visualize operational metrics and financial KPIs, enabling improved business forecasting and reporting clarity.
- Worked closely with senior analysts and data engineers to document data dictionaries, data lineage, and transformation logic for better metadata management and governance.
- Assisted in mapping legacy systems to new BI infrastructure, gaining hands-on experience with database migrations, normalization, and ODBC integration.
- Supported cross-team data validation efforts to ensure data accuracy and consistency across multiple internal systems and client platforms.
