Data Architect | Power BI Consultant2020 - 2021AlixPartners
Technologies: SQL, Dimensional Modeling, Database Modeling, T-SQL, SQL Server Integration Services (SSIS), SQL Server 2016, Data Warehousing, Data Warehouse Design, Microsoft Power BI, QA Testing
- Developed and enhanced a Power BI report to manage COVID-related employee and visitor cases concerning other visitors and locations worldwide. Performed QA checks for accuracy on employee entries data into buildings and floors using SQL statements.
- Automated the ETL process of employee health verification data into SQL Server data mart through SSIS solution developed in Visual Studio. Also performed data quality QA checks before deploying the solution in the production environment.
- Implemented a solution to play company training video files with Microsoft Stream for internal users only and then embedded them into Power BI reports for the business user training.
Senior BI Consultant2020 - 2020IQUBICS Technologies, LLP
Technologies: SQL, Microsoft Teams, T-SQL, Azure SQL Data Warehouse (SQL DW), Dimensional Modeling, Database Modeling, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2016, Microsoft Power BI, Azure SQL, QA Testing
- Gathered business requirements to create an analytical representation of data as part of the complete BI solution. Also held responsibility for data quality QA checks for accuracy, relevancy, completeness and timeliness across all reports.
- Identified and created data source tables in SQL Server data warehouse and designed stored procedures.
- Developed SSIS packages in Visual Studio to extract, transform, and load the source data into ODS and data warehouse.
- Created SSRS tabular reports to auto-save and auto-email the reports to designated users.
- Integrated Power BI and SSRS reports to Microsoft Teams to be shared with the userbase automatically.
- Created great visibility to the client's ten years of data history with Power BI reports, enhancing the decision-making process.
- Integrated Zoho CRM reports with Teams to further improve marketing for the client's customer acquisitions.
Data Engineer | Power BI Consultant2019 - 2020Cisco
Technologies: Data Warehouse Design, Data Warehousing, Excel 2013, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence (BI), Microsoft Power BI, Dimensional Modeling
- Led the transition of video recordings and streaming data statistics from Excel and SSRS reports to Power BI and performed QA checks before publishing data to Power BI reports.
- Acted as project lead for design, development, and implementation of data warehouse and Microsoft BI solutions. Also performed data QA tests on data from source to match the values on target databases.
- Developed SSIS packages to ETL various source data into database and designed star schema models for Power BI.
- Created multiple reports using Power BI Desktop with Import and DirectQuery and advanced data modeling.
Senior BI Developer2018 - 2019SSDataInfo, Inc.
Technologies: SQL, Oracle RDBMS, DAX, SQL Server Integration Services (SSIS), SQL Server 2012, Business Intelligence (BI)
- Implemented a BI reporting solution for medical health records data management and disease surveillance data.
- Imported data from Oracle DB, created data modeling, calculated columns, and measures for Power BI reports.
- Used PL/SQL for ETL tasks, such as bulk inserts of flat files, data transformations, and data loads for reports.
- Worked with advanced data analysis expressions (DAX) to create complex measures and visualizations for medical health records and disease data surveillance in visual forms as per business requirements.
- Interpreted and analyzed clinical data from various sources and recommended best practices. Reviewed the existing reports and converted them into dynamic visual reports.
Lead BI Consultant2003 - 2018Hewlett Packard Enterprise Development, LP
Technologies: SQL, ITIL V3 Foundation Certified, Microsoft Excel, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Microsoft Power BI, T-SQL, Microsoft SQL Server, Business Intelligence (BI)
- Created Power BI reports for Wells Fargo and Bank of America software and hardware break-fix call metrics. Managed SLA reporting for BoA and Wells software and hardware support calls.
- Implemented row-level security on Power BI reports for various regional and district managers and support techs.
- Created and managed different SharePoint sites for internal usage in order to streamline specific processes.
- Automated the delivery mechanism of Excel reports to user emails using scripts and SQL Server daily jobs.
- Used PL/SQL and T-SQL for ETL tasks, bulk inserts of flat files, data transformations, and data loads from different sources.