Power Bi Sql Server

Education

SHUBHANG GUDDETI

Houston, TX +1-949-***-**** ********.**********@*****.*** linkedin

•University of Dayton, Dayton, Ohio Aug 2021 - May 2023

Master of Science in Computer Science and Engineering GPA: 3.54/4.0

•GITAM University, Bengaluru, India Jun 2016 - Aug 2020

Bachelor of Technology in Computer Science and Engineering GPA: 3.0/4.0

Skills

ETL Tools: Talend Suite 5.x/6.x, Informatica 7.x/8.x/9.x, SQL Server Integration Services (SSIS)

BI Tools: SSRS, Power BI, Tableau, SSAS, QlikView, Business Objects, Crystal Reports

Data Quality Tools: DataFlux, Trillium, Talend EDQ, Oracle Enterprise Data Quality (OEDQ), Informatica IDQ

Software Tools: Embarcadero DB Artisan, Rapid SQL, Toad, TAC, Autosys, Control-M, Power Builder, Oracle Forms & Reports, Sybase Open Client, SQL*Loader, SQL*Plus, Erwin, ER Studio, Power Designer, Visual Source Safe, ClearCase, WinRunner, MS Office, MS Project, Visio.

Programming Languages: SQL, PL/SQL, TSQL, Transact SQL, NoSQL, SAS, Unix Shell Scripts, VBA, VB Script, VB 5.x/6.x, Excel Macros, C, XML, HTML, XUL

Operating Systems: Sun Solaris, Linux, Windows NT, HP - UX, UNIX, MS-DOS, Mac OS X

Work Experience

•Power BI/ Data Analyst Equifax Atlanta GA. Jul 2023 - Present

Developed and maintained critical compliance test analysis documents and Business Requirement Documents (BRD), ensuring alignment with business needs.

Designed and optimized complex SQL queries, user functions, stored procedures, Common Expressions (CEs), views, and indexes, along with creating schemas and tables using SSMS 2018.

Performed normalization and de-normalization of database tables to enhance query performance.

Executed advanced SQL queries using DML and DDL statements to extract, transform, and analyze large datasets from multiple sources in MS SQL and Teradata SQL Assistant.

Experience in Data Analysis, understanding trends and patterns in data.

Designed and developed SSIS (SQL Server Integration Services) packages for extracting, transforming, and loading (ETL) data from diverse sources such as Excel and flat files into MS SQL Server.

Utilized various SSIS transformations including Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task, and Send Mail Task.

Implemented SSIS error/failure handling with event handlers, row redirects, and logging mechanisms.

Developed SSIS packages for dynamic deployment across Development, Testing, and Production environments.

Designed and configured OLAP Cubes (Star Schema and Snowflake Schema) using SQL Server Analysis Services (SSAS).

Developed interactive data visualizations and dashboards using Power BI and Tableau for improved decision-making.

Worked extensively on SSAS storage, partitions, aggregations, and MDX queries for data analysis and reporting.

Created KPIs, partitions, perspectives, and calculated measures using DAX queries.

Designed dashboards and ad-hoc reports using MS Power BI and SSRS to support executive management analysis.

Wrote calculated columns and measured queries using DAX in Power BI to show good data analysis techniques.

Involved in the scorecard and KPI Reporting.

Designed Tableau and Power BI dashboards to visually represent MTD sales growth, injury analytics, dealer location maps, and other business insights.

Worked on various visualization techniques in Tableau like Scatter Plots, Histogram, and Heat Maps.

Created different tabular reports using Power BI features and enhanced them based on user requirements.

Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

Installed and configured on-premises gateway for Power BI services to facilitate data refresh and connectivity.

Scheduled automatic data refresh in Power BI services to ensure up-to-date reports.

Maintained and enhanced existing Power BI reports by fixing bugs and adding new functionalities as needed.

Published dashboards on an intranet site using SharePoint Server.

Collaborated with stakeholders from various business units to independently validate and approve compliance tests.

•Power BI/ Data Analyst Delta Airlines Atlanta GA. Mar 2022 - May 2023

Collaborated with DBAs to design and develop databases and data warehouses, ensuring optimal installation, configuration, performance tuning, optimization, backup, and recovery in SQL Server.

Created and managed database objects, including tables, stored procedures, views, functions, triggers, and user profiles in SQL Server.

Utilized SQL Profiler and Query Analyzer to monitor and enhance SQL Server performance by tracing and optimizing queries.

Developed simple or complex cubes in SSAS SQL Server Analysis Services with Dimension table and Fact table either form of Star schema or Snow-flex schema.

Worked on developing cubes with Derived column, Aggregation, and KPI for decision-making, Prospective, measures, and hierarchy.

Developed and executed MDX queries to retrieve data from SSAS cubes for SSRS (SQL Server Reporting Services) reports.

Proficient in creating ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL servers, and transforming it using different transformations such as Lookup, Fuzzy lookup, and Slowly Changing Dimension SCD.

Designed and developed reports in SSRS, including tabular, matrix, drill-down, drill-through, cascading, and map reports.

Created Ad-hoc reports and reports with complex formulas based on managers’ or client requirements.

Managed report deployment, subscription services, snapshots, and report caching in SSRS.

Implemented advanced error-handling mechanisms in SSIS packages, utilizing checkpoints, breakpoints, data viewers, and security measures to ensure dynamic execution.

In-depth knowledge of working and implementation of Crystal reports 9.0, Converting Crystal reports to SSRS SQL Server Reporting Services.

•BI Analyst/ Data Analyst Target Corporations India. Nov 2019 - Jul 2021

The project involved upgrading the current SMART system for Confidential from a legacy system to a web-based application and creating reports and dashboards.

Contributed to various phases of the solution development lifecycle, including database architecture design and the establishment of development and testing guidelines.

Participated in daily stand-ups, sprint planning sprint reviews, and sprint retrospectives regularly reviewed tasks and user stories, and provided estimates in JIRA.

Interacted with the users and conducted meetings to understand the report requirements, to know their Business views and the level of detail needed by them, and worked on data mappings.

Conducted proof-of-concept analyses to determine the most suitable reporting platform, developing report mock-ups for user demonstrations and requirement finalization.

Created multiple SSIS packages to import data from the legacy (mainframe) system, Oracle, and Mongo DB to target SQL Server DB for report consumption and other uses.

Performed data analysis, data quality assessment, and profiling to identify anomalies and ensure data accuracy by scrubbing and cleansing the data.

Developed SQL scripts, stored procedures, common table expressions (CTEs), functions, and ETL flows to extract, transform, and load historical data into target tables, including data lakes and data marts.

Created complex SSRS and Power BI reports that efficiently process high-volume data with response times of just a few seconds, pulling data from SQL Server and MongoDB.

Developed interactive Power BI and SSRS reports for supervisors and managers, allowing them to track work status and shift allocations at location, district, and borough levels.

Generated periodic reports based on statistical data analysis from various time frames and divisions using SQL Server Reporting Services (SSRS).

Configured data refresh schedules for SSRS reports on a weekly and monthly basis to ensure accurate and up-to-date data views.

Created multiple Power BI dashboards and data visualization reports for DSNY supervisors and users to give them zone-wise availability of the resources.

Generated dashboards with key indicators for the daily planning team to enable them to plan the resources, in terms of tasks, routes, personnel, and their allocations.

Utilized Power Query in Power BI to extract data from external sources and transform it into the required format for dashboard consumption.

Deployed SSRS reports and published Power BI dashboards, managing user roles and access privileges to ensure appropriate report distribution.

Involved in performance tuning and optimization of complex SQL queries and stored procedures. Created appropriate indexes, and scheduled jobs for updating stats on the tables to keep the queries efficient.

Troubleshoot issues and collaborate with QA and other teams for bug fixes and report deployment. Maintained task tracking for bug resolutions, improving development turnaround time.

Engaged in the end-to-end process of designing, developing, testing, and supporting BI reports, including debugging, monitoring, and resolving performance issues during releases and weekly runs.

Certifications And Publications

•AWS Certified Cloud Practitioner Amazon Web Services Feb 2024

•Published a paper on Malignant Hub Discovery and Insulation for Remote Sensor Networks in IJAST, Volume 29. No. 5, (2020)

Contact this candidate