Abilash Pothula

Background

About Abilash Pothula

Having 5+ years of IT Experience in Development and support in the areas of Microsoft Business Intelligence (MSBI), Power BI Reporting and having Knowledge in MSBI-SSRS and Data Warehousing (DW) applications primarily using Microsoft SQL Server 2008/2012/2014. · Involving in requirement gathering, system study & analysis. · Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation. · Designed and developed stored procedures, queries and views necessary to support SSRS reports. · Created various kind of reports like Tablix, matrix, chart drill through, drill down, linked,parameterized,cascaded,sub report. Experience in building SSAS Tabular Model cube from scratch in databases with different measures and dimensions. Experience in performance tuning, processing and deployment of cubes. Seasoned in building Tabular models within Power BI Desktop and writing complex DAX queries to create measures and calculated columns; Highly skilled in Analyses Service, particularly in building both Tabular and Multidimensional models (OLAP, Cubes) on top of DW/DM/DB, and writing complex DAX against the models. Experience in cube partitioning for better database performance. · Good experience in configuration and maintain Report Manager and Report Server for SSRS. · Deploying and Scheduling the Reports and applying security on reports and report folders in Report Manager. · Imported data from SQL Server DB to Power BI and using various visualizations to generate reports. · Created DAX Queries to generate computed columns, measure and tables using existing structured data. Worked on couple of Power BI complex reports with performance tuning · Deployed the Power BI report and Generated dashboard in Power BI Services. · Used Power BI Gateways to keep the dashboards and reports up to date. · Analyzed data models, data relationships, and dependencies for greatest optimization. · Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations. · Strong working experience on SQL Server Development, Implemented Performance Tuning at various levels. · Capable of performing under minimal supervision, multi-tasking, meet deadlines as an individual contributor and a committed team player.