Brian Musekiwa
Frederick,MD
Overview
6
6
years of professional experience
Work History
MS SQL BI DEVELOPER
Geico Inc
Chevy Chase, MD
10.2021 - 10.2024
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment
- Created various dashboards in Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
- Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data
- Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables
- Designed and developed stored procedure, queries and views necessary to support the SSRS reports
- Created various Drill through, Parameterized, Tabular reports and matrix reports using SSRS and created subscriptions for users
- Designed and developed Power BI reports, self-service packages and dashboards for a large pool of business associates
- Designed and developed operational reports using MS Power BI Desktop for various regional managers and also created calculated measures and columns with DAX
- Participated in the Agile methodology's daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt down charts etc
- To meet the daily deliverables and timelines
- Used Power Apps visuals in power BI desktop
- Worked with canvas apps in power App
- Tested and debugged Crystal Reports for accuracy and performance
- Troubleshooted and corrected errors in existing reports
- Developed reporting solutions to meet customer's business needs
- Created and maintained reports in accordance with report specifications
- Provided support for Crystal Reports production operations
- Trained and mentored new Crystal Reports developers
- Worked on all types of transformations that are available in Power bi query editor
- Created stored procedures and SQL queries to pull data into power pivot model
- Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset
- Designing and Developing the Dashboard Reports in Power BI using DAX
- Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes
- Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports
- Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries
- Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
- Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell and Kimball Methodology
- Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse and Data Dimensional Modelling
- Performed database backup and deployment to the production server
- Extensively involved in Designing and Developing ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse)
- Created Workspace and Apps in Power BI and giving access to End-users to Apps
- Configured Gateway in the Power BI service and Implemented Data security (Row-level security) on Dataset and Reports in Power BI
- Worked on Power BI, Power Pivot and Power View to visualize reports
- Developed Power BI reports and dashboards for multiple data sources using data blending
- Written calculated columns, DAX, MDX, Measures queries in power bi desktop to show good data analysis techniques
- Developed the reports in Power BI desktop, publish the report and pinned dashboards in the Power BI Service
- Created Drill Down, Drill Through, Book Marking and Hyperlinks features in the Power BI report
- Extensively worked in analyzing profiling and modeling data in the Power BI Desktop using Query Editor and Relationship view
- Involved in transforming the data from data sources and loading into the target databases using Informatica and generating reports using Power BI
- Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time)
- Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer
- Worked on Creating, Modifying and updating the Views and Functions
- Used SQL Search and SQL Prompt tools
- Modified the existing stored procedures to get the new functionality depending on the client requirement
- Written Calculated Columns, Measures, and Queries in Power BI desktop and also Tabular model to show good data analysis techniques
- Worked on creating Power BI Dashboards using tabular model
- Created and Deployed reports using SSRS and configuring the SQL Server Reporting Server
- Used Power Query to acquire data and Power BI desktop for designing rich visuals
- Extensive Dashboard design using Power BI
- Developed a Canvas Power Applications and Workflows using Power Automation
- Publishing Power BI Desktop reports created in Report view to the Power BI
SR. POWER BI DEVELOPER / MSBI DEVELOPER
Insight Global, Inc.- Sauers Brands Inc
Richmond, VA
03.2021 - 09.2021
- Gather Requirement, Data Warehouse Design, Semantic Layer (Tabular model) Design based on Requirement Responsible for gathering/refining requirements from the customer for developing reports in Power BI
- Built Data Analytics or visualization using Power BI (Power View integrated with Share Point)
- Worked with DAX/MDX queries in building expressions for various business calculations
- Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service
- Involved in Developing Power BI visualizations and dashboards using Power BI Desktop
- Designed and documented the entire Architecture of Power bi Poc
- Created various dashboards in PowerBI desktop using table, matrix, bar, card, gauge, and slicer visualizations
- Worked on DAX expressions like filter, aggregate, mathematical functions etc
- Developed calculated columns and measures using DAX in Power BI
- Used the tabular model cubes as the source in Power BI to visualize the data
- Created Power BI dashboard and generated reports
- Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources
- Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard
- Published Power BI Desktop to the cloud
- Created interactive reports customized for the business using Power BI Desktop
- Installed and configured and maintained Power BI Report Server
- Created hierarchies and attributes as part of dimensional modeling
- Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs
- Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, and scorecard/dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems
- SSIS
- Developed over 50 Crystal Reports for various departments and management levels
- Resolved complex Crystal Reports issues and optimized existing reports
- Modified existing Crystal Reports to meet customer's specific requirements
- Designed and developed new Crystal Reports using Oracle and SQL data sources
- Created SSIS packages to Extract- Transform-Load (ETL) from transactional system (OLTP) to analytical system (OLAP)
- Generated ad-hoc reports, sub- reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS
- Installation on Azure Data Factory gateway, Microsoft Power BI gateway, Power BI desktop
- Participated in the Agile methodology's daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt down charts etc
- To meet the daily deliverables and timelines
- Worked as Power BI Service Administrator
- As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI Apps settings, Power BI premium and Premium Capacity settings
- Used Power Apps visuals in power BI desktop
- Worked with canvas apps in power App
- Worked on all types of transformations that are available in Power bi query editor
- Created stored procedures and SQL queries to pull data into power pivot model
- Changed DB SQL server to snowflake cloud and migrated reports to snowflake
- Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset
- Written calculated columns, DAX, Measures query's in power bi desktop to show good data analysis techniques
- Converting the existing Report from SQL Server to Snowflake DB
SR. POWER BÍ DEVELOPER / ETL
MSAG Department of Labor Agency- Project: EBSA
Washington, DC
09.2019 - 02.2021
- Worked on creating dimensional models using star schema and snowflake schema
- Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Infographic Designer, Spline Chart to make the visuals look and understand better
- Created DAX Queries to generate computed columns in Power BI Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports
- Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI
- Demonstrated experience in implementation and deployment of different ServiceNow modules like Agile DevSecOps, WSD, ITOM techniques in a client environment
- Experience in PaaS/SaaS platforms (Instance and Organizational setup strategy, security strategy, reusable components strategy, migration strategy, information architecture strategy)
- Experience with ServiceNow platform capabilities in a client environment
- Experience with the ServiceNow Business Rules and the ServiceNow platform or applications
- Worked on Power Query in Power BI desktop to edit the queries and Model for data modelling and establishing the relationships
- Worked on Power BI service by publishing the Power BI reports onto Power BI server and collaborated team using Power BI service to create the dashboards
- Generated computed tables in Power BI by using DAX
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
- Explore data in a variety of ways and across multiple visualizations using Power BI
- Used Power BI Gateways to keep the dashboards and reports up to date
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services
- Identify the data feed changes and co-ordinate with ETL teams of downstream application to update the ETL workflow and OBIEE reports
- Designed Facts and Dimensions that supports the business requirements and reporting needs
- Created ETL packages with different data sources (SQL Server, Oracle Source, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
- Worked on Creating SSIS Packages to load the files from SFTP Path on daily basis
- Created SSRS inventory management reports, focused on findings to save company millions of dollars in Client members Performance Health management by providing Incentive, Claims, Biometrics file feeds
- Designed and developed stored procedure, queries and views necessary to support the SSRS reports
- Created various Drill through, Parameterized, Tabular reports and matrix reports using SSRS and created subscriptions for users Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time)
- Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer
- Worked on Creating, Modifying and updating the Views and Functions
- Modified the existing stored procedures to get the new functionality depending on the client requirement
- Worked on Views, CTE's, schemas, permissions issues with client/server database design Written Calculated Columns, Measures, and Queries in Power BI desktop and also Tabular model to show good data analysis techniques
- Worked on creating Power BI Dashboards using tabular model
- Data Visualization development using Tableau to create complex, and innovative dashboards
- Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports
- Converted existing SSRS reports to Tableau and created different KPI using calculated key figures and parameters
- Designed, developed, tested, and maintained tableau functional reports based on user requirements
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down using Tableau
- Created and Deployed reports using SSRS and configuring the SQL Server Reporting Server
POWER BI DEVELOPER / SQL
Delmock Technologies Inc.
04.2019 - 09.2017
- Design and developing the POC'S according to business users
- Developing the best practices and drive the code to across development, test and Pre-Prod and Production environments
- Creating the Daily jobs for data dumps for various teams
- Responsible for Data analytics' migration from Tableau to Power BI
- Designed and developed the migration of Data Analytics to Power BI
- Designed and developed the dashboards, Scorecards and KPI's in the Power BI
- Experience in developing the calculated columns and Measure in the Data Analysis Expressions (DAX)
- Implemented scheduled data refreshes with on-premises data gateways as per the business requirement
- Implemented Direct Query, Imports Data and Live Connection modes
- The apps and workspace and share across the organization and individuals based on the requirement
- Creating and maintaining the app's content and maintain the Power BI Content packages
- Generating the Web links or Embedded Code for publishes to web or website or portals
- Design and develop the RLS (Row - Level-Security)
- Experience in working with various data sources
- Implemented the best practices to speed up the data refreshed or load the data model
- Design and Developed the Data marts as per the Business requirement
- Migrated the existing Microsoft excel reports to Power BI
- Experience in using the M language for Data transformation in the Power Query
- Design and developed the Test scenarios in For Data analytics
- Have experience in using the Bookmarks and Sync Slicers and Buttons extensively to develop the Best User Experience
- Design and developed the MySQL Scripts for Data Dumps
- Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities
- Extensively involved in Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling
POWER BI DEVELOPER / DATA ANALYST
Gatest4GBSolutions Inc
Baltimore, MD
03.2019 - 04.2019
- Customized calculated columns and measures utilizing DAX in Power BI desktop
- Implemented transformations and blended data with options such as merge queries and append queries in Power BI desktop
- Created dashboards in Power BI service by adding tiles from reports, and quick insights
- Created reports using Bar chart, Column chart, Donut chart, maps, Scatter Plot, Line chart, card as well as slicer and applied filters on visuals, page and reports for better interaction of visuals
- Also integrated custom visualization as per the business requirement
- Created database objects like tables, views, stored procedures
- Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients
- Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations
- Experience in creating dashboard and the content pack for the originations to get the updated Power BI Reports, and added the refresh time for each tile in the dashboard
- Installed, configured and implemented both enterprise gateway and personal gateway in Power BI service
- Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements
- Developed reports by using different in-built visualizations Pie Chart, KPI, Card, Matrix Table, etc
- In Power BI
- Used Power BI desktop to directly connect to database tables (Direct Query Mode)
- Utilized query editor to clean and format data and eliminate redundant information and append and merge tables from various data sources
- Worked on all types of transformations that are available in Power BI Query editor
- Troubleshooting and performance tuning Power BI reports for optimization
- Utilized datasets in Power BI service for refreshing data and implementing gateway
- Configuring Power BI enterprise gateway to keep the dashboards and reports up to date
- Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively
- Contributed in building reports in Power BI from scratch
- Worked with both direct query and import data in Power BI for creating reports
- Developed and maintained multiple Power BI dashboards/reports and content packs
- Responsible for building Power BI dashboards using tabular and multidimensional models
- Experience in developing dashboards, reports, sub reports by region and service type, and monthly claim reports
- Created static and dynamic row-level security in Power BI desktop and assigned roles to users via service
- Published reports to Power BI services (pro) and scheduled subscription for dashboards in PowerBI service
- Used various sources to pull data into Power BI such as SQL Server, Excel, Snowflake, etc.
Timeline
MS SQL BI DEVELOPER
Geico Inc
10.2021 - 10.2024
SR. POWER BI DEVELOPER / MSBI DEVELOPER
Insight Global, Inc.- Sauers Brands Inc
03.2021 - 09.2021
SR. POWER BÍ DEVELOPER / ETL
MSAG Department of Labor Agency- Project: EBSA
09.2019 - 02.2021
POWER BI DEVELOPER / SQL
Delmock Technologies Inc.
04.2019 - 09.2017
POWER BI DEVELOPER / DATA ANALYST
Gatest4GBSolutions Inc
03.2019 - 04.2019
Similar Profiles
DEAN ADRIANA LOZANODEAN ADRIANA LOZANO
Auto Claims Adjuster at GEICO, Government Employees InsuranceAuto Claims Adjuster at GEICO, Government Employees Insurance
Juanita DarrellJuanita Darrell
Claims Adjuster at GeicoClaims Adjuster at Geico
Amanda JacobyAmanda Jacoby
Customer Service Representative at GEICOCustomer Service Representative at GEICO
Alexis RobersonAlexis Roberson
Talent Acquisition Manager at ThompsonGasTalent Acquisition Manager at ThompsonGas
Brendel BeardBrendel Beard
Site Surveyor /CAD Designer at Sustainable Energy SystemsSite Surveyor /CAD Designer at Sustainable Energy Systems