Banner Image

All Services

Programming & Development

MSBI

$5/hr Starting at $25

Expert in ETL (SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word and Text Format Data. • Expert in presenting multi platform data visualization like pie/bar/graph chart. • Expert in Database administration tasks like performance tuning, Backup and Recoveries, Project tracking, Mentoring, Report Specification, Version Controls, and Migration. • Highly experienced in using SSIS Import / Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations. • Highly experienced in strategically implementing the indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval. • Extensively worked in Migration for MS SQL 2008 to 2012 and MS SQL 2000 to MS SQL 2008 • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools • Experience in creating packages, Jobs, Sending Alerts using SQL Mail. • Expert writing SSIS Configuration, Logging, Procedural Error Handling and Data Error Handling, Master Child Load methods using Control tables. • Good Hand on Resolving complex issues and Error Handling in SSIS. • Good SQL Server Administration skills including backup recovery, database maintenance, user authorizations, Database creation, Tables, indexes, Partitions.. • A dedicated, hardworking individual with strong Logi analytics analysis and problem solving skills and able to play vital role in team or individual environment. • Expert in understanding business-data relationships, modeling data and creating data mappings. • Experienced in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension. • Highly experienced in licensing, auditing and adherence to various standards and regulations. . Experience in building ssas cubes

About

$5/hr Ongoing

Download Resume

Expert in ETL (SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word and Text Format Data. • Expert in presenting multi platform data visualization like pie/bar/graph chart. • Expert in Database administration tasks like performance tuning, Backup and Recoveries, Project tracking, Mentoring, Report Specification, Version Controls, and Migration. • Highly experienced in using SSIS Import / Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations. • Highly experienced in strategically implementing the indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval. • Extensively worked in Migration for MS SQL 2008 to 2012 and MS SQL 2000 to MS SQL 2008 • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools • Experience in creating packages, Jobs, Sending Alerts using SQL Mail. • Expert writing SSIS Configuration, Logging, Procedural Error Handling and Data Error Handling, Master Child Load methods using Control tables. • Good Hand on Resolving complex issues and Error Handling in SSIS. • Good SQL Server Administration skills including backup recovery, database maintenance, user authorizations, Database creation, Tables, indexes, Partitions.. • A dedicated, hardworking individual with strong Logi analytics analysis and problem solving skills and able to play vital role in team or individual environment. • Expert in understanding business-data relationships, modeling data and creating data mappings. • Experienced in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension. • Highly experienced in licensing, auditing and adherence to various standards and regulations. . Experience in building ssas cubes

Skills & Expertise

Admin SupportAnalyticsChild WelfareCreativeData ManagementDtsEtlImport/Export OperationsLayout DesignLikesMicrosoftModelingPackaging DesignPerformance EngineeringReport WritingReportsServer AdministrationSkillSQLSsisTeam ManagementVisualisationWriting

0 Reviews

This Freelancer has not received any feedback.