Power Bi Sql Server

KARTHIK VALAPALA

Email: ***************@*****.***

Contact: +1-505-***-****

PROFILE SUMMARY:

Overall, 13+ years of experience in design, development & analysis of SQL Server and Business Intelligence tools (BIDS) and reporting.

Experience in creating datasets for Power BI and Ad-hoc reports, and an expert on creating various Reports, Dashboards, and Apps using Power BI.

Experience in translating complex SAS programs into optimized SQL code, enabling seamless integration with Power BI for dynamic and high-performance reporting.

Experience in creating visualizations using Power BI and proficient in various chart types like Bar, Line, Tree maps, Matrix and KPI's on graphs.

Experience in Power BI to create various analytical dashboards and reports with multiple visuals and experience in on-premises gateway setup.

Experience in creating reports using Power BI Report Builder.

Expertise in design and development of SQL Server Integration Services (SSIS) packages and using various control flow tasks and data flow transformations.

Strong relational database background in SQL Server with extensive knowledge in writing the T-SQL scripts, Stored procedures, Triggers, Views, Database designing and Maintenance.

Hands on Experience with Power BI Desktop and created Reports, Scorecards and Dashboards.

Experience in Database Design, Data Analysis, Development and Implementation of Database systems using MSSQL 2019/2017.

Experience in Data Warehousing methodologies and concepts, including star schemas, snowflake schemas, ETL processes, dimensional modelling and reporting tools.

Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL Server Agent.

Creating the database objects like procedures, functions, packages, triggers, indexes, and views using t-SQL in development, QA and production environments using SQL Server.

Strong experience in Data Warehousing Data Integration and Data Conversion Projects with ETL experience using Informatica Power Center.

Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.

Expertise in creating various types of reports such as drill down, drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Experience in reporting services configuration manager to configure and maintain Report Manager, Report server, send emails to the end user, and schedule reports.

Collaborated with BI and ETL teams to support data migration, transformation, and integration using SSIS and SQL.

Expertise in building ETL pipelines using Azure Synapse Analytics and Databricks.

Experience in Team Foundation Server (TFS) for source code, task and defect maintenance. Also, experience in using GitHub for source code maintenance

Certification:

Analyzing and Visualizing Data with Microsoft Power BI

Professional Experience

Client: Department of LCB - State of Washington Olympia, WA

Sr. Power BI Developer July 2022 – June 2025

Responsibilities:

Collaborated with cross functional teams to gather requirements, design and translate them into datasets.

Developed and deployed dynamic dashboards using Power BI Desktop, Power Query, DAX, and PowerBook by enhancing visibility into operational metrics.

Experience in DAX queries and M query for creating calculated columns and Measures in Power BI.

Created Power BI reports using the Power BI Report Builder.

Created and deployed Power BI reports using CI/CD to integrate reports in different environments (Dev/QA/Prod).

Created data objects like Tables, Procedures, Indexes, and Views using T-SQL statements using SQL Server.

Collaborated with business stakeholders to identify critical data sources, transformation logic, and KPIs and created accurate and actionable dashboard reporting.

Created and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load into the database.

Implemented Power BI KPI visual elements using calculated DAX measures with thresholds, targets, and conditional formatting.

Implemented row-level security (RLS) and role-based access controls using DAX filters and security models.

Migrated Data from SharePoint to Azure and created Retention rules based on business purpose and Cleansed data.

Created indexes and implemented the use of constraints to handle performance and integrity of data on databases.

Automated report and dataset deployments using Power BI REST APIs, supporting CI/CD pipelines for analytics to use in web apps.

Designed and implemented RESTful APIs to create dynamic analytical data to embedded dashboards and ensure secure, scalable and low-latency access across web applications.

Designed and developed ETL data pipelines to efficiently move and transform data from various sources to Azure Synapse Analytics and Azure Databricks environments.

Integrated data from a variety of sources, including databases, APIs, cloud storage, and on-premise systems into Azure Synapse and Databricks.

Using Azure Data Factory (ADF) created Azure Pipelines to Extract data from Salesforce to Azure Data Lake Storage.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data in OLAP databases.

Created various types of SSRS reports like drill down, drill through, sub reports, also created report parameters, included multi-value parameters and dynamic parameters.

Experience in writing expressions in SSRS and an Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Worked with SSIS Execute SQL task, data flow tasks, script component, row count, union all, multicast, derived column transformations and written T-SQL and C# scripts.

Created Web query files and extracted data from Web Pages and loaded into SQL DB.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Analyzed and tuned application performance by optimizing SQL, stored procedures, views and functions.

Administered and maintained multiple SQL Server instances across Development, QA, Pre-Release, and Production environments.

Documented and maintained the steps for database backup, restore, procedures, and troubleshooting.

Environment: SQL Server 2019, Power BI, REST APIs, CI/CD, Visual Studio 2019/2017, T-SQL, SSDT, SSRS, SSIS, SAS, Power Query, Azure, DAX, Python, Excel.

Client: DTMB - MDOC (Dept. of Corrections) - State of Michigan Lansing, MI

Sr. Power BI Developer Sep 2021 – June 2022

Responsibilities:

Involved in requirements gathering and review with business analyst about end user business requirements.

Developed visual reports, dashboards and KPIs in Power BI and published the reports to the cloud.

Designed, developed, and tested various Power BI Dashboards and ad-hoc reporting solutions by connecting to different data sources and databases.

Developed complex DAX measures and calculated columns for business metrics.

Wrote complex Power Query (M language) and SQL queries to extract, clean, and transform large datasets from SQL Server, Azure SQL DB, and Excel sources.

Used various sources to pull data into Power BI, such as SQL Server, Oracle, SQL, Excel, etc.

Scheduled Automatic refresh and scheduling refresh in Power BI service.

Designed and implemented complex SSIS packages to migrate data from multiple data sources (Teradata, Oracle) for data analyzing, deploying and dynamic configuring of SSIS packages.

Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.

Created Stored Procedures and Views to Support Application users using T-SQL Statements.

Experienced in using ETL tools in (SSIS) MS SQL 2012 and 2016 and DTS in MS SQL 2012/2016 and Microsoft Visual Studio 2012/2016/2019

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data in OLAP databases.

Written complex SQL statements using joins, subqueries and correlated subqueries.

Managed Power BI Portal with Data refreshes/User management and set up gateway data refresh.

Created various types of SSRS reports like drill down, drill through, sub reports, also created report parameters, included multi-value parameters and dynamic parameters.

Integrated Power BI Embedded into internal and customer-facing applications using Power BI JavaScript SDK and REST APIs to deliver interactive reports and dashboards.

Responsible for designing and developing the UI using HTML5, CSS3, jQuery, JavaScript.

Created weekly and monthly reports as per requirement using SSRS and Scheduled reports in SSRS report Manager.

Created SSIS packages to implement the Script Task and Script Component to create custom .NET assemblies (DLLs) using C#, .NET.

Designed and developed the dimensions, cubes with star schema and snowflake using SQL Server Analysis Services (SSAS) for analysing purpose.

Designed and developed complex Azure Analysis Services tabular databases and deployed the same in Microsoft Azure and scheduled the cube through Azure Automation Runbook.

Implemented version control systems in TFS and work item/artifact systems in Azure DevOps.

Working experience with Azure DB technologies and Azure deployments.

Review the Reports with the Business Analyst and test the reports to clarify reporting needs.

Reviewed code and created build Artifacts and coordinated with Admin for successful code deployments.

Environment: Power BI, Visual Studio 2017, SQL Server 2017, SSRS, SSIS, SSAS, T-SQL, Tableau, C#.NET, Oracle, JavaScript, jQuery, HTML5, Azure DevOps, Excel.

Client: CVS Health Chicago, IL

Sr. ETL Developer Nov 2020 – Sep 2021

Responsibilities:

Involved in Requirement gathering, analysis, Low Level Design, Coding and Integration.

Developed efficient, reusable, and testable Python modules for healthcare data processing, leveraging OOP, custom classes, and exception handling to ensure compliance with HIPAA standards.

Implemented SQL Alchemy ORM models to abstract and manage complex relational data schemas, supporting EHR (Electronic Health Record) and claims data processing.

Created and maintained comprehensive Pytest unit and integration test suites to validate critical data pipelines, reducing production bugs and ensuring regulatory data integrity.

Designed and optimized ETL workflows using Informatica PowerCenter to ingest, transform, and load large volumes of healthcare data from multiple sources including HL7, flat files, and relational databases.

Collaborated with data governance and compliance teams to ensure ETL pipelines and Python scripts adhered to healthcare data privacy and audit logging requirements.

Integrated Python-based services with clinical systems and data warehouses, enabling analytics and reporting on patient outcomes, care quality, and cost metrics.

Created and scheduled SSIS packages in SQL Server. Worked with SSIS Execute SQL task, data flow tasks, script component, row count, union all, multicast, derived column transformations and written T-SQL and C# scripts. er Agent to maintain a large data migration effort from different sources (DB2, Oracle, Access, Excel) into destination tables by performing different kinds of transformations to meet business needs.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data in OLAP databases.

Designed interactive dashboards in Cognos Analytics to monitor KPIs, including patient readmission rates, length of stay, and claims processing metrics.

Created various types of SSRS reports like drill down, drill through, sub reports, also created report parameters, included multi-value parameters and dynamic parameters.

Experience in writing expressions in SSRS and an Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Created Power BI reports using the Power BI Report Builder.

Created and deployed Power BI reports using CI/CD to integrate reports in different environments (Dev/QA/Prod).

Developed and deployed dynamic dashboards using Power BI Desktop, Power Query by enhancing visibility into operational metrics.

Integrated authentication and authorization into analytics APIs to support multi-tenant access and data privacy.

Developed web applications using Angular, ASP.NET, Web API, C#, and Entity Framework.

Worked with SSIS Execute SQL task, data flow tasks, script component, row count, union all, multicast, derived column transformations and written T-SQL and C# scripts.

Reviewed and analysed legacy SAS programs by translating multiple scripts into efficient and maintainable SQL code aligned with Power BI reporting needs.

Developed and optimized Cognos Framework Manager models, ensuring high performance and data accuracy across multiple report packages.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Analyzed and tuned application performance by optimizing SQL, stored procedures and triggers.

Experience in DAX queries for creating calculated columns and measures in Power BI.

Built robust ETL processes across multiple SQL Server instances and integrated from Development, QA, Pre-Release, and Production environments.

Provided support to the QA team during the testing phases of the project.

Environment: SQL Server 2014/2012, Power BI, Python, Informatica Power Center, T-SQL, SAS, SSDT, SSRS, SSIS, Excel.

Client: AT&T Middletown, NJ

SQL/ETL Developer Nov 2016 – Oct 2020

Responsibilities:

Interacted with business and application architects for need analysis and to define Business and Functional Specifications and prepared Low-level design document.

Gathered and studied system requirements by analysing real time business needs.

Created reports, dashboards, and apps using Power BI Visuals and deployed reports on the Power BI cloud service.

Wrote calculated columns, Measures queries in Power BI Desktop to show good data analysis techniques.

Implemented row-level security and role-based access controls using DAX filters and security models.

Experience working with various visuals such as Matrix, Table, Slicer, Charts, KPI’s in Power BI.

Built star schema data models with fact and dimension tables, supporting fast performance for DAX measures and slicers.

Created reusable DAX templates and documentation for standardized KPIs across departments.

Experience in developing Multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).

Created database and database objects like tables, stored procedures, views, triggers, rules, defaults, user-defined data types, and functions.

Created user roles and permissions for the Front-End developers to access the DB.

Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to Oracle and SQL Server databases using SQL Server Integration Services (SSIS).

Extensively used SSIS Import/Export Wizard for performing the ETL operations and actively supported business users for change requests.

Worked with SSIS Execute SQL task, data flow tasks, script component, row count, union all, multicast, derived column transformations and written T-SQL and C# scripts.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Created reports using the Power BI Report builder.

Managed reporting infrastructure on SQL Reporting Services Servers, ensuring uptime and data integrity across all environments.

Extensively used for loop Containers and for Each Loop containers to perform dynamic tasks in SSIS.

Created Audit trails for the transactional tables to keep track of the transactions by using triggers.

Documented and optimized data workflows, reducing processing time for the view and stored procedures through performance tuning and automation.

Created test plan documentation and Test Cases for the application functional testing.

Environment: SSDT 2017, SQL Server 2017/2014/2012, SSRS, SSIS, SSAS, Power BI, On-Premises Gateway, C#.NET, Toad, Oracle, Azure, Excel, UNIX, Putty.

Client: Frontier Communications Richardson, TX

SQL Developer May 2015 – Oct 2016

Responsibilities:

Involved in Planning, Designing and created a database based on end-user business requirements.

Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to Oracle and SQL Server databases using SQL Server Integration Services (SSIS).

Designed, developed, and implemented ETL (Extract, Transform, Load) workflows using Informatica PowerCenter or other Informatica products.

Diagnosed and resolved complex performance issues using tools like SQL Profiler and Database Tuning Advisor.

Conducted regular database health checks, index maintenance, and statistics updates to ensure optimal query performance and system stability and monitored the CPU and memory utilizations.

Designed and implemented automated backup and recovery strategies using native SQL Server.

Worked on SQL*Loader to load data from flat files, Excel, xml files on a daily basis.

Designed and developed complex ETL workflows and mappings using Informatica PowerCenter to extract, transform, and load data from multiple source systems into data warehouses.

Built reusable transformations and mapplets to streamline ETL development and improve code maintainability.

Automated ETL job monitoring and implemented alerting using scheduling tools like Control-M, Autosys, or Informatica Scheduler.

Experience in Data Conversion across different databases like SQL, Oracle, DB2 and flat files.

Prepared UNIX Shell scripts to load the data from VZN DB into Oracle tables through SQL Loader.

Worked on SSIS Package, DTS Import/Export for transferring data from one database to another.

Created SSIS packages to import and export data from various flat files, Delimited, Ragged Right, and Fixed width to load data into the target database using SQL Server Integration Services (SSIS) from various sources.

Implemented SQL standards in writing stored procedures, Triggers, Views, and SQL functions.

Backed up master and system databases and restored them when necessary.

Worked on all activities related to the development, implementation and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.

Created SQL server Analysis Projects and created multi-dimensional reports, Pivot charts, and tables.

Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to the User on a demand Basis or run on a daily, weekly, and monthly basis in SSRS report Manager.

Deployed and maintained the SSRS reports on the report server.

Installed, configured, and patched SQL Server instances, including clustering for multiple instances.

Followed Agile Scrum methodologies, Test Driven Development (TDD).

Environment: Oracle, SQL Server 2012/2008, SQL Oracle Developer, Informatica, BIDS (SSIS, SSRS, SSAS), T-SQL, SQL*Plus, UNIX

Client: Microsoft Redmond, WA

SQL Developer Feb 2014 – April 2015

Responsibilities:

Engaged with the project team to understand the functional requirement.

Involved in daily and weekly Scrum meetings to discuss various aspects of the code related to individual modules.

Maintained the Source code using Team Foundation Server (TFS) in a multi developer environment.

Created an SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.

Transformed Complex business requirements into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, and Merge Join.

Experience with Data Cleansing in SSIS using the Derived column and Fuzzy Lookup transformations.

Created and maintained SQL Jobs, SQL Mail Agent, Alerts and scheduled SSIS, DTS Packages.

Responsible for designing and developing the Application using MVC architecture to create web applications.

Responsible for designing and developing the UI using HTML5, CSS3, jQuery, JavaScript.

Experience working with SSIS data parsing using CSV, XML, and JSON.

Created API’s using C# in the SSIS to automate the Excel Web Queries and load data into SQL DB.

Experience in writing complex stored procedures and SQL queries.

Created database maintenance plans for SQL backups, optimization, integrity check and t-log backups.

Worked with SSIS script task, data flow tasks, look up, conditional split, multicast, derived column transformations and written T-SQL and Visual Basic (VB) scripts.

Created and maintained parameterized reports and drilldown reports using SSRS.

Created views and functions using SQL to capture the data for SSRS Reports.

Interacted with the offshore team, ensured the task completion and delivery on time.

Tested the code developed to ensure it accurately captured the existing business processes.

Worked in Agile Scrum methodology and delivered accepted functionality in each sprint.

Responsible for maintaining versions of source code using Team Foundation Server.

Environment: SQL Server 2012/2008, Visual Studio 2012, MVC, C#.NET4.0, WCF, SSRS, SSIS, API, HTML5, CSS3, jQuery, JavaScript, Agile, JIRA, TFS.

Client: Mutual of Omaha Omaha, NE

SQL/ETL Developer Mar 2013 – Jan 2014

Responsibilities:

Involved in Requirement Analysis, Low Level Design, Coding, Integration using AGILE Methodology.

Collaborated with BI and ETL teams to support data migration, transformation, and integration using SQL Server.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files and XML) and performed different kinds of transformations using SSIS.

Performed various Data Transformations using conditional split, data conversion, derived columns and lookups to source data to transfer data in a format as per the organization needs.

Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, DB2 and flat files.

Improved the performance of SSIS packages by implementing parallel execution, removing unnecessary sorting and using optimized queries.

Developed and deployed MSBI SSIS packages in Production Server with deployment utility.

Experience in designing a Data Warehouse with an understanding of all aspects of data modeling and creating data migration mappings and transformations for Data Warehouse loading.

Improved the performance of complex T-SQL queries and stored procedures.

Designed and implemented a comprehensive Backup plan and disaster recovery using SQL Server tools like SSMS.

Used SSIS, Import/Export to Copy, move data from one server to another, and Excel to SQL Server.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Responsible for creating and scheduling the jobs to run stored procedures and SSIS packages.

Maintaining the Source code using Team Foundation Server (TFS) in a multi developer environment.

Tested the code developed to ensure it accurately captured the existing business processes.

Environment: Visual Studio 2012/2010, C#.NET, SQL Server 2008, SSIS, SSRS, ETL, HTML, CSS, Agile, TFS.

Client: Quadratics Systems Inc Schaumburg, IL

SQL Developer July 2012 – Feb 2013

Responsibilities:

Gathered requirements and created requirement specification documents for SSIS packages and reports.

Created Database Structures and Documentation of the Design for Requirements.

Created SSIS packages to import and export data from various flat files, CSV, and transferred data between servers (Oracle and SQL).

Created databases, tables, indexes, stored procedures, views, functions, triggers, and maintained user permissions.

Worked with SQL Disaster Recovery processes like Log Shipping methodologies, clustering, and mirroring.

Developed Complex Queries using different SQL joins and T-SQL Queries.

Developed Packages using most of the Tasks, Containers, and Transformations in SSIS.

Wrote stored procedures and SQL queries to fetch the data using SQL Server 2008.

Created SSIS packages to extract, transform and load data from Excel files and other source systems.

Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to the User on demand Basis or run on a daily, weekly and monthly basis in SSRS report Manager.

Created various SSRS reports such as parameterized reports, drilldown, and drill through reports.

Monitored Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Worked with application team to test the successful upgrades, migrations, and installations.

Environment: SQL Server 2008, Visual Studio 2010/2008, ASP.NET 4.0, C#.NET 4.0, SSIS, SSRS, HTML, CSS.

Education:

Master’s in Computer Science from Chicago State University, Chicago - June 2012

Bachelors in Computer Science from JNTU year 2010

Contact this candidate