Home

SHIRISH - Power BI

[email protected]

Location: Remote, Remote, USA

Relocation:

Visa:

Resume file: Shirish_POWER BI DEVELOPER_1744313243231.pdf Please check the file(s) for viruses. Files are checked manually and then made available for download.

SHIRISH T Sr. POWER BI DEVELOPER / POWER BI ARCHITECT SQL/BI Developer (Power BI Focus) Phone: +1(469)-639-0138 | Email: [email protected] PROFESSIONAL SUMMARY Highly motivated SQL server/BI Lead with 9+ years of IT experience having multiple skill set and extensive working experience in data warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft - managed data centers. Experience in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs). Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications using SQL Server, SSIS and SSRS. Designed a website using an HTML editor and employing Java and ASP.NET code for various sites functionality. Expert database engineer, NoSQL and relational data modeling using Microsoft Sql Server. Having good knowledge on Teradata architecture, database features and Teradata tools. Extensive knowledge of data warehouse methodologies. Proficiency in Database design, Coding, unit testing and Implementation. Strong ability to analyze user requirements, Business Requirement Specifications. Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. 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/2008R 2/2008/2005. Worked in Implementation life cycles of both Agile and Waterfall Methodologies. Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column. Extensive knowledge in Tuning T-SQL queries to improve the database performance. Performed data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server. Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements. Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages. Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL in SSRS. Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS). Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SQL Server Analysis Services (SSAS) on EDW. Experienced in SSAS Tabular data modeling. Built a data warehouse on SQL Server & Azure Database. Involved in importing data from large RDBMS systems to Hadoop using Sqoop. Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources. Created different Power BI reports utilizing the desktop and the online service and schedule refresh. Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and OnPremises gateway, connecting to data sources and adding the different users. Assisted customer in configuring and troubleshooting their row-level security for their company. Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data Experienced in developing Power BI reports and dashboards from multiple data sources using data blending. Experience in database development and release management concepts, practices and procedures along with performance tuning database code in OLTP and OLAP environments. Involved in performance tuning by checking the loads on Indexes by using sql profiler and Tuning advisor. Excellent knowledge of all the phases of Software Development Life Cycle (SDLC). Involved in keeping the team focused and on track and also established meeting times, places and agendas. Excellent written and verbal communication skills and ability to translate technical concepts into business language and business language into technical requirements. Involved in coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task. TECHNICAL SKILLS Databases: SQL Server, Oracle, Azure SQL Database, Teradata, NoSQL ETL Tools: SSIS, Informatica, Azure Data Factory BI Tools: Power BI (Desktop, Service, Gateway), SSRS, Tableau Data Modeling: Star Schema, Snowflake Schema, Dimensional Data Modeling, SSAS (Tabular and Multidimensional) Scripting Languages: T-SQL, DAX, MDX, JavaScript, Python Cloud Platforms: Azure Data Lake, Azure Data Factory, AWS Redshift Development Tools: Visual Studio, SQL Server Management Studio (SSMS), SQL Profiler Version Control & CI/CD: Git, Azure DevOps Other Skills: Performance Tuning, Data Migration, Report Automation, Row-Level Security (RLS), Power Query PROFESSIONAL EXPERIENCE Bank of America, Charlotte, NC Oct 2023 to Present Power BI/SQL Developer Responsibilities: Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process. Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript. Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data. Build GSHS Reports in Power BI from scratch. Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI. Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors. Created dashboard for school system financial information which includes revenue and expenditure by district. Developed custom Georgia district map visual, the SVG is written inline within a Bootstrap 2 container. Written some Java script plugin that makes the polygons work like hyperlinks. Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI. Used various sources to pull data into Power BI such as SQL Server, oracle. Involved in installation of Power BI Report Server. Developed reports to visually explore data and create an interactive report Excel and Power BI. Using a query editor in Power BI performed certain operations like fetching data from different file. Created groups, content packs. By using Power BI desktop connected to various data sources, working with different visualizations. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging Created several user roles and groups to the end - user and provided row level security to them. Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service. Worked on importing custom visualizations. Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters. Used various data visualizations with Power BI. Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements. Created Tabular model reports to slice and dice huge volumes of data. Using Tabular model provided more security to data at Row level. MDX programming, DAX expressions, analysis and business forecasts. Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets. Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop. Creating reports from importing, direct query and live data from several data sources. Experience in combining data from different sources by using of power query. Experience with, power pivot and dashboard designer. Troubleshoot and support reports in Power BI workspaces whenever there are issues in production. Environment: MS SQL Server 2018/2015, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle 11G, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2015, HTML5, Java Script. Wells Fargo, Charlotte, NC March 2021 to October 2023 Power BI/SQL Developer Responsibilities: Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. Generated periodic reports based on the statistical analysis of the data from various time frame and division using power pivot, power query, power view. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning. Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads. Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis. Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models. Designed/Developed table driven ETL process with Perl and shell scripts, which in turn calls OWB mappings, Informatica oracle code to load EDW. Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries. Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements. Experience in custom visuals and groups creation in Power BI. Experience in scheduling refresh of Power BI reports, hourly and on-demand. Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards. Working experience with column store indexes, table partitioning in SQL SERVER 2012. Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014. Hands on experience working with SSIS, for ETL process ensuring proper implementation of event handlers, loggings, checkpoints, transactions and package configurations. Designed high level ETL architecture for overall data transfer from the source server to the enterprise services warehouse. Worked in creating complex stored procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Experience in creating multidimensional cubes using SSAS and designing DW schemas. Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Experience in designing, building the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose. Performance tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, redesigning schemas and many more. Also, went through query execution plans, sql profilers and did query optimization. Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets and Power Pivot. Involved in performance tuning using indexing (Clustered Index, Non-Clustered Index) tables. Created different Power Pivot reports as per the client requirement. Converted the existing Azure Data Factory V1 to Azure Data Factory V2 and also implemented SSIS package in Azure environment using Integration Runtime (IR). Environment: MS SQL Server 2018R2, T-SQL, SQL Profiler, Visual Studio (2018), Power Bi Desktop, Team Foundation Server (2012), MS Analysis Services 2005, MS Reporting Services, MS Access, Import & Export Data, Oracle Warehouse Builder, Power Bi Desktop, Power Bi pro, Source Control Management System Windows XP, Index Tuning Wizard. NCDST (North Caroline Department of State Treasurer), Raleigh, NC Aug 2020 to Mar 2021 Power BI/SQL Developer Responsibilities: Used Power BI to create customized, on-demand reports & ad-hoc reports from Excel and involved in the automation process of the reports from the Corporate Data Models. Worked as Data Analyst to identify the sources and model the data for reporting. Worked in the Agile Methodology using the Microsoft VSTS leveraging the Scrum Process to finish the tasks in the Sprint time frame. Used Power BI s power query and power pivot functionality to transform and model the data. Designed and developed Power BI graphical solutions as per business objectives. Implemented several DAX functions for various fact calculations for efficient data visualization. Used time intelligence functions for time series analysis. Installed and configured enterprise gateway & personal gateway in Power BI Service to keep dashboards and reports up to date. Implemented Row Level Security. Designed various Landing pages related to different functions of the Product Line pointing to relevant dashboards using the specified templates. Involved in troubleshooting, resolving and validating data to improve data quality. Trained business users on leveraging reports and dashboards. Developed Analysis documentation for future for developers. Environment: Power BI Desktop, SQL, MS Excel, Python, python libraries (pandas, numpy, SciPY, MatPlotLib), AWS (S3, IAM, RedShift) Wells Fargo, Charlotte, NC Aug 2018 to Aug 2020 Power BI/SQL Developer Responsibilities: Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data. Created numerous efficient stored procedures to perform data cleansing and loading task when data is loaded into staging area. Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database. Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages. Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code. Created SSIS Packages to integrate data coming from Text files and Excel files. Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio. Created SSIS packages to validate, extract, transform and load data to data warehouse databases. Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and derived Column. Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts. Built connections to/pulling data from AS400, mainframe/db2 and Oracle. Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent. Implemented Event handlers and Error handling in SSIS packages and notified process results to various user communities. Tested, cleaned and standardized data meeting the business standards using fuzzy /exact lookups using SSIS tasks. Data management and data processing solutions using SSIS, this includes error handling and Slowly Changing Dimensions. Worked on database Compression for different databases to save space across different environments. Hands on experience in managing Azure Storage Accounts. Wrote many stored procedures for cleaning, manipulating and processing data between the databases. Extensively used Joins and Common table expressions to simplify complex queries involving multiple tables Developed complex stored procedures and views to generate various drill-through reports, parameterized reports and linked reports using SSRS. Created different Power Pivot reports as per the client requirement. Experience in creating multidimensional cubes using SSAS and designing DW schemas. Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS). Worked on filtered views and Base table integration between different Source systems. Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts. With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status. Scheduled the packages in SQL Server Agent on daily/weekly/monthly basis. Document new SSIS packages and train senior analyst on basic SSIS concepts. Interacted with vendors, developers and customers to manage the business requirements. Created pig scripts to the files landing in blobs to position the fields according to the third- party requirement. Extensive knowledge and hands on experience in azure data warehouse, data lake and data factory, U-SQL. Verified business requirements and functional specifications. Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Pig, Azure, SQL Profiler, T-SQL, Power Bi Desktop, Data Warehousing, Data Transformation Services (DTS). DXC Technologies, Conway, AR May 2015 to Aug 2018 MS SQL / SSRS / SSIS Developer RESPONSIBILITIES: Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in a given period. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager. Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008. Created reports using Global Variables, Expressions and Functions using SSRS 2008. Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers. Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub. Wrote T-SQL queries, created dynamic Stored Procedures by using input values. Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases. Applied monthly patches and hot fixes. Created Alerts for successful and unsuccessful completion of Scheduled Jobs. Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008. Designed and implemented Stored Procedures and Triggers for automating tasks. Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc. Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery. ENVIRONMENT: MS SQL server 2008, SSRS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2008, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL profiler. TriZetto (Cognizant), Phoenix, AZ Jan 2016 to May 2017 Role: SQL/SSIS Developer Responsibilities: Initially loaded data into staging tables from different source databases system using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into different Schema's. Create, analysis, design, implementation, development and validation 837P, 837I and 834 EDI transaction. Involved in claims adjudication process of FACETS application. Experience with Medicare and Medicaid (MMIS) claims processing, Medicaid billing, Medicare membership and eligibility verification and care management. FACETS support systems were used to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834 transactions. Worked with Facets TriZetto Batch Scheduling and monitored daily for updates in various domains Facets. Collect and analyze requirements from the clients to design suitable software for them. General data mapping of Claim Encounter EDI files 837I, 837P, 834 including coding, translation, development, testing and deployment. Programming, including writing T-SQL in SQL Server and SSIS packages, which supports export Claim Encounter EDI files. Written several SQL queries and analyzed them to validate the business rules in Oracle Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). Implemented SSIS data, created maintenance procedures and provided data integrity strategies. Knowledge of SQL server and the ability to design and develop against processed EDI data. Created ETL packages using SSIS to move data from various heterogeneous data sources. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization. Strong knowledge of Medicaid and Medicare transactions. Environment: .Net Framework 4.0, C#, ASP.Net, HTML, VBNET, JavaScript, CSS, XML, XSLT, AJAX 2.0, ADO.Net, Web Service, WPF, HTML5, TFS, jQuery, WCF, SQL Server 2008, SSRS, TFS, Web Forms, IIS, TFS, Windows Server XP clients, Visual Studio 2008, Microsoft Office. Accenture, Hyderabad, India Jan 2013 to Dec 2014 Role: SQL Developer/SSIS Developer Responsibilities: Analyzed and implemented an enhancement for an existing data mart by adding new dimensions and fact tables. Used SSIS ETL system to bring the data together from different systems including text files, spreadsheets, SQL server and Oracle databases. Developed SQL queries, functions, stored procedures and triggers to perform the backend testing Of data Writing PL/SQL Procedures & Batch Processes Used Model, Database and Code First approaches in the Entity Framework. Developed various database queries and Stored Procedures using SQL Server and T-SQL. Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. Managed the daily scheduled run of the jobs for the data mart to ensure that data is available for the business and marketing analyst first time in the morning. Developed unit testing strategies for the ETL processes and provided improvement suggestions on requirements for business users. Implemented error handling and roll back process in ETL load. Configured SSIS packages using Package configuration wizard to allow packages run on different environments. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases Used to remove the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS. Creation of information and process flow diagrams as well as data flow diagrams that captured user data and reporting requirements for direct mail and database marketing systems. Analysis and Database design using SQL Server. Wrote T-SQL stored Procedures and Batch Queries in SQL Server. Responsible in all facets of Software Development Life Cycle (SDLC), including requirements gathering, establishing technical specifications, set deadlines and milestones, Designing, Coding, Testing, Quality Assurance and Production Deployment. Generated Business reports using SQL Server 2005 Reporting Services (SSRS). Used SQL Server Integration Services (SSIS) to transform data from Flat Files to SQL Server 2005. Created Windows Services to run the SSIS package to load data into a database daily. Environment: MS SQL Server 2008r2. 2012, 2014, T-SQL, SSRS 2008 r2, SSIS 2008r2, SSAS 2008r2, Oracle, PL/SQL, Facets, Crystal Reports, Windows 8/7, Asp.net, WCF. Education: Master s in Computer Science (Dec 2015) Rivier University Nashua, NH Bachelor s in Computer Science (June 2012) JNTU University Nashua, NH Keywords: csharp continuous integration continuous deployment quality analyst artificial intelligence business intelligence sthree active directory information technology microsoft procedural language Arizona Arkansas Delaware New Hampshire North Carolina