Rajeswaran

Data Analyst with expertise in automation using SQL, Python, VBA, and Power Query. Specialized in MIS reporting, business analysis, supply chain and inventory management reporting, and process automation. Proficient in creating dynamic dashboards and developing automated reports to reduce manual effort and improve data accuracy.

MIS & Data Analyst at Dollar Industries Limited (2022-08 – Present)

Automated SQL, Python, VBA & Power Query for MIS reporting and data analysis

• Analyzed large datasets to generate actionable insights for business decision-making
• Developed automated MIS reports using Excel and VBA, reducing manual effort by up to 60%
• Created dynamic dashboards for sales, inventory, and supply chain tracking
• Improved data accuracy and consistency through MySQL data validation techniques
• Delivered monthly MIS reports for management, supporting strategic planning
• Generated ad-hoc reports for analysis and in-time decision making
• Collaborated with cross-functional teams to standardize reporting processes

MIS Executive at GG GARMENTS (2020-11 – 2022-07)

Power Query, Advanced Excel & VBA for e-commerce and inventory management

• E-Commerce portal management, produced daily MIS reports highlighting key business trends and performance metrics
• Managed end-to-end data tracking for production, inventory, and online sales channels
• Built Excel dashboards for management reporting and operational monitoring
• Maintained large stock datasets and ensured stock data integrity through regular validation
• Supported production and planning departments with customized reports and analysis

Quantity Surveyor at NCC Limited (2015-03 – 2019-02)

MIS reporting using Power Query, Advanced Excel & VBA for project cost analysis and financial management

• Managed project cost analysis, budgeting, and financial reporting
• Evaluated completed work and ensured cost control within allocated budgets
• Prepared contract documentation and monitored financial performance
• Conducted ROI analysis and cost comparisons for project optimization

Budget Analyst at INDIAPROPERTY.COM (2014-07 – 2015-02)

MIS reporting using Advanced Excel for budget planning and financial analysis

• Budget Planning and Customization for Clients
• Performed budget formulation work involving review and preparation of budget estimates and financial plans

Quantity Surveyor at GMS ELEGANT BUILDERS (2013-06 – 2014-06)

MIS reporting using Advanced Excel for project billing and budget management

• Billing and payment Process Management and Assigned subcontractors tasks, recording activities, progress and deliverables
• Monitored changes to project design or activities and adjusted budgets to incorporate new expense and revenue

Bachelor of Engineering in Civil Engineering with concentration in Automation Design Calculation Programming in Excel with VBA – Erode Builder Educational Trust's Group of Institution (2009-01 – 2013-12)