Banner Image

All Services

Programming & Development

Senior ETL and report developer

$5/hr Starting at $25

Over 12 years of extensive experience in Database Design, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2008/2005/2012, VB 6.0, C#, ASP.NET using .NET Framework in different environments. ? Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using different transformations. ? Experience in SSIS package design, development and deployment. ? Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using SSIS, Bulk Insert, DTS Import/Export utility ? Expertise in using different transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination. ? Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. ? Experience in deploying the packages in different environment and creating the package configurations using Xml configuration file and Environment variables. ? Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/2012). ? Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills. ? Experience in deploying created reports in various sources like Web browser, XML and PDF ? Experience in creating several reports such as drill down reports, parameterized reports, and linked reports, sub reports, Matrix Reports and Charts using SSRS . ? Experience in developing the reports using different data sources ? Experience in Performance Tuning, Query Optimization, Client/Server Conne

About

$5/hr Ongoing

Download Resume

Over 12 years of extensive experience in Database Design, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2008/2005/2012, VB 6.0, C#, ASP.NET using .NET Framework in different environments. ? Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using different transformations. ? Experience in SSIS package design, development and deployment. ? Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using SSIS, Bulk Insert, DTS Import/Export utility ? Expertise in using different transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination. ? Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. ? Experience in deploying the packages in different environment and creating the package configurations using Xml configuration file and Environment variables. ? Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/2012). ? Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills. ? Experience in deploying created reports in various sources like Web browser, XML and PDF ? Experience in creating several reports such as drill down reports, parameterized reports, and linked reports, sub reports, Matrix Reports and Charts using SSRS . ? Experience in developing the reports using different data sources ? Experience in Performance Tuning, Query Optimization, Client/Server Conne

Skills & Expertise

DeveloperEtl

0 Reviews

This Freelancer has not received any feedback.