Eric Axelrod

Current

Senior Data Migration Consultant at Novus International
Consultant at Daugherty Business Solutions

Past

Senior BI Consultant at Centene Corporation
BI Consultant at Energizer
Senior BI Consultant at Cash Management Solutions

Senior Data Analyst, DBA, Data Architect, Applications Developer at Global Pharmaceutical Solutions
Data Analyst at MedScript PBM
Pharmacy Account Rep (Data Analyst) at Coventry Health Care (GHP)
Drug Information Associate at Wolters Kluwer Health (Facts and Comparisons)

see less...

4 more...

Recommended

1 person has recommended Eric

Connections

500+ connections

Industry

Information Technology and Services

Websites

Eric Axelrod’s Summary

Data management is a concept which, even in our high-tech modern world, continues to elude organizations large and small, private and public. While many organizations do an adequate job generating data, they struggle to turn it into information which can be used to make decisions.

Business Intelligence market leaders such as Microsoft, SAP Business Objects, IBM, and Oracle sell products which allow organizations of all sizes to manage data and distribute information. The uniqueness of Business Intelligence concepts creates the need for specialists.

Business Intelligence is my specialty.

I have worked on BI projects for companies large and small. My experience spans many different industries, the majority of which has been in the healthcare sector.

Experience:
* Steering committee member for the Global Business Objects Network (GBN) Data Management Special Interest Group
* Designing SAP Business Objects Enterprise architecture
* Performing an SAP to Business Objects 3.x integration
* Implementing several Business Objects Enterprise deployments.
* Implementing Enterprise-wide BI platforms
* Administering multi-terabyte databases

I am an open networker, always looking to expand my network with professionals and industry leaders. Don't hesitate to send me an invite at axelrod_eric@yahoo.com.

Skype ID: axelrod.eric

Eric Axelrod’s Specialties:

Business Intelligence, MDM, Data Architecture, Dimensional Modeling, Data Integration, ETL, OLAP/ROLAP/MOLAP, Pharmacy Benefits, Medicare Part D

SAP Business Objects:
BOE, Data Services, Data Integrator, Web Intelligence, Crystal Reports, Xcelsius

RDBMS:
Microsoft SQL Server, MySQL Enterprise, Oracle

Other BI:
Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS), Informatica, ModelRight, Talend Open Studio, Pentaho Data Integration (Kettle)

Eric Axelrod’s Experience

Senior Data Migration Consultant

Novus International

(Privately Held; Food Production industry)

February 2009 — Present (10 months)

• ETL Architect, Data Migration
Designed ETL environment for Enterprise Data Migration including ETL design patterns, Metadata management, Data Staging, Flow Control, Logging, and ETL best practices.

• ETL Developer, Data Migration
Designed hundreds ETL processes for Enterprise Data Migration utilizing ETL design patterns, Metadata management, Data Staging, Flog Control, Logging, and ETL best practices.

• Data Quality Engineer
Developed methods and ETL processes for identifying and remediating Data Quality issues in many critical conversions.

• Reverse Engineering ERP and CRM systems
Reversed engineered Legacy ERP and CRM data models for the purpose of migrating legacy data.

• Business Analyst
Worked with business users to gather and refine requirements, remediate data load errors, analyze data, and help move the project forward.
Consultant

Daugherty Business Solutions

(Privately Held; Information Technology and Services industry)

2008 — Present (1 year )

Daugherty Business Solutions is a premier IT consulting company with a 23 year history of providing leading-edge technology solutions to large and mid-sized corporations from a broad spectrum of industries.

I am the SAP Business Objects practice leader and a member of the Business Intelligence (BI) line of service specializing in Management Consulting, BI Deployments, Master Data Management (MDM), Data Architecture, Data Integration, ETL development, and Project Management.
Senior BI Consultant

Centene Corporation

(Public Company; CNC; Hospital & Health Care industry)

December 2008 — January 2009 (2 months)

• Business Analyst
Worked with business users to gather and refine requirements, analyze data, assist with determining project scope, and help move the projects forward.

• BI Architect
Worked with other BI Architects to support and enhance existing BI Architecture, develop BI solutions around existing Data Models.

• Business Objects Administrator
Worked with other Business Objects Administrators to manage restrictions on user group and accounts, implemented systematic methods to control access to protected content.

• Report Developer
Developed reporting solutions using Business Objects WebIntelligence XIR2 and XI 3.1, worked with business users to gather and refine requirements.

• ETL Tester
Performed unit testing on Informatica ETL processes, worked with business users to refine requirements.
BI Consultant

Energizer

(Public Company; Consumer Goods industry)

August 2008 — November 2008 (4 months)

• Business Analyst
Worked with business users to gather requirements, analyze data, and assist with determining the project scope and writing the project plan.

• Data Architect
Modeled a multi-star datawarehouse in the 2nd/3rd Normal Form, involving approximately 50 tables.

• ETL\ELT Developer
Designed ETL processes to populate the newly designed Data Mart using Microsoft SQL Server Integration Services. The ETL processes involved sources such as database tables, views, and xls/xlsx files.

• OLAP Cube Developer
Developed a new OLAP cube using Microsoft SQL Server Analysis Services, including facts, dimensions, measures, and perspectives.
Senior BI Consultant

Cash Management Solutions

(Information Services industry)

June 2008 — August 2008 (3 months)

Cash Management Solutions is a mid-sized firm which provides best-of-breed Accounts Receivable services to US Professional Service Firms.

Roles:

Directing the implementation of the Business Objects XIR2 product suite and Microsoft SQL Server 2005. This includes the installation and configuration of several BI/DW software applications.

Consulting on the design of the data structure for CMSs data reporting platform.

Administer the multi-Terabyte SQL Server 2005 Datawarehouse which supports CMSs reporting platform. This includes managing datawarehouse performance, query optimization, data integrity, etc.

Design and test multiple BOXI Universes which are deployed to the BOXI platform. This includes designing universe layouts, table relationships, aggregate awareness, cascading dimensions, etc., and verifying the integrity of data extracted through the universes.

Design and test Crystal XI and WebIntelligence XI reports which are deployed to the BOXI platform.
Senior Data Analyst, DBA, Data Architect, Applications Developer

Global Pharmaceutical Solutions

(Pharmaceuticals industry)

August 2007 — June 2008 (11 months)

Global Pharmaceutical Solutions provides innovative pharmacy benefits administrative and consulting services to some of the largest employers, managed care organizations, and pharmacy benefit managers in the United States.

I serve in several crucial, tightly integrated roles at GPS.

Senior Data Analyst
As the Senior Data Analyst I manage pharmacy analytics projects, Business Intelligence (BI) projects, and Rx claim audits for GPS.

ETL & Applications Developer
As the ETL & Applications Developer I develop BI tools, ETL processes, and applications to support products which are being taken to market.

Data Architect
As the Data Architect I design the data structure for several of GPSs state-of-the-art applications and BI tools. As we develop enhancements and updates to our product suite I control the regular changes must be made to the underlying data structure.

Database Administrator
I manage the Enterpries Datawarehouse which supports GPSs core operations.
Data Analyst

MedScript PBM

(Non-Profit; 10,001 or more employees; Hospital & Health Care industry)

February 2004 — August 2007 (3 years 7 months)

Developed executive/marketing strategies for the company.

Designed pricing strategies for approximately 18 proposals and over 150,000 members.

Conducted repricing analyses for new client proposals and up-sells.

Designed and analyzed reports and presented them to clients.

Implemented new data reporting software for data warehouse conversion.

Assisted in the conversion of all PBM functions for the entire book of business.

Conducted a complete Proposal redesign.

Directed a complete redesign of all marketing materials.

Sold clinical programs to clients.

Developed and implemented customized PBM programs.

Provided support for the maintenance of all programs including, but not limited to, MedScript MAC and MedScript Specialty Pharmacy.

Consulted on design of new Web Site, Web Portals, and IVR.

Performed all systems administration functions related to data reporting, third-party maintenance, accounts receivable, and third-party billing.
Pharmacy Account Rep (Data Analyst)

Coventry Health Care (GHP)

(Public Company; 10,001 or more employees; CVH; Insurance industry)

February 2003 — December 2003 (11 months)

Instrumental in controlling pharmacy expenditures by identifying cost-drivers and recommending changes in plan design.

Designed reports using MicroStrategy RxNavigator to produce useful financial and clinical data.

Identified the elements which drive overall expenditures.

Calculated financial and clinical impact of changes to plan design.

Presented data, conclusions, and strategies to the Pharmacy and Therapeutics committee.

Provided support for the maintenance of the Pharmacy Drug File, MAC lists, and Specialty Drug lists.

Instrumental in the redesign of the prior authorization processes.

Troubleshoot adjudication issues in collaboration with Caremark Account Managers.

Logged, tracked, and maintained prior authorizations.
Drug Information Associate

Wolters Kluwer Health (Facts and Comparisons)

(Public Company; 10,001 or more employees; Publishing industry)

February 2002 — February 2003 (1 year 1 month)

Developed numerous databases to improve processes and streamline work flow.

Coordinated quarterly updates for numerous clinical publications.

Provided insight to improve existing products and wrote proposals for new products.

Established working relationships with previously uncooperative organizations.

Facilitated the exchange of information between Facts & Comparisons,
Medispan, Pharmaceutical manufacturers, and distributors for clinical and financial information.

Tracked new products and new trends in the marketplace as they occurred and utilized them to our advantage.

Maintained clinical data files.