Software Developer Power Bi

Riya Patel Email Phone LinkedIn

Software Developer *********.**@*******.*** +91-989******* patelriya12 SUMMARY

Results-driven software developer with 3.7 years of experience in designing, developing, and optimizing data-driven solutions. Proficient in Power BI and SQL Server with a strong foundation in data modeling, ETL processes, and dashboard development. Passionate about transforming raw data into actionable insights that drive business decisions.

COMPETENCIES

● Designed interactive dashboards, KPI scorecards, and reports using Power BI Desktop.

● Designed star/snowflake schema models, implemented DAX calculations, and used Power Query for data transformation.

● Expertise in SQL Server and PostgreSQL, including database design, query optimization, and complex stored procedures. Proficient in NoSQL data management with MongoDB.

● Knowledge of Azure Data Factory (ADF) and SQL Server Analysis Services (SSAS) for data modeling and pipeline automation.

● Trained and optimized Machine Learning models using various algorithms to derive actionable insights.

● Knowledge of Sharepoint and Power Platform (Power Apps, Power Automate).

● Currently expanding expertise in Microsoft Fabric and Databricks.

● Collaborated with teams for troubleshooting, debugging, and optimizing solutions.

● Thrive in a team environment and embrace individual work with equal enthusiasm.

● A proactive learner, adapting quickly to new tools and technologies to enhance performance. WORK EXPERIENCE

Volkswagen Group Digital Solutions India – Pune, Maharashtra (Mar 2024 -Present)

● Developed and maintained interactive Power BI reports & dashboards to provide actionable business insights.

● Extracted, transformed, and integrated data from multiple sources, including SQL Server, SharePoint, and Excel, ensuring accuracy and consistency.

● Optimized data models and implemented advanced DAX calculations to enhance performance and analytical capabilities.

● Leveraged Power Query to clean, transform, and shape data for efficient reporting.

● Created comprehensive documentation, including User Manuals, System Architecture Documents (S-AD), and IT Security Assessments, ensuring clarity and compliance.

● Collaborated with international stakeholders, gathering requirements and delivering data-driven solutions tailored to business needs.

● Automated data refresh schedules and ETL processes, improving report efficiency and reducing manual efforts.

● Ensured data security and governance, maintaining compliance with organizational and industry standards.

● Continuously optimized Power BI solutions, improving report performance and user experience. Versatile IT Management – Surat, Gujarat (Jan 2022 - Mar 2024)

● Designed and developed reports and dashboards using Power BI to deliver meaningful insights.

● Designed and developed robust WPF applications using .NET, ensuring a seamless and intuitive user experience.

● Worked with SQL Server and PostgreSQL, optimizing database performance, writing complex queries, and ensuring data integrity.

● Developed and integrated scalable backend services using Node.js with MongoDB, enhancing application efficiency and performance.

● Developed REST APIs, facilitating seamless communication between applications and services.

● Created detailed documentation, including User Manuals and Technical Guides, to support end-users and development teams.

● Optimized queries and database performance, ensuring smooth application functionality and data integrity.

● Ensured clean, maintainable, and efficient code by following industry best practices and design patterns.

● Diagnosed and resolved performance bottlenecks, enhancing system stability and responsiveness. TECHNICAL SKILLS

● BI & Data Analytics: Power BI, DAX, SQL, Google Looker Studio

● Databases: SQL Server, PostgreSQL, MongoDB

● ETL & Data Integration: Power Query, Databricks, Azure Data Factory (ADF), SSAS

● Programming & Development: Python, C#, JavaScript, .NET, HTML, CSS, Node.js

● Automation & Low-Code Platforms: Power Automate, Power Apps (Canvas App) PERSONAL SKILLS

● Resilience

● Adaptability

● Positive Attitude

● Attention to Detail

EDUCATION

BE (COMPUTER) 2018 – 2022

● University: Gujarat Technological University (GTU)

● College: Bhagwan Mahavir College of Engg & Tech, Surat

● CGPA: 8.28

HSC 2018

● Education Board: GSEB

● School: Jay Ambe Vidhyabhavan, Surat

● Percentage: 73.54

SSC 2016

● Education Board: GSEB

● School: Smt Lilaba D V Kanya Vidhyalaya, Surat

● Percentage: 82.5

PERSONAL INFORMATION

Full Name : Riya Patel

Date of Birth : March 12, 2001

Marital Status : Unmarried

Languages known : English, Hindi, Gujarati

Hobbies : Reading books, Playing badminton

Contact this candidate