Microsoft Business Intelligence Developer with experience in developing Business Intelligence solutions in Agile environment in Financial services and hospitality environments. Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks with excellent communication skills for management and end users. Proactive, fast learner, self-managing, and teamwork spirit.
Platforms: Windows (2000, XP, Vista, 7, 8, 10), MS SQL Server 2012/2014/2016
Provided End-to-End solutions in Power BI from Report Development to Workspaces and App management, to Report Governance
Published developed reports to Power BI Service (Cloud).
Migrated various reports built in SSRS to Power BI.
Modeled data using DAX, Power Query according to business requirements.
Management of access and troubleshooting of reports for resolution of issues.
Training of senior level executives on self-service BI and creation reports.
Versioning and Documentation and Knowledge transfer of all work to various Juice Plus project owners.
Daily progress updates during standup meetings.
Troubleshoot and created complex calculations using DAX
Developed Proof of Concepts (POC) for various projects using Power BI.
Developed business logic using DAX to provide custom functionality in Power BI Applications.
Scheduled refreshes through the Power BI gateway to refresh Dashboard at regular intervals and appropriate dependencies
Implemented after insert, update and delete triggers to simultaneously populate multiple tables at once.
Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for
applications following SQL code standards.
Created SSIS packages to extract the data from multiple sources like Excel, XML and OLTP and consolidate them into staging tables.
Clean and transformed data from staging tables base on business requirements using various transformation and load them into a data
Maintained SSIS packages for production and test environment for incoming source application files.
Scheduling Jobs and Alerting using SQL Server Agent.
Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
Worked on Tabular Modeling Development and Multidimensional Modelling Development using SSDT
Built Measures in tabular model using DAX queries and created partitions in tabular model.
Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS tabular model
Processed and deployed tabular model and cubes to SSAS database
Environment: SQL Server 2014/2016, SSIS, SSAS, Power BI
Design and create an ETL solution to consolidate mortgage loan applications received from various sources. Numerous reports were also
created to meet the client's need
Work on all activities related to the development, implementation, administration, and support of ETL processes
Produce dashboards, Tabular and Matrix reports, charts, graphs, and gauges as per customer requirements using SSRS
Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse using various transformations
(Derived Columns, Conditional Split, Look-up, Script Component, Aggregations, Multicasting)
Develop and modify coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis and tune
SQL source queries for data load/usage of Stored Procedures for optimized performance
Enhance performance using optimization techniques - normalization and indexing, and performance tuning of queries and Stored
Procedures. Also use Performance Tuning on existing ETL packages
Followed a star schema design in data warehouse creation, which outlined measurable financial data in the fact table, along with detailed
data in surrounding dimension tables.
Design various SSRS reports as requested by the client and created and developed Sub-Reports, Drill-down reports, Drill-through reports,
Parameterized reports, and Matrix reports using SSRS
Rendered reports in different formats like PDF, Excel, etc. Scheduled to be executed automatically on a weekly or monthly basis and
Applied security on Folder and Report level and used Triggers, Linked servers, Dynamic coding, and Job processing
Hands on experience in Data Modeling, familiar with snowflake schema, star-schema, Multi-dimensional model and tabular model.
Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies, Aggregations, partitions, calculated members and
Migrated SSRS Reports and Dashboards to Power BI
Helped capture data modeling requirements using SQL queries that pulled data from multiple SQL Server databases using Query Editor
Implemented Power BI interactive dashboards-style reports utilizing slicer filters, Drill-down hierarchies, Drill through to another report
Created various Business Intelligence/ Analytical Dashboards utilizing Power BI, calculated columns and measures using complex DAX calculation and transforming data using Query Editor.
Created and managed app workspaces and collaborated with other Developers on creating complex reports and Dashboards
Environment: SQL Server 2014/2016, SSIS, SSRS, SSAS, Power BI
Interacted with users extensively in gathering the requirements and analyzing the needs of the end users
Design, Develop and Deploy reports in SQL Server environment using SSRS
Extensively formatted reports into documents using Report Services for the creation of Dashboards
Generated all daily, weekly, monthly and quarterly reports based on the user business requirements
Created reports that call Sub reports in SSRS.
Installed SQL Server Reporting Services (SSRS) and configure the reporting services configuration.
Created Tablix, Drill down and drill through reports, multi value parameter reports.
Created reports using SQL Reporting Services (SSRS) for Customized and Ad-hoc Queries.
Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
Created Parameterized reports and Linked reports with through knowledge of report serving architecture.
Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
Created objects like tables, views, stored procedures and handled performance tuning using T-SQL
Worked on property expressions, variables and configurations between SSIS packages
Good experience in working with tasks like Script Task, File System, Execute SQL task, etc. in SSIS
Deployed many packages on different servers using SSIS package Configurations.
Transformed the data using different transformations like Conditional split, data conversion, merge join, lookup, derived column, script
Used Best practices for package design, dataflow techniques, deployment and management in SSIS
Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
Environment: SQL Server 2012/2014, SSIS, SSRS
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Job Titles Held: