Data Manager

Daniel R. Whitney

Westerville Ohio, ***** acyg4u@r.postjobfree.com Mobile: 614-***-****

OBJECTIVE

Business Intelligence and data analysis management expert where a keen comprehension of business requirements, data process flows and analytical expertise will contribute to improved data life cycles from data management to analytical models, and decision making.

QUALIFICATIONS SUMMARY

Twenty years of experience ranging from startups to Fortune 500 companies. Expert at leading teams that manage the aggregation and analysis large data sets that develop the analytical models. Create and document data requirements, process improvements, and streamlined business analysis processes. Liaison between Business and IT teams to define, document, translate, and validate the requirements into working solutions. Solves complex problems by identifying insightful patterns that drive actionable solutions. Proven abilities and skills include:

Lead teams that create and manage the analytical models used to solve complex problems.

Identify and manage data reporting processes that track results and drive improvement.

Solicit and define data requirements and policies on multiple integration projects.

Partner with LOB’s and IT to define and document data processes and standards.

Manage data flows end to end, from source systems, to EDW, to reporting processes.

Project management, Requirements and QA experience.

PROFESSIONAL EXPERIENCE

American Electric Power – Columbus, OH

Sr. Consultant – Data Management Feb-2015 – Present

Project role focused on data mapping, migration, analysis and management within the IT Operations area for the Oracle MDM migration project.

Create, test and manage customer meter data for system testing and validation.

Completed gap analysis, mock-ups, and review with stakeholders.

Extract, Transform and Load data from third party systems into the test environment.

Liaison between project team and EDW team on additional business intelligence requirements process for new data capabilities, reporting prototypes and dashboards.

I used SAP BO, SAS, PL-SQL, Power Pivot, XML, VBA, Access, Excel and SharePoint.

Nationwide Insurance – Columbus, OH

Sr. Consultant – Data Analysis Feb-2014 – Dec 2014

Project role focused on data mining, analysis and management within the IT Operations area.

Create, test and manage financial analysis and billing models that quickly compared the “old vs new” environment for analysis and discussions of the proposed changes in IT services.

Present model prototypes to IT Finance teams for the 2015 Budgeting process.

Business Intelligence requirements gathering, reporting and testing for new data flows.

I used SQL Server 2012, IBM DB2, Oracle, VBA, Power Point, Access and Excel.

Verizon Wireless– Columbus, OH

Consultant – Business Analyst Oct-2013 – Feb-2014

Built data models that validated time based usage data from numerous sources.

Manage multiple Oracle reference tables to improve data integrity and systematically audit the data management processes to ensure data quality and requirements exceed expectations.

I used PL-SQL, VBA, and MS Office.

J.P. Morgan Chase – Columbus, OH

Lead Data Analyst – ATM Customer Experience Apr-2013 - Aug-2013

Data analyst lead on predictive modeling project aimed to improve customer experience on the banks network of nearly 10,000 ATM’s.

Daniel R. Whitney Page Two

PROFESSIONAL EXPERIENCE (continued)

J.P. Morgan Chase – (Cont’d)

Develop BI model to reduce cash outages within ATMs.

Managed team on data mining and analysis of the fault codes on the Banks ATM monitoring system, identified areas and implemented improved processes that led to a reduction of down time of individual ATM’s.

Incomm – Atlanta, GA Oct-2008 - Oct-2013

Manager – Data Analysis

Led staff on the defining, designing, modeling, and profiling of data for analytical processes, starting with customers’ requirements and working backwards to the mapping, management and storage of the data.

Led requirements and development of BI Dash Boards, presented prototypes to teams leads, Migrated process to a Cloud environment for enhanced real time data for Sales Team.

Solicit requirements to design and build multiple databases to segment data and improve reporting and billing accuracy, data profiling assisted in identifying millions of dollars of unbilled transactions which we’re able to invoice and collect.

Manage the requirements and creation of automated FP&A and Sales metrics reporting.

Partner with IT to research and resolve data reconciling issues, implement data controls, standards and validation processes to improve data integrity.

Accountable for validating and analyzing all margin based sales data reporting.

Automate dash boards via "ETL" using stored SQL procedures, Access and Excel.

Led analytical and reporting requirements and testing plans on Oracle R12 implementation.

I used T-SQL, PL-SQL, VBA, Power Point, Access, Excel, MSBI, SSAS, SSIS, SSRS, Power Pivot, and Oracle PL/SQL.

Allconnect – Atlanta, GA May-2007 - Sep-2008

Analytics Manager - E-Commerce

Accountable for the financial and analytical management of the company’s growing outbound marketing business and all e-commerce channels in Oracle and Hyperion.

Develop testing, validating and reporting around provisional transactions, showing gross and net amounts.

Optimize paid search returns by vertical, improve overall paid search ROI by continuously optimizing lower cost higher converting keywords.

Reduce direct costs of marketing campaigns by 20% through negotiations with new vendor.

Improve the click-through rates on email marketing campaigns by 15%.

Develop and communicate core KPI metrics for and for all channels of e-commerce.

I used Google Analytics, Omniture, PL-SQL, SQL, VBA, Access, and Excel.

MIVA – Fort Myers, FL FEB-2006 - APR-2007

Manager – Financial Data Analysis

Accountable for the creation, monitoring, and reporting of the Divisions’ $75M operating budget and the departmental level reporting to Senior Management.

Led BI reporting and analysis on “key word” position spreads.

Project lead on the Precision Network implementation and reporting processes. Funneled premium web traffic to the top Advertisers, driving higher pay per click bids. The Precision network accounted for 50% of the corporate revenue within the first 6 months of operation.

Team lead on Cognos BI implementation, interfaced with business and IT teams to provide robust BI management and reporting solutions.

Develop a scorecard dashboard to monitor online traffic by net revenue and by source to assist with contract negotiations and produce greater insight to traffic profitability.

I used Cognos, SQL, and MS Office.

Daniel R. Whitney Page Three

PROFESSIONAL EXPERIENCE (continued)

Navis Capital Management – Columbus, OH Mar-2001- Dec-2005

Project Manager - Data Analysis

Research, develop and test predictive financial models, which built the foundation of proprietary investment management program.

Develop and maintain data warehouse with 10+ years of historical data.

J.P. Morgan Chase – Columbus, OH May-1988- Feb-2001

Financial Modeling - Technology Finance Manager

Led staff on the $600MM annual budget process for the Data Center and Network Groups.

BA liaison between senior financial management and senior technology management bridging the gap between engineering and finance.

Document and define data requirements during numerous system/data migration projects.

Assist in the internal telecom expense allocation models and highlighted adjustments needed for full recovery and the true costs incurred by the profit centers.

Supervised staff through month end closing, reporting and annual budgeting cycles.

EDUCATION

B.S.B.A., Finance – The Ohio State University - Columbus, OH

CFA Level II candidate, Series 3 and 6 License

MCSE Level I candidate

SOFTWARE

Experienced with Access, Excel, Power Point, PowerPivot, BI/DW, Google Analytics, Hyperion, Essbase, Cognos, SAP BO, IBM Mainframe, Salesforce, Oracle R11/12 & MDM, Omniture, Power Pivot, SSAS, SSRS, SSIS, SAS, Oracle PL/SQL, SQL, T-SQL, VB/VBA, Visual Studio, Visio, XML, SDLC and Agile project methodologies.

Contact this candidate