Bi Developer
Current•Developed complex SQL queries using stored procedures common Table expressions CTE, temporary tables to support Power BI and SSRS Reports•Developed complex calculated measures using Data Analysis expression (DAX)•Embedded Power BI Reports on salesforce portal page and also managed access of reports and data for individual users using roles.•Work in a consultative role to provide "value-added" insights in the form of analysis, interpretation and advice of campaign reporting•Responsible for managing development with regards to MI / BI reporting•Work in a consultative role to provide "value-added" insights in the form of advice & interpretation, and execution•Design / Execute / Measure high impact direct marketing experiments•Continuously improve campaign design and delivery by leveraging any and all analytical tools/techniques at your disposal•Maintain a culture of risk management and control, supported by effective processes and sound infrastructure Ability to manipulate and interpret large amount of data using Excel, SQL etc.•Experience of production routine report and developed new report from scratch •Advance knowledge in excel (pivot table, vlookup, if function, charts, Conditional formatting, index etc)•Knowledge in writing advance SQL Server Scripting (T-SQL, Stored Procedure, Views, creating Parameters, Joints etc)•Experience of maintaining and monitoring systems data, reports & dashboards through regular and ad hoc analysis of reports, interacting with stakeholders and the team for KPI’s and customer lead enquiries•Ability to collate Data, manipulate, analyse and Report to various stakeholders•Highly analytical and confident in interpreting multiple data sources to inform decision making•Ability to translate and convey statistical and other data into easy to understand using SSRS and excel•Experience in data visualisation using excel and SSRS•Experience of working with large data sets comprising of both structured and unstructured data