Business Intelligence Engineer at Peramal Services

• Developed and optimized SQL database solutions through stored procedures and automated workflows, enabling accurate analysis of $50M+ in financial transactions and operational metrics • Led requirements gathering and documentation processes across 6 cross-functional teams, translating complex business needs into technical specifications for enterprise-wide reporting solutions • Engineered scalable ETL pipelines using Microsoft SSIS, integrating 5+ data sources into centralized SQL server warehouse, reducing data processing time by 34% and enabling real-time operational reporting • Developed comprehensive KPI framework and built 20+ interactive Tableau and PowerBI dashboards, driving 40% improvement in operational decision-making and 25% increase in customer satisfaction scores • Spearheaded database performance optimization initiative using SQL Server Profiler and Database Engine Tuning Advisor, resulting in 26% faster query execution and 30% reduction in server load • Led data-driven redesign of deposit alternative program through statistical analysis of 3+ years of customer payment patterns, delivering 24% increase in sales conversion and $2M additional annual revenue • Revolutionized sales commission reporting by consolidating 21 manual reports into 2 automated solutions, saving 120+ hours monthly and achieving 90% reduction in calculation effort • Designed and implemented a specialized data mart integrating sales, payment, and billing data from 3 different systems, enabling predictive analytics that reduced bad debt exposure by 35% ($2.5M annually)