Purabi Brahma

Purabi Brahma

Experienced Data Analyst and Program Manager
Canada
English

About Me

Experienced Data Analyst and Program Manager. Proficient in Power BI in creating dashboards, designing and implementing data models. Skilled in crafting complex SQL queries using for ETL and data analysis. Proficient in …

Experience

District Program manager-Analyst

National Health Mission
Dec 2016 - Present · 9 years 6 months

Responsible for reporting, analyzing health data and recommending corrective actions to Joint Director of Health Services and the district administration to improve the health care system.

• Data analysis of program-specific datasets to uncover meaningful insights, patterns, and trends, empowering clients to make informed decisions.

• Created and optimized SQL queries to extract, transform, and load data.

• Developed visually engaging reports and dashboards using tools like Power BI.

• Enhanced report interactivity in Power BI resulting in a 30% increase in user engagement with the reports.

• Utilized advanced Excel functions such as conditional formatting, VLOOKUP, and data validation to streamline data manipulation and reporting processes, resulting in improved data accuracy and efficiency in decision-making.

• Identified opportunities for process improvements and implemented data-driven solutions to enhance efficiency.

• Thrived within Agile project environments, utilizing strong communication skills to collaborate effectively with cross-functional teams, while understanding project timelines and dependencies.

• Harnessed the power of Power BI to craft compelling visualizations, making complex data easily understandable for strategic decision-makers.

• Performed other duties assigned by State authority, District Magistrate and Joint Director.

District Program Manager -Analyst (DPM)

National Health Mission (NHM), Assam, India
Jun 2007 - Apr 2022 · 14 years 10 months

Responsible for reporting, analyzing health data and recommending corrective actions to Joint Director of Health Services and the district administration to improve the health care system.
Data analysis of program-specific datasets to uncover meaningful insights, patterns, and trends, empowering clients to make informed decisions.
Created and optimized SQL queries to extract, transform, and load data.
Developed visually engaging reports and dashboards using tools like Power BI.
Enhanced report interactivity in Power BI resulting in a 30% increase in user engagement with the reports.
Utilized advanced Excel functions such as conditional formatting, VLOOKUP, and data validation to streamline data manipulation and reporting processes, resulting in improved data accuracy and efficiency in decision-making.
Identified opportunities for process improvements and implemented data-driven solutions to enhance efficiency.
Thrived within Agile project environments, utilizing strong communication skills to collaborate effectively with cross-functional teams, while understanding project timelines and dependencies.
Harnessed the power of Power BI to craft compelling visualizations, making complex data easily understandable for strategic decision-makers.
Performed other duties assigned by State authority, District Magistrate and Joint Director.

Block Program Manager (BPM): Program Manager at Sub District Level

National Health Mission (NHM), Assam, India
Jun 2007 - Dec 2016 · 9 years 6 months

Appointed as a Program manager at the sub district level, responsible for data collecting, analyzing, reporting, planning, and implementing all health care programs in the allotted jurisdiction to achieve NHM goals.
Planned, organized, implemented all national programs at the sub district level.
Provided support to Sub Divisional Medical and Health Officer (SDM&HO) for planning, implementing, and monitoring of national health programs.
Data Analysis and reporting in Microsoft Excel (Advanced) using DAX and Google Sheets, Spreadsheets for in-depth data analysis and reporting, presenting key insights of health care data to stake holders.
Created Dashboards in excel to streamline health care data summarization and data visualization.
Managed different health care projects like Reproductive Child Health (RCH), Adolescent Health Care (AHC), Special Immunization Drive (SID), Intensified Diarrhoea Control Fortnight (IDCF), IPPI.

Community Information Centre (CIC) Operator

National Informatics Centre (NIC), Assam, India
Jul 2002 - Oct 2003 · 1 year 3 months

Appointed as a CIC operator and was responsible for the operation of Community Information Centre.
District Rural Development Agency (DRDA) Data entry and Data management.
Developed vocational training module for new inductees on MS Office and health MIS.
Managed office files and correspondences.

Skills

Administrative Activities Batch Ticket Dashboards Data Base Administration Data Cleansing Data Scraping Data Entry Data Assessment Data Extraction Financial Policies Leadership Skill Data Analysis and Reporting Data Analytics Management Experience Project Management Data Analysis Data Visualization Research & Analytics Statistical Analysis Problem Solving Microsoft Office MS Excel PowerPoint Spreadsheets Advanced Excel Pivot Table VLOOKUP DAX Python SQL Power BI HTML PHP CSS Time Management Teamwork Positive Attitude Quick Learner Flexible and Adaptable Prioritize Multiple tasks Communication
Report this Profile?