Highly organized and proactive BI developer focused on translating complex mandates into actionable plans and working systems. Ready to bring 15+ years of related experience to a challenging new role. Proven 6+ years of experience in successfully applying ETL & ELT processes to complex data from various sources. Deft at providing easily understood dashboards and tools using latest technologies. Detail-oriented and systematic with excellent follow-through and a superior work ethic. Excellent communication, project management and problem-solving abilities.
· Successfully directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
· Significantly improved CalSTRS business efficiency by implementing latest BI tools.
· Worked in close consultation with Subject Matter Experts (SMEs) from CalSTRS to apply the ETL process on legacy mainframe system for the next gen solution.
· Designed & developed more than 150+ Dashboards & operational reports using Power BI & SQL server reporting services, providing company-wide access to collected data.
· Handled massive quantities of business intelligence data, personally managing as much as 100 terabytes.
· Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
· Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
· Single handedly developed 90 operational and 35 .net application embedded reports using SQL server reporting services.
· Created 180+ highly performance optimized SQL stored procedures and views to support the operational reports.