SSAS-MODULE LEAD Job For 5-10 Year Exp In Best infosystems Ltd Chennai – 3292291

• JOB DESCRIPTION JOB DESCRIPTION 1 EXPERIENCE IN DESIGNING DEVELOPING OPTIMIZING AND ADMINISTERING TABULAR MODELS IN AZURE ANALYSIS SERVICE OR SSAS 2 EXPERTISE IN DESIGNING DEVELOPING OLAP CUBES AND DEVELOPING COMPLEX CALCULATIONS AGGREGATION S IMPLEMENTING DYNAMIC SECURITY MODEL USING MDX DAX FUNCTIONS IN AZURE ANALYSIS SERVICE OR SSAS 3 EXTENSIVELY USED PERFORMANCE MONITOR SQL PROFILER DMVS TO SOLVE DEADLOCKS TO MONITOR LONG RUNNING QUERIES AND TROUBLESHOOT CUBES 4 SQL AND T SQL ROLES RESPONSIBILITIES 1 SSAS OR AZURE ANALYSIS SERVICES LEAD DEVELOPER WITH 5 YEARS OF EXPERIENCE IN SSAS AZURE DATA MODEL DEVELOPMENT SSAS DATA MODEL DEPLOYMENT IN AZURE QUERYING DATA FROM SSAS AZURE TO BUILD REPORTS 2 DESIGN AND CREA TE SSAS OLAP OLTP TABULAR CUBES AND AUTOMATE PROCESSES FOR ANALYTICAL NEEDS 3 WRITING OPTIMIZED SQL QUERIES FOR INTEGRATION WITH OTHER APPLICATIONS MAINTAIN DATA QUALITY AND OVERSEEING DATABASE SECURITY PARTITIONS AND INDEX 4 TRAIN AND COACH O THERS IN THE TEAM 5 DESIGNING DATABASE TABLES AND STRUCTURES CREATING VIEWS FUNCTIONS AND STORED PROCEDURES 6 EXPOSURE TO SAP BUSINESS OBJECTS REPORTING AND OR POWERBI WILL BE AN ADDED ADVANTAGE.

Job Requirements: SSAS, SQL, PowerBI, Programming Development, Unit Testing, Design and Implement Complex Call flow, Impact Analysis, Reporting, Design Document, Unit Test Case Document, Impact Analysis Report