I am a passionate BI/Power BI Developer with a high ability to solve complex problems. I am Currently working with Colaberry Inc, Plano, Texas. I have experience working effectively within a team. I can work with little or no supervision. I am a fast learner and confident that I will be able to integrate within any team. I am resilient, customer oriented and have a strong interpersonal communication skills. I am open to new ideas and ready to adapt to any environment.
Accidents are multi-factor and random. It is most times unavoidable. Traffic accident leads to loss ... ... More
BI/Power BI Developer
March 2018 - Present
. Participated in gathering requirements.
· Used ETL (SSIS) to develop jobs for extracting, validating, transforming, and loading data into the ODS.
· Prepared the complete data cleansing, mapping for all the migrated jobs using SSIS.
· Designed SSIS Packages to transfer data from SQL Server, Excel, XML, and flat files to Data Warehouse loading Dimensional and Fact tables.
· Developed new and modified existing stored procedures, queries, user-defined functions, and triggers using SQL.
· Developed and implemented Power BI's reporting, analytics, and data visualization solutions.
· Utilized Power BI to create dynamic reports and dashboards with Drill down and Drill through.
· Creating DAX to create calculated columns and measures in providing KPIs with insights.
· Troubleshoot slowly running reports and dashboard elements to improve report performance.
. Created a dashboard that track the percentage of students signing up for a class per month.
. Deployed Dashboard to power BI Service.
R.T.G LLC, Upper Marlboro, MD
June 2016 - February 2018
Involved in requirement gathering meetings to understand requirements and future usage for the reports and documented them.
Worked on SQL Server development including writing SQL Queries and creating SQL Server objects like Stored Procedures, User-defined Functions, Views, Triggers, implementing relational database models, and data integrity.
Extract data from different sources like; Excel, OLTP, Flat File, and XML, transformed and Load to the staging tables.
Created views and join that combined data coming from different sources into one table.
Cleaned and transformed data within SSIS and loaded it to ODS.
Created Slowly changing dimension (SCD) and loaded it to the data warehouse for reporting purposes.
Created Dimensions and Fact tables
Created a report with SSRS and Power BI.