Mohan Vankudoth Email & Phone Number

United States

Chennai, Tamil Nadu, India

Power BI Report end to end Development.Power BI Service, Pro, PPU, Premium Capacity planning, workspace management, cost management, SKU's handling,Power BI Apps, Deployment pipeline.Dataflow, Datamart, Datahub.Microsoft Fabric.Power BI Metrics, Scorecards.Embedding Power BI reports into third party applications like Angular JS, .NET.Custom visualizations implementation using Python, R programming Languages.Visualization.Performance optimization using DAX studio, Vertipaq analyzer, performance analyzer.Version controlling of Power BI Reports using SharePoint/OneDrive and GitHub.Migration of existing Tableau, QlikView, VBA, Congo's reports into Power BI.Data Analysis.Data Modelling.Advanced DAX.SSAS.Power Query.Power PivotPaginated Reports/SSRS.Talend.SQL Server, TSQL.

Hyderabad, Telangana, India

• Developed Rich looking Analytical Dashboards and Reports in Power BI for Business executives to take better decision• Designed and documented the entire Architecture of Power bi Poc• Automated Power Query refresh using power shell script and windows task scheduler. • Scheduled Automatic refresh and scheduling refresh in power bi service.• Worked with Data Sources such as Teradata, MS SQL and Azure SQL Data Warehouse.• Developed Power BI Custom Visual custom table bars with Python and R programming language.• Expertise with DAX Functions such as Time Intelligence, Filter, Conditional, Parent & Child, Aggregation, Date & Time, Statistical functions.• Created Drilldowns, Drill through and Bookmarks in Power BI Reports for easy navigation and storytelling.• Analysing Qlikview and Tableau reports and migrating to Power BI accordingly.• Expertise in ‘M’ Language and Power Query for data cleansing in Power bi desktop query editor.• Created and Managed Parameters in Power BI Desktop for changing the source with different environments such as development, test and production.• Created Dynamic Dropdown measures in slicer with the help of DAX in Power BI Desktop.• Developed different types of reports such as Descriptive, Predictive and Prescriptive for end users.• Created and developed Dynamic and Static Row-Level-Security in Power BI Desktop according to the roles assigned to the users• Installed and Configured Power BI gateway (Personal/Enterprise) to schedule daily jobs to refresh reports/dashboards in Power BI Service.• Wrote SQL Queries in Teradata & Azure SQL Data warehouse to test the data and verify the quality of data.• Designed Data Models in Power Bi Designer by using schemas such as STAR, SNOWFLAKE and GALAXY.• Developed and deployed reports for the internal users in Power BI Report Server.• Worked with both the modes of connection in power bi such as Direct/Import Query Modes.

Hyderabad, Telangana, India

• Developed Power BI model used for financial reporting’s. • Expertise in writing complex DAX & LOD functions in Power BI and Power Pivot & Tableau. • Automated Power Query refresh using power shell script and windows task scheduler. • Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.• Installed and configured Enterprise gateway and Personal gateway in Power bi service.• Created Workspace and content packs for business users to view the developed reports.• Scheduled Automatic refresh and scheduling refresh in power bi service.• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.• Weekly presentation to the business users about the reports and their changes as required.• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.• Worked on all types of transformations that are available in Power bi query editor• Created stored procedures and SQL queries to pull data into power pivot model. • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.• Database creation (DDL, DML, DCL), SQL tuning, performance planning.• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.• Installed SQL 2017 SQL server Database engine, SSIS & SSRS features in the Development environment as needed.• Experience in dealing with ambiguities to create rational and functional solution from imperfect requirements• Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.

Pune Area, India

• Over 3.9 years of experience as a Data Engineer, Data Transforming, Data Modelling, Data Exploring, Statistical Analysis on Data and Software Engineer using Python.• Experienced in reading and writing different data sources, Reshaping, Pivoting, slicing, Fancy Indexing, and sub setting of data sets, Grouping, Merging, Joining, data Filtration.• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.• Using Pandas, Created Data Pipelines for keeping transactional data from various Databases (MongoDB, MySQL, MS SQL) and store in Hadoop databases like Hive .• Designed, Developed and Implemented Power BI Dashboards, Scorecards & KPI Reports, Power BI Mobile Reports, Power BI Report Server configuration, administration.• Developed Power BI model used for financial reporting of P & L and Headcount. • Expertise in writing complex DAX & MDX functions in Power BI and Power Pivot. • Developed Billed Utilization, Sales, Revenue, Contribution, Headcount related Power BI reports by implementing Row Level Security at Project Manager, Delivery Manager, Business Lead, SBU Head Level, Region, Customer Site, Practice Level.• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.• Worked on all types of transformations that are available in Power bi query editor• Created Reports using Charts, Gauges, Tables and matrix.• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.• Created Drill Down Reports, Drill Through Reports.• Build trending, matrix reports on Business requirements like, Batch ID’s, Billed Hours, Unbilled Hours, Delivery Best Estimate, Employee Project Allocation and Attrition.• Experienced in Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using agile methodologies.