Banner Image

All Services

Programming & Development

SQL and MSBI Developer

$5/hr Starting at $25

Having 5+ years of IT experience in Business Intelligence using Microsoft Business Intelligence tools of SSIS, SSRS and SSAS. ? Worked extensively in MSBI (SSRS, SSIS, SSAS), and well versed with RDBMS like MS-SQL server. ? Expertise in Developing SSRS reports and Technical solutions related to SSIS and SSAS implementations. ? Extensive hands on experience in Designing and developing reports using SSRS, developing cubes using SSAS and developing reports using SSAS cube as a data source and developing SSIS packages for integrating data from different sources in to a data warehouse. ? Involved in Business Analysis of the OLTP and OLAP data and in decision support. ? Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools. ? Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL Server. ? Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages. ? Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, Grouping Functionality and subtotals for the respective reports using SSRS 2008R2/2012. ? Extensive database programming Experience in writing T-SQL Stored procedures, Constraints and Views using various DDL and DML commands. ? Experienced in creating various Parameterized, Cascaded, Linked, and Drill-through and Drill-Down reports. ? Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources. ? Efficient in up gradation and migration from SQL Server 2008R2 to SQL Server 2012. ? Experienced in creating OLAP cubes defining the dimensions and relationship between dimensions and measure groups. ? Strong investigative and troubleshooting skills. ? Capable of forming and maintaining positive and productive working relationships in internal/external and team environments. ? Quick learner and good performer both in team and independent job environments.

About

$5/hr Ongoing

Download Resume

Having 5+ years of IT experience in Business Intelligence using Microsoft Business Intelligence tools of SSIS, SSRS and SSAS. ? Worked extensively in MSBI (SSRS, SSIS, SSAS), and well versed with RDBMS like MS-SQL server. ? Expertise in Developing SSRS reports and Technical solutions related to SSIS and SSAS implementations. ? Extensive hands on experience in Designing and developing reports using SSRS, developing cubes using SSAS and developing reports using SSAS cube as a data source and developing SSIS packages for integrating data from different sources in to a data warehouse. ? Involved in Business Analysis of the OLTP and OLAP data and in decision support. ? Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools. ? Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL Server. ? Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages. ? Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, Grouping Functionality and subtotals for the respective reports using SSRS 2008R2/2012. ? Extensive database programming Experience in writing T-SQL Stored procedures, Constraints and Views using various DDL and DML commands. ? Experienced in creating various Parameterized, Cascaded, Linked, and Drill-through and Drill-Down reports. ? Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources. ? Efficient in up gradation and migration from SQL Server 2008R2 to SQL Server 2012. ? Experienced in creating OLAP cubes defining the dimensions and relationship between dimensions and measure groups. ? Strong investigative and troubleshooting skills. ? Capable of forming and maintaining positive and productive working relationships in internal/external and team environments. ? Quick learner and good performer both in team and independent job environments.

Skills & Expertise

AnalyticsData ManagementEtlEvent PlanningLayout DesignMicrosoftMicrosoft SQL ServerModelingOlapProgrammingRdbmsReport WritingReportsServer AdministrationSoftware DevelopmentSQLSsasSsisSSRST SQLTroubleshootingWriting

0 Reviews

This Freelancer has not received any feedback.