Home

Varun Kumar Reddy Guntaka - Sr. Power Bi Developer

[email protected]

Location: Texas City, Texas, USA

Relocation:

Visa: green card

Varun Kumar Reddy Guntaka Sr. Power Bi Developer [email protected] | +1 (408) 454-8569 PROFESSIONAL SUMMARY Over 9+ years of comprehensive experience in developing, designing and implementingBusiness Intelligence solutions with a primary focus on Power BI and Microsoft SQL Server technologies. Expert in database design, development, and management using various versions of SQL Server, with strong skills in T-SQL, stored procedures, user-defined functions, views, triggers, and indexes. Proficient in all aspects of Power BI, including Power BI Desktop, Service, and others, for data import, transformation, visualization, and dashboard creation. Extensive experience in data modeling, including dimensional modeling for data warehouses, and working with both relational and multidimensional data structures. Skilled in ETL processes using SQL Server Integration Services (SSIS), Azure Data Factory, and Power Query, ensuring efficient data extraction, transformation, and loading. Proficient in developing interactive reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI, creating a wide range of visualizations such as charts, maps, and custom visuals. Expert in SQL Server Analysis Services (SSAS), including both multidimensional and tabular models, with experience in MDX and DAX for complex calculations and measures. Strong background in data analysis and visualization using various tools including Power BI, Tableau, and Excel (Power Query, Power Pivot). Experienced in performance tuning and optimization of databases, queries, and Power BI reports to ensure efficient data processing and visualization. Proficient in Azure services, including Azure SQL Database and Azure Data Factory, for cloud-based data solutions and migrations. Proficient in developing complex financial models and predictive analytics using Power BI, supporting data-driven decision-making and future financial projections. Skilled in data mining techniques and predictive analytics to derive valuable insights from large datasets. Experience with Crystal Reports for legacy reporting systems and integration with modern BI solutions. Thorough understanding of the Software Development Life Cycle (SDLC) and Agile methodologies, ensuring efficient project management and delivery. Strong skills in requirements gathering, analysis, and documentation, with a proven ability to translate business needs into technical solutions. Expertise in data security and access management within Power BI and SQL Server environments. Proficient in troubleshooting complex issues across the entire BI stack, from data sources to final visualizations. Experience in OLAP technologies and designing effective star and snowflake schemas for optimal data analysis. Skilled in creating and maintaining data dictionaries and metadata repositories to ensure data consistency and understanding across the organization. Strong collaboration skills, working effectively with cross-functional teams including business analysts, data engineers, and end-users to deliver comprehensive BI solutions. Experienced in providing training and support to end-users on Power BI and related BI tools, promoting data-driven decision making across the organization. Expertise in utilizing Visual Studio for efficient code management and version control of BI projects, ensuring seamless collaboration and code integrity. Skilled in developing custom DAX measures and calculated columns to meet complex business requirements and KPIs. Knowledgeable in data governance practices and implementing data quality measures throughout the BI pipeline. Proven track record of successfully migrating legacy reporting systems to modern Power BI solutions, ensuring seamless transitions and improved analytics capabilities. Experienced in setting up and managing Power BI gateways, workspaces, and apps for efficient report distribution and data refresh processes. Skilled in generating a wide array of report types using SSRS and Crystal Reports, including parameterized, drill-down, and cross-tab reports, catering to various business requirements. TECHNICAL SKILLS: BI & Reporting Tools Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Power Query, Power Pivot, Power View, Tableau Desktop, Tableau Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Crystal Reports, Business Objects Databases Microsoft SQL Server (2000-2019), SQL Azure, Oracle (9i/10g/11g), MySQL, MS Access, Snowflake, Azure SQL DB ETL & Data Integration SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Azure Data Factory, Informatica Programming & Scripting Languages T-SQL, PL/SQL, MDX, DAX, Python, C#, VBScript, JavaScript Web & Cloud Technologies HTML, XML, ASP.NET, Microsoft Azure Data Modeling Star Schema, Snowflake Schema, Kimball & Inmon Methodologies, Erwin, Microsoft Visio, UML Big Data Hadoop Ecosystem (HDFS, Hive) Version Control & Project Management GitHub, JIRA, MS Project, Visual Studio Operating Systems Windows (7/8/10, Server 2012/2016/2018 R2), UNIX, Linux Other Tools & Software MS Office Suite (Excel, PowerPoint, Word), SQL Server Management Studio (SSMS), TOAD, Oracle SQL Developer, Enterprise Manager, Query Analyzer, BI Development Studio, SQL Profiler, Import & Export Wizard, FTP, Control-M, Teradata Viewpoint, Teradata SQL Assistant, Rally, JSON PROFESSIONAL EXPERIENCE: Sr. Power BI Developer Mar 2022 Present Optum, Raleigh, NC Responsibilities: Developed and maintained Power BI dashboards and reports, improving data visibility and decision-making processes for healthcare analytics. Designed and implemented ETL processes using SSIS, reducing data processing time by 30% and improving data accuracy to 99.8%. Created SSAS cubes and developed MDX queries for complex healthcare data analysis, supporting Optum's mission to improve healthcare delivery and reduce costs. Utilized Power BI, Power Pivot, and Power Query to develop data analysis prototypes, resulting in a 25% increase in user adoption of BI tools across departments. Implemented DAX functions for intricate calculations in Power BI, enhancing the depth of insights in claims processing and patient care analytics. Collaborated with cross-functional teams to design end-to-end data solutions, aligning with Optum's goal of integrating technology and healthcare expertise. Optimized database performance by creating indexes and tuning queries, improving report generation speed by 45%. Developed and maintained SSRS reports for in-depth analysis of healthcare trends and outcomes, supporting Optum's data-driven approach to population health management. Implemented Power BI Gateway configurations to ensure real-time data updates, critical for monitoring healthcare metrics and KPIs. Created custom visualizations in Power BI, including combination charts and gauges, to effectively display complex healthcare data relationships. Utilized Azure Data Factory to integrate on-premises and cloud data sources, streamlining data pipelines for Optum's diverse healthcare datasets. Implemented row-level security in Power BI reports to ensure HIPAA compliance and protect sensitive patient information. Developed automated data quality checks using T-SQL and Power BI, reducing manual data validation efforts by 60%. Conducted training sessions for end-users on Power BI report creation and data interpretation, increasing self-service BI capabilities by 35% across the organization. Developed and maintained a library of reusable DAX measures and calculated columns, standardizing KPI definitions across the organization and significantly reducing inconsistencies in reporting. Collaborated with data scientists to incorporate predictive analytics models into Power BI dashboards, enhancing Optum's capabilities in preventive care and risk assessment. Led the migration of legacy reporting systems to Power BI, resulting in a reduction in report generation time and an increase in user satisfaction. Implemented automated data refresh and distribution processes using Power BI Dataflows and Gateways, ensuring 99.9% data availability. Developed a custom Power BI theme, ensuring consistency across all reports and dashboards while reducing design time by 20%. Environment: MS SQL Server 2016/2019, SSIS, SSAS, SSRS, Power BI Desktop, Power BI Service, DAX, MDX, T-SQL, Azure Data Factory, Azure SQL Database, Visual Studio 2022, Git, JIRA, Windows Server 2019 Sr. Power BI Developer Jan 2021 Feb 2022 Truist Bank, Atlanta, GA Responsibilities: Designed and developed data models using Power BI Desktop, creating relationships and hierarchies for efficient data analysis. Developed custom visualizations using Power KPI, Chiclet Slicer, and Spline Chart to enhance data insights. Created and optimized DAX expressions for calculated columns, measures, and advanced data analysis. Utilized Power Query for data cleansing and transformation, ensuring data integrity and consistency. Implemented dimensional data modeling and cube development using SQL Server Analysis Services (SSAS) to support business intelligence initiatives. Developed and implemented ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into Power BI. Integrated Power BI with Azure Data Factory, Data Lake, and Azure Synapse for comprehensive data analysis. Published Power BI reports and dashboards to Power BI Service, ensuring data accessibility and interactivity for end-users. Configured an on-premises Power BI Data Gateway to refresh datasets, maintaining up-to-date information in reports and dashboards. Conducted rigorous testing of Power BI reports and dashboards using SQL Profiler to ensure accuracy, performance, and adherence to business requirements. Performed data validation using complex T-SQL queries to ensure test results matched expected outcomes. Configured and deployed Power BI reports and dashboards, integrating with both on-premises and cloud-based systems. Employed Microsoft DevOps for version control, automated build and release processes, and project task management. Provided ongoing support and maintenance for Power BI solutions, addressing issues and implementing enhancements. Optimized data storage performance in Azure Storage using caching, compression, and tuning techniques. Implemented robust security measures in Power BI, Azure, and Cognos to ensure data privacy and regulatory compliance. Ensured data security and compliance in Databricks when handling sensitive data, implementing monitoring solutions for performance optimization. Prepared comprehensive documentation for Power BI solutions, including design specifications, user manuals, and training materials. Environment: Power BI, DAX, Power Query, SQL Server 2016/2018, Microsoft Azure, SSIS, ADF, Azure Synapse, Power BI Service, SQL Profiler, SSRS, SSAS, Microsoft DevOps, Tableau, Visual Studio 2017/2015, TFS (2015), Alteryx, BI Publisher, Databricks, Cognos. Power BI Developer Jan 2018 Dec 2020 Amex, Phoenix, AZ Responsibilities: Designed, developed, and tested solutions for business requirements, achieving desired business results through data presentation and analytics using Power BI. Created reports using Power BI Desktop and Power BI Service, utilizing connectors and content packs for seamless data integration. Imported data from various sources including SQL Server, Excel, and cloud-based databases, ensuring comprehensive data analysis. Developed custom visualizations using Power KPI, Chiclet Slicer, and Spline Chart to enhance data insights. Utilized Power Query for data cleansing and transformation, adding calculated columns, managing relationships, and creating measures. Created advanced analytics dashboards depicting critical KPIs, incorporating slicers, drill-downs, and drill-through features for enhanced user interactivity. Employed DAX expressions to create new measures and calculations as per business requirements. Configured and implemented data intake using Power Query and its formula language, 'M'. Developed ETL processes using SQL Server Integration Services (SSIS) to migrate data from multiple sources, ensuring data consistency and integrity. Integrated SSAS cubes and tabular models with Power BI for complex data analysis and visualization. Conducted performance tuning and optimization of T-SQL queries for reports, ensuring efficient data retrieval and processing. Performed data validation using complex T-SQL queries and tools like SQL Profiler to ensure data accuracy. Configured and deployed Power BI reports and dashboards, managing data sources and ensuring seamless data integration. Managed data models and schemas in Amazon Redshift, optimizing data refresh and model performance. Applied role-based security in SSAS and maintained backup copies for changes affecting dashboards in daily ETL loads. Environment: Power BI, DAX, Power Query, SQL Server 2016/2018, Microsoft Azure, SSIS, ADF, Azure Synapse, Power BI Service, SQL Profiler, SSRS, SSAS, Microsoft DevOps, Tableau, Visual Studio 2017/2015, TFS (2015), Alteryx, BI Publisher, Databricks, Cognos. Power BI Developer Jun 2015 Nov 2017 TCS, Hyderabad, India Responsibilities: Designed and developed various database objects such as functions, tables, views, triggers, indexes, and constraints to support application needs. Created and optimized complex T-SQL queries, stored procedures, and user-defined functions for implementing business logic. Configured SSIS packages to dynamically execute on Quality Analysis and Production servers. Designed STAR and SNOWFLAKE schemas for data warehousing solutions, optimizing query retrieval times. Utilized Informatica and Talend for comprehensive data integration and transformation. Conducted System Integration Testing (SIT) and User Acceptance Testing (UAT), performed bug fixing, and documented processes. Optimized database queries by analyzing execution plans and creating clustered and non-clustered indexes. Managed and deployed Power BI reports and dashboards, ensuring seamless data integration and visualization. Provided ongoing maintenance and support for Power BI and SSIS solutions, addressing issues and implementing enhancements. Ensured data quality and integrity within ETL processes through data cleansing, validation, and enrichment techniques. Implemented database tuning and troubleshooting, optimizing performance and ensuring data reliability. Environment: MS SQL Server 2016/2014/2012, SSIS, SSRS, SSAS, T-SQL, Power BI Desktop, Power BI Service, Informatica, Talend, Tableau, Oracle 11g, Visual Studio, SQL Profiler, MS Excel, Windows Server 2012, Windows 8. EDUCATION Bachelors of Technology in Information Technology | JNTU Hyderabad 2011- 2015 Keywords: csharp business intelligence database microsoft procedural language Arizona Georgia North Carolina