Daksha Humad

Experience

• 

  Children's Hospital of Philadelphia

  Dec 2018 - Apr 2020

  Power BI Developer

  ⮚ Assisted business analysts and content developers in leading design reviews to create a proof of concept for the entire project.⮚ Prioritized requirements to be developed according to Agile methodology.⮚ Worked on all activities related to the development, implementation, administration, and support of ETL processes for large-scale data warehouses utilizing SSIS.⮚ Conceptualized the data migration strategy to populate the data-mart with facts and dimensions tables.⮚ Built data mart from data warehouse utilizing top-down approach for analysis and reporting purposes.⮚ Ensure data accuracy and consistency through data cleansing and validation.⮚ Developed and maintained Power BI reports and dashboards for various departments within the organization.⮚ Created data visualizations using pie chart, trends, gauge, and scorecards in Power BI to effectively communicate key business metrics and insights.⮚ Developed metrics and created calculated columns and measures using DAX and established KPI’s to report the state of the business to the executive team.⮚ Enriched dashboards and reports in Power BI with bookmark, filters, Q&A and themes.⮚ Generated reports in Excel Power Pivot and shared them using Power BI to facilitate strategic planning.⮚ Published Power BI reports to Power BI Services and shared them with other teams. Show less

• 

  Capital One

  May 2020 - Aug 2021

  Power BI Developer

  ⮚ Attended JRD meetings as part of business requirement gathering sessions to draft out the scope and details of the entire project.⮚ Performed data analysis for existing data warehouse and changed the internal schema for performance.⮚ Wrote T-SQL scripts to combine data from multiple tables using joins, sub queries, and set operators as well utilized loops, CTEs and dynamic SQL to implement business requirements.⮚ Created tabular reports, matrix reports, parameterized reports, global map reports in Power BI Desktop.⮚ Designed and developed interactive dashboards and reports using Power BI Desktop.⮚ Created data models in Power Pivot and Power Query to support reporting requirements.⮚ Used DAX expressions to perform calculations and create KPIs.⮚ Designed complex data-intensive reports in Power BI utilizing various graph features such as gauge, funnel, and line better business analysis.⮚ Scheduled the dataset to refresh for upcoming data in the Power BI server.⮚ Provided technical support for end-users and resolved issues related to data and reporting.⮚ Trained end-users on how to use Power BI reports and dashboards.⮚ Implemented security and shared reports among users with features like workspace in Power BI service. Show less

• 

  Marathon Petroleum Corporation

  Sept 2021 - Dec 2022

  Power BI Developer

  Attended stakeholder meetings for business requirement gathering sessions to draft out the details of the project.Gained insights into Service Now and Rapid 7 as the reports majorly involved these two sources.Participated in the working sessions and created joins and views involving some tables with millions and billions of records for developing the Azure data lake to store the data at a centralized location.Connected to various data sources like Azure, SSMS, SharePoint Folders, Excel, and Web to build the reports. Utilized Power Query and Dax Expressions to create measures and columns and model the data as per the criteria based on the business needs.Designed reports involving drill through, drill down, bookmarks, buttons, and Q/A to give users a deeper functionality to assess the data in the reports.Managed security of the reports by implementing Row-level security and access control at the Power BI Services.Automated the refresh of CSV files by Power Automate and scheduled refresh for all the reports at a repeated interval. Show less

• 

  Ecolab

  May 2023 - now

  Data Analyst

  Collaborated with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.Integrated data from Sharepoint Lists, Excel spreadsheets and SQL databases containing millions of rows into Power BI, resulting in unified data views and confirmed data consistency. Led a project to develop a comprehensive Pest Intelligence dashboard in Power BI that provided real-time insights and increased pest management accuracy by 25%Designed dynamic, user-friendly visualizations and dashboards consisting of bar charts, line graphs, and pie charts, to facilitate data-driven decision-making.Developed custom visuals, bookmarks and utilized Power BI's DAX (Data Analysis Expressions) to generate advanced calculations and metrics.Optimized Power BI reports and queries, which reduced loading times of reports by 40%, resulting in an enhanced user experience and better productivity through faster insights.Utilized TFS (Team Foundation Server) as a centralized repository for cross-functional team communication. Show less