Lalit Malviya profile photo 1 on Tal

Lalit Malviya

MIS & Reporting Professional | Advanced Excel | Power BI & SQL (Learning) | Data Analytics

Pali

< 1 year of work experience

TEXTILE WORLD
Nov 20244 mosFeb 2025

Pali, Rajasthan, India

• Maintained daily operational and accounting records using Excel. • Prepared MIS reports related to sales, purchases, stock, and outstanding. • Coordinated with internal teams for data collection and reporting. • Tracked inventory movement and updated records on a regular basis. • Assisted in basic accounting tasks including billing, reconciliation, and summaries. • Used Excel functions, Pivot Tables, and reports for decision support.
TEXTILE WORLD
Nov 20244 mosFeb 2025

Built and maintained MIS reports using Advanced Excel with Pivot Tables, VLOOKUP, INDEX-MATCH, and SUMIF formulas for sales, purchase, and stock analysis. Performed data cleaning and transformation — removed duplicates, standardized column formats, and handled missing values to ensure reporting accuracy. Designed formatted Excel dashboards with dynamic charts and conditional formatting to visualize sales and inventory trends for management review. Created bank reconciliation sheets and tracked outstanding balances across vendors and customers, reducing manual errors significantly. Assisted in core accounting tasks including billing, purchase entries, and monthly financial summaries. Coordinated with internal teams for timely data collection and consolidated cross-department reporting. Practiced connecting Power BI to Excel datasets to build visual reports on sales performance and inventory stock levels. Exploring DAX calculated columns and measures for KPI tracking; applying SQL SELECT, WHERE, GROUP BY, and JOIN commands to filter and summarize business data.

Education

Jai Narain Vyas University (JNVU), Jodhpur

Bachelor of Arts, Political Economy

Jai Narain Vyas University (JNVU), Jodhpur

20183 yrs2021

Join Lalit and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Lalit Malviya on Tal

Headline

MIS & Reporting Professional | Advanced Excel | Power BI & SQL (Learning) | Data Analytics

About

I am currently working in an Accounts & MIS role in the textile sector, where I handle day-to-day accounting support along with MIS reporting and data management. My work involves maintaining sales and purchase records, bank reconciliation, tracking outstanding balances, and preparing basic MIS reports using Excel. Over time, I have developed a strong interest in working with data and reports. I regularly use Excel for data cleaning, reconciliation, summaries, and reporting to support business decisions. Along with my job, I am actively upgrading my skills in Excel, SQL, and Power BI to move towards more data-oriented roles such as MIS Executive and Data Analyst. I come from a practical working background and believe in learning by doing. I am comfortable working with raw data, understanding business processes, and converting numbers into meaningful reports. My focus is on building strong fundamentals, gaining real exposure, and growing step by step in reporting and analytics roles. I am open to opportunities where I can learn, contribute, and grow in MIS, reporting, or data-focused profiles, especially in roles that offer hands-on exposure and long-term learning.

Location

Pali

Work experience

Mis Executive And Financial Accounting at TEXTILE WORLD, Nov 2024 - Feb 2025 · 4 mos, Pali, Rajasthan, India, • Maintained daily operational and accounting records using Excel. • Prepared MIS reports related to sales, purchases, stock, and outstanding. • Coordinated with internal teams for data collection and reporting. • Tracked inventory movement and updated records on a regular basis. • Assisted in basic accounting tasks including billing, reconciliation, and summaries. • Used Excel functions, Pivot Tables, and reports for decision support.

Management Information System Executive at TEXTILE WORLD, Nov 2024 - Feb 2025 · 4 mos, Built and maintained MIS reports using Advanced Excel with Pivot Tables, VLOOKUP, INDEX-MATCH, and SUMIF formulas for sales, purchase, and stock analysis. Performed data cleaning and transformation — removed duplicates, standardized column formats, and handled missing values to ensure reporting accuracy. Designed formatted Excel dashboards with dynamic charts and conditional formatting to visualize sales and inventory trends for management review. Created bank reconciliation sheets and tracked outstanding balances across vendors and customers, reducing manual errors significantly. Assisted in core accounting tasks including billing, purchase entries, and monthly financial summaries. Coordinated with internal teams for timely data collection and consolidated cross-department reporting. Practiced connecting Power BI to Excel datasets to build visual reports on sales performance and inventory stock levels. Exploring DAX calculated columns and measures for KPI tracking; applying SQL SELECT, WHERE, GROUP BY, and JOIN commands to filter and summarize business data.

Education

Bachelor of Arts, Political Economy, Jai Narain Vyas University (JNVU), Jodhpur

Lalit Malviya - Mis Executive And Financial Accounting in Pali | Tal