A couple of words about me

Sr. BI Developer

I am passionate about Business Intelligence and the ability to develop evidence-based policy and strategy to drive operations in line with organisational objectives.

BI

 

Professional Summary

  • An accomplished, quality-driven IT professional with over 15 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 6.5-2014 Developer/BI Developer.
  • Domain expertise in Retail, Finance (Loans/Securities), Real Estate, Work Order Management, Mining Operations, and Prescriptive Analytics.
  • Extensive experience in BI Solutions using SSIS, SSAS, SSRS and Tabular.
  • Extensive experience on data/system analysis, design, development, testing and implementation of projects in Software Development Life Cycle.
  • Hands on Experience in Installation, Configuration, Managing, Monitoring and Troubleshooting of SQL Server 2005-2014 on different Windows Environments.
  • Excellent understanding of Relational Database Systems, Normalization, Data Warehousing and Data Mining.
  • Excellent T-SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions.
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Experience in building Data Integration and Workflow Solutions for Extracting, Transforming, and Loading data with SSIS packages and BCP utility.
  • Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
  • Extensive experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS) and excellent understanding SSIS Control Flow items and SSIS Data Flow items.
  • Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages, as well as deployment to the SSIS Catalog.
  • Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterised and Cascading Reports with multiple formatting based on T-SQL/MDX/DAX queries using SQL Server Reporting Services (SSRS) 2005-2014.
  • Good understanding of Data Warehouse concepts (Kimball model/Star-schema).
  • Skilled in creating MDX cubes and dimensions and their performance optimisation
    Developed report and dashboards using various reporting tools: PowerPivot, DataZen, XLCubed, Panorama NovaView, SSRS 2005-2014, MS Excel – PivotTable/PowerView.
  • Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
  • Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilising latest versions (2005/2008) and features.
  • Experience In the integration of SSRS Reports using various web parts into Dashboards and Sharepoint

Certifications

I have a strong belief in industry qualifications and hold the following certifications:

  • TOGAF™ 9 Certified
  • ITIL v3 Certified Specialist
    Microsoft Certified Solution Expert: Data Management and Analytics (BI)
  • Tableau Desktop 9 Certified Professional
  • Cloudera Certified Developer for Apache Hadoop (CCDH).
  • Cloudera Certified Specialist in Apache HBase (CCSHB).

Technical Skills

  • SQL Server 6.5/7/2000/2005/2008/2008R2/2012/2014 – 16 years of solid experience;
    OLAP: SQL Server Analysis Services (SSAS) 7/2005/2008/2008R2/2012/2012 Tabular/2014;
  • ETL: SQL Server Integration Services (SSIS) 2005/2008/2012/2014, custom solutions;
    Reporting tools: Tableau 9, PowerPivot, DataZen, XLCubed, Panorama NovaView, SSRS 2005/2008/2008 R2/2012/2014, MS Excel – PivotTable/PowerView;
  • Programming Languages: T-SQL, MDX, DAX, C# & VB.NET 2.0/3.5, VBA, JavaScript;
    Version Control, bug tracking tools: TFS, GitHub, VSS, TestTrack Pro;
  • Testing software: Microsoft Test Manager (MTM), HP Quality Center.
    SQL Server 6.5/7/2000/2005/2008/2008R2/2012/2014 – 16 years of solid experience;
    OLAP: SQL Server Analysis Services (SSAS) 7/2005/2008/2008R2/2012/2012 Tabular/2014;
  • ETL: SQL Server Integration Services (SSIS) 2005/2008/2012/2014, custom solutions;
    Reporting tools: Tableau 9, PowerPivot, DataZen, XLCubed, Panorama NovaView, SSRS 2005/2008/2008 R2/2012/2014, MS Excel – PivotTable/PowerView;
  • Programming Languages: T-SQL, MDX, DAX, C# & VB.NET 2.0/3.5, VBA, JavaScript;
    Version Control, bug tracking tools: TFS, GitHub, VSS, TestTrack Pro;
  • Testing software: Microsoft Test Manager (MTM), HP Quality Center.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s