Terry M Gannon Email & Phone Number

Denver, Colorado, United States

Responsible for the development and maintenance of business intelligence applications. Identifies, researches, and resolves technical problems. Ensures that the use of business intelligence applications enhances business decision making capabilities. Develops reporting solutions including web-based reports, dashboards, scorecards, and queries utilizing SSAS, SSRS, Spotfire, PowerPivot, PowerBI, Power Platform specializing in Power Automate. Create SSIS packages and data integration solutions, based in knowledge of software lifecycle practices for large data environments. Monitor and resolve issues related to the Microsoft Business Intelligence platform. Proven track history for successfully managing and implementing projects by gathering requirements and regularly communicating project status' and timelines.

Denver, Colorado, United States

Golden, Co

• Assisted in creating financial planning dashboards for 30 CoorsTek facilities. Then used VBA to create SQL statements to extract from these dashboards to load to a SQL Server based data warehouse.• Using SSMS stored procedures extracted datasets from MS SharePoint lists to create row level security for our tabular cube environments. This entailed enhancing 8 of our existing tabular models using visual studio.• Created an automated facility capacity report emphasizing growth potential used in executive board meetings.• Created Excel OLAP Calculated Measures using MDX rather than adding measures to existing cube structure.

Englewood, Co

• Created SSIS package and nightly jobs to extract 3rd party data using stored procedures to load our production Oracle CDW database. This dataset was managed by our IT team to provide agents credit granting approval.• Utilizing SSIS collaborated with team members creating our executive data mart extracting from an Oracle CDW database to Management Studio. This included data mining, scripting SQL queries and verifying results.• Created call center reporting using SSRS with multiple data sources containing 30 call center metrics.• Enhanced Call Center reporting utilizing auto generated MS Excel PowerPivot tables and charting whose data models was an Oracle backend. This PowerPivot data model included calculated measures utilizing DAX. Prototyped this Tabular dataset with multiple dimensions in Analysis Services.• Built a MS Access Collections front end to load SQL Server tables used for collections agents reporting.

Englewood, Co

• Implemented IVR parameterized SSRS reports presenting progress of business requested alterations.• After analyzing datasets in both test and production environments, provided IVR standardized and ad hoc reporting support.• Agile and Kanban environment experience.

Englewood, Co

• Responsible for building and maintaining call center datasets, subsequent creation of operational metrics, and reporting for executive team members.• Provide on-going, high quality production maintenance of automated database extractions producing reports that identify fluctuations in trends, risks and opportunities. • Created MDX based SSRS Call Center reporting while managing a purchased 3rd party SQL Server which ran Oracle, MS Access and CSV SSIS packages. Created new calculated measures and dimensions, as well as, monitoring and troubleshooting daily jobs.

Englewood, Co

• Supported business decision needs by creating product specific interactive dashboard reports which extracted from an IBM Server backend and distributed to specific recipients daily during non business hours.• Maximized speed and minimized degrading server performance by introducing evening data extractions.• Created Excel Add-Ins with trigger buttons in the excel ribbon to distribute all reports and useful data mining tools. Such examples are auto import dynamic cross referencing tables into users active excel workbooks and pivot table front ends and MS Access table backend.• Increased team member’s productivity for financial modeling by maintaining monthly metrics in normalized tables from an IBM server via ODBC connections.• Monitored and reported on the effects of a money transfer price decrease comparing results against regular priced control markets. Metrics included growth, lift, spread and weekly totals.• Utilizing SQL and multiple in house data sources, scripted over 700 automated monthly uniform reports for US money transfers, distributed to multiple business partners via MS SharePoint. • Provided financial support and analysis for Marketing, presenting coupon redemption rates, marketing initiative effectiveness, geographical competitor impacts using MS MapPoint, natural disaster impacts and US border analysis.• Using Essbase and AS400 queries, compiled Domestic Money Transfer monthly financial transactions, revenue and principal trends, corridor specifics analysis, as well as, actual to budget tracking and headcount costs.

Burbank, Ca

• Created headcount and financial analysis for internal production and technology departments focusing on project cost forecasts, actual to budget analysis, and overall project investment analysis. • Worked with production and development executives to manage and facilitate accurate financial reporting as project requirements changed. Created various ad-hoc reporting and analysis as needed.• Performed weekly payroll approvals to ensure proper funds allocations and journaled inaccuracies.• Assisted in providing necessary current and historical data to animation studio VPs, as well as, Disney Studio executives during the Pixar acquisition.

Bachelor Of Arts, Mathematics

General, General Studies