Home

Narendra Kilari - Power BI Developer

[email protected]

Location: Tampa, Florida, USA

Relocation:

Visa: H1B

Name: Narendra K Email: [email protected] Phone: 813-331-5805 SUMMARY Around ~13 years of total professional experience as a BI Developer, ETL Developer in various industrial domains like Finance, Banking and Health Care. Experience in developing BI Applications utilizing SQL Server, BI Stack, Power BI and Tableau. Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server with expertise on data normalization. Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support. Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity. Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints. Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc. Good understanding in Database and Data warehousing concepts (OLTP & OLAP). Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages. Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS). Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP. Experience creating ETL processes from source and link data to identify trends and relationships between different pieces of data, draw appropriate conclusions, and translate analytical findings into risk management and marketing strategies that drive value. Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI. Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database. Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes. Worked on Power BI and prepared dashboards using Tableau to make it more attractive. Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications. Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data. Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources. Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio. Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications. Experience in Reporting services, Power BI (Dashboards Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services. Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training. Keywords: business intelligence information technology microsoft Delaware