Kumaraguruparan K

Kumaraguruparan K

FP&A Specialist
India
Tamil, English

نبذة عني

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.

الخبرة

SENIOR SUPPORT ANALYST – BI

REDGRAPE BUSINESS SERVICES, Chennai, IN
حتى الآن

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

SENIOR PROCESS EXPERT – FINOPS

MAERSK GSC India Pvt. Ltd., Chennai, India

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

JUNIOR EXECUTIVE

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

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

المهارات

مايكروسوفت إكسل MS SQL بايثون (لغة برمجة) منهجية أجايل باور بي آي تابلو 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
الإبلاغ عن هذا الملف الشخصي؟