Kumaraguruparan K

Kumaraguruparan K

FP&A Specialist
India
Tamil, English

About Me

Detail-oriented Finance Analyst with 8 years of overall experience, specializing in FP&A and data analysis using SQL, Power BI, and SAP Business Objects.

Experience

SENIOR SUPPORT ANALYST – BI

REDGRAPE BUSINESS SERVICES, Chennai, IN
Present

<p>Collected, transformed, and analyzed both numerical and categorical data from SAP BW data warehouse.<br>
Provided meaningful data insights through Power BI dashboards to the leadership team.<br>
Designed financial KPI reports in SAP BI tool using SQL queries.<br>
Scheduled reports for automated distribution to stakeholders.<br>
Developed complex financial models to analyze organization-wide data across UK, US, and APAC markets.<br>
Provided strategic recommendations that improved on-time payments to vendors by 21%.<br>
Built financial dashboards in Power BI using ETL methods and advanced DAX functions.<br>
Presented reports with actionable insights to top management.<br>
Decreased weekly report processing time by 25% through optimized SQL queries.<br>
Reduced data discrepancies by performing regular audits and quality checks.<br>
Managed a diverse portfolio of financial analytics projects.<br>
Ensured all deliverables met stringent data quality standards.<br>
Delivered all deliverables on time.<br>
Collaborated with cross-functional teams in Finance, Sales, Delivery, and Customer Support.<br>
Understood business requirements from cross-functional teams.<br>
Designed SQL queries to extract and analyze data for each department.</p>

SENIOR PROCESS EXPERT – FINOPS

MAERSK GSC India Pvt. Ltd., Chennai, India

<p>Designed weekly and monthly Power BI dashboards to provide real-time insights on shipment bookings and revenue and cost creation status.<br>
Performed data mining using MS SQL from various SaaS sources.<br>
Maintained data warehouse for analyzing and reporting.<br>
Monitored financial data trends, KPIs, and accuracy of key metrics.<br>
Provided strategic forecasting support using BI reports.<br>
Supported Profit and Loss management.<br>
Managed month-end reconciliations.<br>
Recorded accruals to ensure timely and accurate financial closing.<br>
Ensured compliance with accounting standards.<br>
Performed quarterly analysis on financial data trends.<br>
Highlighted findings through reports.<br>
Helped reduce unrecognized losses by 15% for each quarter.<br>
Led internal KPI calls and KPI management.<br>
Set up goals and objectives for the team.<br>
Managed monthly RICC reporting process as a Finance controller.<br>
Managed a small group of 4 people involved in revenue and cost creation for Oceania Account.<br>
Stabilized the account during automation and process changes.<br>
Created Sales Orders in SAP for export and import shipments based on contract and Incoterms.<br>
Raised bills to customers for export and import shipments.<br>
Created Purchase Orders.<br>
Checked three-way matching of P.O., G.R and I.R for processing payment to vendors.<br>
Coordinated with the AR team to review the Statement of Account.<br>
Followed up with customers on invoice issues or cancellations.<br>
Checked and cleared Vendor Invoice workflows for prompt AP clearance.<br>
Collaborated with Front office, Vendors and Customers from Europe, Asia, and Oceania.<br>
Ensured seamless transition of new process changes and existing process challenges.<br>
Tested SAP tool with the automation process using Excel VBA Macro.<br>
Followed Agile Methodologies for process stabilization.</p>

JUNIOR EXECUTIVE

NEWAGE Software & Solutions Pvt. Ltd., CHENNAI, IN

<p>Created House Bills and sent pre-alerts to the destination as part of tool testing process.<br>
Validated documents for reporting errors to management.<br>
Separated import and export documents for the shipping clearance process using data mining techniques.<br>
Forwarded reports to the onshore office in the US.<br>
Collected data using SQL on quality issues.<br>
Reported findings to the on-site development team.<br>
Provided suggestions for improvement to the on-site development team.<br>
Worked together on product testing and tool initialization process.</p>

Skills

Microsoft Excel MS SQL Python Agile Methodology Power BI Tableau SAP Business Objects Microsoft Dynamics 365 Data Visualization & Presentation Data Mining & Analysis Shipping and Logistics Finance Controllership Financial Planning and Forecasting Financial Modeling and Reporting E-commerce Data Analytics Continuous Improvement Oriented Stakeholder Management Self-motivated & Independent worker Team Leadership Problem-Solving & Strong Decision Maker Strong Interpersonal & Communication Skills Data Visualization Presentation Data Mining Analysis Financial Planning Forecasting Financial Modeling Reporting Continuous Improvement Self-motivated Independent worker Problem-Solving Decision Making Interpersonal Skills Communication Skills SAP BW DAX ETL Excel VBA Macro
Report this Profile?