Summary
Overview
Work History
Education
Skills
Certification
Timeline
BusinessAnalyst

DILIP DASH

Delhi-Ncr

Summary

Solutions-driven business analyst with experience leading cross-functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals.

I am having total 5 years of experience in team management and overall 10+ years Hands-on-Experience with tools like Tableau, Power BI, Excel, Google Sheets, Power Point and Word. Focused and result oriented professional offering expertise in the field of Dashboard Design, Data Analytics and SQL. Possess deep knowledge of Dashboard Preparation with Tableau and data validation with SQL.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Assistant Manager

EXL Services
04.2022 - Current


  • Performed duties in accordance with applicable standards, policies and regulatory guidelines to promote safe working environment.
  • Worked on many projects for Revenue cycle management, financial healthcare and cash inventory model.
  • In the first project we have developed dashboards of the different areas where the businesses are spread and captured all the markets involving all the KPIs that are required
  • In this Project we have used Microsoft SQL Server for developing stored procedures, views, and modeling the data and for reporting Purpose to check Charges, Payments and bad debts for Patients.
  • Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Collaborated with stakeholders to define project scope, objectives, and deliverables
  • Collaborated with cross-functional teams to gather and document business requirements using Agile principles
  • Weekly scrum meeting held to discuss the progress for projects /queries Rebranding and Revamping of 20+ Tableau dashboards according to client specific i.e
  • Worked for big clients such as Affinity, Duly and Excela financials.
  • In the second project, we worked on Revenue Cycle Management Process of US Financials where we built dashboards In Tableau to track Charges, Payments, Adjustments, Refunds, Denials, and Appointments etc.
  • Developed various KPIs for our clients to get Actionable Insights from Dashboards
  • Automated excel reports using SSIS and Control -M process
  • Creation and deployment of 10+ dashboards to measure KPIs such as Denials, cash vs goal variance, Bad debts per Category, financial dashboards in Tableau.

Team Leader

BMTG Advisors
11.2019 - 04.2022
  • Over 5 years of experience in the areas of Core Banking, US Mortgage, US Healthcare
  • Strong experience with Scrum methodology
  • Excellent Understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design
  • Verified credit histories, personal references and employment backgrounds for each applicant.
  • Performed duties in accordance with applicable standards, policies and regulatory guidelines to promote safe working environment.
  • Creation/Modification of Business Entity in Tin man as per the Freddie Mae/Fannie Mae Guidelines.
  • Writing SQL queries to handle big data loads and modifying stored procedures
  • Perform data analysis and build reports based on the customer/stakeholder request
  • Handled a Team of 13 people.

Tableau Developer

TCS
06.2013 - 11.2019
  • Working for UK Commercial and IPB customers
  • Disburse the loan amount to the customer account VIA Mainframe/ALS window and booking the loan in system
  • Preparing Infosec Risk control self assessment (RCSA) tracker for all the teams so as to maintain the security and compliance
  • Worked on client dashboard for cash and sales.
  • Designed and deployed interactive reports with Drill Downs, drop down menu option, Parameters and Linked reports using Tableau
  • Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
  • Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters
  • Developed parameter-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.

Education

BBA - Business Management

Guru Govind Singh Indraprastha University
New Delhi
08.2011

Skills

  • Data Analysis
  • Ms-SQL, SSIS server
  • Tableau Desktop and Tableaue Preps
  • Power Bi, Power Automate,Power query
  • DAX Function
  • Ms-EXCEL

Certification

. Certificate in Tableau Desktop Specialist

. Certificate in Power BI Training (36+ hours) Edureka

. SQL Masterclass for Data Analytics

Timeline

Assistant Manager

EXL Services
04.2022 - Current

Team Leader

BMTG Advisors
11.2019 - 04.2022

Tableau Developer

TCS
06.2013 - 11.2019

BBA - Business Management

Guru Govind Singh Indraprastha University

Similar Profiles

CREATE PROFILE
DILIP DASH