avatar

Developer - MSBI (SSIS SSRS and SQL Server) ETL ASP.NET MVC

Experience:
21 y
Experience:
21 y
Location:
560038 Bangalore
Last update:
26.07.2021
Register to Contact Freelancer
Available
Onsite hourly: 25 €
Remote hourly: N/A
English: Native
Open to Travel any country
SKILLS
10+ years of software development experience in the Private Banking, HealthCare, and Workflow Processing domains, which includes:
? Designing, coding and unit testing in ASP.NET (3.5, 2.0 and 1.1), C#, SQL Server (2000/2005/2008), and MSBI (SSIS & SSRS).
? Writing SQL Stored procedures and developing T-SQL queries, stored procedures, and performance tuning using SQL Server 2005/2008 & 2008 R2.
? SQL Maintenance Planning: Shrinking DB, DB Backup, Re-Organizing Indexes, Rebuilding Indexes, DB Defragmentation, Updating DB Statistics, Monitoring Log files Growth, Monitoring SQL extensive queries in SQL Activity Monitors.
? Performing System queries to help reduce the load in each schema or tables, scheduling DB Jobs / DB Plans, monitoring DB Server activities, and fragmenting the database to increase performance.
? Data Cleansing and Data Integrity (Data warehouse ETL), RI Check, and normalizing of data.
? Managing production support/services for clients and ensuring satisfactory resolution of all issues (Technical and project-related) on priority basis.
SSRS C# SQL Server Integration Services ASP.NET MVC ASP.NET Data warehouse software development database T-SQL Data Cleansing ETL SSIS .NET Stored procedures SQL SQL Server Log files unit testing

Description

SKILLS
10+ years of software development experience in the Private Banking, HealthCare, and Workflow Processing domains, which includes:
? Designing, coding and unit testing in ASP.NET (3.5, 2.0 and 1.1), C#, SQL Server (2000/2005/2008), and MSBI (SSIS & SSRS).
? Writing SQL Stored procedures and developing T-SQL queries, stored procedures, and performance tuning using SQL Server 2005/2008 & 2008 R2.
? SQL Maintenance Planning: Shrinking DB, DB Backup, Re-Organizing Indexes, Rebuilding Indexes, DB Defragmentation, Updating DB Statistics, Monitoring Log files Growth, Monitoring SQL extensive queries in SQL Activity Monitors.
? Performing System queries to help reduce the load in each schema or tables, scheduling DB Jobs / DB Plans, monitoring DB Server activities, and fragmenting the database to increase performance.
? Data Cleansing and Data Integrity (Data warehouse ETL), RI Check, and normalizing of data.
? Managing production support/services for clients and ensuring satisfactory resolution of all issues (Technical and project-related) on priority basis.

Main Skills

Other Skills

SSRS C# SQL Server Integration Services ASP.NET MVC ASP.NET Data warehouse software development database T-SQL Data Cleansing ETL SSIS .NET Stored procedures SQL SQL Server Log files unit testing

Work & Experience