SQL BI Analyst - 222149

Candidate No:  222149
SQL BI Analyst
Location:  Johannesburg
Asking Salary:  R 450 Per hour
Availability:  Immediate

  • Over 9+ years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS). Power BI, Power Pivot, M, T-SQL, PL SQL, DAX., Informatica Power center.
  • Expertise in analyzing, designing, and developing Client/Server, Business Intelligence (BI) database applications using MS SQL Server 2012/2008/2005/2000, SQL Server Integration, Reporting & Analysis Services.
  • Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Involved in creating numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).
  • Involved in designing T-SQL programming artifacts such as complex queries, stored procedures, triggers (DDL and DML), indexes, and user-defined functions.
  • Strong debugging skills and the ability to solve complex problems.
  • Extensive experience in Tuning SQL queries& improving the performance of the Database.
  • Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
  • Built the data cubes by implementing SQL Server OLAP services in SSAS.
  • Used MDX script to create dimensional cubes and query data.
  • Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map.
  • Managed report by using SSRS tools such as report management, report delivery and report security.
  • Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
  • Exposure to all phases of Software Development Life Cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using Multidimensional Expression (MDX).
  • Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008
  • Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
  • Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
  • Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.