Mounika Nandigama

Dedicated, team player self-motivated IT professional with development and support skills coupled with a "can-do" attitude having around 6 years of IT Experience. Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge , union all , Lookup, Cache. Extensive knowledge dealing with Relational Database Management Systems (RDBMS), OLAP, OLTP systems. Extensive knowledge as a Database engineer using MS SQL 2008/2005/2012/2014/2016, BI Stack in various industries Experience in BI Development, Deployment & Maintenance of SSIS packages. Experienced in using of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task and SSIS data flow transformations like Aggregate, Derived Column, Data Conversion, Conditional Split, Multicast, Fuzzy Lookup, Union All, Merge Join, Lookup, Bulk Insert, Slowly Changing Dimension, and Pivot applying ETL concepts. Experience in identifying dimensions, attributes, hierarchies, calculating measures and dimension members in SQL Server Analysis Services (SSAS). Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), and power bi. Creating relationships in Power BI Designer, Uploading reports from the Power BI Designer. Experience in building tabular cubes using Power BI and Microsoft Office 365 and implementing DAX expressions with in Power Pivot, Power view , Power Query , Power Map Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI. •Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, and Indexes using T-SQL. Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation.