• 12+ years of experience in Design, Development and Management of Business Intelligence(BI) Systems using various Microsoft Technologies having varied Industry experienceincluding Insurance and Ecommerce domain.• Extensive Experience in IT as a professional specializing in System Architecture, DetailDesign, Data Modeling, and Data Integration using SSIS and Data Publishing through BI toolssuch as SSRS, Domo, Power BI and Excel.• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.• Excellent in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbingand Data Migration, also created Indexed Views, complex Stored Procedures, Triggers,effective functions to facilitate efficient data manipulation and data consistency.• Extensive experience with designing, configuring, and supporting systems from developmentto production.• Strong knowledge of data warehousing, including Extract, Transform, and Load Processes(ETL).• Proficient in query optimization and effective database management in different versions ofMS SQL Server.• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis,Physical and Logical design, Resource Planning, Coding, Testing and implementing businessapplications.• Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling,Snowflake Modeling, fact and dimension tables.• Wide exposure to insurance, claims, marketing and e-commerce domain.• Solid experience in ASP.NET and C# programming language.• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.• Ability to work individually and as part of a cross functional team.• Currently guiding and managing team of three Developers.• Demonstrated sense of logic, decision-making and problem resolution with an excellent abilityto translate business requirements into programming specifications.• Excellent communication, written, analytical and organization and collaboration skills.• Attention to detail and commitment to quality of work, passion to learn and improvise.• Ability to focus and remain focused on key deliverables.