Employment History 

• Sr. Power BI Developer

  Gainwell Technologies Inc

  August 2021 - Present

  • Gathering and documenting user requirements.
  • Provided the project manager with resource estimates and work planner for the Power BI applications.
  • Designing SQL Server objects such as tables, views, temporary tables and stored procedures.
  • Created dynamic T-SQL queries utilizing joins, functions and stored procedures.
  • Utilized Power Query to Extract, Transform and Load data from SQL server.
  • Utilized Power Pivot to create tabular data model.
  • Created KPI measures, calculated columns and Calculated tables using DAX.
  • Designed visually appealing dashboards and reports in power bi desktop.
  • Created and deployed Paginated reports.
  • Deployed Reports to Power BI report server, maintained gateway and data refreshes.
  • Maintained Row Level Security and manage User access.
  • Created SSIS applications to load data from excel files to SQL server.
  • Utilized Azure Devops to create user story, Source Code control, Pipeline builds and Release management.
  • Training end users on navigating the reports.
  • Collaborated and coordinated with fellow developers on developing, testing, implementation and documentation of new applications, automation of reports, processes and interfaces and maintenance of existing applications
  • Automated manual processes to ensure efficiency.
  • Design and develop project documents and tests as needed.
  • Troubleshooting and resolving issues with reports, queries and SSIS applications
  • Performance tuning of existing applications and queries.
  • Assist the team lead to manage and track tasks on team planner.

• PowerBi Developer

  Colaberry Inc

  October 2016 - August 2021

  PowerBI Developer
  - Extracted data multiple Sources (Files and folders, SQL server
  Databases, Microsoft Azure cloud, Power Platform, Other
  Databases, online services and other Websites), transformed the
  data and Loaded onto the tables using power query via direct
  Query and also Imports. (ETL)
  - Versatile with Query folding and have worked with M Script
  Language.
  - Performed data modelling using Power Pivot,
  - set up table relationships. Created Star Schema in PowerBI.
  - Created complex calculations and columns and KPI’s using DAX
  language.
  - Created Interactive Visuals and Reports using slicers, drill down,
  drill -through and tooltips for both Mobile Views and desktop
  View in Power BI Desktop
  - Deployed the Reports onto Power BI services, Created Visuals,
  Reports and Dashboards in Power Bi services and shared the
  same with the end users using Power apps
  - Collaborated and coordinated with fellow developers on
  developing, testing, implementation and documentation of new
  applications, automation of reports, processes and interfaces
  and maintenance of existing applications
  - Versatile in maintaining RLS (Row Level Security) and Data
  Protection
  - Performance tuning of Power BI applications.
  - Working Knowledge of using Power Bi gateway
  SSRS
  - Designed and develop Dashboards and Reports using SSRS,
  developed various types of complex reports like Drill Down, Drill
  Through, scorecards and parametrized, Gauges, Pie Chart, Bar
  Chart, color coded maps Tables and Matrix in a customized
  format as per business requirements- Experienced in writing Parameterized Queries for generating
  Tabular reports, Formatting report layout, Sub reports using
  Global Variables, Expressions, Functions, Sorting the data,
  Defining Data Source and subtotals for the reports using SSRS
  - Configured and maintained Report Manager and Report Server.
  - Working on deploying Project to Report Server.
  - Scheduled, maintained, and supported the distribution and
  access to reports at Server level.
  - Troubleshooting and resolving problems with the reports
  Designed SSIS packages to extract data from multiple sources
  such as Flat files, Microsoft excel, folders, XML files, and
  databases
  - Performed transformations on the data to verify validity,
  accuracy, completeness, split data and combined data. Some
  of the transformations utilized include lookup transformations,
  merge joins, derived columns, merge join, conditional split, data
  conversion with multiple data flow tasks.
  - Loaded the data into databases and other files
  - Reviewing existing ETL packages and suggesting improvements
  for efficiency.
  - Monitoring error logs and correcting ETL issues uncovered as well
  as building processes that prevent recurring issues in the future.
  - Implemented various Error handling and Event Handling
  Techniques to ensure efficient package execution.
  - Participation in software design discussions to enhance
  performance and solution delivery to client
  SQL server management studio (T-SQL)
  - Designing and Implementing Database Schema, Data modeling,
  creating normalized datasets, Tables, Stored procedures,
  Functions and Triggers, Constraints, Indexes, Schemas, Views,
  Temp tables, and complex SQL statements.
  - Used T-SQL to design databases and tables using normalization,
  primary and foreign keys to ensure inferential integrity.
  - Establishing data consistency, indexing and data cleanup
  procedures to maintain high quality data that can be used for
  reporting.
  - Query Optimization and Performance Tuning of Stored
  Procedures using SQL Profiler and Estimated Query plans,
  normalization, indexing and Transaction Isolation levels,
  monitoring logs to ensure the completeness of batch processes
  and scripts