Power Bi Sql Server

Srujan Kumar Guddeti

SQL Developer/Data Analyst

913-***-****/ ***********.******@*****.***

Professional summary:

Over 5 years of experience in database design, development, and administration using MS SQL Server (2012-2019). Skilled in T-SQL, SSIS ETL, performance tuning, and developing complex stored procedures, triggers, and functions. Proficient in managing SQL Server Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), and business intelligence tools like Power BI, QlikView, and Tableau. Expertise includes building and deploying MSBI solutions, optimizing queries, creating MDX queries, and developing data-driven dashboards. Strong background in troubleshooting, migrating data across SQL Server versions, and automating workflows using PowerShell and Azure tools.

Additionally, experienced in integrating Microsoft Dynamics 365, a cloud-based suite of enterprise resource planning (ERP) and customer relationship management (CRM) tools, to streamline business processes and enhance customer service operations. Knowledgeable in leveraging Power Apps to build custom business applications without extensive coding, improving efficiency by automating workflows and delivering real-time insights through interactive apps.

Technical Skills:

Data Warehousing & BI

SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Azure SQL, Microsoft Dynamics CRM, Power Apps

Reporting Tools

SSRS 2019/2017/2016/2014/2012, Excel, Tableau, Power BI, Power Apps

Database

MS SQL Server 2016/2014, Oracle, MS-ACCESS, Microsoft Dynamics CRM

Programming

C, C++, TSQL, DAX, MDX, Power Fx.

IT Processes

Software Development Life Cycle (SDLC), Project Management

Productivity Applications

MS Word, MS Excel, MS Access, MS Project, Visio

Operating System

Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX

Aws Application Servers

Microsoft IIS 6.0/5.0/4.0, Apache.

Developer Tools

Informatica Power Center, Informatica IDQ, SSIS, Cognos Analytics, SSMS, Power Apps Studio, Dynamics 365 Customization Tools

Work Experience:

Anthem, Atlanta, GA July 2023 - Present

Role: Data Analyst

Responsibilities:

Developed PowerBI reports to deliver metrics for the supply chain data analytics implementation, utilizing DAX, Power Query, and SQL queries.

Proficient in writing advanced DAX functions in Power BI and Power Pivot.

Collected report requirements and identified the optimal solutions for delivering results through Reporting Services reports or Tableau.

Enhanced SSIS performance by tuning using counters, error handling, event handling, and re-running failed SSIS packages with checkpoints.

Employed Python for data analysis and visualization, working with libraries such as NumPy, Matplotlib, Seaborn, and pandas.

Analyzed and presented data to aid the company's decision-making process using Power BI tools and DAX queries.

Integrated data into Power BI from sources such as SQL Server, SAP BW, Oracle, and SQL Azure.

Created calculated columns and measures in Power BI using DAX queries, based on report requirements.

Troubleshot SQL codes, SSIS packages, and SSRS as needed. Collaborated with team members throughout the software development life cycle (SDLC), including business analysis, design, development, testing, and documentation.

Generated computed columns and tables in Power BI using advanced DAX features.

Deployed and enhanced SSIS packages from development to production servers, scheduling jobs to execute stored SSIS packages for daily, weekly, and monthly database updates.

Published reports and dashboards using Power BI. Created computed columns and tables in Power BI using DAX.

Worked with Azure Databricks for ETL solutions, handling large volumes of data, and conducting data analysis.

Utilized Spotfire to transform and pivot data before building visualizations, and wrote back data from TIBCO Spotfire to implement security.

Conducted data analysis and built reports, deploying them into Power BI Service.

Shared Power BI reports and managed workspaces in Power BI Service.

Developed various report types including Tabular, Sub, Matrix, Drill-down, and Chart reports using SQL Server Reporting Services (SSRS).

Generated different types of reports such as Tabular, Matrix, Chart, and Graphs, and Ad-Hoc reports using MS SQL Reporting Services (SSRS).

Improved the speed and performance of Excel reports by approximately 40% by restructuring Power BI.

Used Power BI Gateway to ensure dashboards and reports were up-to-date with on-premise data sources.

Created stored procedures for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports. Demonstrated proficiency in generating on-demand and scheduled reports for business analysis and management decisions using SSRS 2016/2014/2012/2008.

Utilized Jira for process management and people management, including collaboration, working in an Agile team, client management, problem, and change management. Acted as a business analyst for certain assignments.

Environment: SQL Server 2019/2017/2016, ETL, SSIS, T-SQL, Power BI Gateway, Power BI Service, DAX, Python, Excel, Microsoft Power BI, SQL, No-SQL, Server Data Tools (SSDT)

Delta Dental July 2022 – June 2023

Role: Data Analyst

Responsibilities:

Led the design and development of the Sales Data Warehouse project, utilizing Informatica Power Center ETL, Teradata database, and MicroStrategy reporting tool.

Automated processes such as database backups and SSIS package execution using SQL Server Agent jobs.

Designed real-time data integration for the Data Warehouse by creating custom workflows and worklets in Informatica.

Developed complex mappings to transform data from source systems to the Data Warehouse.

Optimized SQL queries and performance using SQL Profiler for troubleshooting, monitoring, and T-SQL code optimization.

Utilized Microsoft Dynamics 365 CRM (Customer Service) to integrate customer service-related data, ensuring seamless access to customer interactions, support case management, and service insights for improved decision-making.

Developed and customized workflows in Dynamics 365 to enhance customer service operations, integrating them with backend systems and data warehouses.

Utilized SSRS to develop complex reports, including drill-through, ad-hoc reports, and scheduled reporting for business analysis.

Created stored procedures and optimized data sets for efficient reporting using SSRS and T-SQL.

Leveraged Power BI to visualize key metrics from Dynamics 365 CRM data and enhanced performance dashboards for tracking customer service KPIs.

Environment:

MS SQL Server 2016/2014, Microsoft Dynamics 365 CRM (Customer Service), SSRS, SSIS, Informatica, Teradata, Power BI, Python, T-SQL

Tech Media Solutions. India Sep 2019 - June 2021

Role: SQL Server Developer

Responsibilities:

Designed advanced SQL stored procedures utilizing Microsoft SQL Server 2014 and 2012.

Created SSIS ETL packages using data warehouse architecture by establishing fact tables and conforming dimensions.

Wrote SQL queries to retrieve complex data using inner and outer joins, subqueries, CTEs, and tally tables, handling intricate filters and database links.

Proficient in data modeling, employing dimensional, star schema, and snowflake modeling with tools like Erwin.

Developed reports using SSRS 2014 and 2016.

Built SSIS-ETL packages to load data into a data warehouse using various tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, File System Task, and Execute Package Task.

Devised SSIS packages for other SQL Server instances in SSIS 2014.

Managed data transfers from remote server files to folders on another server using FTP.

Developed OLAP cubes for data mining and created reports from these cubes.

Generated reports by connecting to the Analysis server from SSRS.

Developed SSIS packages to transform data from SQL 2014 to MS SQL 2014 and created interface stored procedures used in SSIS to load and transform data into the database.

Created various reports using SSRS, including writing intricate stored procedures for datasets.

Produced snapshots of static reports and configured subscriptions.

Designed complex SSIS-ETL packages with appropriate control and data flow elements.

Developed and extended OLAP cubes, dimensions, and data source views.

Extracted data from different sources (CSV files, MS SQL 2018) and stored it in an intermediate staging database using the SSIS ETL tool.

Transformed data from the staging database using Data Flow Tasks.

Crafted complex stored procedures using T-SQL to generate ad hoc reports with SSRS.

Prepared daily, weekly, and monthly reports in various formats, such as MS Excel, PDF, HTML, and XML.

Environment: SQL Server, Business Intelligence Studio (SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, MS Excel.

Education:

University of Central Missouri – Warrensburg, Missouri

Master of Science: Information Technology

Course work: Focused on Data management, Data analysis, SQL, Python, Data visualization, Power BI, Tableau.

Lovely Professional University- Punjab, India

Bachelor of Technology – Computer Science

Coursework- Database management systems, C, python, Data analytics

Contact this candidate