I will clean messy data and automate reports using advanced excel and power query

India

I speak Hindi, English

Data Automation and Financial Analytics Specialist

Welcome! I am a tech-driven Finance & Data Analyst on the professional CMA track. I bridge the gap between financial logic and data engineering to automate reporting and clean databases. My Expertise...
About this Gig

Is your business wasting hours handling messy spreadsheets, manual data cleaning, or unoptimized data logs? Let me automate it for you!


I am a Data Analytics Specialist with a strong background in corporate finance and advanced computer applications. I specialize in transforming chaotic, unorganized rows of data into clean, structured, and actionable business trackers. By combining Advanced Excel models with raw SQL querying, I eliminate manual work and ensure 100% data accuracy.


What I can do for you:

- Advanced Formula Design: Complex XLOOKUP, INDEX/MATCH, and dynamic arrays.

- Data Transformation: Parsing messy text and structuring data via Power Query.

- Automated Reconciliation: Designing workflows to match purchase orders and invoices.

- Custom SQL Queries: Writing optimized queries, CTEs, and relational database joins.


Perfect for tracking:

- E-commerce & Business Sales Metrics

- Corporate Budgets & Cost Variances

- Operational Overhead Logs


Please drop me a message with your raw data sample BEFORE placing an order so we can discuss your project scope!

Technology:

Excel

Google Sheets

Jupyter Notebook

Power BI

BigQuery

Analysis type:

Quantitative analysis

Descriptive analysis

Expertise:

Business Insights

Forecasting

Financial ratios

Programming language:

Python

SQL

Tools:

Microsoft Excel