• Worked as a Senior Business Intelligence developer in an Agile process.• Written Stored Procedures, Functions, Views, Triggers and dealing with in memory, Temporal tables with column store indexes using SQL 2016 and 2017 (Recently upgraded).• Worked on SSIS Packages (ETL and ELT) to handle different processes as part of the application using Visual Studio 2015 and created dashboards and visualizations using Power BI.• Utilized Power BI (Power view) to create various analytical dashboards that depicts KPIs such as capitation amounts paid to the providers along with slicing and dicing for the business team to make decisions.• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, and Bar charts.• Worked on SSRS reports (Drilldown, Drill through, Sub reports etc..) and deploying them to SSRS Web portal.• Supported 24x7 PROD issues in order to send out payments to the providers on time.

Worked as a Team Lead - 1. Worked with clients on various domains like Financial, Insurance, Human Resource and Retail. 2. Software / Tools: Visual Studio 2012, 2010, 2008, .NET 2005/2008/2010, TFS, VSS, SharePoint Designer.3. Databases : SQL Server 2012, 2008 R2, 20054. Operating Systems : Windows Server 2012, 2008 & 2003, Windows 10,8,7,XP5. Full SDLC experience including requirements gathering, designing, implementing applications.6. Data Mapping and Data Lineage analysis & documentation for moving legacy processes to new systems.7. Database design, Data Modeling, and Data Profiling using ErWin for SQL Server & Oracle databases.8. Experience creating Conceptual, Logical, and Physical Data Models as well as building and maintaining Data Dictionaries.

Job Duties: 1. Project deals with superannuation fund2. Participated in workshops in order to discuss majorly on business requirements for AUSTQ fund.3. Created SSIS Packages to load the maintenance data from multiple excel files on weekly basis.4. Scheduling jobs and fixing the issues when its fail.5. Developed Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).6. Running SQL profiler traces to check any issues with the application

Building Datamarts, ETL Workflow, SSIS packages

1. Extensively worked on performance tuning of the ETL process and SQL optimization on a large database.2. Developed data Mappings between source systems and warehouse components.3. Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.4. Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.5. Extract data from access, excel, flat file, and different data base and load in SQL data base Using SSIS packages.

Create MS Sql Server stored procedures, triggers, functions, etc. to support health care data provider business lists.Creating ETL processes to import, export and transform data between sources and production databases.