Md. Shohel Rana profile picture

Md. Shohel Rana

Full time

Data Analyst, Business Analyst, MIS

About Md. Shohel

Hey! This is Shohel Rana a Business Analysts & Management Information Systems (MIS) Officer is a professional who plays a critical role in managing and maintaining the information systems within an organization. The primary focus of an MIS Officer is to ensure that the organization's information technology (IT) infrastructure and systems support the business's operational and strategic needs. Here are some key responsibilities and tasks typically associated with the role of a Management Information Systems Officer.

• Analytical Thinking: Business Analysts need to be excellent analytical thinkers. They must be able to analyze complex data, identify patterns, and draw meaningful insights to make informed business decisions.


• Problem-Solving: Business Analysts are problem solvers. They encounter various challenges related to business processes, technology, and requirements. Being able to identify problems and devise effective solutions is critical.


• Communication Skills: Strong communication skills are vital for a Business Analyst. They must be able to communicate effectively with business users, project managers, developers, and other team members. This includes both verbal and written communication.


• Data Modeling and Analysis: Business Analysts often work with data to uncover insights and trends that can support decision-making. Familiarity with data modeling, data analysis, and data visualization tools is beneficial.


• Technical Knowledge: While Business Analysts are not developers, having a basic understanding of IT concepts, software development methodologies, and database structures can facilitate effective communication with technical teams.


• Data Visualization: Data visualization makes it easier to understand large and complex data sets by presenting information visualize. When data is presented visually, decision-makers can quickly grasp the insights and implications, leading to more informed and timely decisions.


• Time Management: Successful Business Analysts must manage their time efficiently to meet project deadlines and prioritize tasks effectively.

Video Resume

Work Experience

1

MIS Officer

International Classic Composite Limited
Oct, 2022 - Present

Key Responsibilities

  • Managing large datasets dynamic and automation with

formula-functions: IF, SUM, SUMIFS, COUNT, COUNTA,

COUNTIFS, MAX, MAXIFS, MIN, MINIFS, VLOOKUP,

INDEX-MATCH, HLOOKUP, XLOOKUP etc.

  • Million datasets with google sheets, power BI & SQL.
  • Data collection, cleaning, manage and maintain

spreadsheets using MS Excel, including creating reports,

analyzing data, and utilizing advanced Excel functions

and needed many more ETL tools.

  • Assist in managing office records, including inventory,

audit, accounts and financial reports management to

ensure smooth workflow and efficient office operations.

  • Creating dynamic and automation reports with
  • PivotTables. Visualization dynamic charts dashboard.
  • Provide technical IT support to the office staff for

computer-related issues, ERP, printer, scanner &

networking issues.

  • Perform other duties as assigned.
2

Business Analyst

Banglalink
Dec, 2021 - Sep, 2022

Key Responsibilities 

  • Monitoring & analyzing competitive activity, customer

and market trends.

  • Monitoring and evaluating sales performance.
  • Use previous sales data & market trends to develop sales

target and projections.

  • Collect, clean & analyze sales data from various of

sources such as CRM systems, ERP systems, DMS

systems, spreadsheets and many more.

  • Develop & maintain sales performance MIS reports and

dashboard to track progress & projections data

visualization to the management.

Education

1

Diploma in Computer Science and Engineering (CSE)

University of South Asia
May, 2022 - Present
CGPA: 3.3 out of 4
2

Diploma in Computer Technology

Bogura Polytechnic Institute
March, 2013 - December, 2017
CGPA: 3.19 out of 4
Passing Year: 2018

Professional Certificates & Training

Earn More Certificates

Dashboard Reporting in Microsoft Excel (Tips & Tricks)

Udemy

 Dashboard Reporting in Microsoft Excel (Tips & Tricks) 

February, 2023 - July, 2023