Keerthi

Professional Experience

·        Around5 years of experience as a Sr. SQL/Business Intelligence/Power BI Developer and Data Analyst.

·        Strong Experience and knowledge of BI Tools like Power BI, Tableau, OBIEE, Excel, and SQL servers.

·        Working experience in Power Query, Power Pivot, and Power View for creating effective reports and dashboards in Power BI.

·        Extracting the data from various data sources into the Power BI desktop and transforming the data in Power Query Editor to generate Reports and Dashboards.

·        Utilized Power Query in Power BI to Pivot and Un-Pivot the Data Model for Data Cleansing and Data messaging.

·        Involved in creating Data visualizations like Clustered Column charts, Bar charts, Donut charts, Line charts, Scatter plots, Treemaps, slicers, Gauge Visualization, etc. with Power BI.

·        Developed and maintained complex SQL queries, stored procedures, and triggers to support business applications and reporting needs.

·        Designed and implemented efficient database structures, optimizing data storage and retrieval performance.

·        Created calculated columns and measures with the use of DAX Expressions like Aggregate, Time,and Date Functions. Writing DAX, and Power Query formulas, and creating KPIs based on client requirements. 

·        Developed Power BI Reports, Custom Visuals, Group Creation, and Effective Dashboards after gathering and translating End-User Requirements.

·        Hands-on experience in designing and developing cloud solutions based on Microsoft Power Platform using Power Apps, Power Automate, Power BI, Power Apps Portal, and Common Data Service (CDS).

·        Experience in data analysis, design, and development of databases for business applications in client/server and data warehouse environments in PL/SQL.

·        Developed Microsoft Power BI reports, numerous Trend dashboards, Audit reports, and Monitoring reports which helped in deriving the best business insights and also worked with the Data Architect on the expected data.

·        Implemented necessary data cleansing, mapping, and transformation tasks to align with Power BI data models and best practices.

·        Worked extensively with Power BI tools and migration of cubes, canned reports, etc.

·        Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution center solutions design analytics in Power BI.

·        Expertise in Publishing Power BI Reports of Dashboards in the Power BI Server and Scheduling the dataset to refresh for live data in the Power BI Server. Expertise in Visualizing and Analyzing Data using Power BI with cloud-based applications.

·        Worked with both Direct query and Import data into Power BI for creating Reports.

·        Deploying and Scheduling Reports using Power BI to generate all Daily, Weekly, Monthly, and Quarterly Reports including current status.