ANUSUYA RAMESH
Power BI Developer
Villupuram,TN
Summary
Detail-oriented BI and Data Warehousing professional with 6 years of experience in SQL Server, SSIS, SSAS, and Power BI. Specializes in dimensional modeling, ETL processes, and performance tuning. Delivered governed analytics solutions with row-level security and scheduled refreshes on Power BI Report Server. Developed identity governance reporting for public safety and banking sectors, enhancing compliance and decision-making.
Overview
6
6
years of professional experience
Work History
Solution Developer
Datasemantics Private Limited
06.2023 - Current
- Generated enterprise Power BI dashboards for Al-Ghurair and Boubyan Bank clients. Constructed star schemas and curated datasets to optimize analytical processes. Established row-level security (RLS) and automated scheduled refresh to enhance data reliability. Interfaced with clients to identify needs and provide impactful dashboard solutions.
- Resolved end-to-end data quality issues through systematic analysis and troubleshooting
- optimized data pipelines by leveraging SQL and scheduling, reducing manual effort while improving accuracy and refresh SLAs.
Software Engineer (BI)
ProPhoenix Consultancy Services Pvt. Ltd.
03.2020 - 05.2023
- Managed data warehouse and business intelligence functions for police RMS and EZFire records in US public safety, covering incidents, citations, crashes, bookings, property investigations, and NFIRS submissions.
- Created and managed ETL processes ensuring reliable data transformation and effective integration throughout systems.
- Constructed and secured 15+ SSAS cubes, integrating partitions and usage-based aggregations while enforcing role-based security for user permission management.
- Constructed and secured more than 15 SSAS cubes, integrating partitions and usage-based aggregations. Enforced role-based security to manage user permissions effectively.
- Crafted and optimized BI solutions with Power BI to enhance data visualization and reporting capabilities.
- Created and managed ETL processes to ensure reliable data transformation and integration across systems.
- Facilitated cross-functional teams in embracing agile methodologies optimizing project delivery durations significantly.
- Delivered extensive data analysis, generating valuable insights that impact strategic decision-making initiatives.
Education
MBA - Technology Management
Anna University
Chennai11-2022
BE - Electrical & Electronics Engineering
Sri Sairam Institute of Technology
Chennai04-2019
Skills
ETL processes
Accomplishments
- Optimized SSIS loads, improved SSAS query performance, and scaled Power BI adoption across business units.
Timeline
Solution Developer
Datasemantics Private Limited
06.2023 - Current
Software Engineer (BI)
ProPhoenix Consultancy Services Pvt. Ltd.
03.2020 - 05.2023
MBA - Technology Management
Anna University
BE - Electrical & Electronics Engineering
Sri Sairam Institute of Technology