SQL BI / Power BI Developer

Job description / Role

• Over 5 years of experience in developing BI applications utilizing SQL/PLSQL, BI stack, Power BI or Tableau.
• Proficient in using MS Power BI to design and create dashboards and reports
• Involved in Business Analysis of the OLTP and OLAP data and in decision support. Extensive database programming.
• Experienced in Building SSAS Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripts
• Experience in writing T-SQL Stored procedures, Triggers, Constraints, and Indexes using various DDL and DML commands.
• Developed T-SQL scripts for performing automation tasks, Performed and fine-tuned Stored
• Procedures and SQL Queries and User Defined Functions.
• Strong knowledge of Data Warehousing methodologies and including star schemas, snowflakes concepts.
• Used N-tier architecture for presentation layer, the business and the data access layers and were coded using C#, worked with agile methodology for application development.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Proficient in Creating, configuring workflows designed in MS SQL Server Integration Services (SSIS).
• Experience in Reporting Services, Power BI (Dashboard Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse.
• Designed ETL using SSIS Packages to reprocess any date data at any time using Reprocess Logic.
• Developing C# scripts in SSIS and automating tasks using C#.
• Maintaining the Log and Audit information in SQL tables, experienced in providing Logging, Error
• Handling by using Event Handler for SSIS Packages.
• Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Designing current Oracle database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed data quality analysis using advanced SQL skills. Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensive SQL querying on Staging, Data warehouse and Data Mart.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Strategic expertise in design of experiments, data collection, analysis and visualization
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Involved designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View
• Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Have knowledge of Big Data Technologies like Hadoop, Cosmos etc.
• Excellent analytical, communication and interpersonal skills.
• Proficient in technical writing and presentations and a good team player.
• Strong investigative and troubleshooting skills.