PROFESSIONAL SUMMARY:

• Motivated Business Intelligence Developer with expertise in analysis, design, development and implementation of data warehouses, data marts using MS Power BI, Azure Data factory, ETL Tool (SSIS), SSRS, SSAS, MS SQL Server 2018, Tableau, Tableau Report Server and holds a good knowledge of all the phases of Software Development Life Cycle (SDLC).
• Expertise in working with Power BI Desktop, Power BI Service with Pro and Premium capacities and ETL processes involving migrations and in sync processes between two databases.
• Develop and create advanced chart types, visualizations, and complex calculations to manipulate the data as per business need using Microsoft - SSRS, Power BI, SSAS, SSIS, T-SQL, Visual Studio 2019.
• Gather, analyze, and document business requirements, functional requirements and data specifications for Business Objects Universe and Reports to prepare System Design document.
• Able to effectively implement performance tuning and query optimization in different databases like using Microsoft SQL Server 2018. Utilize DAX functions which include Aggregation, Counting, Logical, Information, Text, and Date functions.
• Develop reports using AZURE CLOUD Data Integration and AZURE DevOps to build work tracking reports.
• Perform Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server applications.
• Create New Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Indexes using T-SQL. Write Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins. Maintain and support datasets, templates, and reporting packages.
• Extract, Transform and Load (ETL) data from Excel, Flat file, Oracle to MS SQL Server using BCP utility, DTS and SSIS services. Create OLAP cubes in SSAS.
• Working with DTS/SSIS - SQL server integration services Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Successfully retrieved data from multiple data sources like Azure Data Lake, DevOps Analytics View. Worked with Data Management, Data Integration, Data Mart, and Data Warehouse.
• Set-up, maintains, monitor, and support enterprise reporting structures, security groups, and accounts. Using DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATED TABLE, Power BI, Power Pivot to develop data analysis prototype, and use Power View and Power Map to visualize reports.
• Publishing Power BI Reports to the required originations and made Power BI Dashboards available in Web clients. Develop different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps using Power BI, Python, SQL Server Management Studio, T-SQL, and DAX.
• Involved in a SQL DB and Oracle DB integration using Informatica.
• Develop to generate context filters and data source filters while handling large volume of data and involved in creating Filters, quick filters, table calculations, calculated measures & parameters in Power BI Desktop.
• Using SSIS to extract transform and load data into database, used Excel and MS Access to dump the data and analyze based on business needs.
• Used OBIEE to create POC’s and maintained existing reports created on OBIEE
• Performing Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.
• Well versed with using Microsoft Power BI - designed, developed, and published multiple innovative visualization reports and dashboards in MS SQL Server/Azure cloud environment.
• Worked with Tableau and Tableau Reporting Server.
• Involved in Optimization of Tableau server.
• Create reports with Pie Chats, Gantt Charts, Scatter Charts, Bar Graphs using Tableau.

TECHNICAL SKILLS:

Database: MS-SQL Server 2018/2016/2014/2012, Azure SQL Server, Tableau Reporting Server

SQL Server Tools: SQL Server Management Studio (SSMS)

Reporting Tools: Power BI Desktop, Power BI Report Builder, SSRS, Tableau, PowerPivot for Excel

Analysis Tools: SQL Server Analysis Services (SSAS), AAS (Azure Analysis Service)

Integration Tools: SSIS, Azure Data Factory

Languages/Scripting: SQL, T-SQL, DAX, M-Query, PowerShell Scripting, Python, R

Automation: Power Automate/Flow, PowerShell

IT Processes: Software Development Life Cycle (SDLC), Project Management

Operating System: Windows 11/10/8.1/7

Performance Tuning Tools: MS SQL Profiler, DAX Studio

Developer Platforms: MS Visual Studio 2018/2016/2012, PowerShell ISE, Power GUI

Administration: Active Directory (AD) for Users and Computers, TFS, Azure Cloud, Power BI Admin Portal, Office 365 Admin Portal, Power Platform

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Senior Business Intelligence (BI) Developer

Responsibilities:

• Develop Publish dynamic and complex Financial and Sales Reports in Power BI. Create, Maintain & schedule various reports in Power BI like Tabular Reports.
• Participate in the team business requirements gathering and analyze, understand, and convert them into database solutions. Setting up Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway, Visual Studio, SQL Server Management Studio and PowerShell.
• Develop and deploy SSIS packages, configuration files, and schedule job to run the packages which generate data in CSV files. Use DAX to create complex measure and calculated columns based on the report requirements.
• Perform end to end testing on the reports and packages developed to ensure data quality is met. Troubleshoot reports issues, ETL job failures, optimizing query performances. Work on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes using Oracle, SQL Server, Flat Files, Excel, and XML using SSIS.
• Develop Dashboards and Reports with MS Excel, SQL Server, DAX, T-SQL, Azure cloud, and Report Server data sources using Power BI Service Desktop tool. Utilizer Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing. Implement Row-level security with Power BI (RLS).
• Develop complex T-SQL, DAX, MDX queries for the ETL packages. Involve in developing executive KPI reports and dashboards. Work with implementation master data management (MDM) of new products, customers, and vendors. Used master data management (MDM) to define data.
• Design, Develop and Deploy custom reports in MS SQL Server environment using SQL Server Reporting Services (SSRS). Involved in design and development of Data Warehouses, Data marts, Data Mining and Business Intelligence using dimensional modeling such as Star Schemas and Snowflake Schema for generating reports.
• Write 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. Use DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Provide Production support after Go-LIVE and train end user with Pre-Process and Post-Completion documentation before signing off. Part of the Agile/Scrum team and participated in Standup, planning and retrospective meetings.

Environment: s: Power BI, DAX, T-SQL, Power BI Gateway, Dashboard, Azure Cloud, Power Pivot, MS SQL Server 2018, T-SQL, SSRS, Performance Tuning, ETL, SSIS, SQL Server Analysis Services (SSAS), Visual studio 2018.

Confidential, Milpitas, CA

Business Intelligence Developer

Responsibilities:

• Analyzed reporting requirements and develop various Dashboards, using trend lines and lines. Created number of views, calculated tables, calculated columns, and measures.
• Created and customized simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Developed and published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile. Implemented Power BI as enterprise reporting tool and responsible for managing user licenses, creating, and assigning workspaces to Power BI premium capacity.
• Created Power BI usage metrics report to help Power BI Service administrators to analyze the utilization of premium capacity resources. Created different visualizations using Slicers, Line-charts, Pie-Charts, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, processed flowcharts, and data flow diagrams.
• Enabled Power BI refresh by embedding Power app in the report, with which a user can refresh the dataset without having to be the dataset owner. This is done with the integration of Power BI-Power App and Flow.
• Integrated Power BI dashboards on On-Premises Report Server with Angular Portal. Implemented Row-level security with Power BI (RLS).
• Integrated a SQL DB with Oracle DB using Informatica.
• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure. Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Used One Drive for storing different versions of the Power BI report. Responsible for completing maintenance and delivery of scheduled releases. Implemented data warehouse and ETL (Extraction, Transformation, and Loading) concepts.
• Used OBIEE for a creating a initial POC and has hand on experience using the OBIEE
• Created many complex queries and used them in Power BI Reports directly to generate reports. Incorporated complex business logic by writing complex SQL procedures and functions.
• Maintained Legacy Tableau reports and Involved in Modernizing of those reports.
• Migrated a few reports from Tableau to Power BI.
• Created/Developed new reports in Tableau.

Environment: s: Power BI, DAX, T-SQL, Power BI Gateway, Dashboard, Azure, Power Pivot, MS SQL Server 2016/2012, T-SQL, SSRS, Performance Tuning, ETL, SSIS, SQL Server Analysis Services (SSAS), Visual studio 2016, Tableau, Tableau Reporting Server.

Confidential

SQL Business Intelligence Developer

Responsibilities:

• Created SQL queries, stored procedures, views, and functions as per requirements.
• Designed SSIS Packages in SQL Server 2015/2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat file to SQL Server Database.
• Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, Oracle, flat file, Text Format Data).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Supported efficient Data Insertion, Manipulation, and Retrieval using various Joins, Indexed Views, Stored Procedures, and Functions.
• Executed data validation stored procedures in SSIS packages with BI Development Studio (BIDS).
• Involved in Deployment and Administration of SSIS packages with BI Development studio.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge, and union all.
• Performed error handling in SSIS using Event Handling and logging.
• Assisted in production of OLAP Cubes, wrote queries to produce reports using SSMS 2012, SSAS and SSRS.
• Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping, and rebuilding the indexes during the SSIS package run.

Environment: s: MS Project, MS Visio, MS Word, Excel, Access DB, SSIS, T-SQL, SSIS Packages, Performance Tuning, Outlook, Share point, Transformations, Normalizations, ETL Process, Windows 7/XP, MS Power point.