Sign in

Business Intelligence Consultant (Developer & Analyst) with 4 yrs exp.

St. Louis, Missouri, 63101, United States
January 27, 2017

Contact this candidate Nikhil Dusane +1-573-***-****


Business Intelligence (BI) & Analytics Consultant with around 4 years of experience in implementing large scale end-to-end BI, data-warehouse & Extract-Transform & Load (ETL) projects for leading healthcare & manufacturing clients. Proven track-record of improving clients’ business processes by enabling descriptive & predictive analytics leveraging Microsoft (SSRS, SSIS, SSAS), IBM, & SAP BI products. Proficient in writing complex PL/T-SQL queries, stored procedures, R, C#.NET, & Java codes. Experienced in executing all the SDLC phases & leading teams in an agile environment. Excellent techno-functional & analytical skills & strong aptitude for learning new technologies.


Missouri S&T – LITE Lab Missouri

Data Analyst, Student Assistant August 2015 – December 2016

Researched & applied data mining & statistical algorithms like t-test & clustering in R & MATLAB to analyze 10 Gigabytes of EEG time-series dataset under the strong mentorship of Dr. Fiona Fui-Hoon Nah Missouri S&T Missouri

Graduate Student, Academic Projects August 2015 – December 2016

Gained extensive experience in data modeling using SAP HANA while implementing an analytics project for a Florida based media company; Designed 4 executive performance dashboards leveraging SAP Design Studio

Analyzed 30,000 Amazon products’ customer reviews (unstructured data) using SAS Enterprise Miner – Text analysis, to discover seasonal trends & analyze customer satisfaction toward Amazon services & their products; Applied & studied Decision Trees, Linear Regression, & Principal Components Analysis analytical techniques

Teradata Data Challenge – 2016: Contributed to team’s success in analyzing and recommending hiring strategies to Hire Heroes, USA by analyzing their Salesforce CRM dataset using Tableau, R, and SAP Predictive Analytics; Applied chi-square test, clustering, & decision tree algorithms to predict their hiring trend in the future; Tableau Public profile: Larsen & Toubro InfoTech Ltd. India

Software Engineer (Business Intelligence) January 2015 – June 2015

Reduced BI reports’ execution time by 60% by conducting gap analysis & implementing an independent modular reporting framework for a France-based water services conglomerate

Contributed to team’s success in migrating & modifying 50 reports; Designed test cases & tested 15 dashboards to ensure data consistency & successful migration of functionalities

Developed 7 intuitive dashboards in Tableau that leveraged financial data to deliver actionable insights impacting the daily business decisions

KPIT Technologies Ltd. India

BI Consultant (Analyst & Engineer) October 2013 – January 2015

In a cross-functional environment consulted 5 business users from finance, manufacturing, & marketing domain to identify KPIs

& developed strategic dashboards & scorecards giving near real-time Business Performance Measurement

Designed an ETL framework in Microsoft SSIS, to fetch millions of records from SAP BW & MS SQL transaction servers & load into Data warehouse on nightly basis

Implemented an efficient architecture to transfer data from Microsoft SQL Server data warehouse to 15 SSAS OLAP cubes enabling multi-dimensional data analysis

Datamatics Global Services Ltd. India

Associate BI Consultant (Team Lead) December 2011 – October 2013

Recipient of Merit Award 2013 – Awarded for excellent project execution & exceeding client expectations in deliverables

Identified as a team leader amongst a team of 7 BI Engineers, to execute project “AHC”, an end-to-end SSRS implementation project for a US healthcare client; Strategized the entire SDLC & guided team members accordingly

Acquired expertise in Cognos BI suite & Oracle PL/SQL within a span of 3 months & gained excellent hands-on experience on Informatica PowerCenter & Tableau 7.0

Trained 20 power users to develop ad-hoc reports allowing them to make easy & effective business presentations saving approx. 50% of their time


M.S. in Information Science & Technology (Specialization: Business Analytics & Data Science) GPA 3.7/4.0 Missouri University of Science & Technology December 2016 Bachelor of Engineering in Computer Engineering

University of Pune, India May 2011


Business Intelligence & Analytics: Tableau 10.0 SAP BI MS SSRS SAP Predictive Analytics SAS Enterprise Miner SAS Visual Analytics IBM Cognos BI MS SSAS Power BI Rapid Miner Data Warehousing & ETL: MS SSIS Informatica v.9.0 SAP BW Data Services Databases: MS SQL Server Oracle SAP BW SAP HANA IBM DB2 MySQL Programming Languages: R Python C# Java Android JavaScript JSON & XML ERP: SAP ERP 6.0 (FI, CO, MM, SD, PP, HR)

Contact this candidate