Banner Image

All Services

Programming & Development

SQL Server & MSBI (SSIS-SSRS) Developer

$30/hr Starting at $100

I have 11 years experience as a SQL Server & MSBI (SSIS-SSRS) Developer. ? I have around 11 years of work experience in MS SQL Server database technology of versions 2016, 2012, 2008R2, 2005, & 2000. ? In-depth knowledge of SQL (DQL,DML,DDL,TCL,DCL) and T-SQL (CTE, PIVOT, UNPIVOT& etc.)procedural language. ? Extensive Experience of writing new complex Stored Procedures, Functions, Triggers, Cursors & Views and having good knowledge of analyzing the business logic of existing SP’s, UDF’s, TRG’s and Views were updated with new implementation of business logic. ? Complex Stored Procedures were created as they involved in gathering and aggregating data from various tables and databases using multiple joins giving me an excellent experience to create most complex queries. ? Good knowledge of performance tuning, query optimization by using indexes & few tips to improve performance to execute complex quires fast. Interacted with SQL Server Profiler and display estimated execution plan tools for the same. ? Experience in MS SQL Server Administration, installation, configuration, query optimization, back-up/recovery, running database consistency checks using DBCC, and trouble shooting. ? I have 8 years of work experience in Integration Services(MSBI-SSIS) ETL technology of versions 2005, 2008R2, & 2012. ? Extensive experience of ETL tools including Data Transformation Service (DTS) and SQL Server Integration Services (SSIS) in development, deployment and administration as well. ? Expertise in extracting, transforming and loading data between homogeneous and heterogeneous systems like SQL Server, Oracle, DB2, MS Access, Excel, Flat File and etc using SSIS packages. ? Having good experience in Incremental Loading and Data Matching. ? Good experience of using transformations like Data conversion, Derived column, Conditional split, Merge Join, Look up & etc in SSIS complex packages. ? Experience of scheduling the SSIS packages execution in SQL Server Agent and tracking the success or failure of the execution of SSIS Packages. And configuring the email notifications through SQL Server Agent. ? 5 years of work experience in Reporting Services(MSBI-SSRS) reporting technology of versions 2005, 2008R2 & 2012. ? Familiar with SSRS server configuration, deployment & administration of Report Manager. ? I have good overview knowledge in Analysis Services(MSBI-SSAS) cube technology of version 2008R2. ? Good knowledge of SSAS dimensions and cube development. ? Having good experience of OLAP database models such as star and snow flake schemas. ? Good knowledge of developing and deploying WPF & ASP.NET web technologies. ? Excellent communication skills, preparing project related documentation, knowledge transferring and sharing innovative ideas with team and end user client. Working dedicatedly on projects and understanding the client requirements and delivering projects/tasks on time to the full satisfaction of the client.

About

$30/hr Ongoing

Download Resume

I have 11 years experience as a SQL Server & MSBI (SSIS-SSRS) Developer. ? I have around 11 years of work experience in MS SQL Server database technology of versions 2016, 2012, 2008R2, 2005, & 2000. ? In-depth knowledge of SQL (DQL,DML,DDL,TCL,DCL) and T-SQL (CTE, PIVOT, UNPIVOT& etc.)procedural language. ? Extensive Experience of writing new complex Stored Procedures, Functions, Triggers, Cursors & Views and having good knowledge of analyzing the business logic of existing SP’s, UDF’s, TRG’s and Views were updated with new implementation of business logic. ? Complex Stored Procedures were created as they involved in gathering and aggregating data from various tables and databases using multiple joins giving me an excellent experience to create most complex queries. ? Good knowledge of performance tuning, query optimization by using indexes & few tips to improve performance to execute complex quires fast. Interacted with SQL Server Profiler and display estimated execution plan tools for the same. ? Experience in MS SQL Server Administration, installation, configuration, query optimization, back-up/recovery, running database consistency checks using DBCC, and trouble shooting. ? I have 8 years of work experience in Integration Services(MSBI-SSIS) ETL technology of versions 2005, 2008R2, & 2012. ? Extensive experience of ETL tools including Data Transformation Service (DTS) and SQL Server Integration Services (SSIS) in development, deployment and administration as well. ? Expertise in extracting, transforming and loading data between homogeneous and heterogeneous systems like SQL Server, Oracle, DB2, MS Access, Excel, Flat File and etc using SSIS packages. ? Having good experience in Incremental Loading and Data Matching. ? Good experience of using transformations like Data conversion, Derived column, Conditional split, Merge Join, Look up & etc in SSIS complex packages. ? Experience of scheduling the SSIS packages execution in SQL Server Agent and tracking the success or failure of the execution of SSIS Packages. And configuring the email notifications through SQL Server Agent. ? 5 years of work experience in Reporting Services(MSBI-SSRS) reporting technology of versions 2005, 2008R2 & 2012. ? Familiar with SSRS server configuration, deployment & administration of Report Manager. ? I have good overview knowledge in Analysis Services(MSBI-SSAS) cube technology of version 2008R2. ? Good knowledge of SSAS dimensions and cube development. ? Having good experience of OLAP database models such as star and snow flake schemas. ? Good knowledge of developing and deploying WPF & ASP.NET web technologies. ? Excellent communication skills, preparing project related documentation, knowledge transferring and sharing innovative ideas with team and end user client. Working dedicatedly on projects and understanding the client requirements and delivering projects/tasks on time to the full satisfaction of the client.

Skills & Expertise

Microsoft SQL ServerSoftware DevelopmentSQLSsisSSRS

0 Reviews

This Freelancer has not received any feedback.