Employment History 

• SQL / Power BI Developer

  Colaberry Inc

  June 2017 - Present

  • Worked closely with visual design team to select the appropriate visualizations for BI deliverables.
  • Implemented tasks (both personal and On-Premises) to schedule Power BI Gateway and Dashboard refreshes at regular intervals.
  • Troubleshoot and created complex calculations using DAX.
  • Worked with the business to document and develop KPIs for the calculations in the Power BI and SSRS
  • Involved on deciding which KPIs and metrics to use in the reports.
  • Build Dashboard by Using complex calculation and DAX formulas and generate various reports in Power BI by using different visualization like charts, geographical maps, matrix, etc. by Identifying the Key Performance Indicators (KPIs)
  • Participated Gathering the requirements, Creation/review of Business, Functional requirement Documents for business systems.
  • Involved in writing various DB objects like user defined functions, views, usage of indexes for accomplishing various tasks.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.
  • Involved in Designing and developing data marts and business intelligence using multi-dimensional models - star schema.
  • Participated in AGILE iterative development methodology.
  • Involved in complete Software Development Life Cycle (SDLC).
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
  • Designed and built reliable SSIS packages with error handling and notification techniques to maintain the integrity and notify responsible parties in the event of an error.
  • Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.
  • Created SSIS Packages using Transformation like Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
  • Involved in the data mapping sessions and creation of Data dictionary.
  • Follow Agile Methodology to keep track of projects and maintaining schedule by conducting daily scrums and bi-weekly sprints.