Data Analysis Resume Profile
Summary of Qualifications:
A highly accomplished Information Technology and finance manager with over 20 years comprehensive experience and a proven ability to see the big picture and quickly isolate opportunities for improvement. Extremely strong analytical and problem solving ability combined with a solid understanding of financial concepts, data analytics and the ability to communicate well with individuals at all levels of the organization. A professional with a strong track record of creating technology solutions that reduce costs and enhance organizational capability and productivity.
Professional Experience:
Confidential
Manager, Database/Data Management
- Reported to Vice President of Finance with dotted line to Chief Financial Officer. Managed data analytics, data structure and databases in supporting the organizations fact-based decision making efforts and all driver based analytics to optimize cash flow for multiple business units. Managed and staffed a department of data warehouse and business intelligence analysts and developers. Developed, motivated and managed third party developers and offshore development activities. Led the transition and integration of financial data for all acquisitions, divestitures and divisional transfers. Headed projects for enhancing product profitability, acquisitions, integrations and best practice analysis. Created and managed multiple Inter/Intranet financial application systems including data repositories. Supported the Finance, Sales and Marketing departments in the areas of operational planning, revenue forecasting, and cost analysis.
- Successfully led rollout of new Business Intelligence platform converted Oracle Discoverer to Business Objects XI r2 and reporting functionality to multiple business units prior to project completion deadline.
- Facilitated, calculated and analyzed incentive compensation payouts totaling 10 million annually.
- Centralized data warehouse reporting consolidated superfluous and redundant information into 258 automated reports while eliminating over 3000 existing reports from various end of life systems.
- Created and reviewed original functional and technical design documents for developing data warehouse and reporting solutions.
- Successfully managed, developed and implemented data analytics projects in the areas of financial reporting, marketing, legal and sales organizations.
Consultant/Independent Contractor
Confidential
- Performed ad-hoc financial analysis within SAP 4.6C environment, audited financial systems, assisted in revenue recognition, consolidate worldwide deferred revenue, and assist month end closing.
- Discovered 319K in unbilled revenue through an audit of financial systems.
- Automated in-house systems for employers and clients resulting in efficiencies.
- Integrated and audited corporate data in preparation for SAP migration from newly acquired businesses.
- Developed a data quality system for a large professional services firm with multiple subsidiaries throughout the United States and the world.
Confidential
Manager, Database Systems
- Managed data integration, data migration, purchase requirements and vendor contracts. Coordinated and led database upgrade projects including data integration for database systems. Wrote code for database access, modifications, and construction triggers and stored procedures . Managed projects for data integration from acquired companies into corporate database systems. Led DBAs and programmers to customize software to interact with multiple database systems. Integrated data from Oracle, SQL Server and Sybase databases on UNIX and NT platforms.
- Developed and deployed software to upgrade applications for 1200 remote users and 82 global offices.
- Managed the rollout and implementation of new releases and software upgrades for CRM systems.
- Developed and implemented an automated and improved sales reporting system and incorporated customized multiple third party software applications VB and SQL .
Confidential
Manager, Database Development and Data Management
- Managed database development projects for IT/Marketing/Sales operations in the area of marketing/advertising, reporting, analysis and vendor management. Acted as the primary interface between Corporate IT and multiple non-regulated business units. Coordinated activities of DBAs, programmers and contractors to develop business unit databases. Created SQL scripts to migrate data between various databases that reside on multiple platforms. Planned, coordinated, and implemented departmental strategy for data/network encryption and security for use with third party vendors as well as internal operations. Built working relationships and establish communication channels with external data vendors and internal business unit Solution Directors to provide inexpensive and timely system/data solutions.
- Evaluated and trained over 100 users on ETL, OLAP, Business Intelligence and Decision Support reporting and analysis tools Business Objects, Seagate Holos, SAS, Crystal Analysis/Reports, DataMirror, Cognos Impromptu/Powerplay, Brio, Analytics, Oracle Discoverer, UNIX, Teradata, etc.
Confidential
Project Manager, Data Analysis
- Managed and implemented system development projects utilizing the new data warehouse. Identifed, analyzed, and implemented new requirements for the Oracle/Unix data warehouse and multiple data marts by coordinating with all levels and functional areas within the company. Provided the necessary system support to meet system availability, data management, data accuracy, and system performance requirements for production data warehouse systems.
- Originated, managed and staffed the first Business Intelligence/Data Analytics team for the company to provide insight for the executive team that was previously unavailable.
- Developed, documented, and delivered original user training on the data warehouse functionality utilizing Oracle, Brio, Crystal Reports, Essbase, SQL, SAS, E-R Diagrams, Data Dictionary and meta-data.
Confidential
Network Administrator/Project Manager-Financial Analysis
Coordinated and managed activites of internal and external contractors and software developers for web servers, database servers, software applications, e-mail, security, connectivity, corporate wide SLAs. Accessed user needs, provided alternatives, furnished solutions and coordinated resolutions between end users and support staff in networking, PC repair, purchasing, training, systems design, research, web development and programming for five LANs. Diagnosed, tested, and troubleshooted network hardware/software applications on corporate enterprise LAN/WAN and coordinate multiple projects involving moves/adds/changes for desktop wiring.
Financial/Systems Analyst SCA Analyst - Team Lead
- Managed various telecommunications billing projects with Finance, Sales, Legal, Business Development groups to increase productivity, improve knowledge of products, services and tools. Programmed both mainframe and PC environments using statistical packages SAS, Excel, Syncsort, MVS, JCL, and Business Objects .
- Developed multiple financial/computer models, which incorporated mainframe information into software applications used to produce monthly packages for multinational and national segments. Received corporate recognition award for developing, implenting and automating reporting solutions.
Confidential
Accountant/Financial Analyst
Led a staff of two employees overseeing Accounts Payable and Accounts Receivable. Prepared individual state and federal tax returns for the organization. Performed cost/benefit analysis on products and distribution methods.
Confidential
Supervisor/Manager
Led a staff of six employees and two consultants for the Financial Research/Analysis Department after being promoted from initial position of Asset Servicing/Operations Analyst.
