Karthikraj

Power BI Developer

adyuu4@r.postjobfree.com 602-***-****

PROFESSIONAL SUMMARY:

Over 8+ years of experience in the IT industry as a SQL BI Developer with Microsoft SQL Server 2014/2012/2008 R2/2008, SSIS/SSRS/SSAS. Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. Expertise in writing T-SQL queries, dynamic-queries, sub-queries, and complex joins

Expert in T-SQL (DDL, DML) statement development, Data Integrity (constraints), Rules, and Validation problems.

Experience designing Power BI dashboards/reports using tabular models, as well as knowledge of Gateways and content packs.

Using Power BI, you can explore data in a variety of ways and across numerous visualisations.

Reports were created via the Power BI preview site using the SSAS Tabular through Analysis connector.

Extensive knowledge in publishing Power BI Desktop reports built in Report view to the Power BI service.

Extensive experience with various stages of the project life cycle (analysis, design, implementation, testing, and debugging of new and existing client-server applications).

Exceptional knowledge of normalisation and denormalization algorithms for best performance in relational and dimensional database settings.

Views were created in accordance with design requirements.

Good experience with Microsoft BI studio for ETL technique implementation.

Experience developing SSIS packages for integrating data from disparate sources (Excel, CSV, flat file, Text Format Data) using OLE DB connections and many transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and Union All.

Extraction, Transformation, and Loading (ETL) data from diverse sources into Enterprise Data Warehouse and numerous Data Marts utilising T-SQL, SSIS, and Informatica on Oracle, Teradata, and SQL Server databases.

Experience with Tableau Desktop, Tableau Public, and Power BI for business analysis, delivering customised ad hoc reports, and creating actionable dashboards for enterprise applications.

Worked on DAX scripting to get data from Tabular Models and MDX for Multidimensional Cubes.

Expertise in developing Row Level Security and Roles for SSAS Tabular Models and Multidimensional Cubes, as well as implementing them into SSAS.

Created proof-of-concept REST services utilising NodeJS, MongoDB, Express-JS, and Body-Parser.

KPIs, partitions, perspectives, and calculated measures were all worked on.

Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS databases.

DAX (Data Analysis Expressions) and MDX routines were used to create calculations and measurements in Tabular Mode and multi-dimensional Cubes. Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports, and Graph Reports utilising Crystal Reports' Chart Expert.

Major duties include gathering needs from the user and documenting the reports properly for future reference.

TECHNICAL SKILLS:

Operating Systems

Windows, Unix, Linux, Mac

Databases

MS SQL Server 2008/2008R2/2016/2014/2012, MS Access, Teradata Database, MongoDB

Database Design Tools and Data Modeling

Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools

Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools

SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI, Tableau, SAP

Tools

Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS).

Languages

C, C++, HTML, XML/.Net/C#, Power Shell, VB.NET, Python, T-SQL, SAS, R, SPSS, MySQL, Latex

PROFESSIONAL EXPERIENCE:

U.S. Bank, Minneapolis, MN Jan 2022 to Till date

Power BI Developer

Responsibilities:

Created, updated, and maintained Power BI reports and dashboards.

Imported data into Power BI Desktop and modelled data within Power BI using the Power Query language.

Created Power BI graphical and visualisation.

solutions with business requirement documents and designs for interactive dashboards.

Set up and maintained the Power BI Service (app.powerbi.com) for sharing content with business customers.

Uploaded reports to the Power BI service by building and managing app workspaces and apps.

Publishes reports and dashboards to the PowerBI service and manages refresh schedules and data flow into relevant data sets.

Using groups, bins, hierarchies, sorts, sets, and filters in Tableau Desktop to analyse and get insights into big data sets

Collaborated with data engineers and the operations team to develop the ETL process, and designed and optimised SQL queries to extract data to meet the analytics needs.

Developed unique calculated measures using the Power BI DAX language to satisfy the demands of the business.

Implement Row Level Security (RLS) for Power BI reports to limit data access for specific users.

Experience generating various types of Power BI reports and dashboards.

Power BI Desktop reports prepared in Report view were published to the Power BI service.

Changes were made to the existing Power BI Dashboard on a regular basis in response to business needs.

Premium Capacity was configured and managed in the Power BI service to share apps with corporate users.

Installed and managed an on-premises gateway to provide safe data transfer between on-premises data and the Power BI service.

Created a Tableau Public Dashboard with constraints to display specific characteristics for a specific purpose.

Experience with Power BI service administrator tasks such as building and managing security groups, assigning user permissions, and monitoring dashboard usage metrics.

DAX studio was used to create performance optimisation methods on report level metrics, and PowerShell activities were used to automate numerous Power BI related operations.

Business users were trained on how to use Power BI dashboards and self-service features.

Responsible for meeting with various user groups to determine what dashboards need to be produced; provided production support on existing Power BI dashboards.

Environment: Power BI Desktop, MS SQL Server 2017, Microsoft Visual Studio, Power BI Service, Power Pivot, MS Excel, DAX Studio.

Fitch Ratings, New York Oct 2020 to Dec 2021

SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

Developed complicated stored procedures, triggers, functions, indexes, tables, views, and other T-SQL code and SQL joins for applications as a developer.

Implement many types of constraints on tables.

Identified and defined the data sources in order to develop the data source views.

Examined the reports and corrected problems in stored routines.

Using SQL Profiler, I maintained the physical database by monitoring performance, integrity, and optimising SQL queries for maximum efficiency.

Scheduled jobs and notifications were monitored.

Responsible for gathering/refining customer requirements for report development.

SSIS packages were created using a variety of transformations such as conditional splits, fuzzy lookups, aggregations, and multicasting.

Created, maintained, and scheduled numerous Power BI reports such as Tabular Reports and Matrix Reports.

Experience developing various types of Power BI Reports and Dashboards. Developed periodic reports based on statistical analysis of data from various time frames and divisions using Power Pivot, Power Query, Power View, and Power BI.

Data blending, SQL data preparation for Tableau consumption, and dashboard uploading to Tableau Server were all completed.

As a Power BI Developer, you will be in charge of the design, development, and production support of interactive data visualisations utilised throughout the organisation.

Power BI and Power Pivot were utilised to create a data analysis prototype, and Power View and Power Map were used to visualise reports.

Power BI reports were created using the SSAS Tabular Model and the Analysis connection.

SSRS reports were migrated to Power BI.

Responsibilities include scheduling subscription reports using the subscription report wizard and developing sophisticated expressions and formulas for reports in SSRS.

To meet the demands of the organization's many teams and groups, I created SSRS reports.

Existing reports such as group by, drilldown, drill through, sub-reports, list, tabular, matrix, navigation reports, standard parameter, cascade parameter, and multivalve parameters have been implemented and extended.

Understanding of SSRS report performance utilising execution logs and query optimisation for datasets.

Monthly/weekly/daily reports are scheduled based on customer requirements.

Environment: MS SQL Server 2012, Microsoft Visual Studio, SQL Server Integration Services (SSIS 2012), SQL Server Reporting Services (SSRS 2012), SSAS, Power BI, Power Pivot, Jira, TortoiseSVN, MS Excel, SQL Server Profiler.

AT&T, Dallas, TX Jan 2019 to Sep 2020

SQL/SSIS/SSRS/SSAS /PowerBI Developer

Responsibilities:

Created views for easy user interface implementation, as well as triggers for consistent data entry into the database.

Extensive experience in client/server database design, including views, cursors, CTEs, schemas, permissions, and performance concerns.

Responsible for data transfer utilising SSIS packages.

SSIS packages were created, monitored, and deployed.

SSIS was used to develop ETL packages for validating, extracting, transforming, and loading data into Data Warehouse databases.

I improved report performance and ran unit tests.

SSIS packages were created to export data from a text file to a SQL Server database.

Using SSRS 2014, I created SQL Server Reports and designed queries for generating drill down reports.

In SSRS 2014, I identified and dealt with parameters for parameterized reports.

Analysed old Crystal Reports reports and converted them to SSRS reports with suitable mapping and error handling.

The generated reports were instantly deployed on the client's workstation.

Managed indexes, statistics, and query optimisation by employing an execution plan to tune the database.

Worked on Data Analysis Expressions (DAX) for directly accessing data from a tabular SSAS database.

On MS OLAP/ Analysis Server (SSAS), I created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations.

SSAS was used to create a cube with several dimensions and modify the Relationship between a Measure group and a dimension.

Designed Tableau data visualisation tools such as cross tabs, heat maps, box and whisker charts, scatter plots, geographic maps, pie charts, donut charts, bar charts and density charts.

Collect data from several data sources, such as MySQL and Excel.

Sets, parameters, calculated fields, dynamic sorting, filtering, and parameter driven analysis were used to create visualisations.

Multiple Power BI dashboards/reports and content packs were created and maintained.

Changes were made to the existing Power BI Dashboard on a regular basis in response to business needs.

To tackle the issues rapidly, I provided production support on the existing Power BI dashboards and associated ETL operations.

Power BI Desktop reports prepared in Report view were published to the Power BI service.

With business requirement documents and ideas for building interactive dashboards, I designed and created Power BI graphical and visualisation solutions.

Created Tabular Models to be used as a source for Power BI dashboards and scheduled jobs to refresh them on a regular basis.

Managed Power BI Portal - Data Refreshes / User Management and Gateway Data Refresh ConfigurationMonthly reports, weekly reports, and daily reports were scheduled based on user needs.

Environment: MS SQL Server 2012/2014 R2, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014),Power BI, Power Pivot, Windows 2010, MS Excel.

CVS Health Inc, Castle Rock, Colorado Sep 2016 to Dec 2018

SQL BI Developer

Responsibilities:

For practise, I wrote complex stored procedures, triggers, functions, indexes, tables, views, and other T-SQL code.

Involved in unit testing and user acceptability testing to ensure that data taken from source systems is loaded into the target.

Extensive knowledge of database objects such as procedures, functions, triggers, and indexes.

Created functions to provide bespoke functionality based on the needs.

Designed and written the queries for data retrieval in the query builder.

Used SSIS extensively to import, export, and transform data from XML and text sources.

For SSIS packages, I created and handled event handlers, package configurations, logging, system and user-defined variables.

As part of ETL, I worked with various SSIS control flow activities and data transformation jobs such as data conversion, derived column, look-up, and fuzzy look-up, conditional split, and so on.

Checkpoints and configuration files were created in SSIS packages.

Merge command was extensively utilised as an alternative to short SSIS packages in dimension and fact load.

Using an XML configuration file, I deployed SSIS packages with little adjustments.

Extracted data from a variety of sources and built packages with SSIS, Import/Export data, bulk insert, and BCP utilities.

SQL profiler was used to optimise stored procedures.

Developed SSRS reports with a range of features such as charts, filters, sub-reports, drill down, drill-through, and multi-valued parameters.

SSRS reports were created and deployed to web pages using ASP.NET and C#.

SSRS administration interface for organising reports and data sources, scheduling report execution and delivery, and tracking reporting history.

Based on the OLAP reporting requirements, I created sophisticated SSAS cubes with numerous fact measure groups and multiple dimension hierarchies.

Involved in the design of Cube Partitions to boost performance using SSAS.

MDX was used to query Analysis Service Databases, troubleshoot, and enable data analysis.

Crystal Reports reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports, and so on.

Designed and created Crystal Reports, Cross Tab Reports, and Top N Reports for providing essential data and summary reports with drill-down features.

Using Crystal Reports' chart expert, I created a variety of charts and graphs such as bar charts side by side, stacked, line graphs, pie charts, and so on.

Using MDX, I created calculated measurements to meet a business requirement.

Working on the Star and Snow Flake schemas, I used the fact and dimension tables to generate the cubes, do processing, and deploy them to the SSAS database.

SSAS designed aggregations and pre-calculations.

Teradata SQL Assistant was extensively utilised to extract data from a data warehouse.

Environment: Microsoft SQL Server 2008 R2/ 2012, MS Access, ETL Packages(SSIS 2012), SQL Server Reporting Services(SSRS 2012), SSAS, Power BI, Power Pivot, MDX, Teradata, .Net, VB.Net, HTML, Visual Studio, Crystal Reports, Visual Source Safe, T-SQL,XML .

Grapesoft Solutions Pvt Ltd, India May 2015 to Aug 2016

SQL BI Developer

Responsibilities:

Created new databases and updated existing user and system databases. Involved in database logical/physical design and maintenance.

Database objects (tables, views, and functions) were created.

Indexes and tables were rebuilt as part of a performance optimisation effort.

Physical database design successfully deployed in SQL Server 2008R2.

To capture updated and deleted data from OLTP systems, I wrote Triggers, Stored Procedures, and T-SQL Queries.

Expertise in the use of various transformations like as lookups, derived columns, merge joins, fuzzy lookups, for loops, for each loops, conditional splits, union all, script components, and so on.

Created physical data models and DDL scripts to generate database schema and objects.

T-SQL queries were written utilising inner join, outer join, self joins, and merge join. In addition, features for deleting duplicate records, such as CTE and ranking function, was implemented.

Collaborated with DBA to improve database performance by building Stored Procedures, Clustered and Non-Clustered Indexes, and optimising T-SQL statements using SQL profiler.

Developed SSIS packages that migrate data from DB2, flat files, excel documents, and CVS files to SQL Server's staging area.

SSIS was utilised to transfer large amounts of data from and to SQL Server databases, and configuration files and environment variables were used for production deployment.

SSIS Templates were created for the purpose of building SSIS Packages that can be dynamically deployed into Development, Testing, and Production Environments.

DTS packages were created to duplicate tables, schemas, and views, as well as to extract data from Excel and Oracle using SSIS.

Created SSIS packages with bespoke error handling and worked with various SSIS logging mechanisms.

SSIS packages were created to load data into SQL Server using various SSIS transformations.

SSIS packages were created, and an Analysis Services processing task was used to update the cube with current data.

In SSRS, I created sub-reports, parameterized and drill-through reports, drill-down reports, matrix reports, and summary reports.

Created Report Snapshots to increase SSRS performance.

Environment: MS SQL Server 2008/2008R2, SSIS/SSRS, Query Analyzer, T-SQL, Windows Server 2008R2, SharePoint server, DTS Designer, Visual Source Safe, Microsoft Visio 2007, SQL Profiler, SQL Profiler, MS Excel 2010, MS Word 2010,Power point 2010.

Contact this candidate