Yuvarani Chandran

• Over 10 yrs. Of strong industry experience in Analysis, Design, Development , Implementation and Testing of database systems using MS-SQL Server 2016/2014/2012/2008 r2/2008/2005 for both OLTP & Data Warehousing Systems, building reports using Tableau, Cognos & SSRS and designing ETL solutions in Banking, Manufacturing, Retail, Ecommerce and Cloud Services. • Experience and proficiency in SQL Server and Business Intelligence Tools such as SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Dell Boomi, SQL Server Reporting Services (SSRS), MultiDimensional eXpressions (MDX), Tableau, Cognos, Power BI. • Have sound knowledge in implementing various Data Integration from disparate Data sources and Data Warehousing solutions. • Developed complex ETL Solutions to integrate data from various legacy systems into data marts. • Strong RDBMS knowledge in SQL Server. • Expert in using SSIS to import/export data from/to multiple data sources and then applying various transformations to accommodate the business requirements. • Created & formatted conditional, drill-down, drill-through, summary, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports. • Strong RDBMS knowledge in SQL Server. • Expertise in developing Star and Snowflake Schema. • Experience in creating materialized views, complex SQL queries and SQL procedures. • Experience in Analyzing SQL queries using Execution plan, Query Analyzer, SQL Profiler. • Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages, performance tuning.