Power Bi Sql Server
Resume:
Gopi Chand
Sr.Power BI Developer
***************@*****.***
PROFESSIONAL SUMMARY
Strong knowledge in Power BI using SQL Server 2012/2014/2018/2020 for developing robust and insightful reports and dashboards with almost 6+ years of experience.
Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, and Maintenance of Power BI Applications.
Extensive experience in synthesizing business requirements and data models to identify and develop Key Performance Indicators (KPIs) critical for business success.
Strong knowledge in designing and creating dimension and cubes with Snowflake and STAR schema using SQL Server Analysis Services (SSAS).
Implemented complex query techniques, including passing Multi-Valued parameters and cascading parameters in MDX for advanced reporting needs.
Skilled in creating measures, calculated columns, and performing time-series analysis using DAX expressions within Power BI.
Created parameter-based reports, graphical reports, Excel reports, and drill-down charts using SQL Server Reporting Services (SSRS). Generated on-demand and scheduled reports for business analysis.
Responsible for creating Power BI reports and deploying them to Power BI Service for enterprise-wide use.
Created dynamic dashboards and shared them with user groups through Power BI Apps, ensuring access to real-time data insights.
Performed time-series analysis using DAX expressions in Power BI to reveal business trends and performance over time.
Used Power BI to create self-service BI capabilities, including tabular models, enabling business users to explore data independently.
Built and modified visualizations in Power BI reports and dashboards according to client requests, ensuring tailored solutions.
Published Power BI reports and dashboards to Power BI Server for centralized management and distribution of business intelligence.
Created hierarchies in Power BI reports using visualizations such as Bar Charts, Line Charts, and more, providing drill-down capabilities.
Worked with both live and imported data sources within Power BI to create efficient and interactive reports.
Managed relationships between tables in Power BI using star schema for optimal data structuring and performance.
Utilized different types of slicers available in Power BI for enhanced user interaction and report customization.
Performed data transformations such as Pivoting, Unpivoting, and Splitting of columns using Power Query to prepare data for analysis.
Configured on-premises Power BI gateways to refresh datasets and ensure up-to-date reporting and dashboarding.
Developed and maintained SSIS packages for integrating various data sources like MySQL, Oracle, SQL Server, and Teradata into Power BI.
Designed ETL processes to link data from different sources, allowing insights into trends and relationships for driving marketing strategies and risk management.
Hands-on experience with version control tools like Git and project management platforms like JIRA for efficient team collaboration and workflow management.
Responsible for checking the cross-browser compatibility of HTML files and ensuring responsive design across major browsers like Google Chrome, Firefox, and Internet Explorer.
Knowledgeable in the full software development lifecycle, including Agile methodologies like Scrum, code reviews, and source control management.
Expert in creating Test Plans, Test Cases, Test Scenarios, Test Strategies, and Defect Management to ensure the highest quality in Power BI and related applications.
TECHNICAL SKILLS
Methodologies
Agile, Waterfall, Scrum, Kanban
Databases
DB2, MS SQL Server (2008/2008 R2/2012, 2016, 2019, 2020), Azure SQL, Amazon Redshift, Oracle, MySQL, Teradata, Snowflake
Tools
Microsoft BI (SSRS, SSIS, SSAS), Power BI Services, Power BI Desktop, Power Automate, Azure Data Factory (ADF), MS Office, Power Query, SharePoint, Jira, Git, Jenkins, Tableau, Control-M
Cloud Platforms
Azure, AWS, Google Cloud Platform (GCP)
Languages
SQL, MDX, DAX, Python, Shell Scripting, Bash
Data Integration
SSIS, Azure Data Factory (ADF), NiFi, MuleSoft
Reporting & Analytics
Power BI, SSRS, Tableau, Power BI Report Server, SQL Server Reporting Services, SSAS
Version Control
Git, GitHub, Bitbucket
Project Management
Jira, Confluence, Azure DevOps
Automation & DevOps
Jenkins, Terraform, Docker
Testing & QASelenium, TestNG, NUnit, xUnit, JUnit, Tesseract, OCRopus, Quality Assurance, Manual and Automation Testing
WORK EXPERIENCE
HCA Healthcare, Nashville, TN Jan 2024 to present
Sr.Power BI Developer
Responsibilities:
Developed an annual financial report for Novo Nordisk, integrating data from multiple sources and utilizing advanced DAX functions to provide actionable insights.
Created a sales performance dashboard that tracked key metrics across various time intervals, facilitating strategic decision-making.
Designed a series of reports to analyze operational efficiency, including job performance tracking and performance optimization.
Worked on complex DAX functions in Power BI (Desktop version 2.68) and Power Pivot to deliver advanced data analysis and insights.
Automated Power Query refresh using PowerShell scripts and Windows Task Scheduler, improving data refresh efficiency.
Integrated data from various sources including SQL Server, SAP BW, Oracle, SQL Azure, etc., into Power BI for comprehensive reporting.
Installed and configured Enterprise Gateway and Personal Gateway in Power BI Service to facilitate secure data access.
Collaborated with Epic analysts and data architects to understand table relationships, ETL logic, and metadata definitions in Clarity/Caboodle; ensured alignment between reporting logic and clinical workflows.
Created and managed Workspace and Content Packs in Power BI Service for business users, ensuring seamless access to developed reports
Scheduled automatic and managed scheduled refreshes in Power BI Service to keep reports up-to-date.
Developed calculated columns and measures in Power BI Desktop to enhance data analysis capabilities.
Delivered weekly presentations to business users, showcasing report updates and addressing feedback to align with business needs.
Extracted and transformed Epic Clarity and Caboodle data into enterprise data warehouses using SSIS, SQL, and Power BI Dataflows, enabling automated and near real-time analytics.
Delivered robust clinical dashboards using Epic Radar, integrating SlicerDicer outputs to empower physicians and care managers with self-service analytics tools.
Collaborated with Epic-certified analysts and SMEs to design and validate custom reports via Reporting Workbench, adhering to security and compliance standards.
Utilized Cogito SQL to develop custom queries supporting executive dashboards related to patient flow, no-show rates, and provider productivity.
Designed and developed reports for various intervals including yearly, quarterly, monthly, and daily, tailored to client requirements.
Applied a wide range of transformations in Power BI Query Editor to prepare data for reporting.
Created stored procedures and SQL queries to pull data into Power Pivot models, optimizing data retrieval and processing.
Actively participated in project planning sessions with project managers, business analysts, and team members to analyze requirements and propose solutions.
Conducted database creation (DDL, DML, DCL), tuning, SQL optimization, and performance planning to ensure efficient data handling.
Utilized joins and sub-queries to simplify complex queries involving multiple tables.
Developed tabular queries for efficient report analysis using Pivot/Unpivot in T-SQL.
Transformed complex business logic into database design using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting, and Jobs.
Designed and created data extracts to support SSRS, Power BI, Tableau, and other visualization tools.
Implemented data blending techniques in Tableau to merge different datasets for comprehensive analysis.
Created metadata catalogs and lineage diagrams to document Epic data integration pipelines, ensuring traceability and regulatory alignment.
Participated in Epic release upgrade reviews, testing Cogito-based artifacts for compatibility and performance post-upgrade.
Developed Excel PowerView, PowerQuery, and PowerPivot dashboards for detailed data analysis.
Created proprietary analytical tools and reports using Excel, Power Pivot, and PowerPoint, tailored for confidential business insights.
Conducted index analysis and used Clustered and Non-Clustered Indexes for significant performance improvements.
Filtered bad data using Derived Column, Lookups, Fuzzy Lookups, and Conditional Split techniques.
Designed and implemented SSIS packages for data import and transformation, utilizing transformations like Data Conversion, File System Task, and Row Counts.
Debugged and optimized SSIS packages for improved performance.
Configured and maintained SSRS using Report Manager and Report Server; deployed and scheduled reports for regular updates.
Created diverse report types including charts, gauges, tables, matrices, parameterized reports, dashboards, linked reports, and sub-reports by year, quarter, month, and week.
Developed drill-down and drill-through reports by region for in-depth analysis.
Environment: Power BI, SQL Server, SSMS, SSIS, SSRS, SSAS, T-SQL, Windows 10, MS Office, SharePoint, Jira, SQL Profiler.
Vanguard Mar 2021 to Dec 2023
Power BI Developer
Responsibilities:
Created a comprehensive Power BI model for financial reporting, including P&L and headcount metrics, to support data-driven decision-making.
Designed and documented the architecture and governance framework for Power BI, ensuring best practices for data management and security.
Installed and configured Enterprise and Personal gateways in Power BI Service for continuous data connectivity with on-premises databases.
Utilized Data Analysis Expressions (DAX) to write complex calculated columns and measures, optimizing report accuracy and performance.
Developed a range of reports including yearly, quarterly, monthly, and daily reports, with a focus on actionable insights and data visualization.
Applied various transformations in Power BI Query Editor using M Language (Power Query) to prepare data for analysis.
Developed dashboards using Epic EHR data for operational KPIs, MyChart adoption, appointment no-shows, discharge instructions, and readmission rates.
Partnered with data governance teams to ensure proper handling of Epic patient-level data, supporting risk stratification and quality improvement initiatives.
Aggregated Epic data across care settings to build hospital census, length-of-stay, and bed utilization dashboards for clinical operations.
Integrated claims and Epic encounter data to build patient journey reports, assisting in care coordination strategies and value-based care initiatives.
Participated in project planning sessions to gather and analyze business requirements, and developed solutions accordingly.
Used advanced SQL techniques, including joins and sub-queries, to simplify complex queries and improve data retrieval efficiency.
Transformed complex business logic into database design, maintaining it through SQL Server objects like Stored Procedures, User-Defined Functions, Views, and T-SQL scripting.
Integrated multiple reporting tools including SSRS (RDL) and Power BI (PBIX) into a unified Power BI Premium workspace.
Designed and created data extracts to support reporting applications in SSRS, Power BI, and other visualization tools.
Implemented Incremental Refresh in Power BI to efficiently handle large data loads and ensure timely updates.
Used Performance Analyzer and DAX Studio to optimize Power BI reports for faster performance and better user experience.
Created data blends to merge datasets using Power BI Data Flows for comprehensive analysis.
Developed proprietary analytical tools and reports in Excel and PowerPoint to meet confidential business needs.
Created diverse reports and dashboards using charts, gauges, tables, matrices, and geographical maps.
Designed parameterized reports and dashboards with filtering options by year, quarter, month, and week.
Developed drill-down and drill-through reports using Power BI’s Drill through filters and bookmarks for in-depth analysis.
Employed various DAX functions including SUM, SUMX, CALCULATE, ALLEXCEPT, MAXX, RANKX, MTD, YTD, etc.
Utilized Power Automate Flows to trigger actions in Power BI upon dataset updates.
Set up alerts and subscriptions for Power BI dashboards to monitor key metrics and notify stakeholders.
Implemented STAR and SNOW-Flake schemas in Power BI’s relationship designer to structure data efficiently.
Environment: Power BI, SQL Server, SSMS, SSIS, SSRS, SSAS, T-SQL, MS Word, MS Excel, Share Point, Jira, SQL Profiler.
Molina Healthcare, Albany, NY Dec 2019 to Mar 2021
Power BI Developer
Responsibilities:
Collaborated with cross-functional teams to identify and address business challenges.
Gathered and analyzed client requirements to develop comprehensive database solutions, encompassing architecture, design, testing, development, deployment, documentation, and implementation.
Imported data from various sources to create and manage Power BI reports and dashboards.
Developed interactive reports, charts, and dashboards using Power BI Desktop, and managed security settings according to project requirements.
Utilized Power Query to transform, define, and navigate data, performing merge and append queries.
Implemented advanced query techniques, including multi-valued and cascading parameters in MDX.
Managed different contexts such as row context, filter context, and query context within Power BI Desktop.
Performed data transformations like pivoting, unpivoting, and column splitting using Power Query.
Applied query folding to filter data at the source server.
Created diverse chart types and drill-down reports in Power BI Desktop (SSRS).
Designed report layouts in SSRS.
Developed complex SSAS cubes with multiple fact measure groups and dimension hierarchies in SQL Server.
Created measures, calculated columns, and relationships, and conducted time series analysis using DAX in Power BI.
Published reports and visualizations to Power BI Service and created comprehensive dashboards.
Built hierarchies in Power BI reports using various visualizations such as bar and line charts.
Managed both live and imported data for report generation in Power BI.
Handled large data volumes by implementing weekly partitions in SSAS models.
Utilized various slicers in Power BI to enhance report functionality.
Designed multiple dashboards by pinning visualizations to workspaces based on provided insights.
Performed data modeling to define and analyze data requirements for business processes within information systems.
Used Power BI Gateways to keep dashboards and reports up-to-date.
Created detailed and summary reports, including line and pie charts, trend analysis, and sub-reports tailored to business needs.
Generated on-demand and scheduled reports for business analysis and management decision-making.
Leveraged Power BI's self-service capabilities and tabular models for enhanced reporting.
Modified visualizations in Power BI reports and dashboards as per client requests.
Shared workspaces across the organization using Power BI Apps.
Implemented Row-Level Security (RLS) to meet specific business requirements.
Developed complex stored procedures and scripts in SQL Server.
Environment: Power BI, DAX, Power BI Gateway, Power Query, MS SQL Server (2016/2014/2012/2008 R2), MS Excel, Windows (8/10), Team Foundation, SSRS, SSAS
Bank of America, Charlotte, NC Jun 2018 to Dec 2019
Power BI Developer (SSIS and SSRS)
Responsibilities:
Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors.
Created dashboard for school system financial information which includes revenue and expenditure by district.
Written some Java script plugin that makes the polygons work like hyperlinks.
Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.
Used various sources to pull data into Power BI such as SQL Server, oracle.
Involved in installation of Power BI Report Server
Developed reports to visually explore data and create an interactive report Excel and Power BI.
Using a query editor in Power BI performed certain operations like fetching data from different file.
Created the KPI to show the difference between actual and forecast data.
Working with import and direct query, creating custom table in the Power BI.
Merge queries and append queries, remove columns and split columns, choosing required columns in the data.
By using Power BI desktop connected to various data sources, working with different visualizations.
Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
Created several user roles and groups to the end-user and provided row level security to them.
Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service. O Worked on importing custom visualizations.
Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.
Environment: Power BI, SQL Server 2005, MS Access, SSIS, SSRS, Query Analyzer, Windows Server 2003, DTS, T-SQL, SQL Profiler.
Contact this candidate