G Sumitra

Summary

• Having 5 years of IT experience in the areas of Microsoft Business Intelligence (MSBI) applications primarily using Microsoft SQL Server 2012/2014/2016. • Strong knowledge and Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI. • Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation. • Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2016/2014/2012/2008. • Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2016/2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014. • Experience in writing complex SQL queries involving multiple tables inner and outer joins. • Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. • Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications. • Worked Extensively on ETL process using SSIS package. • Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation. • 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. • to newer version of MS SQL Server 2012. • Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio. • Expertise in Functional testing, Manual Testing, Automated Testing, User Acceptance testing (UAT), System testing in working environments. • Experienced in creating interactive dashboards and scorecards utilizing Power BI. • Hands on experience in Power BI service.

Connections