AK

Ashish Kale

Director Business Intelligence & Analytics · CRN


In My Own Words

• Data-driven BI Director in the Crisis Response Network Business Intelligence Data warehousing Practice.
• Over 15 years of experience in Business Intelligence, 22 years of experience in information systems of which he has more than 12 years of agile project management, team leadership and experience in executing a data analytics strategy.
• Managed all aspects of BI projects & teams through developing, design and evaluating plans in Insurance, Finance, Health care, Manufacturing and Sales industries.
• Has proven ability to build relationships using formal and informal networks and effective communication with the ability to adapt within the organization

Work Experience

Director Business Intelligence & Analytics

CRN

2017 – Present

• Partnering with C-level executives to enable visibility into the EHR (Electronic Health Record) related metrics • Generated new insights by providing executive scorecards, business KPI detail reporting across CRN business owners and senior executives. • Directing and developing a Business Intelligence & Analytics strategy to lead major technical transformation project and provide data driven analytics around CRN • Managed team members, project plans, scope, resources, change requests, risks and issues • Evolve and introduce new data management standards and best practices • Spearheading an initiative to migrate all legacy and current EHR data to a full cloud based big data environment • This system was developed using SQL Server 2017, SSIS, OLAP, MDX, SSAS, SSRS, Tableau, Azure Cloud data warehouse, Python

BI Project Manager, Design & Development

Innovation Group

2014 – 2017

• Managed team members, project plans, scope, resources, change requests, risks and issues • Provide data driven analytics to increase the effectiveness of executive KPI deck by incorporating graphic representation of data and trends. • Managed dimension modeling sessions, created the complete BI roadmap for Auto Insurance Claims • Worked in partnership with key stakeholders and senior management to verify and sort reports based on importance and time consumed, as well as to eliminate unnecessary reports. • Evolve and introduce new data management standards and best practices • Develop and improve processes that monitor data feed which will help in detecting, repairing and preventing duplicates and inconsistencies • Scheduled vendor reviews during reporting and ETL tool selection process • This system was developed using SQL Server 2014, SSIS, Informatica, OLAP, MDX, SSAS, SSRS, Visio, Power BI, Tableau, Hadoop, Azure Cloud data warehouse

BI Datawarehouse Project Manager, Design & Development

Greenway Medical Technologies

2013 – 2014

• Collaborated with the senior leaders to measure key KPIs. • Architected the data warehouse with concepts of star schemas. Significantly reduced the software cost and development time through the implementation of custom ETL processes. • Conducted thorough review and coordinated with the designated team to identify issues and areas for improvement. • Managed project plans, scope, resources, change requests, risks and issues • Ability to effectively communicate technical aspects to employees who possess less technical knowledge • This system was developed using SQL Server 2012, SQL Server 2008 R2, SSIS, OLAP, MDX, SSAS, SSRS, Visio, Performance Point and SharePoint 2010

DW BI Lead, Design & Development

Aetna-Meritain

2013 – 2013

• Established monthly business targets and monitor trending performance, implementing remedial plans wherever adverse variances exist • Compile project status reports, develop project plans, define process flows, coordinate project schedules • Worked with vendors to obtain information needed to build organization hierarchies • This system was developed using Oracle 10g, SQL Server 2012, SQL Server 2008 R2, SSIS, OLAP, MDX, SSAS, SSRS, Visio, Performance Point and SharePoint 2010

DW BI Lead, Design & Development

Wells Fargo

2012 – 2012

• Managed business intelligence project, created the complete BI roadmap • Developed multiple reporting cubes that are consumed via Dashboards • Supervised and participated in the physical design of the data warehouse • This system was developed using Oracle 10g, SQL Server 2012, SQL Server 2008 R2, SSIS, Tabular Model Cube, OLAP, MDX, SSAS, SSRS, Visio, Performance Point and SharePoint 2010

DW BI Manager, Design & Development

Intel

2011 – 2012

• Responsible for managing a team of 8 + resources locally & remotely. • Responsible for the complete lifecycle of the data warehouse star schema design & development process, coordinate with a team of developers, analysts & vendors. • Responsible for managing customer expectations including scope, schedule, changes, and problem resolution • Responsible for creating dashboards, scorecards in Microsoft Performance Point • Responsible for the design & development of the ETL framework for loading, profiling & cleansing data. • Responsible for the data mapping documents. • Responsible for designing and building cubes and MDX queries • This system was developed using Oracle 10g, SQL Server 2005, SQL Server 2008 R2, SSIS, OLAP, MDX, SSAS, SSRS, Visio, Performance Point and SharePoint 2010

DW BI Manager, Design & Development

ATS

2010 – 2011

DW BI Manager, Design & Development

Mercer

2009 – 2010

DW BI Manager, DBA, ETL Design & Development

First Advantage

2008 – 2009

Sogeti

DW BI Manager, DBA, ETL Design & Development

Maricopa County

2007 – 2008

DW BI Manager, Project Planning, DBA, ETL Design & Development

Constellation Brands

2006 – 2007

Constellation Brands Enterprise Sales Data Warehouse

DW BI Manager, Project Planning, DBA, ETL Design & Development

TEK Systems

2004 – 2006

Strong Memorial Hospital DW BI Architect, Project Planning, DBA, ETL Design & Development, SeeBeyond EAI

DW BI Manager, Project Planning, DBA, ETL Design & Development

LPA Systems

2004 – 2004

ETL Architect, DBA, .Net

Cap Gemini Ernst & Young

2000 – 2004

GMAC Team Lead, SeeBeyond EAI, Oracle 8i PL/SQL Design & Development

Ascension Health DW & BI Manager, Project Planning, DBA, SeeBeyond EAI

Valero Energy DBA

ETRM - Energy trading risk management DBA, Database Design & Development

Intergen North America DBA

Continental Airlines Programmer Analyst

Clear Channel Communications DBA, Database Design & Development, ASP

TrueQuote.com DBA, Database Design & Development

Programmer Analyst

RCG Information Technology

1994 – 2000

GUB Reporting System (Global User Billing) • The application was developed using ASP, IIS 5.0, VBScript, JavaScript and Oracle 8 PL/SQL.

EQUIVA SERVICES Magellan Voyage Project • This application was developed using SAP R3 ABAP

EXXON RESEARCH & ENGINEERING, Baytown, TX Rims2000 DBA • This application was developed using Visual Interdev, ASP, VBScript, JavaScript, DHTML and MS SQL Server v 6.5.

EXXON CHEMICALS USA, Houston, TX DBA • This application was developed using Visual Basic 5.0, SQL Server 6.5 and Erwin.

MCNEIL CONSUMER PRODUCTS BME v.1.0 • This application was developed using PowerBuilder & Sybase

HOST (Hotel Open System Technology)

SilverLine Industries

1989 – 1994

This application was developed using Oracle Forms 3.0 and Oracle v 6.0 stored procedures.

Training/Instruction • Facilitated Session Leader Training. • Communicating for success. • Data Warehouse - Design & Implementation Techniques.

Education

BS

University Of Amravati

1985 – 1989

BS