Lalitha Gopinadham

Summary

• Having 4+ 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. • Strong T-SQL experience in creating different database objects Tables, Stored Procedures, DDL/DML Triggers, Functions and User defined data types. Skilled in writing and reviewing T-SQL code and maintaining coding standards. • Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models. • Experience with Relational and Dimensional data modelling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modelling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach. • Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 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 • Excellent knowledge in creating Databases, Tables, Stored Procedures, Common Table Expression (CTE), Views, User defined data types, functions, Cursors and Indexes using T-SQL. • Expertise STAR Schema data warehouse design, slowly changing dimension, • Scheduling the ETL workflows SQL server agent jobs. Logging and Error handling during the ETL Process. • Creating packages for implementing ETL by using various control flow items like For Each Loop, For Loop, Execute SQL and Data Flow Transformations like Conditional Split, Multicast, Derived Column, Lookup, Sort, Union all etc. • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert. • Expertise in SQL Server Analysis Services (SSAS) for Developing Tabular Model, Creating Measures, Key Performance Indicator, Hierarchies, Attribute Relations, Creating Prospective and Translations. • Expertise in Analysis Using Excel, Power Pivot Reports and Drill-Through Reports Dashboards Using Warehouse and OLTP Connections. • Expert in Creating and developing Power Bi Dashboards in to rich Look. • Knowledge in all types of Database migrations with all the versions of SQL Server.

Connections