Gurram Gopi Reddy

6.6 years of strong experience with products of the MicroStrategy suite, namely Desktop, Web, Intelligence Server, Architect, and OLAP Services, and Power Bi, Tableau.

Schema Objects: Extensive experience and involvement in creating schema objects (like attributes, facts, hierarchies, transformations, tables, and logical view tables) to support the requirement.

Public Objects: Extensive experience and involvement in creating public objects (like Metrics, Filters, Prompts, Drill maps, Intelligent Cubes, Consolidations, and Custom Groups) to support the requirement.

Experience in developing reports, documents, dashboards, and Dossiers.

Excellent understanding of relational database concepts and dimensional modeling techniques, like Star and Snowflake schemas.

Worked and developed Intelligent Cubes and cube-based reports to reduce the load on the database server.

Coordination and Communication with Onshore & Offshore Team for Project Activities like Designing, Development, Code Review, Testing, Deployment, Enhancements, Sign-off, and Defect Fixing Plan, and managing the team for Project Stability.

Have experience working with Power BI Dataset with Live connection mode.

Good experience in appending and merging tables by understanding the data structure in those.

Implemented different methods to ease data analysis in visuals and also made DAX calculations by following the best practices suggested by Microsoft in order to optimize performance.

Developed hierarchies in order to implement drilldown for the required visualizations.

Created roles in Power Pivot to implement dynamic and static RLS, and tested them in both desktop and service.

Scheduled refresh essayed the business requirements.

Expertise in creating different visualizations like Line, Bar, cluster, and stacked bar charts, combo charts, Waterfall Chart, Tree map, Card, Multi-card, Table, matrix, Area chart, Pie chart, Donut chart, decomposition tree, etc.

Roles & Responsibilities:

· Worked on report migration in Microstraetgy, sourced from Teradata and targeted to Snowflake. Created business templates and reports.

· Fair hands-on in SQL and object definition comparison and data testing/validation.

· Created MSTR objects such as Facts, Nested Metrics, Prompts, filters, Cubes and custom groups, by investigating the object mappings.

· Performed Unit testing by designing test cases and ensured data validation as well.

· Worked on creating documents of various test cases and also details of our findings of report development and migration.

· Communicated and presented the findings to the client and documented the bugs. Fixed the data/formatting issues for the same.

Roles & Responsibilities:

· Understanding database and Functional, Technical specifications and Business requirements.

· Created the schema objects (like Attributes, Facts, Hierarchies, Transformations, Cubes, Searches, Partition mappings and tables).

· Creating public objects (like Reports, Metrics, Filter, Prompts, Drill maps, Templates, Consolidations, and Custom Group, Dashboards and Scorecards).

· Designed various Grid and graph reports and Documents based on customer requirements.

· Reports Performance Tuning through VLDB Settings.

· Creating multiple reports by using Intelligent Cube.

· Creating complex reports by using consolidations, custom groups.

Roles&Responsibilities:

Role :PowerBi Developer

DataBase :SQLServer,Excelfiles.

Tools  :PowerBI,SQLServer

Duration  :April 2021 – Feb 2023

Description:

Golub Corporation is an American supermarket operator. Headquartered in Schenectady, New York, itowns the chains Market 32 and Price Chopper Supermarkets. The company opened its first supermarkets in New York, Capital District in 1932, and changed its name from CentralMarket to Price Chopper in 1973. Also, in the 2010, the Golub Corporationannounced thatthey would be converting all 131 stores Price Chopper locations into Market 32 locations. OnJune 2, 2010, Price Chopper dedicated its new headquarters, on Nott Street, in Downtown Schenectady. It operates 131 stores in Upstate NewYork, Vermont, Connecticut, Massachusetts, New Hampshire, and Pennsylvania.

· Participated in requirements meetings and Scrum Calls to understand the Report Requirements.

· Identified and Documented detailed business rules.

· Used Power Query / Query Editor for Data transformation as per the reporting needs.

· Created Data Model in Power Pivot by Establishing the Relationship Between the tables.

· Created New Columns and New Measures over data models for the purpose of enhancing Power BI visuals using DAX.

· Participated in weekly, daily meetings, reviews meetings as well as communicating with business teams.

· Integrated Custom Visuals based on business requirements using Power BI desktop.

· Created Hierarchies and Drilldown Reports.

· Created Microsoft Power BI Dashboards in Power BI Service using Reports.

· Installed and Configured Data Gateways to Refresh and Schedule Refresh the Dataset.

· Managed access of Reports, Dashboards and Data for individual users using roles.

· Implemented Row Level Security as part of Security.