Banner Image

All Services

Programming & Development

Experienced MSBI (ETL) Engineer

$30/hr Starting at $25

Around 10.8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008 R2 and SSIS 2016 in Development, Test and Production Environments on various business domains like Financial, FMCG and manufacturing. Microsoft Certified Professional: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Key Skills: SSIS, Control-M, SSRS, SQL, Asp.net, C# Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) • Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. • Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables • Experience in Performance Tuning and Query Optimization. • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL. • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports. • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

About

$30/hr Ongoing

Download Resume

Around 10.8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008 R2 and SSIS 2016 in Development, Test and Production Environments on various business domains like Financial, FMCG and manufacturing. Microsoft Certified Professional: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Key Skills: SSIS, Control-M, SSRS, SQL, Asp.net, C# Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) • Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. • Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables • Experience in Performance Tuning and Query Optimization. • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL. • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports. • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Skills & Expertise

C#Data ManagementDatabase DevelopmentDesignEngineeringEtlLayout DesignMetadata ModelingMicrosoftOlePerformance EngineeringReport WritingReportsServer AdministrationSoftware DevelopmentSQLSsisSSRSWriting

0 Reviews

This Freelancer has not received any feedback.