Summary
Overview
Work History
Education
Skills
Certification
Projects
Languages
Summary
Timeline
Generic

Abhijit Das

Bangalore

Summary

Achievement-driven professional targeting assignments in Data Analysis with an organization of repute in IT industry preferably located in Bangalore

A Data Analyst with 12+ years of experience in Reporting and Analytics SQL, Python, Pandas, NumPy, Power BI, DAX, Advanced Excel. Proficient in interdependent multivariate data analytical techniques with the capability to apply data mining techniques to business problems. A keen analyst with experience in data extraction, cleaning, transformation, mining, analysis and interpretation, Project report preparation and presentation. Skilled in developing and creating data layout like tables, charts, graphs, heat maps and process flow diagrams. Exposure in reviewing system capabilities, workflow and scheduling limitations to identify if requested programs are possible in current system. Data Analyst with the capability to deliver valuable insights through data cleansing & profiling and data-driven methods like data extraction, data pre-processing, data modification, validation, visualization, analysis, management and reporting. Expertise in analyzing problems and uncovering opportunities; exhibiting excellence in developing pipelines to analyze large datasets and extract data from diverse sources (relational databases & unstructured data). Talented Analyst with exceptional background in utilizing data from diverse information systems to build tools and forecasting models that remarkably improve organizational decision-making capabilities. Proactively surface attractive investment ideas internally and externally to support all products and clients.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Data Executive

Alliance University
09.2021 - 07.2022
  • To maintain students, record and maintaining proper data as on required by the Registrar.
  • To fetch data from the University internal database and create a weekly report based on it.
  • Used SQL DBA to fetch data and write SQL Queries.
  • Make reports on Power BI

Data Associate

Brickwork Ratings India Pvt Ltd
02.2019 - 07.2021
  • Successfully interpreting data in order to draw conclusions for Managerial Actions and Strategy.
  • Working with Pandas for data cleaning, data preprocessing, feature engineering, feature selections.
  • Working to Power BI using DAX Expressions and applying them in the Visualization Report.
  • Carrying out analysis of the given data and drawing correct inferences in line with the objectives of the analysis; examining for solutions using data analysis practices and preparing analysis reports.
  • Gathering data necessary to accomplish analysis from a number of sources, accumulating it together in prearranged format and entering the data in various data analysis software.
  • Made Report using Power BI for Data Visualization.
  • Presenting data and conclusions to team in order to improve strategies.
  • Merging Data for both Long Term and Short -Term Loan which is required for SEBI and RBI auditing purposes.
  • Maintaining Data of BLR, MSME and NCD for subsequent Analysis by Senior Data Analyst.
  • Worked with SQL DBA to fetch data from internal data source and write SQL Queries.

Reporting Analyst

Rainbow propriety Pvt Ltd
01.2016 - 12.2019
  • Transformed Data into Information which helps in taking the Right Business Decision.
  • Developed and Maintained Databases and Filtering Data.
  • Contributed to Effective Work Flow through Effective Teamwork.
  • Maintained Files and Data Records Consistent with Compliance Guidelines.
  • Worked with SQL DBA to fetch data from internal data source and write SQL Queries.

Accountant

Podder and Podder Pvt Ltd
07.2010 - 12.2015
  • Managed preparation of weekly, monthly and quarterly service performance report.
  • Performed basic and ad-hoc analysis to support business decisions.
  • Led trending and forecasting to estimate the future demands in line with business Initiatives.
  • Updated data visualization dashboards of business key performance indicators.
  • Coordinated with various teams to gather data for MIS reports.
  • Conducted analysis on regular intervals for respective process with graphical representation.
  • Devised MIS/Reports by using Advanced Excel and Access at operational level.

Education

Bachelor of Science - Computational Science

RBANMS First Grade College
Bangalore
07-2010

12th -

G.C College (A.S.H.E.C)
Silchar, Assam

10th -

Collegiate School (S.E.B.A)
Silchar, Assam

Skills

  • Data Analysis
  • Data Management
  • Data Interpretation
  • Data Manipulation
  • Data Mining
  • Data Processing
  • Data Collection
  • Reporting & Documentation
  • Data Modelling
  • Python
  • Pandas
  • NumPy
  • Data Science
  • Statistics
  • Machine Learning Algorithms
  • Deep Learning Algorithms
  • CNN
  • ANN
  • LSTM
  • SQL Queries
  • CTE
  • Subquery
  • Views
  • Stored Procedures
  • ETL
  • DAX Expressions
  • Flask
  • HTML
  • CSS
  • Fast Api
  • Rest Api
  • Pydantic
  • Streamlit
  • Docker
  • Data Visualization
  • Matplotlib
  • Seaborn
  • Advanced Excel
  • Power BI

Certification

Did a Certification in Data Science

Projects

Bank Credit Rating projects based on Bank Loan, MSME and NCD for Brickwork Ratings India Pvt Ltd. Did Data Cleaning and made a Visualization Report for State Bank of India. Automated Data using ML Algorithms.

Languages

  • English
  • Hindi
  • Bengali

Summary

Achievement-driven professional targeting assignments in Data Analysis with an organization of repute in IT industry preferably located in Bangalore. A Data Analyst with 12+ years of experience in Reporting and Analytics SQL, Python, Pandas, NumPy, Power BI, DAX, Advanced Excel. Proficient in interdependent multivariate data analytical techniques with the capability to apply data mining techniques to business problems. A keen analyst with experience in data extraction, cleaning, transformation, mining, analysis and interpretation, Project report preparation and presentation. Skilled in developing and creating data layout like tables, charts, graphs, heat maps and process flow diagrams. Exposure in reviewing system capabilities, workflow and scheduling limitations to identify if requested programs are possible in current system. Data Analyst with the capability to deliver valuable insights through data cleansing & profiling and data-driven methods like data extraction, data pre-processing, data modification, validation, visualization, analysis, management and reporting. Expertise in analyzing problems and uncovering opportunities; exhibiting excellence in developing pipelines to analyze large datasets and extract data from diverse sources (relational databases & unstructured data). Talented Analyst with exceptional background in utilizing data from diverse information systems to build tools and forecasting models that remarkably improve organizational decision-making capabilities. Proactively surface attractive investment ideas internally and externally to support all products and clients., Data Analysis, Data Management, Data Interpretation, Data Manipulation, Data Mining, Data Processing, Data Collection, Reporting & Documentation, Data Modelling

Timeline

Data Executive

Alliance University
09.2021 - 07.2022

Data Associate

Brickwork Ratings India Pvt Ltd
02.2019 - 07.2021

Reporting Analyst

Rainbow propriety Pvt Ltd
01.2016 - 12.2019

Accountant

Podder and Podder Pvt Ltd
07.2010 - 12.2015

Bachelor of Science - Computational Science

RBANMS First Grade College

12th -

G.C College (A.S.H.E.C)

10th -

Collegiate School (S.E.B.A)
Abhijit Das