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
CRN2017 – 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 Group2014 – 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 Technologies2013 – 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-Meritain2013 – 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 Fargo2012 – 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
Intel2011 – 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
ATS2010 – 2011
DW BI Manager, Design & Development
Mercer2009 – 2010
DW BI Manager, DBA, ETL Design & Development
First Advantage2008 – 2009
Sogeti
DW BI Manager, DBA, ETL Design & Development
Maricopa County2007 – 2008
DW BI Manager, Project Planning, DBA, ETL Design & Development
Constellation Brands2006 – 2007
Constellation Brands Enterprise Sales Data Warehouse
DW BI Manager, Project Planning, DBA, ETL Design & Development
TEK Systems2004 – 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 Systems2004 – 2004
ETL Architect, DBA, .Net
Cap Gemini Ernst & Young2000 – 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 Technology1994 – 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 Industries1989 – 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 Amravati1985 – 1989
BS