Jeff Ridings

Listens to corporate executives and managers requests for better insight and information. Designs integrated dashboard information portals. Incorporates business processes into actionable metrics on dashboards. Fluent in SQL, T-SQL, Business Objects, Xcelsius, Excel, Access, Oracle, IBM, Microstrategy, Microsoft BIDS, and English (natural born in USA).

•Brought in to help client companies with financial analysis, database design, business productivity analysis and business intelligence strategy development. •Responsible for designing Access Database front end Forms, Tables, and Queries for QHR (Quorum Health Resources) Hospital Benchmarking database. •Designed (frontend) Access database forms and tables. Created relational queries to build and load the benchmark data from hospital client sources using SQL server as the backend.

•Responsible for designing Business Objects queries to extract data from HCA Business Objects warehouses for hospitals acquired by CHS. •Developed extract formats and automated processes to populate HMS system for CHS. •Trained programming staff in query design, automation development and reporting techniques of Business Objects software. •Managed the CHS corporate upgrade process from Business Objects 6.5 to XI version.

•Responsible for physical design modifications of enterprise data warehouse – Managed Care and DDS (Diagnosis Decision Support) Universe using Business Objects Designer 6.5. •Developed various WEBI and DESKI reports in Business Objects with drill-down capabilities. Used Business Objects SQL and tested in Teradata (T-SQL) for quality control. •Created Informatica ETL scripts.

As an onsite project management resource for various projects, was responsible for: •Developing corporate-wide Business Intelligence Strategy and identifying Key Performance Indicators. •Managing data warehouse design modifications including aggregation and relational schema re-design. •Designed improved Web Intelligence reports and “actionable metric ready” Dashboards for clients. •Developed “Best Practice Dashboard Selection tool” for client to select the best Dashboard tool.

Role consisted of establishing and implementing a Business Intelligence strategy for this Pharmaceutical leader. Responsible for leading the corporate rollout of the Business Objects XI r2 software primarily focused on increasing sales of leading pharmaceuticals in pipeline. Resourceful team leadership in the following areas: Administration and Design •Business Objects Administration – Refreshing, Publishing, and Scheduling of Corporate Reports. •Designed Universe sourced from Oracle 10g.

•Performing cash flow modeling and Balance Sheet planning for client companies. •Making presentations of financial projections to equity investors. •Conversion of financial information to other file formats and software applications as requested by client companies. •Creation of Access databases and establishing procedures for client companies. LDM and PDM.

•Responsible for the monthly financial analysis and revenue reporting of insurance reimbursements for physicians participating in the Vanderbilt Medical Group. (Physicians Group) •Designed Business Objects queries and desktop intelligence reports for A/R, collections, and insurance audits of reimbursement activity for primary specialty departments and physicians. •Reviewed and analyzed fee schedules.

•Implemented paperless reporting and analysis of retail financial reports, resulting in significant cost reduction ($1.1 mill) and increased speed of information delivery. •Business Objects 5.x database designer of Purchase Order Datawarehouse to increase buyer efficiency and support merchandise planning and inventory control. •ERP System conversion and implementation experience focused on integration testing, application data translation, and validation. •Trained Loss Prevention Dept. Auditors

•Frequent meetings with CEO to develop Executive Information Systems and pioneer new methods in visualization of key performance indicators. •Designed and prepared consolidated financial planning and budgeting reports for each merchandise segment of sales, profits, margins, and inventories for CEO and senior management review. •Managed the team that prepared month-end general ledger entries using Oracle software for G/L, A/R, A/P and inventory and developed accurate accounting policies.

Flow Chart Design, Fund Accounting, Cost Accounting, Music Business Administration, COBOL, Database Design