Banner Image

All Services

Programming & Development

MSBI, powerbi developer

$10/hr Starting at $30

Having experience in developing complex ETL Packages and experienced at all the Transformations in SSIS. Have experience in the development of SSIS packages and SSRS reports. Well versed with Performance tuning in SSIS and created scheduled jobs. Developed various operational Drill-through, Drill-down, Sub Reports and Checkbox Word Reports Excellent T-SQL development skills in writing complex queries by joining multiple tables, Good at writing stored procedures, triggers and user defined functions. Created complex Checkbox word reports in SSRS. Dynamically scheduled SSRS Reports by Data driven subscription and automated them. Having good experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Performance Tuning, Query Optimization Good at optimization tools such as SQL Profiler. Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks. Worked on automated/dynamic Variables in SSIS. Created SSIS packages to export and import data from different flat files. Analysing data and re-mapping fields based on business requirements. Optimized the database by creating various clustered, non-clustered indexes and index views, using sorting and joining tables. Experienced in creating, designing, processing of cubes using SSAS. Good at creating and maintaining analysis services objects such as cubes, dimensions, measures. Created bookmark and toggle reports in Power BI. Implemented different custom visualization in Power BI and worked on different kind of slicers. Created Dashboard, Reports and DAX in Power BI. Created drill down reports and navigation dashboards in Power B Experienced in Tableau.

About

$10/hr Ongoing

Download Resume

Having experience in developing complex ETL Packages and experienced at all the Transformations in SSIS. Have experience in the development of SSIS packages and SSRS reports. Well versed with Performance tuning in SSIS and created scheduled jobs. Developed various operational Drill-through, Drill-down, Sub Reports and Checkbox Word Reports Excellent T-SQL development skills in writing complex queries by joining multiple tables, Good at writing stored procedures, triggers and user defined functions. Created complex Checkbox word reports in SSRS. Dynamically scheduled SSRS Reports by Data driven subscription and automated them. Having good experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Performance Tuning, Query Optimization Good at optimization tools such as SQL Profiler. Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks. Worked on automated/dynamic Variables in SSIS. Created SSIS packages to export and import data from different flat files. Analysing data and re-mapping fields based on business requirements. Optimized the database by creating various clustered, non-clustered indexes and index views, using sorting and joining tables. Experienced in creating, designing, processing of cubes using SSAS. Good at creating and maintaining analysis services objects such as cubes, dimensions, measures. Created bookmark and toggle reports in Power BI. Implemented different custom visualization in Power BI and worked on different kind of slicers. Created Dashboard, Reports and DAX in Power BI. Created drill down reports and navigation dashboards in Power B Experienced in Tableau.

Skills & Expertise

AnalyticsExtract Transform and LoadPower BIReportsSoftware DevelopmentSQLSQL Server Integration Services (SSIS)SQL Server Management Studio (SSMS)SQL Server Reporting Services (SSRS)Writing

0 Reviews

This Freelancer has not received any feedback.