Charan Chavana

Application Systems Engineer 6 @Wells Fargo

Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools) worked on Azure suite: Azure SQL Database, Azure Data Lake(ADLS), Azure Data Factory(ADF) V2, Azure SQL Data Warehouse, Azure Service Bus, Azure key Vault, Azure Analysis Service(AAS), Azure Blob Storage, Azure Search, Azure App Service, Azure data Platform Services. Worked with different methods of logging in SSIS. Extensively worked on Facts and Slowly Changing Dimension (SCD) tables. Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse. Engineered and implemented fully automated end-user, data migration solution to eliminate business downtime during acquisition/merger using PowerShell. Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema. Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters. Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity. Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD. Maintaining jobs for data messaging from development server to test server for generating daily reports. Used data conversion tasks in SSIS to load the data from flat file to SQL Server database. MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.