Power Bi Data Analyst

Location:

Lansdale, PA

Posted:

September 04, 2024

Contact this candidate

Resume:

Vishnu Reddy Ph #:618-***-****

Senior BI Data Analyst Email: ad8hce@r.postjobfree.com

Professional Summary:

• Over 14 years of IT experience in Analysis, Design, Development, Testing and Maintenance of Business Intelligence and Data Warehousing projects using Tableau, MicroStrategy platform, Power BI, Cognos, Informatica, Oracle, Teradata, Sybase and ERWin.

• Lead the team to build BI Reports, Dashboards using MSTR, Tableau & Power BI.

• Gave User trainings on BI Reports, Dashboards and Self Service usage of it.

• Worked in Agile/Scrum methodology used JIRA interface for tracking .

• Solid experience in development, installation, administration, migration, configuration, technical support, troubleshooting, maintenance and overall health of the Tableau implementations.

• Experienced with Create/Manage Groups, Users, Workbooks and Projects, Database Views, Data Sources and Data Connections in Tableau.

• Experienced in Add/Edit Sites and corresponding administration rights (System vs. Content)

• Experienced with Tableau backup and restore.

• Experience with reading through Tableau logs to work through problems finding root causes and rectifying.

• Experienced with alternative authentication providers such as Active Directory.

• Respond to and resolve tickets on technical issues related to Tableau Platform within defined SLAs.

• Connected Tableau Server with GCP.

• Co-ordinate with Tableau Support for any unresolved issues and tool specific issues or hot fixes/patches.

• Developed story telling Power BI Dashboards and reports from multiple data sources (SQL Server, Oracle, Db2, Teradata) using Power Query, M Script, bookmarks, slicers, sync slicers, visuals, performance analyzer, DAX studio and complex DAX functions.

• Created Datasets, Relationships and Reports in Power BI Desktop.

• Used Bar chart, Line chart, Matrix, KPI, Key Influencer, Funnel, Map, Gauge, Slicer, and custom visuals on Power BI Desktop.

• Publishing and sharing reports with the business users on the Power BI Report Server.

• Expertise in using MicroStrategy 10.x/9.x/8.x product suite which includes MicroStrategy Desktop, MicroStrategy Intelligence Server, Narrowcast Server, MicroStrategy Architect, Administrator, MicroStrategy Office, MicroStrategy Object Manager and MicroStrategy Command Manager.

• Experience in Full Life Cycle Implementation of Data warehouse projects.

• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.

• Validated end user report requests using SQL queries and MicroStrategy tools.

• Practical understanding of Star Schema and Snowflake Schema Methodology.

• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Metrics, Filters, Prompts etc) with the data warehouse.

• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.

• Experience in creating Report Service Documents and Dashboards.

• Very good experience in working with very large databases like Oracle, Sybase, Teradata, SQL Server with MicroStrategy.

• Used Cognos to pull the queries and converted the reports to MSTR & Tableau.

• Extensively worked on SQL and PL/SQL, TSQL programming.

• Flexible and Versatile who can adapt to any new environment. Ability to perform well in a group or individually and can cope well in a high intensity work environment.

• Excellent Analytical and Problem Solving Skills.

• Worked closely with business users to do gap analysis, system design and provide best-practices and solutions.

Technical Skills:

BI Tools: Tableau 2023/2021/10.X,MicroStrategy 11.x/10.2/9.x/8.1.x(Administrator, Desktop, Intelligence Server, Architect, Web, Narrowcast Server, Distribution Services), Power BI Desktop & Report Server,Business Objects. Cognos ETL Tools: Informatica Power Center 8.x/7.x/6.x,Data Stage,SQL Server DTS/SSIS services. Databases: Oracle 10g/9i/8i, TeradataV2R6/V2R5, MS SQL Server, Sybase 12 Languages: SQL, PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML Operating

Systems:

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

Office Tools: MS Office, Microsoft Visio

Other Tools: Toad, SQL Assistant, PL/SQL Developer, Aqua Data studio,Interactive SQL. PROFESSIONAL EXPERIENCE

Citi Bank, Warren,NJ June ‘18-Current

Senior BI Tableau/ Microstrategy Consultant

• Gathered the Reporting requirements from business user and created BRD (Business Requirement documents).

• Implemented & Configured Windows AD SSO for Tableau Environment’s.

• Created Tableau Dashboard & Reports with KPI’s,charts etc.

• Created Data Sources by using diff sources databases, excel etc for Self Service Reporting.

• Worked with Tableau Support for unresolved issues and Software bugs.

• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics. Created and assisted users in Tableau dashboard development

• Categorized the users such as Viewer, Creator,Explorer, Site Administrator and identified their roles and defined Tableau Security model.

• Worked on creation of user groups, projects workbooks and the appropriate permission sets for Tableau server logons and security checks.

• Connected Tableau Server with GCP and created Data Sources, Workbooks, Dashboards and published to Tableau server

• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.

• Design and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.

• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately

• Involved in publishing of various kinds of live interactive data visualizations dashboards reports and workbooks from Tableau Desktop to Tableau servers

• Worked on Qlickview Dashboards conversion to Microstrategy.

• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.

• Created the Report Specification document and had it signed off, after suggesting some useful alterations.

• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in MicroStrategy.

• Involved in MicroStrategy upgrade to version 10.4 to 10.11.

• Used database specific Microstrategy Apply functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.

• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering based upon the business user change request on UAT Testing.

• Worked on SDK to implement single sign on (SSO) between the clients app and MicroStrategy. Worked on implementing authentication and authorization of users.

• Designed Hierarchy of Dimensions and Fact Tables in Microstrategy Architect.

• Created Logical Views to accommodate user requirements.

• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.

• Used Information windows extensively on iPad based dashboards for better interactivity and navigation.

• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using I-cubes improved performance of the RS documents significantly.

• Loaded the Intelligent Cubes using Incremental refresh reports.

• Created Scripts to create user,apply security filter and run the cubes in Command Manager.

• Created Dashboards for CCAR Project on projections of future data.

• Developed the Adhoc reports and Documents on BASEL numbers like EAD,RWA etc.

• Used the Object Manager to move the objects from Development to UAT and then to Production Environment in Microstrategy and did project duplications.

• Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.

• Converted Cognos Reports to Microstrategy & Tableau.

• Ran queries in Cognos frame work and pulled SQLs to migrate them to MSTR & Tableau

• Created documents with both Grids and graphs as per user requirements.

• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing.

• Tested all the reports by running queries against the warehouse .Also compared those queries with the MicroStrategy SQL engine generated queries.

• Highly used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time.

(Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast),Cognos, Sybase, Informatica Power Center,SQL Server, MS Office and Windows 2000. Michaels, Irving,TX Aug'17 – May’18

Senior Power BI/MicroStrategy Consultant

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.

• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.

• Created various User groups by assigning row and column level security at application level, folder level and user level

• Involved in MicroStrategy upgrade to version 10.

• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.

• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.

• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.

• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy.

• Created Database Views to accommodate self service reports to Users on Tableau.

• Extensively created MicroStrategy Report Services Documents, Dashboards.

• Used Enterprise Manager Project to create Statistic reports to analyze the license usage, busy hour, Reports executed by Project & User. Reports helped to track the tool usage effectively to improve the platform further.

Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy.

• Served as technical expert providing input to application design, performance tuning. Provided best practices and recommendations for robust and scalable BI environment.

• Experience working in a production/development/test environment with change management, defect tracking and status reporting processes

• Used Distribution manager, Narrowcast Server to schedule the reports to users email, file locations

• Used OLAP Apply functions for complex logic and VLDB properties to alter the SQL queries for better performance

• Involved in end user training

• Highly used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time.

• Developed training workshops and material for Power BI and DAX.

• Responsible for converting the existing MSTR architecture to Power BI.

• Interacting with multiple stakeholders to gather business needs & developed technical specs

• Developed story telling Power BI dashboards and reports from multiple data sources (SQL Server, Oracle, Db2, Teradata) using Power Query, M Script, bookmarks, slicers, sync slicers, visuals, performance analyzer, DAX studio and complex DAX functions.

• Created Datasets, Relationships and Reports in Power BI Desktop.

• Used Bar chart, Line chart, Matrix, KPI, Key Influencer, Funnel, Map, Gauge, Slicer, and custom visuals on Power BI Desktop.

• Publishing and sharing reports with the business users on the Power BI Report Server.

• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

• Converting pre-existing Excel-based reports to Power BI dashboards while providing production support.

• Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation.

• Designing MSTR & Power BI Dashboards with interactive views, trends, and drill downs for 5k+ users

• Rendering production support to Power BI users & writing custom SQL to support business requirements

Environment: Power BI Desktop & Report Server,MicroStrategyDesktop10.4/9.4 (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast), Sybase, Datastage,SQL Server, MS Office and Windows 2000.

Marc Jacobs, New York City,NY Apr'17 – July’17

Senior MicroStrategy Architect

• Worked with Business users to gather requirements and prepared technical specification Documents.

• Understanding the reporting requirements and developed the reports and redesigned the legacy reports in MicroStrategy

• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis

• Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals.

• Designed Reports, Documents and Dashboards using Desktop.

• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.

• Created ad-hoc reports by drilling up, down, within and across Hierarchies.

• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics

• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.

• Validated end user report requests using SQL queries and MicroStrategy tools.

• Using Object Manager to move the reports from Development Project to QA/Production Project.

• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.

• Involved in extracting the data using SSIS from OLTP to OLAP.

• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).

Involved in optimization of code and tuning queries for performance.

• Production Support has been provided for ongoing issues. Environment:MicroStrategyDesktop10.2/9.4 (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast), SSIS,SQL Server, MS Office and Windows 2000. Citi Bank, Warren,NJ Feb ‘14- Mar ‘17

BI MicroStrategy Developer/Programmer Analyst