Resume

Sign in

Business Intelligence

Location:
Wake Forest, North Carolina, 27587, United States
Posted:
October 26, 2016

Contact this candidate

CRYSTAL L. RHOADES

***** *********** ******, *******, ** 27614

(919) ***-**** acw8u1@r.postjobfree.com

www.linkedin.com/in/crystalrhoades

PROFILE

Experienced Business Intelligence (BI) professional, certified in IBM Business Analytics, with an extensive background in financial analysis and metadata management from diverse industries including healthcare, telecommunications, clinical research and mortgage banking. Solid technical experience in BI development with IBM Cognos 10, SAP Business Objects 4.1, Crystal Reports and Tableau. Seeking a management or senior technical position in Clinical and Business Intelligence to leverage current Business Intelligence skill and the knowledge acquired from Duke University Master of Management in Clinical Informatics

EDUCATION

DUKE UNIVERSITY, School of Medicine, Durham, NC

Master of Management in Clinical Informatics August 2016.

Relevant coursework includes: Health IT Business Solutions; Foundations of Management and Organizations; Data, Information, and Knowledge Representation

UNIVERSITY OF PHOENIX, School of Business, Santa Clara, CA

Master of Business Administration, 1995.

Relevant coursework includes: Operations Management; Strategic Planning & Implementation; Human Capital Management and Quantitative Reasoning for Business and Organizational Leadership

NORTH CAROLINA A & T STATE UNIVERSITY, School of Business

Bachelor of Science, Accounting, 1986

PROFESSIONAL EXPERIENCE

Martin Marietta Materials, Raleigh, NC 2016 - 2016

Business Analyst/Developer

Developed metadata Framework Manager models (Physical Layer, Business Layer, and Presentation Layer).

Created complex reports with Report Studio and deployed reports into IBM Cognos Connection.

Worked extensively in IBM Cognos Transformer creating multidimensional cubes.

Maintained and modified security for IBM Cognos Connection by assigning users from Active Directory Namespace.

Gathered end user-requirements and documented end-to-end processes for SDLC.

Validate and test Tableau dashboards.

DUKE CLINICAL RESEARCH INSTITUTE, Durham, NC 2012 - 2016

Senior Analyst, IT Business Intelligence Administrator/Developer

Designed distributed infrastructure for IBM Cognos 10.2.1 environment with Oracle databases.

Installed and configured IBM Cognos 10.2.1 BI Server in a distributed architecture with load-balancing across multiple Web Servers, Application Servers and Content Management Servers. Including the following applications: Mobile gateway, Mobile client components, Insight BI integration gateway, Metrics Manager, Framework Manager, Transformer, Map Manager, Metrics Designer, Life Cycle Manager and Insight BI integration with provisioning of desk top client from webserver.

Installed and configured IIS (Internet Information Services) 7.5 for IBM Cognos 10.2.1 web servers.

Developed metadata Framework Manager models (Physical Layer, Business Layer, and Presentation Layer).

Created complex reports with Report Studio and deployed reports into IBM Cognos Connection.

Worked extensively in IBM Cognos Transformer creating multidimensional cubes.

Maintained and modified security for IBM Cognos Connection by assigning users from Active Directory Namespace.

Gathered end user-requirements and documented end-to-end processes for SDLC.

Developed Tableau dashboard visualizations to provide a snapshot and trending over time of clinical data.

Created adhoc reports in Tableau by connecting various data sources.

Handled Tableau admin granting user access.

Publish Tableau workbook creating sites and filters for appropriate user security.

Analyze source data and modify data types as needed.

Use excel, flat files, csv or database connection to generate Tableau adhoc reports.

Installed and configured SAP Business Objects 4.1 SP6.

RESEARCH TRIANGLE INSTITUTE, Research Triangle Park, NC 2011-2012

Senior Business Intelligence Analyst

Installed and configured Cognos 8.4.1 and Cognos 10.1 business intelligence software with single sign-on using LDAP and Microsoft SQL Server databases.

Analyzed reporting requests and worked directly with business owners to define requirements.

Deployed packages/folders from one environment to another (DEV to QA to PROD) using BSP Metamanager.

Managed user access and IBM Cognos capability mapping through Active Directory groups.

Developed Framework models, Transformer cubes, Report studio reports, scorecards and dashboards.

TEKELEC (Acquired by Oracle in 2013) 2007-2011

Senior Business Intelligence Analyst/Senior Financial Analyst

Installed and configured Cognos 8.4.1 and Cognos 10.1 business intelligence software in large distributed environment.

Developed and prepared process to move Oracle data to Data Warehouse with Data Manager ETL tool for Oracle GL, Accounts Payable, Service Contracts, Accounts Receivable, Materials Management and CRM.

Designed, developed, built and supported metadata models and cubes utilizing Framework Manager and Transformer.

Created, delivered and presented end-user training materials for IBM Cognos Report Studio and Query Studio.

Gathered/designed report requirements and built sophisticated reports/dashboards/scorecards, analysis and queries.

Prepared detailed reports including actual vs. budget/forecast analysis for expenses and P&L analysis.

Recommended suitable amendments in the budget to the managerial staff of the corporate office.

Monitored the budget throughout the year, approving all purchases including capital acquisitions.

Reviewed financial transactions, sales contracts and in charge of day-to-day, quarter end and month end closing activities.

DUKE UNIVERSITY HEALTH SYSTEM, Durham, NC 2004 - 2007

Senior Financial Analyst, Patient Revenue Management

Led a team of 2 developers to design, build and streamline denial management processes for the hospitals; these critical functions worked well and were found to be quite intuitive.

Analyzed reporting requirements to identify root causes to prevent denials; improve cash & efficiency and writing specifications (high-level, detailed functional, detailed technical) for the reports. Led a team to quickly develop a number of crucial reports for the largest facility in Durham, NC.

Evaluated the complex reporting needs for the hospitals and designing appropriate reports. Prepared and coordinated distribution of various financial reports and analyses for senior management and external agencies to include financial analysis of individual unit operations.

Maintained liaison with hospital financial managers and administrative staff in the preparation and analysis of financial reports, to provide information and to resolve problems concerning approved budget, insurance claims and denials.

Set up the metadata models using Framework Manager and built data cubes using BI Transformer.

Designed and developed interactive Dashboards and Key Performance Indicators with drill down and drill through capabilities.

Identified and developed metrics, measures, and dimensions.

Designed and developed ETL procedures using Cognos Decision Stream.

NORTEL, Research Triangle Park, NC 1998 - 2001

Senior Financial Analyst, Finance

Performed calculation/review of monthly/quarterly/annual sales commissions, including running reports in Salesforce.com, HR data validation, compilation of data and performing all calculations.

Stayed abreast of federal, state and local compensation regulations to ensure company compliance.

Prepared and maintained the annual commission policy and various written commission plans, including managing commission plan acknowledgement forms.

Consulted with HR Business Partners and leaders on all compensation programs and practices that pertain to the respective business groups.

Assisted the Sales organization in resolving any Compensation-related issues or discrepancies.

United States Army (Reserve) 1987 - 2001

Accountant

Supervised accounting, accounts payable, disbursing, budget and internal control operations.

Served during Operation Desert Shield/Desert Storm.

CERTIFICATIONS

Microsoft Office Specialist Excel 2013 09/08/2015

ITIL Foundation 06/06/2012

IBM Cognos 10 Designer 03/30/2011

IBM Cognos 10 Developer 04/01/2011

IBM Cognos BI 8 Designer 05/27/2010

IBM Cognos BI 8 Developer 11/04/2010

Microsoft Certified Systems Engineer 2000 02/20/2004

Microsoft Certified Database Administrator SQL 2000 08/07/2003

Microsoft Certified Systems Administrator 2000 06/03/2003

CIW Professional 09/03/2003

CIW Associate-I-net 09/03/2003

CIW Associate 09/03/2003

Master CIW Designer 09/03/2003

CompTIA A+, Network+, iNet+ 04/25/2003



Contact this candidate