Solution Architect with over 18 years of experience in designing innovative business solutions for reputed fortune 100 clients. Skilled in Application development, Data Warehouse, Data Quality, Data Integration methods & Techniques, Investigative and Transactional reporting and strategies.✓ Broad experience in Data Warehousing, Business Intelligence, ETL, Data Quality, Data Management & Data Visualizations as part of business services across various verticals✓ Over 7 years of rich overseas experience in USA/UK; dealt with various clients spread across USA, UK, Canada and India✓ Project leading experience for both Data Warehousing and Data Migration projects. Expertise in Data Migration on multiple platforms through ETL tools✓ Having Strong experience in database design, modelling, architecting, optimizing, and querying with expert knowledge of Oracle PL/SQL & SQL Server✓ Client Liaison, Business requirement gathering and Analysis, Designing, Development and Support of BI projects; Waterfall, Iterative & Agile Methodology✓ Dimensional Modelling concepts for Data Warehouse. Experience in DWH design and Architecture. Thorough understanding of Slowly Changing Dimensions✓ Expertise in designing Real-Time Web-Services through Informatica PowerCenter✓ Involved in efforts estimation, resource planning, end-to-end design & development with ETL tools (Informatica Power Center, Pentaho), Reports development (Cognos, Tableau), Alteryx and system/process development✓ Consistently recognized for creating out of box solutions & strategies to ensure accurate and quick availability of Information with secure & flexible architecture✓ Managed delivery frameworks, Data life cycle and new technology implementation projects for streamlining related activities as per quality standards✓ Excellent interpersonal skills, people management & project management✓ Alteryx Designer Core Certified 2021Key Result Areas:o Build Data Architecture and Strategy to ensure high availability of data without any ambiguityo Delivered BI, Data Warehouse, Data integration, Data Migration, Data Visualization, Analytical Reporting, Data Analytics, Machine Learning Analytics to reputed customers.o Lead the solution design, data ingestion, transformation, conversion & error/exception managemento Hands-on in the market leading tools like Informatica, Alteryx, Tableau and SASo Capacity planning, Data Quality, Data Engineering and Data Governanceo Provided end-to-end solutions to migrate the Applications into Data Warehouses and integrate theTableau/Alteryx reporting from DWH