Projects: Leonard USA CareServ PhaseZero Secuvant Government Acquisitions, Inc.
• Worked as a team Lead to develop Power BI reports and dashboards with use of DAX for creating complex measures.
• Latest work with Microsoft Fabric, semantic layer data modelling, data pipelines and finance Power BI reports.
• Ingested data from Business Central using Data Factory Pipelines into newly developed Data warehouse.
• Consolidate multiple Power BI reports into one Dashboard for cybersecurity project with complex visuals.
• Developed multiple data models using Star schema and Snowflake schema models for the Power Bi reports.
• Worked on complex SQL stored procedures to fix issues and update paginated reports for medical clients.
• Developed self-reporting environment by publishing shared datasets to enable business users report creation.
• Implemented Power BI Embedded solution for wholesale project to enable reporting subscription for vendors.
• Connected to Salesforce using API and imported data into DWH for data analytics using Power BI.
• Connected to Google Business and Google Analytics to import data into database for data analytics using Power BI.
• Performed error fixes for pre-existing Power BI reports and enhanced data modeling for faster refresh rates.
• Implemented RLS (row level security) on Power BI reports for business users to restrict data based on user roles.
• Performed Power BI Admin role providing user security to Workspace, reports, and APP level

• Worked on data migration from On-prem SQL server to Azure Synapse Analytics (DWH) for medical statements.
• Developed tabular models using Azure Analysis Services to meet business reporting requirements.
• Created data factory pipelines to ingest data from different data sources into Azure SQL Synapse analytics (DWH).
• Involved in the complete data warehouse development life cycle and supported business users with change requests.
• 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.
• Created SSAS cube and migrated all DAX to connect it live to Power BI reports for processing 10 years of large dataset.
• Created many visuals based on performance values trending using MTD, QTD and YTD metrics.
• Implemented the use of incremental refresh to handle large data sets in order to improve the data refresh process.
• Developed complex SQL queries using stored procedures to support Power BI reports along with DAX measures.
• Integrated ZOHO CRM reports with TEAMS to further enhance marketing for the client's customer acquisitions.

• Led the end-to-end migration project, moving business intelligence reports from Domo to Power BI.
• Extracted data from Domo using API integrations and CSV exports, ensuring data integrity and completeness.
• Established seamless data integrations between various sources and Power BI using Power Query and Dataflows.
• Recreated complex Domo reports in Power BI, leveraging its advanced visualization and analytical features.
• Conducted extensive data validation and reconciliation to ensure consistency between Domo and Power BI reports.
• Developed training materials and conducted workshops to educate end-users on navigating Power BI reports.
• Deployed Power BI reports to the Power BI Service, configuring access permissions and ensuring secure data sharing.
• Maintained regular communication with stakeholders, providing updates on project progress and migration process.
• Created dynamic dashboards in Domo to visualize key Salesforce metrics such as sales performance, pipeline health, and customer engagement.
• Utilized Domo's connectors to automate the extraction, transformation, and loading (ETL) of Salesforce data into Domo, streamlining data workflows and reducing manual effort.
• Configured and optimized data connectors for robust and secure data transfer between Salesforce and Domo, maintaining data integrity and compliance.
• Created advanced data models in Domo to aggregate and analyze Salesforce data, providing actionable insights and supporting strategic

• Implemented BI Reporting Solution for Medical Health Records data management and disease surveillance data.
• Imported data from Oracle DB, created data modelling, 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 DAX to create complex measures in order to create visualizations for Medical Health Records.
• Worked on Row level security, shared Power BI reports to intended users and provided training.
• Lead projects to completion by contributing to database creation, dimensional modeling and dynamic reports.
• Interpreted and analyzed clinical data from various sources and recommended best approaches.
• Reviewed existing old reports and converted them into dynamic visual reports.

• Worked with various data sources, calculated columns, and measures with DAX to create Power BI Reports.
• Worked with Import and Direct query models in Power BI Desktop.
• Created reporting dashboards and implemented customized reports sharing permissions for the users.
• Created Ad-hoc reporting based on customer requirements and criteria using T-SQL queries and Stored Procedures.
• Extensively worked with SQL Server, Microsoft Excel, Microsoft Access, ETL Tools and SharePoint custom projects.
• Embedded Power BI reports on to SharePoint sites web parts.
• Managed data refreshes and assigned report permissions based on user roles.
• Implemented Row Level Security based on user roles for some reports.

• Created many ad-hoc reports using T-SQL and Stored Procedures in SQL Server.
• Used PL/SQL and T-SQL for ETL tasks, bulk inserts of flat files, data transformations, data loads from different sources
• Created Power BI Reports for Wells Fargo and Bank of America software and hardware break-fix calls metrics.
• Used DAX in creating calculated columns and measures to show aggregations and trends.
• Created SSRS (SQL server reporting services) reports to be auto emailed through SQL Agent jobs.
• Automated delivery mechanism of Excel reports to user emails using scripts and SQL Server daily jobs.
• Created and managed different Sharepoint sites for internal usage in order to streamline certain processes.
• Implemented row level security on Power BI reports for various regional and district managers and support techs.