Mohan Vankudoth

Product Manager

Hyderabad, Telangana, India9 yrs 7 mos experience

Key Highlights

Over 9 years of experience in data analysis and visualization.
Expert in Power BI with extensive project delivery.
Strong background in data engineering and ETL processes.

Stackforce AI infers this person is a Data Analyst specializing in Business Intelligence and Data Engineering within SaaS.

Contact

Skills

Core Skills

Power BiData AnalysisData EngineeringBusiness Intelligence

Other Skills

Apache PigApache SqoopAzure SQLAzure Service FabricBusiness Intelligence (BI)CDAXData AnalyticsData IntegrationData MiningData WarehousingDataHubDataMartDataflowDatahub

About

9.8 Years of experience in Data mining, Cleaning, Validation, Modelling, Analysis, Data Ware housing, Visualization, Statistical modelling with large data sets of Structured and Unstructured data with technologies Power BI, Tableau, Azure SQL, Azure Analysis service, SSAS, Dataflow, DataMart, Datahub, Microsoft Fabric.

Experience

9 yrs 7 mos

Total Experience

1 yr 11 mos

Average Tenure

Current Experience

Pharmerica

Sr Power BI Consultant/ Architect

Jul 2023 – Sep 2025 · 2 yrs 2 mos · United States · Remote

Implementation and delivery of Power BI platform solutions to develop and deploy analytical, reporting and scorecard/dashboards using Power BI, Power BI Report Builder, Paginated Reports.
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
Version controlling by integrating with GitHub, SharePoint and deploying the reports with the help of Deployment pipeline.
Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business.
Built Dataflow, DataMart’s to reduce redundant data modelling and transformations.
Used DAX Studio, Vertipaq Analyzer, Performance Analyzer to optimize power bi reports visuals rendering, DAX query performance and modelling optimization.
Implemented Securities such as Tenant level, Workspace, Reports, Report Pages, Object level Security, Row Level Security.
Analysed and mapped Qlik Sense data models and transformations to Power BI, ensuring data integrity and seamless transition.
Developed equivalent visualizations and dashboards in Power BI, optimizing for improved performance and user experience.
Collaborated with cross-functional teams to validate data accuracy and business logic during migration, reducing downtime and ensuring reporting consistency.
Built Power BI App to share the reports with outside tenant users.
Worked on huge semantic models which are more than 5+GB in size and optimized for the better performance.
Built daily, weekly, monthly graphs and charts of loan data using R and T-SQL queries, Stored Procedures.
Involved in designing, developing and testing of the ETL strategy using ADF to populate the data from various source systems.
Developed high level daily summary reports (Flash reports), and monthly business summary reports (Monthly Management Report) and setup different email subscriptions for different business units as needed.

Power BIPower QueryDAXDataflowDataMartDataHub+4

Indium software

Senior Power BI Consultant

Oct 2021 – Jul 2023 · 1 yr 9 mos · Chennai, Tamil Nadu, India · Remote

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 Pivot
Paginated Reports/SSRS.
Talend.
SQL Server, TSQL.

Power BIDAXDataflowDatahubSQLPython+2

Crafsol technology solutions pvt. ltd

Senior Data Analyst - Power BI, Tableau, Python, SQL

May 2020 – Oct 2021 · 1 yr 5 mos · Hyderabad, Telangana, India · Remote

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.

Power BIDAXPythonSQLAzure SQLTeradata+1

Capgemini

Business Intelligence Analyst

Nov 2019 – May 2020 · 6 mos · Hyderabad, Telangana, India · Remote

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.

Power BIDAXSQLSSASPower QueryData Analysis

Kpit

Business Intelligence Developer

Feb 2016 – Nov 2019 · 3 yrs 9 mos · Pune, Maharashtra, 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.