Power Bi Business Intelligence

Professional Summary:

•Over *+ years of in-depth experience in database Design, Modeling, development and maintenance of SQL Server 2016/2014/2012/ 2008R2/2008 large scale databases.

•Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

•Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization.

•Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers

•Experienced in Data Import, Data Analysis, Data Migration, Data Cleansing, Transformation, and Integration

•Proficient in using Power BI data visualization tool to analyze and obtain insights from large datasets, creating visually compelling and actionable interactive reports and dashboards.

•In-depth knowledge of SQL queries and working with RDBMS like Oracle, SQL Server, and MySQL in Agile project methodology.

•Experienced working with ETL teams on Data Migration using SQL, SQL Azure, Azure Storage, Azure Data Factory, and SSIS.

•Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Treemaps, etc. using Power BI.

•Experience creating Filters, quick filters, table calculations, calculated measures, and parameters in Power BI.

•Have good experience in creating advanced chart types, visualizations, and complex calculations to prepare the data as per business needs through Power BI.

•Experience utilizing DAX functions like Aggregation, Counting, Logical, Information, Text, and date functions.

•Good understanding of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling

•Well versed in query optimization for performance tuning.

•Experience Working on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and an interactive dashboard helped the business get a good deal on the team's productivity.

•Proficient in data blending and increased the dashboard performance by extracting data.

•Strong commitment to organizational work ethics, decision-making, and managerial skills.

•Migrate existing SSRS reports to Power BI and create different reports and dashboards using power BI. Ability and willingness to learn new technology and deliver results in a timely manner.

•A well-organized, goal-oriented, highly motivated effective team member.

RDBMS: SQL Server 2019/2016/2014/2012/2008R2, AZURE, Snowflkae.

Languages\Tools: Visual Basic, PowerShell, C#, T-SQL, Java, Python, .Net.

Modeling Tools: MS Visio, Erwin and Oracle SQL Server Data Modeler.

Visualization: Power BI Desktop, Report Builder, SSRS, Tableau

Analysis Tools: SQL Server Analysis Service (Tabular and Multi-Dimensional)

Project Summery

Client: Veteran Affair, Baltimore, Maryland (Active Public Trust) Jun 2024 - Present

Power BI Developer/Business Intelligence specialist

Responsibilities:

Develop and deploy interactive Power BI dashboards and reports tailored to VA’s business requirements, ensuring visual engagement and actionable insights.

Lead developer for specialized, curated datasets and semantic models for Power BI reporting.

Design and develop semantic models using complex snapshot data for year-over-year reporting.

Maintain existing business intelligence capabilities through support functions and in-depth testing.

Collaborate with end users, data teams, and subject matter experts to ensure systems function properly.

Design, develop, test, verify, and implement dashboards to support data-driven decision-making.

Maintain documentation within business intelligence systems, including advanced logic, stored procedures, and queries.

Revise, update, and enhance existing Power BI dashboards to increase efficiency and automation.

Develop automated data and business intelligence solutions to support data ingestion, processing, and visualization.

Designed and implemented Power Automate flows to streamline data refresh, approval workflows, and alert notifications, reducing manual tasks by 40%.

Integrated Power BI with Power Automate to trigger real-time alerts and email reports based on data-driven conditions.

Collaborated with business users to identify repetitive tasks and deliver automation solutions using Power Automate, improving operational efficiency.

Integrate data across multiple systems to provide comprehensive business intelligence insights.

Work closely with executive and administrative teams to provide analytics for strategic planning.

Provide mentoring, training, and guidance to staff on dashboard development, management best practices, governance, functionality, accessibility, and design.

Connect Power BI to Dataverse as a primary data source, utilizing both Live and Import connectivity modes for optimal performance.

Work across all environments (Dev, UAT, QA, and Production) to ensure seamless deployment and functionality of reports.

Collaborate with cross-functional teams to integrate data from Dynamics 365, CRM, and Power Apps into Power BI solutions.

Optimize data models and DAX calculations to enhance reporting efficiency and accuracy.

Monitor and troubleshoot Power BI report performance, ensuring data integrity and timely refreshes.

Document workflows, data models, and DAX calculations to maintain a robust knowledge base for the team.

Utilize Power Query for data transformation and cleansing, streamlining reporting processes.

Implement row-level security and application security layer models to ensure data confidentiality and compliance.

Participate in Agile/Scrum ceremonies, including sprint planning, backlog grooming, and retrospectives.

Environment: Power BI, MS SQL Server 2012/2014, SSIS, SSRS, Excel, SSMS, Jira (Atlassian), Facets, Dynamics 365, CRM, and Power Apps, Dataverse,ADF

Client: Humana, Louisville, Kentucky Aug 2021- Jun 2024

SQL / Power BI Developer

Responsibilities:

Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows Involved in creating functional and technical specification documents after gathering requirements from business.

Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.

Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.

Building Analysis Services reporting models

Developed visual reports, dashboards, and KPI scorecards using Power BI desktop

Connected to data sources, importing data, and transforming data for Business Intelligence

Excellent in analytical thinking for translating data into informative visuals and reports

Able to implement row-level security on data and understand application security layer models in Power BI

Proficient in making DAX queries in Power BI desktop

Expertise in using advanced level calculations on the data set

Responsible for design methodology and project documentation

Able to develop tabular and multidimensional models that are compatible with warehouse standards

Adopted, developed, publishing, and scheduling Power BI reports as per the business requirements

Able to properly understand the business requirements and develop data models accordingly by taking care of the resources

Should have knowledge and experience in prototyping, designing, and requirement analysis

Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS) or API automation. I and Also, experienced in developing custom visuals for Power BI.

Create SSIS packages to extract data from different sources.

Responsible for developing, supporting, and maintenance for ETL (Extract, Transform, and Load) processes using SSIS increased performance by 15%

Aggregate, Derived Column, and Data Conversion Transformations.

Create indexes on tables; Trace out any table that required any indexes and determine the type of indexes on it.

Place huge table/non-clustered index on separate file group to improve performance by 40%.

Interacting with Business Analysts and Developers in identifying requirements, designing, and implementing Database Schema.

Attend backlog grooming, sprint planning, retrospective meetings, and experience as a scrum master.

Worked as team following Agile/SCRUM methodology for iterative and incremental development.

Environment: MS SQL Server 2012/2014, SSIS, SSRS, Erwin, Excel, Windows Server, Flat Files, Team Foundation Server (TFS), Jira (Atlassian)

Client: Costar Group, Washington DC Jan 2020- Aug 2021

SQL/Power BI Developer

Responsibilities:

•Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes.

•Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.

•Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)

•Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.

•Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

•Used cascaded parameters to generate a report from two different Data Sets.

•Established ETL design practices for optimization and performance of packages and Parameterized SSIS.

•Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.

•Designed an OLAP system with the help of ERWIN to visualize data structure.

•Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2012/2016.

•Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

•Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

•Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

•Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

•Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

•Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI and utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

•Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

Environment: SQL Server 2016/2012, SQL BI Suite (SSIS, SSRS), T-SQL, Power BI, SQL Profiler, MS Office, Erwin, Windows Server 2016.

Client: CenturyLink - Denver, CO March 2018 -Dec 2019

SQL/SSIS/SSRS Developer

Responsibilities:

•Requirements gathering, Analysis and Design of all the client requirements.

•Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.

•Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

•Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.

•Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.

•Used SSIS to upload amortization schedules sent by the client in . CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.

•Designed, coded and implemented ad-hoc reports using existing report models in SSRS.

•I identified the Data Source and defined them to build the Data Source Views.

•Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.

•Managed Alerts for successful or unsuccessful completion of scheduled Jobs.

•Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.

•Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

•Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

•Involved in testing, bug fixing and documentation for the project.

•Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications

•Developed incremental loading using MERGE statement in SQL server 2008R2.

•Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler

•Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Environment: Microsoft SQL Server 2008/2008R2, MS Sql integeration Services 2008, SSRS 2008, SSAS, Microsoft Excel, C#, XML, ASP.NET, MS Office.

Client: Irving holdings, Dallas, TX April 2015-Feb 2018

SQL/ETL Server Developer (SSRS, SSIS)

Responsibilities:

•Interacted with the users to understand and gathering business requirements.

•Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.

•Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.

•Regular monitored of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.

•Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

•Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.

•Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.

•Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher in periodically.

•Log shipping database for reporting server within the firms’ latency objective.

•Mirrored one of our critical database with zero latency/synchronized- with witness/for critical Database on SQL 2008.

•Part of the team which configured AlwaysOn with availability group for one of our critical server on SQL 2012 that was installed via nodes on WSFC (Window Server Failover cluster).

•Performed full, differential and transaction log backups.

•Created the SQL Server Integration Services (SSIS) and DTS Packages for executing the required tasks.

•Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.

•Used the SQL Server profiler to capture and store the execution plan.

•Provided weekly, monthly, yearly quality control reports for work orders, service requests.

•Represent reports in different forms using graphs, charts, tabular, area and pie charts as required.

•Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005/2008/2008R2, MS SQL Server 2008 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.

Education: Bachelor Degree in Computer Science Graduated on 2009 From Arba Minch University

Contact this candidate