Worked with Financial companies for application related pricing and security applications.Expertise in creating Cell Level Security in cubes using SSAS.Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.Hands on Experience in Domo which specializes in business intelligence tools and data visualization.Manually loaded data in FACETS and have good knowledge on FACETS business rules. Worked on FACETS Data tables and created audit reports using queries.Implemented error handling and roll back process in ETL load.Worked in SDLC(Systems Development Life Cycle) for developing systems/Software.Creating and deploying parameterized reports using Power BI.Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.Experienced in debugging and performance tuning of sources, targets and mappings.
Expert in TSQL - DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.Over 7 years of MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise in MSSQL Server 2008/2012/2014/ 2016 and over 5 years of experience in Microsoft’s Business intelligence stack products like SSIS and SSRS.