About
Dedicated professional Business Intelligence developer with experience in Microsoft Stacks such as Data Visualization Power BI
developer, SQL, SSRS, SSAS and Business Analysis.
Power BI Development - Working knowledge and experience with Power BI Desktop, creating calculated columns and
measures, troubleshooting report performance as well as troubleshooting slowly running reports and dashboard
elements to improve report performance, creating Visualization in Power BI service, building dashboards and customizing
to meet the needs of the end-users.
SQL - T-SQL experience creating tables and temp tables, table variables, store procedures, views, indexes, triggers, joins,
User-defined functions (UDF), CTE, Database Models, and data integrity in all SQL version platforms.
SSIS - Designed and developed SSIS packages, validated/cleaned data using various transformations, and used XML
development and XML file parsing. Worked on data flow transformations like XML Source OLE DB source Flat file source
Excel source used functionalities for error handling by giving precedence constraints, breakpoints, checkpoints, logging,
and data viewers.
SSRS
- Created both shared datasets and package-level datasets.
- Developed parameterized reports with drill-down and drill-through.
- Developed a report with various charts, table, matrix, map, and gauge
- Used Sub-report to develop a dashboard.
- Configure and deploy dashboard to report sever.
Portfolio
US Laptop Sales
The retail market for laptops is engaged in the sale of laptops and related products across all chan... ... More
- Case Study
- Data Analytics
- Product Overview
- Reporting
- Instructions
- Computer Software
- Construction
- Education
- Finance
- Marketing
- Mortgage Banking
- Financial Services
- Manufacturing
- Retail
- Technology
- Sales
- Customer Service
- Access
- Dashboards
- Dax
- Microsoft excel
- Microsoft office
- Outlook
- Power BI
- Software design pattern
- Sql
- SQL Server
- SSAS
- SSIS
- SSRS
- Vba
- Visual studio code
- Visual studio data tools
Employment History
-
SQL/Power BI Developer
Colaberry Inc
July 2017 - December 2022
Power BI Development - Working knowledge and experience with Power BI Desktop, creating calculated columns and
measures, troubleshooting report performance as well as troubleshooting slowly running reports and dashboard
elements to improve report performance, creating Visualization in Power BI service, building dashboards and customizing
to meet the needs of the end-users.
SQL - T-SQL experience creating tables and temp tables, table variables, store procedures, views, indexes, triggers, joins,
User-defined functions (UDF), CTE, Database Models, and data integrity in all SQL version platforms.
SSIS - Designed and developed SSIS packages, validated/cleaned data using various transformations, and used XML
development and XML file parsing. Worked on data flow transformations like XML Source OLE DB source Flat file source
Excel source used functionalities for error handling by giving precedence constraints, breakpoints, checkpoints, logging,
and data viewers.
SSRS
- Created both shared datasets and package-level datasets.
- Developed parameterized reports with drill-down and drill-through.
- Developed a report with various charts, table, matrix, map, and gauge
- Used Sub-report to develop a dashboard.
- Configure and deploy dashboard to report sever.