Business Intelligence Analyst

Create and Maintain the reporting database for the Pan-North America customer baseSpecialize in Data Integration of all customer data from multiple source systems into one data sourceOversee the activity of the Reporting Team including Code Reviews and Approvals Serve as Subject Matter Expert for Texas-based customer dataServe as Backup to the Senior Manager for any and all reporting requests/inquiriesMaintain open lines of communication to our internal customers and provide feedback on best ways to view the dataDeliver Customer reports for the Sales, Marketing, and Retention teamsPerform trend analysis on customer behaviors and churn vs. stick ratesInitiated task tracking in SharePoint to better manage the team workload Implemented SQL Server Reporting Services standards to create a unified reporting environment Assisted in developing in house Prospecting and Campaign Management database used by List Management team to allow for in-sourcing from external vendor

Maintained ERCOT processes relating to Retail Market AnalysisDeveloped and maintained macros to assist procedures performed by Retail Market AnalysisResulted in elimination of human error and time required for manual processes with Quarterly Performance MeasuresPerformed data gathering in preparation of reports in response to Retail Market requestsReports requested by recipients including the Electric Reliability Council of Texas (ERCOT), the Public Utility Commission of Texas (PUCT), Competitive Retailers (CRs) and Transmission and/or Distribution Service Providers (TDSPs)Administered Texas Retail Choice Enrollment and Switch Notification / Cancellation ProgramCreated and Ensured data integrity for a number of routine reports in SQL Daily Transaction Reports, Cancellation Verification Report, Representative of Record reports, Monthly Continuous Service Agreement Reports (SCR 732), Quarterly Performance Measures Report (PUCT Project No. 24462) Wrote and modified Retail Market Analysis proceduresServed as Technical Subject Matter Expert for other personnelAssisted in training new employees