Employment History 

• SQL/Power BI Developer

  Colaberry Inc

  January 2018 - Present

  Develop complex Power BI reports and dashboards with Key Performance Indicators (KPIs), and visuals with drill-down and drill-through features to provide business solutions for clients
   Schedule and deploy reports for clients using apps, mobile devices, and email in-box
   Use Power BI Gateways to keep the reports and dashboards up to date.
   Use Role Level Security to manage enterprise data access.
   Maintain and modify existing Power BI reports and dashboards based on users’ feedback
   Import data from sources such as SQL Server DB, CSV File, Excel, Flat file, XML to Power BI Desktop to generate reports
   Create calculated columns, measures and other complex calculations using DAX
   Developed Proof of Concepts (POC) for various projects using Power BI
   Work with T-SQL to create tables, views, index, constraints, temp table, CTE, stored procedures, functions, joins, triggers, and data manipulation functions for data requirements and analysis purpose
   Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages.
   Develop customized ETL packages using SSIS to perform data extraction, transformation, and loading between source and destination systems using SSIS for different business needs. Used various transformations like Data conversion, Derived Column, Conditional Spilt, control flow tasks and containers among others.
   Develop various SSRS reports/Dashboards as requested by the clients including Sub-Reports, Drilldown, Drill through and Parameterized reports; Schedule and deploy reports in Report Server
   Participate in Agile/scrum meetings and project planning sessions with project managers, business analysts, and team members to analyze business requirements and outline the proposed solution
  Environment: Power BI Desktop, Power BI Publisher, SSIS, SSRS, SQL Server 2016/2014, Excel, Notepad++