Power BI Developer / BI Engineer - Think d global
(2023-04)
Enterprise Dashboard Developer & Power BI Environment Administrator for Waterfall Management Company project.
- Designed scalable data models utilizing star schema methodologies, advanced Power Query ETL pipelines, and complex data merging techniques.
- Developed analytical logic using advanced DAX queries, window functions, and calculated measures to eliminate data duplicates.
- Configured on-premises gateways for SAP ASE DB hosted on Google Cloud Platform (GCP).
- Abstracted complex business logic from the reporting layer by developing performant, pre-aggregated relational database views.
- Architected end-to-end security frameworks combining database-level restrictions with Power BI Service Row-Level Security (RLS).
- Built ETL automation pipelines using Python scripts to migrate, clean, and schema-map unstructured Excel data into production tables.
- Authored technical specifications and architecture documentation based on thorough discovery sessions with business stakeholders.
Microstrategy Developer - Ubank Midrand - Midrand
(2022-08 - 2023-03)
Dashboard Developer for Business Intelligence Operational Reports project using SAP Sybase-IQ and Microstrategy desktop and web.
- Implementation of Business Intelligence (BI) projects, especially in hyper cards, reports, cubes, dashboards, & dossiers.
- Created Facts, Filters, Attributes and Metrics, Prompts.
- Assessed the datasets, designs, code and testing with the project team.
- Responsible for efficient design and usage of various attribute dimensions like Customer, Branch, Payment, Sales and Time dimensions, and integrating them into reports displaying forecasting metrics.
- Updated all necessary design documentation as per the project requirement.
SQL Tester - Thomson reuters - Chennai, India
(2009-07 - 2010-04)
SQL data tester for Retail banking Mart project (Standard Chartered).
- Assessed end-user requirements.
- Created SQL scripts for validation.
- Developed Test Plans and Test Cases.
- Designed SQL code to validate report criteria.
- Validated Mart reports.