Balameena

Associate

Cognizant

Feb 2022 - Present

Developed and maintained 30+ interactive Power BI dashboards for BioMarin Pharmaceutical to monitor product inspection, AOI priorities, manufacturing quality metrics, and training compliance. Designed intuitive reports using Bookmarks, Navigation, Drill-through, and multi-level Drill-down functionalities to improve end-user experience and analytical capabilities. Delivered KPI dashboards enabling stakeholders to efficiently monitor operational performance and quality metrics. Designed scalable data models using Star Schema and Snowflake Schema to support enterprise reporting requirements. Developed DAX measures, calculated columns, KPIs, and time-intelligence calculations for business performance analysis. Optimized data models and report structures to improve dashboard performance and user experience. Developed SQL scripts using DDL, DML, Joins, Subqueries, CTEs, and Views for data extraction, transformation, validation, and reporting requirements. Performed SQL query optimization and data validation to improve reporting efficiency and data accuracy. Worked with SQL Server, Oracle, and MySQL databases to support data integration and business reporting solutions. Integrated data from SQL Server, Oracle, MySQL, Excel, flat files, and Informatica PowerCenter pipelines into Power BI reporting environments. Performed data cleansing, transformation, validation, and reconciliation to maintain reporting consistency and data reliability. Collaborated with business stakeholders to gather reporting requirements and translate them into analytical solutions. Managed Power BI Service activities including Gateway configuration, Workspace administration, Scheduled Refresh, and Row-Level Security (RLS). Monitored dataset refreshes, report performance, and user access to ensure reliable reporting operations. Troubleshot and resolved Power BI Service, dashboard, query, and visual performance issues. Developed Power Automate workflows to trigger automated notifications based on changes in business-critical source data. Automated training compliance reminders and stakeholder notifications, reducing manual follow-up activities. Utilized Python (Pandas and NumPy) for data cleaning, exploratory data analysis (EDA), and data transformations. Generated analytical insights to support Power BI visualizations and business decision-making. Gained hands-on exposure to Microsoft Fabric concepts including OneLake, Lakehouse, Dataflows Gen2, and Data Engineering workloads. Delivered Proof of Concepts (POCs) and analytics demonstrations showcasing Power BI reporting and embedded analytics capabilities. Collaborated with business stakeholders to deliver scalable reporting and self-service analytics solutions.