Deepak Bohara

About Deepak Bohara

Actively seeking Data Analyst/ Business Analyst opportunities | MS Office | SQL | Python…

Experience

1. Data Analyst

   Epsilon

   Nov 2021 — Present

   Establish both Agile and Waterfall methodologies, depending on the length and timelines of the projects • Implement and follow Agile development methodology within the cross-functional team and act as a liaison between the business user group and the technical team • Perform Data Analysis and Data profiling using complex SQL on sources systems, including SQL Server • Build and publish customized interactive reports and dashboards using Tableau • Execute SQL queries to access and analyze data from the relational database for data modeling and reporting • Develop business process models in Waterfall to document existing and future business processes • Create the Business metric KPI (Key Performance Indicator) to evaluate factors for different modules • Examined business requirements using R and develop ad-hoc reports as per customer’s request • Generate comprehensive analytical reports by running SQL queries against current databases to conduct data analysis • Monitor, Triage, Track, and resolve issues with the Excel Power BI reports • Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings, and profiling results • Write the SQL queries on data staging tables and Data Warehouse tables to validate the data results • Gained good soft skills like good communication, problem-solving skills, time management skills, and analytics skills

Education

• Excel Business College

  Bachelor of Business Administration - BBA, Finance, General

• Grand Canyon University

  Master of Science - MS, Business Analytics