Power Bi Sql Server

Karthik Valapala

Email - ***************@*****.***

Contact - 505-***-****

PROFILE SUMMARY

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

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

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

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

Experience in Database Design, Development and Implementation of Database systems using MSSQL 2016/2014/2012.

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 environment using SQL server.

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

Expertise in creating various type 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 Scheduling reports.

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

Experience on building SSAS cubes both Tabular cube and Multidimensional cube designs and created various reports and dashboards using Power BI.

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 various visuals and experienced in on-premises gateway setup.

Experience in creating reports using Power BI Report Builder.

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

Quick leaner with excellent communication, analytical & relationship management skills.

CERTIFICATIONS

Microsoft Certified & Development on Power BI.

Analysing and Visualizing Data with Power BI.

MCID: 989872429

EDUCATION:

Master’s in Computer Science - Chicago State University at Chicago, IL 2012

Bachelors in Computer Science systems Engineering - JNTU, India 2010

PROFESSIONAL EXPERIENCE

Employer - Fiona Solutions

Implementation partner - Insight Global

State of Washington, Olympia, WA July 2022 – May 2025

Dept of Liquor and Cannabis (LCB)

Sr. SQL Developer

Responsibilities:

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 database.

Designed and developed ETL data pipelines to efficiently move and transform data from various sources to Azure Synapse Analytics and 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.

Created triggers to run pipelines at scheduled intervals to automate them based on data events.

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).

Built semantic data models in Power BI with efficient DAX measures supporting accurate aggregations and real-time analytics.

Worked on different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.

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

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 to 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 Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Created tables, views, functions and stored procedures using the 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.

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

Created Web query files and extracted data from Web forms 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 and triggers.

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

Installed the power BI gateway to create the direct query connection from SSAS server to get the data on reports and dashboards.

Environment: SQL Server 2019, Power BI, Azure Synapse Analytics, Databricks, Data Lake, ADF, PySpark, Python, T-SQL, SSDT, SSRS, SSIS, SSAS, Azure, CI/CD, Dax Studio.

Employer - Paramount Soft

Implementation partner - Paramount Soft

State of Michigan, Lansing, MI Sep 2021 – June 2022

DTMB - MDOC (Dept. of Corrections)

Sr. SQL Developer

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 cloud.

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

Designed and implemented complex DAX measures and calculated columns to enhance Power BI dashboards.

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 to OLAP databases.

Written complex SQL statements using joins, sub queries and correlated sub queries.

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.

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.

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 developed complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling 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 Business Analyst and test the reports to clarify reporting needs.

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

Implemented CI/CD pipelines using Azure DevOps to automate build, test, and deployment workflows

Environment: Power BI, ADF, Azure Synapse Analytics, SQL Server 2019, SSRS, SSIS, SSAS, T-SQL, C#.NET, Oracle, Azure DevOps, Excel.

Employer - Paramount Soft

Implementation partner - Cognizant

CVS Health, Chicago, IL Nov 2020 – Sep 2021

Sr. SQL/BI Developer

Responsibilities:

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

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

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 database.

Created database level triggers code for database consistency, integrity and security.

Implemented backup and recovery strategies to constantly secure existing databases.

Experience on different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.

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 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 to 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 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).

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.

Developed Web APIs using C# for the ASP.net connectivity services.

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.

Installed the power BI gateway to create the direct query connection from SSAS server to get the data on reports and dashboards.

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

Environment: SQL Server 2017, Visual Studio 2019/2017, C#.Net, ASP.NET, T-SQL, SSDT, SSRS, SSIS, SSAS, Power BI, Excel.

Employer - Paramount Soft

Implementation partner - Macrosoft

AT&T, Middletown, NJ Nov 2016 – Oct 2020

SQL/ETL Developer

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.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

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

Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

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

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, ser-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.

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 the track of the transactions by using triggers.

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

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

Employer - Horizon Advance Systems

Implementation partner - Jas Solutions

Frontier Communications, Richardson, TX May 2015 – Oct 2016

MSBI Developer

Responsibilities:

Involved in Planning, Designing and Created 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).

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

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 it into the Multi-dimensional data warehouse.

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

Implemented the SCD type 2 and Incremental load transformations to maintain data warehouse.

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

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

Created SSIS packages to import and export data from various flat files, Delimited, Ragged Right, 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 restoring them when necessary.

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

Responsible for disaster recovery and high availability solutions and large-scale database migrations from SQL server 2008 to SQL Server 2012.

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 User on demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.

Deployed and maintained the SSRS reports on the report server.

Followed Agile Scrum methodologies, Test driven development (TTD).

Involved in meetings with Verizon team and Business team regarding the Applications to be handled.

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

Employer - Strategic Rescource International INC

Implementation partner - TCS

Microsoft, Redmond, WA Feb 2014 – April 2015

SQL Developer

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 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, 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 Schedule SSIS, DTS Packages.

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

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

Experience working with SSIS data parsing using CSV, XML, 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.

Developed middleware components classes and WCF services in the applications and integrated in UI using MVC model.

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.

Employer - Strategic Rescource International INC

Implementation partner - Diversified Solutions

Mutual of Omaha, Omaha, NE Mar 2013 – Jan 2014

SQL/ETL Developer

Responsibilities:

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

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 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 Data Warehouse with understanding of all aspects of data modeling and created data migration mappings and transformations for Data Warehouse loading.

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

Designed and implemented 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, 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, ASP.Net, SQL Server 2008, SSIS, SSRS, HTML, CSS, Agile, TFS.

Quadratics Systems Inc, Schaumburg, IL July 2012 – Feb 2013

SQL/ETL Developer (Intern)

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 User on demand Basis or run on 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.

Contact this candidate