Accounts to Data Analytics transition

Finance experience, now focused on data analytics.

I am Ratnesh Kumar Pal, an accounts and finance professional transitioning into Data Analytics. My 7+ years in accounting, receivables, reconciliation, and reporting give me a strong business foundation, while SQL, Python, Power BI, and Excel help me convert financial data into clear insights.

Contact Me View GitHub Resume
Career transition

I bring accounting accuracy into modern analytics workflows.

I am not starting from zero. I already understand ledgers, invoices, receivables, month-end close, and reporting pressure. Now I am applying data tools to solve those problems faster and more clearly.

Accounts foundation

I know the business meaning behind the numbers.

My background covers reconciliations, receivables, invoice tracking, month-end reports, and financial controls. That helps me ask better questions before building a dashboard or query.

Power Query Python Pandas Excel
Analytics direction

I turn finance workflows into data projects.

I use SQL, Python, Power BI, and Excel to clean data, build KPIs, automate recurring reports, and create views that support faster business decisions.

SQL Power BI DAX Tableau
Skills

Tools I use to move from accounting work to analytics delivery.

My current focus is building job-ready analytics capability on top of real finance-process experience.

Advanced

Financial Analytics

Receivables, reconciliations, trend review, month-end reporting, and stakeholder summaries.

Strong

SQL

Data extraction, joins, grouping, KPI logic, customer segmentation, and validation queries.

Strong

Python

Pandas, NumPy, data cleaning, EDA, file automation, and reusable reporting scripts.

Strong

Power BI

Dashboard design, DAX measures, data modeling, KPI cards, and executive-ready reporting.

Advanced

Advanced Excel

Pivot tables, Power Query, lookup logic, templates, controls, and audit-ready spreadsheets.

Working

Tableau

Exploratory dashboards, visual summaries, filters, and quick insight views.

Strong

Data Cleaning

Validation checks, missing data handling, outlier review, and standardization.

Practical

Workflow Automation

Repeatable report generation, data checks, and process templates for recurring work.

Experience

Accounts experience that naturally leads into data analytics.

Each role strengthened the same habits data teams need: accuracy, validation, reporting discipline, and stakeholder communication.

Apr 2024 - Present
Gokuldas Sainik School, known as Gookuldas Public School, Khargone, MP

Accountant cum Data Analyst

  • Built month-end financial reporting workflows in Excel while learning to automate the same logic with SQL and Python.
  • Converted routine finance summaries into dashboard-style views to support administrative decision making.
  • Performed validation and reconciliation across financial and operational datasets with a data-quality mindset.
  • Created standardized reporting templates that improved consistency and prepared data for future analytics use.
Jun 2023 - Apr 2024
Solar Square Pvt Ltd, Mumbai

Account Receivable Analyst

  • Analyzed receivables and customer transaction datasets to identify payment patterns, exceptions, and follow-up priorities.
  • Automated recurring financial reports using advanced Excel and Power Query, building confidence in analytics workflows.
  • Conducted account reconciliation and discrepancy analysis with focus on data accuracy, root causes, and clean records.
  • Supported month-end and year-end close by preparing financial summaries that could be converted into KPI reports.
Sep 2020 - May 2023
Fototentia Diagnostics Pvt. Ltd, Indore

Accounts Manager

  • Managed invoice processing, payment tracking, vendor coordination, and records while building strong source-data discipline.
  • Prepared internal finance reports for operational review and learned how stakeholders use numbers for decisions.
  • Supported month-end and year-end closing activities, strengthening my understanding of finance reporting cycles.
  • Maintained organized financial records with accuracy checks that now support my transition into data validation and analysis.
Projects

Projects built around finance, reporting, and analytics practice.

These projects show how I am converting my accounting background into hands-on data analyst work.

Automation

Python Financial Data Automation

Automated month-end reporting with Python and Pandas, including validation, reconciliation, and formatted Excel outputs.

PythonPandasExcelFinance
BI Dashboard

SQL Sales Analytics Dashboard

Sales analytics with SQL and Power BI covering revenue trends, customer segmentation, and KPI reporting for stakeholders.

SQLPower BIDAXKPIs
EDA

Student Performance Analysis

Exploratory data analysis identifying key academic performance factors through cleaning, visualization, and actionable summaries.

PythonPandasMatplotlibNumPy
Credentials

Certifications and education.

A commerce and finance foundation supported by modern analytics credentials.

IBM x Coursera

IBM Data Analyst Professional

Data analytics methods, tools, and project-based workflows.

Meta x Coursera

Meta Data Analyst

Analytics foundations, visualization, and business insights.

Packt x Coursera

Master SQL for Data Analysis

SQL querying, transformation, and analytical reporting.

Masai x IIT Mandi

Minor in CSE and Advanced Technologies

Technology foundation for applied data work.

2022 - 2024

M.Com

Professional Accounting and Finance, Jain University, Bangalore.

2008 - 2011

BBA

Business Management, CSJM University, Kanpur.

ICAI

CA Intermediate

Institute of Chartered Accountants of India.

UP Board

12th

Higher Secondary education.

UP Board

10th

Secondary education.

Quick message

Send a pre-filled email.

This keeps the site static and reliable while still making it easy for recruiters to reach out.