Power BI, SSRS, SQL Server Developer

Devi Ragothaman

Power BI/ SSRS / SQL Developer

Email: *********@*****.*** Mobile: 860-***-****

PROFESSIONAL SUMMARY:

9+ years of IT Experience in design of IT experience. Most of the experience in designing & coding of databases and applications using Microsoft SQL Server 2022/2019/2017 and Oracle. Work experience in SQL Development, Integration Development using Microsoft tools like SSIS, SSRS, SSAS, Power BI and Azure Data Factory (ADF).

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2022/2019/2017/2016/2014.

Experienced in client requirement Analysis, Physical and Logical Design, Development (using ERwin Data Modeler, normalization and SQL Server Management Studio), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2022/2019/2017/2016, SSIS, SSAS, SSRS, Power BI and Azure Data Factory (ADF).

Experience with Relational and Dimensional Data Modelling using ERwin Data Modeler, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modelling, Star and Snowflake Schemas. Thorough understanding of Data Warehouse concepts like Facts, Dimensions, Surrogate Keys, Drill Down and Drill Across approach.

Strong T-SQL experience in creating different database objects such as Tables, Stored Procedures, DDL/DML Triggers, Functions and User Defined Data Types. Skilled in writing and reviewing T-SQL code and maintaining coding standards.

Good knowledge of Data Warehouse/Data Mart concepts and expertise in data modelling for OLAP & OLTP systems from design and analysis to implementation including conceptual, logical and physical data models.

Experience in creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQL statements for various applications and Power BI semantic models.

Worked extensively on ETL processes using SSIS and Azure Data Factory (ADF).

Experience in writing complex SQL queries involving multiple tables, Inner Joins, Outer Joins, CTEs, Window Functions and Common Table Expressions (CTEs).

Experience in optimizing queries by creating various Clustered, Non-Clustered Indexes, Indexed Views and Query Performance tuning.

Expert in design and development of SQL Server Integration Services (SSIS) packages using various Control Flow Tasks and Data Flow Transformations.

Excellent in creating SSIS Packages for integrating data using OLE DB, ADO.NET and Azure connectors from heterogeneous sources (Excel, CSV, Oracle, Flat Files, XML, JSON and Text Files) by using multiple transformations such as Data Conversion, Conditional Split, Lookup, Merge, Merge Join and Union All.

Expert in T-SQL DDL/DML and performing SQL Server Management Studio (SSMS) functionality using T-SQL scripts and batches.

Excellent in Data Extraction, Transformation and Loading (ETL) using SSIS, Azure Data Factory (ADF), Bulk Insert and BCP.

Expert in creating various types of reports such as Complex Drill Down, Drill Through, Matrix Reports, Sub Reports, Charts and Dashboards using SQL Server Reporting Services (SSRS) and Power BI based on Relational and OLAP databases.

Created SSIS packages to import/export business data to/from Excel sheets, Flat Files, XML, JSON files and other databases as per user requirements.

Created ETL solutions using SQL Server Integration Services (SSIS) and coordinated with ETL development teams to ensure data was extracted, transformed and loaded according to specified requirements.

Expert in designing complex reports using Cascading Parameters, Drill-Through Reports, Parameterized Reports, Report Models and Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Power BI based on client requirements.

Created Views as per design needs for security and performance optimization.

Strong knowledge of Software Development Life Cycle (SDLC), Database Design, RDBMS, Data Warehousing and Data Modelling concepts.

Involved in creating SQL Server Agent Jobs and SSIS Jobs to automate report generation, ETL execution and cube refresh packages.

Designed high-level ETL Architecture for overall data transfer from OLTP to OLAP systems using SSIS and Azure Data Factory (ADF).

Extensive experience working with SSAS Cubes, Tabular Models, Power BI Semantic Models and ETL processes.

Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.

Created tables for Data Warehouse applications and populated the tables from OLTP databases using SSIS and Azure Data Factory (ADF).

TECHNICAL SKILLS:

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),

MS Visio, Power BI

Tools & Packages

SQL Server Management studio, Enterprise Manager, Profiler, SSMS 20.x

, ETL, Visual Studio .NET, TOAD

Programming Languages

C, C++, T-SQL, SQL, PL/SQL, JavaScript, HTML5, XML, JSON.

RDBMS

Microsoft SQL Server 2022/2019/2017/2016, Azure SQL Database, Oracle 19c/12c.

Web Technologies

HTML5, JavaScript (ES6+), XML, JSON, XPath

Hardware and Operating Environments

Windows 11, Windows 10, Windows Server 2022/2019/2016, macOS, Linux (Ubuntu).

Education:

Master of Computer Applications (MCA), Anna University, India

EXPERIENCE SUMMARY:

Client: KinderSystems, Frisco, TX Feb-2023-Mar-2026

Role: Power BI/ SSRS / SQL/Database Developer

Responsibilities:

Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have Primary Keys.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION statement and using the TOP operator to limit the SELECT statement in certain queries.

Created Views to restrict access to data in tables for security.

Created Indexes on selective columns to speed up queries and analysis using SQL Server Management Studio (SSMS).

Direct and/or execute the technical characteristics of the overall strategy of the Data Warehouse and ETL process using SSIS and Azure Data Factory (ADF).

Installed and Configured On-premises Data Gateway (Standard Mode) for Power BI Service.

Published Reports, Dashboards and Semantic Models using Power BI Service.

Actively participated in interaction with users, Team Lead, DBAs and Technical Manager to fully understand the requirements of the system.

Used Joins, Correlated and Non-Correlated Subqueries for complex business queries involving multiple tables from different databases and implemented Triggers and Stored Procedures and enforced business rules via Checks and Constraints.

Worked closely with IT and Business groups to understand business reporting requirements, analyze logical models and develop subject matter expertise in a short time.

Architected the database schema and implemented Relational (for ODS) and Dimensional Models (Star Schema). Reviewed and maintained schema, tables, indexes, views and T-SQL Stored Procedures in Microsoft SQL Server 2022/2019.

Participated in development and execution of tactics and strategies to optimize data quality in Data Warehouse and OLAP environments using SSAS Tabular Models and Power BI Semantic Models.

Created and designed Logical and Physical Data Models using ERwin Data Modeler, identified entities and relationships, defined project informational needs, and designed Source-to-Target Mapping as per client requirements and business rules to load data from ODS to Data Warehouse.

Mapped source system data elements to target systems and developed, tested and supported Extraction, Transformation and Load (ETL) processes by defining mappings, packages, pipelines and workflows using SSIS and Azure Data Factory (ADF).

Led the application development team in providing support and maintenance of Data Marts and Data Warehouses. Maintained the integrity of data movement into the Data Warehouse and other environments.

Facilitated Joint Application Development (JAD) sessions for gathering requirements for building Data Warehouses and Data Marts.

Defined and captured metadata and business rules associated with ETL processes.

Reviewed and analyzed database performance, SSAS Tabular Models, and reports generated using SQL Server Reporting Services (SSRS) and Power BI.

Environment: Microsoft SQL Server 2022/2019/2017/2016, Azure SQL Database, SSIS, Azure Data Factory (ADF), Power BI Desktop, Power BI Service, SSRS, SSAS (Tabular & Multidimensional), SQL Server Management Studio (SSMS), Visual Studio 2022, Azure Data Studio, Git, Azure DevOps, Python 3.12, Microsoft Azure Portal, XML, JSON, HTML5, JavaScript (ES6+).

Client: Cognizant, India Mar 2011- May 2017

Role: Database Developer

Responsibilities:

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.

Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.

Published reports and dashboards using Power BI.

Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.

Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.

Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.

Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and TSQL procedures in SQL SERVER 2019.

Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments

Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow

Defines and captures metadata and rules associated with ETL processes

Review and analyse database performance, cubes and reports generated using SQL SERVER 2019 Reporting Services.

Environment: SQL Server 2016/2019, SSIS, Power BI Desktop, Power BI Web, GitHub, Python 3.11, Azure Portal, XML, HTML.

Contact this candidate