BARSHA BHATTARAI

Winnetka, CA

Phone: 747-***-****

Email: adyh1r@r.postjobfree.com

Certification

Analyzing and Visualizing Data with Power BI from Davidson College

Skills

Able to use Microsoft Excel for basic data analysis, including importing, cleaning, and visualizing data.

Familiar with basic T-SQL concepts, such as creating and modifying databases, tables, and views, and writing simple queries for data retrieval and modification.

Basic understanding of Data Analysis Expressions (DAX) for Power BI, including creating simple calculations and measures

Familiar with SQL Server Management Studio (SSMS) and able to perform basic database management tasks such as creating and modifying tables and views and executing queries.

Familiar with basic features of Power BI, such as creating reports and dashboards, and using various data sources.

Utilized Power Query to clean and transform data from different sources.

Strong problem-solving and critical thinking skills

Willingness to learn and adapt to new technologies and methodologies.

Experience

Northridge Hospital Medical Center, Northridge (September 2020 – June 2023)

Business Intelligence Developer

Responsibilities:

Developed interactive dashboards and reports using Power BI to visualize healthcare data, including patient outcomes, operational metrics, and financial analysis.

Collaborated with stakeholders to understand their data requirements and provided actionable insights through visualizations.

Extracted data from various sources such as databases, Excel files, CSV files, and SharePoint lists.

Created calculated columns and measures using the M language or Power Query formula language.

Performed data cleaning, transformation, and modeling using SQL, ensuring data integrity and accuracy.

Assisted in the development of data-driven solutions to optimize hospital processes and improve patient care.

Developed SSRS reports for business users and created SSIS packages for distribution.

Developed T-SQL scripts and stored procedures to implement business requirements.

Collaborated with data architects, data engineers, and business stakeholders to understand data requirements and implemented data transformation processes accordingly.

Developed, generated and distributed monthly reports ensuring data accuracy.

Delivered on demand reports in different rendering formats using Standard and Data Driven Subscriptions.

Effectively handled data errors during the modification of existing reports and creation of new.

Architect’s Design and Consult – Hetauda, Nepal (March 2018 – August 2019)

Report Developer

Responsibilities:

Collaborated with cross-functional teams to understand data requirements and objectives, facilitating effective project planning and execution.

Developed SQL queries to extract, clean, and transform data from multiple sources, ensuring accurate and reliable information for analysis.

Created visually appealing and interactive Power BI dashboards and reports, presenting key project metrics such as budget, timeline, and resource allocation.

Conducted comprehensive data analysis to identify trends, patterns, and anomalies, enabling informed decision-making and improved project performance.

Created overview report with key project metrics like budget, timeline, and resource allocation using visualizations such as bar graphs and pie charts.

Developed report to optimize resource allocation by monitoring utilization of engineers, technicians, and equipment through availability, workload, and utilization rates.

Assisted project managers and engineers in analyzing project data, assessing potential risks, and proposing mitigation strategies for successful project delivery.

Maintained data models, dictionaries, and documentation, ensuring consistent and accessible information for efficient data management.

Streamlined data collection and reporting processes, optimizing efficiency and reducing turnaround time for timely and accurate reporting.

Assisted in cost estimation and budgeting for civil engineering projects with detailed breakdowns of labor, materials, equipment, and subcontractor costs.

Utilized visualizations like stacked bar charts to compare estimated vs. actual costs and identify cost-saving opportunities.

Education

Pokhara University, Nepal

Bachelor’s in Civil Engineering