Sumedh Ranadhir

19+ years of rich experience in the areas of:

- Data Warehousing - BI Architect - Data Engineer - Onsite & Offshore Coordination - Data Architect - Data Migration - Database Development - ETL & BI Data Architecture - Client Relationship Management - Team Management - Kimball Methodology

• Extensive experience in managing Data Warehouse Lifecycle including Data Analysis, Database Design, Data Migration, Data Extraction and Data cleansing; successfully handled Data Migration from various Source Systems to existing or newly created Data Mart keeping in mind Kimball approach.
• Hands on experience on SSIS, SSRS, SSAS, Performance Point, Teradata, MySql, Talend and Cloud Technologies like PowerBI, Power BI Service, Azure data lake, Synapse analytics & ADF.
• Familiar with Bigdata concept i.e Hadoop ecosystem, Distributed computing.
• Hands on experience on creating Data Model and Dashboards using PowerBI and proficient in DAX, Power Query (M Language), Row level security, bookmarks, Navigation, 
• As a Data Architect, expertise in Designing conceptual, logical and physical data model by understanding data requirements. Data profiling in order to understand source data. Familiar with Data vault.
• On learning curve for Bigdata concept i.e Hadoop ecosystem, Distributed Processing, Apache spark, python, etc.
• Proficient in handling BI aspect of data warehouse i.e estimation, designing BI Architecture including HLD & LLD. Integrating data from various sources into data warehouse and generating various BI report like paginated, Matrix, Various types of chart, KPI and dashboards.
• Proven skills in creating Tables, Views, Indexes, writing Stored Procedures & Functions as well as analyzing and debugging existing complex Stored Procedures.
• Resourceful in handling all aspects of SDLC & SCRUM (PSM I Certified).
• Proven abilities in giving effective presentations to the clients and handling POCs with exposure of working in diverse domains like Oil & Gas, Banking & Financial Services, Investment Banking, Healthcare, Telecom, Retail & Manufacturing, etc. 
• A Customer-Centric Professional with proven abilities in interacting with clients, managing client challenges & suggesting technology-based BI/DWH solutions for enhancing functional efficiency of the client’s organization
• An Effective Leader with proven abilities in leading teams during the project phase (both onshore & offshore) & motivating team members to maintain deliverables as per SLAs negotiated with clients
• Possess excellent communication & analytical skills; capable of working in a fast-paced and multi-cultural environment with in-depth understanding of the various facets of Global IT Services & Delivery Framework

• Extensive experience in managing Data Warehouse Lifecycle including Data Analysis, Database Design, Data Migration, Data Extraction and Data cleansing; successfully handled Data Migration from various Source Systems to existing or newly created Data Mart keeping in mind Kimball approach.
• Hands on experience on SSIS, SSRS, SSAS, Performance Point, Teradata, MySql, Talend and Cloud Technologies like PowerBI, Power BI Service, Azure data lake , Synapse analytics & ADF.
• Microsoft certified in Analyzing and Visualizing Data with Power BI.
• Hands on experience on creating Data Model and Dashboards using PowerBI and proficient in DAX, Power Query (M Language) and bookmarks.
• Proficient in handling BI aspect of data warehouse i.e estimation, design and development of paginated, Matrix, Various types of chart, KPI and dashboards.
• Hands on experience on building logical, physical data model and Data profiling 
• Proven skills in creating Tables, Views, Indexes, writing Stored Procedures & Functions as well as analyzing and debugging existing complex Stored Procedures.
• Resourceful in handling all aspects of SDLC & SCRUM (PSM I Certified).
• Proven abilities in giving effective presentations to the clients and handling POCs with exposure of working in diverse domains like Oil & Gas, Banking & Financial Services, Healthcare, Telecom, Retail & Supply chain management, etc. 
• A Customer-Centric Professional with proven abilities in interacting with clients, managing client challenges & suggesting technology-based BI/DWH solutions for enhancing functional efficiency of the client’s organization
• An Effective Leader with proven abilities in leading teams during the project phase (both onshore & offshore) & motivating team members to maintain deliverables as per SLAs negotiated with clients
• Possess excellent communication & analytical skills; capable of working in a fast-paced and multi-cultural environment with in-depth understanding of the various facets of Global IT Services & Delivery Framework

Bachelor of Engineering