Sql Server Power Bi

SAI THARUN S

Phone: +1-203-***-****

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

LinkedIn: https://www.linkedin.com/in/sai-tharun-s-0940b6206/

PROFESSIONAL SUMMARY:

Over 9+ years of extensive experience in Power BI and SQL, specializing in Data Modeling, Database Design, Programming, Development, and Implementation of Client-Server Applications & Database systems across various versions of SQL Server (2008/2008R2/2012/2014/2016/2019).

Proficient in utilizing BI stack tools including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI for comprehensive data analytics and visualization.

Expertise in PL-SQL/T-SQL (DDL and DML) with a strong focus on SSIS, SSAS, and SSRS, ensuring efficient data processing and reporting capabilities.

Skilled in Extract, Transform and Load (ETL) processes using MS-SSIS, DTS application tools, and data migration techniques for seamless transitions between heterogeneous systems.

Proficient in configuring SQL Server packages dynamically to optimize SSIS package performance.

Experienced in creating custom SQL Server reports using SSRS (2012/2008R2) and designing efficient stored procedures, views, functions, and joins for complex queries.

Hands-on experience in Data Warehousing principles including Fact Tables, Dimension Tables, Star Schema modeling, and maintaining referential integrity.

Expertise in Power BI Designer with Power Pivot for Excel, Power View, and DAX for advanced data visualization and analysis.

Skilled in designing and maintaining Cubes, Dimensions, Data source views, and Data mining Models using SSAS, with proficiency in writing MDX queries for multidimensional data analysis.

Extensive experience in SQL Job creation and scheduling using SQL Server Agent for various administrative tasks.

Proven track record in system analysis, design, development, testing, and implementation (SDLC), both independently and as part of a proactive team.

Strong ability to assess client needs, propose efficiency-enhancing solutions, implement technology solutions, and provide end-user training.

Excellent analytical, communication, and interpersonal skills, coupled with proficiency in technical writing and presentations.

A dedicated team player with a commitment to delivering high-quality results and driving continuous improvement initiatives.

TECHNICAL SKILLS:

Databases

SQL Server 2008/2008R2/2012/2014/2016/2019, Oracle, MS Access

Operating Systems

Win XP/Vista/7/10

Microsoft Tools

Management Studio (SSMS), Business Intelligence Development Studio (BIDS).

Programming Skills

T-SQL

ETL Tools

SQL Server Integration Services (SSIS)

Reporting

Microsoft SQL Server Reporting Services (SSRS), Power BI

Data Modeling

Star Schema Modeling, FACT, Dimensions Tables, Physical, Logical and Conceptual Data Modeling, Erwin.

Scheduling Tools

Windows scheduler, SQL Server Agent, Maestro etc.

PROFESSIONAL EXPERIENCE:

Client: Macys, Atlanta GA

Duration: May 2022 – till date

Role: SQL/SSIS Developer

Responsibilities:

Interfaced with various systems for data extractions, ETL, analytics, and reporting.

Served as the primary contact for data processes, mappings, pulls, and reporting solutions.

Created SSIS packages for ETL operations, facilitating local database reporting.

Developed SQL Server Agent Jobs to schedule and maintain SSIS packages.

Wrote complex queries, stored procedures, and T-SQL joins for reporting needs.

Automated maintenance jobs, tuned SQL Server, configured indexes, and managed SQL Server security.

Designed SSIS packages using Control Flow, Sequence Container, Dataflow Task, Execute SQL Task, and Script Task.

Migrated data from text files, Excel, and Access to SQL Server databases using SSIS.

Extracted data into an intermediate staging database using SSIS ETL tool.

Coordinated with source system owners for day-to-day ETL progress and monitored data warehouse schema design.

Transformed complex business requirements into ETL processes using various transformations like Aggregate, Derived Column, and Lookup.

Created and maintained SQL Server reports with SSRS 2012, including drilldown and summary reports.

Connected to data lake Hive using Cloudera ODBC Driver for Apache Hive within SSIS packages.

Developed custom SQL, T-SQL, stored procedures, functions, and triggers for capturing updated and deleted data.

Designed ETL packages to pull data from various sources into Data Marts and the Enterprise Data Warehouse (EDW).

Environment: MS SQL Server 2016/2018/2019, Business Intelligence Development Studio (BIDS), T- SQL, SQL Server Agent, Azure DevOps, SSIS, Power BI

Client: CVS Health, Providence - RI Duration: Jan 2021 – Apr 2022

Role: SQL BI Developer/ETL

Responsibilities:

Created ETL packages with various data sources (SQL Server, Flat Files, Excel, XML) and performed transformations using SSIS.

Published Power BI Desktop models to Power BI Service, creating informative dashboards and collaborating through workspaces and apps.

Implemented filters, slicers, and conditional formatting in Power BI to enhance user interaction and highlight key data.

Created notifications, alerts, and report subscriptions in Power BI Service.

Developed complex ad-hoc reports, sub-reports, linked reports, charts, drill-through, and drill-down reports.

Managed user security and roles in Power BI.

Built reports in Power BI from scratch and modified visualizations per client requests.

Created calculated columns and measures in Power BI and Excel using DAX queries.

Published Power BI reports on dashboards in Power BI Server and integrated Power BI App with SharePoint.

Assigned access permissions and security levels for reports in Power BI.

Designed, developed, tested, and deployed ELT/ETL pipelines using Azure Data Factory.

Developed complex ETL pipelines for full and incremental data loads into a SQL Data Warehouse.

Designed, developed, and deployed reports using Microsoft SQL Server Reporting Services (SSRS).

Created parameterized reports with single and multi-valued parameters and generated drilldown and drill-through reports in SSRS.

Worked on data migration from PostgreSQL to MSSQL and performed various transformations in SSIS, including Slowly Changing Dimensions, Lookup, Merge, and more.

Environment: MS SQL Server 2016/2018/2019, Business Intelligence Development Studio (BIDS), PostgreSQL PL-SQL, T-SQL, SQL Server Agent, Azure Cloud, SSIS, Azure SQL Database, Azure Data Lake, Power BI,

Client: State of NY, NY Duration: Jun 2019 – Dec 2020

Role: SQL/ETL/Power-BI Developer

Responsibilities:

Developed user interface designs and ensured usability, accessibility, and aesthetic alignment with organizational requirements.

Interpreted and implemented design guidance, documenting decision points for future reference.

Collaborated with multiple teams to refine requirements and iterate on design alternatives for consistency.

Applied graphic design UI/UX skills to enhance site usability and support change management.

Ensured a consistent user experience across interfaces, web browsers, and devices.

Optimized existing user interface designs and communicated with stakeholders to ensure intuitive and useful dashboards.

Designed page layouts and navigations, presenting designs and usability strategies to clients and management.

Fetched data from sources like SharePoint and loaded data from Excel, Flat Files, XML, and various databases.

Developed Power BI graphical and visualization solutions based on business requirements for interactive dashboards.

Created Microsoft Power BI dashboards to display data analysis results.

Created MDX, DAX, cubes, and tabular models using SQL Analysis Services (SSAS) and various Power BI visualizations.

Generated Power BI dashboards using advanced data visualization features.

Integrated custom visuals in Power BI Desktop to enhance information clarity.

Designed technology roadmap for Power BI, including installation, implementation, and development of dashboards.

Created interactive data visualizations in Power BI using relational and aggregate data sources, incorporating complex dashboards, filters, and actions.

Environment: MS SQL Server 2012/2014/2016/2018, Power BI and Tableau Desktop v2019.1, MS Office Suite, PL/SQL, MS Excel, SQL Server Management Studio (SSMS), Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, and SSIS.

Client: Centene, St. Louis MO

Duration: Jan 2017 – May 2019

Role: SQL/ETL Developer

Responsibilities:

Developed and optimized stored procedures, views, and user-defined functions for applications.

Created physical data models and DML scripts for database schema and object creation.

Managed SQL Server 2008 Server Group, enabling T-SQL queries across multiple servers from a central server.

Debugged stored procedures to handle errors effectively.

Employed Transparent Data Encryption in SQL Server 2008 for secure data storage.

Developed custom scripts and stored procedures for data import and manipulation.

Implemented Full Text Search for efficient querying of large, unstructured data.

Created ETL packages using SSIS to validate, extract, transform, and load data to data warehouses and data marts.

Migrated data from heterogeneous sources and legacy systems (DB2, Access, Excel) to SQL Server using SSIS.

Implemented incremental loads and used event handlers for data cleaning from various sources.

Generated periodic reports using SSRS based on statistical analysis of data from various time frames and divisions.

Developed operational drill-through and drill-down reports using SSRS.

Created various report types, including sub-reports, charts, matrix reports, and linked reports, using cascaded parameters.

Optimized queries to enhance report performance and developed reports using Report Builder.

Analyzed, designed, built, and tested OLAP cubes with SSAS 2005 and collaborated with DBAs to maintain databases, including using DBCC statements for maintenance tasks.

Environment: SQL Server 2000/2005/2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS visual Studio, BIDS.

Client: IGATE Global Solutions, India

Duration: July 2014 – Oct 2016

Role: MS SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

Collected business requirements from users and translated them into technical specifications and design documents.

Developed complex stored procedures, triggers, functions, indexes, tables, views, and other PL-SQL/T-SQL code for applications.

Utilized PL-SQL/T-SQL to construct user functions, views, indexes, user profiles, relational database models, data dictionaries, and ensure data integrity.

Optimized logic in procedures, functions, and triggers for peak performance.

Extensively used SSIS to move data from text files to SQL Server.

Created views using T-SQL in development and production environments for SQL Server 2008.

Generated Quality Assurance statistics reports using SSRS.

Built dimensional cubes with SQL Server Analysis Services (SSAS) and queried data with MDX scripts.

Implemented SQL Server OLAP services (SSAS) for building data cubes.

Defined MDX scripts for querying data from OLAP cubes (SSAS) and built reports on top of cubes.

Published and managed report subscriptions in SharePoint.

Created SSIS packages for new projects using Business Intelligence Development.

Wrote complex stored procedures to meet business requirements.

Used SQL Profiler for estimating slow-running queries and performance tuning.

Applied data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, and Derived Column.

Created data sources, connection strings, and defined datasets for generating reports.

Environment: MS SQL Server 2008/2008R2/2012/2014, Windows XP/Windows 7, Excel, T-SQL, PL- SQL, Microsoft Visual Studio, SQL Server Reporting Services (SSRS), SQL Server integration services (SSIS), SQL Server Analysis Services (SSAS), SharePoint, Import Export Wizard.

Contact this candidate