Banner Image

Skills

  • Agile Development
  • Business Intelligence
  • Career Development
  • Component Development
  • Data Management
  • Data Warehouse
  • Design
  • Management
  • Microsoft SQL Server
  • Oracle Bi Publisher
  • Server Administration
  • Software Development
  • SQL
  • Team Management

Services

  • Senior BI Developer

    $5/hr Starting at $25 Ongoing

    Dedicated Resource

    Career Profile More than 13 years of hands-on experience in designing and developing data warehouse and Business Intelligence solutions adhering to Agile values and principles. Proficient in client interaction...

    Agile DevelopmentBusiness IntelligenceCareer DevelopmentComponent DevelopmentData Management

About

More than 13 years of hands-on experience in designing and developing data warehouse and Business Intelligence solutions adhering to Agile values and principles. Proficient in client intera

SQL Server/BI/DW Skill Set

• Data Warehouse Design and Data Modelling
• SQL Server 2012/2016 (SSIS, SSAS, Tabular)
• Azure Data Lake
• Power BI (Power Pivot, Power Query, Power BI Desktop)
• PowerApps
• T-SQL, DAX, U-SQL, PowerShell, C#, R
• Query Tuning



Work Experience

HCA International (Sep 2018 – Present)
KPI
One of the key insurance providers with an agreement with HCA being the first point of contact for their customers, wanted to see the overall service quality provided by HCA to their customers. As part of this it was required to measure certain key drivers over a period of time and produce some complex reports to highlight the performance and actionable areas. Power BI is used as the reporting framework while CRM 365 Online and various on-prem SQL Server as the data source.
Responsibilities:
• Data Modelling and solution architecture
• Requirement analysis and meeting with various stake holders to understand the underlying data systems
• Report design specifications
• Presentation of the data-model/mockup-reports to various stake holders
• Designing ETL framework for storing CRM data into the database
• Integrating PowerApps with Power BI to design actionable reports

Apart from project work I also support BAU team in fixing the slow running jobs/packages/t-sql queries. Also, designed a central Job monitoring system with detailed task and error level tracking enabling BAU team to easily track the progress and history.

Freshfields (Jun 2018 – Aug 2018)
Lawyers Experience Reports
Building and supporting various type of SSRS reports for Lawyers across the globe based on highly customized requirements using SSAS tabular model as the source and DAX as the query language.





NELCSU (Aug 2013 – May 2018)
DQ Dashboard
To find the gaps/duplicates early in the Data load cycle