Data Analyst Intelligence Manager
Resume:
Results Driven Data Analyst/Business Intelligence Expert – Trusted technical advisor with prominent corporate executives and clients with expertise designing and implementing robust, and scalable solutions that streamline/automate data management and reporting. Recommends and designs cutting-edge database solutions/data models that capture business intelligence, extracting and distilling data into digestible information and analytics providing critical insights to resolve complex business challenges and inefficiencies. Establishes and manages large data warehouses and data marts to safeguard data and ensure effortless retrieval. Wide-ranging technical expertise working with third-party platforms, designing data ecosystems/framework/structures across multiple operational systems. Solid business, financial, and technical acumen, capable of relaying technical concepts to non-technical personnel with full transparency and clarity consistently assessing business challenges identifying opportunities and offering expert recommendations to senior management.
Areas of Expertise
Business Intelligence (BI)/Analytics Process Automation Documentation/Reporting
Data Mining Extract Transfer Load (ETL) Cross-Team Collaboration
Data Analysis/Valuation Strategic Planning/Tracking FX Conversion Rates
Data Consolidation Forecasting/Budgets Mentoring/Training
Technical Skills: Alteryx Essbase MS Access MS Excel SmartView Visual Basic (VB) SQL ERP CRM
Oracle Hyperion Financial Management (HFM) Batch Files EPMA
Professional Experience & Achievements
S&P Global, Inc. (IHS Markit acquired by S&P Global, Inc) 2007 – 2023
IHS Markit
Data & Business Intelligence Manager
Designed strategic automation for end-to-end forecasting process by merging EAS calc scripts and .bat files which ensured data quality and accuracy.
Transformed revenue reporting process to increase accuracy and enhance real time accessibility across organization.
Designed and implemented automated process to combine multiple data streams and apply Data Governance best practices to ensure the accuracy of the financial forecasting process.
Researched and recommended implementation of Alteryx Analytics Automation Platform to deliver end-to-end automation of analytics. Presented business case and justification to executive leaders.
Systematically designed Alteryx process for extracting data from Essbase and performing organic/FX calculations to prepare direct load file and data finalization into Essbase.
Strengthened data extraction capabilities by utilizing Alteryx analytics automation tool to seamlessly perform complex data mining/calculations and FX conversions across ~30 different currencies.
Instrumental in leveraging tools/features of Alteryx software to extract required data in two hours, previously took two-weeks.
Championed strategic process and procedure automation initiative to reduce labor by ~eight hours and deliver data enterprise-wide same day in partnership with finance.
Drove strategic planning and streamlined execution for Essbase financial forecasting and planning software implementation.
Contributed expertise during expansive tenure with IHS. S&P Global acquired IHS in 2022 and role was eliminated in 2023 due to restructure.
Leveraged tools/features of MS Excel, Access, and SQL to design innovative and automated data analysis, retrieval and reporting solutions and streamline efficiency across business operations.
Scrupulously designed and maintained complex data structure within Essbase. Contributed technical expertise to administer and maintain Essbase system with automation to ensure optimized performance and availability.
Collaborated with Finance Team to prepare and execute forecasts by running seven distinct scenarios on prior year, monthly, and quarterly FX rates.
Partnered with ~30 worldwide financial professionals to conduct comprehensive data validation to ensure accuracy of forecasting, impact, and provide insights used in complex business decisions.
Proficiently modified calc scripts to maintain data flow process.
Led consolidation, and preparation of financial statements across multiple business units.
Drove aggregation and centralization of data from Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems.
Performed analysis and comparisons to ensure data complete, reasonable, and accurate and minimize redundancies.
Adeptly analyzed data and generated automated enterprise reporting through complex stored procedure development.
Utilized extensive comprehension of Hyperion Financial Data Quality Management (FDM) and mapping of trial balances to ingest into Hyperion Financial Management (HFM) database.
Utilized Extract, Transform, Load (ETL) process to aggregate data from multiple sources into secure data warehouse.
Spearheaded end-to-end execution of multiple software implementations and solution customization projects.
Utilized technical acumen and features of MS Access and Visual Basic (VB) scripting to develop innovative data extraction tools.
Cultivated strong relationships with cross-functional teams to consistently ensure alignment with objectives.
Systematically duplicated Hyperion Financial Management (HFM) data into Essbase for complex forecasting and business intelligence.
Methodically loaded Hyperion Financial Management (HFM) data with monthly retrievals from SAP and multiple accounting systems.
Administered and maintained metadata structure within Enterprise Performance Management Architect (EPMA) mapping system.
Accountable for internal revenue reporting for $4B corporation ensuring meticulous attention to detail.
Conducted group and 1:1 training for ~50 end users on Excel SmartView; structure changes, process, calculations, functionality, and features.
Hein & Associates LLP 2003 – 2007
Supervisor – Data and Business Intelligence
Architected data model for tracking financial information on troubled debt restructuring. Integrated data into MS Access from .txt files and into MS Excel for easily digestible reporting and business intelligence for end users and creditors.
Conceptualized and deployed integrated reporting packages by utilizing MS Access data storage and MS Excel with ODBC connections to refresh exhibits.
Instrumental in automating run of multiple files for calculating business intelligence across all enterprise systems. This improved accuracy and minimized redundant tasks.
Scrupulously examined tax returns to ascertain clients net worth and determined capability for negotiating mutually beneficial agreements.
Conducted extensive data analysis and reporting and provided expert recommendations for critical valuations.
Designed and developed robust data model for tracking bond data volume. Served as a trusted resource to coordinate timeline for tranches in alleged Ponzi scheme.
Engaged to contribute expertise on business/personal net worth valuations for legal disputes with a high degree of accuracy.
Previous Experience
SFA Technology Prior to 2003
Partner/Consultant
Sales Performance International
Business Analyst
Education
Master’s Degree – MBA with Emphasis in Finance
University of Iowa Iowa City, IA
Bachelor’s Degree - Accounting
Iowa State University Ames, IA
Tim Kennedy MBA
Aurora, CO ****************@*******.*** LinkedIn
Contact this candidate