Md. Shohel Rana Excel_SpreadSheet_PowerQuery_PowerBI_SQL_MIS
No reviews yet

MD. SHOHEL RANA
DATA ANALYST.
Joydebpur, Gazipur-1702

To:
Dear Hiring Authority,
As a dedicated and technically skilled data analyst. I am excited to express my interest in the Data Analyst position at your company. With a foundational background in computer science and engineering, practical experience in business intelligence tools. I am eager to contribute to your team and support your mission of transforming possibilities through data analytics.
In my recent role MIS Officer at international classic composite limited, I honed my skills in data analysis and visualization, focusing on creating impactful data insight.
Specifically, I have:
• Developed and maintained Microsoft excel, Power Query (ETL tool), PowerBI (ETL tool) and Tableau, google looker studio for dynamic dashboards, big data with structured query language (SQL), which played a key role in strategic decision-making.
• Automated complex data entry workflows, using Microsoft power query automate and Power Apps, increase in operational efficiency.
• Administered Microsoft Teams, google form, spreadsheet for project management, fostering improved communication and collaboration across departments.
• Engaged directly with stakeholders to understand and address their data reporting needs, ensuring the delivery of tailored data insights.
My academic background with a many more training in Data Science, has equipped me with a strong foundation in analytics, reinforcing my practical experiences. Moreover. I possess strong communication skills, both written and verbal, which are essential for collaborating effectively in a team and communicating technical concepts to non-technical stakeholders.
Joining at your company represents an exciting opportunity for me to apply my skills in a dynamic and mission -driven environment. I’m drawn to the challenge of working in such a fast-paced environment and I’m enthusiastic about contributing to the innovative solutions that the company delivers to its clients.
Enclosed is my resume, which provides further details about my professional journey. I am eager to discuss how my background, skills and enthusiasm make me a perfect fit for the Data Analyst role. Thank you for considering my application.
I look forward to the opportunity to discuss how I can contribute to the success of the company. Please contact me at your earliest convenience so that we may arrange an interview.

Sincerely,
Md. Shohel Rana.

Subjects

  • Excel for Finance Beginner-Expert

  • Excel jobs Beginner-Expert

  • Power Pivot, Power BI, Power Query Beginner-Expert

  • Excel for Analysis Beginner-Expert

  • Excel data cleaning and formatting Beginner-Expert

Experience

  • MIS Executive (Oct, 2022–Present) at International Classic Composite LTD.
    International Classic Composite LTD.
    Naojur, Kadda, Joydebpur Gazipur-1702
    MIS Executive
    October 2022 to 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.
  • Business Analyst (Dec, 2019–Sep, 2022) at Banglalink Digital Communications Ltd.
    Banglalink Digital Communications Ltd.
    Mirpur-02, Dhaka-1216
    Business Analyst
    December 2019 to September 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

  • Dashboard Reporting in Microsoft Excel (Tips & Tricks) (Jan, 2024–Jun, 2024) from Udemy
  • Computer Science and Engineering (Jun, 2023–now) from University of South Asia, Bangladesh
  • Master Microsoft PQ in Power BI & Excel (ETL Tool) (Jun, 2023–Dec, 2023) from Udemy
  • Diploma in Computer Science (Mar, 2013–Dec, 2017) from Bogura Polytechnic Institute, Bogura

Fee details

    ৳200–3,000/week (US$1.67–25.12/week)

    3 type of FEE package:

    1. Basic package is Free of Cost (Only first time for you)
    Basic Data Cleaning, Duplicate Removal, And Data Formatting For a Professional Look.

    2. Standard package is negotiate:
    Standard Data Cleaning, Duplicate Removal, And Data Formatting For a Professional Look.

    3. Premium package is negotiate:
    Messy Data Cleaning, Duplicate Removal, And Data Formatting For a Professional Look, Data insights And
    Interactive Dashboard.

Reviews

No reviews yet. Be the first one to review this tutor.