Bhavika Rao Padidala
Power Bi Engineer @LTIMindtree
Signup · Get unlimited contacts
WORK HISTORY
Power Bi Engineer @LTIMindtree
Redmond, WA, US
Extensive experience in analyzing business requirements and creating software requirement specifications, developing custom KPIs, dashboards, reports, and managing Power BI Administration.• Utilized ETL features and implemented advanced data modelling techniques by using Power BI, Excel. SSIS. ADF, and ADLS to create data models which are efficient, scalable, and consistent.• Developed complex formulas and data transformations using DAX and Power Query, ensuring data consistency.• Conducted data analysis and presented insights to stakeholders, helping them to make informed decisions based on the report.• Managed On-Premises Data Gateways to setup connections between cloud services and On-Premises Data Sources and ensured proper failover mechanism and load balancing.• Automated manual activities to minimize execution effort and increase productivity using tools like PowerApps, Power Automate and Microsoft Flow.• Successfully assisted strategic customers in implementing BI solutions that met their specific business needs and provided technical support to overcome any challenges in cross-platform collaboration.• Partnered with the escalation and leadership teams to establish and track learning programs, ensuring continuous skill development and product knowledge for the team.
EDUCATION
Northwest Missouri State University
Master's degree
IT Jobs updates for tomorrow
Bachelor of Technology - BTech
ABOUT BHAVIKA RAO PADIDALA
I have 6 years of experience as a BI Developer.Role:My role in the project includes gathering requirements, analyzing data, writing T-SQL queries, developing various reports using SSRS and Power BI, loading and transforming data into database using SSIS, automating routines and also involved in tuning query performance. Responsibilities: Extensively worked with SQL Server Integration Services (SSIS) tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column. Designed SSIS Packages to extract data from various OLTP sources to MS SQL Server. Designed and Published Power BI Visualizations and Dashboards to various Business Teams for Business use and Decision making. Used DAX Queries to create calculated Measures and Calculated Columns. Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse. Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS. Used SQL Server Profiler to trace the slow running queries and the server activity. Improved the performance of SSRS reports by tuning the Stored Procedures and T-SQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS). Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.