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 strong interpersonal communication skills. I am open to new ideas and ready to adapt to any environment.
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 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 tracks 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.