Power Bi Developer

Professional Summary:

•Results-driven Power BI Developer with over 8+ years of experience in designing, developing, and implementing advanced Power BI solutions.

•Proven expertise in data visualization, DAX, data modeling, and ETL processes. Skilled in delivering impactful dashboards and reports that provide actionable insights and drive decision-making.

• Adept at collaborating with stakeholders to gather requirements and optimize Power BI performance.

•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 handle 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 created different reports and dashboards using power BI.Ability and willingness to learn new technology and deliver results in a timely manner.

•Developed and maintained web applications using Python, Django, and Flask frameworks.

•Designed and implemented RESTful APIs for communication between frontend and backend systems.

•Utilized Python libraries such as Pandas and NumPy for data manipulation and analysis.

•Automated repetitive tasks and improved workflow efficiency by writing Python scripts.

•Collaborated with cross-functional teams to troubleshoot and resolve software issues.

•Participated in code reviews to ensure code quality, readability, and adherence to coding standards.

TOOLS AND TECHNOLOGY

RDBMS

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

Languages\Tools

Visual Basic, PowerShell, C#, T-SQL, Java, Python,.Net.Control-M

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 Summary

Client: Veteran Affair, Baltimore, Maryland Jul 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.

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

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

Power BI Developer/SQL

Responsibilities:

Design and develop interactive Power BI dashboards and reports tailored to business requirements, ensuring visual engagement and actionable insights.

Create and manage comprehensive data models within Power BI, utilizing DAX to enhance reporting capabilities with calculated columns and measures.

Write and optimize complex DAX formulas to ensure accurate and efficient data calculations across various reporting needs.

Collaborate with data engineers and analysts to integrate and transform data from SQL Server, Excel, and cloud services into Power BI, utilizing ETL processes.

Monitor and improve the performance of Power BI reports and dashboards, applying best practices for data modeling and report design.

Engage with stakeholders to gather and clarify business requirements, translating them into effective Power BI solutions.

Document Power BI models, workflows, and DAX calculations to maintain a robust knowledge base for the team and end-users.

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

Diagnose and resolve issues with Power BI reports and data refreshes to maintain report integrity and performance.

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%.

Worked with more than 20Client/Business Analysts to define data requirements for reporting and data maintenance.

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.

Spearheaded the implementation and utilization of IBM Cognos Analytics to streamline and enhance business intelligence processes.

Developed and maintained dynamic reports and dashboards in Cognos, providing key insights to support data-driven decision-making.

Collaborated with cross-functional teams to gather requirements and ensure Cognos solutions aligned with business objectives.

Conducted user training sessions to empower teams in leveraging Cognos tools effectively, resulting in improved efficiency and data-driven decision-making.

Played a key role in troubleshooting and resolving Cognos-related issues, ensuring continuous system functionality and user satisfaction.

Implemented best practices for Cognos report development, optimizing performance and ensuring data accuracy.

Contributed to the design and development of custom Cognos packages and data models to meet specific business needs.

Stayed abreast of the latest Cognos features and updates, providing recommendations for system improvements and enhancements.

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

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 tracked 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.

•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.

•Design, develop, and maintain integration solutions to connect various data sources with BI platforms.

•Implement Extract, Transform, Load (ETL) processes for efficient data flow

•In-depth knowledge and hands-on experience with SQL Server Integration Services (SSIS)

•Hands-on experience using Microsoft's BI and data stack, including Server Reporting Services (SSRS), Power BI, Data Factory, and other relevant tools

•Create and optimize data models to support BI reporting and analytics

•Integrate BI solutions with other applications and services through API integration

•Implement data governance practices to ensure the accuracy, consistency, and security of data within BI solutions

•Adhere to data policies and standards

•Collaborate with business analysts, BI developers, and other stakeholders to understand integration requirements and deliver solutions that align with business needs

•Provide support for integration-related issues, identifying and resolving problems, and ensuring the overall reliability of BI integration solutions

•Leverage Microsoft Azure cloud services for integration, storage, and deployment

•Create and maintain documentation for integration processes, custom development, and data models

•Ensure that documentation is comprehensive and accessible to team members

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 for understanding 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 monitoring 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 servers 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 and 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).

•Experience in implementing data solutions on MS Azure using Azure Data Factory, Synapse or Azure SQL Data Warehouse.

•Prior Experience on any of the ETL Technologies like Informatica Power Centre, SSIS.

•Experience with systems like a relational database SQL Server, DB2, mainframe database, VSAM files, flat files, Sequential files.

•Good experience in data extraction (Full data + Incremental data) strategies from source systems.

•In-depth understanding of various storage services offered by Azure.

•Experience with data process Orchestration, end-to-end design and build process of Near-Real Time and Batch Data Pipelines.

•Working experience with Azure monitor and Azure log Analytics.

•Strong client-facing communication skills.

•Experience with agile methodologies.

•Hands on Experience in using Azure devops.

•Analyze current code in informatica, SQL, unix scripts.

•Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

•Promotes the utilization of technical services to resolve business issues within the enterprise, agency, program area, or division

•Provides technical support on complex business intelligence projects and performs as a Subject Matter Expert in business or functional area

•May participate in strategic planning processes for ODA’s Data Visualization/Business Intelligence team

•Assists with developing technical standards and policies to meet the needs of customers, peers, and management.

•Recommends and facilitates quality improvement efforts

•May serve as a project leader providing guidance, advice, supervision and/or training to other analysts

•Establishes and maintains strategic partnerships with data visualization-based agencies to help them meet their business and technical needs

•Participates in the Business Intelligence Center of Excellence steering committee as it relates to data governance and visualization best practices

•Assists Data Visualization/Business Intelligence team with dashboard development as needed.

•The job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time.

•I have experience with PL/SQL, including writing and optimizing stored procedures, functions, and triggers.

• I am skilled in using PL/SQL for database programming, data manipulation, and performance tuning to support business requirements and enhance application functionality.

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’s

Contact this candidate