Home

Thilak - Power Bi Developer

[email protected]

Location: Duluth, Georgia, USA

Relocation: Open

Visa: H1B

THILAK ADDAGATLA [email protected] | (413)472-9244 | https://www.linkedin.com/in/t-addagatla/ EXPERTISE SUMMMARY Highly motivated BI Developer with extensive IT experience having multiple skill set and extensive working experience in data warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI, Tableau, Qlik for building, deploying, managing applications and services through a global network of Microsoft - managed Data Centers. Experienced in developing Power BI reports and dashboards from multiple data sources using data blending. Experience in writing complex SQL Queries using stored procedure, common table expressions (CTEs) temporary table to support Power BI reports utilizing the desktop and the online service and schedule refresh. Experience in understanding of Microsoft development suite SSIS and SSAS, as well as familiarity with standard data extract, cleansing, integration, and aggregation techniques and best practices. Assist end users with problems installing the Power BI Desktop, installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users. Responsible for building reports in Power BI from the Scratch and responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests. Installation and configuration of all the suites of Power BI products, setting up the Power BI environment to Client locations by Installing and configuring. Expert in Understanding the Technical Specification and creating and modifying the SSIS packages according to the Business requirements. Experienced working with Database Architecture for Design and Development of Data models and Data warehouse. Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities. Hands on experience in designing and deploying rich graphic visualizations with Drill Down and Drop-down menu option and Parameterized dashboards using Power BI. Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters. Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, Information, Text and Date functions, Table Functions and Time Intelligence Functions. Created custom KPI scorecards to help end users visualize metrics according to their preference. Extensively used RDBMS like Oracle and SQL Server for developing different applications. Good Knowledge of Normalization, Performance Tuning, Development Life Cycle source control and ticketing systems and Version Control tools while Design and Development of Data warehouse. Data modeling using Composite models in Power BI, retrieved data from REST Elastic search and SQL server. Implemented Row level security to restrict data access for required users. Effective communication skills and proven ability to perform both as an individual and as a team player. CERTIFICATIONS Microsoft Certified Power BI Data Analyst Associate PL300 PROFESSIONAL EXPERIENCE State Street Dec 2024-Present Power BI Developer Led transformative Power BI initiatives for Lowe s, employing canvas and model-driven approaches to enhance data visualization. Leveraged diverse visual elements like slicers, pie charts, and heat maps, resulting in a 65% improvement in insight comprehensiveness. Applied Star Schema and Snowflake Schema to structure data for accurate reporting. Developed and optimized complex DAX functions in Power BI and Power Pivot, elevating data analysis capabilities and reducing processing time by 50%. Utilized SQL queries and schema designs to improve data retrieval efficiency. Automated Power Query refresh processes with PowerShell scripts and Windows Task Scheduler, achieving a 55% increase in efficiency and streamlining data refresh cycles. Applied ETL frameworks to enhance data flow and transformation. Engineered data flows for ad hoc reporting and exploratory analysis, integrating data from SQL Server, SAP BW, Oracle, and Azure SQL. Enhanced data integration speed by 40% using advanced ETL techniques and data warehousing principles, including Star Schema and Snowflake Schema. Configured Enterprise and Personal Gateways in Power BI Service, reducing data transfer latency by 15% and ensuring secure data connectivity. Implemented data privacy compliance measures, including encryption and RBAC. Developed custom Power BI visualizations using Power BI SDK and advanced charting libraries, including R integration. Improved visualization comprehensiveness by 35% and utilized data storytelling techniques to enhance user insights. Established dynamic data connections between Power BI reports and Power Apps applications, leveraging Power BI Embedded and Azure SQL Database for real-time analytics. Enhanced decision-making agility through interactive data insights. Developed and integrated custom APIs within Power Apps and Power BI using Azure Functions and API Gateway, enabling seamless integration with Dynamics 365 and other CRM/ERP systems. Expanded connectivity options and streamlined data exchange. Leveraged Azure integration services (e.g., Azure Data Factory, Azure Logic Apps) to automate data pipelines between Power BI and Power Apps, achieving a 70% increase in data processing efficiency. Implemented Azure Synapse Analytics for enhanced data processing. Utilized SSIS and T-SQL stored procedures for efficient data transfer between OLAP and OLTP databases. Employed query performance tuning techniques and applied Star Schema and Snowflake Schema to improve data organization and reporting accuracy. Implemented rigorous data governance and security protocols across Power BI and Power Apps solutions, including RBAC, data encryption, and compliance with data privacy regulations. Managed SQL Server Reporting Services (SSRS) for comprehensive reporting. Danske Bank Sep 2022 Nov 2024 BI/SharePoint Developer Designed and optimized interactive dashboards and automated report generation using Power BI, reducing production time and improving efficiency Developed and optimized data models in Power Query, ensuring seamless data integration and transformation Migrated SSRS reports to Power BI, ensuring data source compatibility and maintaining report accuracy Created diverse visualizations including Pie Charts, Donut Charts, Gauge, Stacked Bar Charts, Decomposition Tree, Scatter Plots, Waterfall Charts, and custom marketplace visuals Extracted and transformed data from DB2 (OLTP), Access, and Mainframe files, utilizing staging environments to enhance Data Warehouse performance Optimized Power BI performance using Performance Analyzer and conducted SQL Server tuning with SQL Profiler Developed custom workflows using Microsoft Power Automate, streamlining processes and improving automation Designed and developed Power BI dashboards and reports for clients, ensuring data-driven decision-making Implemented complex SSIS transformations using Lookup, Pivot, Merge Join, Union All, Derived Column, Conditional Split, and Aggregate Published and managed Power BI reports in shared workspaces and optimized data mashups using Power Query M Language Developed and scheduled incremental and historical data loads using SQL Agent, ensuring accurate and efficient data updates Validated DIM and FACT data using Data Profiling Tasks, ensuring accurate data population Created advanced DAX functions including CALCULATE, ALL, and FILTER to enhance analytical capabilities Configured Workspaces, Apps, and managed deployment processes for seamless report accessibility Implemented Row-Level Security (RLS) and Dynamic RLS, ensuring data access control and security compliance Optimized Power On technology, reducing system boot times by 15%, improving overall performance and reliability Collaborated with DBAs to identify and resolve system bottlenecks, enhancing operational efficiency Avaya Techonologies Jun-2019-Aug 2022 Business Intelligence / Data Analyst Collaborated with business teams to identify critical business problems and translated business needs into quantitative analyses Developed complex SQL queries in SnowSight, optimizing data retrieval and transformation Extracted and integrated data from Teradata, SAP HANA, SQL Server, and SSAS into Power BI, ensuring seamless reporting Designed and developed operational reports in Power BI Desktop, implementing calculated measures and DAX expressions for enhanced insights Participated in Agile development, attending daily scrums, sprint meetings, and backlog prioritization to align deliverables with business goals Integrated Power Apps visuals into Power BI dashboards, enhancing interactivity and user experience Created Paginated Reports using Power BI Report Builder, ensuring detailed, print-friendly reporting solutions Developed Power Automate flows to automate Power BI reports, improving efficiency and reducing manual effort Designed and deployed SSRS, Excel Services, and Power BI reports on SharePoint Server, ensuring centralized report accessibility Implemented advanced DAX functions for efficient fact calculations and optimized data visualization in Power BI Utilized Power BI Gateway to keep dashboards and reports up to date with on-premises data sources Extracted and transformed data from Teradata, Oracle, and CSV files into SQL Server using SSIS Packages Developed and optimized SSIS packages, leveraging Control Flow and Data Flow components for seamless ETL processing Designed and created over 20 OLAP Cubes, enhancing data modeling and analytical capabilities Developed SSRS reports based on OLAP cubes and SQL Server tables, ensuring detailed reporting solutions Built and optimized OLAP cubes using SQL Server Analysis Services (SSAS) to improve query performance and reporting efficiency Designed and developed SSRS reports using SSAS Cubes and Data Marts, ensuring robust analytical reporting Created and modified SSRS reports, leveraging SSAS Tabular Model as the primary data source Developed parameterized, drill-through, and cascading reports in SSRS, improving report customization and interactivity Collaborated with testing teams to analyze and resolve defects, ensuring data integrity and report accuracy Environment: Power BI, Snowflake, SAP Hana, Teradata, MS SQL Server, SSAS, SSRS, SSIS, Power Pivot, Power Query, Visual Studio. Education University of Massachusetts Amherst MS in Business Analytics Keywords: business intelligence active directory rlang information technology business works microsoft