Power Bi Developer

NM

NAVITHA MEDISHETTY

Power BI Developer

995******* *******.****.**********@*****.***

Summary

I am an MS SQL Server and MSBI Developer with over 4 years of experience in the IT industry. My expertise spans data massaging, cleansing, and scrubbing using SSIS transformations. I have developed reports using SSRS, while also possessing strong skills in T-SQL for complex stored procedures. I focus on performance monitoring and maintaining data integrity through validation checks Experience

Valuefy

Power BI Developer 06/2023 - 09/2024

Valuefy is a fintech company that provides wealth management and investment technology solutions Collect and clean raw data from various sources (SQL databases, Excel, APIs, cloud services) Transform data using Power Query (M language) and DAX (Data Analysis Expressions) Create data models, define relationships, and optimize them for performance Develop interactive and visually appealing dashboards and reports in Power BI Implement drill-throughs, filters, slicers, and other Power BI features for enhanced user experience Ensure reports are responsive and perform efficiently across devices Write complex DAX calculations for business KPIs, aggregations, and performance metrics Optimize DAX queries for better performance

Implement row-level security (RLS) to restrict data access based on user roles Manage user permissions and ensure compliance with data governance policies HCL Enterprise

Power BI Developer 07/2022 - 04/2023

Development of a Data Warehouse for different Data Marts such as Accounts, Loans, Credit Cards, Insurance, Arrangement, Condition, Event, and Application

Created Packages on SSIS using different data transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort, and Execute SQL Task to load data into the database

Implemented error handling, created checkpoints, configuration files, and log files in the packages Deployed, scheduled, and monitored SSIS Packages

Scheduled jobs to execute SSIS packages and developed parameterized reports including multi-parameters Designed and deployed reports for end-user requests using a web interface Created variables, filters, and bookmarks in ad-hoc reports Involved in backup/restore, replication, and query optimization Virtusa

SQL & SSIS, SSRS Developer 12/2020 - 04/2022

Project developed using SSRS and SQL Server 2008 with ETL process for historical data (last 13 months) storage and refresh Development of reports in SSRS, SSIS with business user approvals Managed database, jobs, and performance tuning

Performed extensive data extraction and preparation using SSIS Wrote stored procedures and SQL scripts in SQL Server and Oracle to implement business rules Designed T-SQL scripts to identify long-running queries and blocking sessions Wrote and debugged T-SQL, stored procedures, views, and user-defined functions Conducted data migration from Text to SQL Server through SSIS Implemented error handling using Try-Catch blocks

Normalized and de-normalized tables, used Joins and CTEs, established relationships using Primary Key & Foreign Key constraints Evaluated database performance and performed maintenance such as tuning, backup, restoration, and disaster recovery Created database objects like tables, views, indexes, stored procedures, triggers, and user-defined functions www.enhancv.com Powered by

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

Education

JNTU 01/2007 - 01/2010

Master of Computer Application

Skills

DAX ETL IAM Microsoft Power BI Your Skill Microsoft SQL Server MSBI Power Query RDBMS SASS SQL SSAS SSIS SSRS T-SQL TypeScript SQL Server Management Studio SQL Profiler Gmail www.enhancv.com Powered by

Contact this candidate