Naga Prathyusha Rayankula

Accomplished Software Developer with a proven track record at Ruat Technologies LLP, specializing in SQL Server and Power BI. Expert in optimizing complex queries and enhancing data integrity, while effectively collaborating with cross-functional teams. Proficient in Python and committed to delivering impactful data-driven solutions. Strong analytical and problem-solving skills.

• Leadership and teamwork
• Problem-solving and time management
• Adaptability and responsibility
• Strong communication and organizational skills

Craftworks Playing badminton

• Power BI Expertise: Skilled in Power BI for report generation, dashboard creation, data visualization, and DAX functions.
• Business Intelligence: Experience in reporting, analysis, and BI authoring in complex international settings.
• Database Design: Expertise in designing stable, reliable, and effective databases.
• Query Optimization: Proficient in writing complex queries, stored procedures, views, and triggers, with a focus on performance tuning.
• ORM & FastAPI: Experience in developing RESTful APIs using FastAPI and integrating database functionality through ORM frameworks.
• Agile Methodology: Hands-on experience with Agile/Scrum processes.

Project 1, Project: Gharpe, Role: SQL DeveloperMSSQL, Visual Studio, Developed a property listing platform with search filters, interactive maps, and virtual tours., roles and responsibilities, Design database schemas, tables, views, stored procedures, and triggers., Write complex SQL queries for data extraction, manipulation, and reporting., Optimize SQL queries for performance improvement and database efficiency., Debug SQL code and optimize stored procedures and queries for efficiency.

 Project 2, Project: Builderpe, Role: SQL Developer |Tools: MySQL, Visual Studio, worked on a builder listing and property sales platform, roles and responsibilities, assist other departments or teams with database queries, data extraction, and troubleshooting user issues related to data access or performance, schedule and execute routine maintenance tasks such as backups, database integrity checks, and updates to ensure optimal performance and data security.

Project 3, Project: Sales Performance Dashboard, Role: Power BI Developer | Tools: Power BI, CRM, ERP Systems, 

Created optimized DAX formulas to calculate KPIs like YoY Growth, Profit Margin, Customer Retention, and more.

Developed star schema-based data models with relationships and hierarchies.

Integrated Power BI with SQL Server, Excel, and SharePoint Online for live data updates.

Published reports to Power BI Service, configured row-level security (RLS), and scheduled data refreshes.

Collaborated with business analysts and stakeholders to gather requirements and deliver insights.