Post Job Free

Resume

Sign in

Business Intelligence Consultant

Location:
Thompson's Station, TN
Posted:
February 28, 2018

Contact this candidate

Resume:

Jeff Ridings

Qualification Summary

Well-versed in architecting and managing Business Intelligence Systems, physical data warehouses, SAP Business Objects XI & BI 4.x, MicroStrategy, Pentaho, Qlikview, Qlik Sense, Tableau, Jaspersoft, Cognos, and SAP HANA implementations. Effectively advances efficient productivity within teams and motivates people to achieve higher standards. Strong ethics and takes responsibility for financial statement representations. Extensive working knowledge of all stages of Business Intelligence development in the retail, healthcare, financial services and pharmaceutical industries. Captures industry best practices and infuses into the corporate standard. Leader of the team that won the TDWI 2010 Best Practices Award for Data Warehousing and Business Intelligence for a Non-Profit group. Demonstrated experience building and leading high-performance Analytics teams.

Professional Profile

Extensive management and hands on experience in developing Business Intelligence solutions in Retail, Healthcare, Financial Services, Oil & Gas, Government and Pharmaceutical domains. Proven ability to listen and communicate with C-level executives and senior management to achieve desired results. Strong technology skill set and implementation experience with multiple business intelligence/ETL tools: SAP HANA, MicroStrategy, Pentaho, Qlikview, Qlik Sense, Tableau, SAP Business Objects, Xcelsius, Jaspersoft, Crystal Reports, Microsoft (SSRS, SSAS, SSIS), Cognos, EPIC Clarity 2012, Datawatch Modeler, SAP Power Designer, Oracle (OBIEE), PL/SQL, Teradata, Cloudera/Hadoop, SQL, MDX, T-SQL, Informatica, Talend, Alteryx, Salesforce, JDA, Google Analytics, Deltek Maconomy BPM and MS SQL Server. Effectively works well with cross-cultural and multi-functional teams in USA, Canada, France, Russia, Poland, China, Sri Lanka and India.

Business Intelligence

Leader in Business Intelligence strategy formation, big data analytics, and executive consultation.

Leader of Analytics Team that won the TDWI 2010 Best Practices Award for Data Warehousing and Business Intelligence for a Non-Profit group utilizing QlikView data visualization tool and Jaspersoft.

Expert in designing SAP HANA/Business Objects XI 3 and BI 4.x, Xcelsius Dashboards, and Web Intelligence Reports. Migration expertise in SAP BW and ECC data into SAP HANA.

Ability to customize EPIC universes to meet healthcare systems specific reporting/dashboard needs.

Certified in development of MicroStrategy (9.02) projects, dashboards, documents, reports & Mobile BI.

Lead designer of Capital Risk Management dashboard for Goldman Sachs, helping to define their Business Intelligence Strategy and designed the logical data model to create web intelligence reports linked to the dashboard.

Project leader for King Pharmaceuticals Business Intelligence strategy and implementation of sales and marketing revenue reporting system via Business Objects XI 2.0 installation on Oracle 10g.

Project Manager of corporate-wide “Agent Analytics” dashboard with actionable metrics for State Farm.

Industry pioneering leader in designing Executive Business Intelligence systems using PDA’s for a national retailer; invented a process to transform mainframe report information into a database designed for the HP200 LX handheld PDA for use by CEO and Chairman of the Board.

Developed “Best Practice Dashboard Selection tool” for client to select the best Dashboard tool (Xcelsius, Dashboard Manager, Performance Manager) used by SAP/Business Objects.

Business Objects XI 3 and BI 4.x implementer, MicroStrategy Developer, trainer, data warehouse and universe designer for retail, healthcare, financial services and pharmaceutical companies.

Data Warehouse and Data Mart Development

Provided data governance and managed enterprise and global data warehouse implementations including: Ingenious Med, State Fund of California, King Pharmaceuticals, HCA, CHS, State Farm Insurance, Goldman Sachs, UBS, Lifeway Stores and Service Merchandise.

Designed the physical database schema and the logical data model of a large Physician Prescription Data Warehouse, managed performance, created star schema design for the Business Objects Universe, consulted with business users to develop reports and implement security on Oracle 10g.

Data Architect and Modeler, Logical Data Modeling and Physical Data Modeling projects in Healthcare, Retail, Manufacturing, Insurance, Government Services and Financial Services. (Primarily using Visio, Sybase Power Designer, SAP HANA SPS3, Oracle 8-11g, Cloudera/Hadoop, Alteryx and SQL Server 2005-2014)

Enterprise Architect of UBS worked with international teams across 5 countries in agile methods to revise 132 databases and data sources for Tableau and SAP Business Objects.

Healthcare, Data Science, Financial Systems Conversions and Innovations

Dimensional Data Model developer of the North Dakota State Government – Eligibility Reporting (EDM) data mart for the DHS dept. use in state and federal ACA Medicaid Eligibility reporting on Oracle 11g. Consulted with North Dakota State Govt. to help develop Business Intelligence strategy and Roadmap. Reviewed current and proposed Business Intelligence state of Dept. of Human Services (DHS), State of North Dakota, and lead the requirements gathering process and data mapping process to develop a new ACA Eligibility System Data Mart.

Develops CRM ROI and Marketing Management strategy and consolidates new data sources into new enterprise marketing dashboards and reports for HCA. Effectively implemented statistical analysis and model development. Integrated Google Analytics with Tableau dashboards.

Patient Experience Survey data migration testing and QA from SQL server to Teradata for HCA.

Successfully implemented Pentaho Enterprise Edition 5.0 BA and DI servers for a Pharmaceutical therapy management company and their CMS Part D Stars client report portal project for Pharm MD.

Financial Systems conversion expert that converted healthcare patient data sets for chain of hospitals (65) into a new McKesson Horizon system format adhering to clinical standards for CHS.

Successfully implemented large scale (JDA) ERP system for 400+ multi-store retail chain. (Lifeway)

Designed, developed and implemented the process of transferring mainframe report information by download to personal computer for use in spreadsheet and/or database models and saving $1 million in annual labor and paper costs while increasing the speed of information delivery. (Service Merchandise)

Merchandise Reporting Manager for large-scale Catalogue retailer, designed and programmed the first web page to start E-Commerce and Internet capability. (Service Merchandise)

Initiated the start-up training of Internal Auditors and Loss Prevention Analysts in a mid-sized retailer (100+ Stores) and helped company develop new procedures for identifying employee theft through centralized daily sales transaction auditing resulting in realized loss reduction of $250,000 in first year.

Experience

Orchestrate Healthcare Spring Hill, TN

Sr. Business Intelligence Consultant Dec 2017 to Present

Developed SAP Web Intelligence reports for WakeMed Emergency Department metrics for hospital administrators.

Trained WakeMed client analytics team on best practices in SAP Business Objects WEBI report design and formula creation techniques.

Modified SAP Web Intelligence variables and advised on universe design changes/additions.

Developed new SAP Web Intelligence reports and innovative Control Chart graphs for comparison and replacement of EPIC Clarity reports.

Performed SAP Universe Design changes to meet new WakeMed reporting requirements.

HEOPS Franklin, TN

Director of Data Analytics, Reporting and BI Sept 2017 to Oct 2017

Performed database design, performance tuning, and resolution of backlog reporting requests.

Provided Data Analytics, Reporting and Business Intelligence guidance across the enterprise.

Design automation workflows that improve efficiency and reduce manual processing tasks.

Mentored and guided associates in best practices in business intelligence and data analytics.

Designed and developed new SQL Server enterprise databases for new client projects.

Develop automated credentialing workflows for faster processing of providers using Alteryx.

Implemented conversion of PDFs into Excel data for faster contract processing using Monarch Complete.

Collaborated with CEO and other executives in developing new business initiatives that gained more insight into client operational results.

Insight Global (Client is HCA) Nashville, TN

Business Intelligence Engineer/Consultant Sept 2016 to June 2017

Worked with Business Innovation team members and recommended new business intelligence solutions and new model developments for a variety of internal HCA business areas.

Developed CRM ROI and Marketing Management strategy and consolidated salesforce, google analytics and new marketing data sources into new enterprise marketing ROI QlikView dashboards and reports.

Recommended new Data Lake Architecture working in Hadoop/Cloudera to improve data flow and reduce operating costs.

Reviewed, developed and suggested edits to Tableau, QlikView and MicroStrategy dashboards across internal clients at HCA.

Developed Tableau dashboards using Google Analytics and Salesforce data sources.

Performed Patient Experience Survey data migration testing and QA from SQL server to Teradata for HCA.

Curated and designed better data sources using ETL workflows for business intelligence and clinical research stakeholders (Alteryx 10.6, DM Express and Talend).

Collaborated with Clinical Research to develop a data science Tableau Dashboard for alerting hospital management when swab and bathing protocols are met/not met for patients in CCU.

Responsible for statistical analysis and model development of the needs of internal HCA clients to help identify problems and propose solutions, liaise with internal business stakeholders, architects, and developers.

Developed new uses for SAP Business Objects Universes and connected them to other BI Tools (Tableau, MicroStrategy, QlikView, Qlik Sense, Power BI).

Leidos Health Nashville, TN

Sr. Business Intelligence Contract Consultant July 2016 to Aug 2016

Developed Horizon Practice Plus quality care reports that meet the State of Mississippi Dept. of Health requirements for hospital compliance in Accountable Care reporting.

Trained client analytics team on best practices in SAP Business Objects WEBI report design and formula creation techniques.

Conducted GoToMeeting training sessions with key report designers of client teams.

Recommended transition strategy steps to client in converting SAP Desktop Intelligence (DESKI) reports to Web-Intelligence (WEBI) reports in order to prevent risk when SAP drops support for DESKI report software.

Consulted with hospital system managers on Accountable Care Reporting initiatives and MACRA bundled payment analytics to improve revenue for hospital and physician practice groups.

UBS (United Bank of Switzerland) Nashville, TN

Associate Director May 2015 to May 2016

Developed database models and consolidated databases into new enterprise dimensional databases.

Researched best data modeling tools and recommended best enterprise data modeling software.

Performed reverse engineering, Logical and Physical Data Model development tasks on numerous databases and utilized SAP PowerDesigner to remodel databases.

Enterprise Architect worked with international teams across 5 countries in agile methods to revise 132 databases and data sources for Tableau and SAP Business Objects.

Trained and Mentored UBS staff in Best Practices for Requirements gathering and Dimensional Data warehouse design and modeling (following Ralph Kimball methodology).

Worked with Tortoise SVN, JIRA, SQL, SAP PowerDesigner, DDL, SAP Business Objects, ERWIN, Oracle, Qlik Sense, QlikView and Tableau.

Business Intelligence Agency Nashville, TN

President Feb. 2015 to May 2015

Consulted with clients to develop Business Intelligence and Digital Transformation strategy and Roadmap.

Gathered requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, business analysis, task and workflow analysis.

Engaged for short term contracts to assist clients in database customization, performance tuning, and/or resolution of backlog reporting /dashboard requests, utilizing a variety of Business Intelligence software tools.

Recent project involved taking EPIC Clarity 2012 universe (Notes) and customizing to meet healthcare client reporting requests.

Frequently engaged to mentor client teams and provide knowledge management and project management of Business Intelligence implementations.

Provided remote Business Intelligence services (enterprise architecture, data modeling, QA master test planning, report development, dashboard design) on a contract basis.

Utilized SAP Business Objects, Talend, SQL Server, QlikView, Qlik Sense, Power BI, SSRS, SSIS, DML, DDL, MDX, Alteryx and Tableau.

Rose International Bismarck, ND

Sr. Business Intelligence Consultant Mar 2014 to Jan 2015

Consulted with North Dakota State Govt. to develop Business Intelligence strategy and Roadmap.

Reviewed current and proposed Business Intelligence state of Dept. of Human Services (DHS), State of North Dakota, and lead the requirements gathering process and data mapping process to develop a new ACA Eligibility System Data Mart.

Mentored DHS staff on approaches to operational and analytical reporting to produce effective Cognos reports.

Provided DHS with Business Intelligence processes and mentoring in developing strategic reporting.

Planned and implemented the Business Intelligence Reporting of the Eligibility System Modernization project for DHS and ITD for the State of North Dakota.

Trained and Mentored DHS staff in Best Practices for Requirements gathering, ETL, and Dimensional Data warehouse design and modeling (following Ralph Kimball methodology).

Developed Sybase Power Designer models and wrote Oracle stored procedures for staging tables to target tables and consolidating three different data sources into one Oracle database.

Lead the dimensional data mart mapping and design of the Eligibility Data Mart (EDM).

Experienced in transforming logical business requirements into appropriate schemas and models.

Drives collaboration with the Oracle DBAs & Oracle Data Integration Leads to achieve BI objectives.

Extensive use of: SAP PowerDesigner, COGNOS, Qlik Sense, SharePoint, TFS, PLSQL, Oracle, and Excel.

OTSI Remote

Pentaho Developer May 2014 to June 2014

Installed and implemented Pentaho Business Analytics Enterprise Edition 5.0 and Data Integration 5.0 for OTSI’s client - HP (Hewlett Packard).

Served as the contract Pentaho Report and Dashboard developer remote resource for HP client report portal (a HP Vertica cloud hosted - Pentaho Proof of Concept).

Designed Pentaho reports and dashboards and accessed HP’s SAP Business Objects as a data source in order to meet user “Proof of Concept” needs and reporting objectives.

Presented final Pentaho reports and dashboards to client (HP) for evaluation.

Santa Rosa Consulting Franklin, TN

Business Intelligence Manager Jan 2014 to Mar 2014

Developed new Microsoft (SSRS) reports and modified existing client reports as requested.

Served as the corporate consulting resource for questions related to Management reporting and Business Intelligence development.

Performed QA with Office 365 and SQL Server 2008 (Empire Time) time and expense database.

Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details and distinguished user requests from underlying true needs.

Developed Tableau, QlikView and Qlik Sense dashboards in Proof of concept demonstrations.

Robert Half Technology Brentwood, TN

Business Intelligence Lead Developer-Pentaho Aug 2013 to Dec 2013

Installed and implemented Pentaho Business Analytics Enterprise Edition 5.0 and Data Integration 5.0 for this pharmacy medical therapy management (MTM) company, Pharm MD.

Served as the contract Business Intelligence developer resource for implementing Pentaho reporting, dashboard and corporate client report portal development.

Designed, updated and managed Pentaho reports and dashboards to meet user needs and reporting initiatives.

Trained staff in all aspects of using the Pentaho Enterprise report and dashboard software.

Designed Pharm MD “Star Cards” for existing and new client use.

Administered the Pentaho Business Intelligence Enterprise for Pharm MD.

Developed and rolled-out Pentaho Mobile for iPad customers of Pharm MD to quickly access dashboards.

Used SQL Server 2012 Database as a source for Pentaho and reverse engineered SSRS reports into Pentaho.

LBMC Brentwood, TN

Business Intelligence Lead Developer Jan 2013 to Jul 2013

Developed new Business Objects (WEBI 4.0) reports and modified existing client reports.

Served as the corporate consulting resource for questions related to Deltek Maconomy /Business Objects reporting and Business Intelligence development (new Universe design).

Customized Deltek Maconomy BPM Reports and modified underlying Business Objects universes.

Updated and modified universes to meet user needs and Deltek Maconomy BPM reporting initiatives.

Experienced with establishing interfaces and data feeds from external structured and non-structured data sources.

Mentored client staff in developing better Deltek Maconomy BPM report writing skills and understanding of universe design.

Performed QA master plan testing and identified data cleansing exceptions.

Used SQL Server 2010 database as source and edited some SSRS reports for consulting division.

Sunrise Systems Knoxville, TN

Senior Consultant Nov 2012 to Mar 2013

Advised Universe Design changes/additions to improve financial reporting capabilities on a Global scale.

Client - Kimberly Clark Corp.– Knoxville, TN where I was engaged in a short term contract to provide Global Reporting services using Business Objects XI 3.1 and assisting in the migration to BI 4.0 before year end.

Performing specialized SQL design within the WEBI report(s) and training client staff in developing Global P&L reports utilizing SAP Business Objects Web Intelligence reports.

Specifically designed a better WEBI Drill Filter that cascades down to specific segments via customized LOV.

Consolidation of joint ventures (countries) into EDW main Global P&L reporting, utilizing WEBI.

Holland Square Group Brentwood, TN

Sr. Business Intelligence Contract Consultant – QlikView Aug 2012 to Oct 2012

Responsible for developing the overall data schema model and QlikView dashboard layout covering over 20 Key Metrics for client loyalty rewards card program and developed customer sentiment analytics on QlikView dashboard.

Consulted with client to gather dashboard requirements, understand business processes, and data sources in order to develop the executive Loyalty Program dashboard. (QlikView)

Designed the client’s Loyalty Program executive dashboard using QlikView program and writing QlikView scripts to access the data sources in Oracle and modifying SSIS packages in SQL Server 2010 databases in order to develop customer sentiment analytics.

Contracting role - using broad skill sets in Business Intelligence:(Data modeling, QlikView, Oracle, SQL Server, SAP Business Objects, Best Practices Coaching) working with client executive BI users.

Consulted with client in numerous focus areas (Marketing, Operations, and Customer) to improve executive insight into marketing KPI’s on the Executive Loyalty Dashboard. (known as MAPCO Rewards)

Leader in improving customer experience and financial results through improved ability to identify marketing ROI.

Provided knowledge transfer and business intelligence training for this oil and gas company.

Cognilytics San Francisco, CA

Sr. Consultant, SAP HANA Jan 2012 to July 2012

Implemented SAP HANA – RDS Operational Reports for large building products client in Midwest.

Mentored client associates in Best Practices in Business Intelligence and developing SAP HANA databases, Business Objects Universes, WEBI/Crystal reports and Xcelsius dashboards.

Consulted with clients to gather report requirements, business processes, and data sources in order to develop SAP HANA data model for faster reporting.

Managed, designed and implemented SAP HANA and Business Objects 4.0 reports, explorer infospaces, and dashboards for clients.

Developed Functional SAP HANA Data Foundation and Report Requirements documentation for client deliverables.

Analyzed reports and user cases to develop data models and big data analytics for SAP HANA development.

Performed QA testing and developed master test plan and requirements traceability with test case coverage.

Developed SAP HANA Modeling Best Practices for Cognilytics consultants to practice with clients.

Architected models and developed analytic views and calculation views for SAP HANA client projects.

Strong understanding of SAP HANA In-Memory platform, installation, data migration and upgrades.

Developed ETL process scripts for SAP HANA from SAP BW and ECC data sources with Data Services.

Created big data analytics using SAP HANA.

Obtained USDA security clearance.

Prosequa Atlanta, GA

Architect Manager April 2011 to Jan 2012

Consulted with clients to develop Business Intelligence strategy, select BI tools, implement business intelligence tools and mentored client staff.

Managed and created 20 Microsoft SSRS reports and designed 5 (SSRS) dashboards for a new Business Intelligence offering for a healthcare software company.

Gathered requirements and developed new Open Source prototypes for client review, to improve corporate reporting efficiency using Pentaho, JasperSoft, and Tableau software.

Worked with Microsoft BI stack (SSRS, SSIS, SSAS, and PowerPivot for Excel) in a SQL Server 2008 environment in development of an Enterprise wide system design, structure and usage deliverable.

Trained in Composite virtualization software.

Prepared and presented proof of concepts (POC’s) from MicroStrategy, Pentaho, Tableau, QlikView and SAP Business Objects for client consideration in OEM’ing the Reporting and Dashboarding features into their software. Client eventually selected MicroStrategy as their OEM tool for BI dashboards and reports.

Client – Ingenious Med – “IM1” is currently one of the best-selling Physician Billing software tools.

Business Intelligence Agency Franklin, TN

President Jan. 2011 to March 2011

Consulted with clients to help develop Business Intelligence strategy, advanced analytics and Roadmap.

Attended training and passed certification in MicroStrategy Project Design (CPD), Report Design (CRD) and Document/Dashboard Design (CDD)

Demonstrated ability to create MicroStrategy Dashboards and Mobile BI Solutions that enabled an Enterprise Wide Mobile Business Intelligence solution for client.

Completed advanced training in the design of Mobile Business Intelligence Apps for iPad, iPhone and Blackberry devices. Certified in Microstrategy Mobile BI.

Gathered requirements and helped internally to develop new ETL process for client in order to improve corporate reporting efficiency.

Created master test plan and executed QA test scenarios, cases, conditions, and steps.

Worked with SQL Server 2008 and developed SSIS packages for data source use in MicroStrategy.

Centerstone Research Institute Nashville, TN

Manager of Analytics Dec. 2009 to Dec. 2010

Managed a team of statistical analysts, (Jasper) report writers, Oracle 10g database developers, and Qlikview creators.

Leader of Analytics team that won The Data Warehouse Institute (TDWI) 2010 Best Practices Award in Data Warehousing and Business Intelligence for a Non-Profit Group.

Gathered report requirements and documented metrics to produce behavioral health reports and dashboard visualizations delighting the business users and management stakeholders.

Mentored and trained staff in best practices for business intelligence requirements gathering, role and security setup, database design, and visualization development using Qlikview in-memory tool.

Prepared and demonstrated Qlikview capabilities and productive features to key stakeholders.

Developed quantitative predictive analytics of effects on FTEs per clinic when Medicare reductions occurred.

Successfully lead and completed (3 Year) CARF certification requirements by compiling clinical data sets and adhering to clinical standards resulting in the analytics team receiving an “Exemplary” rating.

Utilized SQL Server 2008 database and wrote SSIS packages for data source use in QlikView.

Computech Corp. San Francisco, CA

Business Intelligence Technical Lead Consultant Jun. 2009 to Nov. 2009

Prepared and demonstrated Business Objects XI r3 capabilities and productive features to key stakeholders in a large west coast Insurance company (STATE FUND).

Gathered report requirements and documented metrics to produce insurance company reports through web intelligence reporting in accordance with key stakeholders requirements.

Performed data modeling using Erwin modeling tool to define the star schema of Business Objects universe being developed to work with the 3NF Teradata model. (Client was Teradata).

Designed and presented Business Objects universe and web intelligence reports in early phase of project to help generate adoption of Business Intelligence POC roadmap

Mentored and trained client staff in best practices for business intelligence requirements gathering, role and security setup, web intelligence reporting and Xcelsius dashboard development.

Solutions Workforce Decatur, GA

Principal Consultant Apr. 2009 to Jun. 2009

As an onsite project management and development resource for various projects, is responsible for:

Creating Business Objects Universes that enable Business Intelligence for client companies.

Developing corporate-wide Business Intelligence Strategies and identifying Key Performance Indicators.

Performing data warehouse design modifications including aggregation and relational schema re-design, logical data modeling, physical data modeling, and fact table and dimension table design.

Creating data mapping documentation and designing logical data models for clients in early stage data warehouse projects using CA Erwin Modeler.

Created QA master test plan and developed test case scripts and tasks to improve data quality.

Building relationships with business users and deciphering user requirements into logical conformed dimensions and fact tables used in the design of a logical data model, practices Ralph Kimball Lifecycle Data Warehouse design methodology.

Mentoring and training client staff in best practices for business intelligence requirements gathering, modeling, reporting and dashboard development.

Leader in setting up Business Intelligence system using Oracle databases, Business Objects Edge XI 3.0 Universes, Webi Reporting, and Xcelsius 2008 dashboards.

Robert Half Management Consultants Nashville, TN

Senior Consultant Dec. 2008 to Mar. 2009

Consulted with client companies on financial analysis, database design, and productivity analysis and business intelligence strategy development.

Made recommendations for business processes, technology platforms and tools to assist in organizational change.

Developed (OBIEE) Oracle BI (Business Intelligence Enterprise Suite) reports for a healthcare client.

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 SSIS ETL packages to build and load the benchmark data from hospital client sources using SQL server 2005 as the backend.

Trained staff in query design, database modeling and reporting techniques of Access 2003 database.

Wrote SQL, MDX, and SSIS ETL routines to perform data quality control and exception checks on incoming data sources before being loaded to final database version.

Received training in SharePoint Server 2007 implementation.

Tria Staffing, LLC Brentwood, TN

Senior Consultant Apr. 2008 to Oct. 2008

Responsible for creating Business Objects queries to extract clinical data sets from HCA Business Objects warehouses for 65 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.

Project manager of the CHS corporate upgrade process from Business Objects 6.5 to XI 2.0 version.

Worked with McKesson Horizon Business Intelligence module to develop clinical decision support reports utilizing Business Objects XI.

Utilized Monarch DataPump to automate data loads and summary reports.

Provided data privacy, security, protection and encryption.

HCA (Hospital Corp. of America) Nashville, TN

Senior Consulting Engineer Nov. 2007 to Mar. 2008

Responsible for physical design modifications of enterprise data warehouse – Managed Care and DDS (Diagnosis Decision Support) Universe using Business Objects Designer 6.5.

Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

Conducted requirements gathering sessions with clinical stakeholders and revenue cycle analysts.

Developed web and desktop intelligence reports in Business Objects for clinical standards reporting.

Wrote Business Objects SQL and tested with Teradata (T-SQL) for quality control.

Created Informatica ETL scripts for transforming data into reliable database source feeds.



Contact this candidate