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.
Reviews For This Service