Skilled and enthusiastic IT Professional as a Microsoft Business Intelligence/Power BI Developer.
Proven experience in using the Microsoft Suite: Office Suite, SQL Server Management Studio (SSMS),
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI.
Experienced in Microsoft Power BI suite (Power BI Desktop, Power BI Service and Power BI Mobile
app), Microsoft excel pivot table and data models to gather data from different sources to deliver information to the end user.
Proficient in T-SQL programming skills like creating and maintaining Stored Procedures, User-defined Functions, indexes, Views, Tables, Constraints and writing complex queries using Joins, Sub-queries,
Derived tables and CTE.
Full System Development Life Cycle (SDLC) experience including Requirement Gathering, Analysis,
Design, Development, Testing and Implementation.
Experienced in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake
Schema, Fact and Dimensional tables and Operational Data Store (ODS).
Proficient in designing and deploying rich graphic visualizations with drill-down and drill-through menu options, parameterized, and customer interactive sorting using SSRS.
Ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and
teamwork spirit, goal-oriented, highly motivated with excellent analytical, troubleshooting, and
SQL/POWER BI DEVELOPER
September 2018 - Present
Created Power BI reports, dashboards and data models using various data sources to multiple departments in the organization, gaining key insights for the business.
Utilized the navigation features in Power BI (e.g., bookmarks, drill-through) to guide readers through a compelling data-driven story.
Published reports via the Power BI service, managing them through the distribution of apps and
monitoring usage/data refreshes/security access.
Identified key performance indicators (KPIs) with clear objectives and consistently monitor those.
Working knowledge of Power BI DAX and ability to perform and troubleshoot complex calculation and measure, calculated columns and tables.
Performed extensive documentation explaining algorithms, parameters, models, and relations.
Involved in planning, defining, and designing database based on the business requirements document.
Created complex Stored Procedures, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
Created and maintained SSIS packages to extract data from multiple sources like Excel, XML and
OLTP and consolidated them into staging tables.
Used multiple SSIS transformations such as: data conversion, derived column, conditional split to
cleanse and validate data.
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.