Employment History 

• ETL Developer

  Colaberry Inc

  November 2020 - Present

  • Perform data extraction such as Excel, XML, JSON, and OLTP transformation, loading between systems SSIS and consolidating them into staging tables.
  • Create various operational, drill-through and dynamic reports using SSRS.
  • Use SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
  • Work on SSIS performance tuning using error handling, event handling, and re-running of failed SSIS packages using checkpoints.
  • Troubleshooting within SQL codes and SSIS Packages.
  • Generate reports according to the business requirements using SQL Server Reporting Service (SSRS).
  • Work as a collaborative team member using software SDLC including analysis of business functions, design, development, testing, and documentation as required by end-users.
  
  Visual Management Studio 2017, 2019, Microsoft SQL Server Management Studio 2017, MS Excel, PowerPoint, Windows server

• ETL Developer

  Remarkable HealthCare

  September 2018 - September 2019

   Performed the process of extraction, transforming, and loading of data using Microsoft BI Tools.
   Created database and provided constraints and user-defined rules and default
   Designed database and data modeling process.
   Created Views and store procedures for query optimization.
   Optimized the performance of queries with modification in T-SQL queries, joins, and normalized tables.

• Bi Developer

  Cardinal Financial

  October 2019 - November 2020

  • Generate reports according to the business requirements using SQL Server Reporting Service (SSRS).
  • Created database to consolidate applications coming from different sources per the business requirement.
  • Transformed data as I ensured data integrity was maintained through ETL Process.
  • Translated business goals into technical specifications.
  • Populate data warehouse using SQL Server Integration