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