Pradeep kumar

AI and Business Intelligence Consultant

MDATA FINNOVATICS • Full time

Feb 2020 - Present • 6 yrs 9 mos

I help businesses improve reporting and reduce repetitive manual work through custom Excel, VBA, Power Query and Power BI solutions. My work includes finance and sales dashboards, inventory tools, reconciliation systems, invoice automation and management reporting. I also develop Excel applications with user forms, search screens and protected workflows. I integrate AI and APIs for document processing, summaries, classification and report generation, alongside PDF automation and fillable forms. I work directly with clients to understand their requirements, develop and test solutions, and provide a practical handover.

Data Analyst & Business Intelligence Consultant

CARE HEALTH • Full time

Mar 2014 - Jan 2020 • 5 yrs 10 mos

Transformed complex datasets into validated reports, dashboards and business information for operational and management teams. Developed Excel VBA automation for recurring reporting, production tracking, work-in-progress monitoring, variance analysis, leave planning and seat utilisation. Used SQL Server for data extraction and reporting, including queries, stored procedures, functions and views. Built and maintained reporting solutions using Excel, Power BI and Tableau. Worked with business users and technology teams to translate requirements into practical solutions while maintaining data quality and reporting deadlines.

Portfolio Accountant

TCS • Full time

Sep 2011 - Feb 2014 • 2 yrs 5 mos

Worked in fund accounting, valuation, reconciliation and financial reporting, developing a strong foundation in financial data and process controls. Calculated Gross Asset Value and Net Asset Value for funds and Funds of Funds. Prepared financial working papers, reconciled profit and loss against trial balances, and investigated variances. Used Bloomberg for security information, historical prices, corporate actions and exchange rates, and Geneva for transaction processing. Maintained supporting documentation and reviewed processes to improve accuracy and consistency.