Ramu Undefined Email and Phone Number

Responsibilities:● Created AIG Service Dashboard Layout with the theme and Developed Visual reports in Power BI Desktop.● In Data Modelling, created relationship between the 5 tables using calculated column.● Created Power BI calculated measures and using DAX queries for showing that value in card.● Implemented Bookmarks and selection criteria● Implemented Incremental refresh on the table level.● Implemented Mobile Layout design for the report● Having Good Knowledge on Data Warehouse concepts like star schema and snowflake schema.● Validated the data for entire report with SQL Database before publishing the report in Power Bi Service● Used JIRA ticketing tool for the user requested enhancements along with to fix the bugs.● Based on the client requirement implemented Row level security.

Project Description:- Sales management is a business discipline which is focused on the practical application of sales operations. And the management of a firm's sales operations. It is an important business function as net sales through the sale of products and services and resulting profit drive most commercial business. These are also typically the goals and Performance indicators of sales management. Global sales are listed in trade of verified companies.Responsibilities:● Imported data from SQL Server DB to Power BI to generate reports.● Created required Measures and Calculated Columns using DAX. Generated computed tables in Power BI by using DAX.● DAX Functions like Aggregation, Filter, Time, Date, Logical, Information, Text etc... Were used for the calculating the required metrics.● Merge and Append Queries and Utilized aggregation to improve query performance.● Creating Report level apply Individual, Report, Page level filters in power BI● Created Dashboards apply the filters Drill through & Drill Down functions and created tooltip on sheet level as per requirement.● Created Bookmark Pane applies to the actions on view details and Text/ Matrix Tables.● Published Power BI Reports to the APP Workspace and create the APPs to the Users to consume the developed Reports.● Scheduling the reports weekly and monthly basis as per the clients Requires.● Implemented RLS (Row Level Security) for the Reports.

Project Description:- Wright Medical Group is a specialty orthopedic company that provides extremity and biologic solutions which alleviate pain and restores lifestyles. The aim of this project is to maintain the sales billings and distributor sales history data which will shows sales history for invoices and Reps.Responsibilities:● Involved in requirement gathering, analysis, estimations and implementation. Involved in understanding the business requirements and document specifications.● Extract data from different kind of source systems into Power query and then cleansing the data by applying business rules and loading it into Power Pivot.● Creating the Measures according to the business logic in Power BI Desktop using Data analysis expressions (DAX).● Developed custom report tooltips for different reports to showcase the multiple data points in one report.● Created virus visualizations like donut chart, Pie chart and Bar graph, Tree map and waterfall charts and Card Visualizations.● Created various Customized and interactive Reports and Dashboards in Power BI.● Publishing reports to Power BI server and providing the access to required users● Worked on On-Premises Gateway to refresh the data sources and Scheduling the data.● Publishing the data source into Power BI Server and scheduling the data sources● Implemented Role Based Security as part of user level security in Power BI

Responsibilities:● Worked on Creating the Reports and Dashboards in the form of Table, Matrix, Chart and Gauge.● Hands on experience in Creating Drilldown reports, Drill through reports, parameterized reports.● Worked on Creating the Reports as per client’s requirement in the form of Table, Matrix, Chart and Gauge.● Worked on Creating Report level and Data level Security.● Interact with the client for understanding business requirements.● Analyzing data on financial information using Dimensional modeling techniques.● Developed KPI’s to show YTD & LYTD, MTD, QTD, Current period etc., as per user input for From and To Date using Calendar object Involved in deployment activities● Making schedule refresh for reports● Implemented Role based and RLS security.● Analyzing POWER BI reports and understand logic● Worked on Creating Calculated Measures Using With DAX Functions.● Created Dashboards and reports by using Power BI.● Generated Periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query, Power View & Power BI.● Generated parameterized Reports & Enabled Search Concept for Search Parameter Values.