Summary
Overview
Work History
Education
Skills
Timeline
Generic

Khuteja Abdul

West Bloomfield,MI

Summary

Results-driven Business Analytics Engineer with over 10 years of experience in Database development, Data modeling, Data mining, and Business intelligence. Seeking to leverage expertise in SQL, Data Warehousing, Data Analytics and BI tools to drive data-driven decision-making and innovation.

Overview

13
13
years of professional experience

Work History

Business Intelligence Analyst

Great Expressions Dental Centers
03.2020 - Current

Currently, working in the role of a Business Intelligence Analyst developing valuable insights into the company's KPIs, and building reports and visualizations supporting the results for the business stakeholders.

Responsibilities include and not limited to:

  • Data Mining to understand project requirements in a multi-server and multi-application environment.
  • Recently worked on a project to discover deficiencies in Ortho referrals increasing revenue significantly,
  • Working with the Marketing and AR teams to address data and reporting requirements.
  • Develop Adhoc and SSRS reports per demand and maintain them in a multi-server environment.
  • Develop PowerBI scorecards using SQL, Azure Data Factory, and Databricks backend.
  • Resolving support requests maintained under a GitHub ticketing system and a GitHub repo.
  • Address Reporting enhancements and Documentation.

Data Warehouse and Report Developer

Cardinal Health Inc
11.2014 - 01.2020

Worked as SME in the role of a Data warehouse and Report Developer supporting the Pharmaceutical company's BI and Reporting needs. Responsibilities include and not limited to:

  • Creating SQL databases, schema, tables, and ETL jobs
  • Writing SQL stored procedures, functions, and triggers to support existing ETL processes
  • Building and maintaining Data marts using star and/or snowflake schema design for BI and reporting purposes
  • Creating and publishing Tableau dashboards for business users by project/request.
  • Deploying php scripts to derive data from the FACTS legacy system.
  • Built data cubes, data marts, and queries, maintaining every aspect of storage and translation.
  • Troubleshooting PHP scripts, SQL procedures, and functions to resolve support-related issues.
  • Creating and managing SSRS reports, SSIS packages, and SSAS cubes.
  • Continuous SQL Tuning and query performance optimization.
  • Writing SQL procedures to pull data from third-party Oracle databases into SQL server via linked server
  • Participating in Code review for the web team using GitHub/Stash/Bit-bucket.
  • Over 4 years of Agile experience.

Application Support Analyst

IDashboards Inc.
12.2010 - 11.2014

Worked as an Application Support Engineer for iDashboards Inc. providing expert technical support for its customers and prospects. Responsibilities included:

  • Remotely install Java, Apache Tomcat, and the iDashboards software on customer machines
  • Technically supported iDashboard's Java/J2EE application software on customer machines
  • Resolved any application and/or web server-related issues by referring to customer log files
  • Answering support calls and emails from customers/prospects and assisting in troubleshooting issues over GoToMeeting/GoToAssist.
  • Resolve any application and/or web server-related issues by to customer log files analysis.
  • Assisting training consultants with technical issues they faced while on-site.
  • Testing upcoming versions of the software and documentation.
  • Worked on a project to enable connectivity of iDashboards with MS Analysis Services Cubes, Social media platforms, SalesForce, etc

Education

Master of Science - Data Sciences

Walsh College of Accountancy And Business Administration
Troy, MI
06.2024

Bachelors in Finance, Accounting - Statistics, And Economics

Bangalore University
Jyothi Nivas College
05.1999

Skills

  • Data Modeling and Data Visualization
  • SSRS and SSIS experience
  • SSIS with ZappySis for B2B solutions
  • WebAPI integration for ETLs
  • Business Intelligence and Data Analysis
  • Python, R for Data analysis
  • Cloudera (Hadoop), MapReduce, Hive, Pig
  • PowerBI, Tableau, and Alteryx experience
  • SQL, PL/SQL, TSQL
  • GitHub and TFS for code repository
  • JIRA, Zendesk and GitHub for ticketing
  • Agile Experience

Timeline

Business Intelligence Analyst

Great Expressions Dental Centers
03.2020 - Current

Data Warehouse and Report Developer

Cardinal Health Inc
11.2014 - 01.2020

Application Support Analyst

IDashboards Inc.
12.2010 - 11.2014

Master of Science - Data Sciences

Walsh College of Accountancy And Business Administration

Bachelors in Finance, Accounting - Statistics, And Economics

Bangalore University
Khuteja Abdul