SHAHUL HAMEED K S S B

Project #1

Project Name: Bank of Palestine (BOP)

Roles & Responsibilities:

. Prepared MicroStrategy Workstation and Library documents and communicated progress to stakeholders.

. Created and Modified SQL queries in Snowflake based on client requirements, ensuring validation, and performance improvements.

. Designed and Implemented automated workflows using Microsoft Power Automate to streamline business processes and reduce manual effort.

. Participated in agile ceremonies, code reviews, testing, deployment, and release management activities.

. Collaborated with cross-functional teams to deliver scalable and reliable data integration solutions.

Project #2

Project Name: AMC Dashboards

Roles & Responsibilities:

. Developed Interactive Power BI Dashboards with advanced DAX measures, bookmarks, drill-throughs, and what-if parameters to enhance analytical capabilities.

. Created efficient Power Query Transformations to clean and shape raw data from multiple sources including SQL Server, Oracle, Python, Excel and SharePoint.

. Optimized Power BI data models by implementing star schema design, reducing dataset size by 80% and improving report performance.

. Optimized MicroStrategy data models by implementing snowflake schema design to normalize multiple dimensions table in data warehouse.

. Built & maintained MicroStrategy Reports, Documents, and Dashboards using Report Services and Visual Insight for real-time executive reporting.

. Designed and deployed Intelligent cube and in-memory datasets significantly improving performance for large data volumes.

. Created custom metrics, filters, prompts, and hierarchies to meet complex analytical needs.

. Worked with Python data structures such as lists, dictionaries, tuples and sets.

. Debugged and optimized Python code for improved performance and readability.

. Worked with Subqueries, Common Table Expressions (CTEs), and views for data analysis.

. Optimized SQL queries using indexes and query best practices for improved performance.

Project #3

Project Name: Sales and Product Dashboards.

Roles and Responsibilities:

. Designed, Developed, and Maintained scalable BI Dashboards and Reports using Power BI supporting data-driven decision- making across departments.

. Reduced Reporting Delivery time by 40% by automating manual Excel reports into Power BI Dashboards.

. Designed and Developed Canvas and Model-Driven Power Apps to streamline business processes and reduced manual tasks by 70%.

. Built responsive Canvas apps connected to SharePoint, Dataverse, SQL Server and Excel to automate field data collection and reporting.

. Developed and Maintained automated workflows using Power Automate to connect SharePoint, Outlook, Excel and Power BI.

. Created Scheduled Flows in MicroStrategy and Power BI for daily refreshes of cubes and datasets and batch processing tasks, ensuring up-to-date information in downstream Power BI Reports.

. Developed Python Scripts for data processing, automation, and file handling.