SAI SUSMITHA MEDARAMETLA
Results-driven Software Engineer with hands-on experience in building real-time data pipelines, relational databases, and analytics dashboards. Skilled in Python, SQL, MySQL, Pandas, and NumPy for data processing and analysis, complemented by expertise in Power BI, Tableau, and Excel for data visualization. Experienced in full-stack development, including REST API design, frontend technologies, and cloud deployment on AWS. Google Data Analytics certified, aiming to leverage analytical and technical skills as a Junior Data Analyst.
Developed skills in fast-paced business environment, including data analysis, stakeholder communication, and strategic planning. Seeking to transition into new role where these skills can be applied and further developed. Committed to leveraging analytical expertise and problem-solving abilities to contribute to organizational success.
Work History
Business Analyst
4 Months- PROJECT: Healthcare Claims & Member Utilization Analysis
SUMMARY:
Working on developing a Healthcare Claims & Member Utilization Dashboard to analyze medical claims, member enrollment trends, provider performance, and healthcare service utilization.
Collaborated to identify business requirements, define key performance indicators (KPIs), and transform healthcare claims data into actionable insights for operational and financial decision-making.
Cleaned and validated claims data using SQL and Excel, created interactive Power BI dashboards, and presented recommendations to improve claims processing efficiency, reduce claim denials, and enhance member satisfaction.
Software Engineer
1 Year 3 Months- Developed and maintained a real-time data pipeline using Python and REST APIs to ingest and process high-volume sales transaction data for analytics reporting
- Designed and managed a relational database schema in MySQL to store customer, order, product, and transaction records, supporting accurate and scalable reporting
- Wrote optimized SQL queries to extract business insights including revenue trends, top-selling products, and customer purchase behavior, improving performance through indexing and optimized joins
- Performed data cleaning, preprocessing, and feature engineering using Pandas and NumPy to prepare transactional data for statistical analysis and forecasting
- Built a demand forecasting model using time-series analysis to predict future product sales trends and support inventory and pricing decisions
- Developed backend REST API services using Flask to expose analytics results, and created Power BI dashboards to visualize KPIs such as revenue growth, demand patterns, and seasonal trends
- Remote
- Project: Realtime Sales Analytics and Demand Forecasting System
- Skills Used: Python, SQL, MySQL, Pandas, NumPy, Flask, REST APIs, Power BI, Time-Series Analysis
- Analyzed business requirements and documented functional specifications for software development projects.
IT Analyst Intern
7 MonthsRetail Sales Performance Dashboard | Business Analysis Project
- Gathered business requirements and identified key performance indicators (KPIs) for retail sales reporting.
- Cleaned, validated, and analyzed sales data using Excel and SQL to identify revenue trends, regional performance, and product profitability.
- Designed an interactive Power BI dashboard to visualize business metrics and support decision-making.
- Presented actionable recommendations to improve sales performance, inventory planning, and regional growth based on data insights.
Education
Master of Science - Computer Science
Skills
Certification
- Google Data Analytics Professional Certificate — Coursera
- Skills Used: SQL, Excel, Data Cleaning, Data Visualization, Tableau, R Programming, SQL with Python (Pandas)
- Completed a hands-on, industry-recognized program covering the complete data analysis lifecycle, from data collection and cleaning to analysis and visualization
- Practiced data cleaning, transformation, and exploratory analysis using SQL, Excel, R Programming, and Python (Pandas) on real-world datasets
- Built interactive dashboards and visualizations in Tableau to communicate data-driven insights and support business decision-making