| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Visualization Power Bi Sewell, NJ Power Bi Data Analysis Levittown, PA Data Analysis,Business Analysis,ProjectManagement,Python,SQL,Pow Lawrenceville, NJ Power Bi Data Analyst Philadelphia, PA Data Analyst Business Philadelphia, PA Data Analyst Business Intelligence Morristown, NJ Power Bi Sql Server King of Prussia, PA |
|
Click here or scroll down to respond to this candidateVishnu Reddy Ph #:PHONE NUMBER AVAILABLESenior BI Data Analyst Email: EMAIL AVAILABLEProfessional 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 OperatingSystems:Windows 98/2000/NT/2003/XP/Vista, UNIXOffice Tools: MS Office, Microsoft VisioOther Tools: Toad, SQL Assistant, PL/SQL Developer, Aqua Data studio,Interactive SQL. PROFESSIONAL EXPERIENCECiti Bank, Warren,NJ June 18-CurrentSenior BI Tableau/ Microstrategy Consultant Gathered the Reporting requirements from business user and created BRD (Business Requirement documents). Implemented & Configured Windows AD SSO for Tableau Environments. Created Tableau Dashboard & Reports with KPIs,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. Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment. Environment:Tableau Desktop 2023/2022,Tableau Server 2020/2019,MicroStrategyDesktop 10.11/10.4(Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast),Cognos, Sybase, Informatica Power Center,SQL Server, MS Office and Windows 2000. Michaels, Irving,TX Aug'17 May18Senior 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 requirementsEnvironment: 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 July17Senior 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 17BI MicroStrategy Developer/Programmer Analyst Gathered the Reporting requirements from business user and created BRD (Business Requirement documents). 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. 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. 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. Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment. Environment:MicroStrategyDesktop 9.4 (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast), Sybase, Informatica Power Center,SQL Server, MS Office and Windows 2000. Freddiemac, Mclean,VA Mar12- Dec13BI MicroStrategy Developer Gathered the Reporting requirements from business user and created BRD (Business Requirement documents) for SDLC process. Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary and created Functional and Technical specifications for relevant teams. Created TCP (Test case procedures) for the development team and the business user. Created Metadata Repository and Statistical tables in the data warehouse using the Configuration Wizard. Created Dashboards, reports to Track Key Account Performance trends, Top Payor Accounts, National Benchmark reports and many more. Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop. Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters and compound Metrics and Prompts. Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment. Created transformations (Table Based and Expression Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis. Extensively used MicroStrategy Report Services to create Report Documents, Dashboards. 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. Involved in Customer Support and Maintenance & Performance Tuning of reports. Designed and developed various database objects like tables, views. Wisely used various VLDB properties for tuning long running reports. Environment: MicroStrategy Desktop 9.2/8.1.2/8.1.1 (Administrator, Desktop, Web, Intelligence Server, Narrowcast Server), Teradata, UNIX, MS Office and Windows. Fox, Los Angeles,CA May10- Jan12MicroStrategy Developer Responsible for development of project from starting to end,till the handling of reports to the User. Started with gathering requirements from the users and documenting the specifications. Created the Report Specification document and had it signed of, after suggesting some useful alterations. Analyzed the Data Model and made required changes. Responsible for development and management of projects with primary focus on providing robust and scalable Business Intelligence solutions to various functions within company. Working closely with various business functions to find opportunities to build new business enhancing reports and to automate existing labor and time intensive critical reports. Involved in duplicating the projects and configuring with new database instance. Created many small projects by setting up metadata layer and configuring the MicroStrategy Intelligence server. Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator. Designed many Freeform SQL reports by directly querying against the data warehouse. Created many statistical freeform SQL reports to track the MicroStrategy Report usage by user. Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets. Created Complex filters, prompts, metrics with advanced qualifications involving Apply Simple & Apply Comparison functions. Created smart metrics with custom subtotals. Worked extensively on Complex reporting needs which involved creating Consolidations and Custom Groups. Created different Transformations such as Prior Period, Quarter-to-Date, Last year and effectively used them within the metrics to get previous period related data. Created Attributes, Facts and MicroStrategy logical views as per reporting needs. Created customized Hierarchies for Drill Maps. Highly used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time. Also used OLAP services like Derived metrics, View filters wherever necessary. Responsible for Unit Testing of the reports. Involved in migrating the objects from DEV to UAT/Prod using the Object Manager. Environment: MicroStrategy Sybase 12,Desktop 9.x, MicroStrategy Desktop, Web, Object Manager, Enterprise Manager, Distribution Services, Office, Oracle 10g, Windows XP. |
