Power Bi Business Intelligence

NAME: Viswa Sai Abishek Mushyam

Sr. Power BI/ Tabular Admin Developer

Email: ************@*****.***

Mobile: 334-***-****

LinkedIn: www.linkedin.com/in/mushyam-viswa-2aba98254

PROFESSIONAL SUMMARY

More than 12+ years of extensive IT Experience especially in Business Intelligence Power BI applications.

Worked on Power BI and prepared dashboards to make it more attractive.

• Visual BI Solutions Development

• Tabular Service Installation & Configuration

• Server Performance Monitoring Capacity Planning & Resource Optimization

User Access Management & Role-Based Security Data Refresh Scheduling

Power BI / SSAS Tabular Model /DAX / MDX / TMSL

Automation & Scripting (PowerShell, Python) SQL Server & Azure Analysis Services

Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.

Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.

Experience on publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for upcoming data in power BI server.

Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.

Experienced on Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App)

Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients and Power BI for executives and managers

Created scripts to analyze data, modify data, import / export scripts, and execute stored procedures. Created complex queries for use in Power BI.

Developed custom calculated measures using DAX in power BI to satisfy business needs.

Strong experience with Informatica Tools-Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Informatica Repository.

Good experience with LookML, Looker version controlling, Looker Blocks and data modelling in Looker.

Experienced in Performance Tuning of Looker Dashboards and experienced in Advanced D3 Visualizations and adding them to Looker.

Experienced in migrating legacy systems into Google Cloud Platform (GCP).

I Design and Build GCP data driven solutions for enterprise data warehouse and data lakes.

Experience in SSIS, SSRS, SSAS tools in SQL Server & Support different ETL process flows.

Experience with cloud data warehouses such as Snowflake, BigQuery, etc.

Skilled at optimizing/performance tuning of complicated SQL statements.

Experienced in Microsoft SQL Server, T-SQL, and supporting production databases.

Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.

Good skills in testing the Enterprise Data Warehouses using Informatica Power Centre, Data Stage, Ab Initio and SSIS ETL tools.

Experienced in using Data Modelling tools like Erwin, MS Access, and Microsoft Visio.

Worked and provided guidance with Data Architect and DBAs to design, develop, implement, and maintain the conceptual, logical, and physical data models for OLTP and ODS to meet customer requirements and support ETL (Informatica) and Reporting (Cognos).

TECHNICAL SKILLS

BI Tools

Power BI, Google Analytics, Alteryx, MicroStrategy, IBM Cognos Analytics, OBIEE, and SSRS

ETL Tools

Informatica, SSIS, Data Stage, Talend, and Oracle Data Integrator, Data Lake

Databases & Data Warehouses

Microsoft SQL Server, Oracle, PostgreSQL, MySQL, DB2, Teradata, Snowflake, Greenplum, Netezza, Google BigQuery, Sybase, Hadoop, and Impala

Database Tools

Oracle SQL Developer, TOAD, and Teradata SQL Assistant

Applications

Microsoft Office Suite (Word, Excel, Visio, PowerPoint)

Scripting Languages

HTML, SQL, PL/SQL, XML, VB, Shell, Java API, C, Python, Perl

Data Modelling Tools

Power Designer, Erwin, ER/Studio, MS Visio, Toad, MySQL Workbench

Operating Systems

Windows 2005/2008/2012, Windows XP/7, iOS, Unix, Linux

PROFESSIONAL WORK EXPERIENCE

Client: Securian Financial, Saint Paul, Minnesota

Role: Sr. Power BI/ Tabular Admin Developer

Time: Sep 2024 - Present

Responsibilities:

Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

Experience in building Office 365 solutions including Power Automate (Flow), Power Apps, Power BI

Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS.

Responsible for building reports in Power BI from the Scratch.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Experience on publishing Power BI reports on dashboards in Power BI server.

Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.

Responsible for developing, support and maintenance for the ETL (Extract, Transfer and Load) processes using Informatica Power Centre.

Created shell scripts to fine tune the ETL flow of the Informatica workflows.

Analyse the source system and involve in designing the ETL data load.

Worked with ETL developers, Business Analysts, dbas, to architect Data Model, design and implement database as well as write ETL related programs.

Worked on the Microsoft Azure environment (blob storage, Data Lake, AZ copy) using Hive as extracting language.

Developed the Informatica mappings by usage of aggregator, SQL overrides usage in lookups, source filter usage in source qualifiers, and data flow management into multiple targets.

Installing, Configuring and Managing the Looker environment and support the business decision process by implement data security measures and access controls within Looker.

Worked on Looker performance optimization through persistent derived tables and caching strategies and created prototype reporting models Lookml, Looks and Tiles.

Developed Looker Dashboards, Looker Explores and Views.

Worked on pdts, Looker Blocks and Data groups.

Creating Looker projects and configuring the github to Looker projects.

Designing effective layouts and Utilizing features in Looker to guide readers through a compelling data-driven story.

Built look data models on Snowflake consumption layer and involved in testing the SQL, lookml in Looker, and Snowflake DB scripts.

Created Multiset, temporary, derived and volatile tables in Teradata database.

Develop lookml models for the construction of dashboards by data analysts in Looker.

Implementing Looker center of excellence, coding standards and best practices for Looker.

Build GCP data driven solutions for enterprise data warehouse and data lake house.

Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.

Used cloud shell SDK in GCP to configure the services Data Proc, Storage Big Query.

Support existing GCP Data Migration implementations.

Performed detailed analysis on tested and deployed Power BI scripts.

Have performed DAX queries and functions in Power BI.

Good experience in building interactive reports, integrating modelling results, visualization designing and analytical background by using Power BI

Utilized ODBC for connectivity to Teradata via MS Excel to retrieve automatically from Teradata Database.

Ability to learn and understand application data table structure to create database schemas and ability to conditionally extract data directly from database to create complex database views with Strong SQL programming.

Involved in designing and developing Data Warehouses, Data Marts and Business Intelligence using multi-dimensional models such as Star schemas and Snowflake schemas for generating reports using SSRS.

Imported various heterogeneous files using Informatica power center 8.X source analyzer.

Performed unit testing, integration testing and system testing of Informatica mappings.

Administered and maintained Tabular Workbox environments for enterprise-scale reporting solutions.

Installed and configured Tabular services across development, staging, and production environments.

Designed and implemented user access management protocols, ensuring security compliance and role-based permissions.

Managed and scheduled automated data refresh operations to ensure up-to-date reporting data availability.

Proactively monitored server resources and performance metrics to identify bottlenecks and recommend optimizations.

Led capacity planning initiatives for hardware upgrades and new deployments to meet future BI workload demands.

Collaborated with BI developers and data architects to deliver visual solutions aligned with business needs.

Environment: SSIS, SSRS, SSAS, Informatica, Microsoft SQL Server, Google BigQuery, Looker6.x, Looker5.x, Azure Data Lake, Snowflake, Terraform, GitHub, Teradata SQL Assistant 7.0, Power BI, Microsoft Excel, Google Cloud Platform (GCP), abular Workbox, Power BI, SSAS Tabular, SQL Server, Azure Analysis Services, DAX, TMSL, PowerShell, Windows Server, Performance Monitor, Azure Monitor, SQL Profiler, SSMS, Git

Client: US BANK, NY, USA

Role: Sr. Power BI/ Tabular Developer

Time: June 2023 – Aug 2024

Responsibilities:

Work with a cross-functional team of developers and business analysts to deliver strategic data and analytics initiatives.

Utilize business analytics to create performance analysis reports and compile data to drive process improvement opportunities.

Extract and organize datasets using Excel to create business models and compile data for the organization’s risk index.

Experienced in writing SQL Queries for pulling large volume of records from Facets and Tax advisory database using stored procedures, and ETL process using SSIS.

Designed and developed SSIS interfaces for Customer Master, Investment process and Audit process etc., and created jobs using SQL procedures and different types of sources like Oracle, SQL Server and Flat files and FTP connections.

Design, build and deploy BI solutions using Power BI

Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Created scripts to automate in-house metadata explorer project using Shell Script and SQL

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Able to implement row level security on data and application security layer models in Power BI.

Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

Provided technical assistance for maintenance of AutoSys and related scheduling solutions.

Responsible for design of ETL process and development of Informatica code by working with cross-functional teams to analyze requirements, develop technical design and deliver as per standards.

Creating and monitoring batches and sessions using Informatica PowerCenter server.

Extracted data from excel files, high volume of data sets from data files, Oracle, DB2, Salesforce.com (SFDC) using Informatica ETL Mappings/SQL PL SQL scripts and loaded to data store area.

Delivered migration projects related to upgrade of Informatica Power Centre from 6.1.1 to 8.1.1 and then to 8.6.1 along with Oracle upgrade from 9i to 10g.

built automated reports and dashboards with the help of Power BI.

delivered actionable insights by creating custom Microsoft Power BI dashboards, Visualizations, and 28 interfaces with Microsoft SSRS.

Used Power BI gateways to keep Dashboards and Reports up to date.

Responsible for maintaining security and data access models within Looker.

Worked on persistent derived tables and Experienced with Looker schedules.

Worked on Table filters and custom formatting.

Version controlling via GIT.

Mockups for the user cases of business.

Developed and deployed visual BI solutions using Power BI and SSAS Tabular Models.

Supported installation, configuration, and upgrade cycles of Tabular services in on-prem and cloud environments.

Created documentation and SOPs for Tabular administration and performance tuning practices.

Provided technical support for Tabular-related issues and trained team members on best practices.

Environment: Looker6.x, 5.x, Erwin, Oracle, MySQL, SQL Server, SSIS, SSRS, SSAS (DAX and MDX), SQL Developer, TOAD, JIRA, Rally, SFCC, HP Quality Centre, TensorFlow, Power BI, AutoSys, SAP, Data Architecture, ETL, Visualization, QlikView, Qlik Sense, Talend, Share Point, Agile – Scrum, CA Service Manager, abular Workbox, Power BI, SSAS Tabular, SQL Server, Azure Analysis Services, DAX, TMSL, PowerShell, Windows Server, Performance Monitor, Azure Monitor, SQL Profiler, SSMS, Git

Client: AT & T

Role: Sr. Power BI Developer

Time: Oct 2020 – Nov 2022

Responsibilities:

Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Involved in Debugging connection related problems, Query Design, Indexing recommendation and Performance Tuning.

Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.

Handled various issues related to setup & configuration of 'Database Mirroring' solved issues related to synchronization of data in Development, Test, Smoke, Production environments.

Handled all complex queries, ETL/SSIS packages, stored procedures, and triggers.

Involved in writing complex SQL Scripts using excel sheets for loading data into maintenance tables. Handled all complex queries, ETL/SSIS packages, stored procedures, and triggers.

Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing table structures.

Designed high level ETL architecture for overall data transfer from OLTP to OLAP with help of SSIS.

Develop an ETL Database Model to carry out new procedures and create various database warehouse dimensions to accept ETL outputs.

Developed SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Union All, Sort and Execute SQL Task to load data into Database.

Experienced in writing PL/SQL queries to perform various database operations in Portico.

Loaded of tables from DB2 to SQL Server performed every night across multiple systems.

Used Sub queries, joins, CTE's and Analytical functions for data retrieval.

Analyzed complex queries tuned same optimize application system performance.

Experienced in building indexes at regular intervals for better performance.

Designed and implemented comprehensive backup plan and disaster recovery strategies.

Troubleshooting of claims database related issues during upgrading migration process and solved backup, copy, restore job failure, space, network, latency issues related to Log Shipping.

Created data models and tables within Power BI to support efficient, optimized data warehousing and reporting workflows.

Documented DAX code and approach to the management of Power Bi Books.

Developed Reports, Views, KPI scorecards using Power BI Desktop and, Utilized Power BI to build interactive and visually appealing Dashboards.

Responsible for Hands-on development in QlikView, Qlik Sense, SQL, and Business Objects.

Prepared Qlik sense proof of concepts as per the requirements and specifications.

Examines current BI dashboards, makes diagnoses, and continually improves and builds QlikView eco-system.

Experienced in designing dynamic dashboards using MicroStrategy Report Services.

Used Autosys tool for scheduling objects and running through UNIX commands.

Environment: MSSQL Server, MySQL, Lotus Notes, MS Access, MS Office Suite Word, PowerPoint, Excel, SSRS, SSAS, SSIS, Informatica, PL/SQL, T-SQL, Data Stage, Micro Strategy, Autosys, Alteryx, UNIX, MS Visio, MS Project, Oracle, TOAD, Teradata 13.10, Teradata SQL Assistant, Teradata Administrator, SQL Developer, Power Designer

Client: IDBI Bank, Hyderabad, India

Role: SQL / BI Developer

Time: Oct 2017 - Sep 2020

Responsibilities:

Developed ETL framework for processing and monitoring import of flat files in SSIS for key client

Maintained SQL scripts and complex queries for analysis and extraction, Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS

Developed and created the new database objects including tables, views, index, stored procedures and functions and advanced queries, developed complex TSQL stored procedures and SSIS ETL processes utilizing XSLT and XML queries to consume and translate the vendor XML and Excel data files into the supporting database

Design, build and deploy BI solutions using Power BI

Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Created scripts to automate in-house metadata explorer project using Shell Script and SQL

Worked with various scripting languages like Shell and Python, Wrote Python scripts for pushing data from Mongo DB to SQL Database

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Very good knowledge of DAX and MDX queries

Created SSRS inventory management reports

Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting, and joining tables

Created report model on SSAS cubes as well as changing default configuration on existing cubes

Analyzed data using SQL to identify trends, patterns, and insights.

I write MS SQL and T-SQL scripts to transform raw data according to business requirements.

Designed custom queries using Microsoft T-SQL and Crystal Reports as per defined technical specifications.

Created automate processes through stored procedures utilizing T-SQL to facilitate additional production capacity and not overburden the main data server.

Working with Toad and Oracle developers to prepare Oracle queries to validate the data in both source and target databases.

Developed Informatica mappings, reusable transformations and created PL/SQL stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.

Created SSIS packages for data loading utilizing various tasks and transformations within the SSIS.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.

Performed ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, CSV, Excel) and schedule workflows.

Developed complex reports, dashboards and supported the existing reports using SSRS and Power BI based on the end-user requirements, performed Ad hoc analyses using SSRS.

Developed and Tested Excel macros using VBA for reports and transferring data using DTS package.

Perform data validation and quality assurance checks, ensuring data accuracy and reliability.

Provided technical assistance/ support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/ interfaces.

Environment: Business Objects XI3.1/XIR2, Import Wizard, Publishing Wizard, Repository Migration Wizard, Oracle 10g, Sybase, SQL Server 2005, MS SQL Server, SSIS, SSRS, SSAS, Excel, Power BI, ETL, Informatica, TOAD, T-SQL, Teradata, PL/ SQL, Alteryx, MS SharePoint

Client: ESM Square Technologies, Bengaluru, India

Role: SQL Developer

Time: Jun 2012 - Sep 2017

Responsibilities:

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application

Performed Branching, Merging, Tagging and Release Activities on Version Control Tool, GIT

Scheduled and maintain packages by daily, weekly, and monthly using SQL Server Agent in SSMS

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files

Responsible for optimizing SQL queries, stored procedures to improve the performance time

Conducted data migrations from third party databases to create consolidated database system

Performed data analysis on product datasets and led the modeling and development of the initial Enterprises data loading ETL/ELT solution in SQL 2008 R2

Created the weekly meeting BI SSRS reports on data acquisition and integrity progress for Director of Information Systems, Director of Digital Operations, and Vice President of Business Development.

Implemented auditing using triggers and enforcing business rules via checks and constraints. Proper use of views to prevent unauthorized access to sensitive data

Connecting to data sources, importing data, and transforming data for Business Intelligence.

Excellent in analytical thinking for translating data into informative visuals and reports.

Able to implement row level security on data and application security layer models in Power BI.

Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

Created batch job processing, scheduling, and production support

Created a SQL script to create the tables, implement business rules, and populate the tables, developed queries and reports to illustrate features of the application

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, SQL Server automatic email notification and backup strategy

Extensive use of T-SQL programming and stored procedures to interactive with the database, and ASP to perform the calculation of the risk assessment modeling

Using ASP and SQL server programming to produce a final assessment report which are rich with dynamic graphics and charts

Environment: SSAS, SSIS, SSRS, SSMS, SSDT, Power BI, MS SQL, Bash Scripting, Jira, GIT, SVN, Windows Server.

Contact this candidate