Home

Sai Sumanth - Power BI Resume

[email protected]

Location: Atlanta, Georgia, USA

Relocation: Yes

Visa: GC

Sumanth Oddi Power BI Developer Contact No: 978-622-7143 [email protected] | PROFESSIONAL SUMMARY: Over 8+ years of experience working on projects with extensive usage of ETL & reporting tools like Power BI, SSIS, SQL server reporting service (SSRS) in diverse roles across the organizational hierarchy. Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals. Good Experience with power automate. Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items. Experience in configuration and maintain report manager and report server for SSRS deployed and scheduled the reports in report manager. Power BI Tools power bi desktop, power pivot, power query, power view, power map, power bi dashboard, calculated columns and calculated measures using DAX, data modelling, power apps. Use DAX (Data Analysis Expressions) and MDX functions for the creation of calculations and Measures in the Tabular Models and Multi-Dimensional Models. Creating SSAS Cube from Scratch and involved in end-to-end development. Working Knowledge on Power Bi Reports. Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Worked on Power BI which acts like a cloud service that works with Excel to provide a Self-Service BI. Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending. Familiar with DAX Functions Such as Time-Intelligence functions, Date and Time Functions, Filter Functions, Information Functions, Statistical Functions and Text Functions. Experienced in client requirement Analysis, Physical, Logical design, development Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2019/2017/2016. Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014. Expert in designing Data Marts for different Business Subject Areas using STAR and SNOWFLAKE schema. Experienced in database Installation, configuration, maintenance, monitoring, and SQL jobs. Expertise in creating and maintaining Workspace and Gateways. Expert on maintaining and managing POWER BI driven reports and dashboards. strong understanding of managerial and professional skill sets. Extracted data from Azure SQL Server for reporting and to facilitate sharing between multiple data systems. Experienced in ERP system such as Oracle, SQL Server, and Azure SQL Server. Extract the data from different sources and cleanse the data. TECHNICL SKILLS: Database: SQL Server 2019, 2017, 2016, 2014, JSON,Oracle DB 11g/12g SDLC: Agile, Scrum, Waterfall, and Spiral Data Modeling: MS Visio, Erwin, D3M Database Programming: T-SQL, Dynamic SQL, Oracle SQL Development Tools: SSDT, SSMS Reporting Tools: Power BI, Excel Power BI Source Control & Collaboration Tool: JIRA, SharePoint, Power BI Service, IBM Lotus Notes ETL Tool: TSQL, Power Query Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouse WORK EXPERIENCE: Client: BCBSA, Chicago, IL June 2021 Current Role: Power BI Developer Responsibilities: Coordinating with business users in analyzing business requirements and translating them to technical specifications. Developed dashboards and ad-hoc reports using MS Power BI and SSRS for the senior management team for analysis. Using SSIS Package, identified the upstreams and imported the required tables into the intake database, Stored Procedures are created in the staging database using the intake database tables. Good Experience with power automate. Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016. Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services. Design data model and creating the schema on Azure SQL. Good grasp of database concepts, structures, storage theories, practices, or principles. Hands-on expertise in SQL reporting, development, analytics, or BI. Relevant experience in processing flowcharts or data flow diagrams used various sources to pull data into Power BI such as SQL Server, Dynamics CRM, Oracle, SQL Azure, etc. Created many complex Query and used them in Power BI Reports directly to generate reports on the fly. Incorporated complex business logic by writing complex SQL procedures and functions. Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data. Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets. Checking the code into TFS (Stored Procedures, Views, Tables, Schema) for the deployment process for the production environment Published Power BI Reports in the required origination and made Power BI Dashboards available in Web clients and mobile apps. Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data. Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI. Created KPI s, Partitions, Perspectives, and Calculated Measures, used DAX queries, and Roles. Implement the SAP Business Objects reporting requirement. Responsible for deploying the application for the Integration, Functional, and User Acceptance Testing. Adheres to department, organization and industry guidelines, standards, policies, and procedures. Tools & Environment: SQL Server 2014, T-SQL, SSDT, SQL Profiler, OneDrive, MS Visio, Windows Server, Power BI Desktop, Power BI Pro, SharePoint, MS Azure Client: Change healthcare, Nashville, TN April 2019 - June 2021 Role: Power BI Developer Responsibilities: Interpreted business requirements from JRD sessions to technical and function specifications. Participated in converting business requirements into specification documents. Collected, stored, and retrieved business data for analysis and reporting purposes. Involved in developing stored procedures, triggers, and SQL scripts for performing automation tasks. Proactively monitored, determined, and solved issues at SQL/database/server levels. Widely worked on to improve SQL query performance, SQL query analytics and highly complex joins to populate the desired result set. Extensively worked on table design creating clustered indexes, non-clustered indexes, primary key, foreign key, highly complex joins and SQL scripts for views and materialized views. Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements. Extensively used joins to simplify complex queries/sub queries involving multiple tables also optimized the procedures and indexes, cursers and triggers. Used Many tools to manage and utilize data like SSIS, SSRS, and SSAS Contributed in building ad-hoc reports. Created dashboards in line with analytical uniformity using the advanced analysis features of Power BI Desktop. Created measures and calculated columns utilizing DAX in Power BI to answer business questions. Performed time series analysis using DAX expressions in Power BI. Worked with table, matrix visuals and different levels of filters. Created highly interactive data visualization, graphs and charts using RDBMS. Deployed the Power BI reports to Power BI services and pinned visuals to make dashboards out of it. Shared dashboards and reports with user groups by using Power BI App and content packs. Formulated complicated reports like parameter-based reports, graphical reports, drill-down chart using Power BI. Created Static and Dynamic Row-Level-Security in Power BI Desktop and assigned roles to users via service. Created Power BI template files and gave input parameters to the file for filtering the entire report accordingly. Provided subscriptions for dashboards in Power BI Service. Tools & Environment: SQL Server 2016, SSMS, T-SQL, Power BI Desktop, Power BI Pro, DAX, Erwin, SQL Profiler, Azure Data Warehouse, Agile, Google Analytics Client: Nordstrom, Seattle, WA Jan 2017 April 2019 Role: SQL Server BI Developer Responsibilities: Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager. Created reports by retrieving the data from cube using MDX reports. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages. Designed high-level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS. Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server. Set package configuration in SSIS to redirect path from test environment to production environment. Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS. Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services. Experience in creating complex SSIS packages using proper control and data flow elements with error handling. Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS. Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various. Prepared the complete data mapping and Report Definitions for the project, which involved around 33 reports. Developed functions, procedures, and packages to implement the system's business logic using SQL. Involved in the design phase of the development. Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables. Handled the responsibility for the physical as well as logical design on the storage media. Analyzed data access controls and provided suggestions in enhancing the security. Created and managed the database triggers and subprograms and executing complex queries. Tools & Environment: SQL Server 2012, T-SQL, SSMS, SQL Profiler, Windows Server, JIRA, Erwin Client: Gold Stone Technologies, Hyderabad, India January 2016 December 2016 Role: SQL Developer Responsibilities: Involved in creating Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which were also passed on to the application via Stored Procedures. Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedure and maximized the readability of such Stored Procedures. Created DDL/DML triggers in SQL Server 2005/2008. Designed T-SQL scripts to identify long running queries and blocking sessions Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions Data migration (import & export BCP) from Text to SQL Server. Error handling using Try-Catch Block Normalization and De-Normalization of tables Developed Backup and Restore scripts for SQL Server 2005 Installed and Configured SQL Server 2005 with latest service packs. Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions Written T-SQL queries for the retrieval of the data. Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures. Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration. Tools & Environment: SQL Server 2000 Enterprise Edition, MS SQL Server 2005, T-SQL, Enterprise manager, VBS, MSOffice Keywords: business intelligence database active directory information technology trade national microsoft Delaware Illinois Tennessee Washington