Microsoft Platform knowledge on Azure, Power BI, Sql Server, the Microsoft BI .Business Intelligence design and implementation using Microsoft Business Intelligence stack (SSIS, SSAS and SSRS)SQl Server 2016 experiencePowerBI using tabular models, Power Pivot, Power BI Desktop & Power querySSAS tabular data model design, optimisation and query using DAXSSIS design and development of ETL workflows, SSIS automation Complex MDX scriptingMOLAP,ROLAPData warehouse solution architectureClient engagement including prototype reviews and requirements gatheringData modelling: Dimensional/Kimball, 3NF/InmonBusiness process analysis and modellingDocumentation (business focused, technology focused and project focused)

Report Studio:-Worked with various kind of reports like list report, cross tab, chart, Repeater and combination reports.-Developed Complex reports which involved multiple prompts (value prompts, Data & time prompts, Text box prompts) and Filters, Conditional formatting, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.-Created Reports using Render variable and conditional Block.-Customized the reports by adding calculations, conditions, functions and providing Security in Framework Manager.-Implemented Master Detail Relationship and Drill-through reports.-Involved in scheduling and deployment of the reports.Transformer:-Hands on knowledge of Designing and creation of Cube using Power play Transformer.-Creation of regular/calculated dimensions, measures and calculation in Cognos Transformer. -Apply security at Cube.-To debug the Cube using analysis studio.-Involved in Production Support and understanding existing business processes, data analysis requirements.Framework Manager:- Designing and Development knowledge of Framework Manager Models based on Star Schema with layered approach. - Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.- Created folders, filters, namespaces, Model query subjects, query items and complex calculations in Framework Manager. - Worked with entity-relations in Framework manager. - Implementation knowledge of different level of Security in Framework Manager.

Working as a Cognos Report developer.Intrested in learning new tools related to datawarehousing.