Mamatha K Email and Phone Number

• Overall, 4 Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2014/2012/2008R2/2005, SSIS, SSRS and Tableau.• Expertise in SQL Server 2014/2012/2008R2/2005 Reporting Services (SSRS), SQL Server 2012/2008 Integration Services (SSIS) and in SQL Server 2012/2008 Analysis Services (SSAS) in Business Intelligence (BI).• Excellent knowledge to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like Microsoft Excel.• Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.• Experience in creating configuration files to deploy the SSIS packages across all environments.• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions and features. • Good understanding of Normalization / De-normalization, Normal Form and database design methodology.• Expertise in writing SQL Queries, Dynamics, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView, Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.• Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS). • Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.