Madhusudhan Rao C.

• 12 + years of experience in IT industry as report developer using business intelligence tools Big Data Analytics Tools ,IBM Cognos BI 8 & 10 and Power BI with Azure Cloud. • Understanding the customer data requirements, platform selection, design of the technical architecture, design of the application and interfaces, and development, testing, and deployment of the proposed solution. • To be able to perform detailed analysis of business problems and technical environments and use this in designing the solution; • Flexible to changing conditions and possessing high level of integrity process. • Environment Setup for Development and Go Live Database on primes and Azure Cloud. • Designing the transformation and extraction jobs as per the requirements. • Creating the Database monitoring scripts and Write complex Queries for Business Operation. • Regular data extraction from different Data sources, Analytics. • Own the user registration process and profile completeness to identify areas for improvement • Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics. • Involved in Building models, Reports, dashboards and published them using Power BI Desktop. • Analyzing the Model requirement and designing Meta data modules by using Power Models. • Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI and providing access to different user groups like sales, operations and finance team needs. • Involved in Architecting, Design, developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling. • Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service. • Assigning Power BI Pro licences to the users, configuring role base security by creating different roles in Azure Analysis services and providing access to app workspaces and apps. • Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables. • Created Azure Data Lake Analytics U-SQL jobs for transforming data in Azure Data Lake Store to move from Raw to Stage. • Involve the Power BI reports, dashboards, data sets data refreshments as per requirements. • Involve the power bi gate way services, analysis services. • Involved in design and development of multiple Power BI Dashboards and reports. • Architecting, Designing and developing complex databases objects and constantly monitoring the daily schedules and provides data to the adhoc requests from the business users. • Managing data privacy and security in Power BI • Extensively involved in designing and developing the power BI Data model using multiple DAX expressions to build calculated columns and calculated measures.