About
I am a detail-oriented Data Analyst with hands-on experience in Microsoft SQL Server, SSIS, SSRS and Microsoft Power BI for data visualization. Experienced in designing analytical, interactive and user-friendly reports and dashboards with the main aim of providing greater insights into improving the company’s decision-making skills. Proficient in creating DAX formulas to perform complex calculations, create measures and calculated columns. Experienced in developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from different sources. Experienced creating, maintaining and troubleshooting existing tables and views, stored procedures, performing table joins, optimizing queries and stored procedures. I have created parameterized reports and dashboards in SSRS with Drilldown and Drillthrough capabilities. Seeking a position that will make me deliver excellent results and help the business reach its full potential in terms of overall growth.
Looking for Full-TimePortfolio
PHARMA SALES (2014-2019)
The dataset consists of transactional data collected in 6 years (period 2014-2019), indicating date ... ... More
Employment History
-
SQL/Power BI Developer
Colaberry Inc
January 2021 - Present
• Connect and import data from different sources to Power BI to generate reports.
• Performed different transformations on data using Power BI query editor.
• Utilized Power BI to create and design analytical reports/dashboards that depict critical KPIs.
• Performed different DAX calculations for efficient data visualization in Power BI.
• Designed and developed Power BI graphical and visualization solutions based on business requirements documents.
• Published and scheduled Power BI reports based on business requirements.
• Designed and developed SSIS packages to extract data from multiple sources, transform/clean data and load it to the Data Warehouse.
• Developed and reviewed SQL queries with the use of Join clause (Inner, Left and right) for validation of data.
• Create and modify complex SQL queries, stored procedures and views to be used for reporting purposes.